3 DataPoint Engineering is considering the purchase of a new piece of equipment for $290,000. It...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/66480e5a6e43b_29866480e5a071fa.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/66480e5b05b2d_29866480e5a9db59.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/66480e5b804f3_29966480e5b32e91.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/66480e5c3470f_29966480e5bc930c.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/66480e5cdf270_30066480e5c68b3e.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/66480e5da6c0c_30166480e5d30147.jpg)
Transcribed Image Text:
3 DataPoint Engineering is considering the purchase of a new piece of equipment for $290,000. It has an eight-year midpoint of its asset depreciation range (ADR). It will require an additional initial investment of $190,000 in nondepreciable working capital. $47,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 $ 200,000 1 2 170,000 Book 3 140,000 4 125,000 Hint 5 100,000 90,000 Print erences 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) Weights Kd 5.30% 9.40 30% 10 Ke 14.00 60 a. Determine the annual depreciation schedule. Note: 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 Percentage Depreciation Depreciation Annual 1 2 3 4 5 n Check my b. Determine the annual cash flow for each year. Be sure to include the recovered working capital in Year 6. Note: Do not round intermediate calculations and found your answers to 2 decimal places. Year Cash Flow 1 2 3 4 5 6 c. Determine the weighted average cost of capital. Note: Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places. Weighted average cost of capital % Hint Print References d-1. Determine the net present value. Note: 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 colculations. Round your answer to 2 decimal places. Net present value d-2. Should DataPoint purchase the new equipment? O Yes O No Table 12-11 Categories for depreciation write-off Class 3-year MACRS 5-year MACRS 7-year MACRS 10-year MACRS 15-year MACRS 20-year MACRS 27.5-year MACRS 31.5-year MACRS 39-year MACRS All property with ADR midpoints of 4 years or less. Autos and light trucks are excluded from this category. Property with ADR midpoints of more than 4, but less than 10 years. Key assets in this category include automobiles, light trucks, and technological equipment such as computers and research-related properties. Property with ADR midpoints of 10 years or more, but less than 16 years. Most types of manufacturing equipment would fall into this category, as would office furniture and fixtures. Property with ADR midpoints of 16 years or more, but less than 20 years. Petroleum refining products, railroad tank cars, and manufactured homes fall into this group. Property with ADR midpoints of 20 years or more, but less than 25 years. Land improvement, pipeline distribution, telephone distribution, and sewage treatment plants all belong in this category. Property with ADR midpoints of 25 years or more (with the exception of real estate, which is treated separately). Key investments in this category include electric and gas utility property and sewer pipes. Residential rental property if 80 percent or more of the gross rental income is from nontransient dwelling units (e.g., an apartment building); low-income housing. Nonresidential real property that has no ADR class life or whose class life is 27.5 years or more. Nonresidential real property placed in service after May 12, 1993. Table 12-12 Depreciation percentages (expressed in decimals) Depreciation Year 3-Year 5-Year 7-Year 10-Year 15-Year 20-Year MACRS MACRS MACRS MACRS MACRS MACRS 1 0.333 0.200 0.143 0.100 0.050 0.038 2 0.445 0.320 0.245 0.180 0.095 0.072 3 0.148 0.192 0.175 0.144 0.086 0.067 4 0.074 0.115 0.125 0.115 0.077 0.062 5 0.115 0.089 0.092 0.069 0.057 6 0.058 0.089 0.074 0.062 0.053 7 0.089 0.066 0.059 0.045 8 0.045 0.066 0.059 0.045 9 0.065 0.059 0.045 10 0.065 0.059 0.045 11 0.033 0.059 0.045 12 0.059 0.045 13 0.059 0.045 14 0.059 0.045 15 0.059 0.045 16 0.030 0.045 17 0.045 18 0.045 19 0.045 20 0.045 21 0.017 1.000 1.000 1.000 1.000 1.000 1.000 Appendix B Present value of $1, PV IF PV-FV[1/(1+0)")] Percent Period 1% 2% 3% 4% 5% 6% 7% 8% 1 0.990 0.980 0.971 0.962 0.952 0.943 0.935 2 0.980 0.961 0.943 0.890 3 0.971 0.942 4 0.961 5 6 7 8 9 0.923 0.853 0.789 0.731 0.677 0.914 0.837 0.766 0.703 10 11 12 0.905 0.820 0.744 0.676 0.896 0.804 0.722 0.887 0.788 0.701 13 18 3678 19 20 0.879 0.773 0.681 14 0.870 0.758 0.661 15 0.861 0.743 0.642 16 0.853 0.728 0.623 17 0.844 0.714 0.605 0.836 0,700 0.587 0.828 0.686 0.570 0.820 0.673 0.554 0.627 0.645 0.592 0.558 0.527 0.497 0.469 0.442 25 0.780 0.610 0.478 30 40 0.742 0.552 0.412 0.672 0.453 0.307 50 17% 18% 19% 20% 259 0.926 0.917 0.909 0.901 0.893 0.885 0.877 0.870 0.862 0.855 0.847 0.840 0.833 0.80 0.925 0.907 0.873 0.857 0.842 0.826 0.812 0.797 0.783 0.769 0.756 0.743 0.731 0.718 0.706 0.694 0.64 0.915 0.889 0.864 0.840 0.816 0.794 0.772 0.751 0.731 0.712 0.693 0.675 0.658 0.641 0.624 0.609 0.593 0.579 0.51 0.924 0.888 0.855 0823 0.792 0.763 0.735 0.708 0.683 0.659 0.636 0.613 0.592 0.572 0.552 0.534 0.515 0.499 0.482 041 0.951 0.906 0.863 0.822 0.784 0.747 0.713 0.681 0.650 0.621 0.593 0.567 0.543 0.519 0.497 0476 0.456 0.437 0.419 0.402 0.325 0.942 0.888 0.837 0.790 0.746 0.705 0.666 0.630 0.596 0.564 0.535 0.507 0.480 0.456 0.432 0.410 0.390 0.370 0.352 0.335 0.26- 0.933 0.871 0.813 0.760 0.711 0.665 0.623 0.583 0.547 0.513 0.482 0.452 0.425 0.400 0.376 0.354 0.333 0.314 0.296 0.279 0.21 0.582 0.540 0.502 0.467 0.434 0.404 0.376 0.351 0.327 0.305 0.285 0.266 0.249 0.233 0.16 0.544 0.500 0.460 0.424 0.391 0.361 0.333 0.308 0.284 0.263 0.243 0.225 0.209 0.194 0.13- 0.614 0.508 0.463 0.422 0.386 0.352 0.322 0.295 0.270 0.247 0.227 0.208 0.191 0.176 0.162 0.10 0.650 0.585 0.475 0.429 0.388 0.350 0.317 0.287 0.261 0.237 0.215 0.195 0.178 0.162 0.148 0.135 0.08e 0.625 0.557 0.444 0.397 0.356 0.319 0.286 0.257 0.231 0.208 0.187 0.168 0.152 0.137 0.124 0.112 0.065 0.601 0.530 0415 0.368 0.326 0.290 0.258 0.229 0.204 0.182 0.163 0.145 0.130 0.116 0.104 0.093 0.05 0.577 0.505 0.388 0.340 0.299 0.263 0.232 0.205 0.181 0.160 0.141 0.125 0.111 0.099 0.088 0.078 0.044 0.555 0.481 0.417 0.362 0.315 0.275 0.239 0.209 0.183 0.160 0.140 0.123 0.108 0.095 0.084 0.074 0.065 0.035 0.534 0.458 0.394 0.339 0.292 0.252 0.218 0.188 0.163 0.141 0.123 0.107 0.093 0.081 0.071 0.062 0.054 0.028 0.513 0.436 0.371 0.317 0.270 0.231 0.198 0.170 0.146 0.125 0.108 0.093 0.080 0.069 0.060 0.494 0.416 0.350 0.296 0.250 0.212 0.180 0.153 0.130 0.111 0.095 0.081 0.069 0.059 0.051 0475 0.396 0.331 0.277 0.232 0.194 0.164 0.138 0.116 0.098 0.083 0.070 0.060 0.456 0.377 0.312 0.258 0.215 0.178 0.149 0.124 0.104 0.087 0.073 0.061 0.051 0.375 0.295 0.233 0.184 0.146 0.116 0.092 0.074 0.059 0.047 0.038 0.308 0.231 0.174 0.131 0.099 0.075 0.057 0.044 0.033 0.026 0.020 0.208 0.142 0.097 0.067 0.046 | 0.032 0.022 0.015 0.011 0.008 0.005 0.608 0.372 0.228 0.141 0.087 0.054 0.034 0.021 0.013 0.009 0.005 0.003 0.002 9% 10% 11% 12% 13% 14% 15% 16% 0.052 0.045 0.023 0.044 0.038 0.018 0.051 0.043 0.037 0.031 0.014 0.004 0.001 0.001 0.043 0.037 0.031 0.026 0.012 0.030 0.024 0.020 0.016 0.013 0.010 0.004 0.015 0.012 0.009 0.007 0.005 0.004 0.001 0.003 0.002 0.001 0 0.001 0.001 0.001 0 n n n n 3 DataPoint Engineering is considering the purchase of a new piece of equipment for $290,000. It has an eight-year midpoint of its asset depreciation range (ADR). It will require an additional initial investment of $190,000 in nondepreciable working capital. $47,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 $ 200,000 1 2 170,000 Book 3 140,000 4 125,000 Hint 5 100,000 90,000 Print erences 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) Weights Kd 5.30% 9.40 30% 10 Ke 14.00 60 a. Determine the annual depreciation schedule. Note: 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 Percentage Depreciation Depreciation Annual 1 2 3 4 5 n Check my b. Determine the annual cash flow for each year. Be sure to include the recovered working capital in Year 6. Note: Do not round intermediate calculations and found your answers to 2 decimal places. Year Cash Flow 1 2 3 4 5 6 c. Determine the weighted average cost of capital. Note: Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places. Weighted average cost of capital % Hint Print References d-1. Determine the net present value. Note: 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 colculations. Round your answer to 2 decimal places. Net present value d-2. Should DataPoint purchase the new equipment? O Yes O No Table 12-11 Categories for depreciation write-off Class 3-year MACRS 5-year MACRS 7-year MACRS 10-year MACRS 15-year MACRS 20-year MACRS 27.5-year MACRS 31.5-year MACRS 39-year MACRS All property with ADR midpoints of 4 years or less. Autos and light trucks are excluded from this category. Property with ADR midpoints of more than 4, but less than 10 years. Key assets in this category include automobiles, light trucks, and technological equipment such as computers and research-related properties. Property with ADR midpoints of 10 years or more, but less than 16 years. Most types of manufacturing equipment would fall into this category, as would office furniture and fixtures. Property with ADR midpoints of 16 years or more, but less than 20 years. Petroleum refining products, railroad tank cars, and manufactured homes fall into this group. Property with ADR midpoints of 20 years or more, but less than 25 years. Land improvement, pipeline distribution, telephone distribution, and sewage treatment plants all belong in this category. Property with ADR midpoints of 25 years or more (with the exception of real estate, which is treated separately). Key investments in this category include electric and gas utility property and sewer pipes. Residential rental property if 80 percent or more of the gross rental income is from nontransient dwelling units (e.g., an apartment building); low-income housing. Nonresidential real property that has no ADR class life or whose class life is 27.5 years or more. Nonresidential real property placed in service after May 12, 1993. Table 12-12 Depreciation percentages (expressed in decimals) Depreciation Year 3-Year 5-Year 7-Year 10-Year 15-Year 20-Year MACRS MACRS MACRS MACRS MACRS MACRS 1 0.333 0.200 0.143 0.100 0.050 0.038 2 0.445 0.320 0.245 0.180 0.095 0.072 3 0.148 0.192 0.175 0.144 0.086 0.067 4 0.074 0.115 0.125 0.115 0.077 0.062 5 0.115 0.089 0.092 0.069 0.057 6 0.058 0.089 0.074 0.062 0.053 7 0.089 0.066 0.059 0.045 8 0.045 0.066 0.059 0.045 9 0.065 0.059 0.045 10 0.065 0.059 0.045 11 0.033 0.059 0.045 12 0.059 0.045 13 0.059 0.045 14 0.059 0.045 15 0.059 0.045 16 0.030 0.045 17 0.045 18 0.045 19 0.045 20 0.045 21 0.017 1.000 1.000 1.000 1.000 1.000 1.000 Appendix B Present value of $1, PV IF PV-FV[1/(1+0)")] Percent Period 1% 2% 3% 4% 5% 6% 7% 8% 1 0.990 0.980 0.971 0.962 0.952 0.943 0.935 2 0.980 0.961 0.943 0.890 3 0.971 0.942 4 0.961 5 6 7 8 9 0.923 0.853 0.789 0.731 0.677 0.914 0.837 0.766 0.703 10 11 12 0.905 0.820 0.744 0.676 0.896 0.804 0.722 0.887 0.788 0.701 13 18 3678 19 20 0.879 0.773 0.681 14 0.870 0.758 0.661 15 0.861 0.743 0.642 16 0.853 0.728 0.623 17 0.844 0.714 0.605 0.836 0,700 0.587 0.828 0.686 0.570 0.820 0.673 0.554 0.627 0.645 0.592 0.558 0.527 0.497 0.469 0.442 25 0.780 0.610 0.478 30 40 0.742 0.552 0.412 0.672 0.453 0.307 50 17% 18% 19% 20% 259 0.926 0.917 0.909 0.901 0.893 0.885 0.877 0.870 0.862 0.855 0.847 0.840 0.833 0.80 0.925 0.907 0.873 0.857 0.842 0.826 0.812 0.797 0.783 0.769 0.756 0.743 0.731 0.718 0.706 0.694 0.64 0.915 0.889 0.864 0.840 0.816 0.794 0.772 0.751 0.731 0.712 0.693 0.675 0.658 0.641 0.624 0.609 0.593 0.579 0.51 0.924 0.888 0.855 0823 0.792 0.763 0.735 0.708 0.683 0.659 0.636 0.613 0.592 0.572 0.552 0.534 0.515 0.499 0.482 041 0.951 0.906 0.863 0.822 0.784 0.747 0.713 0.681 0.650 0.621 0.593 0.567 0.543 0.519 0.497 0476 0.456 0.437 0.419 0.402 0.325 0.942 0.888 0.837 0.790 0.746 0.705 0.666 0.630 0.596 0.564 0.535 0.507 0.480 0.456 0.432 0.410 0.390 0.370 0.352 0.335 0.26- 0.933 0.871 0.813 0.760 0.711 0.665 0.623 0.583 0.547 0.513 0.482 0.452 0.425 0.400 0.376 0.354 0.333 0.314 0.296 0.279 0.21 0.582 0.540 0.502 0.467 0.434 0.404 0.376 0.351 0.327 0.305 0.285 0.266 0.249 0.233 0.16 0.544 0.500 0.460 0.424 0.391 0.361 0.333 0.308 0.284 0.263 0.243 0.225 0.209 0.194 0.13- 0.614 0.508 0.463 0.422 0.386 0.352 0.322 0.295 0.270 0.247 0.227 0.208 0.191 0.176 0.162 0.10 0.650 0.585 0.475 0.429 0.388 0.350 0.317 0.287 0.261 0.237 0.215 0.195 0.178 0.162 0.148 0.135 0.08e 0.625 0.557 0.444 0.397 0.356 0.319 0.286 0.257 0.231 0.208 0.187 0.168 0.152 0.137 0.124 0.112 0.065 0.601 0.530 0415 0.368 0.326 0.290 0.258 0.229 0.204 0.182 0.163 0.145 0.130 0.116 0.104 0.093 0.05 0.577 0.505 0.388 0.340 0.299 0.263 0.232 0.205 0.181 0.160 0.141 0.125 0.111 0.099 0.088 0.078 0.044 0.555 0.481 0.417 0.362 0.315 0.275 0.239 0.209 0.183 0.160 0.140 0.123 0.108 0.095 0.084 0.074 0.065 0.035 0.534 0.458 0.394 0.339 0.292 0.252 0.218 0.188 0.163 0.141 0.123 0.107 0.093 0.081 0.071 0.062 0.054 0.028 0.513 0.436 0.371 0.317 0.270 0.231 0.198 0.170 0.146 0.125 0.108 0.093 0.080 0.069 0.060 0.494 0.416 0.350 0.296 0.250 0.212 0.180 0.153 0.130 0.111 0.095 0.081 0.069 0.059 0.051 0475 0.396 0.331 0.277 0.232 0.194 0.164 0.138 0.116 0.098 0.083 0.070 0.060 0.456 0.377 0.312 0.258 0.215 0.178 0.149 0.124 0.104 0.087 0.073 0.061 0.051 0.375 0.295 0.233 0.184 0.146 0.116 0.092 0.074 0.059 0.047 0.038 0.308 0.231 0.174 0.131 0.099 0.075 0.057 0.044 0.033 0.026 0.020 0.208 0.142 0.097 0.067 0.046 | 0.032 0.022 0.015 0.011 0.008 0.005 0.608 0.372 0.228 0.141 0.087 0.054 0.034 0.021 0.013 0.009 0.005 0.003 0.002 9% 10% 11% 12% 13% 14% 15% 16% 0.052 0.045 0.023 0.044 0.038 0.018 0.051 0.043 0.037 0.031 0.014 0.004 0.001 0.001 0.043 0.037 0.031 0.026 0.012 0.030 0.024 0.020 0.016 0.013 0.010 0.004 0.015 0.012 0.009 0.007 0.005 0.004 0.001 0.003 0.002 0.001 0 0.001 0.001 0.001 0 n n n n
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Roles define the manager. Do you agree or disagree with this statement? Discuss what you think managers do.
-
A copper wire 20.0 m long with radius 4.57 x 103 m and = 1.72 x 108 cm is used to form a solenoid that will produce a magnetic field. (a) What is the wires resistance? (b) If the wire is connected...
-
Navaria Inc. manufactures and sells chair lift mobility aids. These are chairlift systems designed for in home use to aid persons with mobility challenges. The company sells its systems online and...
-
The March 31, 2008, adjusted trial balance of Success Systems (reflecting its transactions from October 2007 through March of 2008) follows. The March 31, 2008, amount of merchandise available totals...
-
Accounting, Analysis, and Principles Diversified Products, Inc. operates in several lines of business, including the construction and real estate industries. While the majority of its revenues are...
-
Problem brief. #1 A rectangular steel beam with an overall length of L m is simply supported at each end. At mid section the beam carries a point load of T tonnes. The mass of the beam constitutes a...
-
What are soft skills? Enumerate and explain the most in-demand soft skills along with useful examples. Give some industrial example.
-
1. Corporate Finance deals with raising funds for Private Companies, Corporate entities and Governments. What are these funds not used for ? Explain
-
A table below shows a simplified balance sheet for Randy Co. The debt has just been refinanced at an interest rate of 6% (short term) and 8% (long term). The expected rate of return on the company's...
-
IN ACFR, if the legal debt margin is steady increase in last ten fiscal years what it means
-
11. Pistol Pete's all-you-can-eat buffet restaurant charges as shown below. Age under 6 Price Free 9 times child's weight (in lbs.) $10.95 6 to 15 16-59 60 and over $8.95 Write a Python program with...
-
A company has 5 3 6 4 2 3 8 shares outstanding and the stock sells at $ 8 4 . 6 4 per share. What is the market value of equity?
-
XYZ Insurance Company, a relatively small general insurer, has outsourced its claims adjusting function. Now, when a claim is reported, the insurer notifies the outsource adjusting company, which...
-
A heat engine has a heat input of 3 Ã 104 Btu/h and a thermal efficiency of 40 percent. Calculate the power it will produce, in hp. Source 3 x 10 Btu/h 40% HE Sink
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App