Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post

jonesy · 04-05-2011, 01:07 PM

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.

04-05-2011, 01:07 PM	#4
jonesy First Line Centre Join Date: Nov 2002 Location: Niceland Exp:	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$1512))/(POWER(1+($B$12/12),($B$1512))-1)) and this for interest paid: =(D312$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.