Build a financial model

a) prepare an Excel Financial Model
The Financial model should include at the minimum the following components,
which reflect the different stages of the lifecycle of the project [they may be
presented in either the same “excel tab” or separate “excel tab”]:

i) Projection of Capital Expenditures (Capex) during the development phase
including, among others, costs for planning & design, construction work,
procurement and installation of equipment etc.
ii) Projection of Revenues during the operations phase, including, among
others, projection of volumes of output and expected prices of output
sold.
iii) Projection of Operating Expenses (Opex) during the operations phase,
including, among, costs for raw materials used in the production,
Operations & Maintenance (O&M), personnel (HR), Legal & Acc,
Depreciation of capex and capitalized interest, where applicable.
iv) Projection of all Financing cash-flows from all sources of funding the
project, including, Equity financing, Debt financing, Grants from the public
sector and VAT facilities, if applicable.
v) Draft projected Profit & Loss and Cash-flow statements including;
a. Calculation of Operating Cash-flow (Gross)
b. Calculation of Unlevered Cash-flow (Net)
c. Calculation of Levered Cash-flow (after adjusting for all debt financing
Cash-flows)
vi) Calculate relevant metrics that evaluate the financial sustainability of the
project for the financiers and in particular for Equity sponsors of the
project;
a. Project [Unlevered] IRR – relevant to all financiers
b. Dividend payout to Equity shareholders
c. Levered IRR