Answer:
On the Formulas tab, in the Function Library group, click the Financial button, and click PMT. Enter B3/12 in the Rate argument box. Enter B4 in the Nper argument box. Enter B2 in the Pv argument box. Click OK.
Explanation:
Inside any excel spreadsheet like Microsoft Excel or Libre office Calc.
While your cursor is present at cell B6, do the following
On the formulas tab, in the function library group,
click the financial button
Then click PMT
Enter B3/12 in the rate argument box.
Enter b4 in the Nper argument box. Enter B2 in the argument box.
Click ok.
The following assumptions were made:
the annual interest rate is stored in cell B3
the number of payments in cell B4
the loan amount in cell B2.
