Question

7. The payback period Aa Aa E 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 Omega'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. Year 2 Year 3 Year o -6,000,000 Year 1 $2,400,000 $5,100,000 $2,100,000 Expected cash flow Cumulative cash flow Conventional payback period:

Answer 1

E 1 2 Expected cash flow 3 Cumulative cash flow 4 5 Conventional payback period Year 0 (6,000,000) (6,000,000) c ID Year 1 Year 2 2,400,000 5,100,000 (3,600,000) 1,500,000 Year 3 2,100,000 3,600,000 1.7059 years Year 0 Year 1 Year 2 Year 3 9 Expected cash flow (6,000,000) 2,400,000 5,100,000 2,100,000 10 Discounted Cash flow (6,000,000) 2,201,835 4,292,568 1,621,585 11 Cumulative cash flow (6,000,000) (3,798,165) 494,403 2,115,988 12 13 Conventional payback period 1.8848 years 14 15 Given discounted payback takes time value of money into consideration, that is a superior approach to regular payback 18 19 Discounted payback fails to recognize value 20 2,115,988 21

Year 0 Year 1 Year 2 Year 3 -6000000 =B2 2400000 =B3+C2 5100000 =C3+D2 2100000 =D3+E2 2 Expected cash flow 3 Cumulative cash flow 4 5 Conventional payback period =1+(-C3/D2) years ooo 9 Expected cash flow 10 Discounted Cash flow 11 Cumulative cash flow Year o =B2 =B9/(1+9%)^0 =B10 Year 1 =C2 =C9/(1+9%)^1 =B11+C10 Year 2 =D2 =D9/(1+9%)^2 =C11+D10 Year 3 =E2 =E9/(1+9%)^3 =D11+E10 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 17 18 19 Discounted payback fails to recognize value 20 =E11