Excel Magic Trick 407 Amortization Table W Variable Rate
Posted on May 6, 2011.
See how to create a Amortization Schedule / Table with a variable interest rate. See the PMT function, finance and tricks a cell range in a function That Will Shrink As We copy it down a column. See the trick for shrinking range functions.
Otherwise, I would read the contact and figure out the math used for that particular contact.
Posted on May 12, 2011
Claretta Dick says...
Just trudging through the process now. Will check out those amort videos. Thx
Posted on May 16, 2011
Marie Hawes says...
Mike, I am stumped on how to apply the following. Australian banks usually lend on a std variable rate. They calculate interest daily, and add it to the loan balance monthly. I presume it is this figure pmt is calculated on. I also understand they add the interest before calculating the pmt on the due date. I have set up a schedule to calculate interest every day, and sum it every month.....but am bewildered how to work out the pmt. any help appreciated.
