Watch Me Build a Mortgage Amortization Table in Excel in Under 90 Seconds



Important note: Sorry if that last step is a bit ambiguous! All I do to finish is to copy row 12 down to row 371, which gives me 360 periods or a full 30-yr …

source