I want to develop an Excel file that will allow users to enter various inputs. Using these inputs calculate the relative attractiveness of using various investments methods. Specifically, there are four different ways to finance a solar energy system for the home. These are a) using cash; b) a solar lease; c) a solar power purchase agreement; and d) a solar loan. Each option has benefits and weak points. I would like to create a simple type of "solar calculator"that will give outputs and then give the reader various conclusions.
Functionally, this is what I want. I’ll provide the data on the cost of electricity and every other assumption that is blank now.
Part a: Develop the model. Visitors will input a set type of criteria;
[login to view URL] the state where the visitor lives. The model will cover all 50 states. US territories, Canada and Mexico are not covered.
[login to view URL] and record the answer for the following question: Is your house.
[login to view URL] sunny
[login to view URL] sunny
[login to view URL] usually sunny
[login to view URL] on the state, the model will provide an average cost of a kilowatt hour of electricity. I will provide you with this information in table form.
[login to view URL], it will provide a 10-yr rate of electricity price escalation expressed as a percent.
[login to view URL]: “In New Jersey, the average household uses ____ kilowatt hours per month, or ____ kilowatt hours per year. The average kilowatt hour costs ____ . A typical monthly bill is ____. The typical annual expense is _____. Your usage could be more or less depending on the number of members of your house hold and your lifestyle.
[login to view URL] options. Ask the homeowner to select from one of three options:
[login to view URL] lease or solar PPA. These are very similar options
[login to view URL]
c. Purchase the system with cash.
7. If #6 is “a”, give the homeowner a rundown of the return on investment. “A solar lease can save you 5-40% off the price of electricity with zero investment”
8. With a loan, use the interest rate to calculate monthly payments. Create a cashflow chart that shows outflow and inflow of cash. Also produce a visual graphic interpretation of this cash flow. Calculate IRR and ROI
9. Just as in #8, Do the same for a cash purchase.
This Excel file will be used in a subsequent project. I will develop a website that will get visitor input into the model and then give the visitor the output. So I ask the Excel developer to consider the inputs and outputs to be co-located on the same page. Thank you.