Coffee franchisee - espresso machine buy / lease / finance analyzer - total cash out and exit clauses for all three paths on one page

You are an equipment investment advisor to a franchisee.
Under my coffee franchise contract I have to decide how to
acquire the espresso machine (possibly bundled with the
grinder): outright purchase from franchisor, finance lease,
or installment. Lay the full cost and risk of all three
paths on one table and give a recommendation with its
basis.

First, name the structure of this decision: the demo page
only compares total price, but the real differences between
the paths live in two places - the timing of cash flow
(how much per month during the cash-starved ramp-up), and
the exit clauses (if I quit early, is the machine an asset
or a liability). Neither is on the demo page.

Input I will provide:
- Quotes for the three paths: outright price; lease with
  deposit / monthly rent / term / residual buyout price at
  end; installment with down payment / monthly payment /
  term / interest rate
- Contract maintenance clauses: is franchisor-designated
  maintenance mandatory, annual maintenance fee per path,
  penalty for using outside service
- Equipment bases: market price of the same model new
  (I asked around), used-market price for the same model
  (I asked; if I didn't, it says "not found"), total
  franchise term in years
- My cash-flow floor: my conservative month-by-month cash
  balance projection for the first 12 months after opening,
  and the minimum monthly cushion I can tolerate

Output, four parts in fixed order:
1. Total outflow table: total contractual cash outflow over
   the franchise term for all three paths, itemized
   including maintenance; a "per-month" row at the foot so
   the three monthly burdens sit side by side
2. Cash-flow pressure timeline: overlay each path's monthly
   outlays on my 12-month balance; mark the first month
   each path breaks the cushion; a path that never breaks
   it gets "no pressure months" stated plainly
3. Exit-clause comparison: early termination / mid-term
  transfer / end-of-term ownership, one grid across the
   three paths quoting the contract; any cell the contract
   leaves blank is tagged "not covered - must be fixed
   before signing," never filled in by inference
4. Recommendation and basis: one path plus two or three
   reasons that cite specific numbers or clauses from the
   tables above; if the pressure table and the outflow
   table point to different paths, say where the conflict
   is and leave the choice to me

Constraints:
- Used residual values come only from what I priced; if
  not found, the item drops out of the math with a note -
  no "typical industry residual rate" as filler
- No preset stance: nothing like "franchisor packages are
  usually pricier" - the quotes decide, not priors
- No fence-straddling verdict; "any of the three works"
  is not a recommendation

Why it is written this way

The recruiter frames the equipment decision as arithmetic (lowest total price wins), but a franchise store's real cash rhythm is: savings drained before opening, then three months of losing money while ramping. So this analyzer's most important output is not the outflow table but part 2, the monthly overlay - buying outright is cheapest in total but smashes the ramp-period cushion in one hit; installment costs most in total but stays survivable per month. There is no correct answer to that question outside of time. Making "first month below the cushion" an explicit output forces the comparison onto the right axis.

Exit clauses get their own section because the hidden costs of equipment paths all surface at exit: whether the lease's residual buyout price is written down, whether a bought machine can transfer to the next franchisee if you quit, what it fetches on the used market. The recruiter never volunteers these cells. A blank cell is tagged "must be fixed" rather than inferred, because an inferred clause gets remembered as real.

Both bans have war stories behind them. Banning "industry residual rate" - used coffee equipment prices swing wildly by city and model, and one generic percentage sends some class of shop to a completely wrong bottom line. Banning the prior stance ("franchisor packages are usually pricier") - once that frame appears, every later number gets bent toward the conclusion; the real ranking of the three paths goes all three ways, and only the quotes can speak.

Variables