View Single Post
Old 04-05-2011, 01:07 PM   #4
jonesy
First Line Centre
 
jonesy's Avatar
 
Join Date: Nov 2002
Location: Niceland
Exp:
Default

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.
jonesy is offline