98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel xp training - Mortgage repayments
excel xp training - Mortgage repayments
Resolved · Low Priority · Version Standard
Rob has attended:
Excel Advanced course
Mortgage repayments
what formula/s can i use to show the break down of mortgage repayments between interest and principle over a typical residential table mortgage?
RE: mortgage repayments
Try using the IPMT function, which will allow you to calculate the interest repayments for a given period. This can then be calculated with a PMT function to give the result you may be looking for.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding date and timeHere are two quick ways to add the date and time to your spreadsheet: |