In this example, Excel would display $148.45.Įnter '=B1-C7' in cell D7 to calculate the new balance of the loan. In cell B8, enter '=ROUND(D7*B$2/1200,2)' and in cell D8 enter '=D7-C8' to calculate the values for the second payment period.Ĭontinuing the example, Excel would display $24,851.55.Ĭopy and paste the values from A7 and C7 to A8 and C8.
