Internal Rate of Return (IRR): It is the rate at which the NPV of the project is 0 or we can say that IRR is the rate of return at which the project is at breakeven. IRR is calculated using excel or approximation method. To calculate: The Estimated IRR based on NPVs at different rates.

Question

Want to see the full answer?

Answer 1

Question

Chapter 11, Problem 1.5GBP

To determine

Concept introduction:

Internal Rate of Return (IRR): It is the rate at which the NPV of the project is 0 or we can say that IRR is the rate of return at which the project is at breakeven. IRR is calculated using excel or approximation method.

To calculate:

The Estimated IRR based on NPVs at different rates.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

A company is considering three alternative Investment projects with different net cash flows. The present value of net cash flows is calculated using Excel and the results follow. Potential Projects Present value of net cash flows (excluding initial investment) Initial investment Complete this question by entering your answers in the tabs below. a. Compute the net present value of each project. b. If the company accepts all positive net present value projects, which of these will It accept? c. If the company can choose only one project, which will it choose on the basis of net present value? Required A Required B Compute the net present value of each project. Potential Projects Project A Present value of net cash flows Initial investment Net present value Required C Project E Project C $10,685 (10,000)

Use the information provided to answer the questions.Use the information provided below to calculate the following. Where applicable, use the presentvalue tables provided in APPENDICES 1 and 2 that appear after QUESTION 5. QUESTION) Calculate the Accounting Rate of Return (on average investment) of Project B (expressed to twodecimal places). INFORMATION Zeda Enterprises has the option to invest in machinery in projects A and B but finance is only available to invest inone of them. You are given the following projected data:Project A Project BInitial cost R300 000 R300 000Scrap value R40 000 0Depreciation per year R52 000 R60 000Net profitYear 1 R20 000Year 2 R30 000Year 3 R50 000Year 4 R60 000Year 5 R10 000Net cash flowsYear 1 R90 000Year 2 R90 000Year 3 R90 000Year 4 R90 000Year 5 R90 000 Additional informationThe discount rate used by the company is 12%. Transcribed Image Text:Number of Periods 1 2 3 4 5 6 7 8 m 10 11 12 13 14 15 1% 2% 0.9901 0.9804 0.9709 3% 3.9020 3.8077…

You are analyzing a project and have prepared the following data: a. Based on the net present value of this project, should you reject or accept this project? (Please provide the formulas for calculation or the keys applied if a financial calculator is used) b. What is the internal rate of return (IRR) of this project? Should you reject or accept this project? (Please use a financial calculator and list the keys you use)