Template 01 · Cash flow and resilience
Rental Property Cash Flow Stress Test Template
A 10-year French short-term rental model comparing Baseline, Rate Shock at 7.74%, and Stagflation scenarios. It focuses on debt coverage, occupancy resilience, annual NOI versus debt service, cumulative cash flow, and recovery after a deficit.
Type: Project finance dashboard
Key metrics: €620.0K entry value; €28.8K baseline cumulative cash flow; 0.87x minimum DSCR under rate shock; 73.6% peak break-even occupancy under stagflation
Primary use case: Lender-style rental property underwriting and scenario testing
Description: The dashboard identifies years below the 1.0x DSCR threshold and shows how interest rates and occupancy pressure affect coverage. It is particularly useful when a property decision depends on whether operating deficits reverse or compound.
Tags: cash flow, stress testing, project finance, DSCR
Open Project Cash Flow Dashboard
Scenario scorecard
| Scenario | Min DSCR | 10Y cash flow |
|---|
| Baseline | 1.02x | €28.8K |
| Rate Shock | 0.87x | -€17.7K |
| Stagflation | 0.79x | -€24.4K |
Template 02 · Corporate performance
Software and Payments Operating Leverage Template
This 2011–2025 dashboard examines revenue scale, gross-margin expansion, operating-expense absorption, and operating income. In 2025, total revenue was $455.5M, gross margin was 43.5%, gross profit covered 0.74x of operating expenses, and operating margin was -15.1%.
Type: Operating leverage dashboard
Primary use case: Evaluating whether gross profit is growing faster than operating expenses
Tags: operating leverage, revenue, gross margin, opex coverage
Open Cost Coverage Dashboard
Template 03 · Allocation and risk
ETF Portfolio Allocation and Risk Template
A €40,000 portfolio dashboard covering four asset sleeves, five interactive charts, annualized return, volatility, drawdown, correlation, and expected return contribution. The final allocation is 65% equities and 35% bonds, with modeled return of 15.3% and volatility of 10.6%.
Primary use case: Comparing allocation, risk, correlation, and contribution across S&P 500, NASDAQ, investment-grade bonds, and high-yield bonds
Tags: portfolio, allocation, risk, correlation
Open ETF Portfolio Dashboard
Template 04 · Revenue mix
Broker Revenue and Revenue-Mix Template
Compare Interactive Brokers and Tiger across revenue scale, commissions, net-interest income, and growth from 2018 through 2024. IBKR's 2024 mix was 35.0% commissions and 65.0% net interest, while its revenue basis reached $4.84B; Tiger total revenue reached $391.5M.
Type: Revenue comparison dashboard
Primary use case: Studying disclosed revenue composition and scale growth
Tags: broker revenue, commissions, net interest, growth
Open Broker Revenue Dashboard
Template 05 · Macro relationships
Macro-Quantitative Financial Modeling Template
Model relationships among Fed Funds, the 10-year Treasury yield, inflation, unemployment, and real GDP from January 2000 through May 2026. It includes five charts, a correlation heatmap, a current regime snapshot, and rolling-correlation analysis.
Key metrics: May 2026 Fed Funds rate 3.63%; 10-year yield 4.48%; inflation 4.17%; unemployment 4.30%; real GDP growth 2.68%
Tags: macro, interest rates, inflation, GDP, correlation
Open Macro-Quantitative Dashboard
Template 06 · Model validation
Macro Financial Modeling Diagnostics Template
This diagnostic framework tests spurious regression, lookahead bias, timing misalignment, and factor interpretation. Levels produced a 98.1% R², while the corrected differences model produced 19.0%; realistic lagged-data R² was 18.6%, making the gap visible rather than hidden.
Primary use case: Separating trend fit, timing risk, and factor meaning before relying on a macro model
Tags: diagnostics, spurious regression, lookahead bias, factors
Open Diagnostics Dashboard
Template 07 · Regime stress testing
Macro Model Failure and Regime Stress-Test Template
See where a simple policy-rate model breaks across calm samples, the zero-lower-bound period, and the post-2020 regime. RMSE was 0.32 percentage points in 2005–2007, 7.85 points during the GFC-era zero-lower-bound regime, and the largest miss reached 30.532 points in April 2020.
Primary use case: Stress testing model coefficients against historical regime changes
Tags: macro, stress testing, regime failure, residuals
Open Failure Dashboard
Template 08 · Development finance
Campground Build Feasibility and Development Finance Template
Evaluate infrastructure-heavy Phase 1 scope, inflation reserves, borrowing costs, and sequencing decisions for a campground build. The stated Phase 1 budget range is $4.5M–$5.0M; a 5% reserve adds $225K–$250K, while a 10% reserve adds $450K–$500K.
Key metrics: 6.49% 30-year mortgage proxy in June 2026; 79.7th percentile of the 2015–2026 range; 2.01 percentage-point mortgage-versus-Treasury spread
Tags: project finance, feasibility, infrastructure, contingency
Open Campground Feasibility Dashboard
Template 09 · Retail profitability
Retail Financial Performance Template
Analyze 51,290 transactions from 2011 through 2014 across sales, profit, discounts, margins, categories, subcategories, and monthly trends. Total sales were $12,642,905 and total profit was $1,467,457. Weighted margin was 11.6%, compared with a 4.7% average transaction margin.
Notable output: Weighted margin stayed positive through the 10–20% discount bucket at 9.9% but turned negative in the 20–30% band at -5.5%; Tables had -$64,083 profit and an -8.5% weighted margin.
Tags: retail, margin, discounting, transactions
Open Retail Financial Dashboard
Template 10 · Integrated project finance
Project Finance Dashboard Template
A reusable project-finance framework built from the rental property cash flow stress test. Modules cover acquisition and renovation basis, operating revenue and costs, NOI, debt service, DSCR, break-even occupancy, interest-rate sensitivity, cumulative cash flow, recovery year, and lender-style coverage analysis.
Recommended inputs: 5.74% baseline interest rate; 7.74% rate-shock case; +200 basis-point shock; 1.0x DSCR threshold; 64.3%, 71.4%, and 73.6% peak break-even occupancy across the stated scenarios
Tags: project finance, cash flow, DSCR, scenario analysis
Open Project Finance Dashboard
