Financial Modeling
Challenge
NEST is an owner and operator of maternal and children's healthcare facilities in Senegal. They have 2 locations in Dakar, the capital of Senegal, and achieved revenue of ~$1.3m in FY19. NEST is the only healthcare provider in Senegal to have received an ISO certification for every aspect of their operations and processes.
NEST is seeking up to ~$11m in funding (equity, debt, and/or grants) to expand their operations by acquiring and improving the operations of existing, practitioner-owned and operated healthcare facilities throughout West/Central Africa.
The purpose of the engagement is to help NEST refine their business plan by (1) appropriately budgeting the capital requirements of their expansion program, (2) developing a rigorous valuation and acquisition structuring framework for potential targets and (3) identifying financing structures that would be sustainable for NEST while being attractive for potential capital providers.
Expected outcome
(1) Flexible financial model in Excel format including all formulas and an output tab summarizing key P&L, cashflow statement, balance sheet, equity return analysis, and debt service coverage ratios over the next 7 years
(2) Clinic valuation and transaction structuring memo (1-2 pages/slides)
Resources provided
Historical financials, customer survey data, business plan, investor presentations/teasers
Program structure
Modèle financier
Élaborer un modèle financier détaillé incluant les opérations actuelles et les acquisitions futures.
Structure de financement
Calibrer la structure de financement des nouvelles acquisitions afin de permettre une combinaison flexible entre financement par capitaux propres, emprunts et subventions.
Note sur l'évaluation de la clinique et la structuration de l'acquisition
Élaborer une note d'évaluation clinique et de structuration de l'acquisition à l'intention de la direction de NEST.
Compétences
Les langues
Nonprofit mission
NEST's mission is to offer quality healthcare to low and middle populations in urban and peri-urban areas of West and Central Africa, through a network of quality certified medical centers.
Publié par
