Solar Project Financial Excel Model

Description
The financial model has different tabs which contain calculations to compute NPV and IRR of the project. Summary output of the model is shown in first 6 rows of the Assumptions tab.

The assumption tab has various inputs related to the project/ The assumptions have been categorised into different categories. The categories include Revenue Assumptions like tariff, duration, merchant tariff; macros like interest rate, inflation, tax rate etc; Generation Assumptions like Gross Energy Yield, panel degradation, losses etc, operational expenses like fixed overhead, administrative & legal expenses etc; and funding assumptions like ratio of equity funding, debt funding etc. All the assumptions are in yellow cells.

The tabs for Income Statement, Balance Sheet and Cash Flow Statement tabs are for yearwise projected financial statements for the life of the project.

Schedules tab calculates various items required for financial statements like yearwise capex, depreciation, operational expenses, generation of electricity , forecast revenue etc.

Investor Returns and Investment Analysis tabs show the cash flows, IRR, NPV and yearwise projected financial ratios of the project.This tab also contains different charts and graphs.

Graphs and charts tab visualize important financial and operational KPIs and Market Prices Forecast tab shows forecast price of electricity from different sources.