A balance sheet projection (also called a pro forma balance sheet) shows what a company’s assets, liabilities, and equity are expected to look like at a future date, usually the end of a quarter or year. You build it by starting with the current balance sheet, then adding the effects of projected income, planned spending, loan repayments, and new financing. The result helps owners, investors, and lenders see whether the business will have enough cash, debt, and equity to support its plans.
Formula
The core formula for a balance sheet projection is the accounting identity:
Assets = Liabilities + Equity
Each line item is projected separately, then the equation must balance. For a loan that affects the balance sheet, the monthly payment is calculated with the standard amortization formula:
PMT = P × (r / (1 − (1 + r)^(−n)))
- P = principal loan amount (in dollars)
- r = monthly interest rate = annual APR ÷ 12 (as a decimal, e.g., 8% APR → 0.08/12 = 0.006667)
- n = total number of monthly payments (years × 12)
- PMT = the level monthly payment (in dollars, rounded to the cent)
In the calculator above, the monthly payment is the first output. Total interest is simply the total paid minus the principal: PMT × n − P.
Worked Example
Using the default inputs: loan amount P = $20,000, APR = 8%, term = 5 years (n = 60 months).
- Monthly rate r = 8 / 1200 = 0.0066667
- Compute (1 + r)^(−n) = (1.0066667)^(−60) ≈ 0.67121
- Payment = 20000 × (0.0066667 / (1 − 0.67121)) = 20000 × (0.0066667 / 0.32879) ≈ 20000 × 0.020276 = 405.52
- Total paid = 405.52 × 60 = 24,331.20
- Total interest = 24,331.20 − 20,000 = 4,331.20
The calculator’s first output shows $405.52 for the monthly payment and $4,331.20 for total interest. These match the manual calculation.
Assumptions
- Fixed interest rate for the entire loan term (no rate changes).
- Payments are made monthly at the end of each period.
- Interest compounds monthly at APR ÷ 12.
- The payment is rounded to the cent, and totals use that rounded payment.
- This calculator does not include fees, taxes, insurance, or early repayment penalties. Those must be added separately to your projection.
How to Build a Balance Sheet Projection
A projection is only as good as its assumptions. The usual process is:
- Start with the most recent actual balance sheet – use the numbers from your last month-end or year-end statement.
- Project income statement items – forecast sales, cost of goods sold, operating expenses, interest expense, and taxes for the period.
- Project cash flows – estimate cash collections from customers, cash paid to suppliers and employees, capital expenditures, and loan proceeds or repayments.
- Update asset accounts – add expected cash, accounts receivable (based on sales and collection days), inventory (based on cost of goods sold and turnover), and fixed assets (add planned purchases, subtract depreciation).
- Update liability accounts – accounts payable (based on purchases and payment terms), accrued expenses, and current portions of long-term debt.
- Update equity – add net income for the period, subtract dividends or owner draws, and add any new capital contributions.
- Check the balance – total assets must equal total liabilities plus equity. If they don’t, recheck your cash or retained earnings calculation.
For example, if you project $50,000 in assets and $30,000 in liabilities, equity must be $20,000. If your projected net income is $5,000 and you start with $15,000 equity, you’ll need to adjust cash or retained earnings to make the equation hold.
Why Project a Balance Sheet?
Unlike an income statement, which shows profitability over time, the balance sheet projection reveals the company’s financial position at a specific future date. It answers questions like:
- Will we have enough cash to pay suppliers next quarter?
- How much debt will remain after the loan payments?
- Will our equity ratio stay above the level a lender requires?
- Can we afford to buy new equipment without running out of working capital?
Lenders and investors often ask for a projected balance sheet alongside a profit and loss forecast. It shows them that you have thought through the full impact of your plans, not just the revenue side.
Common Mistakes and How to Avoid Them
- Forgetting to balance – the most common error. Always verify that assets = liabilities + equity. A small rounding difference is acceptable, but a large gap means a missing item.
- Mixing up timing – a balance sheet is a snapshot at a point in time, not a flow. Make sure your projections are as of the same date for all accounts.
- Using the wrong depreciation – depreciation reduces fixed assets and retained earnings, but it does not affect cash. Include it correctly in both places.
- Ignoring loan amortization – the portion of a loan payment that goes to principal reduces the liability, while the interest portion goes to the income statement. Many first-timers treat the whole payment as interest.
- Overly optimistic assumptions – a projection is a planning tool, not a promise. Use conservative sales growth and realistic collection periods.
How to Use the Loan Payment Calculator in Your Projection
When you take out a new loan, the balance sheet projection must reflect both the initial cash inflow (the loan proceeds) and the ongoing repayment. Here’s how to connect the calculator to your projection:
- Enter the loan amount, APR, and term to get the monthly payment and total interest.
- In the month the loan is received, add the loan principal to cash and add the same amount to long-term debt (or current debt if due within a year).
- Each month, reduce cash by the monthly payment amount.
- Reduce the debt liability by the principal portion of the payment (which you can calculate from an amortization schedule). The interest portion is an expense on your income statement, which reduces net income and therefore retained earnings.
- At the end of the period, the balance sheet will show the remaining loan balance under liabilities and the net cash effect under assets.
For example, with the default $20,000 loan at 8% for 5 years, the first month’s payment of $405.52 includes about $133.33 in interest and $272.19 in principal. After 12 months, the remaining balance is roughly $16,500. Your projected balance sheet at that date should show a liability of about $16,500 for that loan, not the original $20,000.
Frequently Asked Questions
How far into the future should I project? Most businesses project one year ahead, broken down by month, and then a summary for the next 2–5 years. The further out you go, the less reliable the numbers become, so keep the detail in the first year.
What if my projected balance sheet doesn’t balance? Start by checking retained earnings – it should equal beginning retained earnings plus net income minus dividends. Then check cash: a common error is forgetting to include the cash effect of loan principal payments or capital expenditures.
Do I need a balance sheet projection if I already have a cash flow forecast? Yes. A cash flow forecast shows cash in and out, but it doesn’t show the resulting balances of inventory, receivables, debt, or equity. The balance sheet projection gives the full picture of financial health, which lenders and investors expect.
Can I use this calculator for a business loan with a balloon payment? No. The calculator assumes level payments over the full term. For a balloon loan, you would need a different amortization schedule that leaves a large final payment. The formula here will underestimate the regular payment if a balloon exists.
What is the difference between a projection and a budget? A budget is a plan for the coming period, often used for control and comparison to actual results. A projection is a forward-looking estimate of what will actually happen, often used for external purposes like loan applications. They can be the same, but a projection is usually more formal and tied to specific assumptions.
How often should I update my balance sheet projection? At least quarterly, or whenever a major change occurs – a new loan, a large purchase, or a significant shift in sales. Regular updates keep the projection useful for decision-making.
This calculator gives an estimate of loan payments and interest; the exact figures on your lender’s disclosure will be the final authority for your balance sheet projection.
Related
Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in yrs | Loan term | years | 5 | 0.0833 | 50 out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2 out int | Total interest | $ | pmt * yrs * 12 - p | 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
- Vanilla Credit Card Balance: What It Is & How to Check$70.00
- VI Credit Card Balance Check: How to See It$50.00
- Triple S Combo Card Balance: How to Check$75.00
- Transfer Credit Card Balance to Another Card? Guide
- Triple O Gift Card Balance: Check It Here
- Toys R Us Gift Card Balance: How to Check It$30.00