Inputs, operations, debt
Inputs, operations, debt and returns schedules
Business & investing · Excel + guide
Work from sources and uses through five years of operations, cash available for repayment and an illustrative equity exit.
Designed for analysts learning acquisition financing.
See exactly what is included ↓What you receive
Inputs, operations, debt and returns schedules
Sources-and-uses reconciliation and linked charts
Two-input sensitivity and a practical learning guide
Your workflow
Set entry valuation, financing and operating assumptions.
Trace cash available for debt repayment each year.
Test exit assumptions and explain MOIC and IRR together.
A taste of the method
Buying a business with debt can amplify the equity outcome. The model separates operating cash generation, debt reduction and exit value so you can see which assumption drives the return.
Read the related free lesson ↗You receive an editable calculation structure, a fictional worked example, linked visualisations and a guide explaining the inputs, outputs and common mistakes. The purpose is to help you understand the result and repeat the process.
Simplified five-year fictional buyout. Opening-debt interest avoids circularity. Not a transaction-ready financing model; no multiple tranches, management waterfall or tax advice. Native Excel data-table behaviour requires desktop review.
A spreadsheet application that opens .xlsx files. Desktop Excel is the intended application. These release candidates have calculation and export checks; desktop Excel acceptance remains outstanding. No macros or external data connections are required.
Not yet. These pages show the actual prepared products while checkout, delivery, purchase terms and release checks are completed. No payment or reservation is taken here.