This page explains how to project a balance sheet, a core skill in financial modeling, and provides a calculator to help you compute the key balancing figure (often retained earnings or cash) needed to make your projected balance sheet balance. You enter your projected assets, liabilities, and equity components, and the calculator tells you the plug figure required to balance the statement, along with the resulting total assets and liabilities plus equity.
Formula
The balance sheet is built on the accounting equation:
Assets = Liabilities + Equity
When you project each line item individually, the sum of liabilities and equity rarely equals total assets on the first pass. The balancing plug is the amount you add to (or subtract from) equity—usually retained earnings or cash—to force the equation to hold:
Plug = Total Assets − Total Liabilities − Total Equity (before plug)
Variables:
- Total Assets (p) – the sum of all projected asset accounts (cash, receivables, inventory, PP&E, etc.), in dollars.
- Total Liabilities (l) – the sum of all projected liability accounts (accounts payable, debt, accrued expenses, etc.), in dollars.
- Total Equity before plug (e) – the sum of common stock, additional paid-in capital, and beginning retained earnings (before any net income adjustment), in dollars.
- Plug – the amount needed to balance, in dollars. A positive plug means equity (or cash) must increase; a negative plug means it must decrease.
Worked Example
Using the default inputs: Total Assets = $500,000, Total Liabilities = $300,000, Total Equity before plug = $150,000.
Step 1: Calculate the plug:
Plug = $500,000 − $300,000 − $150,000 = $50,000
Step 2: Calculate total liabilities + equity after plug:
Total Liabilities + Equity = $300,000 + $150,000 + $50,000 = $500,000
Step 3: Check the balance:
Assets ($500,000) = Liabilities + Equity ($500,000) ✓
The calculator shows the same: plug of $50,000, total assets of $500,000, and total liabilities + equity of $500,000.
Assumptions
- The calculator assumes you have already projected all asset, liability, and equity line items separately.
- The plug is placed in equity (specifically retained earnings) or cash, depending on your model design. This calculator does not automatically allocate the plug; it only tells you the amount.
- It assumes a static point-in-time projection (a single period), not a multi-year dynamic model.
- It does not include any assumptions about interest rates, tax rates, or working capital drivers—those are inputs to your asset and liability projections.
Why a Balance Sheet Projection Matters
Projecting the balance sheet is the final step in a three-statement financial model. After forecasting the income statement and cash flow statement, the balance sheet ties everything together. It shows the company’s expected financial position at a future date, which lenders, investors, and management use to assess liquidity, solvency, and capital structure.
A well-built projection helps answer questions like:
- Will the company need external financing to support growth?
- How much debt will be outstanding at year-end?
- What will the company’s net working capital be?
Without a proper balance sheet projection, your model is incomplete and may hide errors in the income statement or cash flow statement.
How to Build a Balance Sheet Projection
Building a projection from scratch involves several steps. The typical process is:
- Project the income statement – forecast revenue, expenses, and net income for each period.
- Project cash flow – determine operating cash flow, investing cash flows (capex), and financing cash flows (debt issuance/repayment, dividends).
- Project assets – estimate cash based on cash flow, accounts receivable based on revenue and DSO, inventory based on COGS and turnover, and PP&E based on capex and depreciation.
- Project liabilities – estimate accounts payable based on purchases and days payable, accrued expenses, and debt based on scheduled repayments or new borrowings.
- Project equity – start with beginning equity, add net income, subtract dividends, and adjust for any stock issuances or buybacks.
- Check the balance – sum assets and sum liabilities + equity. The difference is your plug. In practice, you adjust cash or retained earnings to make it balance.
This calculator handles the final check (step 6) once you have totals for steps 3–5.
Common Mistakes in Balance Sheet Projections
Several errors frequently appear in balance sheet projections, even among experienced analysts:
- Plugging without understanding – blindly forcing a balance without investigating why it doesn’t balance can hide errors in your income statement or cash flow assumptions.
- Mixing timing of items – e.g., including a full year of depreciation in the first month, or not aligning the balance sheet date with the income statement period.
- Forgetting to update retained earnings – net income must flow into equity; otherwise, the balance sheet will never balance.
- Using inconsistent units – mixing thousands with millions, or dollars with percentages, leads to large discrepancies.
- Ignoring rounding – small rounding differences are normal, but a plug of $1,000,000 when your assets are $500,000 signals a real problem.
Always trace the plug back to its source. If the plug is large, check your net income, dividends, and any changes in working capital.
How to Use the Plug in Your Model
Once you know the plug amount, you need to decide where it goes. Two common approaches are:
- Cash as the plug – if you assume all other balance sheet items are fixed, the plug is the change in cash needed to balance. This is common in simple models where cash is not explicitly forecasted.
- Retained earnings as the plug – if cash is forecasted separately, the plug is the adjustment to retained earnings (often due to changes in net income or dividends). This is more realistic because retained earnings directly link to the income statement.
In a full three-statement model, you typically use a circular reference: interest income/expense depends on cash/debt, which depends on net income, which depends on interest. Most modelers enable iterative calculations to solve this. This calculator does not handle circular references; it gives you a snapshot for a single period.
Limitations of This Calculation
This calculator is a simplification. It assumes you have already projected all line items and only need to find the balancing figure. In reality, a balance sheet projection is dynamic and involves:
- Multiple periods (monthly, quarterly, annual) with carry-forward balances.
- Drivers like days sales outstanding (DSO), days payable outstanding (DPO), and inventory turnover.
- Debt schedules with interest calculations and amortization.
- Tax effects and deferred tax assets/liabilities.
For a robust projection, use a spreadsheet or financial modeling software that can handle these complexities. This calculator is best used as a quick check or for educational purposes.
Frequently Asked Questions
Why does my balance sheet not balance when I project it?
Usually because retained earnings did not include net income, or because cash flow statement items (like capex or debt repayments) are not reflected in the balance sheet. Check that net income flows to equity and that all asset/liability changes are consistent with the cash flow statement.
What is the best plug to use: cash or retained earnings?
It depends on your model. If you are forecasting cash flows explicitly, use retained earnings (or a separate equity account) as the plug. If you are not forecasting cash, use cash as the plug. In practice, most analysts prefer cash as the plug because it highlights the company’s need for funding.
How do I handle a negative plug?
A negative plug means your liabilities plus equity exceed your assets. This could indicate that your projected liabilities are too high, your assets are too low, or you have not added enough net income to equity. Review your assumptions and correct the underlying line items rather than just forcing a negative balance.
Can I project a balance sheet for a startup with no history?
Yes, but you must build assumptions from scratch. Start with projected sales, then estimate receivables, inventory, payables based on industry benchmarks. Equity will be the initial investment plus projected net income. The plug will help you see how much additional funding is needed.
What is the difference between a projected balance sheet and a pro forma balance sheet?
They are often used interchangeably. Both are forward-looking statements. Some practitioners use “pro forma” to refer to statements that assume a specific transaction (like a merger or loan), while “projected” refers to a forecast based on expected operations. The math is the same.
The result from this calculator is an estimate based on the figures you enter. Your lender or financial advisor will provide exact figures in their formal projections.
Related
Formula used
in p | Total projected assets | $ | 500000 | 0 | 10000000000 in l | Total projected liabilities | $ | 300000 | 0 | 10000000000 in e | Total projected equity (before plug) | $ | 150000 | 0 | 10000000000 out plug | Balancing plug (retained earnings or cash) | $ | p - l - e | 2 out ta | Total assets | $ | p | 2 out tl | Total liabilities + equity | $ | l + e + plug | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- QNB Car Loan Payment Calculator and Guide$405.53
- Car Loan Payment Calculator and Formula$405.53
- VA Down Payment Assistance Calculator and Guide$15,000.00
- Low Down Payment Home Loans: Costs and Trade-Offs$405.53
- Down Payment vs Advance Payment: Key Differences
- DIB Bank Car Loan Calculator and Payment Guide$405.53