Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.soft-sys.math.mathematica > #10631 > unrolled thread

Issue understanding the use of Cashflow

Started byvandel@gmail.com
First post2012-06-26 08:47 +0000
Last post2012-06-27 08:08 +0000
Articles 2 — 1 participant

Back to article view | Back to comp.soft-sys.math.mathematica


Contents

  Issue understanding the use of Cashflow vandel@gmail.com - 2012-06-26 08:47 +0000
    Re: Issue understanding the use of Cashflow vandel@gmail.com - 2012-06-27 08:08 +0000

#10631 — Issue understanding the use of Cashflow

Fromvandel@gmail.com
Date2012-06-26 08:47 +0000
SubjectIssue understanding the use of Cashflow
Message-ID<jsbsuq$6nh$1@smc.vnet.net>
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.

[toc] | [next] | [standalone]


#10641

Fromvandel@gmail.com
Date2012-06-27 08:08 +0000
Message-ID<jsef16$i4s$1@smc.vnet.net>
In reply to#10631
If anyone is looking at this, it seems that the issue has something to do with the way that specifying time as Date is handled.  If you use numeric periods everything works out as expected.

In[414]:= TimeValue[Cashflow[testCashFlowSpecification[[1 ;; 10]]], 
 5./1200, 10]

TimeValue[Annuity[1342.05, 360 - 9], 5./1200]

Out[414]= -247251.

Out[415]= 247250.

Either I don't understand how to use the date format, which is quite possible, (and there isn't much documentation on it) or there is something wrong with the function...

[toc] | [prev] | [standalone]


Back to top | Article view | comp.soft-sys.math.mathematica


csiph-web