Trying to get a formula to automatically show a balance on a R/E Loan.
$140,000.00 Original Note @ 7.5% interest.
Paid 10% up front. ($14,000.00)
Starting 1/1/05, monthly pymts of $800.00.
How can I set up a formula to automatically reduce the balance of the loan after each monthly payment is made?
Thank you.
Bookmarks