You've estimated the following cash flows (in $) for a project: A B 1 Year Cash flow 2 0 -5,100 3 1 1,325 4...
You've estimated the following cash flows (in $) for a project:
| A | B | |
| 1 | Year | Cash flow |
| 2 | 0 | -5,100 |
| 3 | 1 | 1,325 |
| 4 | 2 | 2,148 |
| 5 | 3 | 2,742 |
The required return for the project is 8%.
Part 1
What is the IRR for the project?
Homework Answers
IRR of the project is the rate for which the NPV of the project is zero
Method 1: IRR Calculation using Excel
IRR can be calculated using the IRR function in Excel as shown below:
=IRR(B2:B5) = 9.40070052%
Method 2: Using ba ii plus calculator
CF0 = -5100
C01 = 1325, F01 = 1
C02 = 2148, F02 = 1
C03 = 2742, F03 = 1
IRR -> CPT (Press IRR and then press CPT)
We get, IRR = 9.400700523
Answer -> IRR = 9.40% (Rounded to two decimal points)
Add Answer to:
You've estimated the following cash flows (in $) for a project: A B 1 Year Cash flow 2 0 -5,100 3 1 1,325 4...
A project has the following cash flows: year. Cash flow 0. $71,000 1. -50,000. 2. -29,200...
A project has the following cash flows: year. Cash flow 0. $71,000 1. -50,000. 2. -29,200 a. What is the IRR for the project? (Do not round intermediate calculations and enter answer as a percent round to 2 decimal places) b. What is the NPV of this project if the required return is 6 percent? c. What is the NPV of the project if the required return is 0 percent? d. What is the NPV of the project if the...
Filter Corp. has a project available with the following cash flows: Year Cash Flow 0 −$15,700...
Filter Corp. has a project available with the following cash flows: Year Cash Flow 0 −$15,700 1 5,100 2 6,400 3 5,800 4 4,200 What is the project's IRR? a. 14.32% b. 15.51% c. 15.91% d. 16.70% e. 14.91%
Your company has a project available with the following cash flows: Year. Cash Flow 0. $80,200...
Your company has a project available with the following cash flows: Year. Cash Flow 0. $80,200 1 21,950 2. 25,900 3. 31,700 4. 26,450 5. 20,700 If the required return is 16 percent, should the project be accepted based on the IRR? A. No, because the IRR is 17.75 Percent B. Yes, because the IRR is 18.90 Percent C. No, because the IRR is 18.90 Percent D. Yes, because the IRR is 17.45 Percent E. Yes, because the IRR is...
Vital Silence, Inc., has a project with the following cash flows: Year Cash Flow 0...
Vital Silence, Inc., has a project with the following cash flows: Year Cash Flow 0 –$ 27,400 1 11,400 2 14,400 3 10,400 The required return is 16 percent. What is the IRR for this project? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) IRR % Should the firm accept the project? Accept Reject
You've estimated the following cash flows (in $ million) for two mutually exclusive projects: Year Project A Project...
You've estimated the following cash flows (in $ million) for two mutually exclusive projects: Year Project A Project B 0 -28 -43 1 30 45 2 40 50 Part 1 What is the crossover rate, i.e., the discount rate at which both projects have the same NPV?
Filter Corp. has a project available with the following cash flows: Year 0 Cash Flow -$14,500...
Filter Corp. has a project available with the following cash flows: Year 0 Cash Flow -$14,500 6,100 7,400 5,100 4,700 What is the project's IRR?
A project has the following cash flows: Year Cash Flows 0 -2,500 1 750 2 800...
A project has the following cash flows: Year Cash Flows 0 -2,500 1 750 2 800 3 500 4 400 5 300 6 250 What is the Internal Rate of Return (IRR) of this project?
A project has the following cash flows: Year Cash Flow 0 $64,200 1 –30,200...
A project has the following cash flows: Year Cash Flow 0 $64,200 1 –30,200 2 –48,200 Required: (a) What is the IRR for this project? (Click to select)13.97%12.77%13.3%13.03%13.57% (b) What is the NPV of this project, if the required return is 11 percent? (Click to select)$-2,169.96$-2,042.31$2,127.41$-2,127.41$-2,233.78 (c) NPV at 0 percent? (Click to select)$-14,910.00$-14,200.00$-14,484.00$14,200.00$-13,632.00 (d) NPV at 22 percent? (Click to select)$7,203.38$-7,062.13$6,779.65$7,062.13$7,415.24
Intro You've estimated the following cash flows (in $ million) for two mutually exclusive projects: Year...
Intro You've estimated the following cash flows (in $ million) for two mutually exclusive projects: Year Project A Project B 0 -28 -43 1 30 45 2 40 50 Attempt 1/5 for 10 pts. Part 1 What is the crossover rate, i.e., the discount rate at which both projects have the same NPV? The crossover rate is the discount rate at which both projects have the same NPV: NPV(A) = NPV(B) ⇔ NPV(A) - NPV(B) = 0 ⇔ NPV(A-B) =...
Vital Silence, Inc., has a project with the following cash flows Year Cash Flow 0 28,600...
Vital Silence, Inc., has a project with the following cash flows Year Cash Flow 0 28,600 12,600 15,600 11,600 The required return is 14 percent. What is the IRR for this project? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) IRR Should the firm accept the project? O Accept ○ Reject References eBook & Resources Section: 5 Worksheet Difficulty: 1 Basic
Filter Corp. has a project available with the following cash flows: Year 0 Cash Flow -$14,500 6,100 7,400 5,100 4,700 What is the project's IRR?
Vital Silence, Inc., has a project with the following cash flows Year Cash Flow 0 28,600 12,600 15,600 11,600 The required return is 14 percent. What is the IRR for this project? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) IRR Should the firm accept the project? O Accept ○ Reject References eBook & Resources Section: 5 Worksheet Difficulty: 1 Basic
Most questions answered within 3 hours.
-
After watching the lectures I am still having a hard time
understanding these equations.
1. The...
asked 1 hour ago -
Testing:
H0:μ=56.9
H1:μ<56.9
Your sample consists of 23 subjects, with a mean of 56.3 and
standard...
asked 1 hour ago -
straight wire, labeled as Wire A, lies horizontally on a
tabletop and is oriented to run...
asked 1 hour ago -
For a Chi-Squared Goodness of Fit Test about a uniform
distribution, complete the table.
Round to...
asked 1 hour ago -
Milk of magnesia is only slightly soluble in water. Kc for the
reaction Mg(OHs)(s)>Mg2+(a) + 2OH-1(aq)...
asked 1 hour ago -
Excel's HYPGEOM.DIST function can be used to compute _____.
a. both hypergeometric probabilities and cumulative
hypergeometric...
asked 1 hour ago -
The rocket used for the human lunar missions was the Saturn V
rocket. At liftoff the...
asked 1 hour ago -
1. The East Street Bagel Shop has a weekly demand for 3,500
bagels, which they make...
asked 1 hour ago -
paraphrasing each paragraph
“Where two or more persons knowingly act together unlawfully,
the act of each...
asked 1 hour ago -
The lateral line system in fish is contained which of the
following?
chemoreceptors
photoreceptors
mechanoreceptors
odor...
asked 1 hour ago -
Find the y-intercept of y =-5 x. The y-intercept of y equals
negative 5 x is______...
asked 1 hour ago -
Customers arrive randomly at a gas station at the average rate
of 30 per hour, while...
asked 1 hour ago