Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
xirr | Excel Worksheet Functions | |||
IRR, XIRR and NPV - a very frustrating problem | Excel Discussion (Misc queries) | |||
Problem with XIRR function returning #NUM! | Excel Worksheet Functions | |||
XIRR | Excel Worksheet Functions | |||
XIRR and IRR | Excel Worksheet Functions |