Discover how the Internal Rate of Return (IRR) is used in financial analysis to measure the profitability of potential investments. Learn about a practical example involving a company's software purchase and how the IRR was calculated to determine the investment's viability.
Key Insights
- The Internal Rate of Return (IRR) is a common metric used in financial analysis to estimate the profitability of prospective investments.
- IRR is derived using the same principle as the Net Present Value (NPV), where the NPV is set equal to zero.
- A higher IRR typically indicates a more desirable investment opportunity.
- In the given example, a company invests $45,000 in software that improves process efficiency, thus saving money over the next five years.
- For investment analysis, outflows such as the initial investment are considered negative, while inflows like savings from efficiency are considered positive.
- The example project's IRR is 23%, indicating that the software investment would be financially beneficial for the company in the long run.
Build a Financial Model
-
Lay Out Assumptions
Inputs at the top, color-coded blue — never hardcoded in formulas.
-
Build the Income Statement
Revenue, COGS, OpEx, EBITDA — driven by assumptions.
-
Add Balance Sheet
Working capital, fixed assets, debt — must balance.
-
Cash Flow Reconciles
Operating, investing, financing — ties to balance sheet cash.
The internal rate of return (IRR) is a metric used in financial analysis to estimate the profitability of potential investments.
IRR is calculated using the same concept as net present value (NPV), except it sets the NPV equal to zero.
Generally speaking, the higher an internal rate of return, the more desirable an investment is to undertake.
In our example, the company purchases an important software for $45,000. That software saves money to the company in the next 5 years as it increases efficiency of the processes. Let’s see what the IRR would be for the company in this case scenario.
Please make sure that your investment of $45,000 is negative – it’s cash outflow. The money saved are cash inflows, therefore they are positive.
E28 = IRR(F21:F26)
IRR for that project is 23%, meaning it’s totally worth it to invest into the software to save money in the future.
