PC savings credit on spreadsheet

3 December 2013, 01:04 pm

neilbateman
forum member

Welfare Rights Author, Trainer & Consultant

Total Posts: 443

Joined: 16 June 2010

Does anyone have a spreadsheet for working out savings credit?

3 December 2013, 01:21 pm #1

PJC
forum member

Advice Link, Blackpool

Total Posts: 3

Joined: 18 July 2013

may be possible to make one from this - needs updating

3 December 2013, 01:27 pm #2

neilbateman
forum member

Welfare Rights Author, Trainer & Consultant

Total Posts: 443

Joined: 16 June 2010

Thanks. The tricky bit is translating this into excel-speak!

3 December 2013, 05:10 pm #3

Jon Blackwell
forum member

Programmer - Lisson Grove Benefits Program, Brighton

Total Posts: 501

Joined: 18 June 2010

Hi Neil

you could try something like

set D1:Total AMG (incl additions), D2:Total Net Income (after tax,NI, disregards) ,D3: Any non-qual income included in D2.

then, single SC
=MAX(0,MIN(18.06,0.6*MAX(0,MAX(0,D2-D3)-115.3))-0.4*MAX(0,D2-D1))

and couple SC
=MAX(0,MIN(22.89,0.6*MAX(0,MAX(0,D2-D3)-183.90))-0.4*MAX(0,D2-D1))

3 December 2013, 05:16 pm #4

neilbateman
forum member

Welfare Rights Author, Trainer & Consultant

Total Posts: 443

Joined: 16 June 2010

Thanks, if this works, I’ll donate a spread sheet with the formulae to Rightsnet over the next few days.

Our webtools: