Some details
CHALLENGE
How much should I invest in this business?
How much should I charge for each procedure?
Is this business idea profitable?
When can I reach a break-even level?
The customer wanted to have a comprehensive financial model to answer that kind of questions.
SOLUTION
We did not hard-code any assumptions. All the variables could be edited
directly from the dashboard or at the expense/wages tabs. Thanks to it, we could test different alternatives and make any edits literally on the fly.Finally, we delivered a fully customized financial model shall contain the following:
- Dashboard with core inputs and core outputs
- Patient base forecast
- Revenue model based on visits
- Flexible Pricing model by years
- Variable and Fixed expenses model
- Wages and staff strength model
- CAPEX additions and depreciation model
- CapTable &, Debt Financing and repayment schedule
- Income Statement, Balance Sheet, and Cashflow for 5 years
- Valuation of Company – DCF
Have any questions? – Just message us with anything you would like to know. Thank you!
