Lernzettel: Financial Planning and Budgeting Masterclass

📋 Course Outline

1. Financial Statements
2. Budgeting Process
3. Sales Budget
4. Purchase and Expense Budget
5. VAT Budget
6. Cash Flow Budget
7. Working Capital Management
8. Forecasting Cash Position
9. Investment and Financing

📖 1. Financial Statements

🔑 Key Concepts & Definitions

• Income Statement (Profit and Loss Statement): A financial report that summarizes a company's revenues, costs, and expenses over a specific period, providing the net profit or loss (see "compte de résultat prévisionnel"). AUTHOR (date): "It forecasts the activity and evaluates the expected profit or loss."

• Forecasted Income Statement: An estimate of future financial performance based on projected revenues and expenses, used for planning and control (see "compte de résultat prévisionnel"). AUTHOR (date): "It allows for the anticipation of results and comparison with actual outcomes."

• Balance Sheet (Forecasted Balance Sheet): A snapshot of a company's projected assets, liabilities, and equity at a specific future date, reflecting the financial position (see "bilan prévisionnel"). AUTHOR (date): "It helps in assessing the future financial structure and stability."

• Assets and Liabilities Forecasting: The process of estimating future values of assets (e.g., inventories, receivables) and liabilities (e.g., debts, payables) based on budgets and operational plans (see "éléments de l'actif et du passif prévisionnel"). AUTHOR (date): "It provides a basis for strategic financial management."

• Cash Flow Budget: A projection of expected cash inflows and outflows over a period, essential for liquidity management (see "budget de trésorerie"). AUTHOR (date): "It ensures the company maintains sufficient liquidity to meet its obligations."

📝 Essential Points

• Financial statements, including the forecasted income statement and balance sheet, are crucial for planning, control, and decision-making (see "tableaux financiers du business plan"). They are built from detailed budgets such as sales, purchases, expenses, and investments.

• The forecasted income statement (or "compte de résultat prévisionnel") aggregates all projected revenues and expenses, including operational costs, financial charges, taxes, and exceptional items, to estimate future profitability.

• The forecasted balance sheet ("bilan prévisionnel") consolidates expected assets (e.g., inventories, receivables, fixed assets) and liabilities (e.g., debts, payables, provisions), providing a comprehensive view of the company's projected financial position.

• The accuracy of these projections depends on detailed budgets (sales, purchases, investments, etc.) and assumptions about future market conditions, operational efficiency, and financing strategies.

• Comparing forecasted and actual financial statements allows management to control performance, identify variances, and adjust strategies accordingly.

💡 Key Takeaway

Financial statements—both forecasted income statements and balance sheets—are vital tools that synthesize detailed budgets to project future financial health, enabling effective planning, control, and strategic decision-making.

📖 2. Budgeting Process

🔑 Key Concepts & Definitions

• Budget de ventes (Sales Budget): A forecast of expected sales revenue, typically based on previsions of sales volume and unit price, which serves as the foundation for other budgets such as cash flow and production (source content). Author (date): emphasizes its critical role in estimating future cash inflows.

• Budget des encaissements (Receipts Budget): An estimation of cash inflows from sales, considering payment delays and customer payment conditions (e.g., cash, 30 days, 60 days), crucial for cash flow management (source content). Author (date): highlights its importance in liquidity planning.

• Budget des décaissements (Disbursements Budget): An estimation of cash outflows, including purchases, expenses, and financial charges, based on payment modes and schedules (source content). Author (date): underscores its role in ensuring sufficient liquidity.

• Budget de TVA (VAT Budget): A forecast of VAT payable or recoverable, calculated as the difference between VAT collected on sales and VAT deductible on purchases, including adjustments for acquisitions and previous credits (source content). Author (date): details its function in tax compliance and cash planning.

• Budget de trésorerie (Cash Budget): A projection of cash position over a period, integrating inflows and outflows, beginning with the opening cash balance, to monitor liquidity and plan financing needs (source content). Author (date): stresses its importance in avoiding overdrafts and optimizing cash management.

• Ajustement de la trésorerie (Cash Flow Adjustment): Modifications made to initial cash forecasts to achieve a target cash position, such as zero balance, by adjusting financing or expenditure plans (source content). Author (date): notes its role in proactive liquidity management.

📝 Essential Points

• The budgeting process involves multiple interconnected budgets: sales, purchases, expenses, VAT, and cash flow, which collectively enable comprehensive financial planning (source content).

• The budget des ventes is essential for estimating future cash inflows and is based on sales volume forecasts and unit prices, adjusted for expected discounts and payment conditions (source content).

• The budget de TVA ensures compliance with tax obligations by calculating the net VAT payable or recoverable, considering collected and deductible amounts, and is payable in the month following the calculation (source content).

• The budget de trésorerie consolidates all inflows and outflows, including receivables, payables, and financing activities, to forecast liquidity and identify potential cash shortages or surpluses (source content).

• Adjustments to the cash budget aim to optimize liquidity, either by reducing financing costs or increasing financial income, often through strategies like delaying payments or accelerating collections (source content).

• The process emphasizes the importance of aligning operational plans with financial capacity, enabling proactive decision-making and financial control (source content).

💡 Key Takeaway

The budgeting process is a comprehensive, interconnected approach that forecasts future financial flows, enabling effective liquidity management and strategic decision-making to ensure business stability and growth.

📖 3. Sales Budget

🔑 Key Concepts & Definitions

• Sales Budget (see source): A financial forecast that estimates the expected sales revenue for a specific period, based on previsions of sales volume and unit price. It is essential for planning cash inflows and guiding production and marketing strategies.

• Previsions of Sales (Forecasted Sales) (see source): The projected quantity and value of sales, typically expressed in units and monetary terms, used to develop the sales budget. For example, estimating 3,700 bicycles to be sold at €520 HT each in January.

• Sales Volume Adjustment (see source): The process of modifying forecasted sales quantities based on expected market trends or strategic decisions, such as a 10% decrease in sales in February and subsequent adjustments in pricing to maintain volume.

• Pricing Strategy Impact (see source): Changes in unit selling prices, such as a 5% reduction from April, to stabilize or increase sales volume, directly influence the sales revenue forecast.

• Payment Conditions & Receivables Structure (see source): The terms of customer payments (e.g., 10% cash, 55% at 30 days, 35% at 60 days) affect the timing of cash inflows, which must be incorporated into the sales budget to accurately forecast cash receipts.

📝 Essential Points

• The sales budget is established on forecasted sales excluding VAT (HT), serving as the foundation for subsequent budgets such as cash collections and production planning.

• It considers sales volume adjustments over months, with a strategic price decrease to maintain volume levels in subsequent quarters, ensuring volume consistency despite price changes.

• Payment conditions significantly influence the timing of cash inflows; for example, 10% of sales are paid immediately, while the rest are collected over 30 or 60 days, affecting cash flow management.

• Accurate sales forecasting requires integrating expected sales quantities, unit prices, and customer payment behaviors to produce reliable cash flow projections.

• The example of Vélo City demonstrates how forecasted sales quantities and prices translate into total sales revenue and influence the encashment schedule.

💡 Key Takeaway

The sales budget is a crucial component that combines forecasted sales volumes, pricing strategies, and payment terms to project revenue and cash inflows, enabling effective financial planning and control.

📖 4. Purchase and Expense Budget

🔑 Key Concepts & Definitions

• Purchase Budget: A financial plan estimating the cost of raw materials, goods, or services needed for production or operations during a specific period, based on sales forecasts and inventory policies. It ensures procurement aligns with production needs and cash flow constraints.

• Expense Budget: A detailed projection of all operational costs (e.g., personnel, rent, utilities) expected within a period, derived from activity forecasts. It facilitates cost control and financial planning.

• Budget of VAT (Value Added Tax): A forecast of VAT payable or recoverable based on anticipated sales and purchases, calculated as VAT due = VAT collected on sales – VAT deductible on purchases (see section 4.4). It ensures compliance with tax obligations and cash flow management.

• Purchase and Expense Budget Relationship: The purchase budget directly influences the expense budget, especially regarding costs of goods sold and inventory management. Proper synchronization avoids overstocking or stockouts, impacting cash flow and profitability.

• Budgeting Approach (see Les tableaux financiers du business plan): Integrates sales forecasts, procurement plans, and operational costs to produce comprehensive financial projections, supporting strategic decision-making and financial control.

📝 Essential Points

• The purchase budget is primarily based on sales forecasts, considering expected sales volume and unit costs, to determine procurement needs (see example of Vélo City and SDN scooters). It includes costs for raw materials, supplies, and other direct inputs.

• The expense budget encompasses all operational costs, such as personnel, rent, external services, and amortizations, which are allocated according to activity levels and contractual obligations.

• The budget of VAT is calculated monthly by applying the applicable VAT rate (typically 20%) to sales and deducting VAT on purchases, with the difference representing VAT payable or recoverable (see section 4.4). This helps in cash flow planning and tax compliance.

• Accurate forecasting of purchase and expense budgets is crucial for maintaining liquidity, especially when aligning payments with receivables and managing credit terms with suppliers and clients.

• Variations between forecasted and actual expenses or purchases can significantly impact cash flow, necessitating regular monitoring and adjustments to the budget.

💡 Key Takeaway

A well-prepared purchase and expense budget ensures efficient procurement, cost control, and compliance with tax obligations, forming the backbone of effective cash flow management and financial planning.

📖 5. VAT Budget

🔑 Key Concepts & Definitions

• VAT Budget (Value Added Tax Budget): A financial plan estimating the amount of VAT payable or recoverable for a specific period, based on anticipated sales and purchases, as described by author(s) (date). It helps businesses forecast cash flows related to VAT obligations.

• VAT Collection and Deduction: The process of collecting VAT on sales (output VAT) and deducting VAT paid on purchases (input VAT). The difference determines the VAT payable to or recoverable from the tax authorities (author(s), date).

• VAT Regimes: Different schemes under which VAT is managed, including Reel Normal, Reel Simplifié, Franchise en Base, and Non soumis à TVA. These regimes influence how VAT is calculated, collected, and paid (author(s), date).

• VAT Payable or Credit: The net amount of VAT a business must pay to or recover from the government in a given period. Calculated as VAT collected on sales minus VAT deductible on purchases (author(s), date).

• VAT Declaration (e.g., CA3, CA12): The periodic reporting form businesses submit to declare VAT due, based on their VAT budget, and to settle their VAT liabilities (author(s), date).

📝 Essential Points

• The VAT budget is calculated monthly using the formula:
  VAT due = VAT collected on sales – VAT deductible on purchases – VAT deductible on acquisitions of fixed assets – VAT credit from previous month (see source).
  A positive result indicates VAT payable; a negative indicates a VAT credit (author(s), date).

• VAT is payable the month after the period in which it was collected or deducted, aligning with the regime of TVA (e.g., reel normal, reel simplifié, franchise en base).
  For example, under the reel normal regime, VAT must be declared and paid monthly (author(s), date).

• The VAT budget must consider the specific activity sector, as thresholds (e.g., CA >= 818,000 € for activity of purchase-revente) determine the applicable regime (author(s), date).

• Accurate VAT budgeting ensures compliance and optimizes cash flow, especially when managing VAT credits and liabilities, which are settled periodically (author(s), date).

💡 Key Takeaway

The VAT budget is a crucial financial tool that forecasts VAT liabilities or credits, enabling businesses to plan cash flows and ensure compliance with tax regulations. Proper management of VAT obligations can significantly impact overall financial health.

📖 6. Cash Flow Budget

🔑 Key Concepts & Definitions

• Cash Flow Budget: A financial plan that forecasts the inflows and outflows of cash over a specific period, enabling businesses to monitor liquidity and plan for financing needs (source content).
• Encaissements (Receipts): The total cash inflows expected during a period, including collections from sales and other income sources (source content).
• Décaissements (Disbursements): The total cash outflows during a period, covering payments for purchases, expenses, taxes, and other obligations (source content).
• Budget Adjustment for Cash Optimization: Modifications made to the initial cash flow projections to minimize financing costs and maximize short-term investments, aiming for a "cash zero" balance (source content).
• Trésorerie Positive/Negative: A situation where cash inflows exceed outflows (positive) or are less than outflows (negative), requiring management actions such as placements or financing (source content).

📝 Essential Points

• The cash flow budget is essential for managing liquidity, ensuring the company can meet its obligations without excessive borrowing or idle cash (source content).
• It involves detailed forecasting of monthly receipts and payments, including receivables and payables based on credit terms (e.g., 30 or 60 days) (source content).
• The budget must account for timing differences between sales/expenses recognition and actual cash movements, such as credit sales or delayed supplier payments (source content).
• Adjustments to the initial cash flow forecast aim to optimize the company's cash position, reducing interest costs and increasing financial returns through short-term placements (source content).
• When cash flow is negative, companies should explore financing options like bank overdrafts, short-term loans, or factoring of receivables; when positive, they can consider short-term investments (source content).
• The budget also incorporates the impact of taxes (e.g., TVA) and other financial obligations, ensuring comprehensive liquidity planning (source content).

💡 Key Takeaway

A cash flow budget is a vital tool for maintaining liquidity, enabling proactive management of inflows and outflows to avoid shortages or excess idle cash, thus supporting sustainable business operations.

📖 7. Working Capital Management

🔑 Key Concepts & Definitions

• Working Capital: The difference between a company's current assets and current liabilities, representing the liquidity available for day-to-day operations. (Source: general financial principles)
• Cash Conversion Cycle (CCC): The period between outlay of cash for inventory and receipt of cash from sales, encompassing inventory turnover, receivables collection, and payables deferral. (Source: G. Johnson (1987): emphasizes the importance of managing CCC for liquidity)
• Net Working Capital (NWC): The excess of current assets over current liabilities, indicating short-term financial health and operational efficiency. (Source: Brigham & Ehrhardt (2013): NWC optimization is crucial for working capital management)
• Working Capital Policy: Strategic decisions regarding the level of current assets and liabilities to balance liquidity and profitability. (Source: Van Horne & Wachowicz (2008): highlights the trade-offs involved in working capital policies)
• Liquidity Management: The process of ensuring sufficient cash flow to meet short-term obligations without excessive idle cash. (Source: Ross, Westerfield, Jaffe (2013): underscores the importance of liquidity for operational stability)

📝 Essential Points

• Effective working capital management involves optimizing the cash conversion cycle to improve liquidity and reduce financing costs (see G. Johnson, 1987).
• The components of working capital include inventories, receivables, and payables, which must be managed to minimize the cash cycle duration.
• Excessive current assets can reduce profitability, while insufficient working capital can lead to liquidity crises. The goal is to balance these aspects through strategic policies (see Van Horne & Wachowicz, 2008).
• Managing receivables and payables involves setting appropriate credit terms and payment policies to accelerate cash inflows and delay outflows, respectively.
• Short-term financing options (e.g., bank overdrafts, trade credit, factoring) are used to cover temporary working capital shortages, but their costs and risks must be carefully evaluated.
• The working capital policy should align with the company's overall strategy, industry standards, and economic conditions to optimize liquidity and profitability.

💡 Key Takeaway

Effective working capital management requires balancing liquidity and profitability by strategically managing current assets and liabilities to ensure operational efficiency and financial stability.

📖 8. Forecasting Cash Position

🔑 Key Concepts & Definitions

• Cash Flow Forecasting: The process of estimating future cash inflows and outflows over a specific period to predict the company's liquidity position (see section 6). It helps identify potential shortfalls or surpluses in cash.

• Budget of Cash Receipts (Encaissements): An estimate of all cash inflows during a period, including collections from sales, receivables, and other income sources, adjusted for payment delays (see section 6).

• Budget of Cash Payments (Décaissements): An estimation of all cash outflows, such as purchases, expenses, loan repayments, and taxes, considering payment terms and delays (see section 6).

• Working Capital Management: Strategies to optimize the company's short-term assets and liabilities to ensure sufficient liquidity, including managing receivables, payables, and inventory (see section 7).

• Adjustment of Cash Position: Modifications made to initial cash flow projections to achieve desired liquidity goals, such as maintaining a zero or positive cash balance, by adjusting receivables, payables, or financing (see section 6).

• Liquidity Optimization: The process of minimizing financing costs and maximizing financial income by managing cash balances, short-term investments, and debt levels based on forecasted cash flows (see section 6).

📝 Essential Points

• Forecasting cash position involves projecting inflows and outflows based on sales, purchases, expenses, and payment terms, incorporating delays and credit periods (see source content).
• The accuracy of cash flow forecasts depends on reliable estimates of sales, collection periods, payment delays, and expenses, as demonstrated in the detailed examples of business plans and budgets.
• Adjustments to the initial cash flow forecast are crucial to reach the target liquidity level, such as "cash zero," which involves strategies like reducing receivables, extending payables, or securing short-term financing (see section 6).
• The forecasted cash position at the end of each period informs decision-making regarding investments, financing, and operational adjustments to prevent liquidity shortages or excesses.
• The use of budgets for sales, purchases, VAT, and expenses enables detailed and dynamic cash flow predictions, facilitating proactive liquidity management (see source content).
• In practice, cash flow forecasting must consider timing differences between recognition of revenues/expenses and actual cash movements, including credit terms and payment schedules (see source content).

💡 Key Takeaway

Forecasting the cash position is a vital tool that combines detailed budget estimates with strategic adjustments to ensure liquidity, optimize working capital, and support sustainable business growth.

📖 9. Investment and Financing

🔑 Key Concepts & Definitions

Investment Appraisal (no specific author): The process of evaluating the potential profitability and risks of an investment project, often involving techniques such as Net Present Value (NPV), Internal Rate of Return (IRR), and Payback Period.

Financing Structure (no specific author): The composition of a company's capital, including debt and equity, which influences its financial stability, cost of capital, and risk profile.

Cost of Capital (no specific author): The rate of return required by investors to finance a project or company, serving as a discount rate in investment appraisal; includes cost of debt and equity.

Leverage Effect (no specific author): The impact of using borrowed funds (debt) on the return to equity holders, where financial leverage can amplify gains or losses depending on the project's performance.

Investment Horizon (no specific author): The period over which an investment is expected to generate returns, influencing the choice of investment and financing options.

Capital Budgeting (no specific author): The planning process for evaluating and selecting long-term investments, ensuring alignment with strategic goals and financial constraints.

📝 Essential Points

• Investment decisions require thorough appraisal to assess profitability, risks, and alignment with strategic objectives, using tools like NPV, IRR, and Payback Period (see REMI for investment evaluation methods).
• The choice of financing structure (debt vs. equity) affects the company's leverage, cost of capital, and financial risk; optimal structure balances risk and return.
• Cost of capital, including the weighted average cost of capital (WACC), is crucial for discounting future cash flows in investment appraisal.
• Leverage can enhance returns to shareholders but increases financial risk; thus, the level of debt must be carefully managed.
• Long-term investments are sensitive to the investment horizon, which influences cash flow timing and financing needs.
• Capital budgeting involves analyzing potential projects' cash flows, risks, and strategic fit, ensuring efficient allocation of resources.

💡 Key Takeaway

Investment and financing decisions are interconnected; effective evaluation of projects through capital budgeting, considering the cost of capital and optimal leverage, is essential for sustainable growth and financial stability.

📊 Synthesis Tables

Aspect	Financial Statements	Budgeting Process	Authors & References
Purpose	Summarize projected financial position (Income Statement & Balance Sheet)	Forecast future cash flows, sales, expenses, and taxes	"It forecasts activity and evaluates expected profit or loss" (Author, date); "It allows anticipation of results" (Author, date)
Key Components	Revenue, costs, expenses, assets, liabilities, equity	Sales, receivables, payables, VAT, cash flow	"Budget de ventes" (sales forecast), "budget de TVA" (VAT), "budget de trésorerie" (cash flow)
Main Use	Planning, control, decision-making	Liquidity management, operational planning	"Financial statements are built from detailed budgets" (Author, date)
Time Frame	Usually annual or quarterly	Monthly, quarterly, or annual	"Forecasted income statement" and "forecasted balance sheet" (Author, date)
Connection	Derived from detailed operational budgets	Inputs include sales, purchase, expense budgets	"It consolidates expected assets and liabilities" (Author, date)

Aspect	Sales Budget	Pitfalls & Confusions
Purpose	Estimate future sales revenue	Overestimating sales due to overly optimistic forecasts
Key Elements	Sales volume, unit price, payment terms	Ignoring seasonal variations or market trends
Impact	Guides production, cash flow, and marketing	Failing to adjust for market changes or competitor actions

⚠️ Common Pitfalls & Confusions

1. Confusing forecasted income statement with actual results; neglecting the difference in planning vs. actual data.
2. Underestimating the importance of payment conditions in cash flow forecasts, leading to liquidity shortfalls.
3. Overly optimistic sales forecasts without considering market trends or historical data.
4. Ignoring VAT adjustments and timing, resulting in inaccurate tax planning.
5. Misaligning budgets: neglecting the link between sales, purchase, and cash flow budgets.
6. Failing to update budgets regularly, causing outdated or irrelevant financial planning.
7. Overlooking the impact of currency fluctuations or inflation on forecasts and budgets.

✅ Exam Checklist

• Know the purpose and components of the forecasted income statement, including revenues, costs, and expenses (Author, date).
• Understand the structure and significance of the forecasted balance sheet, including assets, liabilities, and equity (Author, date).
• Be able to explain how detailed budgets (sales, purchases, expenses) feed into financial statements (Author, date).
• Master the concept of the sales budget: how sales volume, unit price, and payment terms influence cash inflows (source content).
• Know how to calculate and interpret the VAT budget, including VAT collected and deductible, and its impact on cash flow (source content).
• Understand the cash flow budget: its purpose, components, and how to adjust it to meet liquidity targets (source content).
• Recognize the importance of the budgeting process for proactive liquidity management and strategic planning (source content).
• Be familiar with the key authors' definitions of financial statements, budgets, and forecasting tools (e.g., "It forecasts activity," "It consolidates expected assets").
• Know the interconnections between budgets: sales, receipts, disbursements, VAT, and cash flow (source content).
• Understand the role of adjustments in cash flow planning to achieve desired liquidity positions (source content).
• Be able to identify and avoid common pitfalls such as overestimating sales, neglecting payment conditions, or ignoring market trends (common pitfalls).
• Recall the key concepts of working capital management, forecasting cash position, and investment/financing decisions (source content).