Chapter 12Balance Sheet Projections
Now that our cash flow is complete, we can proceed to the balance sheet, which begins in row 152. Before actually projecting the 2013 balance sheet, we need to pull in the pro-forma balance sheet numbers we calculated in our balance sheet adjustments analysis. We can simply link those numbers into 2012PF Column F.
We can begin by linking the cash balance in from the cash line in the “Balance sheet adjustments” section. So, F158 will read “=H111.” The next line, “Receivables,” will link in from cell H112 in the “Balance sheet adjustments” section. We could simply copy the formula from cell F158 down to cell F159. We can continue copying down; however, the “Totals” should calculate the total top-down, as one would in any period. This process will continue until we have a representation of the pro-forma balance sheet here to build our projections.
| Balance Sheet Item | Formula |
| Cash and cash equivalents (cell F158) | =H111 |
| Receivables (cell F159) | =H112 |
| Inventories (cell F160) | =H113 |
| Prepaid expenses and other current assets (F161) | =H114 |
| Deferred income taxes and receivables (F162) | =H115 |
| Total current assets (cell F163) | =SUM(F158:F162) |
| Property, plant, and equipment, net (cell F164) | =H117 |
| Goodwill (cell F165) | =H118 |
| Other intangibles, net (cell F166) | =H119 |
| Investment in Boise Cascade Holdings, LLC (cell F167) | =H120 |
| Timber notes receivable (F168) | =H121 |
| Deferred income taxes (F169) | =H122 |
| Other noncurrent assets (cell F170) |
Get Mergers, Acquisitions, Divestitures, and Other Restructurings, + Website now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
