Aaron Bauer Email & Phone Number

Pittsburgh, Pa, Us

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.

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.

Pittsburgh, Pa, Us

Pittsburgh, Pa, Us

Pittsburgh, Pa, Us

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

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).

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.

Mba, Strategy, Finance, Organizational Behavior

B.S., Accounting