O'Reilly logo

Business Analysis with Microsoft® Excel, Second Edition by Conrad Carlberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required