The CFO's role in negotiating an acquisition includes leading valuation analyses, structuring deal terms and pricing, handling working capital and earn-out negotiations, and ensuring the deal meets financial criteria and creates shareholder value.