Business Template - Simple Projections

Doing Simple Projections Making Payments -MkPmts This shows one of the easiest, most obvious functions in the library. It just drops a series of payments into a timebase. Dates Payments 4 May 08 10 6 Aug 08 20 8 Apr 09 30 3 Feb 08 40 1 Jan 08 1 Apr 08 1 Jul 08 Method 1 40 10 20 Method 2 40 10 20 Method 3 (Array function) 40 10 20 Spreading something -Unispread This is just a uniform (ie flat, or even) distribution -there are others available, including S-Curve. Start 4 Mar 08 Finish 10 Feb 09 Amount 100 Periods -4 pa arr ProjMode 1 cash 1 Jan 08 1 Apr 08 1 Jul 08 Method 1 8 27 Method 2 8 27 Method 3 (Array function) 8 27 Growing Something -AnnGrow An annually growing amount. Start 1 Feb 08 GrowthDates Rates Finish 4 Jul 13 4 Mar 08 5% Annual Rate 100 1 Jan 09 10% Periods 1 pa adv ProjMode 1 cash1 Jan 08 1 Jan 09 1 Jan 10 Method 1 92 105 115 Method 2 92 105 115 Method 3 (Array function) 92 105 115Base 3 months 1 Oct 08 1 Jan 09 1 Apr 09 1 Jul 09 30 30 30 available, including S-Curve. 1 Oct 08 1 Jan 09 1 Apr 09 1 Jul 09 27 38 27 38 27 38 Base 12 months1 Jan 11 1 Jan 12 1 Jan 13 1 Jan 14 126 139 76 126 139 76 126 139 76