optimistic estimates of the annual cash inflows associated with each project. These estimates are shown in the following table. Project A $12,100 Project B $12,100 Initial investment (CF) Outcome Pessimistic Most likely Optimistic Annual cash inflows (CF) $830 1,670 2,400 $1,530 1,670 1,730 . Determine the range of annual cash inflows for each of the two projects. . Assume that the firm's cost of capital is 9.5% and that both projects have 17-year lives. Construct a table showing the NPVS for each project for each of the possible outo each project. . The range of annual cash inflows for project A is S (Round to the nearest dollar) CHI

Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 -$ 243,567 -$ 15,530 1 27,200 55,000 60,000 413,000 234 5,173 8,261 13,237 8,729 Whichever project you choose, if any, you require a 6 percent return on your investment. a. What is the payback period for Project A? Payback period

I need help finding the Profitability index for each project (D) using Excel

Prime Paints is in the process of evaluating two mutually exclusive additions to its processing capacity. The​ firm's financial analysts have developed​ pessimistic, most​ likely, and optimistic estimates of the annual cash inflows associated with each project. These estimates are shown in the following table.     Project A Project B Initial investment ​(CF0​) ​$12,900 ​$12,900 Outcome Annual cash inflows ​(CF ​) Pessimistic ​$830 ​$1,540 Most likely 1,690 1,690 Optimistic 2,490 1,790   a. Determine the range of annual cash inflows for each of the two projects. b. Assume that the​ firm's cost of capital is 9.1%and that both projects have 18​-year lives. Construct a table showing the NPVs for each project for each of the possible outcomes. Include the range of NPVs for each project. c. Do parts ​(a​) and (b​) provide consistent views of the two​ projects? Explain.

Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) -$425,000 44,000 62,000 79,000 540,000 -$40,000 20,400 13,300 18,600 15,400 2 4 The required return on these investments is 10 percent. a. What is the payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) b. What is the NPV for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) c. What is the IRR for each project? (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) d. What is the profitability index for each project? (Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.) e. Based on your answers in (a) through (d), which project will you finally choose? a. Project A Project B b. Project A Project B c. Project A years years % Project B % d. Project A…

Consider the following two mutually exclusive projects: Year Cash Flow (X) Cash Flow (Y) 0 -$ 15,900 -$ 15,900 1 6,710 7,290 2 7,290 7,730 3 4,810 3,630 a. What is the IRR of Project X? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decim b. What is the IRR of Project Y? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decim c. What is the crossover rate for these two projects? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decim a. IRR b. IRR % % c. Crossover rate %

ok ht ences A firm evaluates all of its projects by applying the IRR rule. A project under consideration has the following cash flows: Year 0 1 2 3 Cash Flow IRR -$27,400 11,400 14,400 10,400 If the required return is 16 percent, what is the IRR for this project? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) % Should the firm accept the project? Yes O No

Solve Part B of the question

A project has the following cash flows.  Year 0 1 2 3 4 Amount -200 950 -850 75 12 You are a financial analyst, and note the sequence of cash flows.   What is the internal rate of return for this project?   Round your answer to two decimal places.