Question

can someone show the work to this question

Roger has a levered cost of equity of 0.18. He is thinking of investing in a project with upfront costs of $8 million, which pays $1 million per year for the next 8 years. He is going to borrow $2 million to offset the startup costs at a rate of 0.08. His tax rate is 0.3. He will repay this loan at the end of the project. What is the NPV of this project, using the FTE method?

You Answered

Correct Answer

-4,134,468 margin of error +/- 10,000

Answer 1

The NPV is computed as shown below:

Net Initial investment is computed as follows:

= - upfront cost + loan amount

= - $ 8,000,000 + $ 2,000,000

= - $ 6,000,000

cash flow of each year from year 1 till year 7 is computed as follows:

= ($ 1,000,000 - Amount of loan x cost of loan) x (1 - tax rate)

= ($ 1,000,000 - $ 2,000,000 x 0.08) x (1 - 0.30)

= $ 840,000 x 0.70

= $ 588,000

Cash flow of year 8 is computed as follows:

= ($ 1,000,000 - Amount of loan x cost of loan) x (1 - tax rate) - loan repaid

= ($ 1,000,000 - $ 2,000,000 x 0.08) x (1 - 0.30) - $ 2,000,000

= $ 840,000 x 0.70 - $ 2,000,000

= $ 588,000 - $ 2,000,000

= - $ 1,412,000

So, the NPV will be as follows:

= Net initial investment + cash flow of year 1 / (1 + 0.18)¹ + cash flow of year 2 / (1 + 0.18)² + cash flow of year 3 / (1 + 0.18)³ + cash flow of year 4 / (1 + 0.18)⁴ + cash flow of year 5 / (1 + 0.18)⁵ + cash flow of year 6 / (1 + 0.18)⁶ + cash flow of year 7 / (1 + 0.18)⁷ + cash flow of year 8 / (1 + 0.18)⁸

= - $ 6,000,000 + $ 588,000 / 1.18¹ + $ 588,000 / 1.18² + $ 588,000 / 1.18³ + $ 588,000 / 1.18⁴ + $ 588,000 / 1.18⁵ + $ 588,000 / 1.18⁶ + $ 588,000 / 1.18⁷ - $ 1,412,000 / 1.18⁸

= - $ 4,134,468 Approximately

Feel free to ask in case of any query relating to this question