Construction, Financial Model, Infrastructure, Renewable Energy

10-year Financial Projections, Amortization, Break-Even, Cash Flow Analysis, Cash Flow Projections, CFO, Dashboard, Debt Amortization, Debt Schedule, Debt Security, Debt Service Coverage, Financial Debt, Financial Feasibility, Financial Model, Financial Modeling, Financial Planning, Financial Projections, Financial Ratios, Financial Statements, Forecast, Forecasting, Income Statement, Investor Cash Flows, IRR (Internal Rate of Return), LLCR (Loan Life Coverage Ratio), Loans, Macros, NPV (Net Present Value), Payback Period, PLCR (Project Life Coverage Ratio), Project Finance, Project Management, Project Plan, Replacement Cost, Return on Invested Capital (ROIC), Return on Investment (ROI), Revenue Projections, Scenario Analysis, Sensitivity Analysis, Tax Assets, Three Statement Model | Three Financial Statements, WACC (Weighted Average Cost of Capital)

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

A special project vehicle SPV for an energy 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.
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.

File Types:

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

You must log in to submit a review.