Could be a stupid question/issue here, but bare with me.
I'm getting the #NUM! error for an IRR or XIRR formula. The cash flows are as follows:
Cost: (1,228,880) CF1: (189,560) CF2: 1,210,440 CF3: 203,000 CF4: (24,000) CF5: (24,000) CF6: (24,000) CF7: (24,000) CF8: (24,000) CF9: (24,000) CF10: (24,000) CF11: (24,000)
I do have iterative calculations enabled.
| +326 | UBS Tech MD hires Son (from no-name college) as an Intern | 57 | 18h |
| +253 | Evercore Intern Seizure | 38 | 5h |
| +90 | [Official] 2026 IB Analyst Bonus Megathread (with 2025 Consolidated Pay and Perks/Benefits) | 12 | 2d |
| +55 | Is DCM actually underrated ? | 21 | 17h |
| +55 | JPM M&A is Gone??? Purely Coverage Banking??? | 22 | 8h |
| +46 | Are all Tech / TMT groups sweaty? | 33 | 1d |
| +43 | Losing my personality in Banking | 7 | 1h |
| +39 | Am I behind? 31 Year Old Analyst | 9 | 1d |
| +39 | Associate & Above IB exits | 16 | 2d |
| +31 | Incoming IB Analyst: Best Ways to Prepare? | 8 | 2d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Seems like NPV is always negative with those cash flows regardless of discount rate, so there isn't a rate that would set NPV = 0, thus no IRR.
I appreciate the help. If I do an NPV calc and use goal seek for the rate with NPV set at 0, it returns something like -198.5%.
Explicabo illum aliquid et dolores recusandae architecto. Illo laboriosam et distinctio modi autem quod hic. Modi exercitationem qui nemo quis. Voluptates vel sed sapiente aut consequuntur nam.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...