| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
XIRR versus IRR help!
Hi:
I am trying to figure out how to calculate the IRR of a series of cashflows. There are 177 cashflows of $41,422, and the up-front cost is $3,330,786. I tried using an IRR, but that just gives me an error I think because there are too many cashflows. I used an XIRR, but this compounds daily, and thus gives me a different result than an HP-12C. Please advise! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| $ versus None | Excel Discussion (Misc queries) | |||
| XP versus Vista spreadsheet | Excel Worksheet Functions | |||
| Excel: PC versus Mac | Excel Discussion (Misc queries) | |||
| R1C1 versus A1 | New Users to Excel | |||
| How to plot B2:B11 versus A2:A11 | Excel Worksheet Functions | |||
Threaded Mode
