In: Finance
Roger has a levered cost of equity of 0.15. He is thinking of investing in a project with upfront costs of $9 million, which pays $3 million per year for the next 7 years. He is going to borrow $1 million to offset the startup costs at a rate of 0.05. His tax rate is 0.4. He will repay this loan at the end of the project. What is the NPV of this project, using the FTE method?
| 
Given, Cost of the equity(CE) =
0.15 Cost of the Debt(CD) = 0.05 Tax Rate = 40% Total cost for the project is $ 9 Million. Of these, $ 1 Million is funded with borrowed funds and $ 8 Million is funded with Own funds. Annual cash inflow is $ 3 Million. Annual interest Payment is $ 1 Million * 0.05 = $50000. Interest payment of $50000 is eligible for tax deduction Weighted average cost of capital = CD*(1-Tax rate)*Debt funds/Total funds + CE * Own funds/ total funds = 0.05*(1-0.4)*$1M/$9M + 0.15*$8M/$9M = 0.0033 + 0.1333 = 0.1366 (or) 13.66%  | 
| Calculation of Net Present Value of the Project | ||||||||
| Year | Particulars | A | B | (C=A-B) | D | E=C-D | F | E*F | 
| Cash Inflow/(Outflow) | Interest Paid | Net Cash Inflow(A-B) | Tax Paid @ 40% | Net cash flow after tax | Present Value annuity Factory @ 13.66 | PV of cash flow | ||
| 0 | Intial Cash outflow | -$ 90,00,000 | - | -$ 90,00,000 | - | -$ 90,00,000 | 1.0000 | -$ 90,00,000 | 
| 1 | Cash inflow | $ 30,00,000 | $ 50,000 | $ 29,50,000 | $ 11,80,000 | $ 17,70,000 | 0.8798 | $ 15,57,276 | 
| 2 | Cash inflow | $ 30,00,000 | $ 50,000 | $ 29,50,000 | $ 11,80,000 | $ 17,70,000 | 0.7741 | $ 13,70,118 | 
| 3 | Cash inflow | $ 30,00,000 | $ 50,000 | $ 29,50,000 | $ 11,80,000 | $ 17,70,000 | 0.6810 | $ 12,05,453 | 
| 4 | Cash inflow | $ 30,00,000 | $ 50,000 | $ 29,50,000 | $ 11,80,000 | $ 17,70,000 | 0.5992 | $ 10,60,578 | 
| 5 | Cash inflow | $ 30,00,000 | $ 50,000 | $ 29,50,000 | $ 11,80,000 | $ 17,70,000 | 0.5272 | $ 9,33,115 | 
| 6 | Cash inflow | $ 30,00,000 | $ 50,000 | $ 29,50,000 | $ 11,80,000 | $ 17,70,000 | 0.4638 | $ 8,20,970 | 
| 7 | Cash inflow | $ 30,00,000 | $ 50,000 | $ 29,50,000 | $ 11,80,000 | $ 17,70,000 | 0.4081 | $ 7,22,303 | 
| 7 | Loan repayment | -$ 10,00,000 | - | -$ 10,00,000 | - | -$ 10,00,000 | 0.4081 | -$ 4,08,081 | 
| Net Present Value | -$ 17,38,268 |