Loan Amortization Quarterly Payments

1.8k Views Asked by At

Has anyone got a loan amortization table in excel for loans with payments every four months? I need to calculate the payment amount for a loan that will pay three times a year 20 times

1

There are 1 best solutions below

1
On BEST ANSWER

This is not a programming question, but...

  • Quarterly means 4 times per year (every 3 months), and 20 payments would take 5 years.

  • 3 payments per year is called Triannually and will take 6 years and 8 months.

I'm pretty sure you meant quarterly.


A quick search found:

Loan amortization schedule template

Create a loan summary and payment schedule based on the terms of the initial loan with this loan amortization schedule template. This is an accessible template. (Excel)

img

Download Template

(Source)