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.