:Exercise 24-22A (Algo) Using Excel to compute IRR LO P4Following is information on two alternative investments. Beachside Resort is considering building a new pool or spa. The companyrequires a 10% return from its investments.PoolSpaInitial investment$ (173,000) $ (118,000)Net cash flows inYear 141,30033,300CesYear 257,30051,300Year 381,59567,300Year 491,70073,300Year 566,30025,300Compute the internal rate of return for each of the projects using excel functions. (Round your answers to 2 decimal places.)IRRPoolSpa%

Internal rate of return (IRR): Internal rate of return (IRR) is defined as the discount rate at…

Exercise 24-22A (Algo) Using Excel to compute IRR LO P4 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. Pool $(173,000) spa Initial investment $(118,000) Het cash flows in 41,300 33,300 Year 1 Year 2 57,300 51,300 Year 3 81,595 67,300 Year 4. 91,700 73,300 Year 5 66,300 25,300 Compute the internal rate of return for each of the projects using excel functions. (Round your answers to 2 decimal places.) IRR % Pool Spa %

Exercise 24-22A (Algo) Using Excel to compute IRR LO P4 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. Pool $(173,000) spa Initial investment $(118,000) Het cash flows in 41,300 33,300 Year 1 Year 2 57,300 51,300 Year 3 81,595 67,300 Year 4. 91,700 73,300 Year 5 66,300 25,300 Compute the internal rate of return for each of the projects using excel functions. (Round your answers to 2 decimal places.) IRR % Pool Spa %

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Exercise 10-10A (Algo) Using the internal rate of return to compare investment opportunities LO 10-3 Velma and Keota (V&K) is a partnership that owns a small company. It is considering two alternative investment opportunities. The first investment opportunity will have a three-year useful life, will cost $6,328.24, and will generate expected cash inflows of $2,500 per year. The second investment is expected to have a useful life of four years, will cost $11,072.11, and will generate expected cash inflows of $3,800 per year, Assume that V&K has the funds available to accept only one of the opportunities. (PV of $1 and PVA of $1) (Use appropriate factor(s) from the tables provided.) Required a. Calculate the internal rate of return of each investment opportunity. (Do not round intermediate calculations.) b. Based on the internal rates of return, which opportunity should V&K select? Internal Rate of Return a. First investment Second investment b. V&K should select the
Question content area top Part 1 (Related to Checkpoint 6.6) (Present value of annuities and complex cash flows) You are given three investment alternatives to analyze. The cash flows from these three investments are as follows: Investment Alternatives End of Year A B C 1 $ 14,000 $ 14,000 2 14,000 3 14,000 4 14,000 5 14,000 $ 14,000 6 14,000 70,000 7 14,000 8 14,000 9 14,000 10 14,000 14,000 (Click on the icon in order to copy its contents into a spreadsheet.) Assuming an annual discount rate of 15 percent, find the present value of each investment. Question content area bottom Part 1 a. What is the present value of investment A at an annual discount rate of 15 percent?…
Question Four Two plants (A) and (B) are suggested to be constructed. Plant (A) with an investment of 105,000$, and Plant (B) with an investment of 25,000 $. End of year 0 1234 Plant (A) (103) Plant (B) (103) 105 25 35 10 35 10 35 10 35 10 35 10 5 a. The net present value at rate of 20 % (2 marks) b. The discounted cash flow rate of return (initial guess 20%). c. Which project you will select and justify your selection.
ic Yo NS io cer ist bun ngs nnée Current Attempt in Progress Blossom Manufacturing Co. is evaluating two projects. The company uses payback criteria of three years or less. Project A has a cost of $905,000, and project B's cost is $1,247,300. Cash flows from both projects are given in the following table. Year 1 2 3 4 Project A $86,212 313,562 427,594 285,552 Project B $586,212 413,277 231,199 What are their discounted payback periods? (Round answers to 2 decimal places, e.g. 15.25. If discounted payback period exceeds life of the project, enter 0.00 for the answer.) Discounted payback period of project A Discounted payback period of project B will he accepted with a discount rate of 8 percent? átv zoom
CENGAGE MINDTAP Week 6 Homework Your division is considering two projects with the following cash flows (in millions): 0 2 1 % Project A -$20 Project B -$13 a. What are the projects' NPVs assuming the WACC is 5%? Enter your answer in millions. For example, an answer of $10,550,000 should be entered as 10.55. Negative values, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to two decimal places. Project A: $ million million Project B: $ What are the projects' NPVs assuming the WACC is 10%? Enter your answer in millions. For example, an answer of $10,550,000 should be entered as 10.55. Negative values, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to two decimal places. Project A: $ million Project B: $ million What are the projects' NPVs assuming the WACC is 15%? Enter your answer in millions. For example, an answer of $10,550,000 should be entered as 10.55. Negative values,…
Question 3 You are working as a finance manager for Fire Fox Transport Ltd. The company is considering to invest in one of the two following projects to buy a new equipment for their storage which is expected to boost the company’s revenue. Each equipment will last 5 years and have no salvage value at the end. The company’s required rate of return for all investment projects is 9.5%. The cash flows of the projects are provided below. Equipment 1 Equipment 2 Cost $157,000 $182,000 Future Cash Flows Year 1 Year 2 Year 3 Year 4 Year 5 67 000 82 000 78 000 64 000 56 000 83 000 94 000 80 000 77 000 73 000 Required: Identify which option of equipment should the company accept based on Net Present Value (NPV) method? Identify which option of equipment should the company accept based on discounted pay back method if the payback criterion is maximum 3 years?
Alternative Capital Investments The investment committee of Sentry Insurance Co. is evaluating two projects, office expansion and upgrade to computer servers. The projects have different useful lives, but each requires an investment of $860,000. The estimated net cash flows from each project are as follows: Net Cash Flow Year OfficeExpansion Server 1 $240,000 $317,000 2 240,000 317,000 3 240,000 317,000 4 240,000 317,000 5 240,000 6 240,000 The committee has selected a rate of 15% for purposes of net present value analysis. It also estimates that the residual value at the end of each project's useful life is $0, but at the end of the fourth year, the office expansion's residual value would be $300,000. 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…
Pls fast pls dont usd chatgpt.Westchester Water Works Systems is considering a project that has the following cash flow and cost of capital data. What is the project's MIRR? Cost of capital: 10.00% Year 0 1 2 3 Cash flows -$1,000 $400 $400 $400 Potential answers: 10.35% 9.81% 9.32% 14.20% 12.78%
Question 1 You currently work at Happy home Construction company The government offered the company 4 projects to undertake in building houses Management is trying to select the best investment from among these alternative independent projects. Each alternative involves an initial outlay of $160,000 and a 10% cost of capital. Management requires that all project investments should be recovered in 4 years. Their cash flows are as follows: Year Kinstown St Christina St Thomp St Bess 1 60,000 40,000 41,000 0 2 50,000 60,000 41,000 60,000 3 40,000 0 41,000 0 4 30,000 40,000 41,000 56,000 5 20,000 20,000 41,000 50,000 6 8,000 60,000 0 80,000 1a. Calculate each project’s Payback Period. 1b. Based on the payback periods, which project(s) should they accept if the project(s) are independent. 1c. Which project(s) should they accept if the projects are mutually exclusive? PLEASE DO QUESTION 1…
Problem 13-21 Mr. John Backster, a retired executive, desires to invest a portion of his assets in rental property. He has narrowed his choices to two apartment complexes, Windy Acres and Hillcrest Apartments. The anticipated annual cash inflows from each are as follows: Windy Acres Yearly Aftertax Cash Inflow 20,000 25,000 40,000 55,000 60,000 Coefficient of Variation 0-0.35 0.35-0.40 0.40-0.50 Over 0.50 Probability 0.2 0.2 0.2 Windy Acres Hillcrest Apartments 0.2 0.2 Mr. Backster is likely to hold the apartment complex of his choice for about 20 years and will use this period for decision-making purposes. Either apartment can be purchased for $140,000. Mr. Backster uses a risk-adjusted discount rate approach when evaluating Investments. His scale is related to the coefficient of variation (for other types of investments, he also considers other measures). O Windy Acres O Hillcrest O Both O None Discount Rate 7% 10 14 not considered Hillcrest Apartments Yearly Aftertax Cash Inflow…
Exercise 10-10A (Algo) Using the internal rate of return to compare investment opportunities LO 10-3 Velma and Keota (V&K) is a partnership that owns a small company. It is considering two alternative investment opportunitles. The first Investment opportunity will have a five-year useful life, will cost $9,869.02, and will generate expected cash inflows of $3,300 per year. The second investment is expected to have a useful life of three years, will cost $8,703.98, and will generate expected cash inflows of $3.500 per year. Assume that V&K has the funds available to accept only one of the opportunities. (PV.of $1 and PVA of $1) (Use appropriate factor(s) from the tables provided.) Required o. Calculate the internal rate of return of each investment opportunity. (Do not round intermediate calculations.) b. Based on the internal rates of return, which opportunity should V&K select? Internal Rate of Return a First investment Second investmont bV&K should select the
Problem 5-29 Calculating Incremental Cash Flows Darin Clay, the CFO of MakeMoney.com, has to decide between the following two projects: Year Project Million Project Billion 0123 -$2,500 0-290 -$10 0+1,050 1.090 1.850 1,850 2,900 The expected rate of return for either of the two projects is 13 percent. What is the range of initial investment (0) for which Project Billion is more financially attractive than Project Million? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Initial investment less than