This amortization sheet covers 5 years (60 months). To go further, save the last row, clear the whole sheet, and put the saved numbers up top. I tried making a 30 year sheet and it was just too big!
Change any number and it will update! Note to recalculate and fill all the numbers, just