?IRR, investment? life, and cash inflows??? Oak Enterprises accepts projects ear

Question

?IRR, investment? life, and cash inflows???

Oak Enterprises accepts projects earning more than the? firm's 12% cost of capital. Oak is currently considering a 10 year project that provides annual cash inflows of ?$50,000 and requires an initial investment of $315,100.

? (?Note:All amounts are after? taxes.)

a.??Determine the IRR of this project. Is it? acceptable?

b.??Assuming that the cash inflows continue to be ?$50,000 per? year, how many additional years would the flows have to continue to make the project acceptable? (that is, to make it have an IRR of 12?%)?

c.??With the given? life, initial? investment, and cost of? capital, what is the minimum annual cash inflow that the firm should? accept?

Explanation / Answer

a.

Use IRR function in Excel

IRR = 9.42%

b. FV = 0, PMT = 50,000, PV = -315,100, rate = 12%

use Nper function in Excel

number of years = 12.46

c, PV = -315,100, rate = 12%, N = 10 FV = 0

use PMT function in Excel

minimum payments = 55,767.71

Cash flows Year        (315,100.000) 0            50,000.000 1            50,000.000 2            50,000.000 3            50,000.000 4            50,000.000 5            50,000.000 6            50,000.000 7            50,000.000 8            50,000.000 9            50,000.000 10

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.