Project Finance Model for a Highway SPV Project

Construction, Financial Model, Infrastructure

10-year Financial Projections, Amortization, Break-Even, Cash Flow Analysis, Cash Flow Projections, CFO, Dashboard, Debt Amortization, Debt Schedule, Debt Security, Debt Service Coverage, Developers, Discount Rate, Excel, Financial Analysis, Financial Debt, Financial Model, Financial Modeling, Financial Projections, Financing, Income Statement, Investment Multiple, Investor Cash Flows, IRR (Internal Rate of Return), KPIs (Key Performance Indicators), Levered Yield, LLCR (Loan Life Coverage Ratio), Loans, Macros, NPV (Net Present Value), Payback Period, PLCR (Project Life Coverage Ratio), Project Finance, Project Plan, Return on Invested Capital (ROIC), Return on Investment (ROI), Revenue Projections, Scenario Analysis, Sensitivity Analysis, WACC (Weighted Average Cost of Capital)

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 and 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

File Types:

1 Excel Model – .xlsm
1 Macro Documentation – .pdf

You must log in to submit a review.