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?

Answer 1

a.

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

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