Thankfully, our favorite AI systems have at last caught up with our spreadsheets.

Links to financial analysis models, workbooks and AI systems for diligence.

• Retention Analysis Model

  • Calculates net and gross revenue retention, logo and dollar retention by cohort, and customer concentration. Excel template can be uploaded onto AI products like Shortcut AI

• Unit Economics and LTV/CAC Model

  • This model calculates the lifetime value of a customer by combining revenue, churn, and gross margin. It measures the full cost of acquiring customers, including sales and marketing, and compares that against LTV to show whether growth creates or destroys value. It tracks CAC over time to reveal if acquisition efficiency improves as the business scales. It also tests how changes in churn, margins, or capital costs affect overall profitability. The purpose is to give a precise view of whether customer growth translates into sustainable cash generation.

• Building Blocks of Financial Model Frameworks

  • These workbooks include paper LBOs and framework models to analyze valuation, purchase accounting, and financial performance in LBO models. The modules outline enterprise value calculations, goodwill accounting in acquisitions, operating assumptions for forecasting, and the treasury stock method for share dilution.

• Framework for Equity Rollover and Preferred Stock Analysis

  • This workbook outlines the building blocks of equity structures in an LBO. It lays out how participating and convertible preferred instruments function, how rollover equity is analyzed in a buyout, how goodwill is created and recorded at closing, and how the treasury stock method is applied to options and warrants.

• Framework for Revolver, Waterfall and PIK Analysis

  • This workbook outlines the building blocks of debt structures in an LBO. It lays out how a revolver operates as a source of liquidity, how a debt waterfall allocates cash flow across interest, mandatory amortization, and optional repayments, and how PIK interest accrues when cash payments are deferred and compounds over time.

• Framework for Enterprise Value Build and Free Cash Flow Yield

  • This workbook outlines how enterprise value is constructed from equity, debt, and other adjustments, and how free cash flow yield is calculated to measure the efficiency of cash generation relative to enterprise value.

• Framework for Scenario Analysis and Returns Proceeds Analysis

  • This workbook outlines how returns are measured through IRR and MoM, and how scenario analysis is used to test outcomes under different exit multiples, leverage levels, and operating assumptions.

• Due Diligence Screener GPT

  • Due Diligence Screener is built to screen any company to generate a company scorecard, industry scorecard, and structured diligence points—each fact sourced from web searches and user input.

AI systems allow us to:

• Clean data — convert inconsistent data from PDFs and databases into structured outputs using GPT, Claude, and Gemini.

• First Draft Models — draft financial models through Excel templates and AI tools like Shortcut AI.

• Dashboard — identify anomalies in revenue, expenses, and cash flow with Julius AI.

• Put numbers in context — benchmark performance and run trend analysis against peers and industry standards with custom-trained GPTs.

Coming Soon

1. Perplexity AI for financial Analysis (Coming Soon)

2. Valuation Calculator - Initial Appraisal (Coming soon…)

3. DCF Model (Coming soon…)

4. TAM Calculator(Coming soon…)

5. CAC Payback Period Metric (Coming soon…)

6. Cash Runway Financial Model (Coming soon…)

7. Sales Efficiency Metrics (Coming Soon)

8. Claude Projects (Coming Soon)