Excel Forum

Excel Magic Trick 407: Amortization Table W Variable Rate

See how to create a Amortization Schedule / Table with a variable interest rate. See the PMT function, finance tricks and a cell range in a function that will shrink as we copy it down a column.
See the Shrinking range trick for functions.

Got a Question? Ask it Here in the Forum.