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.
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%.
Praesentium expedita vero dolores doloremque sit alias nesciunt. Assumenda et facere id eligendi illum ut corrupti sint. Velit quaerat dolore dignissimos voluptate alias.
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...