Valuation

Assume company has a 10% after tax discount rate

Calculate the 20 years after tax NPV

What is your recommended purchase price? (input acquisition price on cell D9 of inputs tab. This should populate the rest of the model)

What is the NPV after accounting for the acquisition price?

What is the IRR with the recommended purchase price?

What is the simple payback with the recommended purchase price?

What is the discounted payback with the recommended purchase price?

Do you have any comments on these results?

Valuation after value added changes

The model is based on current tariff and current performance. With due diligence and negotiation, the assumptions will change.

If you could change up to 5 assumptions that would impact the value of the asset, what would they be and why? You may modify any of the tabs as required to modify the assumptions. You may send back a 2nd excel file with modified assumptions.

With the updated assumptions, what is your recommended purchase price? (input revised acquisition price on cell D9 of inputs tab, input acquisition price on cell D9 of inputs tab. This should populate the rest of the model)

What is the NPV after accounting for the acquisition price?

What is the IRR with the recommended purchase price?

What is the simple payback with the recommended purchase price?

What is the discounted payback with the recommended purchase price?

Do you have any comments on these results?

Please submit 2 excel sheets, one for the valuation and the other one is for the valuation after value added changes

please make sure to show all excel equations and calculations.