Apply on Employer Site

Cooley LLP · 2 days ago

Transactional Quantitative Analyst

San Francisco, CA

Full-time

Onsite

Mid, Senior Level

$100K/yr - $190K/yr

3+ years exp

Cooley LLP is seeking a Transactional Quantitative Analyst to join the Practice Management team. The role involves assisting clients with quantitative analysis related to venture capital and M&A deals, including constructing models and conducting financial analyses.

Document PreparationLegalProfessional Services

Comp. & Benefits

Responsibilities

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, Shareworks 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

Qualification

Advanced Excel proficiencyQuantitative analysisFinancial modelingVisual Basic skillsCorporate finance experienceAnalytical thinkingCommunication skillsTeam collaborationTime management

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