| VESPER MENSWEAR | |||||||
| Elevate Every Day — Franchise Financial Model | |||||||
| Investor & Franchisee Economics Workbook | Monthly Bottom-Up Model, FY2025-FY2029 | |||||||
| Sector | Premium Menswear - Retail Franchise | ||||||
| Founded | 2018 | ||||||
| Model | Monthly, branch-by-branch bottom-up build - 22 branches, 60-month horizon | ||||||
| Currency | All figures in USD ($) - illustrative only | ||||||
| DEMO / ILLUSTRATIVE FILE. Vesper Menswear is a fictional company created solely to demonstrate advanced financial-model construction (branch-level monthly build, ramp curves, escalation schedules, debt amortization). All names, figures and projections are invented for portfolio purposes and do not represent any real business, person or transaction. | |||||||
| Tabs in This Workbook | |||||||
| Assumptions | Growth-rate schedules, capital structure, escalation & royalty assumptions | ||||||
| Branch Roster | All 22 branches - city, sqm, status, open month | ||||||
| Revenue Build | Monthly, branch-by-branch P&L build-up: store sales -> EBITDA (60 months) | ||||||
| Annual P&L Summary | FY2025-FY2029 roll-up of the monthly model | ||||||
| Franchisee Economics | Active-partner P&L by revenue scenario, payback period | ||||||
| Company Economics | What Vesper earns per branch - upfront + ongoing | ||||||
| Loan Amortization | 60-month growth-debt facility schedule | ||||||
| Use of Proceeds | Allocation of the $4.0M growth round | ||||||
| KPI Dashboard | RAG scorecard, 5-year sparklines, and charts | ||||||
| Legend | |||||||
| ■ | Hardcoded input / assumption | ||||||
| ■ | Calculated formula | ||||||
| ■ | Link / lookup to another tab | ||||||
| VESPER MENSWEAR - Key Assumptions | ||||||
| Inputs shown in blue drive the entire monthly model. FY table (right) drives escalation formulas. | ||||||
| Company Profile & Financing | ||||||
| Founded | 2018 | |||||
| Active branches, FY2025 (from roster) | 8 | |||||
| Target branches, FY2029 (from roster) | 22 | |||||
| Growth-round size ($) | $4,000,000 | |||||
| Growth-debt facility principal ($) | $1,500,000 | |||||
| Growth-debt annual interest rate | 7.0% | |||||
| Growth-debt term (months) | 60 | |||||
| Per-Branch Capital Structure (Franchisee Economics tab) | ||||||
| Franchise Fee (paid by franchisee on signing) | $180,000 | |||||
| Branch build-out + opening inventory (cost to Vesper) | $165,000 | |||||
| Net upfront margin per branch | $15,000 | |||||
| Active Partner 1 equity | $200,000 | |||||
| Active Partner 2 equity | $200,000 | |||||
| Silent Partner equity | $150,000 | |||||
| Debt financing (per branch) | $100,000 | |||||
| Total capital per branch | $650,000 | |||||
| Branch Operating Assumptions | ||||||
| Fixed operating cost per branch, active-partner P&L (annual) | $250,000 | |||||
| Active partners' combined profit share % | 65% | |||||
| Active partner annual salary (each) | $45,000 | |||||
| Annual loan repayment (branch, shared) | $18,000 | |||||
| Marketing co-funding by Vesper (% of branch sales) | 3.0% | |||||
| Revenue Build Assumptions (monthly model) | ||||||
| Sales per sqm per month, mature branch ($) | $235 | |||||
| New-branch ramp period (months to full run-rate) | 6 | |||||
| Royalty / Company-Revenue share of store sales | 45.0% | |||||
| Base monthly HQ salaries ($) | $55,000 | |||||
| Base monthly HQ facilities & warehouse cost ($) | $9,500 | |||||
| Base monthly other HQ opex ($) | $22,000 | |||||
| Annual Escalation & Margin Schedule (FY2025-FY2029) | ||||||
| FY2025 | FY2026 | FY2027 | FY2028 | FY2029 | ||
| COGS % of Company Revenue | 52.0% | 50.0% | 48.0% | 47.0% | 46.0% | |
| Marketing % of Company Revenue | 16.0% | 15.0% | 14.0% | 13.0% | 12.0% | |
| HQ Salary Increase % (YoY) | 0.0% | 8.0% | 7.0% | 6.0% | 5.0% | |
| Facilities Cost Escalation % (YoY) | 0.0% | 5.0% | 5.0% | 4.0% | 4.0% | |
| Other HQ Opex Growth % (YoY) | 0.0% | 6.0% | 5.0% | 5.0% | 4.0% | |
| Cumulative Escalation Factors (Year-1 = 1.00x) | ||||||
| HQ Salary Factor | 1.0x | 1.1x | 1.2x | 1.2x | 1.3x | |
| Facilities Factor | 1.0x | 1.1x | 1.1x | 1.1x | 1.2x | |
| Other Opex Factor | 1.0x | 1.1x | 1.1x | 1.2x | 1.2x | |
| All figures illustrative. This tab is the single source of truth for growth-rate schedules; Branch Roster and Revenue Build reference these cells rather than re-entering numbers. | ||||||
| Branch Roster | |||||||||
| All 22 branches - the source of truth for store openings feeding the Revenue Build tab | |||||||||
| # | Branch Name | City / Location | Status | Sqm | Open Month # | Open Date | Mature Monthly Rev. ($) | Mature Annual Rev. ($) | |
| 1 | Vesper - Metro Central | Metro Central | Active | 300 | 1 | Jan-25 | $70,500 | $846,000 | |
| 2 | Vesper - Port District | Port District | Active | 280 | 1 | Jan-25 | $65,800 | $789,600 | |
| 3 | Vesper - Northgate | Northgate | Active | 260 | 3 | Mar-25 | $61,100 | $733,200 | |
| 4 | Vesper - Old Mill | Old Mill | Active | 240 | 5 | May-25 | $56,400 | $676,800 | |
| 5 | Vesper - Harbor View | Harbor | Active | 220 | 6 | Jun-25 | $51,700 | $620,400 | |
| 6 | Vesper - Fifth & Main | Downtown | Active | 300 | 8 | Aug-25 | $70,500 | $846,000 | |
| 7 | Vesper - Lakeside | Lakeside | Active | 200 | 10 | Oct-25 | $47,000 | $564,000 | |
| 8 | Vesper - Westfield | Westfield | Secured | 260 | 14 | Feb-26 | $61,100 | $733,200 | |
| 9 | Vesper - Brookhaven | Brookhaven | Secured | 240 | 17 | May-26 | $56,400 | $676,800 | |
| 10 | Vesper - Silver Creek | Silver Creek | Secured | 220 | 20 | Aug-26 | $51,700 | $620,400 | |
| 11 | Vesper - Crestwood | Crestwood | Projected | 260 | 26 | Feb-27 | $61,100 | $733,200 | |
| 12 | Vesper - Fairview | Fairview | Projected | 240 | 30 | Jun-27 | $56,400 | $676,800 | |
| 13 | Vesper - Cedar Hill | Cedar Hill | Projected | 220 | 34 | Oct-27 | $51,700 | $620,400 | |
| 14 | Vesper - Sunset Ridge | Sunset Ridge | Projected | 260 | 38 | Feb-28 | $61,100 | $733,200 | |
| 15 | Vesper - Ashford | Ashford | Projected | 240 | 41 | May-28 | $56,400 | $676,800 | |
| 16 | Vesper - Bellmont | Bellmont | Projected | 230 | 44 | Aug-28 | $54,050 | $648,600 | |
| 17 | Vesper - Kingsley | Kingsley | Projected | 250 | 47 | Nov-28 | $58,750 | $705,000 | |
| 18 | Vesper - Oakdale | Oakdale | Projected | 230 | 50 | Feb-29 | $54,050 | $648,600 | |
| 19 | Vesper - Rosewood | Rosewood | Projected | 220 | 52 | Apr-29 | $51,700 | $620,400 | |
| 20 | Vesper - Hamilton Square | Hamilton Square | Projected | 260 | 54 | Jun-29 | $61,100 | $733,200 | |
| 21 | Vesper - Ivy Court | Ivy Court | Projected | 240 | 56 | Aug-29 | $56,400 | $676,800 | |
| 22 | Vesper - Online | Direct-to-Consumer | Active | 100 | 1 | Jan-25 | $23,500 | $282,000 | |
| Total / Average | 240 | $56,293 | $14,861,400 | ||||||
| Open Month # is the month index used throughout the model (1 = Jan-2025 ... 60 = Dec-2029). Mature Monthly Revenue = Sqm x Sales-per-Sqm assumption. Illustrative demo data. | |||||||||
| Revenue Build: Monthly, Branch-by-Branch P&L | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 60-month build from store opening through mature run-rate - store sales, royalty revenue, cost structure, EBITDA | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Month # | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | |
| Month | Jan-25 | Feb-25 | Mar-25 | Apr-25 | May-25 | Jun-25 | Jul-25 | Aug-25 | Sep-25 | Oct-25 | Nov-25 | Dec-25 | Jan-26 | Feb-26 | Mar-26 | Apr-26 | May-26 | Jun-26 | Jul-26 | Aug-26 | Sep-26 | Oct-26 | Nov-26 | Dec-26 | Jan-27 | Feb-27 | Mar-27 | Apr-27 | May-27 | Jun-27 | Jul-27 | Aug-27 | Sep-27 | Oct-27 | Nov-27 | Dec-27 | Jan-28 | Feb-28 | Mar-28 | Apr-28 | May-28 | Jun-28 | Jul-28 | Aug-28 | Sep-28 | Oct-28 | Nov-28 | Dec-28 | Jan-29 | Feb-29 | Mar-29 | Apr-29 | May-29 | Jun-29 | Jul-29 | Aug-29 | Sep-29 | Oct-29 | Nov-29 | Dec-29 | |
| Year | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2026 | 2027 | 2027 | 2027 | 2027 | 2027 | 2027 | 2027 | 2027 | 2027 | 2027 | 2027 | 2027 | 2028 | 2028 | 2028 | 2028 | 2028 | 2028 | 2028 | 2028 | 2028 | 2028 | 2028 | 2028 | 2029 | 2029 | 2029 | 2029 | 2029 | 2029 | 2029 | 2029 | 2029 | 2029 | 2029 | 2029 | |
| Fiscal Year | FY2025 | FY2025 | FY2025 | FY2025 | FY2025 | FY2025 | FY2025 | FY2025 | FY2025 | FY2025 | FY2025 | FY2025 | FY2026 | FY2026 | FY2026 | FY2026 | FY2026 | FY2026 | FY2026 | FY2026 | FY2026 | FY2026 | FY2026 | FY2026 | FY2027 | FY2027 | FY2027 | FY2027 | FY2027 | FY2027 | FY2027 | FY2027 | FY2027 | FY2027 | FY2027 | FY2027 | FY2028 | FY2028 | FY2028 | FY2028 | FY2028 | FY2028 | FY2028 | FY2028 | FY2028 | FY2028 | FY2028 | FY2028 | FY2029 | FY2029 | FY2029 | FY2029 | FY2029 | FY2029 | FY2029 | FY2029 | FY2029 | FY2029 | FY2029 | FY2029 | |
| Store Sales by Branch ($) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Vesper - Metro Central | $11,750 | $23,500 | $35,250 | $47,000 | $58,750 | $70,500 | $70,500 | $70,500 | $70,500 | $70,500 | $70,500 | $70,500 | $73,320 | $73,320 | $73,320 | $73,320 | $73,320 | $73,320 | $73,320 | $73,320 | $73,320 | $73,320 | $73,320 | $73,320 | $76,253 | $76,253 | $76,253 | $76,253 | $76,253 | $76,253 | $76,253 | $76,253 | $76,253 | $76,253 | $76,253 | $76,253 | $79,303 | $79,303 | $79,303 | $79,303 | $79,303 | $79,303 | $79,303 | $79,303 | $79,303 | $79,303 | $79,303 | $79,303 | $82,475 | $82,475 | $82,475 | $82,475 | $82,475 | $82,475 | $82,475 | $82,475 | $82,475 | $82,475 | $82,475 | $82,475 | |
| Vesper - Port District | $10,967 | $21,933 | $32,900 | $43,867 | $54,833 | $65,800 | $65,800 | $65,800 | $65,800 | $65,800 | $65,800 | $65,800 | $68,432 | $68,432 | $68,432 | $68,432 | $68,432 | $68,432 | $68,432 | $68,432 | $68,432 | $68,432 | $68,432 | $68,432 | $71,169 | $71,169 | $71,169 | $71,169 | $71,169 | $71,169 | $71,169 | $71,169 | $71,169 | $71,169 | $71,169 | $71,169 | $74,016 | $74,016 | $74,016 | $74,016 | $74,016 | $74,016 | $74,016 | $74,016 | $74,016 | $74,016 | $74,016 | $74,016 | $76,977 | $76,977 | $76,977 | $76,977 | $76,977 | $76,977 | $76,977 | $76,977 | $76,977 | $76,977 | $76,977 | $76,977 | |
| Vesper - Northgate | $0 | $0 | $10,183 | $20,367 | $30,550 | $40,733 | $50,917 | $61,100 | $61,100 | $61,100 | $61,100 | $61,100 | $61,100 | $61,100 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $68,729 | $68,729 | $68,729 | $68,729 | $68,729 | $68,729 | $68,729 | $68,729 | $68,729 | $68,729 | $68,729 | $68,729 | $71,478 | $71,478 | $71,478 | $71,478 | $71,478 | $71,478 | $71,478 | $71,478 | $71,478 | $71,478 | |
| Vesper - Old Mill | $0 | $0 | $0 | $0 | $9,400 | $18,800 | $28,200 | $37,600 | $47,000 | $56,400 | $56,400 | $56,400 | $56,400 | $56,400 | $56,400 | $56,400 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $61,002 | $61,002 | $61,002 | $61,002 | $61,002 | $61,002 | $61,002 | $61,002 | $61,002 | $61,002 | $61,002 | $61,002 | $63,442 | $63,442 | $63,442 | $63,442 | $63,442 | $63,442 | $63,442 | $63,442 | $63,442 | $63,442 | $63,442 | $63,442 | $65,980 | $65,980 | $65,980 | $65,980 | $65,980 | $65,980 | $65,980 | $65,980 | |
| Vesper - Harbor View | $0 | $0 | $0 | $0 | $0 | $8,617 | $17,233 | $25,850 | $34,467 | $43,083 | $51,700 | $51,700 | $51,700 | $51,700 | $51,700 | $51,700 | $51,700 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $55,919 | $55,919 | $55,919 | $55,919 | $55,919 | $55,919 | $55,919 | $55,919 | $55,919 | $55,919 | $55,919 | $55,919 | $58,155 | $58,155 | $58,155 | $58,155 | $58,155 | $58,155 | $58,155 | $58,155 | $58,155 | $58,155 | $58,155 | $58,155 | $60,482 | $60,482 | $60,482 | $60,482 | $60,482 | $60,482 | $60,482 | |
| Vesper - Fifth & Main | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $11,750 | $23,500 | $35,250 | $47,000 | $58,750 | $70,500 | $70,500 | $70,500 | $70,500 | $70,500 | $70,500 | $70,500 | $73,320 | $73,320 | $73,320 | $73,320 | $73,320 | $73,320 | $73,320 | $73,320 | $73,320 | $73,320 | $73,320 | $73,320 | $76,253 | $76,253 | $76,253 | $76,253 | $76,253 | $76,253 | $76,253 | $76,253 | $76,253 | $76,253 | $76,253 | $76,253 | $79,303 | $79,303 | $79,303 | $79,303 | $79,303 | $79,303 | $79,303 | $79,303 | $79,303 | $79,303 | $79,303 | $79,303 | $82,475 | $82,475 | $82,475 | $82,475 | $82,475 | |
| Vesper - Lakeside | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $7,833 | $15,667 | $23,500 | $31,333 | $39,167 | $47,000 | $47,000 | $47,000 | $47,000 | $47,000 | $47,000 | $47,000 | $48,880 | $48,880 | $48,880 | $48,880 | $48,880 | $48,880 | $48,880 | $48,880 | $48,880 | $48,880 | $48,880 | $48,880 | $50,835 | $50,835 | $50,835 | $50,835 | $50,835 | $50,835 | $50,835 | $50,835 | $50,835 | $50,835 | $50,835 | $50,835 | $52,869 | $52,869 | $52,869 | $52,869 | $52,869 | $52,869 | $52,869 | $52,869 | $52,869 | $52,869 | $52,869 | $52,869 | $54,983 | $54,983 | $54,983 | |
| Vesper - Westfield | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $10,183 | $20,367 | $30,550 | $40,733 | $50,917 | $61,100 | $61,100 | $61,100 | $61,100 | $61,100 | $61,100 | $61,100 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $68,729 | $68,729 | $68,729 | $68,729 | $68,729 | $68,729 | $68,729 | $68,729 | $68,729 | $68,729 | $68,729 | |
| Vesper - Brookhaven | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $9,400 | $18,800 | $28,200 | $37,600 | $47,000 | $56,400 | $56,400 | $56,400 | $56,400 | $56,400 | $56,400 | $56,400 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $61,002 | $61,002 | $61,002 | $61,002 | $61,002 | $61,002 | $61,002 | $61,002 | $61,002 | $61,002 | $61,002 | $61,002 | $63,442 | $63,442 | $63,442 | $63,442 | $63,442 | $63,442 | $63,442 | $63,442 | |
| Vesper - Silver Creek | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $8,617 | $17,233 | $25,850 | $34,467 | $43,083 | $51,700 | $51,700 | $51,700 | $51,700 | $51,700 | $51,700 | $51,700 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $55,919 | $55,919 | $55,919 | $55,919 | $55,919 | $55,919 | $55,919 | $55,919 | $55,919 | $55,919 | $55,919 | $55,919 | $58,155 | $58,155 | $58,155 | $58,155 | $58,155 | |
| Vesper - Crestwood | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $10,183 | $20,367 | $30,550 | $40,733 | $50,917 | $61,100 | $61,100 | $61,100 | $61,100 | $61,100 | $61,100 | $61,100 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | $66,086 | |
| Vesper - Fairview | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $9,400 | $18,800 | $28,200 | $37,600 | $47,000 | $56,400 | $56,400 | $56,400 | $56,400 | $56,400 | $56,400 | $56,400 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $61,002 | $61,002 | $61,002 | $61,002 | $61,002 | $61,002 | $61,002 | |
| Vesper - Cedar Hill | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $8,617 | $17,233 | $25,850 | $34,467 | $43,083 | $51,700 | $51,700 | $51,700 | $51,700 | $51,700 | $51,700 | $51,700 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $53,768 | $55,919 | $55,919 | $55,919 | |
| Vesper - Sunset Ridge | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $10,183 | $20,367 | $30,550 | $40,733 | $50,917 | $61,100 | $61,100 | $61,100 | $61,100 | $61,100 | $61,100 | $61,100 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | $63,544 | |
| Vesper - Ashford | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $9,400 | $18,800 | $28,200 | $37,600 | $47,000 | $56,400 | $56,400 | $56,400 | $56,400 | $56,400 | $56,400 | $56,400 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | $58,656 | |
| Vesper - Bellmont | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $9,008 | $18,017 | $27,025 | $36,033 | $45,042 | $54,050 | $54,050 | $54,050 | $54,050 | $54,050 | $54,050 | $54,050 | $56,212 | $56,212 | $56,212 | $56,212 | $56,212 | |
| Vesper - Kingsley | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $9,792 | $19,583 | $29,375 | $39,167 | $48,958 | $58,750 | $58,750 | $58,750 | $58,750 | $58,750 | $58,750 | $58,750 | $61,100 | $61,100 | |
| Vesper - Oakdale | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $9,008 | $18,017 | $27,025 | $36,033 | $45,042 | $54,050 | $54,050 | $54,050 | $54,050 | $54,050 | $54,050 | |
| Vesper - Rosewood | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $8,617 | $17,233 | $25,850 | $34,467 | $43,083 | $51,700 | $51,700 | $51,700 | $51,700 | |
| Vesper - Hamilton Square | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $10,183 | $20,367 | $30,550 | $40,733 | $50,917 | $61,100 | $61,100 | |
| Vesper - Ivy Court | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $9,400 | $18,800 | $28,200 | $37,600 | $47,000 | |
| Vesper - Online | $3,917 | $7,833 | $11,750 | $15,667 | $19,583 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $23,500 | $24,440 | $24,440 | $24,440 | $24,440 | $24,440 | $24,440 | $24,440 | $24,440 | $24,440 | $24,440 | $24,440 | $24,440 | $25,418 | $25,418 | $25,418 | $25,418 | $25,418 | $25,418 | $25,418 | $25,418 | $25,418 | $25,418 | $25,418 | $25,418 | $26,434 | $26,434 | $26,434 | $26,434 | $26,434 | $26,434 | $26,434 | $26,434 | $26,434 | $26,434 | $26,434 | $26,434 | $27,492 | $27,492 | $27,492 | $27,492 | $27,492 | $27,492 | $27,492 | $27,492 | $27,492 | $27,492 | $27,492 | $27,492 | |
| Total Store Sales | $26,633 | $53,267 | $90,083 | $126,900 | $173,117 | $227,950 | $256,150 | $296,100 | $325,867 | $363,467 | $391,667 | $411,250 | $437,225 | $455,242 | $475,703 | $485,886 | $507,725 | $529,377 | $548,960 | $569,797 | $587,813 | $607,710 | $616,327 | $624,943 | $640,208 | $652,835 | $665,560 | $675,743 | $690,529 | $712,263 | $731,846 | $746,247 | $755,647 | $775,619 | $793,636 | $802,252 | $817,783 | $841,568 | $863,012 | $873,195 | $897,565 | $921,641 | $941,224 | $964,833 | $983,242 | $1,005,751 | $1,024,551 | $1,043,351 | $1,069,342 | $1,095,771 | $1,117,320 | $1,144,737 | $1,169,595 | $1,202,076 | $1,229,885 | $1,265,655 | $1,293,855 | $1,317,704 | $1,339,638 | $1,349,038 | |
| Active Branch Count | 3 | 3 | 4 | 4 | 5 | 6 | 6 | 7 | 7 | 8 | 8 | 8 | 8 | 9 | 9 | 9 | 10 | 10 | 10 | 11 | 11 | 11 | 11 | 11 | 11 | 12 | 12 | 12 | 12 | 13 | 13 | 13 | 13 | 14 | 14 | 14 | 14 | 15 | 15 | 15 | 16 | 16 | 16 | 17 | 17 | 17 | 18 | 18 | 18 | 19 | 19 | 20 | 20 | 21 | 21 | 22 | 22 | 22 | 22 | 22 | |
| Franchise / Royalty Revenue | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Company Revenue (Royalty) | $11,985 | $23,970 | $40,538 | $57,105 | $77,902 | $102,578 | $115,268 | $133,245 | $146,640 | $163,560 | $176,250 | $185,062 | $196,751 | $204,859 | $214,066 | $218,649 | $228,476 | $238,220 | $247,032 | $256,408 | $264,516 | $273,470 | $277,347 | $281,224 | $288,093 | $293,776 | $299,502 | $304,085 | $310,738 | $320,518 | $329,331 | $335,811 | $340,041 | $349,029 | $357,136 | $361,014 | $368,002 | $378,706 | $388,355 | $392,938 | $403,904 | $414,738 | $423,551 | $434,175 | $442,459 | $452,588 | $461,048 | $469,508 | $481,204 | $493,097 | $502,794 | $515,131 | $526,318 | $540,934 | $553,448 | $569,545 | $582,235 | $592,967 | $602,837 | $607,067 | |
| Cost Structure & EBITDA | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| COGS | $6,232 | $12,464 | $21,080 | $29,695 | $40,509 | $53,340 | $59,939 | $69,287 | $76,253 | $85,051 | $91,650 | $96,232 | $98,376 | $102,429 | $107,033 | $109,324 | $114,238 | $119,110 | $123,516 | $128,204 | $132,258 | $136,735 | $138,674 | $140,612 | $138,285 | $141,012 | $143,761 | $145,961 | $149,154 | $153,849 | $158,079 | $161,189 | $163,220 | $167,534 | $171,425 | $173,287 | $172,961 | $177,992 | $182,527 | $184,681 | $189,835 | $194,927 | $199,069 | $204,062 | $207,956 | $212,716 | $216,693 | $220,669 | $221,354 | $226,825 | $231,285 | $236,960 | $242,106 | $248,830 | $254,586 | $261,991 | $267,828 | $272,765 | $277,305 | $279,251 | |
| Gross Profit | $5,753 | $11,506 | $19,458 | $27,410 | $37,393 | $49,237 | $55,328 | $63,958 | $70,387 | $78,509 | $84,600 | $88,830 | $98,376 | $102,429 | $107,033 | $109,324 | $114,238 | $119,110 | $123,516 | $128,204 | $132,258 | $136,735 | $138,674 | $140,612 | $149,809 | $152,763 | $155,741 | $158,124 | $161,584 | $166,670 | $171,252 | $174,622 | $176,821 | $181,495 | $185,711 | $187,727 | $195,041 | $200,714 | $205,828 | $208,257 | $214,069 | $219,811 | $224,482 | $230,113 | $234,503 | $239,872 | $244,356 | $248,839 | $259,850 | $266,272 | $271,509 | $278,171 | $284,212 | $292,105 | $298,862 | $307,554 | $314,407 | $320,202 | $325,532 | $327,816 | |
| Marketing Expense | $1,918 | $3,835 | $6,486 | $9,137 | $12,464 | $16,412 | $18,443 | $21,319 | $23,462 | $26,170 | $28,200 | $29,610 | $29,513 | $30,729 | $32,110 | $32,797 | $34,271 | $35,733 | $37,055 | $38,461 | $39,677 | $41,020 | $41,602 | $42,184 | $40,333 | $41,129 | $41,930 | $42,572 | $43,503 | $44,873 | $46,106 | $47,014 | $47,606 | $48,864 | $49,999 | $50,542 | $47,840 | $49,232 | $50,486 | $51,082 | $52,508 | $53,916 | $55,062 | $56,443 | $57,520 | $58,836 | $59,936 | $61,036 | $57,744 | $59,172 | $60,335 | $61,816 | $63,158 | $64,912 | $66,414 | $68,345 | $69,868 | $71,156 | $72,340 | $72,848 | |
| HQ Salaries | $55,000 | $55,000 | $55,000 | $55,000 | $55,000 | $55,000 | $55,000 | $55,000 | $55,000 | $55,000 | $55,000 | $55,000 | $59,400 | $59,400 | $59,400 | $59,400 | $59,400 | $59,400 | $59,400 | $59,400 | $59,400 | $59,400 | $59,400 | $59,400 | $63,558 | $63,558 | $63,558 | $63,558 | $63,558 | $63,558 | $63,558 | $63,558 | $63,558 | $63,558 | $63,558 | $63,558 | $67,371 | $67,371 | $67,371 | $67,371 | $67,371 | $67,371 | $67,371 | $67,371 | $67,371 | $67,371 | $67,371 | $67,371 | $70,740 | $70,740 | $70,740 | $70,740 | $70,740 | $70,740 | $70,740 | $70,740 | $70,740 | $70,740 | $70,740 | $70,740 | |
| HQ Facilities & Warehouse | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,975 | $9,975 | $9,975 | $9,975 | $9,975 | $9,975 | $9,975 | $9,975 | $9,975 | $9,975 | $9,975 | $9,975 | $10,474 | $10,474 | $10,474 | $10,474 | $10,474 | $10,474 | $10,474 | $10,474 | $10,474 | $10,474 | $10,474 | $10,474 | $10,893 | $10,893 | $10,893 | $10,893 | $10,893 | $10,893 | $10,893 | $10,893 | $10,893 | $10,893 | $10,893 | $10,893 | $11,328 | $11,328 | $11,328 | $11,328 | $11,328 | $11,328 | $11,328 | $11,328 | $11,328 | $11,328 | $11,328 | $11,328 | |
| Other HQ Opex | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $23,320 | $23,320 | $23,320 | $23,320 | $23,320 | $23,320 | $23,320 | $23,320 | $23,320 | $23,320 | $23,320 | $23,320 | $24,486 | $24,486 | $24,486 | $24,486 | $24,486 | $24,486 | $24,486 | $24,486 | $24,486 | $24,486 | $24,486 | $24,486 | $25,710 | $25,710 | $25,710 | $25,710 | $25,710 | $25,710 | $25,710 | $25,710 | $25,710 | $25,710 | $25,710 | $25,710 | $26,739 | $26,739 | $26,739 | $26,739 | $26,739 | $26,739 | $26,739 | $26,739 | $26,739 | $26,739 | $26,739 | $26,739 | |
| Total Opex | $88,418 | $90,335 | $92,986 | $95,637 | $98,964 | $102,912 | $104,943 | $107,819 | $109,962 | $112,670 | $114,700 | $116,110 | $122,208 | $123,424 | $124,805 | $125,492 | $126,966 | $128,428 | $129,750 | $131,156 | $132,372 | $133,715 | $134,297 | $134,879 | $138,851 | $139,646 | $140,448 | $141,090 | $142,021 | $143,390 | $144,624 | $145,531 | $146,124 | $147,382 | $148,517 | $149,060 | $151,815 | $153,206 | $154,461 | $155,056 | $156,482 | $157,890 | $159,036 | $160,417 | $161,494 | $162,811 | $163,911 | $165,011 | $166,552 | $167,979 | $169,142 | $170,623 | $171,965 | $173,719 | $175,221 | $177,153 | $178,675 | $179,963 | $181,148 | $181,655 | |
| EBITDA | $-82,665 | $-78,830 | $-73,528 | $-68,226 | $-61,571 | $-53,675 | $-49,614 | $-43,862 | $-39,575 | $-34,161 | $-30,100 | $-27,280 | $-23,832 | $-20,994 | $-17,772 | $-16,168 | $-12,728 | $-9,318 | $-6,234 | $-2,952 | $-114 | $3,019 | $4,376 | $5,734 | $10,958 | $13,117 | $15,293 | $17,034 | $19,563 | $23,279 | $26,628 | $29,091 | $30,698 | $34,113 | $37,194 | $38,667 | $43,226 | $47,508 | $51,368 | $53,201 | $57,587 | $61,921 | $65,446 | $69,696 | $73,009 | $77,061 | $80,445 | $83,829 | $93,298 | $98,294 | $102,366 | $107,548 | $112,246 | $118,385 | $123,641 | $130,402 | $135,732 | $140,239 | $144,384 | $146,161 | |
| All figures illustrative. Ramp curve: MIN(1, months-since-open / ramp period). Post-ramp growth assumed at 4%/yr same-branch. Escalation factors and COGS/Marketing % pulled from Assumptions by fiscal year. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Annual P&L Summary: FY2025 - FY2029 | |||||||
| Roll-up of the Revenue Build monthly model into fiscal-year totals | |||||||
| FY2025 | FY2026 | FY2027 | FY2028 | FY2029 | CAGR / Multiple | ||
| Active Branch Count (year-end) | 8 | 11 | 14 | 18 | 22 | 2.8x | |
| Total Store Sales ($) | $2,742,450 | $6,446,708 | $8,642,386 | $11,177,718 | $14,594,615 | ||
| Company Revenue ($) | $1,234,102 | $2,901,019 | $3,889,074 | $5,029,973 | $6,567,577 | 51.9% | |
| COGS ($) | $641,733 | $1,450,509 | $1,866,755 | $2,364,087 | $3,021,085 | ||
| Gross Profit ($) | $592,369 | $1,450,509 | $2,022,318 | $2,665,886 | $3,546,492 | ||
| Total Opex ($) | $1,235,456 | $1,547,493 | $1,726,683 | $1,901,590 | $2,093,795 | ||
| EBITDA ($) | $-643,087 | $-96,983 | $295,635 | $764,295 | $1,452,696 | $2,095,783 | |
| Gross Margin % | 48.0% | 50.0% | 52.0% | 53.0% | 54.0% | ||
| EBITDA Margin % | -52.1% | -3.3% | 7.6% | 15.2% | 22.1% | ||
| Every cell above is a live SUM/lookup over the Revenue Build monthly model - change any assumption and this tab recalculates. Illustrative demo data, all figures in USD. | |||||||
| Franchisee Economics: What You Earn per Branch | ||||||
| Active-partner perspective | Investment: $200,000 equity | Full P&L by revenue scenario | ||||||
| Conservative | Below Base | Base ◀ | Above Base | Optimistic | ||
| Annual Branch Sales | $650,000 | $750,000 | $850,000 | $950,000 | $1,100,000 | |
| Gross Margin % | 56.0% | 54.0% | 52.0% | 51.0% | 50.0% | |
| COGS % | 44.0% | 46.0% | 48.0% | 49.0% | 50.0% | |
| Gross Profit ($) | $364,000 | $405,000 | $442,000 | $484,500 | $550,000 | |
| Fixed Operating Cost ($) | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | |
| Net Profit ($) | $114,000 | $155,000 | $192,000 | $234,500 | $300,000 | |
| Net Profit (% of Sales) | 17.5% | 20.7% | 22.6% | 24.7% | 27.3% | |
| Active Partner Profit Share | 65% | 65% | 65% | 65% | 65% | |
| Cash to Active Partner (profit share / 2) | $37,050 | $50,375 | $62,400 | $76,212 | $97,500 | |
| + Annual Salary | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | |
| - Loan Repayment (partner's share) | $-9,000 | $-9,000 | $-9,000 | $-9,000 | $-9,000 | |
| Active Partner Cash Flow | $73,050 | $86,375 | $98,400 | $112,212 | $133,500 | |
| Cash-on-Cash Yield (on $200K) | 36.5% | 43.2% | 49.2% | 56.1% | 66.8% | |
| Payback Period (months) | 32.9 mo | 27.8 mo | 24.4 mo | 21.4 mo | 18.0 mo | |
| Risk Profile - Built-In Protection | ||||||
| Break-Even Branch Sales (at base-case margin) | $480,769 | |||||
| Conservative Case Buffer Above Break-Even | 35.2% | |||||
| COGS Protection: Vesper reduces cost-of-goods to franchisees when branch sales soften. Marketing Co-Fund: Vesper reinvests a share of branch sales into shared local marketing (see Assumptions, Marketing co-funding %). | ||||||
| All figures in USD. Cash flow = profit share + salary - loan repayment share. Illustrative demo data. | ||||||
| Vesper's Economics per Managed Branch | |||||
| What Vesper earns from each franchised branch - upfront and ongoing | |||||
| Upfront Economics | |||||
| Franchise Fee (collected on signing) | $180,000 | ||||
| Less: Build-Out & Opening Inventory Cost | $-165,000 | ||||
| Net Upfront Margin per Branch | $15,000 | ||||
| Ongoing Revenue per Branch | |||||
| Avg. Mature Monthly Store Sales (from roster) | $56,293 | ||||
| Ongoing Annual Revenue per Mature Branch (royalty) | $303,983 | ||||
| Marketing Co-Funding Reinvested ($/yr, at avg. mature branch) | $20,266 | ||||
| Unit Economics Summary | |||||
| Total Year-1 Value to Vesper per Branch | $318,983 | ||||
| Annualized Ongoing Revenue at FY2029 Target (from roster) | $6,687,630 | ||||
| Cumulative Net Upfront Margin, New Branches FY25-FY29 | $210,000 | ||||
| All figures in USD. Marketing co-funding shown as % of branch sales; ratios may vary year to year. Illustrative demo data. | |||||
| Growth-Debt Facility: 60-Month Amortization | ||||||
| Term loan supporting the expansion plan - fully formula-driven schedule | ||||||
| Principal ($) | $1,500,000 | |||||
| Annual Rate | 7.0% | |||||
| Term (months) | 60 | |||||
| Monthly Payment ($) | $29,702 | |||||
| Month | Beginning Balance | Payment | Interest | Principal | Ending Balance | |
| 1 | $1,500,000 | $29,702 | $8,750 | $20,952 | $1,479,048 | |
| 2 | $1,479,048 | $29,702 | $8,628 | $21,074 | $1,457,974 | |
| 3 | $1,457,974 | $29,702 | $8,505 | $21,197 | $1,436,777 | |
| 4 | $1,436,777 | $29,702 | $8,381 | $21,321 | $1,415,457 | |
| 5 | $1,415,457 | $29,702 | $8,257 | $21,445 | $1,394,012 | |
| 6 | $1,394,012 | $29,702 | $8,132 | $21,570 | $1,372,442 | |
| 7 | $1,372,442 | $29,702 | $8,006 | $21,696 | $1,350,746 | |
| 8 | $1,350,746 | $29,702 | $7,879 | $21,822 | $1,328,923 | |
| 9 | $1,328,923 | $29,702 | $7,752 | $21,950 | $1,306,974 | |
| 10 | $1,306,974 | $29,702 | $7,624 | $22,078 | $1,284,896 | |
| 11 | $1,284,896 | $29,702 | $7,495 | $22,207 | $1,262,689 | |
| 12 | $1,262,689 | $29,702 | $7,366 | $22,336 | $1,240,353 | |
| 13 | $1,240,353 | $29,702 | $7,235 | $22,466 | $1,217,887 | |
| 14 | $1,217,887 | $29,702 | $7,104 | $22,597 | $1,195,289 | |
| 15 | $1,195,289 | $29,702 | $6,973 | $22,729 | $1,172,560 | |
| 16 | $1,172,560 | $29,702 | $6,840 | $22,862 | $1,149,698 | |
| 17 | $1,149,698 | $29,702 | $6,707 | $22,995 | $1,126,703 | |
| 18 | $1,126,703 | $29,702 | $6,572 | $23,129 | $1,103,573 | |
| 19 | $1,103,573 | $29,702 | $6,438 | $23,264 | $1,080,309 | |
| 20 | $1,080,309 | $29,702 | $6,302 | $23,400 | $1,056,909 | |
| 21 | $1,056,909 | $29,702 | $6,165 | $23,536 | $1,033,373 | |
| 22 | $1,033,373 | $29,702 | $6,028 | $23,674 | $1,009,699 | |
| 23 | $1,009,699 | $29,702 | $5,890 | $23,812 | $985,887 | |
| 24 | $985,887 | $29,702 | $5,751 | $23,951 | $961,936 | |
| 25 | $961,936 | $29,702 | $5,611 | $24,091 | $937,846 | |
| 26 | $937,846 | $29,702 | $5,471 | $24,231 | $913,615 | |
| 27 | $913,615 | $29,702 | $5,329 | $24,372 | $889,242 | |
| 28 | $889,242 | $29,702 | $5,187 | $24,515 | $864,728 | |
| 29 | $864,728 | $29,702 | $5,044 | $24,658 | $840,070 | |
| 30 | $840,070 | $29,702 | $4,900 | $24,801 | $815,269 | |
| 31 | $815,269 | $29,702 | $4,756 | $24,946 | $790,323 | |
| 32 | $790,323 | $29,702 | $4,610 | $25,092 | $765,231 | |
| 33 | $765,231 | $29,702 | $4,464 | $25,238 | $739,993 | |
| 34 | $739,993 | $29,702 | $4,317 | $25,385 | $714,608 | |
| 35 | $714,608 | $29,702 | $4,169 | $25,533 | $689,075 | |
| 36 | $689,075 | $29,702 | $4,020 | $25,682 | $663,393 | |
| 37 | $663,393 | $29,702 | $3,870 | $25,832 | $637,561 | |
| 38 | $637,561 | $29,702 | $3,719 | $25,983 | $611,578 | |
| 39 | $611,578 | $29,702 | $3,568 | $26,134 | $585,444 | |
| 40 | $585,444 | $29,702 | $3,415 | $26,287 | $559,157 | |
| 41 | $559,157 | $29,702 | $3,262 | $26,440 | $532,717 | |
| 42 | $532,717 | $29,702 | $3,108 | $26,594 | $506,123 | |
| 43 | $506,123 | $29,702 | $2,952 | $26,749 | $479,373 | |
| 44 | $479,373 | $29,702 | $2,796 | $26,905 | $452,468 | |
| 45 | $452,468 | $29,702 | $2,639 | $27,062 | $425,405 | |
| 46 | $425,405 | $29,702 | $2,482 | $27,220 | $398,185 | |
| 47 | $398,185 | $29,702 | $2,323 | $27,379 | $370,806 | |
| 48 | $370,806 | $29,702 | $2,163 | $27,539 | $343,267 | |
| 49 | $343,267 | $29,702 | $2,002 | $27,699 | $315,568 | |
| 50 | $315,568 | $29,702 | $1,841 | $27,861 | $287,707 | |
| 51 | $287,707 | $29,702 | $1,678 | $28,024 | $259,683 | |
| 52 | $259,683 | $29,702 | $1,515 | $28,187 | $231,496 | |
| 53 | $231,496 | $29,702 | $1,350 | $28,351 | $203,145 | |
| 54 | $203,145 | $29,702 | $1,185 | $28,517 | $174,628 | |
| 55 | $174,628 | $29,702 | $1,019 | $28,683 | $145,945 | |
| 56 | $145,945 | $29,702 | $851 | $28,850 | $117,095 | |
| 57 | $117,095 | $29,702 | $683 | $29,019 | $88,076 | |
| 58 | $88,076 | $29,702 | $514 | $29,188 | $58,888 | |
| 59 | $58,888 | $29,702 | $344 | $29,358 | $29,530 | |
| 60 | $29,530 | $29,702 | $172 | $29,530 | $0 | |
| Standard amortizing schedule: Payment = PMT(rate/12, term, principal). Illustrative demo data. | ||||||
| Use of Funds | ||||
| Strategic allocation of the $4.0M growth round across five pillars | ||||
| Round Size ($) | $4,000,000 | |||
| Growth Pillar | % of Round | Amount ($) | Description | |
| Prime Location Relocation | 25% | $1,000,000 | Relocating legacy branches into high-traffic malls in key metro markets | |
| Overseas Manufacturing Shift | 20% | $800,000 | Shifting production overseas to unlock better margins & pricing power | |
| Debt Restructuring | 15% | $600,000 | Retiring high-interest legacy loans to free up cash flow | |
| Marketing Expansion | 30% | $1,200,000 | Aggressive brand & digital investment to accelerate customer acquisition | |
| Board & Governance | 10% | $400,000 | Recruiting senior professionals to strengthen strategy & investor confidence | |
| Total | 100% | $4,000,000 | ||
| Check (should be $0) | $0 | |||
| Every dollar deployed to accelerate the path from 7 to 22 branches - and from planned loss to platform profitability. Illustrative demo data. | ||||
| KPI Dashboard | |||||||
| RAG scorecard - FY2025 baseline vs. FY2029 target, with 5-year trend and commentary | |||||||
| KPI | FY2025 | FY2029 Target | Growth | Status | 5-Yr Trend | Commentary | |
| Active Branch Count | 8 | 22 | 175% | ● | ▁▂▄▆█ | Store count more than triples as the secured & projected pipeline converts to open branches. | |
| Total Store Sales ($) | $2,742,450 | $14,594,615 | 432% | ● | ▁▃▄▆█ | End-customer sales scale with both new-branch openings and same-branch growth. | |
| Company Revenue ($) | $1,234,102 | $6,567,577 | 432% | ● | ▁▃▄▆█ | Recognized revenue = royalty share of store sales; the metric that flows into EBITDA. | |
| Gross Profit ($) | $592,369 | $3,546,492 | 499% | ● | ▁▃▄▆█ | COGS % improves as the overseas-sourcing shift phases in (see Assumptions schedule). | |
| EBITDA ($) | $-643,087 | $1,452,696 | 326% | ● | ▁▃▄▆█ | Fixed HQ costs are spread across a growing branch base - EBITDA inflects positive mid-plan. | |
| EBITDA Margin % | -52.1% | 22.1% | 142% | ● | ▁▆▇▇█ | Operating leverage: EBITDA margin expands from a loss to a healthy double-digit margin. | |
| Branch Payback Period (mo., by scenario) | 32.9 mo | 18.0 mo | 45% | ● | █▆▄▃▁ | Payback shortens from ~33 months (conservative) to 18 months (optimistic) as branch sales scale. | |
| Cash-on-Cash Yield (by scenario) | 37% | 67% | 83% | ● | ▁▃▄▆█ | Active-partner cash yield on $200K equity ranges 37%-67% across the five sales scenarios. | |
| Underlying Annual Data (linked) | |||||||
| FY2025 | FY2026 | FY2027 | FY2028 | FY2029 | |||
| Store Count | 8 | 11 | 14 | 18 | 22 | ||
| Company Revenue ($) | $1,234,102 | $2,901,019 | $3,889,074 | $5,029,973 | $6,567,577 | ||
| EBITDA ($) | $-643,087 | $-96,983 | $295,635 | $764,295 | $1,452,696 | ||
| Illustrative demo data created to showcase advanced financial-model formatting. Not a real business. | |||||||