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
Modello finanziario
Costruire un modello finanziario dettagliato che includa le operazioni attuali e le acquisizioni future
Struttura di finanziamento
Calibrare la struttura di finanziamento delle nuove acquisizioni per consentire una combinazione flessibile di finanziamenti tra capitale proprio, debito e sovvenzioni.
Memorandum sulla valutazione della clinica e sulla strutturazione dell'acquisizione
Sviluppare una valutazione clinica e un memorandum di strutturazione dell'acquisizione da utilizzare da parte della direzione di NEST.
Competenze
Lingue
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.
Postato da
