# Start here: companion files of The Parking Lot Owner (Julian R. Sterling)

Nine Excel files, each with three tabs: Inputs (blue cells, type your own values), Calc (formulas only) and Checks (each line reads 0 when the check passes; Checks!B2 adds them up).

- `Parking_1_Lot_Month.xlsx`: Workbook 1: One Lot's Month. From permits, tickets and event nights to gross and net parking revenue, payment fees and net after payment fees, and from the hours parked to occupancy, turnover and revenue per space per day of one lot. Filled with lot A in October 2025.
- `Parking_2_Monthly_Permits.xlsx`: Workbook 2: Monthly Permits and Oversell. From the spaces held for monthly parkers and their presence to the most permits the lot can carry without refusing a parker, the oversell ratio, the spare held spaces and the permit revenue. Filled with lot A in October 2025.
- `Parking_3_Revenue_NOI_Break_Even.xlsx`: Workbook 3: Lot Revenue, NOI and Break-Even. From spaces, permits, tickets, events, parking tax, payment fees, attendants, maintenance, taxes, insurance, reserve and the operating mode to gross and net parking revenue, NOI, revenue per space per day, occupancy, the break-even in revenue per space per day and in occupancy, the debt-service break-even and an indicative value. Filled with the first lot of 50 spaces bought with a loan, a scenario.
- `Parking_4_Attendants_Workweek.xlsx`: Workbook 4: An Attendants' Workweek. From the days and shifts of a workweek to each attendant's hours worked, overtime above 40 hours in that workweek, wages, payroll taxes and pay per hour worked against the federal minimum. Filled with the workweek of Sunday 28 September 2025 to Saturday 4 October 2025.
- `Parking_5_Operating_Modes.xlsx`: Workbook 5: Operate, Sign a Management Agreement or Lease to an Operator. Lot A's year read three ways on the same base, the year's net parking revenue: the owner operates, an operator manages for a fixed fee and an incentive, or an operator leases the lot for a base rent and a percentage rent. Filled with lot A in FY2026 with the December forecast.
- `Parking_6_Lot_C_and_Loan.xlsx`: Workbook 6: Lot C, Its Price and Its Loan. From the price, the loan share, the rate and the amortization to the payment, the first eight payments and the balance, and from lot C's NOI run rate to debt service coverage, NOI after debt service and the cash return on the cash put in. Filled with lot C, bought on 1 June 2026, loan disbursed in June 2026, first payment in July 2026.
- `Parking_7_Value.xlsx`: Workbook 7: What Each Lot Is Worth, and an Offer. Lots A and C at their NOI over a cap rate, lot B at a multiple of its SDE, each on its own base and counted once; the land offer read against lot A's value and never added to it; an offer's price taken line by line to cash at closing. Filled with the owner's reading in November 2026 and the operator's offer for the three lots, a scenario.
- `Parking_8_Accessible_Spaces.xlsx`: Workbook 8: Accessible Spaces. From the total spaces of one parking facility to the accessible and van spaces Table 208.2 and 208.2.4 require, and the spaces missing. Filled with lot C as the seller's register stood at closing.
- `Parking_Lot_Calculator.xlsx`: Parking Lot Revenue, NOI and Break-Even Calculator, the free calculator, filled with example values that are not the case of the book.

The values typed in the files are the book's fictional case and scenarios: teaching assumptions, not market figures. Change one input at a time and read the result again. Rely on nothing while Checks!B2 is above zero.
