We show you how to calculate compound interest in Excel at different rate of interests, like semi-annually, quarterly, monthly, etc.

Compound interest refers to interest calculated on interest balances as well as principal. Learn how to calculate compound interest using Microsoft Excel.

The interest rate your lender gives you isn't the true cost of your mortgage. Learn how to calculate your effective interest rate, including any discount points.

When you use Excel, you can make changes to the amount borrowed, the interest rate and the payment period and immediately see how the loan would change.

How to calculate the effective interest rate, or APR The calculation of APR involves a rather complex mathematical formula, but there is a relatively easy "shortcut" method you can use that ...