Estimating a company’s future performance by working “up” to revenue
Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.
Bottom-up forecasting is a method of estimating a company’s future performance by starting with low-level company data and working “up” to revenue. This approach starts with detailed customer or product information and then broadens up to revenue. This guide will provide examples of how it works and explain why it’s commonly used in financial modeling and valuation.
As you can see in the screenshot below, a financial analyst begins the analysis by outlining the total orders that will be placed for each of the company’s business channels. This is a common place for starting a bottom-up analysis, although it is possible to start “further down” at something like website traffic, for example.
In this example, since the company sells its products through different marketing channels, it’s important to estimate the number of orders from each channel, and prices and costs may vary. In the course, we provide the estimated website traffic and conversion rates to arrive at the number of orders.
Step #2 Product/Service Prices
The next step is to estimate how much the company will charge customers for its products and/or services. Continuing with the E-commerce Course, you can see that we estimate the company charges an average of $275 per order in 2016, but after discounts and promotions, the net value per order is $193.
Step #3 Revenue
With the volume of orders and average net sales prices in place, we can calculate the company’s estimated revenue by multiplying the number of orders and the average price. Depending on the level of detail in your financial model, you may also wish to add other assumptions, such as returns, refunds, exchanges, chargebacks, and other items that may net out. You may also wish to include customer-level detail like total customers, retention rate, and churn rate.
Bottom-Up vs. Top-Down Forecasting
The opposite approach to bottom-up forecasting is called top-down forecasting, which begins with broad assumptions like Total Addressable Market (TAM) and market share to work “down” to revenue. It is also a very common method of building a forecast in financial modeling and valuation.
Below is a break down of subject weightings in the FMVA® financial analyst program. As you can see there is a heavy focus on financial modeling, finance, Excel, business valuation, budgeting/forecasting, PowerPoint presentations, accounting and business strategy.
A well rounded financial analyst possesses all of the above skills!
Additional Questions & Answers
CFI is the global institution behind the financial modeling and valuation analyst FMVA® Designation. CFI is on a mission to enable anyone to be a great financial analyst and have a great career path. In order to help you advance your career, CFI has compiled many resources to assist you along the path.
In order to become a great financial analyst, here are some more questions and answers for you to discover:
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Already have a Self-Study or Full-Immersion membership? Log in
Access Exclusive Templates
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.