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.

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.

You can use an online calculator to figure the present and future value of an annuity.

Learn how to calculate the future value of an investment to ensure your portfolio is being monitored and heading in the right direction.