![]() |
Interest and capital calculations
Hello, I would like to calculate the interest i would pay on a loan and the capital I would pay off each month. Mortgage = 50,000 Term 25 years = 300 months at a rate of 4.39% how much interest would I be paying and how much capital. I could then work out how much quicker I could pay off the mortgage by overpaying. Matt |
Interest and capital calculations
You're describing an amortization schedule- the Microsoft website has
templates available for no-cost download. When considering how much to "overpay" the mortgage, do you consider the tax effects? |
All times are GMT +1. The time now is 03:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com