CRE Debt Rescue, Lease CAM/NNN & Hospitality Margin Suite — API & MCP Calculators
Deterministic pure-Python & NumPy statutory and financial calculation engines calibrated across all 57 US jurisdictions.
| Code | Engine Reference | Governing Authorities | Calculation Scope |
|---|---|---|---|
BI-16 | Restaurant Tipped-Wage Make-Up, Service-Charge Overtime & Form 8846 FICA Tip Credit Schedule FLSA 29 U.S.C. 203(m) Tip-Pool vs. 29 CFR 531.55 Service-Charge Payroll & IRS Form 8846 (IRC Sec. 45B) Filing | D.C. Official Code § 32-1003(f) (Tipped Wage Phase-In to 100% of Base Minimum Wage by July 1, 2027); 29 U.S.C. § 203(m) / 29 CFR Part 531 (FLSA Tip Pool vs. Service Charge); D.C. OAG statutory Fee Disclosure Guidance; Uniform System of Accounts for Restaurants (USAR 12th Ed.) IRS Form 8846 (IRC Sec. 45B) / FLSA 29 CFR 531.55 / USAR 12th Ed. Prime Cost | Evaluates FLSA Sec. 203(m) & State Tipped Cash-Wage Make-Up & Regular-Rate Overtime Rule; 29 CFR Sec. 531.55 Automatic Service-Charge Overtime & Tax Contamination Test; IRS Form 8846 / IRC Sec. 45B Employer FICA Tip Tax Credit (7.65% Above $5.15 Peg); USAR 12th Edition Prime Cost Ratio Benchmark (<= 65.0% of Gross Sales). Submit: Tipped Regular Hours, Tipped Overtime Hours, Statutory Full Min Wage Hr, Cash Tipped Base Wage Hr. Excel Tabs: Exec Prime Cost Dashboard, DC 32 1003 Wage Step Up, FLSA 203m Service Fee, Kasavana Smith Menu Matrix. |
BI-17 | Commercial Lease CAM / Triple-Net (NNN) Overcharge Audit & ASC 842 Lease Schedule FASB ASC 842 ROU Asset & Lease Liability Amortization, BOMA Z65.1 Load Factor & CAM Cap Audit Workpaper | FASB ASC 842 (Leases); BOMA Z65.1 / Z65.5 (Office & Retail Area Measurement Standards); D.C. Official Code § 47-825.01a (Real Property Tax Pass-Through Verification) FASB ASC 842 Lease Amortization Schedule / BOMA Z65.1 CAM Reconciliation | Evaluates FASB ASC 842-20 Lease Liability, ROU Asset & Straight-Line Expense Schedule; ANSI/BOMA Z65.1 Usable-to-Rentable Load Factor Cap & Pro-Rata Share Audit; 95% Occupancy Gross-Up Isolation (Excluding Fixed Real-Estate Taxes & Insurance); Controllable CAM Cap & Structural Capital-Expenditure Disallowance Claim. Submit: Remaining Lease Years, Annual Fixed Rent (USD), Annual Rent Escalation (%), Incremental Borrowing Rate. Excel Tabs: CAM Audit Exec Summary, BOMA Z65 Load Factor Test, Gross Up And Cap Waterfall, ASC842 ROU Amortization. |
BI-18 | Hotel USALI 12th Ed. Operating Statement, Net RevPAR / GOPPAR & Mortgage Debt-Yield Schedule USALI 12th Revised Edition Departmental Schedules 1-14, FF&E Reserve & Hospitality Debt-Yield Covenant Filing | Uniform System of Accounts for the Lodging Industry (USALI 12th Revised Edition — effective Jan 1, 2026); STR Benchmarking Standards USALI 12th Revised Edition Summary Operating Statement (Schedules 1-14) | Evaluates USALI 12th Ed. Schedule 1 Rooms RevPAR, Net RevPAR & Departmental Margin; USALI Schedule 2 Food & Beverage Margin & Banquet Admin-Fee Flow-Through; Undistributed Operating Expenses, Gross Operating Profit (GOPPAR) & Management Fees; 4.0% FF&E Reserve, Stabilized EBITDAre & CMBS Debt-Yield / DSCR Covenant Gate. Submit: Hotel Keys, Operating Days, Occupancy (%), Adr (USD). Excel Tabs: Summary Operating Statement, Schedule 1 Rooms, Schedule 2 Food And Beverage, Schedule 3 Other Operated Depts. |
BI-19 | Commercial Real Estate (CRE) Loan Sizing (DSCR / LTV / Debt Yield) & Maturity Refi Gap Workpaper CREFC IRP OSAR Stabilized NOI/NCF Underwriting, Triple-Constraint Debt Sizing & Refinance Rescue Schedule | CREFC Investor Reporting Package (IRP) Standards; OCC CRE Lending Interagency Guidance on Prudent CRE Loan Accommodations; AICPA CS Section 100 Non-USPAP Direct Income Capitalization Financial Underwriting CREFC Investor Reporting Package (IRP) OSAR & Rent-Roll Underwriting Schedule | Evaluates CREFC IRP v8.0+ OSAR Stabilized NOI & Verified NCF Waterfall; Triple-Constraint Senior Mortgage Sizing (LTV, DSCR & Debt-Yield Gate); Rent-Weighted WALT, 24-Month Rollover Exposure & Upfront TI/LC Escrow; Maturing Note Refinance Rescue Gap & OCC Current-Pay Blended DSCR Test. Submit: Gross Potential Revenue (USD), Vacancy Concession Loss (USD), Crefc Operating Expenses (USD), Annual Ti Lc Reserve (USD). Excel Tabs: CREFC OSAR Operating Statement, CREFC Commercial Rent Roll, WALT Rollover And TI LC Schedule, Debt Yield And DSCR Sizing Matrix. |
BI-20 | Franchise FDD Item 19 Unit-Economics Substantiation & ASC 606 Initial Fee Recognition Schedule FTC 16 CFR Part 436.5(s) FDD Item 19 Attainment Proof, Four-Wall EBITDA & ASC 606 Franchise Fee Workpaper | 16 CFR Part 436 (FTC Franchise Rule — Item 7 & Item 19 Financial Performance Representations); FASB ASC 606-10-55-65 (Sales-Based Royalties); Spatial Huff Gravity Model FTC 16 CFR Part 436 (FDD Items 7 & 19) / FASB ASC 606-10-55 Schedule | Evaluates 16 CFR Sec. 436.5(s) FDD Item 19 Mean, Median & Attainment Substantiation; Store-Level Four-Wall EBITDA & ASC 606-10-55-65 Sales-Based Royalty Reconciliation; FASB ASC 606-10-55 Pre-Opening Distinct Services SSP vs. License Deferral; 16 CFR Sec. 436.5(h),(l) Item 8/12 Credits & Franchisee Debt Coverage Gate. Submit: Fdd Item19 Claimed Mean (USD), Non Revenue Royalty Exclusions (USD), Contractual Royalty (%), Contractual Ad Fund (%). Excel Tabs: Exec Franchise Dashboard, FDD Item19 Substantiation, Four Wall Unit Economics, Huff Gravity Cannibalization. |