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