Use Excel to get a handle on your mortgage or loan by determining your monthly payment, your interest rate, and your loan schedule. You can take a more in-depth look at the breakdown of a loan ...

The formula for simple interest in Excel is =<cell with principal value>*<cell with rate of interest>*<cell with time period>. If these three values are mentioned in the A1, B1, and C1 cells, your ...

Use Excel to get a handle on your mortgage or loan by determining your monthly payment, your interest rate, and your loan schedule. You can take a more in-depth look at the breakdown of a loan ...