Posted to microsoft.public.excel.worksheet.functions

Duke Carey Duke Carey is offline

external usenet poster

Posts: 1,081

The XIRR function in Excel

see Chip Pearson's explanation at

http://www.cpearson.com/Excel/rounding.htm

"MMM" wrote:

When I try to calculate an IRR with an initial outlay of -$100 on 1/1/07 and
an final amount of $112 on 1/1/08 does the IRR come to 11.99999988% instead
of 12% even?
--
Matt

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
Please help for FV and XIRR function.	RushatiINDIA	Excel Worksheet Functions	3	April 12th 07 04:00 AM
What compounding assumption does excel use for its XIRR function?	IRR calculator	Excel Worksheet Functions	3	February 13th 07 02:04 PM
Any more advice than the Excel help, on the XIRR Function?	excelent	Excel Worksheet Functions	1	August 5th 06 12:41 AM
XIRR function	Daniel Bonallack	Excel Worksheet Functions	2	June 20th 05 09:00 PM
XIRR function on Excel 2003	Liz	Excel Worksheet Functions	2	April 24th 05 06:36 PM

All times are GMT +1. The time now is 06:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us