Transactional Quantitative Analyst

Cooley LLP is seeking a Transactional Quantitative Analyst to join the Practice Management team.

The Transactional Quantitative Analyst will assist transactional clients of the firm with quantitative analysis for the purpose of evaluating, structuring, optimizing, and closing venture capital and merger & acquisitions (M&A) related deals. Responsible for conducting research, designing the analysis, performing calculations, and preparing models and other materials to meet client demands and requests of deal teams. Working under the general direction of the lead attorney on the deal, this role will work directly with clients to understand the quantitative objectives and data available, and then design and carry out required modeling tasks.

• Construct hypothetical liquidation waterfall models based on corporations’ certificate of incorporation or other governing document, which have optionality for several different deal scenarios
• Construct payout spreadsheet deliverables for M&A deals based on relevant transaction documents for both buy‑side and sell‑side clients
• Audit existing waterfall or payout spreadsheets obtained from clients, investment banks, or other law firms
• Construct pro forma capitalization tables, including price per share calculations, in connection with venture capital and private equity financings, debt to equity conversions, anti‑dilution adjustments, and stock option grants
• Audit existing pro forma capitalization tables obtained from clients, investors, or other law firms
• Create and manage capitalization tables and perform related data conversion and analysis
• Run 280G analysis based on compensation, capitalization, and deal data
• Run 701 analysis for later stage companies
• Collaborate with the Capital Markets practice group to construct pricing spreadsheets, beneficial ownership, and pro forma capitalization models in connection with IPOs, SPACs, and other public offerings
• Develop and maintain functioning firm wide models for all of the core quantitative analysis to be performed by Cooley on a predictable or regular basis
• Promote firm wide adoption of capitalization table management standards as adopted by the firm (including, as applicable, in Excel or via third party tools, such as eShares, Share works and other software platforms)
• Design and perform financial statement analysis to calculate and analyze financial metrics and ratios (as requested)
• Design and prepare customized mathematical analysis that may include, but are not limited to tax analysis (e.g., stock sale vs. asset sale) and analysis of allocations/distributions for LLCs and partnerships
• Design and prepare valuation reports and economic analysis
• Assist with training junior attorneys and paralegals or other business professionals on the use of Excel to achieve deliverables
• Bill and meet a minimum of 1,800 billable hours annually
• Record all time daily (billable, productive, admin and PTO) and release and in accordance with specified narratives where applicable
• All other duties as assigned or required

• Advanced proficiency in Excel, with the ability to design and perform complicated analysis; develop reports; write macros; produce documents; and create tables, graphs, and charts
• Ability to work extended and/or weekend hours, as required
• Ability to travel, as required
• Along with 3+ years directly relevant experience, a Senior Transactional Quantitative Analyst will exhibit analytical and critical thinking in day‑to‑day tasks along with the proven ability to operate at an elevated level in terms of scope of responsibility, judgement and autonomy. Seniors work more independently, demonstrate escalating ownership and mastery of assigned area, exhibit strength in areas of responsibility and become a resource and mentor to within the department

• Bachelor’s or advanced degree in Economics, Accounting, Business, Finance, Mathematics, Applied Mathematics, or other applied quantitative field
• Prior experience in corporate finance or financial transactions
• Visual Basic skills
• Strong interest in capital markets, emerging companies, venture capital, and M&A…