Financial Projections: Key Points

Financial Projections: Key Points

DOWNLOAD PDF 

Financial projections are crucial for any business, whether it's a startup seeking funding or an established company planning for the future. Here's a breakdown of the key points to consider:

 

I. Purpose and Scope: Defining the Foundation

This section is absolutely critical. It sets the stage for everything that follows. If you get this wrong, your entire financial model will be flawed. Think of it as the blueprint for your house.

1. Defining the Purpose (Why are you creating these projections?)

• Funding: Seeking investment from venture capitalists, angel investors, or banks? This requires rigorous accuracy and a compelling growth story.
• Internal Planning/Management: Making strategic decisions about resource allocation, budgeting, and forecasting future performance. Here, the focus is on internal understanding and driving improvement.
• Operational Planning: Managing day-to-day operations, including inventory, staffing, and cash flow.
• Valuation/Mergers & Acquisitions (M&A): Determining the value of a business for sale, acquisition, or internal valuation purposes. This requires specific methodologies and considerations.
• Business Plan: Developing a comprehensive plan that outlines your business strategy, including financial projections.
• Performance Measurement: Tracking performance against financial goals and identifying areas for improvement.
• Consider: Each purpose may require a slightly different level of detail and focus. For example, funding requires greater scrutiny and due diligence. Internal planning allows more flexibility.

2. Defining the Scope (What will be included and excluded?)

• Time Horizon:
• Short-Term (1-2 years): Focuses on immediate cash flow and operational planning. Often used for startups and short-term budgeting.
• Mid-Term (3-5 years): Typical for many businesses, especially startups seeking funding. Balances detail with the uncertainty of long-term forecasting.
• Long-Term (5+ years): Used for strategic planning, assessing long-term viability, and in some valuation scenarios. More susceptible to significant assumptions.
• Consider: The time horizon should be appropriate for the business stage, industry, and the purpose of the projections. Startups typically focus on a shorter horizon, while established businesses may need longer-term views.
• Geographic Scope: Will the projections cover a local market, a regional market, a national market, or an international market?
• Consider: Revenue projections need to align with the geographic scope.
• Business Units/Products/Services: Will the projections cover the entire business or specific departments, products, or services? It helps to break down revenues and expenses based on the specific products/services or business units.
• Consider: This allows for more granular analysis and strategic decision-making.
• Level of Detail:
• Annual: A high-level overview.
• Quarterly: More granular than annual, allowing for tracking of seasonal variations or early performance indicators.
• Monthly: Provides the most detail and allows for close monitoring of cash flow and performance. Often preferred for startups and businesses with volatile cash flows.
• Consider: The level of detail should align with the purpose and the business's needs.

3. Key Considerations for Purpose and Scope:

• Audience: Who will be reading/using these projections? Tailor the level of detail, clarity, and presentation to the audience. Investors have different needs than internal management.
• Assumptions are Key: Prepare a separate section for documenting all assumptions. These are the driving forces behind your numbers. The more detailed and justifiable your assumptions, the stronger your projections.
• Data Availability: Be realistic about the data you have available. Don't try to build a complex model if you lack the necessary historical data or market research.
• Flexibility: Build flexibility into your model. This means building in the capacity to run multiple scenarios (best-case, worst-case, most-likely) to account for unforeseen events.
• Iterative Process: Financial projections are not static. As your business evolves, so should your projections. Plan to review and update your projections regularly (e.g., monthly, quarterly, or annually).
• Start Simple: It's better to start with a simplified model that is accurate than a complex model that is riddled with errors. You can add complexity later as your business grows and your understanding deepens.
• Check for Alignment: Ensure that the scope and purpose are clearly aligned. For example, if your purpose is to secure funding, your scope must include a detailed revenue forecast, operating expenses, and key metrics that show the business's potential.

 

II. Key Financial Statements: The Pillars of Financial Projection

This section outlines the core financial statements that form the backbone of any robust financial projection. These statements tell the story of your business's financial health and future performance.

1. Income Statement (Profit & Loss - P&L)

• Purpose: To show the company's financial performance over a specific period (e.g., a month, quarter, or year). It summarizes revenues, expenses, and the resulting profit or loss.
• Key Line Items:
• Revenue (Sales):
• Definition: Money generated from the sale of goods or services.
• Projection Drivers: Sales volume, price per unit/service, sales mix (if applicable), customer acquisition rate, customer retention rate, contract terms (if applicable), and changes in pricing strategy.
• Detailed Breakdown: Clearly show how you arrive at your revenue figure (e.g., Units Sold * Price Per Unit, or number of subscriptions * subscription price).
• Important Considerations:
• Revenue Recognition: Understand how you recognize revenue.
• Seasonality: Account for seasonal variations in sales.
• Growth Rates: Justify projected growth rates based on market research, sales pipeline, and sales and marketing plan.
• Cost of Goods Sold (COGS) / Cost of Services:
• Definition: Direct costs associated with producing goods or delivering services.
• Projection Drivers: Direct materials, direct labor, manufacturing overhead (if applicable), cost of services delivered.
• Metrics:
• Gross Margin: (Revenue - COGS) / Revenue. This indicates profitability of core operations.
• Important Considerations:
• Variable vs. Fixed Costs: Separate variable costs (those that fluctuate with sales volume) from fixed costs.
• Supply Chain: Consider potential disruptions in the supply chain.
• Efficiency improvements: Plan for potential efficiency gains that will impact cost.
• Gross Profit:
• Definition: Revenue - COGS. Represents the profit earned from core business activities before operating expenses.
• Operating Expenses (OPEX):
• Definition: Expenses incurred in the day-to-day operations of the business.
• Key Categories: Sales & Marketing, General & Administrative (G&A), Research & Development (R&D).
• Projection Drivers: Salaries, rent, utilities, marketing spend, insurance, professional fees.
• Detailed Breakdown: Specify the components of each operating expense category (e.g., Marketing: online advertising, content creation, event costs).
• Metrics:
• Operating Profit Margin: Operating Profit / Revenue
• Important Considerations:
• Fixed vs. Variable: Consider whether costs are fixed or variable in relation to revenue and/or production volume.
• Scalability: Assess how expenses will scale as revenue grows.
• Expense Controls: Develop a clear plan for managing expenses.
• Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA):
• Definition: A measure of core profitability. Often used to compare businesses.
• Calculation: Gross Profit - Operating Expenses + Other Income (if any)
• Important Considerations: EBITDA does not account for capital expenditures (such as equipment).
• Earnings Before Interest and Taxes (EBIT):
• Definition: Operating profit.
• Calculation: EBITDA - Depreciation and Amortization
• Interest Expense:
• Definition: The cost of borrowing money.
• Projection Drivers: Outstanding debt, interest rates.
• Taxes:
• Definition: Income taxes paid.
• Projection Drivers: Tax rate, taxable income.
• Net Income (Profit):
• Definition: The "bottom line" – the profit or loss after all expenses and taxes.
• Calculation: Revenue - COGS - Operating Expenses - Interest Expense - Taxes.
• Important Considerations: Net Income provides the clearest picture of a company's financial performance.

2. Balance Sheet

• Purpose: To provide a snapshot of a company's assets, liabilities, and equity at a specific point in time. It shows what the company owns, what it owes, and the owners' stake.
• The Accounting Equation: Assets = Liabilities + Equity (This equation always holds true.)
• Key Line Items:
• Assets:
• Definition: Resources controlled by the company that are expected to provide future economic benefits.
• Key Categories:
• Current Assets: Assets that can be converted into cash within one year (e.g., cash, accounts receivable, inventory, prepaid expenses).
• Cash: Beginning cash balance, cash receipts (from sales, investments, financing), cash disbursements (operating expenses, capital expenditures, etc.)
• Accounts Receivable (AR): Money owed to the company by customers for goods or services sold on credit.
• Projection Drivers: Sales, credit terms, collection rate.
• Inventory: Goods held for sale. (relevant to product companies)
• Projection Drivers: COGS, lead times, storage capacity.
• Non-Current Assets: Assets not expected to be converted to cash within one year (e.g., property, plant, and equipment (PP&E), intangible assets (e.g., patents, trademarks)).
• PP&E: Land, buildings, equipment.
• Projection Drivers: Capital expenditure plan, depreciation method.
• Liabilities:
• Definition: Obligations of the company to other entities (what the company owes).
• Key Categories:
• Current Liabilities: Liabilities due within one year (e.g., accounts payable, accrued expenses, short-term debt).
• Accounts Payable (AP): Money owed to suppliers.
• Projection Drivers: COGS, payment terms.
• Accrued Expenses: Expenses incurred but not yet paid (e.g., salaries payable, interest payable).
• Non-Current Liabilities: Liabilities due in more than one year (e.g., long-term debt).
• Equity:
• Definition: The owners' stake in the company (the residual interest in the assets after deducting liabilities).
• Key Categories:
• Common Stock: The original investment by the owners.
• Retained Earnings: Accumulated profits that have not been distributed to shareholders (Net Income - Dividends).
• Additional Paid-in Capital: Money received from shareholders exceeding the par value of the shares.
• Important Considerations: The balance sheet must always balance (Assets = Liabilities + Equity).

3. Cash Flow Statement

• Purpose: To track the movement of cash in and out of the company over a specific period. It answers the question: "Where did the cash come from, and where did it go?"
• Key Categories:
• Cash Flow from Operations (CFO):
• Definition: Cash generated from the company's core business activities.
• Calculation: Net Income + (Depreciation & Amortization) - Changes in Working Capital (AR, Inventory, AP)
• Projection Drivers: Revenue, COGS, operating expenses, changes in working capital.
• Important Considerations:
• Indirect Method: Most companies use the indirect method to calculate CFO, starting with Net Income and then making adjustments for non-cash items (like depreciation) and changes in working capital.
• Cash Flow from Investing (CFI):
• Definition: Cash flows related to the purchase and sale of long-term assets (e.g., property, plant, and equipment (PP&E), investments).
• Projection Drivers: Capital expenditure plan (CapEx)
• Important Considerations:
• CapEx: Significant capital expenditures can have a major impact on cash flow.
• Cash Flow from Financing (CFF):
• Definition: Cash flows related to debt, equity, and dividends.
• Projection Drivers: New debt, repayment of debt, proceeds from stock issuance, stock repurchases, dividend payments.
• Important Considerations:
• Debt Financing: Borrowing money increases cash, while debt repayment decreases it.
• Equity Financing: Issuing stock increases cash.
• Dividends: Paying dividends decreases cash.
• Ending Cash Balance:
• Definition: The cash balance at the end of the period.
• Calculation: Beginning Cash Balance + CFO + CFI + CFF
• Important Considerations: This is a critical number. Ensure sufficient cash to cover operating expenses.
• Cash Burn Rate: The rate at which a company is spending its cash, especially during early stages.

4. Interrelationships Between Statements:

• Income Statement & Balance Sheet: Net Income from the Income Statement flows into Retained Earnings on the Balance Sheet. Depreciation expense on the Income Statement reduces the book value of PP&E on the Balance Sheet.
• Income Statement & Cash Flow Statement: Depreciation is added back to Net Income in the Cash Flow Statement because it is a non-cash expense. The Income Statement is the starting point for Cash Flow from Operations (CFO).
• Balance Sheet & Cash Flow Statement: Changes in working capital accounts (accounts receivable, inventory, and accounts payable) on the Balance Sheet affect the Cash Flow Statement (CFO). Cash balance on the Balance Sheet is the ending number on the Cash Flow Statement.

 

 

 

III. Building the Projections: A Step-by-Step Guide

This section outlines the process of constructing your financial projections, focusing on the key steps and best practices.

1. Start with Revenue: The Engine of Your Model

• Why Revenue First? Revenue drives almost everything else in the model. It's the foundation.
• Gather Data:
• Historical Revenue (If Available): Analyze past performance to identify trends and patterns.
• Market Research: Understand market size, growth rates, and competitive landscape.
• Sales Pipeline (If Applicable): Track potential sales opportunities and their probability of closing.
• Customer Acquisition Cost (CAC) and Customer Lifetime Value (CLTV): Crucial metrics.
• Project Revenue:
• Identify Revenue Streams: What are your different sources of revenue? (e.g., product sales, subscriptions, services).
• Sales Volume/Units: Project the number of units sold, customers acquired, or transactions.
• Drivers: Market growth, market share, sales and marketing efforts, customer acquisition cost.
• Pricing: Project the price per unit, service, or subscription.
• Drivers: Market pricing, competitive landscape, discounts, price increases.
• Revenue = Sales Volume * Price for each revenue stream.
• Project Month-by-Month (Recommended): Start small and get more granular to understand the trajectory of the business.
• Assumptions:
• Clearly Document All Assumptions: Market growth rates, market share targets, average selling prices, customer acquisition costs, and churn rates. Justify these assumptions with data or market research.
• Sensitivity Analysis: Prepare to analyze the impact of changes to key assumptions.

2. Project Cost of Goods Sold (COGS) / Cost of Services:

• Focus: The direct costs associated with producing or delivering the product or service.
• Gather Data:
• Historical COGS Data: Analyze past COGS as a percentage of revenue.
• Cost Structure: Understand the components of COGS (e.g., raw materials, direct labor, manufacturing overhead, cost of services).
• Project COGS:
• Variable Costs: Costs that vary with sales volume (e.g., raw materials). Project these as a percentage of revenue or based on the projected sales volume.
• Fixed Costs (if any): Costs that do not vary with sales volume (e.g., a warehouse lease).
• COGS = Total Variable Costs + Total Fixed Costs
• Gross Margin: Important indicator of profitability (Gross Profit / Revenue). Track and project this metric.
• Assumptions:
• Raw Material Costs: Project based on supplier agreements, commodity prices, and production volumes.
• Direct Labor Costs: Project based on wage rates and production volumes.
• Cost of Services: Project based on service delivery costs, labor costs, and overhead.

3. Project Operating Expenses (OPEX):

• Focus: Expenses incurred in running the business.
• Key Categories:
• Sales & Marketing: Sales salaries, advertising, marketing campaigns, commissions.
• General & Administrative (G&A): Salaries, rent, utilities, insurance, professional fees, office supplies.
• Research & Development (R&D): Salaries, materials, software, and other costs related to product development.
• Gather Data:
• Historical OPEX Data: Review past spending patterns.
• Budgeting: Use a budget to guide expense projections.
• Project OPEX:
• Fixed vs. Variable: Identify and classify each expense as either fixed or variable.
• Fixed Costs: Salaries, rent, etc. Project based on contractual agreements, headcount plans, and lease terms.
• Variable Costs: Marketing expenses, commissions. Project these as a percentage of revenue, sales volume, or other relevant metrics.
• Headcount Planning: Project salaries based on staffing plans.
• Marketing Plan: Project marketing expenses based on your sales and marketing plan.
• Scalability: Consider how expenses will scale as the business grows.
• Assumptions:
• Salary Increases: Project salary increases based on company policy.
• Marketing Spend: Project marketing spend based on your marketing plan and expected results.
• Rent Increases: Factor in any expected rent increases.

4. Build the Income Statement:

• Calculate:
• Gross Profit = Revenue - COGS
• Operating Profit (EBIT) = Gross Profit - Operating Expenses
• EBITDA = Operating Profit + Depreciation & Amortization
• Net Income = Operating Profit - Interest Expense - Taxes
• Format: Present the income statement in a clear and organized format, with clearly labeled line items.
• Review: Review your income statement to ensure that it makes sense and that the results align with your expectations.

5. Project the Balance Sheet:

• This Section Requires Integration: Projecting the balance sheet requires projecting all the key line items and the interrelationship between the income statement and the balance sheet.
• Project Assets:
• Cash: Project cash based on the cash flow statement (see below).
• Accounts Receivable: Project AR based on sales, credit terms, and collection rates. (e.g., AR = Revenue * (Credit Sales Percentage) * (Days Sales Outstanding / 365)).
• Inventory: (For product-based businesses): Based on COGS, inventory turnover, and lead times.
• Property, Plant, and Equipment (PP&E): Based on planned capital expenditures, depreciation, and asset sales.
• Project Liabilities:
• Accounts Payable: Project AP based on COGS, payment terms, and purchasing patterns.
• Accrued Expenses: Project based on expected accrued salaries, rent, and other expenses.
• Debt: Project based on borrowing and repayment plans.
• Project Equity:
• Retained Earnings: Flows from the Income Statement (Net Income - Dividends)
• Common Stock: Based on any stock issuances.
• Additional Paid-in Capital: Based on amount received above par value of stock.
• Important: The balance sheet must balance (Assets = Liabilities + Equity) at the end of each period.

6. Build the Cash Flow Statement:

• Direct vs. Indirect Method: The indirect method (used most often) starts with Net Income and makes adjustments for non-cash items and changes in working capital.
• Calculate Cash Flow from Operations (CFO):
• Start with Net Income
• Add back Depreciation & Amortization (Non-cash expense)
• Adjust for changes in working capital accounts (AR, Inventory, AP):
• Increase in AR = decrease cash
• Decrease in AR = increase cash
• Increase in Inventory = decrease cash
• Decrease in Inventory = increase cash
• Increase in AP = increase cash
• Decrease in AP = decrease cash
• Calculate Cash Flow from Investing (CFI):
• Capital Expenditures (CapEx): Purchase of PP&E. This is a cash outflow.
• Sale of Assets: Sale of PP&E. This is a cash inflow.
• Calculate Cash Flow from Financing (CFF):
• Proceeds from Debt: Borrowing money (cash inflow).
• Repayment of Debt: Paying back loans (cash outflow).
• Proceeds from Equity: Issuing stock (cash inflow).
• Dividends Paid: (cash outflow).
• Share Repurchases (cash outflow)
• Ending Cash Balance = Beginning Cash Balance + CFO + CFI + CFF

7. Formatting & Presentation:

• Use a Spreadsheet: Use Excel, Google Sheets, or dedicated financial modeling software.
• Clear and Organized: Use a clear and organized structure. Color-coding and logical formatting help.
• Consistency: Use consistent units of measurement (e.g., dollars, thousands of dollars).
• Formula Integrity: Ensure that formulas are correct and that all values are linked correctly.
• Documentation: Include clear documentation of your assumptions and calculations.

8. Review, Refine & Iterate:

• Review Regularly: Review your projections at least monthly, or quarterly.
• Sensitivity Analysis: Test the impact of changes to key assumptions.
• Scenario Planning: Develop best-case, worst-case, and most-likely scenarios.
• Update as Needed: Update your projections as your business evolves.

9. Tools for Building the Projections

• Spreadsheets: (e.g., Excel, Google Sheets)
• Financial Modeling Software: (e.g., Finbox, LivePlan, ProjectionHub)
• Accounting Software: (e.g., QuickBooks, Xero)

Key Takeaways for this section:

• Start with Revenue and follow a logical process.
• Document all Assumptions thoroughly.
• Use clear and organized formatting.
• Ensure the statements are integrated and consistent.
• Review, refine, and iterate frequently.
• Don't be afraid to seek help from a financial professional.

 

IV. Important Considerations & Best Practices: Achieving Financial Projection Excellence

This section covers the critical aspects of building and maintaining high-quality financial projections that provide valuable insights for your business.

1. Accuracy and Realism:

• Avoid Overoptimism: Be realistic in your revenue projections, especially in the early stages. It's better to be conservative and exceed expectations than to fall short.
• Base Projections on Data: Support your projections with historical data, market research, and reasonable assumptions. Avoid making numbers "out of thin air."
• Understand Industry Benchmarks: Research industry averages for key metrics (e.g., gross margins, operating expenses) to ensure your projections are reasonable.
• Revisit and Refine: Financial projections are dynamic, not static. Regularly review and revise your projections based on actual performance and changes in the business environment.

2. Transparency and Documentation:

• Document All Assumptions: Clearly state all assumptions used in your projections. This is crucial for understanding the drivers behind your numbers and for explaining variances.
• Show Your Work: Provide clear explanations of how you calculated each line item in the projections. This makes your model easier to understand, audit, and update.
• Create a "Summary of Assumptions" Page: This page should concisely summarize all key assumptions for easy reference.
• Use Clear and Consistent Formatting: Use a consistent format for your financial statements, assumptions, and calculations. This improves readability and reduces the risk of errors.

3. Consistency:

• Consistent Accounting Methods: Apply accounting principles consistently throughout the projections (e.g., revenue recognition, depreciation methods).
• Consistent Units of Measurement: Use a consistent currency and unit of measure throughout your model (e.g., thousands of dollars, millions of euros).
• Consistent Time Periods: Use consistent time periods (e.g., monthly, quarterly, annually) for your projections.

4. Conservative Estimates:

• Err on the Side of Caution: When estimating expenses or other uncertain variables, consider using conservative (higher) estimates. This helps to ensure that your projections are realistic and that you are prepared for potential setbacks.
• Prepare for Worst-Case Scenarios: Develop scenarios that reflect potentially unfavorable outcomes (e.g., lower sales, higher costs) to assess the financial impact and develop contingency plans.

5. Seasonality:

• Identify Seasonal Patterns: If your business is subject to seasonal variations (e.g., retail, tourism), incorporate these patterns into your projections.
• Adjust for Peak and Off-Peak Periods: Use different revenue and expense assumptions for peak and off-peak periods.

6. Technology and Tools:

• Spreadsheet Software: Use spreadsheet software (e.g., Excel, Google Sheets) or financial modeling software.
• Templates: Use templates or build your own from scratch, depending on complexity.
• Accounting Software Integration: If possible, integrate your financial projections with your accounting software to automate data entry and updates.

7. Professional Help (When to Seek It):

• Complex Business Models: If your business model is complex, or if you need to create projections for a significant investment or loan application, consider seeking help from a financial advisor or accountant.
• Limited Financial Expertise: If you lack financial expertise, it is advisable to seek professional help.
• Funding Applications: If you are seeking funding from investors or lenders, they may require professional financial projections.

8. Key Performance Indicators (KPIs):

• Identify and Track Key Metrics: Define the key metrics (KPIs) that are most important to your business (e.g., customer acquisition cost, customer lifetime value, gross margin, burn rate).
• Monitor Performance Against KPIs: Regularly monitor your performance against these KPIs and use them to evaluate the accuracy of your projections and make adjustments as needed.
• Examples of KPIs by Function:
• Sales: Sales volume, average order value, conversion rates, customer acquisition cost (CAC), customer lifetime value (CLTV), churn rate.
• Marketing: Website traffic, lead generation, cost per lead, conversion rates, customer acquisition cost (CAC).
• Operations: COGS as a percentage of sales, gross margin, inventory turnover, on-time delivery rate, production efficiency.
• Finance: Revenue growth, profit margins, cash flow, debt-to-equity ratio, working capital management.

9. Focus on the Message:

• Tell a Compelling Story: Your financial projections should tell a clear and compelling story about your business's potential and future prospects.
• Highlight Key Strengths: Emphasize your business's strengths and competitive advantages in your projections.
• Address Risks: Acknowledge and address potential risks and challenges.
• Prepare a Summary: Summarize your key findings and conclusions in a clear and concise manner.

10. Adaptability & Revision:

• Plan for Change: The business environment is constantly changing. Prepare to revise your projections regularly.
• Update Regularly: Create a schedule for reviewing and updating your financial projections (e.g., monthly, quarterly, annually).
• Learn from Results: Compare your actual results to your projected figures and use this information to refine your assumptions and improve the accuracy of your future projections.

By following these key points, you can create well-structured and insightful financial projections that help you make informed business decisions, secure funding, and track your progress toward your goals.