WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Accounting Tutorials » Budgeting Tutorials » Bottom-Up Forecasting

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

Bottom-Up Forecasting

Let’s take an example to understand the concept:

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 of the company for the next year. The details are mentioned below:

Given Data

Use Bottom-Up Approach to calculate the revenue

Solution:

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

Bottom-Up Forecasting Example 1

Step #2: Determine Operational Expenses and Interest Expense as per Forecast

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Example 1-1

Example 1-2

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

Bottom-Up Forecasting Example 1-3

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.

Advantages

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

Disadvantages

  • As it involves several micro factors, so it takes time for the study to get completed. All micro factors must be properly forecasted for this approach.
  • It is costly. In will require a team to be dedicated to gathering data from individual departments to carry out the approach. So it is costly to make the forecast.
  • The data collected will be provided by the specific department as per their productivity level. If a decision is taken as per the data, then it may happen that the forecast will not match reality if the key members of the team change.

Recommended Articles

This has been a guide to what is Bottom-Up Forecasting. Here we discuss examples and the difference between bottom-up forecasting and top-down forecasting along with advantages and disadvantages. You may learn more about financing from the following articles –

  • FP&A Analyst
  • Budgeting vs. Forecasting
  • Financial Planning and Analysis
  • Forecast in Excel
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Free Accounting Course

You will Learn Basics of Accounting in Just 1 Hour, Guaranteed!

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Download Bottom-Up Forecasting Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More