Yes I have excel for this and Gavin I did state above that intrest would need to be added .
As long as the FIRST year payment is lower than the SAVING SEE BELOW
as long as my savings are higher than £42.00 PM then this meets golden rule spread over 20 years
PLEASE NOTE : I am giving examples to get the idea in your head you can adjust prices , payment terms and down payments to meet golden rule .
the goldne rule is to beat the mthly repayments and not to exceed the life time of the measure NOT the FINAL TOTAL COST IE £10,252.55
so its doable !
so the System cost , GDA fees cost £5510.00 so thats the amount to borrow over the lifetime of the system 20 years = payments of £42.72 PM
I do not know what the provider fees are or how they will make money yet or if they get the intrest but I will find out on monday as I am meeting two providers Monday.
[TABLE="width: 556"]
[TR]
[TD="class: xl72, width: 387, bgcolor: transparent"]Loan Payment Calculator Using PMT Function[/TD]
[TD="width: 354, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Total cash back [/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]£0.00[/TD]
[/TR]
[TR]
[TD="class: xl73, bgcolor: transparent"]Amount To Borrow [/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]£5,510.00[/TD]
[/TR]
[TR]
[TD="class: xl73, bgcolor: transparent"]Down Payment[/TD]
[TD="class: xl64, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]Loan Amount[/TD]
[TD="class: xl71, bgcolor: #D8E4BC"]5,510.00[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]Payment Frequency[/TD]
[TD="class: xl71, bgcolor: #D8E4BC"]Monthly[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]Term (Years)[/TD]
[TD="class: xl70, bgcolor: #D8E4BC"]20[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]Annual Interest Rate %[/TD]
[TD="class: xl69, bgcolor: #D8E4BC"]7.00%[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Monthly Payment[/TD]
[TD="class: xl66, bgcolor: transparent"]42.72[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]Total Cost[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]£10,252.55
[/TD]
[/TR]
[/TABLE]