View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shaun Shaun is offline
external usenet poster
 
Posts: 47
Default Loan amortization schedule for variable interest rates

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.