Interest and capital calculations

[Guest]

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]

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?