URGENT – Acquisition Financial Model for Utility Contracting Company – Milestone 1 in 72 hrs – Start TODAY – $600–$850 Fixed

I need a Top-Rated financial modeling expert to start RIGHT NOW (today, Dec 12, 2025). This is for the final closing economics of acquiring a utility contracting company based in Canada (utilities & infrastructure, fiscal year-end June 30, on QuickBooks, Cash Accounting basis).

Two milestones – paid separately:

MILESTONE 1 – $400 – Deliver within 72 hours (latest Monday Dec 15 evening):
• Consolidate historical financial data (fiscal years 2021–2025) from provided PDFs/Excels into one common workbook, ensuring consistent line items, formatting, and roll-ups (e.g., P&L, BS where available, cash flow summaries), handling inconsistencies like "property taxes" as rent in 2025 P&L.
• Apply 5 years of provided EBITDA normalizations (e.g., owner/exec salary adjustments, one-time expenses, rent/utilities/insurance/building normalizations, lower costs for synergies) to calculate adjusted EBITDA backward for each year, reflecting post-acquisition operations and integration assumptions (e.g., ops efficiencies from lower facility costs).
• Prepare post-close opening balance sheet using LOI terms (provided today) and normalized figures.
• Analyze opening balance sheet, including defining working capital peg/target, CapEx needs for growth (e.g., equipment/vehicles for new crews, with explicit depreciation schedules), free cash flow bridge for first 12 months, cost of capital (WACC if financing involved), Canadian tax considerations (e.g., deferred taxes, PST commissions), and identification of additional capital raises required (e.g., for working capital gaps, expansion, or construction-specific risks like project delays/material costs).
• Build out fiscal 2026 YTD (July–Dec 2025, as of current date) based on top-line revenue/bottom-line EBITDA, reverse-engineered from historical averages/ratios (no QB data available; use provided projections as starting point).
This is the urgent piece we need for lenders/investors this coming week.

MILESTONE 2 – balance of payment – Deliver by Dec 17th:
• Full rebuilt 3-year financial model (second half FY2026, FY2027–2028) built in a new company template and must include all of the following:
• Updated revenue and costs incorporating growth plans (adding public utility cable/distribution/transmission crews + private work; provided projections for FY2026 and FY2027 revenue; extend logically to FY2028 based on crew ramps and historical trends), including $75K annual salary addition from FY2026 onward.
• Forward application of EBITDA normalizations to reflect changed operations (e.g., lower facility costs, salary adjustments).
• Fully integrated 3-statement model (P&L, BS, CF) with monthly granularity rolling up to annual summaries.
• Complete debt waterfall: all loan amortizations, deferred notes, and any contingent payments (terms provided if applicable).
• EBITDA clearly broken out by division: Corporate/SG&A, Public Utility Work (cable crews, distribution crews, transmission crews), Private Work.
• Cost of capital calculation (WACC) with clear assumptions.
• Driver-based architecture with visible, changeable inputs (e.g., # of cable/distribution/transmission crews, revenue per crew, EBITDA margin %, price increases, crew ramp timing, CapEx per crew, working capital days, etc.).
• Five divisional sub-forecasts that roll up seamlessly into a consolidated master forecast. The model must allow the user to isolate full P&L, Balance Sheet, and Cash Flow Statement for each individual division.
• Sensitivity / scenario analysis (data tables or scenario manager) showing impact of key variables (crew count, revenue/crew, margin, timing delays, market conditions, etc.), including risk mitigation notes (e.g., construction-specific risks like project delays or material costs).
• Professional charts and dashboard (similar in style and quality to provided sample).
• One-page executive summary in PDF format (key metrics, charts, conclusions).
• Additional elements: Tax calculations (Canadian rates, deferred taxes if relevant), depreciation schedules for CapEx, integration assumptions (e.g., synergies from operations changes).

The model should follow the clean, driver-based, visually strong style of the provided sample, but must extend it with:
• monthly detail,
• true divisional roll-up structure,
• full debt schedules,
• and the ability to view any division in isolation.

Files I will send immediately after hiring:
-2021–2025 financials
-Normalizations schedule
-Projections data, list of growth assumptions and forecast changes.
-LOI terms and any financing stack details.

Requirements:
• 4.9–5.0 rating only
• Proven acquisition / post-close modeling experience, especially in construction/utilities (send 1–2 examples)
• Advanced Excel (no errors, clean formulas, comments, VBA if needed for sensitivities)
• Available to start TODAY and jump on quick calls
• Familiarity with Canadian accounting/tax norms (e.g., fiscal year-ends, PST commissions) and construction-specific modeling (e.g., crew/project drivers, CapEx-heavy).

To win this job, reply with:
1. “I can start right now and deliver Milestone 1 in X hours”
2. Link to 1–2 similar acquisition models (post-close BS + FCF + divisional forecasts)
3. Your fixed price for both milestones + any bonus conditions
4. Exact delivery date for Milestone 1 I will hire and fund Milestone 1 within the next 1–2 hours.

Skills: Excel, Financial Modeling, Financial Analysis, Forecasting, Accounting, Mergers & Acquisitions, VBA Tags urgent, immediate, acquisition model, post-close balance sheet, free cash flow, wacc, financial forecast, utilities, construction,