Useful insights into financial modeling

dividend recap LBO model with IRR sensitivity chart

Dividend Recap Modeling Explained: Why Smart PE Firms Use It to Turbocharge IRR

A dividend recapitalization (dividend recap) lets a private equity (PE) firm extract cash from a portfolio company early by loading it with new debt, paying a special dividend to investors while keeping control. This LBO variant boosts internal IRR without selling the asset, but demands bulletproof cash flow modeling to …

more…

Financial analyst working on AI-powered financial model dashboard with forecasting charts, scenario sliders and semi-transparent AI assistant overlay, modern office setting

AI in Financial Modeling: How Your Role Will Fundamentally Change in 2026

For years, financial models were mainly about grind work: collecting data, cleaning it, putting it into Excel, building forecasts, and running scenarios. In 2026, this balance is tipping – artificial intelligence is taking over more and more of the routine work and shifting your focus toward interpretation, storytelling, and strategic decision-making. If …

more…

Credit metrics dashboard showing Net Leverage, FCCR and FCF Yield in Excel – financial-modeling.com

Your Credit Metrics Dashboard Is Lying to You – Here’s How to Fix It

Leverage, Fixed Charge Coverage, and Free Cash Flow Yield are the three numbers every lender, CFO, and credit analyst watches most closely. Yet most Excel-based dashboards either calculate them inconsistently, mix accounting periods, or strip out the nuances that make these ratios meaningful. This guide builds a structured, audit-proof credit …

more…

Professionals discussing valuation analysis in boardroom

The Price Behind the Price: Using Reverse DCF to Reframe M&A Negotiations

A Reverse DCF starts with the market or proposed transaction price and works backward to derive the assumptions required to justify that valuation. In negotiations, this technique shifts the conversation from opinions to implied expectations — revealing whether growth, margins, and capital efficiency assumptions are realistic or strategically optimistic. Why …

more…

Financial modeling workspace showing SOTP valuation model

Break the Conglomerate Discount: Building a Sum-of-the-Parts (SOTP) Valuation That Stands Up in Investment Committees

A Sum-of-the-Parts (SOTP) valuation decomposes a diversified company into distinct business units, values each segment using the most appropriate methodology, and recombines them into an equity value. When built rigorously, SOTP reveals hidden value, supports strategic decisions, and withstands scrutiny from lenders, auditors, and investment committees. Why SOTP matters in …

more…

Sensitivity tables explained in professional financial modeling

Building Sensitivity Tables the Right Way – A Practical Tutorial

Sensitivity tables are not Excel decorations. They are decision tools. Built correctly, they show where value truly comes from. Built poorly, they create false confidence and break under review. This tutorial explains how to design sensitivity tables that are structurally sound, economically meaningful, and defensible. This is not about formatting.It …

more…

Transaction expenses modeled correctly in sources and uses

Transaction Expenses in Financial Models: The Checklist Most Models Get Wrong

Transaction expenses rarely break a deal on paper — but they regularly break financial models. Incorrect fee treatment distorts equity value, misstates cash needs, and triggers credibility issues during investment committee or lender review. This checklist shows how to model transaction expenses correctly, cleanly, and defensibly. This is not about …

more…

Corporate finance setting representing terminal value assumptions in financial modeling

Common Terminal Value Mistakes Analysts Make – And How to Fix Them

Terminal value is often treated as a mechanical output of a formula. In reality, it is the single most assumption-sensitive component of a valuation model. Most errors do not come from incorrect math, but from structural misunderstandings about growth, reinvestment, and capital intensity. This article explains the most common terminal …

more…

Opening hours

Appointment by
prior arrangement

ADDRESS

37 Wall St, New York, NY

Telephone

+1-754-249-7916