Aaron Bauer

Aaron Bauer Email and Phone Number

Commercial Strategy | Corporate Finance | FP&A | Treasury at EQT @ EQT Corporation
Aaron Bauer's Location
Greater Pittsburgh Region, United States, United States
Aaron Bauer's Contact Details
About Aaron Bauer

Curious, organized, dependable professional who is continually seeking to improve processes, visualizations, and results. Passionate about evolving the way things are done for better outcomes. Industry experience in energy and financial services. Skilled in commodities trading, financial & strategic planning/analysis, executive presentations and decision support, financial modeling, valuation, capital markets, treasury, corporate M&A, and data visualization.

Aaron Bauer's Current Company Details
EQT Corporation

Eqt Corporation

View
Commercial Strategy | Corporate Finance | FP&A | Treasury at EQT
Aaron Bauer Work Experience Details
  • Eqt Corporation
    Lead Business Specialist - Commercial Strategy
    Eqt Corporation Nov 2023 - Present
    Pittsburgh, Pa, Us
  • Eqt Corporation
    Lead Business Specialist - Corporate Finance
    Eqt Corporation Aug 2020 - Oct 2023
    Pittsburgh, Pa, Us
    • VBA: Developed several macros used in our corporate model. One of these, triggered by closing the file, automatically logs key changes made (along with a name/file/time stamp) with a delta of key metrics to the last saved version. Another example is a macro that changes the view and print settings of our key output data based on the intended user (i.e. high level for the BOD or more detail for other users) with the click of a button.• Dashboarding/BI: Customized workflow dashboard and built reports in Salesforce. Currently creating extensive financial dashboard in PowerBI. • Capital Allocations: Key analyst supporting the decision and execution of our comprehensive capital allocation strategy including fixed dividends, debt, equity repurchases, and ongoing analysis of shareholder returns.• M&A Analysis: Modeled various scenarios and provided pro forma forecasts to the executives and advisers resulting in our $8bn acquisition of Rice Energy in 2017. Assessed the accretion/dilution effects and corporate impacts of various upstream and midstream asset purchases. Provided similar analytical support for other acquisitions including Chevron Appalachia (~$1 bn value), Alta Resources (~$3 bn value), and Tug Hill & XcL Midstream (pending FTC approval; ~$5 bn value). Built a merger model to quickly evaluate combinations with a list of peers.
  • Eqt Corporation
    Senior Business Specialist
    Eqt Corporation Aug 2017 - Aug 2020
    Pittsburgh, Pa, Us
    • Corporate Planning: Created a comprehensive forecast charts model, which compares multiple scenarios, to generate slides regularly used in communications with the executives, the board of directors (BOD). • Financial Modeling: Managed or co-managed the company’s corporate model for four years. Duties included updating the forecast, running sensitivities, evaluating corporate impacts of transactions, building out functionality, and improving model efficiency. • Executive Communication: Led the company Business Plan coordinating with the business units’ FP&A functions. Presented the Plan to the executives who in turn presented to and received approval from the BOD. • Competitive Analysis: Ran various decision analysis projects for the CEO/CFO on an ad hoc basis. • Valuation: Analyzed and presented alternatives for monetizing the general partner of EQM. Produced a DCF valuation model, shared with the banks, ultimately resulting in the IPO for EQGP ($7bn valuation, $700mm in proceeds). Also constructed a valuation model used to estimate returns for midstream business development opportunities (some being > $100mm).• Capital Markets: Managed the due diligence process for multiple bond offerings including a recent $1.8bn issuance. Conducted make-whole premium analysis and provided support for $1.5bn in redemptions. Analyzed financing options leading to a $1bn term loan. Other capital markets responsibilities included cost of capital and liquidity analysis, MLP distributions, and credit ratings.
  • Eqt Corporation
    Business Specialist
    Eqt Corporation Feb 2016 - Aug 2017
    Pittsburgh, Pa, Us
  • Eqt Corporation
    Business Analyst
    Eqt Corporation Aug 2014 - Feb 2016
    Pittsburgh, Pa, Us
  • Eqt Corporation
    Mba Intern
    Eqt Corporation May 2014 - Aug 2014
    Pittsburgh, Pa, Us
  • Kkr
    Manager
    Kkr Jun 2011 - Jul 2013
    New York, New York, Us
    Manager, 2013Senior Accountant, 2011 - 2012• Cash Management: Reviewed daily liquidity with treasury and initiated capital calls/distributions totaling more than $1 billion in cash flows for 16 private equity funds.• Leadership: Led communications with our accounting administrator, based in India, which provided accounting services, investor reporting and support for our data analysis of our alternative investment funds. Leveraged the administrator to produce high quality deliverables within tight deadlines for our regular discussions with the CFO.• Analytical
  • Rothstein Kass
    Senior Associate
    Rothstein Kass Oct 2007 - Jun 2011
    Us
    Senior Associate, 2009 - 2011Associate, 2007 - 2009The company is now part of KPMGLeadership• Managed engagement teams performing financial statement audits including budgeting, planning and reviewing work performed by staff. Communicated with hedge fund managers, brokers and attorneys. • Led the audit of an energy hedge fund client which had more than $2bn in assets under management.• Recruited, trained, supervised and evaluated 10 other professionals. Analytical Thinking• Recalculated investor economic allocation models to ensure proper allocation of P&L items to hundreds of investors (both institutional and high-net-worth individuals).
  • Vspring Capital
    Summer Intern
    Vspring Capital May 2006 - Jul 2006
    Us
    Venture capital firm now known as Signal Peak Ventures.• Financial Analysis: Improved the financial forecast of one of the firm’s technology portfolio companies. The forecast was used by the executives and capital providers for a $10mm Series B round of financing.

Aaron Bauer Skills

Private Equity Finance Hedge Funds Financial Modeling Corporate Finance Investments Leadership Derivatives Financial Analysis Alternative Investments Microsoft Excel Management Asset Management Strategy Fixed Income Valuation Bloomberg Capital Markets Treasury Sensitivity Analysis Leveraged Finance Strategic Planning Mergers And Acquisitions @risk Optimization Oil And Gas Industry Energy Industry Data Visualization Powerpoint Vba Factset Risk Solver Monte Carlo Simulation Partnerships Mlp

Aaron Bauer Education Details

  • Carnegie Mellon University - Tepper School Of Business
    Carnegie Mellon University - Tepper School Of Business
    Organizational Behavior
  • Brigham Young University Marriott School Of Business
    Brigham Young University Marriott School Of Business
    Accounting

Frequently Asked Questions about Aaron Bauer

What company does Aaron Bauer work for?

Aaron Bauer works for Eqt Corporation

What is Aaron Bauer's role at the current company?

Aaron Bauer's current role is Commercial Strategy | Corporate Finance | FP&A | Treasury at EQT.

What is Aaron Bauer's email address?

Aaron Bauer's email address is aa****@****hoo.com

What is Aaron Bauer's direct phone number?

Aaron Bauer's direct phone number is +192576*****

What schools did Aaron Bauer attend?

Aaron Bauer attended Carnegie Mellon University - Tepper School Of Business, Brigham Young University Marriott School Of Business.

What are some of Aaron Bauer's interests?

Aaron Bauer has interest in Economic Empowerment, Traveling, Snowboarding, Reading Business Media, Education, Health, Extreme Sports, Strategy Games.

What skills is Aaron Bauer known for?

Aaron Bauer has skills like Private Equity, Finance, Hedge Funds, Financial Modeling, Corporate Finance, Investments, Leadership, Derivatives, Financial Analysis, Alternative Investments, Microsoft Excel, Management.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.