In: Finance
The table below offers EBIT for a potential capital investment for Fake Company Alpha. You should be able to determine a few things once you consider the following:
YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | |
EBIT | $(3,600) | $(2,725) | $1,875 | $5,000 |
What is this project's internal rate of return?
Time line | 0 | 1 | 2 | 3 | 4 | |
Cost of new machine | -12000 | |||||
=Initial Investment outlay | -12000 | |||||
EBIT= | -3600 | -2725 | 1875 | 5000 | ||
-taxes | =(Pretax cash flows)*(1-tax) | -2628 | -1989.25 | 1368.75 | 3650 | |
+Depreciation | 3000 | 3000 | 3000 | 3000 | ||
=after tax operating cash flow | 372 | 1010.75 | 4368.75 | 6650 | ||
+Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 2628 | ||||
+Tax shield on salvage book value | =Salvage value * tax rate | 0 | ||||
=Terminal year after tax cash flows | 2628 | |||||
Total Cash flow for the period | -12000 | 372 | 1010.75 | 4368.75 | 9278 | |
Discount factor= | (1+discount rate)^corresponding period | 1 | 1.066766 | 1.13799 | 1.2139692 | 1.2950212 |
Discounted CF= | Cashflow/discount factor | -12000 | 348.7175 | 888.1888 | 3598.7322 | 7164.3613 |
NPV= | Sum of discounted CF= | -0.000187444 | ||||
IRR is discount rate at which NPV = 0 = | 6.68% |