Question

In: Finance

1. What's the NPV of the following cash flows with a 8% WACC? 2. What's the...

1. What's the NPV of the following cash flows with a 8% WACC?

2. What's the payback period of the following cash flows with a 8% WACC?

3. What's the discounted payback period of the following cash flows with a 8% WACC?

4. What's the profitability index of the following cash flows with a 8% WACC?

Year 0 = 100,000

Year 1 = 10,000

Year 2 = 50,000

Year 3 = 45,000

Year 4 = 25,000

Solutions

Expert Solution

1. Calculation of NPV

NPV = Present value of cash Inflow - Present value of Cash Outflow

Year Cash Flow PVF @8% PV of cash Flow
0 -100000 1 -100000
1 10000 0.926 9260
2 50000 0.857 42850
3 45000 0.794 35730
4 25000 0.735 18375
NPV 6215

2. Calculation of Payback period

Initial Investment = 100000

Year Cash Inflow Cumulative Cash Inflow
1 10000 10000
2 50000 60000
3 45000 105000
4 25000 130000

Payback period = Year before Full recovery + Unrecovered cost / Cash Flow during the year

= 2 years + 40000/45000

= 2.89 years

Unrecovered Cost = Initial Investment - Cumulative cash flow at the end of 2nd year.

3. Calcuation of Discounted Payback period

Year Cash Flow Discounted Cash Flow (refer NPV solution in point 1) Cumulative Discounted Cash Flow
0 -100000 -100000 -100000
1 10000 9260 -90740
2 50000 42850 -47890
3 45000 35730 -12160
4 25000 18375 6214

Discounted Payback period = 3 years + (12160 / 18375)

= 3.66 years

4. Profitability Index

= 1 + Net Present value (NPV) / Initial Investment

= 1 + 6215 / 100000

= 1.062


Related Solutions

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
Calculate the NPV given the following cash​ flows YEAR   CASH FLOWS 0 -60,000 1 25,000 2...
Calculate the NPV given the following cash​ flows YEAR   CASH FLOWS 0 -60,000 1 25,000 2 25,000 3 15,000 4 15,000 5 10,000 6   10,000 if the appropriate required rate of return is 8 percent. Should the project be​ accepted? What is the​ project's NPV​?
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
Calculate NPV for the following stream of cash flows: Year 1 is an outflow of $200...
Calculate NPV for the following stream of cash flows: Year 1 is an outflow of $200 for research; Years 2, 3 and 4 have a cash inflow each year of $100. The appropriate discount rate for valuation is 10%. NPV is
1. Laketown Enterprises is considering a project that has the following cash flows. It’s WACC is...
1. Laketown Enterprises is considering a project that has the following cash flows. It’s WACC is 10%. Year 0, 1, 2, and 3 Cash flows are $950, $500, $400, and $300, respectively. a. What is the project’s payback period? b. What is the project’s NPV? c. What is the project’s IRR? d. What is the project’s discounted payback period? 2. Cole Trucking, the company you work for, is considering a new project whose data are shown below. What is the...
The NPV of a series of cash flows is the following: At a 5% required rate...
The NPV of a series of cash flows is the following: At a 5% required rate of return, the NPV is $41,728 At a 10% required rate of return, the NPV is $24,708 At a 15% required rate of return, the NPV is $9,940 At a 20% required rate of return, the NPV is -$2,968 (note the negative sign) The IRR for the series of cash flows is in which range: Multiple Choice 0% to 5% Between 5% and 10%...
A. What is the NPV of the following cash flows if the required rate of return...
A. What is the NPV of the following cash flows if the required rate of return is 0.05? Year 0 1 2 3 4 CF -13868 2129 2503 694 3244    Enter the answer with 2 decimals (e.g. 1000.23). B. Winnebagel Corp. currently sells 39298 motor homes per year at $59840 each, and 17359 luxury motor coaches per year at $116566 each. The company wants to introduce a new portable camper to fill out its product line; it hopes to...
A project has the following cash flows. This project is of average risk and the WACC...
A project has the following cash flows. This project is of average risk and the WACC is 0.1. Find the Net Present Value. Round your answer to two decimal places. Year 0 Year 1 Year 2 Year 3 Cash Flow -$91 $50 $40 $7
NPV Your division is considering two projects with the following cash flows (in millions): 0 1...
NPV Your division is considering two projects with the following cash flows (in millions): 0 1 2 3 Project A -$29 $15 $13 $3 Project B -$16 $8 $3 $6 What are the projects' NPVs assuming the WACC is 5%? Round your answer to two decimal places. Do not round your intermediate calculations. Enter your answer in millions. For example, an answer of $10,550,000 should be entered as 10.55. Negative value should be indicated by a minus sign. Project A    $   million...
NPV Your division is considering two projects with the following cash flows (in millions): 0   1...
NPV Your division is considering two projects with the following cash flows (in millions): 0   1 2 3 Project A -$19 $8 $15 $17 Project B -$17 $11 $8 $6 What are the projects' NPVs assuming the WACC is 5%? Round your answer to two decimal places. Do not round your intermediate calculations. Enter your answer in millions. For example, an answer of $10,550,000 should be entered as 10.55. Negative value should be indicated by a minus sign. Project A...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT