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.
| +137 | Return Rates For Interns Are Falling? | 44 | 5h |
| +128 | UBS Americas IB: The Kids’ Table of Wall Street | 15 | 3d |
| +73 | London IB BB is a challenge | 40 | 4h |
| +71 | I am a drunk MD AMA | 33 | 5h |
| +61 | VP Lifestyle at Top BB Coverage Groups | 39 | 2h |
| +46 | SharePoint makes IB hours HELL | 15 | 1d |
| +46 | An Outsider’s View of RX Banking Out of College | 6 | 1d |
| +42 | momentum of Rx groups | 15 | 5h |
| +39 | Fired during interview | 8 | 9h |
| +28 | Weird Majors->IB ? | 22 | 2h |
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%.
Voluptas suscipit voluptatem id deserunt. Vel sit est omnis est qui eligendi magni. Et assumenda et voluptatem sed. Reiciendis non est unde ipsum accusantium. Sit impedit debitis omnis ipsum aliquid.
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...