• Buffer
  • Sharebar
  • Buffer
jethro's picture

NPV and FV From Scheduled Cash Flows

From Charley Kyd's Excel Newsletter.

When readers ask questions that I think others would find useful, I try to take the time to frame my answer as an article.
Recently a reader asked about the XNPV and XIRR functions, which are new with Excel 2007.
These are really useful functions. Suppose you have a column of cash flows and a column of dates. The dates don't need to be periodic. These functions find the Net Present Value and the Internal Rate of Return for that schedule of cash flows.
My reader wondered if there's a way to do the same thing for Future Values.
It turns out that the SUMPRODUCT function can do exactly what he needed. Better yet, this function allows Excel 2003 users to calculate both the future and present values of the same cash flow schedule.
See Find Future & Present Values From Scheduled Cash Flows In Excel 2003 and Excel 2007.

jethro's picture

Digging the garden

My dad always said there was no need to go to the gym when you had a garden you could go and dig!

Well I just finished digging the garden twice over, once to turn it over and the second time to work through all the mulch and compost I put into it.

I got away with only one blister!

jethro's picture

Spy Journal Archives

This is the third incarnation of Spy Journal
Archive by Month from this site
For all the previous posts check these Spy Journal Archive links:

For the specific pages in Version 2, check these links:

jethro's picture

Multiple Monitors

I have been working with 2 monitors for years.
This week I upgraded to 3 and after tomorrow will be using 4 (when I pick up a long enough DVI cable to reach)

Already with 3 I have found some productivity gains.
I have 2 22" widescreens as my main monitors and 2 19" widescreens either side of them. As my desk is a curved reception desk (curves through 90 degrees) they sit very nicely on it.
So how did I make it work? Well two BFGTech 8800GTX OC 768Mb video cards (SLI) help - and a massive server case fan to cool them!
I have the 2 19"s either side of the main 22" monitors. So from left to right they are numbers 3, 1, 2, 4