#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FA FA is offline
external usenet poster
 
Posts: 18
Default NPV & IRR

Please help.

I want to evalue the returns of a series of investments as shown below.
2008 2009 2010 TOTAL IR = 0.05
INCR Sales $166,873 $813,114 $1,266,398 $2,246,385
Invest. $(105,500) $(164,150) $(170,609) $(440,259)
TOTAL $61,373 $648,964 $1,095,790 $1,806,126

I'm not sure if I should use NPV, IRR or PV. When I use the formula I also
have problems understanding the results.

Looking forward to your suggestions.

FA
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"