# Bottom-Up Forecasting

## What is Bottom-Up Forecasting?

Bottom-Up forecasting refers to the projection of micro-level inputs of a company to reach the revenue and income for a particular year. However, estimation of these micro factors that leads to the revenue is difficult to forecast as it is company specific and depends on various factors.

### Example of Bottom-Up Forecasting

Let’s take an example to understand the concept:

For eg:
Source: Bottom-Up Forecasting (wallstreetmojo.com)

You can download this Bottom-Up Forecasting Excel Template here – Bottom-Up Forecasting Excel Template

Company ABC is a pen producing company. An investor is trying to forecast the revenue for the next year. The details are mentioned below:

Use Bottom-Up Approach to calculate the revenue

Solution:

Step #1: Determining Next year’s sale and price as per forecast

Step #3: The overall income statement looks like this –

### Bottom-Up vs. Top-Down Forecasting

Bottom-Up Approach starts with Micro factors that are company-specific and reaches the revenue. On the other hand, the Top-Down approach helps in forecasting the revenue of a company by using macro factors. In Top-Down approach say the GDP is forecasted to determine whether the sell quantity of a company will increase or decrease. Sector-specific aggregate demand is forecasted to determine the demand for goods. Relaxation of export terms also increases the demand for goods. Depreciation of currency increases the demand for goods. So all these are macro factors that are considered while doing Top-Down Forecasting.

• This approach is more practical than Top-Down. In Bottom-Up forecasting, the actual sales of a company are predicted by seeing its products demand in the market as the demand is being compared from the previous year to the current year. So it is more realistic. It deals with the companies fundamental data.
• This approach is dependent on the company’s data, so they are accurate. A Financial Analyst will not have to depend on third-party data to do the forecasting. Real data makes the forecasting stronger as the trends can be validated from the company’s past data.
• Companies may have different segments. Bottom-Up finds the demand of each segment, so it will help companies to allocate resources accordingly. It makes the company more efficient while making capital budgeting decisions.
• As the decision is based on micro factors, so it gives a clear picture of the higher management about the company. Management is aware of the expenditure being conducted by each segment and whether it will be possible to reduce the expenditure in order to improve productivity.