The capital investment committee of Arches Landscaping Company is considering two capital investments. The estimated operating income and net cash flows from each investment are as follows:
Front-End Loader | Greenhouse | ||||||||
Year | Operating Income |
Net Cash Flow |
Operating Income |
Net Cash Flow |
|||||
1 | $45,600 | $149,000 | $96,000 | $238,000 | |||||
2 | 45,600 | 149,000 | 73,000 | 201,000 | |||||
3 | 45,600 | 149,000 | 36,000 | 142,000 | |||||
4 | 45,600 | 149,000 | 16,000 | 97,000 | |||||
5 | 45,600 | 149,000 | 7,000 | 67,000 | |||||
Total | $228,000 | $745,000 | $228,000 | $745,000 |
Each project requires an investment of $480,000. Straight-line
Present Value of $1 at |
|||||
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
Average Rate of Return | |
Front-End Loader | fill in the blank 1% |
Greenhouse | fill in the blank 2% |
1b. Compute the net present value for each investment. Use the present value of $1 table above. If required, round to the nearest dollar. If required, use the minus sign to indicate a negative net present value.
Front-End Loader | Greenhouse | |
Present value of net cash flow | $fill in the blank 3 | $fill in the blank 4 |
Amount to be invested | fill in the blank 5 | fill in the blank 6 |
Net present value | $fill in the blank 7 | $fill in the blank 8 |
2. Prepare a brief report for the capital investment committee, advising it on the relative merits of the two investments.
The front-end loader has a
net present value because cash flows occur
in time compared to the greenhouse. Thus, if only one of the two projects can be accepted, the
would be the more attractive.
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 1 images
- Following is information on two alternative investments. Beachside Resort is considering building a new pool or spa. The company requires a 12% return from its investments. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Initial investment Pool $ (174,325) Spa $ (155,960) Net cash flows in: Year 1 54,000 28,000 Year 2 43,000 51,000 Year 3 76,295 58,000 Year 4 88,400 80,000 Year 5 65,000 19,000 a. For each investment project compute the net present value. b. For each investment project compute the profitability index. c. If the company can only select one project, which should it choose on the basis of profitability index? Complete this question by entering your answers in the tabs below. Req A Req B and C For each investment project compute the net present value. Pool Net Cash Flows x Present Value Year 1 Year 2 Year 3 Year 4 Year 5 Totals Spa Net Cash Flows X Present Value Year 1 Year 2 Year 3 Year 4 Year 5 Totals = = = = = = =…arrow_forwardAverage 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 operating income and net cash flows from each investment are as follows: Front-End Loader Year 1 2 3 4 5 Total Year 1 2 3 4 5 6 7 8 9 10 Required: Operating Income $62,000 62,000 62,000 62,000 62,000 $310,000 Each project requires an investment of $620,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 6% 10% 15% 0.943 0.909 0.870 0.890 0.826 0.756 0.840 0.751 0.658 0.792 0.683 0.636 0.572 0.747 0.621 0.567 0.497 0.705 0.564 0.507 0.432 0.665 0.513 0.452 0.376 0.627 0.467 0.404 0.327 0.592 0.361 0.284 0.558 0.322 0.247 Front-End Loader Greenhouse 0.424 Net Cash Flow $187,000 187,000 187,000 0.386 187,000 187,000 $935,000…arrow_forwardUsing the Campbell Soup files given below, develop NOPAT, OCF, and FCF for the last two years. In your opinion and using these measures, is the firm healthy or not? Why or why not? [Note: you will need to use the cash flow statement to find data for fixed asset and working capital investments. For fixed asset investment, consider only the “Purchases of plant assets” in your analysis from the cash flow statement. For working capital investment, only consider Depreciation and Amortization, accounts receivable, inventory, accounts payable, accruals from the cash flow statement. Remember that each of these cash flows already represent changes in cash flow period-over-period.] Please use supporting data exhibits. Consolidated Balance Sheets July 28, 2019 July 29, 2018 Current assets Cash and cash equivalents $ 31 $ 49 Accounts receivable, net 574 563 Inventories 863 887 Other current assets 71 71…arrow_forward
- Gonzalez Company is considering two new projects with the following net cash flows. The company's required rate of return on investments is 10%. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Net Cash Year Project 1 Flows Project 2 Initial investment $ (60,000) $ (60,000) 1. 30,000 35,000 2. 3. 30,000 5,000 20,000 20,000 a. Compute payback period for each project. Based on payback period, which project is preferred? b. Compute net present value for each project. Based on net present value, which project is preferred? Complete this question by entering your answers in the tabs below. Required A Required B Compute net present value for each project. Based on net present value, which project is preferred? (Round your present value factor to 4 decimals. Round your final answers to the nearest whole dollar.) Net Cash Flows Present Value Factor Present Value of Net Cash Flows Project 1 Year 1 Year 2arrow_forwardA company is considering a $184,000 investment in machinery with the following net cash flows. The company requires a 10% return on its investments. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Net Cash Flow (a) Compute the net present value of this investment. (b) Should the machinery be purchased? Required A Required B Year 1 $11,000 Year Year 2 $31,000 Complete this question by entering your answers in the tabs below. Year 1 Year 2 Year 3 Net Cash Flows Year 3 $61,000 Compute the net present value of this investment. (Round your present value factor to 4 decimals. Round your final answers to the nearest whole dollar.) Present Value Factor Year 4 $46,000 Present Value of Net Cash Flows Year 5 $123,000arrow_forwardThe capital investment committee of Taiwan Semiconductor Company is considering two capital investments. The estimated income from operations and net cash flows from each investment are as follows: Lithography Machine Photoresist Machine Year Income from Operations Net Cash Flow Income from Operations Net Cash Flows 1 $26,000 $41,000 $12,250 $25,250 2 21,000 35,000 12,250 25,250 3 7,000 22,500 12,250 25,250 4 4,000 18,000 12,250 25,250 5 1,450 16,150 12,250 25,250 Total $59,450 $132,650 $61,250 $126,250 Each project requires an investment of $75,000. Straight-line depreciation will be used, and no residual value is expected. The committee has selected a rate of 12% for purposes of the net present value analysis. Compute the following: The average rate of return for each investment. The net present value for each investment. Use the present value of $1 table appearing in this…arrow_forward
- Capital Investment Analysis: Tasty Doughnutsarrow_forwardplease answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)arrow_forwardProminent Sdn Bhd invested in two projects, project Alpha and project Beta. The projects are independent of each other. The following schedule shows the cash flows for each project. Year Project Alpha Project Beta 0 -10,000 -10,000 1 5,000 1,000 2 4,000 2,000 3 2,000 2,000 4 2,000 3,000 5 1,000 6,000 The following schedule shows the profit for each project. Year Project Alpha Project Beta 0 0 0 1 2,000 1,000 2 2,000 1,000 3 2,000 2,000 4 2,000 2,000 5 2,000 4,000 The discount rate is 10%. Additional information : Appraisal method 1: Rate of return : Year Project Alpha Project Beta 1 2,000 1,000 2 2,000 1,000 3 2,000 2,000 4 2,000 2,000 5 2,000 4,000 total profit 10000 10000 average annual profit (total profit / number of years) 2000 (10000/5) 2000 (10000/5) initial investment 10000 10000 accounting rate of return = average annual profit initial investment * 100 20%…arrow_forward
- Capital Investment Analysis: Arches Landscaping Companyarrow_forwardRequired: 1a. Compute the average rate of return for each investment. If required, round your answer to one decimal place. Average Rate of Return Greenhouse Front-End Loader 1b. Compute the net present value for each investment. Use the present value of $1 table above. If required, round to the nearest dollar. Front-End Loader Greenhouse Present value of net cash flow Amount to be invested Net present value 2. Prepare a brief report for the capital investment committee, advising it on the relative merits of the two investments. The front-end loader has a net present value because would be the more attractive. cash flows occur earlier in time compared to the greenhouse. Thus, if only one of the two projects can be accepted, thearrow_forwardProminent Sdn Bhd invested in two projects, project Alpha and project Beta. The projects are independent of each other. The following schedule shows the cash flows for each project. Year Project Alpha Project Beta 0 -10,000 -10,000 1 5,000 1,000 2 4,000 2,000 3 2,000 2,000 4 2,000 3,000 5 1,000 6,000 The following schedule shows the profit for each project. Year Project Alpha Project Beta 0 0 0 1 2,000 1,000 2 2,000 1,000 3 2,000 2,000 4 2,000 2,000 5 2,000 4,000 The discount rate is 10%. Additional information : Appraisal method 1: Rate of return : Year Project Alpha Project Beta 1 2,000 1,000 2 2,000 1,000 3 2,000 2,000 4 2,000 2,000 5 2,000 4,000 total profit 10000 10000 average annual profit (total profit / number of years) 2000 (10000/5) 2000 (10000/5) initial investment 10000 10000 accounting rate of return = average annual profit initial investment * 100 20%…arrow_forward
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education