ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Interest and capital calculations (https://www.excelbanter.com/excel-discussion-misc-queries/62080-interest-capital-calculations.html)

mattguerilla

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

Dave O

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