1.Break-Even and Sensitivity Analysis for Lease Negotiation
horizontal bar and combo chart · 2026
A prospective restaurant owner used this dashboard to evaluate financial viability before signing a commercial lease. The top section visualizes core cost structure ratios as a percentage of sales, highlighting Labor (25.0%), Food & Beverage (14.7%), and Occupancy (7.4%). A combo chart models break-even sales under stress scenarios against a $78.5K base requirement. The analysis reveals that a 3% increase in rent drives break-even sales up by $13.6K to $92,078. By visualizing these specific sensitivities, the user identified fixed rent as the dominant risk factor, establishing a defensible floor for lease negotiations.
What it shows:
Stress-testing fixed costs against sales baselines provides concrete leverage for commercial lease negotiations.




