Driver-Based Acquisition Financial Model
Budget: €250 – €750 EUR
I need a driver-based financial model to evaluate a pending company acquisition in classic M&A / LBO style. The worksheet must let me toggle key operating drivers—revenue growth, margins, capex, financing structure—and instantly see the impact on cash flow, debt pay-down, valuation and investor returns.
Core expectations
• Fully linked three-statement model built in Excel (or Google Sheets if you prefer).
• Clear Input tab where the drivers live, separating assumptions from formulas.
• Debt schedule that can accommodate different leverage levels, repayment profiles and interest scenarios.
• Summary outputs: free cash flow, IRR, MOIC, sensitivity tables and waterfall if relevant.
• Clean architecture with consistent naming, audit checks and easy scenario switching so I can reuse the tool on other targets.
I will provide the historical financials and headline transaction terms once we start; please structure the file so updating those numbers is painless. A brief walk-through call or screen-share at hand-off would be appreciated so I can understand your logic and extend the model myself later.
Core expectations
• Fully linked three-statement model built in Excel (or Google Sheets if you prefer).
• Clear Input tab where the drivers live, separating assumptions from formulas.
• Debt schedule that can accommodate different leverage levels, repayment profiles and interest scenarios.
• Summary outputs: free cash flow, IRR, MOIC, sensitivity tables and waterfall if relevant.
• Clean architecture with consistent naming, audit checks and easy scenario switching so I can reuse the tool on other targets.
I will provide the historical financials and headline transaction terms once we start; please structure the file so updating those numbers is painless. A brief walk-through call or screen-share at hand-off would be appreciated so I can understand your logic and extend the model myself later.