Question

In: Finance

Good Morning Food, Inc. is using the profitability index (PI) when evaluating projects. You have to...

Good Morning Food, Inc. is using the profitability index (PI) when evaluating projects. You have to find the PI for the company’s project, assuming the company’s cost of capital is 9.92 percent. The initial outlay for the project is $368,538. The project will produce the following end-of-the-year after-tax cash inflows of

Year 1: $155,548

Year 2: $144,874

Year 3: $15,293

Year 4: $374,481

Round the answer to two decimal places.

How do I do this in excel?

Solutions

Expert Solution

Computation of profitability index
year Cash flow PVIF @ 9.92% Present value
1 155,548             0.9098 $                   141,510.19
2 144,874             0.8276 $                   119,904.92
3 15,293             0.7530 $                     11,514.96
4 374,481             0.6850 $                   256,520.99
a Present value of cash flow $                   529,451.06
b PV of outflow 368,538
c=a/b Profitability index                                  1.44
Ans =                                  1.44

Related Solutions

Good Morning Food, Inc. is using the profitability index (PI) when evaluating projects. You have to...
Good Morning Food, Inc. is using the profitability index (PI) when evaluating projects. You have to find the PI for the company’s project, assuming the company’s cost of capital is 6.11 percent. The initial outlay for the project is $498,112. The project will produce the following end-of-the-year after-tax cash inflows of Year 1: $148,444 Year 2: $92,435 Year 3: $171,330 Year 4: $436,132
You have to choose between two options using   PI (profitability index) as your project evaluation tool....
You have to choose between two options using   PI (profitability index) as your project evaluation tool. The company use a 15% discount rate The project “A” needs $25,000 for initial investment and will produce in 3 years $18,000 per year. The project “B” needs $50,000 for initial investment and will produce in 3 years $35,000 per year
What is the projects profitability index?
What is the projects profitability index?
Which of the following statement regarding Profitability Index (PI) is correct? you should accept a project...
Which of the following statement regarding Profitability Index (PI) is correct? you should accept a project if PI is greater than 0 you should use PI to compare and select mutually exclusive projects you should accept a project if PI is greater than 1
Calculate the profitability index (PI) for the following cash flows if the relevant discount rate is...
Calculate the profitability index (PI) for the following cash flows if the relevant discount rate is 10% Year Cash Flow 0 -15,300 1 9,400 2 7,600 3 4,300
. For each project, calculate the NPV, IRR, profitability index (PI) and the payback period. For...
. For each project, calculate the NPV, IRR, profitability index (PI) and the payback period. For each capital budgeting decision tool, indicate if the project should be accepted or rejected, assuming that each project is independent of the others. Important Note: The venture capital folks have a firm maximum payback period of four years.          Project A= Required rate of Return= 16.30% Project B= R= 12.50% Project C= R= 15.35% Project D= R= 17.25%      Expected cash flows for the four...
Deep Waters, Inc. is using the internal rate of return (IRR) when evaluating projects. Find the...
Deep Waters, Inc. is using the internal rate of return (IRR) when evaluating projects. Find the IRR for the company’s project. The initial outlay for the project is $397,200. The project will produce the following after-tax cash inflows of Round two decimal points Year 1: 144,400 Year 2: 89,500 Year 3: 189,600 Year 4: 172,000
Tall Trees, Inc. is using the modified internal rate of return (MIRR) when evaluating projects. The...
Tall Trees, Inc. is using the modified internal rate of return (MIRR) when evaluating projects. The company is able to reinvest cash flows received from the project at an annual rate of 12.04 percent. What is the MIRR of a project if the initial costs are $1,680,000 and the project life is estimated as 7 years? The project will produce the same after-tax cash inflows of 474,700 per year at the end of the year. Round the answer to two...
Tall Trees, Inc. is using the modified internal rate of return (MIRR) when evaluating projects. The...
Tall Trees, Inc. is using the modified internal rate of return (MIRR) when evaluating projects. The company is able to reinvest cash flows received from the project at an annual rate of 13.42 percent. What is the MIRR of a project if the initial costs are $1,476,100 and the project life is estimated at 9 years? The project will produce the same after-tax cash inflows of $627,700 per year at the end of the year. Round the answer to two...
Deep Waters, Inc. is using the internal rate of return (IRR) when evaluating projects. Find the...
Deep Waters, Inc. is using the internal rate of return (IRR) when evaluating projects. Find the IRR for the company's project. The initial outlay for the project is $468,900. The project will produce the following after-tax inflows of Year 1: 176,300 Year 2: 100,000 Year 3: 128,300 Year 4: 123,700 Round the answer to two decimal places in percentage form.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT