Doing the math and crunching the numbers when it comes to figuring out your loan's interest can be complicated. Here's how to calculate interest on a loan.

Read: How to Calculate Simple Interest in Excel. How do you enter a ratio value in Excel? There is no direct way to show the result as a ratio in Excel. For this, you have to use appropriate formulae.

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

How to Calculate Simple Interest Savings. Savings accounts will earn interest on the amount of money deposited into the account. The formula to calculate simple interest in a savings account is ...

For example, if you borrow $1,000 from a friend and agree to pay 6% simple interest for two years, the formula above tells you that you'll pay $120 in total interest ($1,000 x 0.06 x 2).

For example, if you borrow $1,000 from a friend and agree to pay 6% simple interest for two years, the formula above tells you that you'll pay $120 in total interest ($1,000 x 0.06 x 2).

Therefore, the simple interest on Rs. 78,000 at 10% per annum for 9 years will be Rs. 70,200. So, now you know that calculating Simple Interest is as easy as ABC.