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.
| +183 | Americas M&A League Table Q2 Updated | 74 | 2h |
| +132 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 27 | 2h |
| +110 | Restructuring: Anti-climactic Experience | 29 | 2h |
| +83 | IB Net Worth / Savings Check | 34 | 18m |
| +74 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 12 | 1d |
| +51 | Boutique firm wants access to my LinkedIn? | 40 | 1d |
| +39 | Investment Banking is Hard | 17 | 21h |
| +31 | PWP vs BofA | 23 | 6h |
| +27 | Who pays the highest right now? | 14 | 6h |
| +25 | Woman who emptied Knicks trashcan on street then stole it was DEI exec, worked at JPMorgan Chase | 10 | 1h |
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%.
Accusamus excepturi laborum debitis adipisci quibusdam ipsa. Perspiciatis dolor qui rerum.
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...