Financial Statement Modeling (2024)

Refresher Reading

Privacy Settings

Functional cookies, which are necessary for basic site functionality like keeping you logged in, are always enabled.

2024 Curriculum CFA Program Level II Corporate Finance

Two ways to enjoy this Refresher Reading

Available to members only. Login required.

Access the Full Reading in the Learning EcosystemDownload the full reading (PDF)

Introduction

Financial statement modeling is a key step in the process of valuing companies and the securities they have issued. We focus on how analysts use industry information and corporate disclosures to forecast a company’s future financial results.

An effective financial statement model must be based on a thorough understanding of a company’s business, management, strategy, external environment, and historical results. Thus, an analyst begins with a review of the company and its environment—its industry, key products, strategic position, management, competitors, suppliers, and customers. Using this information, an analyst identifies key revenue and cost drivers and assesses the likely impact of relevant trends, such as economic conditions and technological developments. An analyst’s understanding of the fundamental drivers of the business and assessment of future events provide the basis for forecast model inputs. In other words, financial statement modeling is not merely a quantitative or accounting exercise, it is the quantitative expression of an analyst’s expectations for a company and its competitive environment.

We begin our discussion with an overview of developing a revenue forecast. We then describe the general approach to forecasting each of the financial statements and demonstrate the construction of a financial statement model, including forecasted revenue, income statements, balance sheets, and statements of cash flows. Then, we describe five key behavioral biases that influence the modeling process and strategies to mitigate them. We turn to several important topics on the effects of micro- and macroeconomic conditions on financial statement models: the impact of competitive factors on prices and costs, the effects of inflation and deflation, technological developments, and long-term forecasting considerations. The reading concludes with a summary.

Most of the examples and exhibits used throughout the reading can be downloaded as a Microsoft Excel workbook. Each worksheet in the workbook is labeled with the corresponding example or exhibit number in the text.

Learning Outcomes

The member should be able to:

  • compare top-down, bottom-up, and hybrid approaches for developing inputs to equity valuation models;
  • compare “growth relative to GDP growth” and “market growth and market share” approaches to forecasting revenue;
  • evaluate whether economies of scale are present in an industry by analyzing operating margins and sales levels;
  • demonstrate methods to forecast cost of goods sold and operating expenses;
  • demonstrate methods to forecast nonoperating items, financing costs, and income taxes;
  • describe approaches to balance sheet modeling;
  • demonstrate the development of a sales-based pro forma company model;
  • explain how behavioral factors affect analyst forecasts and recommend remedial actions for analyst biases;
  • explain how competitive factors affect prices and costs;
  • evaluate the competitive position of a company based on a Porter’s five forces analysis;
  • explain how to forecast industry and company sales and costs when they are subject to price inflation or deflation;
  • evaluate the effects of technological developments on demand, selling prices, costs, and margins;
  • explain considerations in the choice of an explicit forecast horizon; and
  • explain an analyst’s choices in developing projections beyond the short-term forecast horizon.

Summary

Industry and company analysis are essential tools of fundamental analysis. The key points include the following:

  • Analysts can use a top-down, bottom-up, or hybrid approach to forecasting income and expenses. Top-down approaches usually begin at the level of the overall economy. Bottom-up approaches begin at the level of the individual company or unit within the company (e.g., business segment). Time-series approaches are considered bottom-up, although time-series analysis can be a tool used in top-down approaches. Hybrid approaches include elements of top-down and bottom-up approaches.
  • In a “growth relative to GDP growth” approach to forecasting revenue, the analyst forecasts the growth rate of nominal GDP and industry and company growth relative to GDP growth.
  • In a “market growth and market share” approach to forecasting revenue, the analyst combines forecasts of growth in particular markets with forecasts of a company’s market share in the individual markets.
  • Operating margins that are positively correlated with sales provide evidence of economies of scale in an industry.
  • Some balance sheet line items, such as retained earnings, flow directly from the income statement, whereas accounts receivable, accounts payable, and inventory are closely linked to income statement projections.
  • A common way to model working capital accounts is to use efficiency ratios.
  • Return on invested capital (ROIC), defined as net operating profit less adjusted taxes divided by the difference between operating assets and operating liabilities, is an after-tax measure of profitability. High and persistent levels of ROIC are often associated with having a competitive advantage.
  • Competitive factors affect a company’s ability to negotiate lower input prices with suppliers and to raise prices for products and services. Porter’s five forces framework can be used as a basis for identifying such factors.
  • Inflation (deflation) affects pricing strategy depending on industry structure, competitive forces, and the nature of consumer demand.
  • When a technological development results in a new product that threatens to cannibalize demand for an existing product, a unit forecast for the new product combined with an expected cannibalization factor can be used to estimate the impact on future demand for the existing product.
  • Factors influencing the choice of the explicit forecast horizon include the projected holding period, an investor’s average portfolio turnover, the cyclicality of an industry, company-specific factors, and employer preferences.
  • Key behavioral biases that influence analyst forecasts are overconfidence, illusion of control conservatism, representativeness, and confirmation bias.

Related

Members' Guide to 2023 Refresher Readings (PDF)

Microsoft Excel Workbook (login required)

3.25PL

Manage your Professional Learning credits

Categories

Fundamental Analysis

Quantitative Methods

Financial Statement Modeling (2024)

FAQs

Is financial modeling a hard class? ›

Learning financial modeling is challenging due to the complex formula logic and hidden assumptions involved. It requires technical and mathematical skills, as well as problem-solving and decision-making abilities. Financial modeling is more challenging to learn than accounting and investing.

Is financial modelling a hard skill? ›

You normally need to gain advanced Excel proficiency abilities, have an understanding of accounting and business, and be able to design simple models if you want to become proficient at financial Modeling. Compared to taking a course, learning financial Modeling on your own involves more work.

How long should a 3 statement model take? ›

The “strict time limit” could be anything from 30 minutes to 3-4 hours, and the complexity increases as the time limit increases. The “no strict time limit” type might give you several days or even 1 week+. There is still a deadline, but you don't need to rush around like a madman to finish.

What is the hardest financial course? ›

The Chartered Financial Analyst (CFA) program is widely regarded as one of the toughest courses in finance.

Can I learn financial modelling in 1 month? ›

The time it takes to learn financial modelling varies based on individual factors. Prior knowledge, learning resources, practice, and the complexity of the models all matter. While some might grasp the basics in a matter of weeks, mastering financial modelling can take several months to a year or more.

How fast can I learn financial modelling? ›

It depends on person to person how fast their learning and grasping power is. However, the minimum time required to learn the fundamentals of Financial Modeling is 30 to 40 days on average. Financial modeling training is required to understand the drivers and consequences of organizational decisions.

Which is better CFA or financial modelling? ›

While CFA offers prestige, Financial Modeling provides accessible practical skills. Proficiency in financial modeling enhances CFA pursuits. In simple terms, mastering both is pivotal for a successful finance career. CFA imparts theoretical knowledge, while Financial Modeling equips you with practical skills.

Can I learn financial modelling on my own? ›

To become skilled at financial modeling, you typically need to develop advanced Excel proficiency skills, have accounting and business knowledge, and know how to create simple models. Learning financial modeling on your own requires more legwork than taking a course.

How to build a financial model from scratch? ›

  1. STEP 1 : KNOW YOUR COMPANY. ...
  2. STEP 2 : UNDERSTAND THE INDUSTRY DYNAMICS. ...
  3. STEP 3 : START WITH THE AUDITED NUMBERS. ...
  4. STEP : 4 FIND THE ASSUMPTIONS. ...
  5. STEP 5 : FORECAST THE INCOME STATEMENT. ...
  6. STEP 6 : PREPARE THE SUPPORTING SCHEDULES. ...
  7. STEP 7 : COMPLETE STATEMENT OF PROFIT & LOSS (P&L) AND BALANCE SHEET.
May 20, 2023

How to prepare a financial model in Excel? ›

How to build a financial model in Excel in 5 steps
  1. Input historical data. Most financial models require historical financial data to function. ...
  2. Calculate ratios and metrics. ...
  3. Include financial assumptions. ...
  4. Build a forecast. ...
  5. Determine valuation.
Jun 24, 2022

What is a stub in financial modeling? ›

There is often a “stub period” at the beginning of the model, where only a portion of the year's cash flow is received. Additionally, the cash outflow (making the actual investment) is typically a spate time period before the stub is received.

How much do financial modelers make? ›

Financial Modeling Analyst Salary. $70,000 is the 25th percentile. Salaries below this are outliers. $116,500 is the 90th percentile.

How to do financial modelling for beginners? ›

Gain knowledge of financial statements, for instance, the income statement, balance sheet, and cash flow statement. Learn about critical financial metrics such as revenue, expenses, assets, liabilities, and equity. This foundation will help you grasp the principles that underpin financial modelling.

Can anyone learn financial modelling? ›

Absolutely. Coursera has business courses and Specializations on a wide range of topics, including financial modeling. You can take courses focused on areas like financial and quantitative modeling, statistics for financial analysis, and the use of programs like Microsoft Excel and Python in this field.

How long does it take to learn financial modeling? ›

The duration of studying financial modeling or valuation as a part-time student can vary depending on individual circ*mstances and the depth of knowledge desired. However, it typically takes several months to a year to gain a solid understanding of these subjects.

Are financial modeling courses worth it? ›

Financial modeling can be especially useful for startup founders and small business owners. You can use financial modeling to compare pricing models, calculate how much capital you need, and prepare to meet with investors.

Are financial modelling courses worth it? ›

It is a valuable, reliable method that helps many businesses grow. It is also why financial modelling analysts are in high demand. Many established professionals such as investment advisors, tax specialists and accountants got a head start in their careers by learning this essential skill.

Is financial modeling a good course? ›

Yes, financial modelling certification can enhance job prospects for fresh graduates by making them more competitive, showcasing practical skills, and opening doors to roles in investment banking, equity research, and corporate finance.

Top Articles
Latest Posts
Article information

Author: Arline Emard IV

Last Updated:

Views: 5977

Rating: 4.1 / 5 (72 voted)

Reviews: 95% of readers found this page helpful

Author information

Name: Arline Emard IV

Birthday: 1996-07-10

Address: 8912 Hintz Shore, West Louie, AZ 69363-0747

Phone: +13454700762376

Job: Administration Technician

Hobby: Paintball, Horseback riding, Cycling, Running, Macrame, Playing musical instruments, Soapmaking

Introduction: My name is Arline Emard IV, I am a cheerful, gorgeous, colorful, joyous, excited, super, inquisitive person who loves writing and wants to share my knowledge and understanding with you.