Numbers tell a story — I make sure it's the right one. I help businesses uncover growth drivers, build robust financial models, and deliver dashboards that drive executive action.
A comprehensive suite of dashboards covering the full financial analysis spectrum — from revenue performance to 3-statement modeling, profitability deep-dives, and customer cohort analysis.
| Department | Revenue | % Mix | Growth | Status |
|---|---|---|---|---|
| Inpatient | $19,280 | 40.0% | +14.2% | Strong |
| Outpatient | $11,568 | 24.0% | +11.5% | Healthy |
| ICU | $7,230 | 15.0% | +18.4% | Strong |
| Cath Lab | $5,784 | 12.0% | +22.1% | Star |
| Pharmacy | $4,338 | 9.0% | -3.2% | Declining |
| Total | $48,200 | 100% | +12.4% |
| Driver | Amount | Contribution | Growth % |
|---|---|---|---|
| Price Effect | $3,782,700 | 53% | +17% |
| Utilization Effect | $3,105,464 | 43% | +14% |
| Volume Effect | $461,479 | 6% | +2% |
| Mix / Pharmacy | ($175,219) | -2% | -1% |
| Total Growth | $7,174,424 | 100% | +31% |
| Line Item | Current | % Rev | PY | YoY |
|---|---|---|---|---|
| Revenue | $48,200 | 100.0% | $42,884 | +12.4% |
| COGS | ($27,580) | 57.2% | ($25,250) | +9.2% |
| Gross Profit | $20,620 | 42.8% | $17,634 | +16.9% |
| S&M | ($6,750) | 14.0% | ($6,260) | +7.8% |
| R&D | ($3,180) | 6.6% | ($2,815) | +13.0% |
| G&A | ($1,990) | 4.1% | ($1,860) | +7.0% |
| Operating Income | $8,700 | 18.0% | $6,699 | +29.9% |
| + D&A | $2,600 | 5.4% | $2,605 | -0.2% |
| EBITDA | $11,300 | 23.4% | $9,304 | +21.5% |
| Interest & Tax | ($2,500) | 5.2% | ($2,066) | +21.0% |
| Net Income | $6,200 | 12.9% | $5,238 | +18.4% |
| ASSETS | |
| Cash & Equivalents | $14,200 |
| Accounts Receivable | $8,640 |
| Inventory | $5,820 |
| Other Current | $2,140 |
| Current Assets | $30,800 |
| PP&E (net) | $32,400 |
| Intangibles | $15,200 |
| Total Assets | $78,400 |
| LIABILITIES & EQUITY | |
| Accounts Payable | $6,820 |
| Short-term Debt | $3,420 |
| Other Current | $3,880 |
| Current Liabilities | $14,120 |
| Long-term Debt | $15,200 |
| Other LT | $6,480 |
| Equity | $42,600 |
| Total L+E | $78,400 |
| OPERATING | |
| Net Income | $6,200 |
| + D&A | $2,600 |
| + Stock Comp | $580 |
| Δ Working Capital | ($1,420) |
| Cash from Operations | $7,960 |
| INVESTING | |
| CapEx | ($3,200) |
| Acquisitions | ($1,800) |
| Cash from Investing | ($5,000) |
| FINANCING | |
| Debt Repayment | ($1,200) |
| Dividends | ($650) |
| Cash from Financing | ($1,850) |
| Net Change in Cash | $1,110 |
| Free Cash Flow | $4,760 |
| Component | Current | PY | Δ |
|---|---|---|---|
| Accounts Receivable | $8,640 | $7,860 | +$780 |
| Inventory | $5,820 | $5,640 | +$180 |
| Prepaid Expenses | $1,420 | $1,280 | +$140 |
| Accounts Payable | ($6,820) | ($5,940) | +$880 |
| Accrued Expenses | ($2,420) | ($2,180) | +$240 |
| Net Working Capital | $6,640 | $6,660 | ($20) |
| Physician | Specialty | Revenue | Direct Cost | Contribution | Margin | Patients | Status |
|---|---|---|---|---|---|---|---|
| Dr. A. Hassan | Cardiology | $1,420K | ($820K) | $600K | 42.3% | 1,240 | Star |
| Dr. S. Mahmoud | Orthopedics | $1,180K | ($710K) | $470K | 39.8% | 980 | Star |
| Dr. M. Ibrahim | Neurology | $1,050K | ($680K) | $370K | 35.2% | 820 | Healthy |
| Dr. F. Nabil | Oncology | $980K | ($650K) | $330K | 33.7% | 560 | Healthy |
| Dr. R. Youssef | Cardiology | $920K | ($580K) | $340K | 37.0% | 890 | Healthy |
| Dr. H. Salem | Internal Med | $850K | ($620K) | $230K | 27.1% | 1,450 | Cash Cow |
| Dr. K. Adel | Pediatrics | $720K | ($530K) | $190K | 26.4% | 1,680 | Cash Cow |
| Dr. N. Farag | Gen Surgery | $680K | ($520K) | $160K | 23.5% | 420 | Question |
| Dr. L. Mostafa | Dermatology | $620K | ($380K) | $240K | 38.7% | 1,920 | Healthy |
| Dr. W. Karim | Urology | $580K | ($420K) | $160K | 27.6% | 640 | Question |
| Top 10 Total | $9,000K | ($5,910K) | $3,090K | 34.3% | 10,600 |
| Specialty | Physicians | Revenue | Avg Margin |
|---|---|---|---|
| Cardiology | 8 | $5,840K | 39.8% |
| Orthopedics | 6 | $3,920K | 37.5% |
| Neurology | 4 | $2,840K | 35.2% |
| Oncology | 5 | $3,420K | 33.1% |
| Internal Med | 10 | $4,680K | 27.4% |
| Others | 15 | $5,500K | 28.2% |
| Department | Budget | Actual | Variance $ | Var % | Driver |
|---|---|---|---|---|---|
| Sales | $22,000 | $23,400 | +$1,400 | +6.4% | New deals beat plan |
| Marketing | $8,400 | $8,800 | +$400 | +4.8% | Campaign overperformance |
| Operations | $10,200 | $10,000 | -$200 | -2.0% | Capacity constraint |
| Services | $5,900 | $6,000 | +$100 | +1.7% | In line |
| Total | $46,500 | $48,200 | +$1,700 | +3.7% |
| Driver | Base | Optimistic | Conservative | Sensitivity |
|---|---|---|---|---|
| Patient Volume Growth | +8% | +12% | +4% | High |
| Avg Revenue / Patient | $2,450 | $2,600 | $2,300 | Medium |
| Payer Mix (Private %) | 62% | 68% | 58% | High |
| Collection Rate | 94.3% | 96.0% | 92.0% | Medium |
| New Services Launch | Q3 | Q2 | Q4 | Low |
Core competencies across financial planning, analysis, and business intelligence.
Budgeting, forecasting & variance analysis
P&L, BS, and CF integration
Price/Volume/Mix decomposition
CCC, DSO/DPO/DIO optimization
Contribution margin & physician profit
Budget vs actual & root-cause analysis
Power Query, dynamic models, VBA
DAX, data modeling & reporting
Alexandria University — English Section, 2023
Certified Management Accountant — In Progress
Financial Modeling & Valuation — CFI, In Progress