Want To Use Excel To Calculate Your Mortgage Repayments?

If you borrow a lump sum over a number of years at a certain rate of interest then Excel has a financial function to help you calculate the monthly repayments. You might want to just calculate your monthly mortgage repayments or maybe you need to check how your mortgage repayments are affected by interest rate changes or by changes to the loan period? You can use Excel's PMT function to carry out these calculations.

The full article appears here:
http://www.microsofttraining.net/article-572-want-use-excel-calculate-your-mortgage-repayments.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com