LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Excel gives me false IRR values|How do I find the real IRR on this investment

I have an investment with $100M outflow then an inflow of $230M finally an outflow of $132M

I used Excel IRR "fuction" with default guess of 10% and a guess rate of 15% to get two IRR values shown below

=IRR({-100,230,-132})

10%

=IRR({-100,230,-132},0.15)

20%

But when I showed the IRR values to my CFO, he showed a grin on his face and yelled what non sense you throwing at me. How in the world we have an IRR of 10% and 20% when lost $2,000,000

So how do I find the real IRR that reflects the true return on my company's investment.

 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
line chart plots false value and the real value on same date Isabel Charts and Charting in Excel 0 February 10th 10 01:18 PM
Recognizing Real Values Ken Excel Discussion (Misc queries) 2 September 18th 07 07:08 AM
VBA always creates linked chart even when using PasteExcelTable False, False, False in Office 2007 Matt Simpson Excel Programming 0 August 6th 07 08:11 PM
What calculation can I use to find income on a fixed investment? Ken K Excel Discussion (Misc queries) 3 June 3rd 06 10:08 PM
Find last real row of filterred data table andibevan Excel Programming 1 July 23rd 04 01:27 PM


All times are GMT +1. The time now is 11:51 AM.

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"