Em Andamento

Excel solar investment model

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;

[url removed, login to view] the state where the visitor lives. The model will cover all 50 states. US territories, Canada and Mexico are not covered.

[url removed, login to view] and record the answer for the following question: Is your house.

[url removed, login to view] sunny

[url removed, login to view] sunny

[url removed, login to view] usually sunny

[url removed, login to view] 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.

[url removed, login to view], it will provide a 10-yr rate of electricity price escalation expressed as a percent.

[url removed, login to view]: “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.

[url removed, login to view] options. Ask the homeowner to select from one of three options:

[url removed, login to view] lease or solar PPA. These are very similar options

[url removed, login to view]

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.

Habilidades: Excel, Planejamento Financeiro

Ver mais: what is cost flow, website cost in canada, three d model, solar system website, solar system data, i want to develop a website where can i, excel form to enter data, excel energy, developer cost per hour, data solar system, create a table chart, cost flow model, cost flow chart, all points covered, 2 d model, excel macros vendor, excel seller net calculations formulas, property investment modelling excel, use google finance formulas excel, use latex render formulas, excel use web service vbnet sample, use vendor virtuemart, chart excel use comparison buying versus renting

Acerca do Empregador:
( 7 comentários ) Pennington, United States

ID do Projeto: #8156675