English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

I bought 12.20 acres for 30,000. The payment was 284.78 per month. The interest is calculated at 7.240% per annum. on a 15 year mortgage. After 4 years I've paid nearly 14,484.. and still owe 27,000. Thank you all, math certainly isn't my thing.

2006-12-21 13:23:06 · 1 answers · asked by Jennifer N 3 in Business & Finance Personal Finance

1 answers

Excel has a very friendly formula to calculate payments and interest.
It is PMT. Play with it and you will find how to draw the table of payments and how much of every payment is interest and how much is principal. In general terms what happens is that the first payment you are paying almost only interest and in the last payment you pay only principal. The proportion changes a little with every payment. After year 7 you´ll be much happier. Hope it helps.

2006-12-21 14:09:59 · answer #1 · answered by Anonymous · 0 0

fedest.com, questions and answers