Linking an NPV to your sales forecast
Learn how to link your forecast to a Profit & Loss account, determining Net Present Value can make for much better evaluation of opportunities.
In our latest series of blogs, we’ll be sharing tips and insights gained over the course of our many years of experience.
The first three of these will focus on Sales Forecasting, and how linking your forecast to a Profit & Loss account, determining Net Present Value can make for much better evaluation of opportunities.
We’ll now hand over to Kris Barker, Senior Consultant here at J+D Forecasting:
As with many a forecast, the resulting outputs may well be used to drive a go/ no-go decision with regard to progressing the development of as asset or purchasing an asset from another company. To help with this decision, senior management will require more information than just the predicted net sales from your forecast model.
They will need to understand the cost of generating these sales, be it cost of goods, distribution costs, sales force costs etc. And ultimately, they will need to understand the present day value of the future cash stream so that they can compare the opportunity with others that they may be considering at the same time.
As a result, linking your forecast to a profit and loss account that helps you to clearly and consistently present your ‘opportunity’ to senior management is important. This can also be a good way of engaging other colleagues (e.g. finance) into the forecasting process. Ultimately, for the evaluation of a go/ no-go decision, the Net Present Value (NPV) of any opportunity will need to meet the internal requirements of each specific organisation.
In the screen shot below, you can see the calculated NPV for a particular asset. If the internal requirement is that any future opportunity needs to have a positive NPV, then this asset is worth considering. If the internal requirement is that any future opportunity needs to have an NPV of at least $10m, then this asset may not be worth considering.
Feel free to download an example model that links a P&L (including NPV) to the forecast model itself. Please note that linking a P&L to your forecast can be done using any of the FC+ addins.
The link above provides you with an NPV Calculator to be used in Microsoft Excel. Here are definitions and more information on some of the terms used in Kristian’s post above.
Net Present Value (NPV)
Net present value (NPV) is the difference between the present value of cash inflows and the present value of cash outflows over a period of time. NPV is used in capital budgeting and investment planning to analyze the profitability of a projected investment or project. Source
Positive Net Present Value
The purpose of net present value is to help analysts and managers decide whether or not new projects are financially viable. Essentially, net present value measures the total amount of gain or loss a project will produce compared to the amount that could be earned simply by saving the money in a bank or investing it in some other opportunity that generates a return equal to the discount rate. If a long-term project has a positive net present value, then it is expected to produce more income than what could be gained by earning the discount rate, which means the company should go ahead with the project. Source
Negative vs Positive Net Present Value
If the net present value of a project or investment, is negative it means the expected rate of return that will be earned on it is less than the discount rate (required rate of return or hurdle rate). This doesn’t necessarily mean the project will “lose money.” It may very well generate accounting profit (net income), but, since the rate of return generated is less than the discount rate, it is considered to destroy value. If the NPV is positive, it creates value. Source
Profit & Loss (P&L) Statement — Formula & Example
The profit & loss statement summarises the revenues and expenses generated by the company over the entire reporting period. The profit & loss statement is also known as the income statement, statement of earnings, statement of operations, or statement of income. The basic equation on which a profit & loss statement is based is Revenues – Expenses = Profit. Source
You might also be interested in our blog – Top 5 Tips for Oncology Forecasting