Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.python > #94741
| Date | 2015-07-29 17:14 +0100 |
|---|---|
| From | duncan smith <buzzard@invalid.invalid> |
| Newsgroups | comp.lang.python |
| Subject | Re: How to Calculate NPV? |
| References | <249a5b7e-0364-4b74-94f4-c8bbfbba2479@googlegroups.com> <757d1a56-fc27-4996-acff-8bb7e07204d6@googlegroups.com> <9f04969b-6b6b-4773-a1f1-37e23706aecf@googlegroups.com> |
| Message-ID | <55b8fbf1$0$10731$862e30e2@ngroups.net> (permalink) |
On 29/07/15 15:27, ryguy7272 wrote: > On Wednesday, July 29, 2015 at 10:21:35 AM UTC-4, ryguy7272 wrote: >> On Wednesday, July 29, 2015 at 9:59:10 AM UTC-4, ryguy7272 wrote: >>> I am using Spyder Python 2.7. I'm running this sample code. >>> >>> import scipy as sp >>> cashflows=[50,40,20,10,50] >>> npv=sp.npv(0.1,cashflows) >>> round(npv,2) >>> >>> >>> Now, I'm trying to get the NPV, and I don't see any obvious way to get it. >>> The author of the book that I'm reading gets 144.56. I think that's wrong, but I don't know for sure, as Python won't do any calculation at all. It's easy to enter code and run it, but I can't tell how to get Python to actually DO the calculation. >>> >>> Any idea what I'm doing wrong? >> >> PERFECT!! SO SIMPLE!! >> I don't know why the author didn't do that in the book. >> >> Thanks! > > One last thing, for Excel users, leave out the initial CF. Do the NPV on the other CFs, and then add in the initial CF at the end of the NPV function. It's almost like a PV + 1stCF. I don't know why Excel does it like that... > I don't know what Excel does, but the first value shouldn't require any special treatment, 1.1**0 = 1. >>> sum([x/(1.1)**i for i, x in enumerate([50,40,20,10,50])]) 144.55638276074038 >>> Duncan
Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
How to Calculate NPV? ryguy7272 <ryanshuell@gmail.com> - 2015-07-29 06:58 -0700
Re: How to Calculate NPV? Saber Ayoub Chelaghma <saber.chelaghma@gmail.com> - 2015-07-29 07:09 -0700
Re: How to Calculate NPV? ryguy7272 <ryanshuell@gmail.com> - 2015-07-29 07:21 -0700
Re: How to Calculate NPV? ryguy7272 <ryanshuell@gmail.com> - 2015-07-29 07:27 -0700
Re: How to Calculate NPV? duncan smith <buzzard@invalid.invalid> - 2015-07-29 17:14 +0100
Re: How to Calculate NPV? Terry Reedy <tjreedy@udel.edu> - 2015-07-29 15:08 -0400
Re: How to Calculate NPV? Dave Farrance <df@see.replyto.invalid> - 2015-07-30 15:18 +0100
csiph-web