Healthcare IoT Financial Model

Project Overview

Developed a fully integrated 3-statement financial model for a healthcare IoT business providing cattle health monitoring solutions through connected devices and cloud-based subscription services.

The model projected monthly financial performance over a 24-month forecast period, incorporating device installations, subscription revenue growth, operating expenses, working capital assumptions, and valuation analysis using DCF, multiple-based, and cost-based approaches.

Business & Revenue Model

The company operates a hybrid revenue structure combining one-time device installation revenue with recurring subscription-based monitoring income, creating predictable long-duration cash flows.

Device installation revenue was modelled at ₹3,200 per device with an initial deployment of 100 devices growing at 10% month-over-month under a compounded expansion framework.

Subscription revenue was projected at ₹200 per device per month, while cloud servicing costs were estimated at ₹50 per device, enabling analysis of recurring gross margin scalability.

Key Findings & Insights

• Device installations scaled from 100 units initially to ~895 units by the end of the forecast horizon under 10% monthly compounded growth assumptions.
• Subscription-driven recurring revenue increased steadily from ₹20,000 per month to ~₹1.79 lakh per month, improving revenue visibility and predictability.
• DCF valuation estimated enterprise value at approximately ₹4.46 crore based on projected long-term free cash flow generation.
• Analysis highlighted the importance of recurring subscription retention and operational scalability in driving long-term intrinsic valuation.
• Working capital analysis showed that delayed receivable collection cycles could create short-term liquidity pressure despite strong long-term revenue growth potential.

Financial Modeling Methodology

• Built integrated Income Statement, Balance Sheet, and Cash Flow projections
• Created monthly device deployment and subscription forecasting schedules
• Forecasted recurring revenue, cloud servicing costs, and operating expenses
• Modelled working capital assumptions using receivable and payable cycles
• Developed depreciation schedules and capex assumptions for business scaling
• Performed DCF, multiple-based, and cost-based valuation analysis
• Calculated enterprise valuation range under varying growth assumptions

Valuation Analysis

DCF valuation estimated enterprise value at ~₹4.46 crore using a 15% discount rate and 4% terminal growth assumption.

Multiple-based valuation highlighted the sensitivity of early-stage startup valuation to profitability assumptions, while cost-based valuation established a conservative downside asset benchmark.

The valuation exercise demonstrated how recurring SaaS-style subscription revenue models can create substantial intrinsic value despite initially negative EBITDA margins.

Key Assumptions

• 10% monthly device installation growth under compounded scaling assumptions
• ₹200 monthly subscription fee per active device
• Cloud servicing cost of ₹50 per device per month
• 45-day receivable cycle and 61-day payable cycle assumptions
• 15% WACC and 4% terminal growth rate used for DCF valuation
• Employee costs and operating expenses escalated annually based on projected business expansion

Risks & Strategic Considerations

• Customer retention risk impacting recurring subscription revenue sustainability
• Operational dependency on device reliability and cloud infrastructure uptime
• Cash flow pressure arising from delayed receivable realization
• High upfront scaling costs potentially delaying operating profitability
• Valuation sensitivity to terminal growth and long-duration cash flow assumptions

Skills & Tools Used

Key Learnings

Strengthened practical understanding of startup financial modelling, recurring revenue economics, operational scalability analysis, and long-term valuation frameworks for early-stage technology-enabled businesses.

The project also improved analytical thinking regarding subscription-based business models, unit economics, and the relationship between scalability, working capital efficiency, and enterprise valuation.