NPV and IRR formulas - case study

I don't see any break even point. The NPV and IRR seem accurate as you never overcome that initial investment value (I2), which I assume is some sort of loan? If so, should the sum of column M equal I2? As an aside, is the 'Own capital invested' (K7) part of that initial investment or does it really occur after the first year? Just make sure you are not double counting that amount.

Your chart is showing your profit/loss between income and costs. It is ignoring that 116,250 initial investment.

Your NPV and IRR calculations are including that 116,250 investment.

I'm not sure how you want to present your data or what you are trying to analyze; however, I would say that you should include that 116,250 investment, and, as you can see, your 'Cumulative Results' (column T) never exceed that amount. That is why I said you have not reached a break even. I'm also unsure why your CF (cashflow?) doesn't include your own capital invested. I think it should, as it is not 'free' money and is tied to this analysis.

It doesn't work in my version of Microsoft Excel