Download Files:
https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT407-414.xls
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.
