Interest/Principle calculations not working

  • Thread starter Thread starter Kristen
  • Start date Start date
K

Kristen

I'm trying to set up a simple spreadsheet that will show
car loan payments over 48 months, using the PMT and IPMT
Paste Functions. I have three columns showing Interest,
Principle and Balance Due. I'm dividing the Int. by 12,
but the balance keeps getting to 0 at payment 45, not 48.
Any ideas?
 
You might have to post more details, Kristen. Like in A1 I have 20,000 and
in B1 this formula =xxx and C3 this one =yyy, etc.
 
I fixed it! I was thinking I had to feed the new lower
balance back into the IMPT Paste Function every time it
recalculated, while I should have been using the original
principle. Thanks.
 
Back
Top