Question
Thanks in advance! :) Average Rate of Return Method, Net Present Value Method, and Analysis for a service company The capital investment committee of Arches
Thanks in advance! :)
Average Rate of Return Method, Net Present Value Method, and Analysis for a service company
The capital investment committee of Arches Landscaping Company is considering two capital investments. The estimated income from operations and net cash flows from each investment are as follows:
Front-End Loader | Greenhouse | |||||||||
Year | Income from Operations | Net Cash Flow | Income from Operations | Net Cash Flow | ||||||
1 | $37,800 | $122,000 | $79,000 | $195,000 | ||||||
2 | 37,800 | 122,000 | 60,000 | 165,000 | ||||||
3 | 37,800 | 122,000 | 30,000 | 116,000 | ||||||
4 | 37,800 | 122,000 | 13,000 | 79,000 | ||||||
5 | 37,800 | 122,000 | 7,000 | 55,000 | ||||||
Total | $189,000 | $610,000 | $189,000 | $610,000 |
Each project requires an investment of $420,000. Straight-line depreciation will be used, and no residual value is expected. The committee has selected a rate of 10% for purposes of the net present value analysis.
Present Value of $1 at Compound Interest | |||||
Year | 6% | 10% | 12% | 15% | 20% |
1 | 0.943 | 0.909 | 0.893 | 0.870 | 0.833 |
2 | 0.890 | 0.826 | 0.797 | 0.756 | 0.694 |
3 | 0.840 | 0.751 | 0.712 | 0.658 | 0.579 |
4 | 0.792 | 0.683 | 0.636 | 0.572 | 0.482 |
5 | 0.747 | 0.621 | 0.567 | 0.497 | 0.402 |
6 | 0.705 | 0.564 | 0.507 | 0.432 | 0.335 |
7 | 0.665 | 0.513 | 0.452 | 0.376 | 0.279 |
8 | 0.627 | 0.467 | 0.404 | 0.327 | 0.233 |
9 | 0.592 | 0.424 | 0.361 | 0.284 | 0.194 |
10 | 0.558 | 0.386 | 0.322 | 0.247 | 0.162 |
Required:
1a. Compute the average rate of return for each investment. If required, round your answer to one decimal place.
Average Rate of Return | |
Front-End Loader | % |
Greenhouse | % |
1b. Compute the net present value for each investment. Use the present value of $1 table above. If required, use the minus sign to indicate a negative net present value.
Front-End Loader | Greenhouse | |
Present value of net cash flow | $ | $ |
Amount to be invested | $ | $ |
Net present value | $ | $ |
Cash Payback Period, Net Present Value Method, and Analysis
Elite Apparel Inc. is considering two investment projects. The estimated net cash flows from each project are as follows:
Year | Plant Expansion | Retail Store Expansion | ||||
1 | $ 450,000 | $ 500,000 | ||||
2 | 450,000 | 400,000 | ||||
3 | 340,000 | 350,000 | ||||
4 | 280,000 | 250,000 | ||||
5 | 180,000 | 200,000 | ||||
Total | $1,700,000 | $1,700,000 |
Each project requires an investment of $900,000. A rate of 15% has been selected for the net present value analysis.
Present Value of $1 at Compound Interest | |||||
Year | 6% | 10% | 12% | 15% | 20% |
1 | 0.943 | 0.909 | 0.893 | 0.870 | 0.833 |
2 | 0.890 | 0.826 | 0.797 | 0.756 | 0.694 |
3 | 0.840 | 0.751 | 0.712 | 0.658 | 0.579 |
4 | 0.792 | 0.683 | 0.636 | 0.572 | 0.482 |
5 | 0.747 | 0.621 | 0.567 | 0.497 | 0.402 |
6 | 0.705 | 0.564 | 0.507 | 0.432 | 0.335 |
7 | 0.665 | 0.513 | 0.452 | 0.376 | 0.279 |
8 | 0.627 | 0.467 | 0.404 | 0.327 | 0.233 |
9 | 0.592 | 0.424 | 0.361 | 0.284 | 0.194 |
10 | 0.558 | 0.386 | 0.322 | 0.247 | 0.162 |
Required:
1a. Compute the cash payback period for each project.
Cash Payback Period | |
Plant Expansion | 2 years |
Retail Store Expansion | 2 years |
1b. Compute the net present value. Use the present value of $1 table above. If required, round to the nearest dollar.
Plant Expansion | Retail Store Expansion | |
Present value of net cash flow total | $ | $ |
Less amount to be invested | $ | $ |
Net present value | $ | $ |
Net Present Value Method, Internal Rate of Return Method, and Analysis for a Service Company
The management of Advanced Alternative Power Inc. is considering two capital investment projects. The estimated net cash flows from each project are as follows:
Year | Wind Turbines | Biofuel Equipment | ||
1 | $280,000 | $300,000 | ||
2 | 280,000 | 300,000 | ||
3 | 280,000 | 300,000 | ||
4 | 280,000 | 300,000 |
The wind turbines require an investment of $887,600, while the biofuel equipment requires an investment of $911,100. No residual value is expected from either project.
Present Value of an Annuity of $1 at Compound Interest | |||||
Year | 6% | 10% | 12% | 15% | 20% |
1 | 0.943 | 0.909 | 0.893 | 0.870 | 0.833 |
2 | 1.833 | 1.736 | 1.690 | 1.626 | 1.528 |
3 | 2.673 | 2.487 | 2.402 | 2.283 | 2.106 |
4 | 3.465 | 3.170 | 3.037 | 2.855 | 2.589 |
5 | 4.212 | 3.791 | 3.605 | 3.353 | 2.991 |
6 | 4.917 | 4.355 | 4.111 | 3.785 | 3.326 |
7 | 5.582 | 4.868 | 4.564 | 4.160 | 3.605 |
8 | 6.210 | 5.335 | 4.968 | 4.487 | 3.837 |
9 | 6.802 | 5.759 | 5.328 | 4.772 | 4.031 |
10 | 7.360 | 6.145 | 5.650 | 5.019 | 4.192 |
Required:
1a. Compute the net present value for each project. Use a rate of 6% and the present value of an annuity of $1 in the table above. If required, round to the nearest dollar.
Wind Turbines | Bio Fuel Equipment | |
Present value of annual net cash flows | $ | $ |
Less amount to be invested | $ | $ |
Net present value | $ | $ |
1b. Compute a present value index for each project. If required, round your answers to two decimal places.
Present Value Index | |
Wind Turbines | |
Bio Fuel Equipment |
2. Determine the internal rate of return for each project by (a) computing a present value factor for an annuity of $1 and (b) using the present value of an annuity of $1 in the table above. If required, round your present value factor answers to three decimal places and internal rate of return to the nearest percent.
Wind Turbines | Bio Fuel Equipment | |
Present value factor for an annuity of $1 | ||
Internal rate of return | % | % |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started