Dear All,
I was exploring Excel and OpenOfficeOrg's in built XNPV and XIRR functions
yesterday and having put a new page together on my web site to explain
them I thought I'd share it all with you.
Basically, these two functions allow Capital Budgeting problems to have
payment and receipt periods longer or shorter than the year that is
normally assumed. In fact XNPV and XIRR allow us to have day long, week
long, five year long ... periods.
Good for exercises for more advanced students.
In the middle of my preparation I found a small error in Excel's Help
files and have provided a correction for that.
I have also found that Excel and OpenOfficeOrg both use a different XNPV
formula to my own: anyone who reads my page and can correct me or the
spreadsheet packages will earn a special mention and my undying gratitude.
Please take a look at http://www.duncanwil.co.uk/xnpv.html
Best wishes
Duncan Williamson
|