Projecting Balance Sheet Line Items

Designing a forecasted balance sheet

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.

Projecting Balance Sheet Line Items

Projecting balance sheet line items is typically done in conjunction with projecting income statement line items. Both of these skills are necessary when mastering the art of financial modeling. This guide breaks down, step-by-step, how to calculate and then forecast each of the line items necessary to forecast a complete balance sheet and build a 3 statement financial model.

Projecting Balance Sheet Line Items - Image of Forecast Balance Sheet

The above screenshot is from CFI’s financial modeling course.

Balance Sheet Forecast items

The following are the main accounts we need to cover when projecting balance sheet line items:

  • Assets
    • Accounts Receivables
    • Inventory
    • Other Current Assets
    • PP&E
    • Other Long-Term Assets
  • Liabilities
    • Accounts Payables
    • Long-term Debt
  • Equity
    • Shareholder Capital
    • Retained Earnings

These are the main line items that make for a functioning balance sheet.

Working Capital Line Items

Accounts Receivables, Inventory, and Accounts Payables are unique in that they have a very specific method of forecasting. Because these accounts are all involved in the operating and cash cycle, it is useful to forecast “days outstanding” for all of these accounts. Using the formula for their respective days outstanding, we can forecast future accounts receivables, inventory, and accounts payables.

The following are the formulas for annual days outstanding:

  • Accounts Receivable Days = Average AR / Sales Revenue x 365
  • Inventory Days = Average Inventory / Cost of Goods Sold x 365
  • Accounts Payable Days = Average AP / Cost of Goods Sold (or Purchases) x 365

After finding historical values for days outstanding, we can use these trends and reverse engineer the days outstanding formulas to find the accounts receivables, inventory, or accounts payables for that specific period.

Working Capital Example

Let’s take an example of accounts receivables. In the previous year, accounts receivables days outstanding was 120. If sales revenue was $100,000 for the year, then accounts receivables is found by:

Accounts Receivables = 120 x $100,000 / 365 = $32,876

Other Current Assets and Long-term Assets

We can forecast other current assets as a single line item or break them out as individual items. Projecting balance sheet line items through the latter method is a bit more involved, but will allow for more granularity and dynamism in the model.

The quick and dirty method of projecting balance sheet line items for current assets is to simply use a whole dollar value prediction for these accounts in the future, or follow the trend that already exists.

Property, Plant, and Equipment

Projecting PP&E is different from projecting other current assets and long-term assets. This projection requires building out a depreciation schedule for each class of PP&E. The balance displayed on the balance sheet is the closing balance.

Closing balance = Opening Balance + Capital Expenditures – Depreciation Expense

As you can see, the use of the depreciation schedule is tied to both the balance sheet and income statement. We use the closing balance on the balance sheet and the depreciation expense in the income statement.

Long-term Debt

Similar to PP&E with its depreciation schedule, long-term debt is forecasted using the debt schedule. This schedule outlines each class of borrowings and lays out the interest expense for each period. The balance displayed on the balance sheet is also the closing balance of long-term debt or the sum of all the closing balances of individual debt.

Closing balance = Opening Balance + Interest Expense – Repayments

It’s important to note that, here, interest expense is added back to the opening balance. In contrast, depreciation expense is deducted from the opening balance under PP&E. Keep this in mind and don’t forget to use the appropriate signs.

Shareholder Capital

Shareholder capital can be one of the simplest tasks when projecting balance sheet line items. More often than not, shareholder capital remains constant throughout periods, so forecasts will generally just be set to equal the latest known period.

Closing balance = Opening Balance + New Capital Issued – Capital Repurchased

Retained Earnings

Forecasting retained earnings actually involves projecting net income and dividends rather than retained earnings itself. This means that to finish projecting balance sheet line items, it’s handy to first finish projecting income statement line items, so as to have net income readily available. As always, the balance that is displayed on the balance sheet is the closing balance.

Closing balance = Opening Balance + Net Income – Dividends

The Ideal Order of Projecting Balance Sheet Line Items

Because we need certain items from the income statement, this is the best way of projecting balance sheet line items:

  1. Project income statement leading up to depreciation expense and interest expense
  2. Project balance sheet all the way through to retained earnings
  3. Finish projecting income statement by completing depreciation, interest, and tax expense
  4. Finish projecting balance sheet by completing retained earnings

Additional Resources

Thank you for reading CFI’s guide to Projecting Balance Sheet Line Items. To continue learning and advancing your career, these additional CFI resources will be very helpful:

Analyst Certification FMVA® Program

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.

 

Financial Analyst certification curriculum

 

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:

 

0 search results for ‘