Uses this forumula:
P=L[c(1+c)^n]/[(1+c)^n-1]
which looks like this in xl lingo:
=C3*(($B$12/12)*POWER((1+($B$12/12)),($B$15*12))/(POWER(1+($B$12/12),($B$15*12))-1))
and this for interest paid:
=(D3*12*$B$15)-C3
also calculates taxes/month.
lets you change, %down payment, term, rate
of course you have to see what the cells are for this to make sense. Anyways I can send it if you want.
__________________
When in danger or in doubt, run in circles scream and shout.
|