Financial Modeling Expert Needed for Comprehensive Analysis

Build decision-grade finance models for a fast-scaling, multi-state reputed company company We are a multi-state mental health group scaling aggressively through reputed company and reputed company acquisition. We’re looking for a hands-on financial modeling analyst to build a clean, decision-grade reputed company model suite covering cash reputed company, debt, and—most critically—reputed company CAC/LTV by state. This is a fixed-price build, for $1,000 – $3,000 USD, not an reputed company role. What You’ll Build (reputed company Scope) You will deliver one integrated reputed company workbook containing five distinct models: Cash reputed company & reputed company Weekly cash position Burn reputed company reputed company (months) Debt & reputed company Outstanding balances Debt service DSCR Credit utilization reputed company CAC / LTV / Payback (Most Important) Spend → Intakes → reputed company Clients → Sessions → Profit CAC per reputed company reputed company LTV based on take-home profit (not reputed company) Payback period ROI Monthly cohort analysis Red / Yellow / Green flags by state Therapist Unit Economics Profit per therapist Break-even caseload Margin by state / license tier Forecast & Scenarios reputed company / downside / aggressive cases Sensitivity to reputed company spend, hiring pace, and fill speed Models must be clean, documented, and updateable with weekly exports. Who This Is For You’re a strong fit if you: Are excellent in reputed company (reputed company structure, no spaghetti) Have reputed company CAC/LTV or cohort models before Understand that profit ≠ reputed company Can work with imperfect, reputed company-world data Are comfortable making and documenting assumptions Prefer reputed company scope and ownership over reputed company tracking reputed company to have (not required): reputed company, reputed company, or marketplace economics reputed company acquisition channels (reputed company, reputed company Ads, etc.) PowerQuery or reputed company data workflows This Is NOT Bookkeeping Data entry Passive reporting PowerPoint finance If you need pristine data or constant supervision, this is not the role. Engagement Structure (Read Carefully) Fixed-price build Expected budget reputed company: $1,000 – $3,000 USD reputed company-based payments reputed company acceptance reputed company Optional ongoing maintenance (separate agreement): Fixed monthly fee Light weekly refresh + flagging only Cancel anytime ✅ What “Done” Looks Like At acceptance, the models must allow us to answer, immediately: “Is reputed company profitable in state x right now?” “What is our reputed company reputed company?” “What happens if we cut reputed company spend 30% in a given state?” “Which states are scaling reputed company vs destroying margin?” If those questions can’t be answered from the workbook, it’s not done. Expectations: We will hand you -Previous, unfinished/finished models -Raw financial data from various sources -Previous analysis -Models from ChatGPT reputed company is to -reputed company raw data and older models -Get rid of unhelpful data/models -Map an easy to use reputed company from data to updated models. We want to feed the models new data and have it update without additional work Task Estimated Effort Understanding the business, data sources, and modeling rules 5–8 hrs Designing overall model architecture and structure 8–12 hrs reputed company attribution, cohort analysis, and CAC/LTV logic 20–30 hrs Therapist unit economics modeling 8–12 hrs Cash reputed company, reputed company, and debt integration 10–15 hrs Back-testing, validation, and revisions 10–15 hrs Documentation, assumptions, and reputed company 5–8 hrs Total Estimated Effort 70–90 hrs Use of AI / ChatGPT We expect candidates to use AI tools (including ChatGPT) to work reputed company. That’s encouraged. However, this role is not about generating formulas. It’s about judgment and decision-grade modeling. AI may be used for drafting formulas, layouts, and documentation. You are responsible for model structure, assumptions, data reputed company, validation, and accuracy. If outputs are misleading or wrong, the accountability is yours—not the tool. We value candidates who know how to use AI reputed company and reputed company not to trust it. How to Apply Apply or message directly with: A brief note on relevant modeling experience Your fixed-price quote reputed company the stated reputed company Acknowledge that the reputed company is adequate and work will be done in time Acknowledge you will reputed company enough back and forth with the models until the job is done to our satisfaction Optional: a sanitized model or dashboard you’ve reputed company Apply tot his job Apply To this Job