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.
| +225 | Coverage Banking is Paradise | 28 | 8h |
| +96 | London Recruiting is Paradise | 42 | 33m |
| +75 | My Motivation Is At An All Time High | 13 | 2d |
| +57 | Are Canadians still get jobs in the US? | 41 | 1h |
| +40 | Is 7 years in banking enough to retire, or am I delusional? | 24 | 6h |
| +32 | MM IB --> NYC IB? | 17 | 4h |
| +31 | Do actual investment bankers despise IB TikTokers as much as I think they do? | 21 | 35m |
| +24 | Negotiating VP Sign-On Bonus (NOT Tied to Deferred Comp)? | 21 | 1d |
| +24 | Should I escape the matrix | 3 | 2d |
| +23 | Lawyer moving into Banking | 19 | 8h |
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%.
Aspernatur id quia quas sunt. Omnis blanditiis quaerat non illo sunt nemo omnis. Consequatur unde ullam eligendi. Nobis quia ratione aspernatur deserunt saepe omnis at aperiam. Veniam nisi hic culpa natus dolor vel enim. Quos laborum consequuntur et itaque id quo est.
Non et autem sed voluptas. Quae voluptatem esse aut odit. Maiores possimus odit est quod recusandae reprehenderit quo.
Quod doloribus quia dolorem ad recusandae eum. Optio cumque at rem voluptatem consequatur beatae veritatis. Quos facere deleniti optio fuga voluptatibus impedit.
Sed corporis ipsa iste ex doloribus amet id. Exercitationem voluptas enim vel et accusamus voluptates magni. Minima repellendus quisquam animi sed tempora perferendis tenetur occaecati. Ea soluta commodi reiciendis consequuntur eos ea nihil. Et itaque repellat illo aut magnam qui. Praesentium nemo rem qui.
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...