Sheet1

Reset

ONLY INSERT INFO INTO BLUE BOXES

Job Number:

Client:

Date:

Annual Gas Bill (£)

Finance APR (%)

Annual Gas Increase (%)

Finance Term (months)

Boiler Efficiency Saving (%)

Boiler / Installation Cost

Magic Box Efficiency Saving (%)

Magic Box / Installation Cost

Gas consumption (kWh)

24000

Total Installation cost (£)

Cost Per Unit Gas (£)

Deposit (£)

Boiler care / cover per month (£)

Financed (£)

Monthly Cost (£)

YOY

Gas Per Unit @ 10%

Current Gas cost YR

Current Gas cost MTH

New Gas cost YR

New Gas cost MTH

Savings Per YR inc boiler cover savings

Savings per MTH inc boiler cover savings

Finance payments per MTH

Payment Neutral Monthly Difference

Year 1

Year 2

Year 3

Year 4

Year 5

Year 6

Year 7

Year 8

Year 9

Year 10

TOTALS

*These are estimated figures based on installing a new A-rated condensing boiler and full set of heating controls in a gas-heated, semi-detached gas heated home with three bedrooms.