View License

Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.

» Watch video

Highlights from
Amortization schedule with variable interest rates

Be the first to rate this file! 5 Downloads (last 30 days) File Size: 134 KB File ID: #31790 Version: 1.6
image thumbnail

Amortization schedule with variable interest rates



14 Jun 2011 (Updated )

Computes & optionally saves & plots some variables, like interest paid and balance outstanding.

| Watch this File

File Information

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 includes a PDF file describing theoretical and applied amortization schedules and a MATLAB .m file functionally written as: [Amorout,T,Ratio] = amorvar(K0,Rates,Prop,Plop,Freq,Comp).
The INPUTS are:
1. K0: Initial principal borrowed
2. Rates: Tx1 time series of interest rates applied in the loan contract expressed in percent (e.g. 12.25)
3. Prop: print option to XLS file in the current MATLAB directory
4. Plop: plot option
5. Freq: yearly periodicity at end of which payment is due
6. Comp: option for computing periodic interest rate
The OUTPUT includes eight variables and two scalars:
I) Amorout: Tx8 matrix containing:
1. Tx1 vector of 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!

Required Products Financial Toolbox
MATLAB release MATLAB 7.12 (R2011a)
Tags for This File   Please login to tag files.
Please login to add a comment or rating.
15 Jun 2011 1.1

Minor additions in the file text

08 Jul 2011 1.6

Extends and ameliorates original code by including PDF documentation and adding inputs.

Contact us