Services & ResourcesWolfram ForumsMathGroup Archive

[Date Index] [Thread Index] [Author Index]

Issue understanding the use of Cashflow

• To: mathgroup at smc.vnet.net
• Subject: [mg127032] Issue understanding the use of Cashflow
• From: vandel at gmail.com
• Date: Tue, 26 Jun 2012 04:46:37 -0400 (EDT)
• Delivered-to: l-mathgroup@mail-archive0.wolfram.com

I've been tearing my hair out (what little I have left) trying to understand what I'm missing in the difference between using Cashflow in TimeValue and Annuity, any insight would be appreciated.

If I take a 250K loan and use Solve and TimeValue to find the payment for 30 years at 5 percent I get 1342.05 and if I plug this in to TimeValue[Annuity ....} all the amortization tables and such work out fine and as expected.

However, what I am trying to do is to work out the ability to provide a cash flow stream that has varying payments and to calculate the remaining value of the loan a various points in time.

What I am seeing is that the loan seems to pay off way too fast in the Cashflow case.  Here are some specifics:

Here are the first 10 elements of the Cashflow specification (there are 360 in all)

In[350]:= testCashFlowSpecification[[1 ;; 10]]
Out[350]= {{{2012, 2, 1, 0, 0, 0}, -250000.}, {{2012, 3, 1, 0, 0, 0}, 
  1342.05}, {{2012, 4, 1, 0, 0, 0}, 1342.05}, {{2012, 5, 1, 0, 0, 0}, 
  1342.05}, {{2012, 6, 1, 0, 0, 0}, 1342.05}, {{2012, 7, 1, 0, 0, 0}, 
  1342.05}, {{2012, 8, 1, 0, 0, 0}, 1342.05}, {{2012, 9, 1, 0, 0, 0}, 
  1342.05}, {{2012, 10, 1, 0, 0, 0}, 
  1342.05}, {{2012, 11, 1, 0, 0, 0}, 1342.05}}

My thinking has it that if I look at the TimeValue of these 10 elements at {2012,12,1} I should get the same value as:

In[351]:= TimeValue[Annuity[1342.05, 360 - 10], 5./1200]
Out[351]= 246938.

If I do:

In[354]:= TimeValue[Cashflow[testCashFlowSpecification[[1 ;; 10]]], 
 5./1200, {2012, 12, 1}]
Out[354]= -238765.

But the result is dramatically different with the CashFlow version amortizing way faster than expected (and not just by an amount that might be associated with one payment or start of month/end of month type issues).

Any support in what I am missing here would be much appreciated.

• Follow-Ups:
  • Re: Issue understanding the use of Cashflow
    • From: Stuart Nettleton <Stuart.Nettleton@uts.edu.au>