Then, you will notice a little dot at the right-bottom corner of cell D3. The formula for simple interest in Excel is =<cell with principal value>*<cell with rate of interest>*<cell with time period>.

Using Excel, you can get a better understanding of your mortgage in three simple steps ... step calculates the interest rate, and the third step determines the loan schedule.