This glossary pulls together common pharmaceutical terms. Terms range from those used in forecasting, to more general pharmaceutical terms.
Simply select the letter from the options, and the correlating terms and definitions will be shown underneath. Please note terms will need to be expanded to show definitions.


Linking an NPV to your sales forecast

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

Trending Example

Trending is one of the key principles that underlay best practice forecasting. Time series trending applies when you have a single data set or one row of data. Briefly, this approach involves plotting historical data against time, and then trending this into the future using an excel generated formula.

We have pulled together an example of how to carry out time series trending within Excel. This can be viewed within the video, or through downloading the related Excel document.

This example aims to walks you through how to trend out historical data within excel, step by step. It will take you through from inputting your historical data, to selecting an appropriate trending curve, and finally to calculating trended data. The example also covers how to convert trend line equations into those recognised by Excel.

If you would like to find out any further information on the principles of trending, the time series trending approach, or other trending methodologies, please visit the training section of theHub or contact us.

Time Series Trending Example Excel – Download