Excel DCF Modeler

Overview

Creates professional DCF valuation models following investment banking standards with WACC calculations and sensitivity analysis.

Prerequisites

• Excel or compatible spreadsheet software
• Historical financial data for target company
• Industry comparables for WACC estimation

Instructions

1. Create assumptions sheet with revenue growth, margins, WACC, and terminal growth rate
2. Build free cash flow projections (5-year forecast)
3. Calculate terminal value using Gordon Growth Model
4. Discount cash flows and terminal value to present value
5. Sum to get enterprise value, subtract net debt for equity value
6. Add sensitivity tables for key assumptions

Output

• Complete 4-sheet DCF model with assumptions, projections, valuation, and sensitivity
• Enterprise value and equity value per share
• Sensitivity analysis on WACC and terminal growth rate

Error Handling

Examples

Example: Value a SaaS Company Request: “Create a DCF model for a $50M ARR SaaS company growing 30%” Result: 4-sheet model with 5-year projections, 12% WACC, 3% terminal growth, sensitivity tables

**Example: M&A Valuation

…(truncated)

Excel LBO Modeler

Overview

Creates leveraged buyout models with debt structuring, amortization schedules, and sponsor returns analysis for private equity transactions.

Prerequisites

• Excel or compatible spreadsheet software
• Target company financial data
• Debt term sheet parameters
• Entry/exit multiple assumptions

Instructions

1. Set up transaction structure (purchase price, debt/equity split)
2. Build debt schedules for each tranche (senior, mezzanine, etc.)
3. Create operating projections with debt service
4. Calculate cash flow available for debt paydown
5. Model exit scenarios and calculate IRR/MOIC

Output

• Complete LBO model with sources & uses, debt schedules, and returns
• IRR and MOIC at various exit multiples and years
• Sensitivity tables for entry/exit multiple and leverage

Error Handling

Examples

Example: Mid-Market LBO Request: “Build an LBO model for a $100M EBITDA company at 8x entry” Result: 60% senior / 40% equity structure, 5-year model, IRR analysis at 7x-10x exits

Example: Add-On Acquisition Request: “Model a bolt-on acquisition with synergies” Result: Integrated model with synergy phase-in and ac

…(truncated)

Excel Pivot Wizard

Overview

Creates advanced pivot tables with calculated fields, slicers, and dynamic dashboards for data analysis and reporting.

Prerequisites

• Excel or compatible spreadsheet software
• Tabular data with headers
• Clear understanding of analysis dimensions and measures

Instructions

1. Verify source data is in tabular format with headers
2. Create pivot table from data range
3. Configure rows, columns, values, and filters
4. Add calculated fields for custom metrics
5. Insert slicers for interactive filtering
6. Format and style for presentation

Output

• Configured pivot table with appropriate aggregations
• Calculated fields for derived metrics
• Interactive slicers for filtering
• Dashboard-ready formatting

Error Handling

Examples

Example: Sales Dashboard Request: “Create a pivot summarizing sales by region and product” Result: Pivot with region rows, product columns, revenue values, and date slicer

Example: Financial Analysis Request: “Build a pivot showing monthly trends by cost center” Result: Time-series pivot with calculated YoY growth fields

Resources

• Microsoft Pivot Table Guide
• `{baseDir}/refe

…(truncated)

Excel Variance Analyzer

Overview

Performs comprehensive budget vs actual variance analysis with automated drill-down, root cause identification, and executive reporting.

Prerequisites

• Excel or compatible spreadsheet software
• Budget data by period and category
• Actual results for comparison
• Cost center or department structure

Instructions

1. Import budget and actual data into comparison template
2. Calculate absolute and percentage variances
3. Apply materiality thresholds for flagging
4. Create drill-down by category, period, or cost center
5. Generate variance waterfall chart for executive reporting

Output

• Variance summary with favorable/unfavorable indicators
• Materiality-filtered exception report
• Waterfall chart showing budget-to-actual bridge
• Drill-down by category or cost center

Error Handling

Examples

Example: Monthly P&L Variance Request: “Analyze why we missed budget by $500K this month” Result: Variance waterfall showing revenue shortfall offset by OPEX savings

Example: Department Budget Review Request: “Which departments are over budget YTD?” Result: Ranked list by variance magnitude with drill-down to line items

Resources

• [FP&A Best Practices](

…(truncated)