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: 75
Default XIRR Problem

I need to go month to month with a value at the beginning of the month, a
cash flow at some point the middle of the month, and a value at the end of
the month. I'm trying to get the ROR for that month.

For example:
$67,626.52 2/29/2008 known starting value
-$3,921.48 3/6/2008 cash flow
$72,906.91 3/31/2008 known value at end of month

If I set this up in XIRR, I get 0.000..

If I build out using a row for each day of the month "from known starting
value" through "known value at end of month" (thus including the cash flow as
a positive number since I'm putting monto into the account) and use Goal Seek
to find an answer, I get 0.0613%

What is the right answer and how do I get there from here?
 
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
xirr john Excel Worksheet Functions 4 June 26th 06 11:04 AM
IRR, XIRR and NPV - a very frustrating problem zacharychan Excel Discussion (Misc queries) 1 October 24th 05 09:01 AM
Problem with XIRR function returning #NUM! Francois_Provost Excel Worksheet Functions 3 June 7th 05 01:05 AM
XIRR maryj Excel Worksheet Functions 1 May 20th 05 09:28 PM
XIRR and IRR Dan Excel Worksheet Functions 2 May 13th 05 03:20 AM


All times are GMT +1. The time now is 04:03 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"