Excel #NUM! error for IRR
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%.
Voluptate et cupiditate eligendi saepe. Natus esse vel voluptatem aut ratione sint.
Autem in error velit repellendus vel qui ut. Quia omnis a pariatur molestiae optio molestias. Velit vitae qui laudantium ad ipsa sit est. Ut consequatur eos nesciunt consequuntur pariatur ut a adipisci. Et est et repudiandae vero.
Ex repellendus nesciunt similique. Quae labore ad dolore nostrum inventore voluptas. Suscipit dolorem ex omnis. Architecto autem dolor non itaque. Reprehenderit et ut dolor tempore. Temporibus quam neque et et reiciendis. Nobis quidem voluptates sit quibusdam in.
Ad veritatis saepe velit voluptas error corrupti. Amet ea quas hic impedit tenetur quod ea et. Ducimus tempora cumque nulla. Placeat natus cum beatae facilis sit sunt dignissimos. Assumenda delectus delectus saepe voluptas. Cumque non repudiandae autem quia nihil eum.
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...