Balance Sheet Modeling

Balance Sheet Modeling

Some balance sheet items, such as retained earnings, flow directly from the income statement. Others, such as accounts receivable, inventory, and accounts payable, are closely linked to income statement projections.

Working capital accounts are forecasted using efficiency ratios. For example, accounts receivable are forecast by estimating the number of days of sales outstanding and combining this assumption with a sales projection. Days sales outstanding are the average number of days a company takes to collect revenue from its customers. For example, if credit sales are $25 million and it usually takes a company 50 days to collect this amount from their customers, accounts receivable would be estimated to be $2.05 million ($15 million × 50/365). An analyst can forecast inventory by calculating an inventory turnover ratio and combining that with the cost of goods sold projection. The inventory turnover ratio measures how much inventory a company keeps on hand. Analysts can look at historical efficiency ratios and recent project performance or a historical average to persist in the future.

Projections for long-term assets such as property, plant, and equipment (PP&E) are less directly linked to the income statement. Net PP&E changes result from capital expenditures and depreciation, which are essential components of the cash flow statement. Depreciation forecasts are based on historical depreciation and disclosures about depreciation schedules. In contrast, capital expenditure forecasts depend on analysts’ judgment and future need for new PP&E. An organization’s capital expenditures are divided into maintenance capital expenditures, expenditures needed to sustain the current business, and growth capital expenditures, expenditures required to expand the business. Maintenance expenditures should be higher than depreciation because of inflation.

A company’s future debt and equity levels can be forecast using leverage ratios such as debt-to-capital, debt-to-equity, and debt-to-EBITDA. Analysts should consider historical practices, management’s strategy, and capital requirements when projecting the future capital structure.

After projecting the balance sheets and income statements, the future cash flow statement can be projected. The analyst will make assumptions about how a company will use its future cash flows, share repurchases, dividends, additional capital expenditures, and acquisitions.

Question

Which of the following is least likely a ratio used to forecast working capital accounts such as accounts receivables and inventory?

  1. Days sales outstanding.
  2. Inventory turnover ratio.
  3. Sensitivity analysis.

Solution

The correct answer is C.

Sensitivity analysis is a tool that involves changing only one assumption at a time to determine its effect on the estimate of the intrinsic value.

A is incorrect. Days sales outstanding is an efficiency ratio used to measure the average number of days a firm takes to collect revenue from its customers. It is used to forecast accounts receivable.

B is incorrect. The inventory turnover ratio is an efficiency ratio used to forecast inventory. It measures how much inventory a company keeps on hand.

Reading 17: Financial Statement Modeling

LOS 17 (f) Describe approaches to balance sheet modeling.

Shop CFA® Exam Prep

Offered by AnalystPrep

Featured Shop FRM® Exam Prep Learn with Us

    Subscribe to our newsletter and keep up with the latest and greatest tips for success
    Shop Actuarial Exams Prep Shop Graduate Admission Exam Prep


    Daniel Glyn
    Daniel Glyn
    2021-03-24
    I have finished my FRM1 thanks to AnalystPrep. And now using AnalystPrep for my FRM2 preparation. Professor Forjan is brilliant. He gives such good explanations and analogies. And more than anything makes learning fun. A big thank you to Analystprep and Professor Forjan. 5 stars all the way!
    michael walshe
    michael walshe
    2021-03-18
    Professor James' videos are excellent for understanding the underlying theories behind financial engineering / financial analysis. The AnalystPrep videos were better than any of the others that I searched through on YouTube for providing a clear explanation of some concepts, such as Portfolio theory, CAPM, and Arbitrage Pricing theory. Watching these cleared up many of the unclarities I had in my head. Highly recommended.
    Nyka Smith
    Nyka Smith
    2021-02-18
    Every concept is very well explained by Nilay Arun. kudos to you man!
    Badr Moubile
    Badr Moubile
    2021-02-13
    Very helpfull!
    Agustin Olcese
    Agustin Olcese
    2021-01-27
    Excellent explantions, very clear!
    Jaak Jay
    Jaak Jay
    2021-01-14
    Awesome content, kudos to Prof.James Frojan
    sindhushree reddy
    sindhushree reddy
    2021-01-07
    Crisp and short ppt of Frm chapters and great explanation with examples.