Question

6. The payback period The payback method helps firms establish and identify a maximum acceptable payback period that helps in their capital budgeting decisions. Consider the case of Cute Camel Woodcraft Company: Cute Camel Woodcraft Company is a small firm, and several of its managers are worried about how soon the firm will be able to recover its initial investment from Project Delta's expected future cash flows. To answer this question, Cute Camel's CFO has asked that you compute the project's payback period using the following expected net cash flows and assuming that the cash flows are received evenly throughout each year. Complete the following table and compute the project's conventional payback period. For full credit, complete the entire table. (Note: Round the conventional payback period to two decimal places. If your answer is negative, be sure to use a minus sign in your answer.)
Answer in full please

Answer 1

D 1 2 3 B Year 0 (5,000,000) (5,000,000) C Year 1 2,000,000 (3,000,000) Expected cash flow Cumulative cash flow Year 2 4,250,000 1,250,000 Year 3 1,750,000 3,000,000 5 Conventional payback period 1.7059 years 9 Expected cash flow 10 Discounted Cash flow 11 Cumulative cash flow Year 0 (5,000,000) (5,000,000) (5,000,000) Year 1 2,000,000 1,869,159 (3,130,841) Year 2 4,250,000 3,712,115 581,273 Year 3 1,750,000 1,428,521 2,009,795 12 13 Conventional payback period 1.8434 years 14 15 Given discounted payback takes time value of money into consideration, that is a superior 16 approach to regular payback 17 18 19 Discounted payback fails to recognize value 2,009,795 20

Year 0 Year 1 Year 2 Year 3 2 Expected cash flow 3 Cumulative cash flow -5000000 =B2 2000000 =B3+C2 4250000 =C3+D2 1750000 =D3+E2 5 Conventional payback period =1+(-C3/D2) years 6 7 Year o Year 1 9 Expected cash flow =B2 =C2 10 Discounted Cash flow =B9/(1+7%)^0 =C9/(1+7%)^1 11 Cumulative cash flow =B10 =B11+C10 12 13 Conventional payback period =1+-C11/D10) years 14 15 16 Given discounted payback takes time value of money into consideration, that is a superior approach to regular payback Year 2 =D2 =D9/(1+7%)^2 =C11+D10 Year 3 =E2 =E9/(1+7%)^3 =D11+E10 17 18 19 Discounted payback fails to recognize value 20 =E11