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

Learn how to use the powerful Excel PMT Function to help you manage your loan payments and easily calculate detailed loan repayment schedules ...

How Simple Interest Works: An Example Suppose you take out a $5,000 loan at 6% interest for two years. To calculate the amount of interest you will pay, use the simple interest formula above.

An Excel formula is generally composed of several items. Knowing how to calculate formulas in Excel will make tracking various parts of your business that much easier.

To calculate interest, you need to know variables such as interest rate, principal loan amount and loan term. So if you had 4% interest on a $100,000 mortgage loan, and your loan term was 30 years ...

The formula for calculating simple interest in a savings account is Interest = P * R * T. Multiply the account balance by the interest rate by the time period.

Learn how to calculate the Simple Interest in Excel either for a single entry or a range or entries, between two dates, using this forumula.