The Physician Recruitment Pro Forma Template will open directly to the Assumptions tab with realistic placeholder values for a family medicine practice. This way you (or a team member) can see how the model works from beginning to end before customizing it for your organization. 

What's inside — Eight connected tabs 

Key design choices 

• Yellow = input; gray = calculated — color-coded throughout so team members know what's safe to edit 
• Fully formula-driven — change any assumption (e.g., bump Year 1 ramp from 50% → 60%) and every downstream tab, the wRVU bonus calculation, the NPV, and the decision indicator all update automatically 
• wRVU bonus uses MAX(0, …) — so it never goes negative when production is under threshold 
• Breakeven formula — does linear interpolation between annual cumulative cash flows so you get a precise month estimate (e.g., "16.4 months") rather than just "Year 2" 
• Decision indicator — a large conditionally-formatted banner that flips green / amber / red based on net margin and breakeven; direct visual link back to Gate 3 of the recruitment decision tree 
• Subsidy tab — pulls Year 1 collections from the Revenue tab automatically and shows remaining loan balance at 12 / 18 / 24-month exit points (critical for Stark-compliant recruitment agreements) 
• Decision Log Gate 3 — auto-populates "Pass" or "Review" by reading the ROI Summary decision text — so the financial gate is tied directly to the model output