Based on the cash flows shown in the chart below, compute the IRR and MIRR for Project
Fantastic news! We've Found the answer you've been seeking!
Question:
- Based on the cash flows shown in the chart below, compute the IRR and MIRR for Project Erie. Suppose that the appropriate cost of capital is 12 percent. Advise the organization about whether it should accept or reject the project.
also calculate VPN .
Transcribed Image Text:
17 18 19 20 21 22 23 24 25 26 27 28 A Based on the cash flows shown in the chart below, compute the IRR and MIRR for Project Erie. Suppose that the appropriate cost of capital is 12 percent. Advise the organization about whether it should accept or reject the project. B IRR = CFn/(1+ IRR)^n Excel formula: =IRR(values) Note: must include a positive and negative input MIRR Excel formula: =MIRR(values, finance_rate, reinvest_rate) Notes: IRR will equal the expected rate of return; compare against cost of capital (aka required rate of return). If IRR is greater than or equal to cost of capital, accept the project. We only want to invest in projects where the rate we expect to get (IRR) is larger than the rate investors require (i) based on the project's expected return, including risk (Cornett et al., 2019). Recommendation: This project should be rejected. The IRR and MIRR both fall below the 12% cost of capital and would not be worth the investment. Discount Rate (i) Period 0 1 2 3 4 5 NPV D Cash Flow IRR MIRR 12% -12000 2360 4390 1520 980 1250 E 1.12 ($3,979.18) -5.2% 3.33% 17 18 19 20 21 22 23 24 25 26 27 28 A Based on the cash flows shown in the chart below, compute the IRR and MIRR for Project Erie. Suppose that the appropriate cost of capital is 12 percent. Advise the organization about whether it should accept or reject the project. B IRR = CFn/(1+ IRR)^n Excel formula: =IRR(values) Note: must include a positive and negative input MIRR Excel formula: =MIRR(values, finance_rate, reinvest_rate) Notes: IRR will equal the expected rate of return; compare against cost of capital (aka required rate of return). If IRR is greater than or equal to cost of capital, accept the project. We only want to invest in projects where the rate we expect to get (IRR) is larger than the rate investors require (i) based on the project's expected return, including risk (Cornett et al., 2019). Recommendation: This project should be rejected. The IRR and MIRR both fall below the 12% cost of capital and would not be worth the investment. Discount Rate (i) Period 0 1 2 3 4 5 NPV D Cash Flow IRR MIRR 12% -12000 2360 4390 1520 980 1250 E 1.12 ($3,979.18) -5.2% 3.33%
Expert Answer:
Answer rating: 100% (QA)
Solution Based on the cash flows provided the IRR for Project Erie can be calculated using the formu... View the full answer
Related Book For
Introduction To Corporate Finance
ISBN: 9781118300763
3rd Edition
Authors: Laurence Booth, Sean Cleary
Posted Date:
Students also viewed these finance questions
-
In the Federal Reserve Bank of Atlanta, Working Paper Series (October 2008), researchers presented a novel approach to identifying firms that discriminate against women. The researchers used the...
-
The Taylor polynomial for sin(x) for a near 0 to order 5 is 1 1 sin(x) = x - + -x +0(x7) 6 120 The figure below shows a plot of sin(x) [blue] and the above Taylor polynomial [red]. 0.8 0.6 0.4 0.2 1...
-
A clinical study is established to determine if the results of a screening stress test can be used as a predictor of the presence of heart disease. The study enrolls 100 participants who undergo a...
-
Tyson Chandler Company's sales budget projects unit sales of part 198Z of 10,000 units in January, 12,000 units in February, and 13,000 units in March. Each unit of part 198Z requires 2 kg of...
-
While standing at the edge of the roof of a building, a man throws a stone upward with an initial speed of 6.31 m/s. The stone subsequently falls to the ground, which is 16.9 m below the point where...
-
A laminated plate consisting of the [90/0/90] \(]_{\mathrm{s}} \mathrm{AS} / 3501\) laminate described in Example 7.13 has a central hole, as shown in Figure 9.28. The plate is loaded uniaxially...
-
The International Ethics Standards Board for Accountants (IESBA) Handbook of the Code of Ethics for Professional Accountants is available for free download from the IFAC website (www.ifac.org)....
-
Basic Home Care sells two-year warranty plans for home repairs, paid in cash in advance. On January 2, of the current year, 160 warranty plans were sold for $700 each. What would be the adjusting...
-
The April 30, 2020, bank statement for Comet Company showed a cash balance of $7,582. The Cash account in the companys general ledger (G/L), according to the companys records on April 30, had a...
-
Climate change and health are inextricably linked. Discuss the impacts of climate change on health, and the key policies designed to mitigate the impacts. Discuss how health economic evidence can be...
-
JD is playing with some clay (mass = 18-g). He flings it across the room, where it lodges on the hood of a 241-g toy car that can freely roll back. Once in motion, the clay/car combination moves with...
-
What are the socio-ecological implications of ecosystem degradation and biodiversity loss, and how can collaborative governance approaches be leveraged to promote sustainable resource use and...
-
Martin is offered an investment where for $4,500 today, he will receive $4,680 in one year. He decides to borrow $4,500 from the bank to make this investment. What is the maximum interest rate the...
-
What is the function of registers in the fetch-execute instruction cycle? What is the purpose of the instruction register? Q.9 Define the terms: Master slave multiprocessing Symmetrical...
-
172.Sharma Company's balance sheet reflects total assets of $250,000 and total liabilities of $150,000. Calculate the company's debt-to-equity ratio. 173.On October 1 of the current year a...
-
Sigma Limited has 500 kg of material X in stock for which it paid Rs. 2,000. The material is no longer in use in the company and could be sold for Rs. 1.50 per kg. Sigma Limited is considering taking...
-
Let (X. A. p) be a measure space. Show that for any A,B A, we have the equality: (AUB)+(An B) = (A) + (B).
-
You have just been to see your broker at Acclaim Capital Inc. for advice about investing in the Empire Bank. The broker indicates that the Empire Bank has three different types of securities: debt,...
-
Other candy-making firms have an average forward P/E ratio of 12 at this time. With a share price of $18.20, what are the expected 2013 EPS for Corines Candies if its forward P/E ratio is the same as...
-
Describe the purchase method in accounting for acquisitions.
-
What is the direction of the magnetic field at a point vertically (a) above (b) below segment 1 in Figure 28.5? Figure 28.5 Mapping the magnetic field of a current loop. The magnetic field...
-
Make a sketch showing the directions of the magnetic forces exerted on each other by (a) an electron moving in the same direction as the current through a wire, (b) a moving charged particle and a...
-
As the current loop in Figure 28.10 rotates over the first \(90^{\circ}\), do the magnitudes of (a) the magnetic force exerted on the horizontal sides and (b) the torque caused by these forces...
Study smarter with the SolutionInn App