In: Finance
The table below offers EBIT for a potential capital investment for Fake Company Zeta. (This same project will be used for all of your FMC #3 work.) You should be able to determine a few things once you consider the following:
YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | |
EBIT | $(1,750) | $325 | $1,025 | $3,700 |
What is this project's internal rate of return?
Time line | 0 | 1 | 2 | 3 | 4 | |
Cost of new machine | -20000 | |||||
=Initial Investment outlay | -20000 | |||||
=Pretax cash flows | -1750 | 325 | 1025 | 3700 | ||
-taxes | =(Pretax cash flows)*(1-tax) | -1225 | 227.5 | 717.5 | 2590 | |
+Depreciation | 5000 | 5000 | 5000 | 5000 | ||
=after tax operating cash flow | 3775 | 5227.5 | 5717.5 | 7590 | ||
+Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 4200 | ||||
+Tax shield on salvage book value | =Salvage value * tax rate | 0 | ||||
=Terminal year after tax cash flows | 4200 | |||||
Total Cash flow for the period | -20000 | 3775 | 5227.5 | 5717.5 | 11790 | |
Discount factor= | (1+discount rate)^corresponding period | 1 | 1.101939809 | 1.21427134 | 1.33805393 | 1.47445489 |
Discounted CF= | Cashflow/discount factor | -20000 | 3425.776951 | 4305.05095 | 4272.99667 | 7996.17543 |
NPV= | Sum of discounted CF= | 5.78843E-06 | ||||
IRR is discount rate at which NPV = 0 = | 10.19% |