THE MODEL
The best LBO model your credit team has ever used.
Institutional-grade. Fully standardized. FactSet and CapIQ integrated. Built for the most complex capital structures. Build new deals in a fraction of the time — roll forward in minutes. Every output table updates automatically.
~10%
Time to build vs. a traditional model
Minutes
To roll forward for a new LTM period
6
Projection cases run simultaneously
Live
Factset & CapIQ EV Integration
MODEL OUTPUTS
Every output. Fully automated.
These aren't manually assembled tables. Every output updates automatically when you roll the model forward — no reformatting, no copy-paste, no reconciliation.
1
Historical Financial Table
A fully automated historical financials module covering quarterly and annual periods with LTM calculations. Revenue, EBITDA, FCF, credit statistics, and balance sheet items — all structured identically across every credit in the portfolio.
→ Quarterly actuals + annual fiscal years + LTM in one view
→ Credit statistics auto-calculated every period
→ EBITDA reconciliation and FCF bridge built in
Historical Financial Table
→ Identical structure across every credit — enables portfolio-level aggregation
2
Model Output: 6 Projection Cases
An 8-year projection engine built for institutional complexity. Four reporting segments. Six simultaneous projection cases. Complex capital structures up to two revolvers, seven loan tranches, and five note tranches — all handled natively. Full cash flow schedule, debt repayment waterfall, and credit statistics auto-calculated across every case.
→ Six cases: Sponsor, Base, Downside, Base +Incremental, Base at Caps, Stress
→ Up to 4 reporting segments with independent revenue and EBITDA drivers
→ Complex capital structures — 2 revolvers, 7 loan tranches, 5 note tranches
→ Full debt repayment waterfall and cash flow bridge across all cases
Model Output — Base Case
→ Revenue, EBITDA, leverage, and coverage charts auto-generated
3
Performance to Plan
Automatic variance analysis comparing LTM actuals against the original sponsor case, base case, and downside case — all on one page. Revenue, EBITDA, FCF, liquidity, leverage, and coverage ratios with dollar and percentage variances auto-calculated every time the model is rolled forward.
→ Actuals vs. sponsor case, base case, and downside — side by side
→ Dollar and % variance auto-calculated on every roll-forward
→ Revenue, EBITDA, FCF, liquidity, and leverage all on one page
Performance to Plan
→ Updates when the model is rolled to a new LTM period
4
EV Summary — FactSet & CapIQ Integrated
A fully integrated enterprise value analysis module linked live to FactSet and Capital IQ. Public equity comparables, M&A precedent transactions, and DCF methodology — all in one structured output. EV coverage ratios calculated automatically against secured and total debt.
→ Live FactSet & CapIQ data integration — no manual comp entry
→ Public equity comparables and M&A precedent transactions
→ DCF methodology with WACC assumptions and terminal value
EV Summary
→ EV/Secured Debt and EV/Total Debt coverage auto-calculated
5
Covenant Detail Table
Per-credit covenant compliance table showing actual test results, cushions, and step-down schedules for every covenant — plus base and downside projected compliance for the next two quarters. Pass/Fail status and cushion percentages calculated automatically against current test levels on every roll-forward.
→ All covenants tracked with actual and projected results
→ Base and downside projected compliance — next 2 quarters
→ Step-down schedules auto-populated from deal terms
→ Pass/Fail and cushion % recalculated on every roll-forward
Covenant Details
THE WORKFLOW
How the model actually works
From initial underwriting through quarterly monitoring — the entire credit lifecycle runs through one standardized system.
1
Spread the financials
Input the historical financial statements into the standardized spreading template. The model architecture is identical across every credit — same rows, same structure, same output format. One analyst can train on the system and spread any deal in the portfolio.
2
Set the projection assumptions
Define segment-level revenue drivers, EBITDA margin assumptions, capex, and working capital across up to six projection cases simultaneously. The projection engine handles all downstream math — cash flow, debt repayment across complex capital structures, credit statistics, and covenant compliance — automatically.
3
Pull live EV data
The EV module links directly to FactSet and CapIQ. Public equity comparables and M&A precedent transactions populate automatically. EV coverage ratios calculate instantly. No manual data entry, no spreadsheet lookup, no stale comps.
4
Roll forward each quarter
When a new quarter drops, add the new period's actuals to the historical table. The entire model rolls forward automatically — performance to plan variance updates, covenant compliance recalculates, and every output table reflects the new LTM period. What took a full day now takes minutes.
5
Feed the portfolio layer
The standardized export layer transfers data from the unified model to the portfolio monitoring system — via macro or structured export. Covenant data, DRC figures, watchlist status, and risk ratings flow into the eight monitoring modules on a consistent, repeatable schedule.
6
AI integration — near term
The standardized export layer transfers data from the unified model to the portfolio monitoring system — via macro or structured export. Covenant data, DRC figures, watchlist status, and risk ratings flow into the eight monitoring modules on a consistent, repeatable schedule.
WHY IT MATTERS
Before and after
This is the difference between a credit team that's always catching up and one that's always ahead.
WITHOUT PALM FINANCE
Every deal from scratch
●
3-5 days to build a new LBO model
●
Half a day to roll forward each quarter
●
Every analyst has a different model format
●
No standardized performance-to-plan output
●
Manual FactSet/CapIQ data entry for EV
●
Covenant compliance tracked in separate files
●
Portfolio aggregation requires manual effort
●
AI integration blocked by inconsistent data
WITH PALM FINANCE
One standardized system
●
New deal built in hours, not days
●
Roll forward in minutes — model does the work
●
Every analyst on the same architecture
●
Performance-to-plan auto-updates every period
●
Live FactSet & CapIQ EV integration
●
Covenant compliance auto-calculated in model
●
Standardized data transfer to portfolio layer
●
Clean, structured data - AI-ready from day one
INTEGRATION & ARCHITECTURE
Built for how credit teams actually work
No new software, no IT project, no migration. The model runs in Excel — the environment your team already trusts.
PLATFORM
Excel-native
Runs entirely in Microsoft Excel. No new software licenses, no cloud dependency, no IT approval required. Drop it into your existing workflow and start on day one.
DATA
FactSet & CapIQ linked
The EV module connects directly to your existing FactSet and CapIQ subscriptions. Public comps and precedent transactions populate automatically — no manual data entry.
COMPLEXITY
Built for complex deals
Handles capital structures with up to two revolvers, seven loan tranches, and five note tranches natively. Four reporting segments. Six simultaneous projection cases. No simplification required.
SECURITY
Your infrastructure
The model lives in your environment — your servers, your security protocols, your compliance framework. No data leaves your organization. No third-party cloud risk.
AI
AI-ready architecture
Plug your existing AI workflow into the standardized data layer today. Or use our near-term AI integration for spreading and commentary — analyst-reviewed, zero data risk to the model.
DEPLOYMENT
White-glove implementation
Every implementation is led by an MD-level credit executive with experience deploying this system across tier-one institutions globally. Full customization, comprehensive training, 12 months of oversight included.