: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

Spreadsheet Link What is the IRR of the following project? Cash Flow Year 0 32.000 9,000 2 10,000 15,200 3. 4. 7,800 1) 10.8% 2) 11.2% • 3) 11.7% 4) 12.0% 5) 12.3%
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. Initial investment Net cash flown in Pool Spa Year 1 Year 2 IRR 41,100 57,100 81,395 91,500 66,100 Compute the internal rate of return for each of the projects using excel functions. (Round your answers to 2 decimal places.) Year 3 Year 4 Year 5 % Pool Spa $ (171,000) $ (116,000) % 33,100 51,100 67,100 73,100 25,100
Instruction: Use the table below to acquire information and answer the following questions. Please do not use signs like Rs., $, % etc in your answer. If you calculate percentage as 10.23% than answer must write like 10.23 only (do not write like 10.23% or 0.1023) Year 0 1 2 3 4 Cash flows −$950 $525 $485 $445 $405 Ms ABC is considering an opportunity of a new investment that has the following cash flow and weighted average cos of capital is 13 percent. What is the project's discounted payback in years? Answer should correct up to 2 decimal places. Ms ABC is considering an opportunity of a new investment that has the following cash flow and weighted average cos of capital is 13 percent. What is the project's net present value? Ms ABC is considering an opportunity of a new investment that has the following cash flow and weighted average cos of capital is 13 percent. What is the project's profitability index? Answer should correct up to 2…
n Ltd is considerinc X O VitalSource Bookshelf: Manageria X G Marian Ltd is considering two mu X ses/1155/quizzes/6003/take - LIBIS - Sampoerna... Dashboard A VitalSource Booksh... O Spotify - Web Player MLA For Show your computation Scooby Doo Ltd is considering two mutually-exclusive projects with the following details: Project A Initial investment is $450,000 Scrap value in year 5 is $20,000 Year: 1 3 4 5 Annual cash flows 200 150 150 55 100 ($000) Project B Initial investment $100,000 Scrap value in year 5 is $10,000 Year: 1 2 3 4 Annual cash flows ($000) 20 20 30 40 40 33%
Problem #2 - Chapter 13 – Preference Ranking for Investment Projects The management of Revco Products is exploring four different investment opportunities, Information on the four projects under study follows: Project C (450,000) 522,970 72,970 Project B (360,000) 433,400 73,400 Project A Description Investment Required ($) Present value of Cash Inflows ($) Net Present Value ($) Life of the Project (in years) Project D (270,000) 336,140 66,140 (480,000) 567,270 87,270 6 3 12 6 Internal Rate of Return (%) 18% 19% 14% 16% Because the company's required rate of return is 10%, a 10% discount rate has been used in the present value computations above. Limited funds are available for the investment, so the company cannot accept all the available projects. 1) Compute the project profitability index for each investment project. 2) Rank the four projects according to preference in terms of the following metrics: Net Present Value b. Project Profitability Index Internal Rate of Return a. c. 3)…
Calculate the internal rates of return of the following investment: Net investment -$1,100 Year 0 Net cash flows +6,500 Year 1 -11,400 Year 2 +6,000 Year 3 Round your answers to the nearest whole number and enter them in ascending order. IRR1: 0% IRR2: % IRR3: %
Saved A company is considering the following three Investment projects (Ignore income taxes.): Investment required Present value of cash inflows Project C $46,800 $ 51,948 Project D $ 53,300 $ 61,828 Project E $110,500 $ 120,445 Rank the projects according to the profitablity index, from most profitable to least profitable. Multiple Choice D. C. E C.E. D E. C. D E. D. C
Use python to answer the following question: Question 5 A capital investment in an equipment with an upfront cost of $23,540 will provide you with the following annual cash flow stream (paid end of year): 1. $2,000 2. $1,456 3. $3,230 4. $6,850 5. $2,384 6. $1,234 7. $5,987 8. $4,190 The project will incur the following cost for maintenance and repair (paid end of year): Year 3: ($2,984) Year 4: ($1,837) Year 6-8: ($2,000) Calculate the NPV of the investment and comment on whether you should invest in the project. Why or why not? What is the IRR of the investment? The required rate of return is 3.5%.
Consider projects A and B: Cash Flows (dollars) Project A Co -30,500 C1 C2 21,400 21,400 NPV at 11% +$6,148.00 B -50,500 33,500 33,500 + 6,869.53 a. Calculate IRRS for A and B. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Project A B IRR % % b. Which project does the IRR rule suggest is best? O Project A ○ Project B c. Which project is really best? ○ Project A O Project B k
Homework, Chapter 26 Average Rate of Return The following data are accumulated by Watershed Inc. in evaluating two competing capital investment proposals: Project A Project z Amount of investment $80,000 $92,000 Useful life 4 years 7 years Estimated residual value Estimated total income over the useful life $8,800 $27,370 Determine the expected average rate of return for each project. Round your answers to one decimal place. Project A Project z
es The management of Unter Corporation, an architectural design firm, is considering an investment with the following cash Year 1 Investment $ 68,000 $8,000 Cash Inflow $7,000 $ 14,000 2 $ 21,000 3 4 5 6 7 8 9 10 $ 22,000 $ 25,000 $ 23,000 $ 21,000 $ 19,000 $ 18,000 $ 18,000 Required: 1. Determine the payback period of the investment. 2. Would the payback period be affected if the cash inflow in the last year were several times as large? Complete this question by entering your answers in the tabs below. Saved Required 1 Required 2 Determine the payback period of the investment. Note: Round your answer to 1 decimal place. Payback period years
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 $ 20,000 $ 20,000 2 20,000 3 20,000 4 20,000 5 20,000 $ 20,000 6 20,000 100,000 7 20,000 8 20,000 9 20,000 10 20,000 20,000 (Click on the icon in order to copy its contents into a spreadsheet.) Assuming an annual discount rate of 23 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 23…