📊 OVERVIEW
A professional Excel workbook for modelling the impact of debt on firm value, shareholder returns, and weighted average cost of capital (WACC). Designed for finance students, analysts, and corporate strategists, this template includes editable inputs for EBIT, interest, tax rate, and capital structure scenarios. Ideal for valuation modelling, capital optimisation, and equity-debt tradeoff analysis.
📦 WHAT’S INCLUDED
• 📘 Excel workbook (.xlsx)
• 🧮 Exhibit 1: capital structure scenarios from 0% to 50% debt
• 📊 WACC calculator with debt/equity weights and after-tax cost logic
• ✅ Ready for printing, PDF export, or digital sharing
🧠 USE CASES
• Corporate finance coursework and capital structure simulations
• Strategic planning and debt optimisation
• Shareholder impact modelling and valuation analysis
• Reusable format for any firm or industry
🎯 FEATURES
• Editable .xlsx format with UK spelling and layout standards
• Includes EPS, P/E ratio, market value calculations, and free cash flow logic
• Built-in assumptions for repurchase mechanics and equity revaluation
• Compatible with Microsoft Excel and Copilot editing
🔴 INSTANT DIGITAL DOWNLOAD
No waiting, no shipping, no locked fields. This template is available immediately and built for professionals who need a structured, editable way to model capital structure decisions. Download, customise, and start analysing—right away.
