Spy Journal 3.0 Filtering the web for you

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.

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:

• Spy Journal 1.0
• Spy Journal 2.0

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

• Personal Blog - This is Tim's personal journal
• Excel Tips Blog - Free Microsoft Excel and VBA hints and tips
• Blog Tips Blog - Blogging tips, how to how to set up a blog and how to make money from blogging
• Tech Tips Blog - Geeks heaven - go here for all things tech. Software, Hardware, Gadgets and geek humour
• Urban Space Novel - Tim's Novella - in the making
• Photo Archive - our best photos

Erin's birthday was on Wednesday - she is 6 now and growing up to be a big girl.
With birthdays at our place come extra chores and a raise in pocket money. Erin's new chore is making all the shoes at the front door line up neatly in pairs!

Here's a picture of her at Sizzlers with her birthday cake.

Find out how much of your favorite drink will kill you.
http://www.energyfiend.com/death-by-caffeine/