Amortization schedule with variable interest rates (Scripts) Publisher's description
from Guido Travaglini
Tools for computing amortization schedules with variable interest rates are quite uncommon as opposed to those for computing their fixed interest-rate counterpart
Tools for computing amortization schedules with variable interest rates are quite uncommon as opposed to those for computing their fixed interest-rate counterpart.
This code (hopefully) helps filling the gap. It is an .m file functionally written as: [Amorout,T,Ratio] = amorvar(K0,Rates,Prop,Plop).
The INPUTS required are minimal: K0 is the initial principal lended expressed in the desired currency; Rates is the vector of the variable interest rates of length T periods;Prop and Plop are binary options for saving the output in a XLS file and for plotting the most relevant variables contained in the output.
The OUTPUT includes eight variables and two scalars:
I) Amorout: Tx8 matrix containing:
1. Tx1 vector of t.th step, t=1,...,T
2. Tx1 vector of Interest rate in %
3. Tx1 vector of Principal paid
4. Tx1 vector of Interest paid
5. Tx1 vector of Balance Outstanding
6. Tx1 vector of Payment due
7. Tx1 vector of Cumulative Payment due
8. Tx1 vector of Ratio of (7) w.r.t. K0
II) T: Total number of steps (scalar)
III) Ratio: Cumulative Payment at time T / K0 (scalar)
Enjoy and provide feedback!
System Requirements:MATLAB 7.12 (2011a)
Program Release Status: New Release
Program Install Support: Install and Uninstall