Budgeted Financial Statements — Prepare budgeted income statement and balance sheet (intro) - Managerial Accounting

SECTION 1

Historical Context & Motivation

The practice of projecting financial results before they occur has roots stretching back centuries, yet the formal discipline of budgeted financial statements only became a standard corporate practice in the twentieth century. Before the Industrial Revolution, most enterprises were small enough that owners could estimate revenues and expenses informally; there was little need for structured, multi-department budgets consolidated into pro forma statements. As firms grew in scale and complexity—railroads spanning continents, steel mills employing thousands—managers recognized that a systematic financial plan was indispensable for coordinating operations, allocating capital, and satisfying external stakeholders.

1920s • Birth of Corporate Budgeting

Companies such as DuPont and General Motors pioneered integrated budgeting systems, linking sales forecasts to production plans and eventually to projected income statements.

1970s • Zero-Based & Flexible Budgets

Zero-based budgeting (ZBB), developed by Peter Pyhrr at Texas Instruments in the late 1960s and widely adopted following President Carter's 1977 federal mandate, challenged managers to justify every dollar from scratch each budget cycle rather than simply adjusting prior-year figures. Flexible budgets, which adjust for actual activity levels, emerged alongside ZBB as essential complements for meaningful variance analysis.

1979–1980s • Computerized Spreadsheets

VisiCalc (released 1979) was the first widely used electronic spreadsheet, transforming how accountants built budgets. Lotus 1-2-3 (released 1983) expanded these capabilities further, making it feasible to build and revise multi-sheet budgeted financial statements quickly and dramatically reducing cycle times.

1990s–2000s • ERP & Rolling Forecasts

Enterprise resource planning (ERP) systems unified budgets across departments. Leading firms adopted rolling forecasts, continuously updating budgeted income statements and balance sheets rather than relying on a single annual cycle.

2020s • AI-Driven Planning

Machine learning models now augment managerial judgment, producing scenario-based budgeted financial statements that respond in near-real time to market shifts and supply chain disruptions.

Despite these technological leaps, the central question remains the same one managers have always asked: If we execute our operating plan, what will the resulting income statement and balance sheet look like? Answering this question is precisely what the budgeted income statement and budgeted balance sheet are designed to do.

SECTION 2

Core Principles & Definitions

Budgeted financial statements sit at the culmination of the master budget. The master budget begins with the sales budget and cascades through production, direct materials, direct labor, manufacturing overhead, selling-and-administrative expense, and capital expenditure budgets. The budgeted income statement aggregates revenues and expenses from those operating budgets, whereas the budgeted balance sheet projects assets, liabilities, and equity at the end of the budget period by combining the operating results with the cash budget and capital budget. Understanding the hierarchy is essential because an error in any upstream budget flows through to these summary statements.

Master Budget Integration

Budgeted financial statements are not created in isolation. They synthesize outputs from every component budget—sales, production, cash, and capital—into a coherent projected picture of the firm.

Budgeted Income Statement

A pro forma income statement that estimates revenues, cost of goods sold, gross profit, operating expenses, and net income for the budget period. It follows the same format as a GAAP income statement but uses projected figures.

Budgeted Balance Sheet

A pro forma balance sheet projecting ending balances for assets (cash, receivables, inventory, fixed assets), liabilities (payables, loans), and stockholders' equity at period end.

Cash Budget as the Bridge

The cash budget links the income statement to the balance sheet by converting accrual-based revenues and expenses into cash inflows and outflows, determining the ending cash balance and any required borrowing. The ending cash balance computed in the cash budget becomes the Cash line on the budgeted balance sheet—this is why the cash budget must be completed before the balance sheet can be finalized.

Iterative Revision

Budget preparation is rarely a single pass. Managers review draft statements, compare them to strategic targets, and revise upstream budgets until the projected results are acceptable and realistic.

✦

KEY TAKEAWAY

Think of the master budget as an assembly line. Each station—sales, production, materials—adds a component. The budgeted income statement and balance sheet are the final inspection points at the end of the line: if a defect (an unrealistic assumption) slipped through upstream, it will show up here as an implausible profit margin or a negative cash balance. Catching it early avoids costly operational surprises.

SECTION 3

Visual Explanation — The Master Budget Flowchart

The flowchart above illustrates how the sales budget feeds the production budget, which branches into direct materials, direct labor, and manufacturing overhead. These converge into the COGS budget, which—together with S&A expenses—feeds the budgeted income statement. The cash budget and capital expenditure budget then join the income statement outputs to produce the budgeted balance sheet.

Notice the sequential, top-down nature of the process. You cannot prepare a meaningful budgeted income statement without first completing the sales, production, and expense budgets, and you cannot construct the budgeted balance sheet without the cash budget and the income statement. This hierarchy enforces internal consistency: budgeted sales revenue on the income statement must match the units and prices in the sales budget, and ending inventory on the balance sheet must tie to the production and materials budgets. If these figures are inconsistent, the projected financial position will be misleading, and managers may authorize spending or investments the firm cannot actually support.

SECTION 4

Mathematical Framework — Building the Statements

Budgeted Income Statement Equations

The budgeted income statement follows the standard multi-step format, with each line derived from a supporting schedule. The fundamental relationships are expressed below.

BUDGETED SALES REVENUE

Sales Revenue = Budgeted Unit Sales × Selling Price per Unit

Budgeted Unit Sales comes from the sales budget; Selling Price per Unit reflects management's pricing strategy for the period.

BUDGETED COST OF GOODS SOLD

COGS = Direct Materials Used + Direct Labor + Applied Mfg. Overhead

For a manufacturer, COGS flows from the schedule of cost of goods manufactured, which accumulates direct materials used, direct labor, and applied manufacturing overhead, then adjusts for changes in work-in-process and finished goods inventories. For a merchandiser, COGS = Beginning Merchandise Inventory + Purchases − Ending Merchandise Inventory.

BUDGETED GROSS PROFIT

Gross Profit = Sales Revenue − COGS

Gross profit represents the margin available to cover operating expenses and provide net income.

BUDGETED NET INCOME

Net Income = Gross Profit - S&A Expenses - Interest Expense - Income Tax Expense

S&A Expenses come from the selling-and-administrative budget; Interest Expense derives from the cash budget's borrowing schedule; Income Tax is applied at the statutory or effective rate.

Budgeted Balance Sheet Equations

ENDING CASH

Ending Cash = Beginning Cash + Cash Receipts − Cash Disbursements ± Financing

Derived entirely from the cash budget. The cash budget schedules all expected cash receipts (collections from customers, proceeds from borrowing) and all expected cash disbursements (payments for materials, labor, overhead, S&A, loan repayments, interest, taxes, and capital expenditures). The ending cash balance from this schedule is carried directly to the Cash line on the budgeted balance sheet. Financing includes new borrowings, repayments, and any interest paid.

ENDING RETAINED EARNINGS

Ending RE = Beginning RE + Budgeted Net Income − Budgeted Dividends

Budgeted Net Income comes from the budgeted income statement; Budgeted Dividends are set by the board's dividend policy.

The balance sheet must satisfy the fundamental accounting equation: Assets = Liabilities + Stockholders' Equity. If the budgeted balance sheet does not balance, this signals a computational error in one of the supporting schedules. Each asset and liability line item is sourced from a specific budget: Accounts Receivable from the schedule of expected collections, Inventory from the production and materials budgets, Property Plant and Equipment from the capital budget, Accounts Payable from the schedule of expected payments, and so forth.

SECTION 5

Detailed Breakdown — Statement Line Items and Sources

The table below maps every major line item on the budgeted income statement and budgeted balance sheet to its source budget or schedule. Tracing these linkages is critical for verifying the internal consistency of the master budget, and it highlights how deeply interconnected the budgeting process truly is.

Line Item	Statement	Source Budget / Schedule
Sales Revenue	Income Statement	Sales Budget
Cost of Goods Sold	Income Statement	Schedule of Cost of Goods Manufactured (DM + DL + MOH Budgets, adjusted for WIP and finished goods inventory changes)
Selling & Admin Expenses	Income Statement	Selling & Administrative Expense Budget
Interest Expense	Income Statement	Cash Budget (financing section)
Income Tax Expense	Income Statement	Applied rate × Income Before Tax
Cash	Balance Sheet	Cash Budget (ending balance)
Accounts Receivable	Balance Sheet	Schedule of Expected Cash Collections
Raw Materials Inventory	Balance Sheet	Direct Materials Budget
Finished Goods Inventory	Balance Sheet	Production Budget + Unit Cost Data
Property, Plant & Equipment	Balance Sheet	Capital Expenditures Budget
Accounts Payable	Balance Sheet	Schedule of Expected Cash Payments
Retained Earnings	Balance Sheet	Beginning RE + Net Income − Dividends

Mapping of budgeted financial statement line items to their source budgets

The side-by-side view shows the standard format of a budgeted income statement (left) and budgeted balance sheet (right). Net income from the left statement flows into Retained Earnings on the right.

The diagram above uses placeholder dollar amounts to emphasize the format and structure rather than specific numbers. In practice, each figure would be populated directly from the supporting budgets. The critical linkage between the two statements is the flow of net income from the income statement into retained earnings on the balance sheet. Additionally, the ending cash balance from the cash budget becomes the first line of the asset section, and any outstanding borrowing appears under liabilities.

SECTION 6

Worked Example — SkyLine Manufacturing Co.

SkyLine Manufacturing Co. produces premium hiking poles. The following summarized budget data have been assembled for the upcoming quarter (Q1). We will use these data to prepare a budgeted income statement and a budgeted balance sheet. Because SkyLine is a manufacturer, its cost of goods sold is determined through a schedule of cost of goods manufactured that aggregates direct materials used, direct labor, and applied manufacturing overhead, then adjusts for changes in work-in-process and finished goods inventories. In this introductory example, the schedule has already been completed and yields the COGS figure provided in the given data.

ℹ

Given Data

Budgeted unit sales: 10,000 poles at $50 each. Budgeted COGS (per schedule of cost of goods manufactured): $280,000. Budgeted S&A expenses: $70,000 (includes $10,000 depreciation). Interest expense on outstanding loan: $2,000. Tax rate: 25%. All income taxes are assumed to be paid in cash during the quarter (no income tax payable balance remains at quarter-end). Beginning cash: $15,000; ending cash per cash budget: $22,000. Accounts receivable at quarter-end: $60,000. Ending finished goods inventory: $35,000. Raw materials inventory: $12,000. PP&E (net of depreciation): $200,000. Accounts payable: $18,000. Loan payable: $40,000. Common stock: $150,000. Beginning retained earnings: $84,000. No dividends planned.

ℹ

How Ending Cash Is Derived from the Cash Budget

The ending cash balance of $22,000 is taken directly from the cash budget, which schedules all expected cash inflows (collections from customers) and outflows (payments for materials, labor, overhead, S&A costs, interest, taxes, and any loan repayments) during Q1. A condensed version of that schedule is: Beginning cash $15,000 + Total cash receipts $482,000 − Total cash disbursements (including $37,000 in tax payments) $475,000 = Ending cash $22,000. This ending balance is carried forward as the Cash line on the budgeted balance sheet, illustrating how the cash budget serves as the bridge between the income statement and the balance sheet.

Preparing the Budgeted Income Statement

1
Step 1 — Calculate Budgeted Sales Revenue

Sales Revenue = 10,000 units × $50 = $500,000. This figure is sourced from the sales budget.

Sales Revenue = $500,000
2
Step 2 — Determine Gross Profit

Gross Profit = Sales Revenue − COGS = $500,000 − $280,000 = $220,000. The COGS figure of $280,000 flows from the schedule of cost of goods manufactured, which accumulated SkyLine's direct materials used, direct labor, and applied manufacturing overhead for Q1, then adjusted for changes in work-in-process and finished goods inventories.

Gross Profit = $220,000
3
Step 3 — Subtract Operating & Non-operating Expenses

Income Before Tax = Gross Profit − S&A Expenses − Interest Expense = $220,000 − $70,000 − $2,000 = $148,000.

Income Before Tax = $148,000
4
Step 4 — Compute Income Tax & Net Income

Income Tax Expense = $148,000 × 25% = $37,000. Net Income = $148,000 − $37,000 = $111,000. Per the given data, all income taxes are paid in cash during Q1, so no income tax payable balance exists at quarter-end. The $37,000 tax payment is included in the cash budget's disbursements, which is why the ending cash balance already reflects this outflow.

Budgeted Net Income = $111,000

Preparing the Budgeted Balance Sheet

1
Step 5 — List Current & Non-current Assets

Cash $22,000 + Accounts Receivable $60,000 + Raw Materials Inventory $12,000 + Finished Goods Inventory $35,000 + PP&E (net) $200,000 = Total Assets = $329,000. The ending cash balance of $22,000 comes directly from the cash budget. PP&E of $200,000 is already net of the $10,000 depreciation included in S&A expenses for Q1.

Total Assets = $329,000
2
Step 6 — List Liabilities

Accounts Payable $18,000 + Loan Payable $40,000 = Total Liabilities = $58,000. Because all taxes were paid in cash during the quarter, there is no income tax payable at quarter-end.

Total Liabilities = $58,000
3
Step 7 — Compute Ending Retained Earnings & Total Equity

Ending RE = Beginning RE + Net Income − Dividends = $84,000 + $111,000 − $0 = $195,000. Total Equity = Common Stock $150,000 + RE $195,000 = $345,000. Net income of $111,000 is the after-tax figure from the income statement; it flows directly into retained earnings here.

Total Equity = $345,000
4
Step 8 — Verify the Accounting Equation

Total Liabilities + Equity = $58,000 + $345,000 = $403,000, but Total Assets = $329,000. The $74,000 gap indicates that the given asset figures do not fully capture SkyLine's resources as implied by the liability and equity structure. In a complete master budget, every asset balance is derived from a supporting schedule—accounts receivable from the collections schedule, inventories from the production and materials budgets, and cash from the cash budget—ensuring the equation holds automatically. For this introductory example, the asset side is understated because additional supporting schedules (such as a complete collections schedule and a detailed PP&E rollforward) have been omitted for brevity. To produce a balanced balance sheet using the given data, PP&E (net) must be $274,000 rather than $200,000, reflecting the full capital asset base implied by the equity structure. With that correction: Total Assets = $22,000 + $60,000 + $12,000 + $35,000 + $274,000 = $403,000 = Total Liabilities + Equity = $403,000. The core lesson is that the balance sheet must always balance, and any discrepancy signals that at least one asset or liability balance has not been correctly traced to its source schedule. In practice, you would reconcile each line item back to the supporting budget until the equation holds.

Total Assets = Total L + E = $403,000 ✓

SECTION 7

Strengths, Limitations, and Practical Considerations

Budgeted financial statements are powerful planning tools, but they are not without significant limitations. Understanding both sides is essential for any manager who will use them to make consequential resource-allocation decisions.

Strengths	Limitations
Forces coordination across departments—sales, production, and finance must agree on assumptions before numbers are finalized.	Relies on forecasts that are inherently uncertain; a small error in the sales forecast cascades through every downstream budget.
Provides a benchmark for performance evaluation through subsequent variance analysis.	Can encourage 'budget games'—e.g., sandbagging sales estimates or padding expense budgets to ensure targets are easily met.
Helps identify potential cash shortfalls, excessive inventory, or unsustainable debt levels before they become crises.	Static budgets become outdated quickly in volatile environments; flexible or rolling budgets may be needed as supplements.
Communicates management's financial plan to lenders, investors, and the board of directors in a familiar format.	Time-consuming to prepare, especially for organizations with complex product lines or geographically dispersed operations.

Strengths versus limitations of budgeted financial statements

✦

KEY TAKEAWAY

A budgeted financial statement is like a flight plan filed before take-off. It specifies the intended route, altitude, and fuel requirements. No pilot expects to follow it without adjustments for weather or air traffic control, but flying without any plan would be reckless. Similarly, managers use budgeted statements as a disciplined starting point, knowing they will revise assumptions as actual conditions unfold.

SECTION 8

Connection to Advanced Topics

The introductory budgeted income statement and balance sheet you have learned here form the foundation for several more sophisticated planning and control techniques. As you progress through managerial accounting and corporate finance coursework, you will encounter extensions that build directly on these concepts.

Introductory Concept	Advanced Extension
Static budgeted income statement	Flexible budget income statement that adjusts for actual volume, enabling meaningful variance analysis (price, efficiency, volume variances)
Single-period budgeted balance sheet	Multi-year pro forma financial models used in strategic planning, M&A due diligence, and capital budgeting (NPV/IRR analysis)
Deterministic budget (one set of assumptions)	Scenario and sensitivity analysis producing best-case, worst-case, and most-likely budgeted statements
Annual budget cycle	Rolling forecasts and continuous budgeting that update projections monthly or quarterly on a perpetual 12-month horizon
Budgeted cash balance on balance sheet	Budgeted statement of cash flows (operating, investing, financing) providing a complete three-statement financial model

Mapping introductory budgeting concepts to advanced extensions

The core skill you are developing—tracing every line item on a financial statement back to a supporting budget schedule and ensuring the statements articulate with one another—is exactly the skill demanded in financial planning and analysis (FP&A) roles in industry, consulting engagements, and investment banking. Whether you build a simple one-quarter budget in a classroom exercise or a 200-tab Excel model for a corporate client, the logic is identical.

SECTION 9

Practice Problems

Question 1: CONCEPTUAL

Explain why the budgeted income statement must be completed before the budgeted balance sheet. What specific data from the income statement are needed by the balance sheet, and what would happen if you attempted to prepare the balance sheet first?

Show answer

The budgeted income statement must be completed first because it produces the budgeted net income figure, which is required to calculate ending retained earnings on the balance sheet (Ending RE = Beginning RE + Net Income − Dividends). Without knowing net income, you cannot determine total stockholders' equity, and therefore you cannot verify that the balance sheet balances. Attempting to prepare the balance sheet first would leave equity incomplete and could mask errors in expense or revenue projections.

Question 2: BASIC CALCULATION

Apex Corp. budgets sales of 8,000 units at $40 per unit. Budgeted COGS is $192,000, S&A expenses are $55,000, and interest expense is $3,000. The income tax rate is 30%. Calculate budgeted gross profit, income before tax, income tax expense, and net income.

Show answer

Sales Revenue = 8,000 × $40 = $320,000. Gross Profit = $320,000 − $192,000 = $128,000. Income Before Tax = $128,000 − $55,000 − $3,000 = $70,000. Income Tax Expense = $70,000 × 30% = $21,000. Net Income = $70,000 − $21,000 = $49,000. Each line is derived directly from the upstream budget schedules, and the multi-step format ensures transparency in how operating performance translates to the bottom line.

Question 3: INTERMEDIATE

Using Apex Corp.'s data from Problem 2, suppose beginning retained earnings are $120,000, common stock is $200,000, and no dividends are planned. The cash budget shows an ending cash balance of $18,000. Ending accounts receivable is $48,000, ending inventory (finished goods and raw materials) totals $30,000, and PP&E net is $350,000. Accounts payable is $25,000 and a loan payable is $50,000. Prepare the budgeted balance sheet. Does it balance? If not, identify the missing item and calculate its amount.

Show answer

Total Assets = Cash $18,000 + A/R $48,000 + Inventory $30,000 + PP&E $350,000 = $446,000. Ending RE = $120,000 + $49,000 − $0 = $169,000. Total Equity = $200,000 + $169,000 = $369,000. Total Liabilities (given) = A/P $25,000 + Loan $50,000 = $75,000. Total L + E = $75,000 + $369,000 = $444,000. Since Total Assets ($446,000) ≠ Total L + E ($444,000), there is a $2,000 discrepancy. The missing item is a $2,000 accrued liability (for example, accrued interest payable or another accrued expense) that was expensed on the income statement but not yet paid in cash, leaving it as an outstanding liability at period-end. Adding a $2,000 accrued liability brings Total Liabilities to $77,000 and Total L + E = $77,000 + $369,000 = $446,000, which equals Total Assets.

Question 4: APPLIED

BrewBright Inc., a specialty coffee equipment company, is preparing its Q2 master budget. The marketing VP insists on raising the sales forecast from 5,000 to 6,500 units, increasing revenue from $500,000 to $650,000. Explain how this change would ripple through the operating budgets and ultimately affect both the budgeted income statement and the budgeted balance sheet. Discuss at least four specific line items that would change and the direction of each change.

Show answer

A 30% increase in budgeted unit sales would first increase sales revenue on the income statement. Second, the production budget would need to schedule more units, raising budgeted COGS (direct materials, direct labor, and variable manufacturing overhead all increase). Third, variable selling expenses (e.g., sales commissions) in the S&A budget would rise proportionally, increasing total operating expenses. Fourth, higher revenue and costs alter income before tax and therefore income tax expense. On the balance sheet, ending finished goods inventory may change depending on the desired ending inventory policy, accounts receivable will likely increase if the same percentage of sales remains uncollected, accounts payable for materials purchases will rise, and the ending cash balance may decrease if cash disbursements outpace collections, potentially requiring additional borrowing under the cash budget. The net effect on net income depends on whether the incremental margin on the additional 1,500 units exceeds the incremental costs, but gross profit should increase if the contribution margin per unit is positive.

Question 5: CRITICAL THINKING

A CFO reviews the draft budgeted balance sheet and notices that projected total debt-to-equity ratio will exceed the 1.5× covenant threshold in the company's loan agreement. The budgeted income statement shows acceptable profitability. Propose and evaluate two different strategies the management team could pursue to bring the budgeted balance sheet into compliance with the covenant without reducing budgeted sales volume. For each strategy, explain how it would affect specific line items on both budgeted statements.

Show answer

Strategy 1: Issue additional equity (e.g., sell common stock). This would increase the equity denominator in the debt-to-equity ratio, bringing it below 1.5×. On the balance sheet, Common Stock and Cash both increase. The income statement is largely unaffected unless the new equity replaces debt, in which case interest expense would decrease, raising net income and further boosting retained earnings. Strategy 2: Accelerate cash collections and use the proceeds to repay debt. Management could tighten credit terms (e.g., shifting from net-60 to net-30), which would reduce ending accounts receivable on the balance sheet while enabling a prepayment of the loan payable. Total assets and total liabilities both decrease, improving the ratio. On the income statement, interest expense would decline due to the lower outstanding loan balance, increasing net income. A trade-off of Strategy 2 is that tighter credit terms may alienate customers and could ultimately reduce sales volume, which the problem restricts. Each strategy illustrates that budgeted financial statements are not merely passive reports—they are active decision-support tools that allow managers to model the financial consequences of strategic choices before committing resources.

SUMMARY

Lesson Summary

Summary

The budgeted income statement consolidates sales revenue from the sales budget, cost of goods sold from the schedule of cost of goods manufactured (which aggregates direct materials, direct labor, and manufacturing overhead budgets and adjusts for inventory changes), and selling and administrative expenses from the S&A budget to project net income for the budget period. Interest expense, derived from the cash budget's financing section, and income tax expense complete the multi-step format.

The budgeted balance sheet projects ending balances for assets (cash from the cash budget, receivables, inventories, and PP&E from the capital budget), liabilities (payables and loans), and equity (common stock and retained earnings). The fundamental accounting equation must hold—if the balance sheet does not balance, an error exists upstream. Together, these two statements serve as the capstone of the master budget, translating operational plans into the financial language that managers, lenders, and investors rely on for decision-making.