Loan amortization schedule for variable interest rates
Just roll your own. Amortization tables are easy to do manually. In your
case, you'll need five columns:
Opening balance, interest rate, payment, interest, closing balance.
Post back if you need help on the formulas.
Regards,
Fred.
"Shaun" wrote in message
...
I am using a Amortization Schedule template from Microsoft Office online.
While this template is helpful for cases of fixed rate of interest over
the
period, I was looking for a template which would allow for variable rates
of
interest.
My current loan amount is 2500000.
Annual Interest Rate for first 12 months is 8% and for the rest period
would
be 10%. Loan period 13 years, Number of payments per year 12.
Please help me out here.
|