The figures in the yellow fields are suggestions only. You can enter your own data. Explanations can be found below.* If the calculator spreadsheet is not showing, please try with another internet browser.*

More calculators can be found here: http://www.environment.nsw.gov.au/business/solar-calculators.htm

#### Investing in a domestic solar PV system in Australia has become a positive financial investment in most cases.

Unfortunately most installers, consultants and websites only supply the **payback time **(also called ‘payback period’ or just ‘payback’) to describe the financial situation. *(Some call this even ROI, which is wrong, because ROI is used in finance calculations as ‘Return on Investment’ and delivers % as result.) *But for other investments like savings accounts, real estate or term deposits, a payback time is usually not given. This means that there is no direct way for comparing a solar investment to any other investment. And this is an important disadvantage for investments in solar PV.

However investment in solar technology can be seen like any other financial investment. The payback time has to be converted into a **comparison rate**. The simple spreadsheet below allows the conversion of the payback time into the comparison rate.

The **comparison rate** is a term defined for home loans by the Australian Government and must be given with all domestic home loan products. However the calculation works both ways. In case of solar PV the owner is the ‘bank’ and will receive his ‘payments’ either from savings on grid demand or from an existing feed-in tariff or from a combination of both.

**comparison rate**is calculated in the same way as the

**‘Internal Rate of Return’ (IRR)**(see Excel function) which is used in financial mathematics. In simple terms the comparison rate (IRR) describes the interest rate of a fixed rate savings account which – with the same amount invested – returns the same final financial outcome as the investment project. (Sometimes it may be useful to use the Excel function XIRR instead of IRR.)

As an the example on the calculator above an investment of $5000 is calculated having a payback time of 10 years. This may sound pretty poor. According to the calculator the comparison rate (or IRR) is 8.78%. This means the solar investment with an IRR of 8.78% is as good as $5000 invested in a savings account over 25 years with an interest rate of 8.78%. (assuming interests are left in the account for 25 years) So 8.78% looks very good.: the best savings accounts available today are providing far less than half of this interest rate.

Another way to describe the investment quality of a solar PV system is to calculate the **levelised cost of energy (LCOE)**. If the owner sells electricity at the LCOE value, he will just break even at the end of the project. A higher price for electricity than the LCOE will lead to a financial gain.

Both IRR and LCOE take the time value of money into account. That means that because of inflation and interest rates $100 in my hand today have a higher value than $100 which I will get at a later date. The formula for LCOE needs for this purpose to know the** discount rate**. The discount rate is something like an interest rate and can be different if you pay for the investment in cash or with a loan.

The spreadsheet above calculates these key figures for an investment in solar PV. It does not take taxes and depreciation in consideration. (The bank also does not tell you the interest rate after tax, but before tax.)

It also produces the **accumulated cash flow** (not corrected for time value of money) and the **net present value (NPV)** which is essentially the accumulated cash flow with a correction for the time value of money.

The** payback time** (not corrected for the time value of money) can easily be looked up on the chart as the point where the line for the accumulated cash flow crosses the timescale.

The value for the ‘**electricity price**‘ in the spreadsheet below needs some explanation: Only in very rare cases where 100% of the electricity is consumed inside the building within a single tariff, the actual electricity price can be used. For other applications where some of the electricity is exported into the grid, a weighted average of tariff price (for savings in demand) and of the feed-back tariff should be used. Scrolling down the spreadsheet reveals a cost estimator which can be used for this purpose.

Example: 40% export at 8 cent/kWh and normal tariff of 25 cent/kWh –> ‘electricity price’ = 40% * 8 + (1- 40%) * 25 = 18.2 cent/kWh

The ‘**discount rate**‘ is only used for the calculation of the Net Present Value. A simple assumption is to use the best interest rate for safe investment (bank accounts, term deposits) when the solar plant is bought with cash OR to use a relevant loan interest rate when the PV plant is financed.

In many cases it can make a lot of sense to finance the PV plant with a redraw from an existing home loan. In most cases the cash flow will be positive from year the beginning. That means that the payback time is zero! The use of the solar income can also help to pay off the home loan faster.

Comments and questions can be posted as a ‘Reply’ below.

Hi,

I am wondering where in this spreadsheet is the Daily Usage Charge?

Tx

The calculator is not calculating the electricity cost, but the potential savings from installing solar PV.

The daily usage charge stays the same as long as the system stays connected to the grid.

FYI: The daily supply charge raised from July 1 from 55c to 95c. So I am wondering how this charge will NOT impact on saving?

John, which state are you in? I have created this calculator to calculate the cost savings between not having a solar PV system and having a solar PV system. Installing a PV system will not make any difference to the daily supply charge as having solar panels does not change the daily supply charge. This may change in the future, if – as already has been tried in Queensland – , the daily charge will be changed just for owners of PV systems.

In this case you can scroll the calculator to the right. In the field ‘fixed cost’ you can enter the annual change in fixed cost caused by the installation of the solar system. Or to avoid an offline calculation you can also enter ” =365*0.40 “, with 365 being the conversion from daily to yearly data and 0.40 the daily difference in dollars caused by the installation of a solar PV system (in your example the difference between 95c and 55c = 0.40 dollars).

Thank you for bringing this up. I just realised that this field had been write protected. This has been fixed now.

I am from QLD.

I understand your explanations. Still the Daily Supply Charge – DSC must be taken into account the same way as electricity prices when calculating the cost savings of installing a solar system. If you assume that electricity prices will raise with inflation or above same assumption should be taken in regards to DSC especially now when the electricity suppliers are raising this DSC way above inflation to compensate for their incorrect calculations in previous years of raising electricity consumption. Therefore, the Fixed Cost field is NOT fixed and should be allowed to add X% yearly raise same as electricity prices.

Is the fixed charge in Queensland different for homes with solar and for homes without solar?

It depends on the supplier and different plans. Have a look here https://www.clickenergy.com.au/energy-price-fact-sheets/ Choose QLD, than Go to Shine, Shine Budget and Shine Rewards VS Elite and Easy plans. On the other hand Origin as far as I know have the same charge for solar and Non Solar plans.

I am sorry, I cannot see a single daily charge which is different with the solar tariff.

But let’s discuss Origin. Do you agree that in case of Origin with unchanged daily charges for solar there is no need to add the daily charge into the calculator?

Sorry for the late answer.

Note here in Click Elite plan https://www.clickenergy.com.au/energy-price-fact-sheets/energex/click-elite/42/ the Daily Supply Charge (DSC)is 91.755c inc. GST while in Click Shine Rewards https://www.clickenergy.com.au/energy-price-fact-sheets/energex/click-shine-reward/175/ it is 96.344c inc. GST. This is 5% more for solar plans.

In regards to Origin, even if the DSC is the same it will still change un-proportionally to the electricity price. Therefore, IMO if you include the ability to raise the electricity charge by x% every year, you should also include the same ability for the DSC in an additional field.

Can you give me a formula or an algorithm?

This is something new, have never heard or read about this solar PV investment calculators before. This is a new tool to me. Enjoyed reading this.

Hey great solar calculator. BSPQ have made some very basic solar calculators here: http://www.bspq.com.au/solar-calculators/. Keep up the great work guys!

This is an extremely well written and informative article. Thanks for posting I enjoying reading them.

Hello I am masters research student I am working on a project with solar PV, I would like to know the if the excel spreadsheet is available to download as it is very informative and useful.