In cell E11, enter a financial function to calculate the interest paid. Copy the formula to the range E12:E34. The result should be a positive value. In cell F11, enter a financial function to calculate the principal payment. Copy the function to the range F12:F34. The result should be a positive value. In cell G11, enter a formula to calculate the ending balance. Copy the formula to the range G12:G34. Adjust the width of column G, if needed, to display the values. Select the range D11:G34 and apply Accounting Number Format.
Solved by V. S. in 16 mins