I am opening (or running) an independent title and escrow office. I have attached the Title and Escrow Business Plan and Operations Starter Kit from businessconsultant.services. Help me turn it into my own plan for my files, closed volume and referral shares, using my numbers only. Follow these rules for the whole conversation: 1. Use only numbers I give you, or numbers you calculate from mine with the formulas below. Never invent a premium, a fee, a referral share, a file count, percentage or benchmark, and never state a rule about funds handling or referral agreements. 2. The numbers printed in the kit are worked examples. Never use them as my numbers, not even as a placeholder. 3. If a number you need is missing, ask me for it. If I ask you to estimate or use typical figures, write [NEED: ...] instead and tell me which quote, record or calculation will give me the real number. If I give you my own estimate, label it MY ESTIMATE. 4. Use these formulas exactly, and show your arithmetic for every number you calculate: - Monthly sales for a sales line = files times the title premium per file times days open in the month (use 1 where I count files per month, and files per day times the days the office is open where I count them per day), and fees = files times the closing fee on the same basis. Each month's expected sales = full-run premium and fees times ramp times season; a file that closes replaces its ramped figure that month, never both; before opening, count expected files by month, each marked MY ESTIMATE until confirmed. - Net sales exclude sales tax. Labor = wages, payroll taxes and benefits, plus a market wage for the owner's management time (line 4); the owner's own file and closing work sits in line 4 with the management wage, and line 14 is only overflow support labor above the salaried team. The owner's wage counts as cash even if it is not drawn, so the plan still holds when the owner steps back from the work; only line 4 may go undrawn, and the cash break-even and Test 6 still count it while your cash forecast and the floor test use the money you actually pay. - Contribution margin ratio = 1 minus variable cost share; a line's contribution = its sales times its own ratio. Operating break-even sales = fixed costs divided by contribution margin ratio. Cash break-even sales = (fixed costs with line 4 even if I do not draw it, plus monthly loan principal and any recurring other cash out) divided by contribution margin ratio; only the cash forecast drops an undrawn wage. A blended ratio holds only at its own sales mix: name that mix beside each break-even, and recompute from each line's own contribution when a what-if changes one line. Loan interest is fixed; principal is not an operating cost, so it never enters operating break-even or operating profit. - Weekly = monthly times 12, divided by 52. Daily = weekly divided by days open per week. - Break-even closed files = (fixed costs, principal and other recurring cash out minus the direct file and closing fee contribution, with each line counted at its own contribution ratio) divided by one referral file's net contribution. If the other lines already cover fixed costs and principal, report 0 and say so; never report a negative break-even count. Files the office can settle in a month = paid staff hours a week times 52 divided by 12, times your productive share, divided by your hours a closed file; planned files a month = the files the referral sources and direct relationships produce. - Office share = line 1 divided by net sales. Planning debt service coverage, before income tax and equipment replacement = (full-run sales times contribution margin ratio, minus fixed costs other than loan interest) divided by (loan interest + loan principal). - Month-12 run rate = average monthly sales over a year at month 12's ramp and closed files, seasons applied (not month 12's own sales). Test 1 needs that rate at or above cash break-even and my floor held 24 months; Test 3, coverage at full run and at that rate. - Test 6 = 12 months of (full-run sales minus their variable costs, minus full-run fixed costs, line 4 included, minus principal), seasons applied to every sales line, the closing fee following the referral-file counts that create it, and seasonal fixed lines at each month's amount. The cushion to set aside = the largest fall in running net cash from a high to any later low, the year run twice so a dip can cross into month 1 (zero if it never falls). - Full-run figures (break-even, coverage, floor) take a late-starting fixed line at its full amount, and a seasonal fixed line at its year average. - For pages 7 and 9, use the formulas printed on those pages of the attached kit, exactly as written, with my own figures. - Cash forecast: closing cash = opening cash + cash in minus cash out. Month 1 opening cash = cash on hand the first day the office opens, after startup spending. Place every receipt and payment (deposits, supplier invoices, startup bills, funding) in the month the cash moves. Income tax set-aside, equipment replacement and one-off cash out go in their own row. Open month 1 with the cash I give. Enter the premium and the closing fee in the month the file closes and funds, pay the referral share on that same schedule, and pay the escrow team, rent and fees in the month. An opened order is not income until the file closes and funds. In the slow-start case, every month's sales, files closed included, are the tested share of expected sales; fixed costs, other cash out, principal, bills and funding stay as planned; all variable lines fall with sales, each figured from that month's slow-start sales, on the same payment timing as the expected case (line 14 holds only hours I would cut). Runway = the number of future months, from the latest closed month (before opening, from the first day the office opens), before closing cash falls below my cash floor. 5. Do not give legal, tax, permit, disclosure, funds handling, employment, wage or lease advice. Do not name laws, permit types, government bodies, government fees or wage rates for title and escrow work, even as examples. When my question touches these, write only "Review this with a qualified professional" and continue with the rest. You may record and use figures I give from my own records, such as my sales tax rate and when I remit it, without checking, interpreting or advising on them. 6. Do not quote statistics, studies or sources that are not in the kit. For the market and marketing sections, use only what I tell you, and list the local facts I should gather. 7. Work every total step by step and recheck it a second way. In the cash forecast, show the arithmetic for month 1, one later month and the year total; give plain numbers for the other months. 8. If a formula would divide by zero or a contribution margin is zero or below, write N/A, say why, and do not continue that calculation. If my lender defines coverage differently, show both results and label each. If cash never falls below my floor in the forecast, write the runway as more than 24 months; otherwise give the runway in months and, separately, the first month below it, counting year 2. With no loan, Test 3 passes. 9. Use business figures only, with anonymous client IDs. Do not ask for names, property addresses, loan numbers, closing statements, or bank account or tax ID numbers. 10. Mark every output: Draft for my own planning. Not for a lender or investor until a qualified accountant has reviewed it. 11. If your full answer would be very long, deliver outputs 1 to 4 first, then stop and ask me to type "continue" for the rest. 12. Build the cash forecast month by month from the sales build, the cost lines, my payment terms and my opening cash; it does not need the inputs for pages 7 and 9. Each month: cash in = sales receipts plus money arriving; cash out = each variable cost, calculated from the sales that created it and placed in the month it is paid under my terms, plus fixed costs (lines 1 to 12, with line 4 only if I draw it in cash), plus loan principal, startup bills and other cash out. Loan interest is already in line 5; never add it again. Vendor and platform payments follow the cost of the service I delivered, plus any vendor deposit or prepayment I give; the working capital reserve on page 5 is opening cash and never a cash-out line. If a vendor invoice falls outside my terms, ask me for payments by month instead. If you can run code, do every calculation in code. Step 1. Before you write anything else, ask me for the inputs below in three rounds, one message per round. Ask round A as one numbered list, then wait for my answers. When I answer, ask round B and wait; then round C and wait. Start Step 2 only after I answer round C. Round A, sales, capacity and evidence: a. Services and property types, the counties and price bands you work, the files you close a month, the hours a closed file takes, the paid staff hours a week, and the referral sources behind the files. b. Sales build: for referral files, the files a month, the average property price, the title premium as a market percentage of price and the share paid to the referring office; for direct files, the files the owner brings a month; the closing fee per file; a ramp percentage of full-run volume for every month from 1 to 12 (ask me to confirm any month I leave out); a seasonal percentage for each month from files closed and orders opened by month in my market; and the slow-start percentage I want to test (this kit sets a 70 percent stress test, a kit rule rather than my estimate; use it, and show any different percentage beside it as a second case). Give counts at full run, with month 1 as my opening month. Give the evidence behind each count (site counts, comparables, signed orders or my history). c. For the premium page (property price, premium percentage, referral share, closing fee and file counts are in b above): any other per-file cost in my referral arrangement, pass-through costs per file, and my historic close rate on opened orders. Then wait for my answers. Round B, costs, the startup budget and my lender: d. Startup budget: an amount and its source (vendor quote, insurance quote, landlord quote or calculation) for each line on page 5, from computers to the working capital reserve and contingency. e. Monthly fixed costs for lines 1 to 12 on page 8, including the escrow team, title production and title plant fees, loan interest and my market wage; whether I draw that wage in cash; and my monthly loan principal. Give interest and principal as year 1 monthly averages for break-even and coverage, and, for the cash forecast, any payment, fixed line or other cash line that changes in months 1 to 24 (a payment holiday, a balloon payment, a rent step) with its month. My market wage covers management time (line 4); my own file and closing work sits in line 4 with the management wage, and line 14 is only overflow support labor above the salaried team. f. Variable cost shares of net sales for lines 13 to 17: line 13, per-file reports and fees passed through (title reports, copy fees, postage); line 14, variable support labor above the salaried team (overflow file work and closing help); line 15, payment and platform fees; line 16, referral partner entertainment and closing gifts; line 17, referral share on referral files (blended share of all sales); and any sales line whose own shares differ, given for that line. g. For each referral source: conversations, confirmed orders and closed files last quarter, and days from the first conversation to the confirmed order; orders opened at the start of the quarter and orders that fell over; the number of new files I need. h. The debt service coverage ratio my lender requires and how the lender calculates it, if I know them. Then wait for my answers. Round C, cash timing, sales tax, deposits and Gate 0: i. Payment terms: when the premium and the closing fee reach the office (the month the file closes and funds, or later), when the referral share is paid out, and when the escrow team, rent and fees are paid. j. For every other cash line (payroll, card settlements, insurance, loan payments, rent and fixed bills), when it is paid, or confirm it is paid in the month it is incurred. k. Monthly cash out beyond operating costs: income tax set-aside, equipment replacement and any recruiting bonus or draw. l. Cash on hand on the first working day after all startup spending, startup bills still to pay by month, owner money or loans still to arrive by month, and my minimum cash floor. m. If I am already open: what customers owe me and what I owe suppliers and staff, each by the month it will be paid, deposits I already hold, and sales tax already owed with its payment month. n. Sales tax: the rate I collect on taxable sales, from the sales-tax number the office holds, which sales lines (or what share of each) are taxable, and when I remit what I collect (each month, each quarter or another schedule), so the forecast holds collected tax apart until it is paid. o. Gate 0: which agreements, quotes and approval requirements I already have in writing. Then wait for my answers. Step 2. When I answer, produce these as plain tables I can copy back into the kit: 1. Business plan sections 1 to 8 for my office, drafted from my answers, with gaps marked [NEED: ...]. 2. The sales build by referral files, direct files, closing fees and month, with annual sales and the capacity check from page 6. 3. The completed startup budget, line by line as on page 5, with the total. Size the reserve by the page 5 rule; if I gave another, show both and the result for each. 4. Operating and cash break-even per month, per week and per day open; break-even closed files a month (use cash break-even); office share and planning debt service coverage at full-run sales, labeled before income tax and equipment replacement, and on my lender's definition too if I gave it. 5. The 12-month cash forecast for the expected and slow-start cases, in thousands of dollars to two decimals (51.25 means $51,250) to match the kit, with, for each case, the first month below my cash floor and the first month below zero, and the runway; the second year's lowest closing cash (month 12's ramp and closed files held, each month with its own season, not a flat average); any extra reserve the slow start needs; and the Test 6 cushion, with whether the page 5 buffer covers it (add any excess to the reserve). Add memo rows for each month, kept out of closing cash: sales tax collected, remitted and owed at month end (last month's owed + collected minus remitted), and receivables (last month's + billed minus collected). 6. Premium kept per file and per month by referral source, with the fall-through exposure on opened orders. 7. Closed files by referral source with conversations needed and the fall-through rate. 8. The kit's page 4 check: Gate 0 and pass or fail for each of the six tests with the reason (if Gate 0 fails, the result is not ready), and the overall result: not ready if Gate 0 fails, with no color; otherwise green, amber or red under the page 4 rules. 9. A final checklist: every MY ESTIMATE figure, every [NEED: ...] gap, every file count, referral share or payment term I should verify, and every question that needs a qualified professional.