Savanna Harvest Supermarket — Financial Plan

The following financial projections have been prepared based on conservative assumptions, industry benchmarks for the South African grocery retail sector, and the specific operating characteristics of the Polokwane market. All projections are presented in South African Rand (ZAR) and assume a five-year…

Savanna Harvest Supermarket (Pty) Ltd Business PlanSection 13 › Financial Plan

Section 13 · Business Plan

Financial Plan

The following financial projections have been prepared based on conservative assumptions, industry benchmarks for the South African grocery retail sector, and the specific operating characteristics of the Polokwane market. All projections are presented in South African Rand (ZAR) and assume a five-year…

Year 5 Revenue
R85,963,000

Growing toward R65 million by Year 3, with a 25–27% gross margin, a 9–11% EBITDA margin and a 6.0% Year-3 net profit margin.

The following financial projections have been prepared based on conservative assumptions, industry benchmarks for the South African grocery retail sector, and the specific operating characteristics of the Polokwane market. All projections are presented in South African Rand (ZAR) and assume a five-year forecast period.

13.1 Startup Capital Requirements

Figure
Capital Allocation — visualised from the accompanying data.
Item Amount (ZAR) % of Total
Lease Deposit & Store Fit-out R5,500,000 29.7%
Equipment & Fixtures (shelving, refrigeration, bakery, butchery) R4,200,000 22.7%
Initial Inventory (opening stock) R4,000,000 21.6%
Technology & POS Systems R1,800,000 9.7%
Working Capital Reserve R1,500,000 8.1%
Licences, Permits & Regulatory Compliance R500,000 2.7%
Marketing & Launch Campaign R1,000,000 5.4%
Total Investment R18,500,000 100.0%

13.2 Revenue Projections

Figure
Revenue Projection — visualised from the accompanying data.

13.3 Key Financial Assumptions

Assumption Basis
Year 1 Revenue R42,000,000 – Based on average daily sales of R115,000
Revenue Growth Rate Year 2: 30%, Year 3: 19%, Year 4: 15%, Year 5: 15%
Gross Margin 25% in Year 1, improving to 27% by Year 3 as buying power increases
Staff Costs (% of Revenue) 16.5% in Year 1, declining to 14.5% by Year 5
Rental Cost R100/sqm escalating at 8% per annum
Marketing Expenditure 2.9% of revenue in Year 1, declining to 2.0% by Year 5
Depreciation Straight-line over 5–10 years depending on asset class
Corporate Tax Rate 27% (South African standard rate)
Inflation Assumption 5.5% per annum on operating costs
Shrinkage & Wastage 1.5% of revenue in Year 1, reducing to 1.0% by Year 3

13.4 Projected Profit and Loss Statement

The following table presents the projected income statement for Savanna Harvest Supermarket over a five-year forecast period. Revenue projections are based on conservative market penetration assumptions, with gross margins improving over time as the business achieves greater scale and procurement efficiency.

Income Statement (ZAR '000) Year 1 Year 2 Year 3 Year 4 Year 5
Revenue 42,000 54,600 65,000 74,750 85,963
Cost of Goods Sold (COGS) (31,500) (40,404) (47,450) (53,843) (61,057)
Gross Profit 10,500 14,196 17,550 20,907 24,906
Gross Margin % 25.0% 26.0% 27.0% 28.0% 29.0%
Staff Costs (6,930) (8,736) (10,075) (11,213) (12,464)
Rental & Occupancy (2,400) (2,592) (2,799) (3,023) (3,265)
Marketing & Advertising (1,220) (1,365) (1,430) (1,495) (1,719)
Utilities & Services (840) (924) (1,001) (1,083) (1,170)
Insurance (360) (389) (420) (454) (490)
Depreciation & Amortisation (1,850) (1,850) (1,850) (1,850) (1,850)
Other Operating Expenses (630) (819) (975) (1,121) (1,289)
Total Operating Expenses (14,230) (16,675) (18,550) (20,239) (22,247)
EBITDA 3,780 5,733 7,475 9,218 11,175
EBITDA Margin % 9.0% 10.5% 11.5% 12.3% 13.0%
Depreciation & Amortisation (1,850) (1,850) (1,850) (1,850) (1,850)
Earnings Before Interest & Tax (EBIT) 1,930 3,883 5,625 7,368 9,325
Interest Expense (1,010) (910) (810) (710) (610)
Profit Before Tax (PBT) 920 2,973 4,815 6,658 8,715
Corporate Tax (27%) (248) (803) (1,300) (1,798) (2,353)
Net Profit After Tax 672 2,170 3,515 4,860 6,362
Net Profit Margin % 1.6% 4.0% 5.4% 6.5% 7.4%
Figure
Profit Comparison — visualised from the accompanying data.
Figure
Ebitda Margin — visualised from the accompanying data.

13.5 Projected Balance Sheet

The following balance sheet projections reflect the anticipated financial position of Savanna Harvest Supermarket at the end of each financial year. The balance sheet demonstrates a progressively strengthening equity position as retained earnings accumulate, with prudent management of working capital and asset investment.

Balance Sheet (ZAR '000) Year 1 Year 2 Year 3 Year 4 Year 5
ASSETS
Non-Current Assets
Property, Plant & Equipment 9,700 9,050 8,700 8,850 9,500
Intangible Assets (Software) 400 320 240 160 80
Deposits & Guarantees 300 300 300 300 300
Total Non-Current Assets 10,400 9,670 9,240 9,310 9,880
Current Assets
Inventory 4,200 4,800 5,400 5,900 6,500
Trade Receivables 420 546 650 748 860
Cash & Cash Equivalents 2,850 5,200 8,800 13,400 19,200
Prepayments 180 200 220 240 260
Total Current Assets 7,650 10,746 15,070 20,288 26,820
TOTAL ASSETS 18,050 20,416 24,310 29,598 36,700
EQUITY & LIABILITIES
Shareholders’ Equity
Share Capital 18,500 18,500 18,500 18,500 18,500
Retained Earnings 672 2,842 6,357 11,217 17,579
Total Equity 19,172 21,342 24,857 29,717 36,079
Non-Current Liabilities
Long-Term Borrowings 0 0 0 0 0
Deferred Tax Liability 120 150 180 210 240
Total Non-Current Liabilities 120 150 180 210 240
Current Liabilities
Trade Payables (2,100) (2,020) (1,700) (1,350) (700)
Accrued Expenses (420) (500) (580) (630) (680)
VAT Payable (480) (320) (210) (120) (20)
Short-Term Provisions (242) (236) (237) (229) (219)
Total Current Liabilities (1,242) (1,076) (727) (329) (381)
TOTAL EQUITY & LIABILITIES 18,050 20,416 24,310 29,598 36,700

13.6 Projected Cash Flow Statement

The cash flow statement is arguably the most important financial projection for a retail business, as it demonstrates the ability of the business to generate sufficient operating cash to service its obligations, fund working capital requirements, and provide returns to shareholders. The projections below demonstrate that Savanna Harvest is expected to generate positive operating cash flow from Year 1.

Cash Flow Statement (ZAR '000) Year 1 Year 2 Year 3 Year 4 Year 5
OPERATING ACTIVITIES
Net Profit After Tax 672 2,170 3,515 4,860 6,362
Add: Depreciation & Amortisation 1,850 1,850 1,850 1,850 1,850
Changes in Working Capital:
(Increase)/Decrease in Inventory (200) (600) (600) (500) (600)
(Increase)/Decrease in Receivables (420) (126) (104) (98) (112)
Increase/(Decrease) in Payables 948 (80) (320) (350) (350)
Movement in Accruals & Provisions 0 74 61 42 40
Net Cash from Operations 2,850 3,288 4,402 5,804 7,190
INVESTING ACTIVITIES
Capital Expenditure (Fit-out, Equipment) (11,500) (700) (900) (1,200) (1,500)
Technology Investments (1,800) (200) (200) (200) (200)
Initial Inventory Investment (4,000) 0 0 0 0
Deposits & Guarantees (300) 0 0 0 0
Net Cash from Investing (17,600) (900) (1,100) (1,400) (1,700)
FINANCING ACTIVITIES
Share Capital Invested 18,500 0 0 0 0
Dividends Paid 0 0 0 (1,000) (1,500)
Loan Drawdown / (Repayment) 0 0 0 0 0
Net Cash from Financing 18,500 0 0 (1,000) (1,500)
Net Cash Movement 3,750 2,388 3,302 3,404 3,990
Opening Cash Balance 0 3,750 6,138 9,440 12,844
Closing Cash Balance 3,750 6,138 9,440 12,844 16,834
Figure
Cashflow Summary — visualised from the accompanying data.

13.7 Break-Even Analysis

The break-even analysis determines the minimum revenue level at which total costs are fully covered and the business begins to generate a profit. For Savanna Harvest Supermarket, fixed operating costs (excluding COGS) are estimated at approximately R16.2 million per annum in Year 1, with a variable cost ratio of approximately 75% (cost of goods sold as a percentage of revenue).

Based on these assumptions, the annual break-even revenue is calculated at approximately R64.7 million. The business is projected to approach break-even within the first 18–24 months of operation, with full-year profitability expected from Year 2 onwards. The chart below illustrates the break-even dynamics.

Figure
Breakeven — visualised from the accompanying data.

13.8 Key Financial Ratios

Financial Ratio Year 1 Year 2 Year 3 Year 4 Year 5
Gross Margin 25.0% 26.0% 27.0% 28.0% 29.0%
EBITDA Margin 9.0% 10.5% 11.5% 12.3% 13.0%
Net Profit Margin 1.6% 4.0% 5.4% 6.5% 7.4%
Return on Equity (ROE) 3.5% 10.2% 14.1% 16.4% 17.6%
Return on Assets (ROA) 3.7% 10.6% 14.5% 16.4% 17.3%
Current Ratio 6.2x 10.0x 20.7x 61.7x 70.4x
Inventory Turnover 7.5x 8.4x 8.8x 9.1x 9.4x
Staff Cost / Revenue 16.5% 16.0% 15.5% 15.0% 14.5%
Debt-to-Equity Ratio 0.00 0.00 0.00 0.00 0.00

This document contains proprietary and confidential information. Distribution without written consent is prohibited.