DataPoint Engineering is considering the purchase of a new piece of equipment fo
ID: 2619420 • Letter: D
Question
DataPoint Engineering is considering the purchase of a new piece of equipment for $410,000. It has an eight-year midpoint of its asset depreciation range (ADR). It will require an additional initial investment of $230,000 in nondepreciable working capital. Seventy-seven thousand dollars 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)$ 236,000 2)194,000 3)164,000 4)149,000 5)112,000 6)102,000
Side note: Cash flow for the 6 years are as followed (and have been checked for accuracy)
Year 1: $189,800 Year 2: $175,160 Year 3: $138,416 Year 4: $118,445 Year 5: $92.545 Year 6: $155,534
Weighted Average Cost of Capital: 15.06% (also checked for accuracy)
Question 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.
Appendix B Present value of $1,PVF PV=FV Percent Period 4 Appendlx B (concluded) Percent Period 50% 0.783 0.769 0.756 0.743 0.731 0.718 0.706 0.694 0.640 0.592 0.549 0.510 0.444 0.693 0.675 0.658 0.641 0.624 0.609 0.593 0.579 0512 0.455 0.406 0.364 0.296 0.480 0.456 0.432 0.410 0.390 0.370 0.352 0.335 0.262 0.207 0.165 0.133 0.088 0.425 0.400 0.376 0.354 0.333 0.314 0.296 0.279 0.210 0.159 0.122 0.095 0.059 0.261 0.237 0.215 0.195 0.178 0.162 0.148 0.135 0.086 0.056 0.037 0.025 0.012 0.160 0.140 0.123 0.108 0.095 0.084 0.074 0.065 0.035 0.020 0.011 0.006 0.002 0.125 0.108 0.093 0.080 0.069 0.060 0.052 0.045 0.023 0.012 0.006 0.003 0.001 0.098 0.083 0.070 0.060 0.051 0.043 0.037 0.031 0.014 0.007 0.003 0.002 0 0.087 0.073 0.061 0.051 0.043 0.037 0.031 0.026 0.012 0.005 0.002 0.001 0 0.047 0.038 0.030 0.024 0.020 0.016 0.013 0.010 0.004 0.001 0.001 0 0.026 0.020 0.015 0.012 0.009 0.007 0.005 0.004 0.001 0Explanation / Answer
An 8-year midpoint of ADR leads to 5 year MACRS epreciation
Table showing depreciation
Statement showing NPV
In absence of information it is assumed that balance of WC will not be recovered. Alternatively it can be assumed that it will recover in year 7, In that case NPV will be as under
Year Opening balance Depreciation rates Depreciation410000* Depreciation rates Closing balance 1 410000 20% 82000 328000 2 328000 32% 131200 196800 3 196800 19.20% 78720 118080 4 118080 11.50% 47150 70930 5 70930 11.50% 47150 23780 6 23780 5.80% 23780 0
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.