The Investor Model vs. the Lender Model
SaaS founders building for VC fundraising optimize their financial models for growth narrative: a hockey-stick revenue curve, aggressive TAM capture assumptions, and a burn rate that signals confidence. Lenders who underwrite ARR loans are reading the same spreadsheet through a different lens entirely. They are not asking "how big could this get?" — they are asking "can this company service debt if growth slows by 30%?"
The Intel Hub contains a full library of ARR lending intelligence. This guide specifically addresses the financial documentation that separates applications that advance quickly from applications that stall in underwriting. For context on what lenders are scoring before they ever see your model, see our guide to ARR loan underwriting criteria.
A lender-grade SaaS financial model has seven required schedules. Four of them — the ARR waterfall, customer cohort analysis, DSCR model, and covenant compliance model — are rarely included in investor decks and are the primary source of underwriting delays for McKinney operators.
The AICPA's financial reporting guidance and FASB ASC 606 revenue recognition standards underpin the revenue reporting methodology that institutional lenders expect. McKinney operators whose financial models align with these standards pass underwriting more efficiently than those using non-standard revenue recognition approaches.
What Lenders Are Actually Calculating From Your Model
Before building the model, understand the five calculations the lender's underwriter will perform from your data:
1. Qualifying ARR. The lender extracts your contracted ARR, applies the concentration haircut (removing revenue from customers above 25% of total ARR), and applies a churn discount based on your historical logo retention. This figure drives the advance rate calculation.
2. Debt Service Coverage Ratio (DSCR). DSCR = EBITDA (or operating cash flow) / Annual Debt Service. Most ARR lenders require DSCR above 1.2x–1.5x. This calculation requires your P&L and the proposed debt service schedule.
3. ARR Stability Score. Month-to-month ARR variance, NRR trend, and logo retention trend. These come directly from the ARR waterfall. Lenders score volatility and flag operators whose ARR fluctuates more than 10–15% month-over-month.
4. Covenant Compliance Probability. Using your projected ARR under a downside scenario (typically 20–30% ARR miss), will you maintain compliance with the proposed minimum ARR covenant? This requires your financial model to include scenario analysis.
5. Collateral Recovery Value. In a default scenario, what is the lender's expected recovery from the ARR collateral? This is driven by NRR, churn rate, and logo concentration — all derived from your ARR waterfall and cohort analysis.
Schedule 1 — The ARR Waterfall
The ARR waterfall is the single most important document in your pre-application data room. No other schedule drives more underwriting decisions or creates more delays when missing or incorrectly structured.
Format: Monthly columns, rows for Beginning ARR, New Bookings, Expansion (upsell/cross-sell to existing customers), Churn (customers who cancel), Contraction (customers who downgrade), Ending ARR, Net Revenue Retention (calculated automatically).
Depth: Provide 24 months of historical actuals. Extend with 12–24 months of projections. Projections should be based on documented assumptions — average monthly new bookings from historical data, churn rate from trailing-12-month actuals, expansion rate from cohort analysis.
The waterfall must reconcile to your P&L revenue line. If the waterfall shows $1.05M ending ARR in month 12 and your P&L shows $1.15M in year-1 revenue, the discrepancy will stall underwriting until explained. The difference is usually timing (revenue recognized vs. contracted ARR) — document this explicitly in a reconciliation note. For more on this, review our guide to churn-adjusted ARR.
Schedule 2 — Customer Cohort Analysis
The cohort analysis validates your NRR figure at the customer level. It groups customers by acquisition quarter and tracks the revenue from each cohort over time.
A cohort that generated $100,000 in ARR in Q1 2024 and generates $120,000 in Q1 2026 demonstrates 120% NRR for that vintage — strong collateral quality. A cohort that generated $100,000 in Q1 2024 and generates $70,000 by Q1 2026 demonstrates 70% NRR — severe churn signal that the lender will price heavily.
Lenders use cohort analysis to distinguish between operators whose NRR is driven by expansion in a few large customers (concentration risk) vs. broad-based retention across the customer base (more robust collateral). Build the cohort analysis at the customer level, then roll up to cohort totals. Suppress individual customer names if needed — lenders typically accept anonymized cohort data at the pre-LOI stage.
Schedule 3 — Cash Flow Statement
The cash flow statement — not the income statement — is what lenders use to assess debt service capacity. Operating cash flow, not EBITDA, is the numerator in the DSCR calculation for most ARR lenders.
Provide 24 months of historical monthly cash flow statements. The lender specifically focuses on: operating cash flow trend (is it growing or shrinking?), working capital changes (particularly deferred revenue movements — growing deferred revenue is a positive signal), and capital expenditures (which reduce free cash flow available for debt service).
The SEC's cash flow statement guidance specifies the required presentation for public companies; private SaaS operators should align to the same format to signal financial sophistication to institutional lenders.
Schedule 4 — Debt Service Coverage Model
The DSCR model is the calculation that most founder-built models omit entirely. Build it explicitly: Operating Cash Flow (trailing 12 months) ÷ Annual Debt Service on the proposed facility = DSCR.
Show DSCR under three scenarios: Base Case (your central projection), Upside Case (20% ARR outperformance), Downside Case (20–30% ARR underperformance). The downside case is the one the lender cares most about. A McKinney operator with $1M ARR and $150K in annual debt service who can demonstrate 1.8x DSCR in their base case and 1.2x DSCR in the 30% downside scenario is demonstrating creditworthiness that accelerates approval.
Schedule 5 — Covenant Compliance Model
Map your current financial metrics against the proposed covenant thresholds in the term sheet. Then project forward 24 months and show compliance (or breach) under base case and downside scenarios.
Key covenants to model: Minimum ARR (typically 75–90% of closing ARR), Maximum Monthly Churn Rate (typically 3%), Minimum Cash Balance (typically 3 months of debt service). Show each covenant, the proposed threshold, your current position, your position in the downside scenario, and whether covenant headroom is positive or negative.
If the downside scenario shows a covenant breach, you have two options: negotiate for a lower covenant threshold before signing, or model the cure period process. Either way, identifying this before closing — not at month 9 of the facility — is the value of building this schedule.
Schedule 6 — Use of Proceeds
Lenders want to see that loan proceeds will be deployed into ARR-generating activities. A use of proceeds schedule that allocates 70% to customer acquisition, 20% to sales team expansion, and 10% to product development is far more compelling than one that allocates 40% to "general working capital."
Show the expected ARR return on each use of proceeds. If you're deploying $500K into customer acquisition at a CAC of $15K per customer and expected ACV of $25K, document: new customers expected, ARR generated per dollar deployed, ARR compounding timeline. This is the investment thesis the lender needs to see — not just where the money goes, but what it returns.
Schedule 7 — Three-Year P&L with Revenue Bridge
The standard P&L is required but not sufficient. It must be accompanied by a revenue bridge that reconciles year-over-year revenue growth to its components: new ARR, expansion ARR, churn ARR, and any non-recurring revenue.
Present by revenue line (by product or segment if applicable), with gross margin, OPEX broken out by function (S&M, R&D, G&A), and EBITDA. Include a clear statement of assumptions for each projection year — growth rate, hiring plan, gross margin assumptions, OPEX scaling logic.
5 Model Mistakes That Slow Underwriting
| Mistake | Why It Stalls Underwriting | Fix |
|---|---|---|
| Revenue doesn't reconcile to ARR waterfall | Underwriter must resolve discrepancy before advancing | Build a reconciliation note explaining timing differences |
| Zero churn modeled in projections | Lender assumes model is aspirational, not analytical | Model churn at trailing-12-month rate; show sensitivity |
| No debt service coverage calculation | Underwriter must build DSCR model from scratch | Include explicit DSCR model with 3 scenarios |
| Missing customer cohort analysis | NRR claim cannot be validated at customer level | Build cohort table even if anonymized |
| No downside scenario | Lender constructs worst-case — usually more pessimistic than yours | Include 30% ARR downside with covenant compliance analysis |
McKinney operators who submit a complete 7-schedule lender model at first contact report underwriting timelines 2–3 weeks faster than operators who submit investor-style models and iterate through document requests. The model preparation investment typically pays back in reduced underwriting cost and faster capital deployment.
How to Present the Model to Your Lender
Structure your model workbook with three tabs: (1) Summary Dashboard — key metrics at a glance (current ARR, NRR, DSCR, qualifying ARR, proposed facility size, use of proceeds summary). (2) Historical Actuals — all 7 schedules populated with 24 months of verified actuals. (3) Projections — base, upside, and downside scenarios with documented assumptions.
Accompany the model with a one-page narrative that explains: the business model in two sentences, the purpose of the loan in one sentence, the ARR growth driver in two sentences, and the downside scenario logic in two sentences. Lenders who receive a self-contained package advance underwriting without a preliminary call — saving 1–2 weeks of the typical timeline.
Before submitting, review your term sheet checklist using our post-term sheet checklist, and benchmark your lender options using the SaaS ARR Lender Comparison 2026. For an understanding of what the lender will score from your model, see our MRR loan velocity audit.
Quick Check
See what you qualify for in under 3 minutes.
No personal guarantee required. No hard credit pull. Revenue history is what qualifies you.
Check Capital Eligibility →Institutional FAQ
An ARR waterfall is a schedule showing how ARR changes month-by-month: beginning ARR plus new bookings plus expansion revenue minus churn minus contraction equals ending ARR. Lenders require it to validate your NRR figure, understand churn patterns, and model the qualifying ARR base for advance rate calculations. A well-built ARR waterfall is the single most important document in your pre-application data room.
Most ARR lenders require a minimum trailing-12-month DSCR of 1.2x–1.5x, meaning operating cash flow must cover debt service 1.2–1.5 times over. Companies below 1.2x DSCR typically face restricted advance rates or conditional approval with additional cash reserve requirements. Companies with DSCR above 2.0x access premium terms and covenant flexibility.
Include 24 months of historical actuals minimum — 36 months if available. Lenders use historical data to calculate trailing ARR metrics, churn rates, and revenue stability scores. Less than 12 months makes underwriting impossible; 12–18 months qualifies for fintech ARR platforms; 18–24 months qualifies for regional bank SaaS desks; 24+ months qualifies for institutional private credit facilities.
The most common delay is a revenue projection that doesn't reconcile to the ARR waterfall. If the P&L shows $1.2M in projected revenue but the ARR waterfall shows only $900K ending ARR, the lender's underwriter will flag the discrepancy and pause the process. Revenue projections and ARR waterfalls must use identical assumptions and reconcile at every period end.
Yes — actively include a 20–30% ARR downside scenario in your lender model. This demonstrates that you have modeled the risk the lender is taking and that the business remains viable under stress. Lenders who see a downside scenario with positive DSCR and covenant compliance headroom advance underwriting significantly faster than lenders who must construct the downside themselves.
Ready to check your options?
Rev Boost Funding connects operators with independent financing partners. Not a lender. Affiliate partnerships present.
Disclaimer: Financial figures and estimates on this page are illustrative only. They do not represent guaranteed outcomes. Individual results will vary based on lender, ARR quality, and market conditions.
Check Capital Eligibility →