This project is meant to two students in two separate teams.

We are looking for a student with a financial analysis or financial modelling background. Someone who is very comfortable with making and reviewing a model of a business interested in leasing equipment. Our end goal is to create a model to show to bankers and possible investors that provides profitability for us as well as all other partners involved.

You will be given an initial model to modify and tweak as appropriate for our industry.

We are trying to build a portfolio of solar projects that can then be securitized together to be financed at better interest rates. We are already speaking with a bank interested in providing us with a revolving credit facility if we can show a pipeline of projects to be built in the next 24 months that create a portfolio $2 million+ in size.

You will modify, update and error correct the excel spreadsheet given to you in order to make it applicable for solar projects. Modify this spreadsheet so it may function based on a number of line items given for a specific cost per watt. Further edit the spreadsheet so the number of years of the agreement and amortization can be changed. Have the spreadsheet identify the LCOE and monthly payments based off given variables for $/watt CAPEX, DSCR, debt interest rates and the fact that revenue is generated by two income streams, one of which is for the O&M beginning in year 10 of the agreement. Include the ability to factor in generation losses over time. Provide analysis of savings of switching to onsite generated solar energy vs paying the utility for electricity with it increasing by 2.5% each year. We will be providing you data provided to us by multiple banks we have been in contact with in order to ensure the modelling outputs are relevant.