ROI, PBP and IRR

Key Financial Metrics Every Growing Company Should Track

For growing companies, every investment decision can have a substantial impact on the future success of the business. With limited resources and a need to scale rapidly, understanding the potential returns on investments is vital. Investors, whether they’re venture capitalists, angel investors, or even the founders themselves, need to assess the viability of investments to ensure the company’s growth trajectory remains positive. Three essential metrics help in evaluating the profitability and risk of these investments: Return on Investment (ROI), Payback Period (PBP), and Internal Rate of Return (IRR).  

Return on Investment (ROI) for Startups and Growing Businesses

ROI is king! Return On Investment is one of the most well known metrics and for small businesses ROI provides a clear and concise snapshot of how well an investment is performing. Since resources are limited and every penny counts, ROI helps company leaders and investors understand whether an investment is generating enough return to justify its cost.

• Why ROI Matters for Growing Businesses:
• Budgeting Efficiency: fast growing companies often work with tight budgets. ROI helps them decide which projects yield the best returns for their limited resources.
• Investor Confidence: When small businesses show strong ROI figures, it signals to investors that their capital is being put to good use, potentially leading to additional rounds of funding.
• No Time or Risk Considerations: However, ROI does not consider the time it takes to achieve the return, nor the risks involved.

Formula: In its simplest form, ROI refers to the return on an investment… so, if we are talking about investing (in a company or a project or an activity), the ROI is calculated as follows: ROI = Current Value of Investment − Cost of Investment Cost of Investment If instead we are looking at a broader economic activity, we can interpret the current value of the investment as the value generated by a specific activity within the business. In this sense, ROI can also be calculated as follows: ROI = Return (Net Income) Investment (Cost)  

Payback Period (PBP) to Reduce Risk in Growth Phases

For small, growing businesses, cash flow is everything. The Payback Period (PBP) measures how quickly an investment will pay for itself. It’s particularly useful when a company is scaling rapidly and needs to know how long it will take to recover the initial capital invested in a new product, technology, or market expansion.

• Why PBP is Crucial for Growing Companies:
• Cash Flow Management: In the early stages of growth, it’s critical to ensure investments pay off quickly to avoid cash flow shortages. A shorter payback period reduces financial strain, allowing the business to reinvest faster.
• Risk Reduction: For investors, a quick payback period indicates lower risk. A fast return on capital means that if a business faces unexpected challenges, it can still survive without suffering prolonged financial stress.
• Limited Temporal Frame and Opportunity Cost: However, Pay Back Period does not account for any returns beyond the payback point or factor in the time value of money.

Formula: You might have seen a very simple formula online, that divides the total investment by annual cash flow: PBP = Cost of Investment Average Annual Cash Flow However, in reality, it's rare for companies to have the same consistent cash flow year after year. Cash flow will likely grow over time, with very limited results in Year 1 and better and better results in the following years. How to calculate PBP in excel? So, how should you go about calculating your Payback Period in your Excel projections? First, start by calculating the Cumulative Cash Flow. Once you have that, you can see how many years will pass until you reach a positive Cumulative Cash Flow—that's when your company hits its PBP. Now, this gives you only an integer result: 1 year, 2 years, 3 years, etc. If you want a more granular approach, you can calculate the remaining fraction within the year in which your venture hits its Payback Period. To do this, divide the last negative Cumulative Cash Flow by the Cash Flow of the following year. This will give you the fraction of the year it takes for that new Cash Flow to close the negative gap in the Cumulative Cash Flow and reach zero. Number of years with negative Cumulative Cash Flow + Last negative Cumulative Cash Flow Annual Cash Flow Also, keep in mind that the negative cumulative cash flow will, of course, be negative. So, you’ll need to correct for that by using a formula like ABS() in Excel, which gives the absolute value of a number. Your formula might look something like this: Number of years with negative Cumulative Cash Flow: =COUNTIF(the whole line of the Cumulative Cash Flow) Fractional remaining value: =IF(AND(this year’s Cumulative Cash Flow>0, last year’s Cumulative Cash Flow < 0, ABS(Cumulative Cash Flow of last year) / Cash Flow of this year, “ - “) Payback Period Number of years with negative Cumulative Cash Flow + Fractional remaining value Example: Check the formulas on the spreadsheet here  

Internal Rate of Return (IRR) for Ensuring Long-Term Viability

Internal Rate of Return (IRR) is particularly important for growing companies with complex investment opportunities that span several years. Unlike ROI and PBP, which offer a snapshot of profitability, IRR accounts for the time value of money, giving a clearer view of long-term returns on investment. Even more importantly, IRR allows for the comparison of competing opportunities with very different characteristics. It identifies the rate at which the present value of an investment's cash inflows equals its initial cost, showing the return needed for the investment to break even. In this way, IRR helps select investments that will not only break even quickly but also generate the highest returns.

• Why IRR Matters to Growing Companies and Investors:
• Long-Term Planning: For small businesses, sustainable growth is key. IRR helps project the potential returns over a longer period, making it invaluable for long-term strategic investments such as expanding into new markets or launching a new product line.
• Attracting Investors: Investors in growing companies often look beyond immediate returns and focus on long-term growth potential. A strong IRR can make the business more attractive to venture capitalists or other funding sources.
• Time Periods are Important: IRR can give misleading results when comparing projects of different durations; using the Excel formula XIRR() can help address this issue by accounting for the exact timing of cash flows.

Formula Do you really want to know IRR’s formula? If yes, check it out on Investopedia’s website: they explain it better than we can! For practical purposes, however, you can simply use the IRR() function in Excel, which is quick and straightforward, or the more advanced XIRR() function, which accounts for the specific dates of your cash flows.  

Choosing the Right Financial Metric for Business Growth

• Each of these metrics provides different insights into an investment’s performance:
• ROI is a quick, straightforward measure of profitability but lacks a time component.
• IRR is a more advanced metric that considers the timing of cash flows and the time value of money, making it ideal for more complex investment comparisons.
• Payback Period helps assess how quickly you can recover your investment, useful for risk analysis, though it ignores returns beyond payback and the time value of money.

Understanding these financial metrics is crucial for making informed investment decisions. Depending on your project or investment goals, one or more of these metrics can be used to evaluate financial performance and guide strategic decisions. By leveraging ROI, Payback Period, and IRR, businesses can gain a comprehensive understanding of an investment’s potential, allowing for better decision-making and maximising returns.