Calculate interest each month for a loan.

  • Thread starter Laurie-Earl''sGirl
  • Start date
L

Laurie-Earl''sGirl

I am selling a home on contract for $132,900 with monthly payments of $1115
paid at 8% interest over 20 years. Start Date May 1, 2007. First payment due
June 1, 2007. Balloon payment due June 1, 2008. I need to create a
spreadsheet that will track the payments and calculate the intrerest and
credit the payment based on the date that I receive the payment. The payment
will be credited to the interest first and then principal.

Can anybody help me?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top