What is the difference between a projected balance sheet and a historical balance sheet?

A historical balance sheet shows a company's financial position at a specific point in the past, while a projected balance sheet forecasts the company's financial position at a future date.

What happens if my projections are inaccurate?

Inaccurate projections can damage your credibility with the bank. It's important to be realistic and transparent about your assumptions and to provide a range of potential outcomes.

Should I include a sensitivity analysis with my projected balance sheet?

Yes, including a sensitivity analysis demonstrates that you have considered different scenarios and understand the potential risks and opportunities facing your business.

Projected Balance Sheet Format for Bank Loan (Step-by-Step)

When looking for a bank loan, a projected balance sheet is a critical document. It demonstrates your understanding of future financial performance and your ability to repay the loan. This post provides a step-by-step guide to creating a professional and persuasive projected balance sheet.

Why is a Projected Balance Sheet Important?

Banks use projected balance sheets to assess your company's financial health and stability. It helps them figure out if you can manage your assets, liabilities, and equity useful. A well-prepared projection increases your chances of loan approval.

Step 1: Gather Your Data

Start by collecting relevant historical financial data, including past balance sheets, income statements, and cash flow statements. Also, gather information about industry trends, market conditions, and your company's careful plans. This data forms the foundation of your projections.

Step 2: Project Your Assets

Project your assets based on your sales forecasts and operational plans. Think about the following:

Cash: Project your cash balance based on expected cash inflows (sales, collections) and outflows (expenses, debt payments).
Accounts Receivable: Estimate accounts receivable based on your sales projections and collection patterns.
Inventory: Project inventory levels based on sales forecasts and production schedules.
Fixed Assets: Account for planned capital expenditures (e.g., equipment purchases) and depreciation.

Step 3: Project Your Liabilities

Project your liabilities based on your financing plans and operational needs. Look at the following:

Accounts Payable: Estimate accounts payable based on your purchase plans and payment terms.
Short-Term Debt: Include any short-term loans or lines of credit.
Long-Term Debt: Account for existing long-term debt and any new debt you plan to take on (including the bank loan).

Step 4: Project Your Equity

Project your equity based on your retained earnings and any planned equity contributions. Retained earnings are calculated by adding net income (from your projected income statement) to the previous year's retained earnings. If you are issuing new stock, include that as well.

Step 5: Format Your Balance Sheet

Use a standard balance sheet format:

Assets

Current Assets
Fixed Assets
Total Assets

Liabilities and Equity

Current Liabilities
Long-Term Liabilities
Equity
Total Liabilities and Equity

Make sure that Total Assets equals Total Liabilities and Equity.

Step 6: Review and Refine

Thoroughly review your projections for accuracy and reasonableness. Compare your projections to industry benchmarks and historical trends. Refine your assumptions and calculations as needed. Look at performing sensitivity analysis to understand how changes in key assumptions (e.g., sales growth, interest rates) could impact your projected balance sheet.

Step 7: Present Your Balance Sheet Professionally

Present your projected balance sheet in a clear and concise manner. Include supporting documentation and explanations for your key assumptions. Be prepared to answer questions from the bank about your projections.

Case Snippet

Here's a simplified case:

Projected Balance Sheet

As of December 31, 2024

Assets

Cash: $50,000
Accounts Receivable: $100,000
Inventory: $75,000
Fixed Assets: $200,000
Total Assets: $425,000

Liabilities and Equity

Accounts Payable: $40,000
Short-Term Debt: $25,000
Long-Term Debt: $100,000
Equity: $260,000
Total Liabilities and Equity: $425,000