Solar Installation Payback Spreadsheets

The following spreadsheets are extensions of the one in the video:

solar_payback.xlsx - the original payback spreadsheet used in the video

solar_payback_v2.xlsx - improved version adding VAT/tax setting for WITHOUT SOLAR costs

solar_payback_craig_harris_v4.xlsx - further improved version developed by Craig Harris that includes crosshairs for the estimated payback date (nice!)

solar_payback_allan_v4.xls - an extension of Craig's version developed by Allan that includes a daily tracker tariff and opportunity cost (columns T to Z). This version doesn't include VAT/tax though.

Then these spreadsheets use a completely different model:

analysis_and_vfm_calculations_v2.xlsx - a payback spreadsheet developed by Michael Blackmore to assess the VFM of any solar & battery installation.

Solar Battery Project Financial Forecast - a comprehensive Google spreadsheet developed by Rahul Parmar, who is happy to receive feedback directly on X (@rahulbrit).

solar_performance_v2.6_craig_harris.xlsx - a very detailed and highly visual payback performance spreadsheet developed by Craig Harris (I am really impressed by it!)

All of these spreadsheets are provided 'as is' without any guarantees. Forward projections included therein should be regarded as estimates and may not accurately predict future outcomes. No warranty is supplied with any of these spreadsheets.

If you have any other improvements to the spreadsheet and would like to share them to help others, please feel free to email me, and I'll add them to the list.