How do I create a loan amortization schedule?

It's relatively easy to produce a loan amortization schedule if you know what the monthly payment on the loan is. Starting in month one, take the total amount of the loan and multiply it by the interest rate on the loan. Then for **a loan with monthly repayments, divide the result by 12** to get your monthly interest.

How do I create a loan amortization schedule in Google Sheets?

How do you create a loan on a spreadsheet?

## Related Question how to create a loan amortization schedule

### How do I calculate bank loan interest in Excel?

### How does PMT work?

The PMT function calculates the required payment for an annuity based on fixed periodic payments and a constant interest rate. An annuity is a series of equal cash flows, spaced equally in time. A mortgage is an The NPER function returns the number of periods for loan or investment.

### How do you calculate PMT on a financial calculator?

### How do I calculate APR in Google Sheets?

### How do you calculate principal and interest in Google Sheets?