Question

In: Finance

Use the following cash flows to calculate the NPV, IRR, PI. The firm's WACC is 6%....

Use the following cash flows to calculate the NPV, IRR, PI. The firm's WACC is 6%. Y0 = ($1,500), Y1= $600, Y2 = $700, Y3 = $500. Determine which statement is true.

a) NPV = 108.84; IRR = 9.99%; PI = 1.07

b) NPV = 108.84; IRR = 10.47%; PI = 1.07

c) NPV = 108.84; IRR = 9.99%; PI = 0.0726

d) NPV = 300; IRR = 9.99%; PI = 1.20

Please Explain

Solutions

Expert Solution

a) NPV = 108.84; IRR = 9.99%; PI = 1.07

Working:

NPV $ 108.84
IRR 9.99%
PI 1.07
working:
a.
Year Cash flow Discount factor@6% Pesent Value
1 $         600 0.943 $          566.04
2 $         700 0.890 $          623.00
3 $ 500 0.840 $          419.81
Total $       1,608.84
Less:Costs of Project $       1,500.00
Net Present Value $          108.84
b. PI (Profitability Index) = $ 1,608.84 / $ 1,500.00
= 1.07
c. At 10%
Year Cash flow Discount factor@10% Pesent Value
1 $         600 0.909 $          545.45
2 $         700 0.826 $          578.51
3 $         500 0.751 $          375.66
Total $       1,499.62
Less:Costs of Project $       1,500.00
Net Present Value $             -0.38
IRR = 6%+(10%-6%)*(108.84/(108.84+0.38))
= 9.99%
IRR is the rate at which NPV is zero.

Related Solutions

What is NPV, IRR, PI, MIRR of a project with the following cash flows if the...
What is NPV, IRR, PI, MIRR of a project with the following cash flows if the discount rate is 14 percent? Year CF 0 -18,000    1 5000 2 7500 3 8400 4 2100 Also upload your excel files showing your work.
These are the cash flows for two projects. Calculate the NPV and IRR for both. Then...
These are the cash flows for two projects. Calculate the NPV and IRR for both. Then select the best project according to the NPV measure. Use a WACC of 10% for both projects. The investments are 7 for project 1, and 8 for project 2. Cash flows for project 1 year 1 2 3 4 cash 4 6 2 4 Cash flows for project 2 year 1 2 3 4 cash 3 2 7 4 Calculate the NPV for project...
6 You have the following cash flows: FIND the IRR, NPV (using 8 %), and the...
6 You have the following cash flows: FIND the IRR, NPV (using 8 %), and the Profitability Index (Bang for your buck) T0 = -1250 IRR = _______________%_ T1 = 350 NPV = __$______________ T2 = 450 PI = __$______________ T3 = 450 T4 = 550
Assume the following CFs, what is the PV, the NPV, and the IRR? Use the WACC...
Assume the following CFs, what is the PV, the NPV, and the IRR? Use the WACC as your required return. What is the most you should pay for the set of cash flows and earn your WACC? WACC is 11.55%. Do not use excel. Year 0 1 2 3 4 5 6 7 Investment -200,000 OCF 50,000 60,000 40,000 70,000 15,000 0.00 -10,000 Terminal CF 78,000
Please calculate the payback period, IRR, MIRR, NPV, and PI for the following two mutually exclusive...
Please calculate the payback period, IRR, MIRR, NPV, and PI for the following two mutually exclusive projects. The required rate of return is 15% and the target payback is 4 years. Explain which project is preferable under each of the four capital budgeting methods mentioned above: Table 1 Cash flows for two mutually exclusive projects Year Investment A Investment B 0 -$5,000,000 -5,000,000 1 $1,500,000 $1,250,000 2 $1,500,000 $1,250,000 3 $1,500,000 $1,250,000 4 $1,500,000 $1,250,000 5 $1,500,000 $1,250,000 6 $1,500,000...
Please calculate the payback period, IRR, MIRR, NPV, and PI for the following two mutually exclusive...
Please calculate the payback period, IRR, MIRR, NPV, and PI for the following two mutually exclusive projects. The required rate of return is 15% and the target payback is 4 years. Explain which project is preferable under each of the four capital budgeting methods mentioned above: Table 1 Cash flows for two mutually exclusive projects Year Investment A Investment B 0 -$5,000,000 -5,000,000 1 $1,500,000 $1,250,000 2 $1,500,000 $1,250,000 3 $1,500,000 $1,250,000 4 $1,500,000 $1,250,000 5 $1,500,000 $1,250,000 6 $1,500,000...
Build a case on any company’s new projects calculate the NPV , IRR , and PI...
Build a case on any company’s new projects calculate the NPV , IRR , and PI and say if it’s a good project or not
. 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...
NPV,​ PI, and IRR calculations​) You are considering a project with an initial cash outlay of...
NPV,​ PI, and IRR calculations​) You are considering a project with an initial cash outlay of ​$70,000 and expected free cash flows of ​$28,000 at the end of each year for 6 years. The required rate of return for this project is 7 percent. a. What is the​ project's payback​ period? b. What is the​ project's NPV​? c. What is the​ project's PI​? d. What is the​ project's IRR​?
For each project, calculate the NPV, IRR, profitability index (PI) and the payback period. For each...
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. Risk free rate = 1.10%, MRP = 9.5%, Required return = 14.40% Yes excel is fine Expected cash flows for the four potential projects that Avalon is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT