Question
only questions 3 & 5 please odd only
(Internal Rate of Return) Calculate the projects internal rate of return. An initial cash outflow of $6,235 and a free cash
0 0
Add a comment Improve this question Transcribed image text
Answer #1

3). Answer 1 7125 23 71257125 5 5 71257125 6 8 9 10 71257125712571257125 Part (36) Part (3a) Part (3) Year (n) Cash flow (FCF) IR

(Solved using IRR function with given cash flows)

3d). IRR = [(1,125/6,235)^(1/5)] -1 = -29.00%

Answer 0 -6235 -21.91% 0 1 0 2 0 3 4 11250 5 1125 Year (n) Cash flow (FCF) IRR Year (n) Cash flow (FCF) IRR Part (3e) & (3) A

5a).

Formula Year (n) Cash flow (CF) Cumulative cash flow (CCF) Payback period in years) 01 -5275 -5275 2.48 1 2 125 -3150 2 2125

5b & c).

Formula 6 Year (n) Cash flow (CF) 0 -5275 1 2125 2 2125 3 2125 4 2125 5 2125 2125 7 2125 Using NPV function with CFs & 10% di

5d). The project should be accepted as it has a positive NPV and an IRR much greater than the required return of 10%, so it will yield profits.

Add a comment
Know the answer?
Add Answer to:
only questions 3 & 5 please odd only (Internal Rate of Return) Calculate the project's internal...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 17. Paybag and ex requin Fr 18. d. AD 239 CHAPTER 10 d. A project with...

    17. Paybag and ex requin Fr 18. d. AD 239 CHAPTER 10 d. A project with an initial out of 5.000 rewas in a singde free cash years 13. (Payback) Determine each project's payback period: A project with an initial outlay of $10,000 results in a single free cash flow of $3.000 end of each year for 5 years b. A project with an initial outlay of $10,000 results in a single free cash flow of 5.000 end of each...

  • 15. (Net Present Value) Calculate the project's net present value. The cost of capital is 10%....

    15. (Net Present Value) Calculate the project's net present value. The cost of capital is 10%. An initial cash outflow of $6,235 and a free cash flow of $7,125 in 5 years. b. An initial cash outflow of $6,235 and a free cash flow of $7,125 in 3 years An initial cash outflow of $6,235 and a free cash flow of $7,125 in 10 years An initial cash outflow of $6,235 and a free cash flow of $1,125 at the...

  • IRR A project's internal rate of return (IRR) is the -Select- The IRR is an estimate...

    IRR A project's internal rate of return (IRR) is the -Select- The IRR is an estimate of the project's rate of return, and it is comparable to the -Select-on a bond. The equation for calculating the IRR is: ;that forces the PV of its inflows to equal its cost. CF2 CFN 1 IRF 1 IRF 1IR CFt t-1 (1 +IRR) CFt is the expected cash flow in Period t and cash outflows are treated as negative cash flows. There must...

  • The internal rate of return (IRR) is a capital budgeting project's expected return. Which of the...

    The internal rate of return (IRR) is a capital budgeting project's expected return. Which of the following statements about the IRR method is true? Because of the uncertainty connected with risky cash flows, the realized return will almost surely be different from the IRR. Decision rule for IRR: undertake the capital budgeting project only if the IRR equals r, the project's cost of capital. If the cost of capital (required return) equals the IRR (expected return), the NPV is greater...

  • What is the internal rate of return (IRR) of a project with an initial outlay of...

    What is the internal rate of return (IRR) of a project with an initial outlay of $10,000, resulting in a free cash flow of $2,055 at the end of each year for the next 18 years? Please provide your submission in only MS Excel, identifying the IRR as a percent. Ensure that your IRR percentage is rounded to two decimal places.

  • udicates problems in Excel Study Problems All Study Problems are available in MyLab Finance. The X...

    udicates problems in Excel Study Problems All Study Problems are available in MyLab Finance. The X icon indicates problems Mylab format available in MyLab Finance. LO2 10-1. (Payback Period) What is the payback period for the following set of cash flowe YEAR CASH FLOWS --- $11,300 3,400 4,300 3,600 4,500 3,500 x 10-2. (IRR calculation) Determine the IRR on the following projects: a. An initial outlay of $10,000 resulting in a single free cash flow of $17,182 after 8 years...

  • 3. Understanding the IRR and NPV The net present value (NPV) and internal rate of return...

    3. Understanding the IRR and NPV The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting decisions. Consider the case of Blue Hamster Manufacturing Inc.: Last Tuesday, Blue Hamster Manufacturing Inc. lost a portion of its planning and financial data when both its main and its backup servers crashed. The company's CFO remembers that the internal rate of return (IRR) of Project Zeta is...

  • 3. Understanding the IRR and NPV The net present value (NPV) and internal rate of return...

    3. Understanding the IRR and NPV The net present value (NPV) and internal rate of return (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting decisions. Consider the case of Cute Camel Woodcraft Company: Last Tuesday, Cute Camel Woodcraft Company lost a portion of its planning and financial data when both its main and its backup servers crashed. The company's CFO remembers that the internal rate of return (IRR) of Project Lambda is...

  • 5. ULJI,123 dl the end of the next 3 years (Payback period, IRR, & NPV) You...

    5. ULJI,123 dl the end of the next 3 years (Payback period, IRR, & NPV) You are considering a project with an initial cash outlay of $5,213, and expect to receive free cash flows $2,125 at the end of each year for the next 7 years. If required rate of return is 10%, what is the firm's a. Payback period? b. NPV? c. IRR? d. Should this project be accepted? (use answers to parts b and c)

  • Given the following​ after-tax cash flow on a new toy for​ Tyler's Toys, find the​ project's...

    Given the following​ after-tax cash flow on a new toy for​ Tyler's Toys, find the​ project's payback​ period, NPV, and IRR. The appropriate discount rate for the project is 9​%. If the cutoff period is 6 years for major​ projects, determine whether management will accept or reject the project under the three different decision models. Initial cash​ outflow: ​$12,800,000 Years one through four cash​ inflow: ​$3,200,000 each year Year five cash​ outflow: ​$1,280,000 Years six through eight cash​ inflow: ​$548,667...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT