Highway Project Finance Excel Model

Description
An infrastructure model that incorporates the following (built using FAST standard):


A special project vehicle SPV for a highway project. The model covers a period of 10 years. This model can be updated, adjusted to reflect agreed terms with lenders and investors.


Project finance is the funding (financing) of long-term infrastructure, industrial projects, and public services using a non-recourse or limited recourse financial structure. The debt and equity used to finance the project are paid back from the cash flow generated by the project.


a. Well structured inputs that can be updated and changed.
b. Project Timing (financial close, construction, delay and operations)
c. Two funding Tranches with different repayment profiles (sculpted, principal repayment & annuity).
d. Equity funding (prorata and upfront draw option)
e. Moratorium period, interest during construction and debt service reserve account (DSRA).
f. Tax computation, capital allowance and depreciation.
g. Monthly calculation and consolidated monthly financial, quarterly financial and annual financial.
h. Investment evaluation using DSCR, NPV, IRR and Break-even.
i. Automated macro (excel vba) to avoid circularity in the model.
j. Model balance check.k. Purchasing power parity on the exchange rate