Measuring Profit
To this point, the sensitivity analysis has been simplified by considering only one measure of profit: payback period. There are other measures that you can use, and each of these alternatives provides another point of view on your profit. These include the Internal Rate of Return and the Profitability Index.
Calculating Internal Rate of Return
Given the assumptions used in the Base Case, it is apparent that introducing a new product will generate more than a 10% return on the funds that the project requires. This is easy to determine from the net present value of the project. Taking the discount rate (10%) into account, the project returns a positive net present value. The company therefore has positive earnings compared to ...
Get Business Analysis with Microsoft® Excel, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
