The following are the main accounts we need to cover when projecting balance sheet line items:
Other Current Assets
Other Long-Term Assets
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.
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.
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.
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 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
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:
Project income statement leading up to depreciation expense and interest expense
Project balance sheet all the way through to retained earnings
Finish projecting income statement by completing depreciation, interest, and tax expense
Finish projecting balance sheet by completing retained earnings
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: