Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me figure out what I am doing wrong. DataPoint Engineering is considering the purchase of a new piece of equipment for $260,000. It

Please help me figure out what I am doing wrong.

image text in transcribedimage text in transcribedimage text in transcribed

DataPoint Engineering is considering the purchase of a new piece of equipment for $260,000. It has an eight-year midpoint of its asset depreciation range (ADR). It will require an additional initial investment of $160,000 in nondepreciable working capital. $40,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 1 2 3 4 5 6 Amount $191,000 164,000 134,000 119,000 97,000 87,000 The tax rate is 25 percent. The cost of capital must be computed based on the following: Debt Preferred stock Common equity (retained earnings) Kd ke Cost (aftertax) 5.80% 11.60 16.00 Weights 30% 10 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.) Answer is complete and correct. Year 1 2 3 Depreciation Base s 260,000 260,000 260,000 260,000 260,000 260,000 Percentage Annual Depreciation Depreciation 0.200$ 52,000 0.320 83,200 0.192 49,920 0.115 29,900 0.115 29,900 0.058 15,080 $ 260,000 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 but not entirely correct. Year 1 2 3 Cash Flow $ 142,350 X 135,720 104,572 X 87,815 73,515 X 221,828 4 5 6 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 but not entirely correct. Weighted average cost of capital 12.21 X % d-1. Determine the net present value. (Use the WACC from part crounded 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.) Answer is complete but not entirely correct. Net present value $ 96,511.89 d-2. Should DataPoint purchase the new equipment? Yes No DataPoint Engineering is considering the purchase of a new piece of equipment for $260,000. It has an eight-year midpoint of its asset depreciation range (ADR). It will require an additional initial investment of $160,000 in nondepreciable working capital. $40,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 1 2 3 4 5 6 Amount $191,000 164,000 134,000 119,000 97,000 87,000 The tax rate is 25 percent. The cost of capital must be computed based on the following: Debt Preferred stock Common equity (retained earnings) Kd ke Cost (aftertax) 5.80% 11.60 16.00 Weights 30% 10 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.) Answer is complete and correct. Year 1 2 3 Depreciation Base s 260,000 260,000 260,000 260,000 260,000 260,000 Percentage Annual Depreciation Depreciation 0.200$ 52,000 0.320 83,200 0.192 49,920 0.115 29,900 0.115 29,900 0.058 15,080 $ 260,000 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 but not entirely correct. Year 1 2 3 Cash Flow $ 142,350 X 135,720 104,572 X 87,815 73,515 X 221,828 4 5 6 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 but not entirely correct. Weighted average cost of capital 12.21 X % d-1. Determine the net present value. (Use the WACC from part crounded 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.) Answer is complete but not entirely correct. Net present value $ 96,511.89 d-2. Should DataPoint purchase the new equipment? Yes No

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Real Estate Finance

Authors: Sherry Shindler Price

1st Edition

0934772185, 9780934772181

More Books

Students also viewed these Finance questions

Question

3. Provide time for independent and extended projects.

Answered: 1 week ago