Following is information on two alternative investments. Beachside Resort is considering building a new pool or spa. The companyrequires a 10% return from its investments.Initial investmentNet cash flows in:Year 140,000Year 256,000Year 380,295Year 490,400Year 565,000Compute the internal rate of return for each of the projects using excel functions. (Round your answers to 2 decimal places.)PoolSpaIRRPoolSpa$ (160,000) $ (105,000)%%32,00050,00066,00072,00024,000

Following is information on two alternative investments. Beachside Resort is considering building a new pool or spa. The company requires a 10% return from its investments. Initial investment Net cash flows in: Year 1 Year 2 Year 3 Year 4 Year 5 Compute the internal rate of return for each of the projects using excel functions. (Round your answers to 2 decimal places.) Pool Spa IRR Pool Spa $ (160,000) $ (105,000) % % 40,000 56,000 80,295 90,400 65,000 32,000 50,000 66,000 72,000 24,000

Following is information on two alternative investments. Beachside Resort is considering building a new pool or spa. The company requires a 10% return from its investments. Initial investment Net cash flows in: Year 1 Year 2 Year 3 Year 4 Year 5 Compute the internal rate of return for each of the projects using excel functions. (Round your answers to 2 decimal places.) Pool Spa IRR Pool Spa $ (160,000) $ (105,000) % % 40,000 56,000 80,295 90,400 65,000 32,000 50,000 66,000 72,000 24,000

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 1PA: Your company is planning to purchase a new log splitter for is lawn and garden business. The new...

See similar textbooks

Similar questions

Following is information on two alternative investments. Beachside Resort is considering building a new pool or spa. The company requires a 10% return from its investments. Initial investment Net cash flows in: Year 1 Year 2 Year 3 Year 4 Year 5 Pool Spa IRR Pool $ (177,000) % % 41,700 57,700 81,995 92,100 66,700 Compute the internal rate of return for each of the projects using excel functions. Note: Round your answers to 2 decimal places. Spa $ (122,000) 33,700 51,700 67,700 73,700 25,700
X-treme Vitamin Company is considering two Investments, both of which cost $14,000. The cash flows are as follows: Tear Project A Project B $16,000 $14,000 5,000 9,000 2 3 6.000 4,000 Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods. a-1. Calculate the payback period for Project A and Project B. (Round your answers to 2 decimal places.) Project A Project B Payback Period year(s) year(s) a-2. Which of the two projects should be chosen based on the payback method? O Project A O Project B b-1. Calculate the net present value for Project A and Project B. Assume a cost of capital of 8 percent. (Do not round intermediate calculations and round your final answers to 2 decimal places.) Project A Project B Net Present Value
X-treme Vitamin Company is considering two investments, both of which cost $20,000. The cash flows are as follows: Year Project A Project B 1 $ 23,000 $ 20,000 2 10,000 9,000 3 10,000 15,000 Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods. a-1. Calculate the payback period for Project A and Project B. (Round your answers to 2 decimal places.) project A 0.87 years project B 1 year b-1. Calculate the net present value for Project A and Project B. Assume a cost of capital of 8 percent. (Do not round intermediate calculations and round your final answers to 2 decimal places.)
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: Plant Expansion Retail Store Expansion Year 1 2 3 4 5 Total Year 1 2 Each project requires an investment of $294,000. A rate of 15% has been selected for the net present value analysis. Present Value of $1 at Compound Interest 6% 10% 12% 15% 20% 0.893 0.870 0.833 0.797 0.756 0.694 3 4 5 $162,000 132,000 114,000 103,000 33,000 $544,000 6 7 8 9 10 Required: 0.909 0.826 $135,000 159,000 109,000 76,000 65,000 $544,000 0.943 0.890 0.840 0.751 0.792 0.683 0.747 0.621 0.705 0.564 0.665 0.627 0.592 0.558 0.712 0.658 0.636 0.572 0.567 0.497 0.507 0.432 0.513 0.452 0.376 0.467 0.404 0.327 0.424 0.361 0.284 0.386 0.322 0.247 1a. Compute the cash payback period for each project. Cash Payback Period 0.579 0.482 0.402 0.335 0.279 0.233 0.194 0.162 Plant Expansion Retail Store Expansion 1b. Compute the net present value.…
Below are four cases that you will have to solve using Excel spreadsheets. 1st case The company COMERCIAL SA has two investment alternatives that present the following information: PROJECT A B It is requested Initial investment. $25,000 $22,000 Cash flows year 1 1. Determine the internal rate of return. 2. Determine the present value. $7,000 $12,000 The discount rate for the project will be 10% and the MARR will be 20%. 3. Determine the recovery period. 4. Define which is the most viable project. Year 2 cash flows $15,000 $8,000 Year 3 cash flows $18,000 $12,000
X-treme Vitamin Company is considering two investments, both of which cost $34,000. The cash flows are as follows: $ 36,000 Project B $ 34,000 16,000 18,000 16,000 10,000 Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods. a-1. Calculate the payback period for Project A and Project B. Note: Round your answers to 2 decimal places. Year Project A 1 2 3 Project A Project B a-2. Which of the two projects should be chosen based on the payback method? Project A O Project B Payback Period year(s) year(s) b-1. Calculate the net present value for Project A and Project B. Assume a cost of capital of 12 percent. Note: Do not round intermediate calculations and round your final answers to 2 decimal places. Project A Project B Net Present Value
Dock Company is considering a capital investment in machinery: E (Click the icon to view the data.) 8. Calculate the payback. 9. Calculate the ARR. Round the percentage to two decimal places. 10. Based on your answers to the above questions, should Dock invest in the machinery? 8. Calculate the payback. Payback years - X Data Table Initial investment $ 1,500,000 Residual value 350,000 Expected annual net cash inflows 500,000 Expected useful life 4 years Required rate of return 9% Print Done
The internal rate of return method is used by Testerman Construction Co. in analyzing a capital expenditure proposal that involves an investment of $143,920 and annual net cash flows of $35,000 for each of the six years of its useful life. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet Determine the internal rate of return for the proposal. %
X-treme Vitamin Company is considering two investments, both of which cost $10,000. The cash flows are as follows: NOTE: you must show your work for ALL steps for full credit. Year Proj A Proj B 1 $ 12,000.00 $10,000.00 2 $8,000.00 $6,000.00 3 $ 6,000.00 $16,000.00 a. Which of the two projects should be chosen based on the payback method b. Which of the two projects should be chosen based on the net present value method? Assume a cost of capital of 10 percent. c. Should a firm normally have more confidence in answer a or answer b.
Dogwood Company is considering a capital investment in machinery: (Click the icon to view the data.) 8. Calculate the payback. 9. Calculate the ARR. Round the percentage to two decimal places. 10. Based on your answers to the above questions, should Dogwood invest in the machinery? 8. Calculate the payback. Amount invested Expected annual net cash inflow Payback 1,500,000 24 500,000 3 years 9. Calculate the ARR. Round the percentage to two decimal places. Average annual operating income Average amount invested ARR Data Table Initial investment $ 1,500,000 Residual value 350,000 Expected annual net cash inflows 500,000 Expected useful life 4 years Required rate of return 15%
X-treme Vitamin Company is considering two investments, both of which cost $10,000. The cash flows are as follows: Year Project A Project B 1 $ 12,000 $ 10,000 2 8,000 6,000 3 6,000 16,000 Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods. a-1. Calculate the payback period for Project A and Project B. b-1. Calculate the net present value for Project A and Project B. Assume a cost of capital of 10 percent.
Your company is planning to purchase a new log splitter for is lawn and garden business. The new splitter has an initial investment of $180,000. It is expected to generate $25,000 of annual cash flows, provide incremental cash revenues of $150,000, and incur incremental cash expenses of $100,000 annually. What is the payback period and accounting rate of return (ARR)?