Question

DataPoint Engineering is considering the purchase of a new piece of equipment for $350,000. It has an eight-year midpoint of its asset depreciation range (ADR). It will require an additional initial investment of $170,000 in nondepreciable working capital. $62,000 of this investment will be recovered after the sixth year and will provide additional cash flow for that year. Income before depreciation and taxes for the next six are shown in the following table. Use Table 12–11, Table 12-12. Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods. Year Amount 1 $218,000 2 182,000 3 162,000 157,000 5 106,000 6 126,000 The tax rate is 25 percent. The cost of capital must be computed based on the following: Cost (aftertax) Weights Kd 12.30% 30% 10 Debt Preferred stock Common equity (retained earnings) Ap 15.40 20.00 60 a. Determine the annual depreciation schedule. (Do not round intermediate calculations. Round your depreciation base and annual depreciation answers to the nearest whole dollar. Round your percentage depreciation answers to 3 decimal places.) Year 1 Answer is complete and correct. Depreciation Percentage | Annual Base Depreciation Depreciation $ 350,000 0.200 $ 70,000 350,000 0.320 112,000 350,000 0.1921 67,200 350,000 0.115 40,250 350,000 0.115 ) 40,250L 350,000 0.058 20,300 $ 350,000 3 4 5 6 b. Determine the annual cash flow for each year. Be sure to include the recovered working capital in Year 6. (Do not round intermediate calculations and round your answers to 2 decimal places.) Answer is complete and correct. Cash Year Flow 1 $ 181,000 2 164,500 138,300 127,813 89,563 6 161,575 c. Determine the weighted average cost of capital. (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) Answer is complete and correct. Weighted average cost of capital d-1. Determine the net present value. (Use the WACC from part c rounded to 2 decimal places as a percent as the cost of capital (e.g., 12.34%). Do not round any other intermediate calculations. Round your answer to 2 decimal places.) X Answer is complete but not Net presents 10,314.00 value

Answer 1

Α $ $ $ $ $ $ $ 13 Working capital 14 Working capital recovery 15 Year 1 EBDT 16 Year 2 EBDT 17 Year 3 EBDT 18 Year 4 EBDT 19 Year 5 EBDT 20 Year 6 EBDT 21 Tax rate 22 Debt aftertax cost 23 Debt weight 24 Preferred stock cost 25 Preferred stock weight 26 Common equity cost 27 Common equity weight 28 MACRS 5-year rates: 29 Year 1 30 Year 2 31 Year 3 32 Year 4 33 Year 5 34 Year 6 170,000 62,000 218,000 182,000 162,000 157,000 106,000 126,000 25% 12.30% 30% 15.40% 10% 20.00% 60% .200 .320 .192 .115 .115 .058

B48 =NPV(B46,B44:G44)-B12-B13 B A 36 37 EBDT 38 Depreciation 39 EBT 40 Taxes 41 EAT 42 Depreciation 43 Net working capital recovery 44 Cash flow 45 46 WACC 47 48 NPV Year 1 $218,000 $70,000 $148,000 $37,000 $111,000 $70,000 Year 2 $182,000 $112,000 $70,000 $17,500 $52,500 $112,000 D E F G Year 3 Year 4 Year 5 Year 6 $162,000 $157,000 $106,000 $126,000 $67,200 $40,250 $40,250 $20,300 $94,800 $116,750 $65,750 $105,700 $23,700 $29,188 $16,438| $26,425 $71,100 $87,563 $49,313 $79,275 $67,200 $40,250 $40,250 $20,300 $62,000 $138,300 $127,813 $89,563 $161,575 $181,000|_ $164,500 17.23% =ROUND(B22*B23+B24*B25+B26*B27,4) $ 10,313.99 49 Should the equipment be 50 purchased? Yes

Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Depreciation Base $ 350,000 $ 350,000 $ 350,000 $ 350,000 $ 350,000 $ 350,000 Percentage Annual Depreciation Depreciation 0.200 $ 70,000 0.320 $ 112,000 0.192 $ 67,200 0.115 $ 40,250 0.115 $ 40,250 0.058 $ 20,300 b) Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 $ $ $ $ $ $ 181,000 164,500 138,300 127,813 89,563 161,575 17.23% d-1) $ 10,313.99 d-2) | Yes

*Please rate thumbs up