You can use the PMT function to figure out payments for a loan given the loan amount number of periods and interest rate. The NPER argument is 3012 for a 30 year mortgage with 12 monthly payments made each year. Copy the example data in the following table and paste it in cell A1 of a new Excel worksheet.
The Excel PMT function is a financial function that returns the periodic payment for a loan.
Copy the example data in the following table and paste it in cell A1 of a new Excel worksheet. This is just EMI that we pay for our loan or invested amount when we opt for any policy or loan from a bank. To be able to choose different periods and specify when the payments are due create drop-down lists with the following. If you need to you can adjust the column widths to see all the data.