Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.soft-sys.math.mathematica > #10631 > unrolled thread
| Started by | vandel@gmail.com |
|---|---|
| First post | 2012-06-26 08:47 +0000 |
| Last post | 2012-06-27 08:08 +0000 |
| Articles | 2 — 1 participant |
Back to article view | Back to comp.soft-sys.math.mathematica
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
| From | vandel@gmail.com |
|---|---|
| Date | 2012-06-26 08:47 +0000 |
| Subject | Issue 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]
| From | vandel@gmail.com |
|---|---|
| Date | 2012-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