| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Interest Functions | Excel Worksheet Functions | |||
| Interest Formula | Excel Discussion (Misc queries) | |||
| Calculate Interest Rate when payment changes! | Excel Worksheet Functions | |||
| ccalulate interest % | Excel Worksheet Functions | |||
| How to calculate total interest on 12 month loan with early payments | Excel Worksheet Functions | |||
Hybrid Mode
