Question: Need to know how you are calculating the NPV, everything else that I have is correct, I even had it as 63,798.68 nothing is correct,


Need to know how you are calculating the NPV, everything else that I have is correct, I even had it as 63,798.68 nothing is correct, please help!
DataPoint Engineering is considering the purchase of a new piece of equipment for $360,000. It has an eight-year midpoint of its asset depreciation range (ADR). It will require an additional initial investment of $180,000 in nondepreciable working capital. $65,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 $221,000 184,000 154,000 139,000 107,000 97,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) Cost (aftertax) Kd6 .20% 10.80 Ke 15.00 Weights 308 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.) Year Depreciation Base $ 360,000 360,000 360,000 360,000 360,000 360,000 Percentage Depreciation 0.200 0.320 0.192 0.115 0.115 0.058 Annual Depreciation $ 72,000 115,200 69,120 41,400 41,400 20,880 $ 360,000 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.) Year 2 Cash Flow $ 183,750 166,800 132,780 114,600 90,600 142,970 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.) Weighted average cost of capital 11.94 % 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.) Net present value $ 48,309.30 Appendix B Present value of $1, PVOF Period 11% 0.901 0.812 1% 0.990 0.980 0.971 0.961 0.951 0.942 0.933 10% 0.909 0.826 0.751 0.683 0.621 0.564 0.731 0.513 0.923 0.914 0.905 0.896 0.887 0.879 0.870 0.861 0.853 0.844 0.836 0.828 0.820 0.780 0.742 0.672 0.608 2% 0.980 0.961 0.942 0.924 0.906 0.888 0.871 0.853 0.837 0.820 0.804 0.788 0.773 0.758 0.743 0.728 0.714 0.700 0.686 0.673 0.610 0.552 0.453 0.372 3% 0.971 0.943 0.915 0.888 0.863 0.837 0.813 0.789 0.766 0.744 0.722 0.701 0.681 0.661 0.642 0.623 0.605 0.587 0.570 0.554 0.478 0.412 0.307 0.228 4% 0.962 0.925 0.889 0.855 0.822 0.790 0.760 0.731 0.703 0.676 0.650 0.625 0.601 0.577 0.555 0.534 0.513 0.494 0.475 0.456 0.375 0.308 0.208 0.141 5% 0.952 0.907 0.864 0.823 0.784 0.746 0.711 0.677 0.645 0.614 0.585 0.557 0.530 0.505 0.481 0.458 0.436 0.416 0.396 0.377 0.295 0.231 0.142 0.087 Percent 6% 7% 0.943 0.935 0.890 0.873 0.840 0.816 0.792 0.763 0.747 0.713 0.705 0.666 0.665 0.623 0.627 0.582 0.592 0.544 0.558 0.508 0.527 0.475 0.497 0.444 0.469 0.415 0.442 0.388 0.417 0.362 0.394 0.339 0.371 0.317 0.350 0.296 0.331 0.277 0.312 0.258 0.233 0.184 0.174 0.131 0.097 0.067 0.054 0.034 8% 0.926 0.857 0.794 0.735 0.681 0.630 0.583 0.540 0.500 0.463 0.429 0.397 0.368 0.340 0.315 0.292 0.270 0.250 0.232 0.215 0.146 0.099 0.046 0.021 9% 0.917 0.842 0.772 0.708 0.650 0.596 0.547 0.502 0.460 0.422 0.388 0.356 0.326 0.299 0.275 0.252 0.231 0.212 0.194 0.178 0.116 0.075 0.032 0.013 0.467 0.424 0.386 0.350 0.319 0.290 0.263 0.239 0.218 0.198 0.180 0.164 0.149 0.092 0.057 0.022 0.009 0.659 0.593 0.535 0.482 0.434 0.391 0.352 0.317 0.286 0.258 0.232 0.209 0.188 0.170 0.153 0.138 0.124 0.074 0.044 0.015 0.005 12% 0.893 0.797 0.712 0.636 0.567 0.507 0.452 0.404 0.361 0.322 0.287 0.257 0.229 0.205 0.183 0.163 0.146 0.130 0.116 0.104 0.059 0.033 0.011 0.003
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
