Forum Discussion
IRR or XIRR
Super UserHi garzajnc24
IRR cannot be computed if all values are the same sign. This is because there is no finite discount rate that would produce a zero NPV (see here for example).
Stepping back a bit, for IRR to make sense, you would need to define "cash inflows" and "cash outflows" based on your data for an IRR calculation to make sense (these can be notional inflows/outflows if necessary).
Looking at the tables you posted, did you want the IRR based on investment to date (outflow) and valuation at a point in time (inflow)?
Thank you for your response.
I've been tasked to recreate formulas in an Excel spreadsheet in PowerBI. The actual dates don't matter so much as the periods.
Their definition of valuation is EBITDA multiple x EBITDA. Easy to accomplish.
Second, they want IRR and MOIC for each period as a predictor (if in this period they exit what was the valuation, IRR, MOIC at that time)
MOIC = valuation / initial investment
IRR = IRR(C2:D3) for period 1
IRR(C5:36) for period 2 etc..
3. They want a stakeholder Cap table. But I'll just focus on the main table for now.