Tooth Shield India — Financial Feasibility Model
3-Year Projection · B2B Dental Clinics · All amounts in Indian Rupees
Performance Dashboard
Drag levers to pressure-test the plan · Use year selector to view any year's KPIs
Live leversDrag to test sensitivity — verdict & metrics update in real time
Headline Metrics
Unit Economics & Funding
Charts & Visual Analysis
Monthly Revenue vs. Total Cost
Year 1 — 12 months
Cumulative Cash Balance
Year 1 monthly · zero line shown
Cost Breakdown
Composition of total costs
Gross Margin % Trend
Monthly progression
Monthly Plan
Edit any cell — changes cascade to all tabs · Sidebar values seed defaults but this table is the source of truth
Additional costs appear in P&L as operating expenses
Profit & Loss Statement
Monthly detail with year selector · Annual summary · Driven by Monthly Plan table
Cash Flow Statement
DSO-adjusted collections · Machine additions shown as mid-year capex · Red = negative balance
Balance Sheet
Year-end snapshots · Reflects expansion capex · Balance check must equal zero
Scenario Analysis
Bear / Base / Bull side-by-side comparison
Capex Estimation
Capacity in units · Machine timeline with mid-year additions · Depreciation pro-rated by half-year rule
📦 Expansion CapEx Plan
Multi-year machine scaling · Additional capex flows into Cash Flow & Balance Sheet
Version History
Save, freeze and compare model snapshots