Excel Magic Trick 407: Amortization Table W Variable Rate

Related Videos
By: UCkndrGoNpUDV-uia6a9jwVg
Video Discription: 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.

--

Video Just Watched

Dailymotion.com

Youtube.com