Модуль №4. Фінансове планування: прогноз Cash Flow, бюджетування, точка окупності інвестицій.

High-level summary

Practical, entrepreneur-oriented guidance on financial planning, cash‑flow forecasting and budgeting. Focus is on building multi‑year financial plans to guide strategy and attract lenders/investors, while using monthly budgets and cash‑flow forecasts to manage day‑to‑day liquidity and operations.

Core themes

• Financial planning: multi‑year, forward‑looking (3–5 years). Used to attract lenders/investors and to guide strategy.
• Budgeting: internal operational control tool (typically 12 months, with monthly plan‑vs‑fact monitoring). Used to control expenses and course‑correct.
• Cash‑flow forecasting: central to detecting timing gaps and planning financing; should model operating, investing and financing flows.
• Liquidity management: mix own funds, grants, loans, subsidies and investor equity to ensure continuity and growth.

Frameworks, processes and playbooks

Cash‑flow statement decomposition

• Operating cash flows: sales receipts, operating expenses.
• Investing cash flows: capex, asset purchases.
• Financing cash flows: loan receipts and repayments, grants, investor equity.

Liquidity / cash‑gap playbook

• Forecast timing of inflows versus outflows.
• Negotiate accounts receivable/payable (AR/AP) terms with buyers and suppliers.
• Use reserves, credit lines/overdrafts, short‑term loans, factoring.
• Sequence capex payments and keep retention until commissioning.

Budgeting process

• Build a 12‑month budget; update monthly.
• Perform plan‑vs‑fact variance analysis and act (reduce costs or drive revenue).
• Avoid common mistakes: over‑optimistic revenue, underestimated expenses, ignoring seasonality, no reserves.

Investment evaluation approaches

• Simple payback period: easy to calculate; ignores time value of money.
• Discounted cash flow (DCF) / Net Present Value (NPV): uses a discount rate; more accurate and preferred by banks/investors.
• Use EBITDA as a cash‑based profitability proxy in investment models.

Mixed‑financing design

• Combine own contribution + grant (often tranche‑based) + short‑term loan for working capital + investor/subsidy.

Owner vs accountant roles

• Accountant: historical recording and tax compliance.
• Owner/manager: forward‑looking financial planning and decisions. Owner must understand core numbers (revenues, margins, cash needs).

Key metrics, KPIs, assumptions and targets (case study examples)

• Capex example (solar plant): 1,650,000 UAH
  • Simple payback (savings‑only) = 1,650,000 / 200,000 ≈ 8.25 years.
• DCF example:
  • Capex = 1,000,000 UAH; projected cash flows = 300k / 350k / 400k / 450k (years 1–4); discount rate = 10%.
  • Sum of discounted cash flows ≈ 1,484k UAH; NPV ≈ +408k UAH → project acceptable.
• Agricultural producer assumptions:
  • Land lease = 7,000 UAH/ha per year.
  • Total asset value = 78,000,000 UAH.
  • Annual depreciation ≈ 9.2% of asset value.
  • Wage‑related tax burden ≈ 45% (18% PIT + 5% military levy + 22% employer).
  • Expense inflation = 10% p.a.
  • Selling price growth = +1,000 UAH/ton per year.
  • Yield improvement = +0.5 t/ha per year.
  • Losses reduced from 15% to 10% starting year 2.
  • Harvest/timing: harvest in Q3–Q4; sales split 60% in Q4, 40% in Q1 of next year.
• Operational metric emphasized: track EBITDA versus net profit.

Concrete case studies and examples

Agricultural producer (example: “borscht set” — potatoes, carrots, beets, cabbage)

• Production plan: area × yield; adjust for losses and seasonality in storage/sales.
• Revenue recognition: reflect seasonal sales timing (60% Q4, 40% Q1).
• Major operating costs: seeds, fertilizers, fuel, packaging, logistics, wages (seasonal + fixed admin), land rent.
• Capex example: install 30 kW solar plant to reduce electricity costs for refrigerated storage.
  • Financing split: grant (e.g., 1,000,000 UAH paid in tranches), Vision Fund short‑term loan for working capital, investor contribution (e.g., 100,000 UAH), state subsidy, company own funds.
  • Cash‑flow sequencing: stagger capex payments, schedule grant tranches, time loan drawdowns/repayments so cash stays positive. In the model presented, only Q3 required bridging; earlier positive balances covered it.

Micro and small business examples

• Sole proprietors (roses, curtain‑maker, beekeepers):
  • Even microbusinesses should budget (include owner salary) and track simple income/expense columns.
  • Use prepayments/advances to avoid cash gaps for bespoke orders.
  • For seasonal businesses, combine supplier credit, short‑term loans, grants/subsidies and prepayments to bridge gaps.

Actionable recommendations (next steps for entrepreneurs)

• Build a multi‑year financial plan (3–5 years) for strategic conversations; build a 12‑month budget updated monthly for operational control.
• Start with simple templates: list expected volumes, prices, losses and seasonality; include owner salary and taxes.
• Model cash flows (operating, investing, financing) to spot cash gaps; plan financing before a gap occurs.
• Use mixed financing; expect grants to be partial and tranche‑based — prepare co‑financing from own funds or short‑term loans.
• Run simple investment metrics first (payback), then DCF/NPV if seeking bank/investor financing.
• Negotiate AR/AP terms; consider factoring for receivables and supplier credit for payables.
• Maintain a reserve fund and access to quick credit (overdraft, short loan) for flexibility.
• Do monthly plan‑vs‑fact variance analysis and take corrective action promptly.
• For producers: prepare a tailored production plan (not a one‑size‑fits‑all template) to justify revenue and costs to funders.
• Leverage available tools: workbook templates, loan calculators and program directories to estimate loan cost and fit financing into your cash plan.

Operational tools & resources mentioned

• Vision Fund Ukraine workbook and downloadable financial plan templates (pre‑filled examples + blank templates with formulas).
• Vision Fund loan calculator and list of finance programs (state/regional grants, subsidies, specialized agri loans).
• Mentoring (Zoom) sessions offered alongside lectures for 1:1 guidance and plan review.

Common pitfalls to avoid

• Overly optimistic revenue forecasts and underestimated expenses.
• Ignoring seasonality and timing of cash receipts.
• No contingency reserves or diversification of financing sources.
• Delegating all financial planning to an accountant (accounting ≠ forward‑looking financial planning).

Presenters and sources

• Ivan Koryakin — lecturer, financier (30 years business experience; 21 years in finance; PhD in Economics).
• Alina Sevastyuk — program manager, Vision Fund Ukraine (organizer/host).
• Program organizer: Vision Fund Ukraine; partners include Aktion Deutschland Hilft, World Vision, Del.ua, Ekonomika Plus / VOM.ua; ecosystem partners: UVHub, Women InTech.

Templates, calculators and recordings referenced are available at visionfund.ua → Resources → Workbook for the Financial Literacy for Entrepreneurs program.