Vintage Analysis Calculator
Track deal performance by funding cohort to identify trends in underwriting quality over time.
What Is Vintage Analysis?
Vintage analysis groups deals by the month they were funded and tracks each group's performance independently. This reveals whether your underwriting quality is improving, stable, or deteriorating over time. Aggregate portfolio metrics can mask vintage-specific problems -- a portfolio with 90% overall collection rate may have January deals collecting at 95% and July deals at only 82%. Without vintage analysis, you would not know that recent deals are performing worse. In MCA, vintage analysis is the standard analytical framework used by institutional investors, syndicators, and sophisticated ISOs to evaluate portfolio health. It answers the critical question: is the book getting better or worse?
How to Use This Calculator
Enter cohort data for 3 funding months
Select representative months and enter the number of deals and collection percentage for each. Use completed or near-completed cohorts for the most meaningful comparison.
Compare across vintages
The calculator identifies the best and worst performing vintage and determines whether the trend is improving, stable, or deteriorating.
Investigate deteriorating vintages
If recent vintages are performing worse, drill down: did you change funder relationships? Start accepting lower-quality merchants? Increase stacking? The vintage trend points to the timeframe; you need to identify the cause.
Key Concepts
Vintage
A cohort of deals funded in the same month. Each vintage is tracked independently to isolate time-period-specific performance from the overall portfolio.
Vintage Curve
A chart showing collection rates for each vintage over time. Healthy vintages show rising collection rates that plateau near 90-95%. Unhealthy vintages show flat or declining collection rates.
Vintage Deterioration
When more recent vintages perform worse than older vintages. This is the most important early warning signal in portfolio management -- it means something changed in deal quality.
Expert Insights
Monthly Vintage Tracking Is Non-Negotiable: If you fund from your own capital or participate in syndication, monthly vintage tracking is the most important analytical practice you can implement. It takes 30 minutes per month to update and can save you from a portfolio blow-up that costs hundreds of thousands. The pattern: vintage deterioration goes unnoticed for 3-4 months, then defaults spike, then it is too late to prevent. Monthly tracking gives you the 3-4 month warning window to tighten underwriting.
Compare Vintages to Market Conditions: Vintage performance is affected by both your underwriting quality AND market conditions. If all vintages funded during a particular quarter underperform, it may reflect market-wide stress rather than your specific underwriting. Compare your vintage performance to industry benchmarks and other portfolios (if accessible) to distinguish between your-specific and market-wide effects.
Frequently Asked Questions
Results are estimates for educational purposes only. Actual amounts may vary based on your specific financial situation, market conditions, and other factors. This calculator does not constitute financial advice.
Run These Numbers Too
Portfolio Performance Dashboard
Track key portfolio metrics: collection rate, default rate, ROI, and deal composition.
Collection Efficiency Calculator
Measure how effectively your portfolio is collecting against expected repayment schedules.
Default Rate Impact Calculator
Model how merchant default rates affect portfolio yield, losses, and net returns.
Need Help With Business Debt?
Speak with a Delancey Street specialist — free consultation, no obligation.
Get Free ConsultationEconomic Snapshot
Source: Federal Reserve Economic Data (FRED). Indicators refresh daily.
Financial News & Regulation
Apr 24, 2026Holding Government Contractors Accountable for Wrongdoing
Jan 21, 2025Argus Information and Advisory Services, a subsidiary of TransUnion, has agreed in writing that it will not seek any government contract with the Consumer Financial Protection Bureau for three years.
Blog | Consumer Financial Protection BureauStrengthening Appraisal Oversight: Progress at the Appraisal Subcommittee
Jan 17, 2025CFPB Deputy Director Zixta Martinez discusses changes at the ASC since she became Chair in 2022, including enhanced state oversight, landmark hearings on appraisal bias, and improved collaboration with The Appraisal Foundation to create a more equitable and accountable appraisal industry.
Blog | Consumer Financial Protection BureauBack from the Dead: Zombie Second Mortgages
Jan 17, 2025Forgotten second mortgages may be coming back to haunt homeowners who haven’t received notices or account statements for years.
Blog | Consumer Financial Protection BureauHeadlines sourced from government agencies and legal publications. Updated every 12 hours.
Did You Know?
BNPL (Buy Now, Pay Later) usage tripled between 2020 and 2025, with over 40% of U.S. consumers having used it.
Cost of living varies dramatically: the same salary goes 30-50% further in states like Texas or Tennessee vs. California or New York.
The average 401(k) balance hit $118,600 in 2025, though the median is much lower at $35,286.
Roughly 40% of small businesses fail within the first 5 years, with cash flow problems being the #1 cause.