Microsoft Office Advanced, Financial Modeling, VBA, Vlookup, Bloomberg

Shylock Baloyi

**** ****** ******, ******, ** ***43

214-***-**** /******.*******@*****.***

EXPERIENCE

Wall Street Training Dallas, TX

Advanced Financial Modeling and Valuation Course Jan 2016 – July 2016

Built stand-alone depreciation schedules to estimate working capital changes and free cash flow

Constructed detailed accelerated tax depreciation schedules based on MACRS

Analyzed liquidity ratios, profitability ratios and asset management efficiency ratios

Constructed a DCF analysis, estimated unlevered free cash flow and terminal value using multiples and perpetuity growth M&A and LBO Modeling

Calculated pro-forma, post-transaction EPS, accretion /dilution analysis and pre-tax synergies / breakeven analysis

Expanded debt sweep to account for new debt issued and discretionary cash flow recapture

Constructed credit & leverage ratios and automated credit ratings, IRR analysis to evaluate financial sponsor returns Integrated Oil and Gas Financial Modeling and Valuation

Built detailed oil & gas integrated financial statement model, quantifying all key drives of growth.

Constructed robust sensitivity and scenario analysis for toggling various future spot prices assumptions that drive profitability

Projected refining capacity, throughput, capacity utilization, refining and marketing revenue and EBITDA REIT Modeling

Built fully integrated, REIT financial models with detailed build-up by internal growth, acquisitions, dispositions, and new development

Calculated net change to development properties, construction in process and investments The Hill School Pottstown, PA

Instructor of Mathematics (Course Chair for Geometry and Calculus) June 2011 – Sept 2013

Developed top quality lesson plans to engage four classes of 15 students each

Responsible for all coaching and training of the junior varsity soccer team

Mentored and counseled students in loco parentis in the dorm St. Paul’s School Concord, NH

Instructor of Mathematics June 2010 – June 2011

Taught Vector Calculus, Financial Accounting, Multi-Variable Calculus and Geometry

Assisted in the coaching of junior varsity soccer, basketball and varsity softball Ipreo London, UK

Global Markets Intelligence Analyst Intern June 2009 –Aug 2009

Provided companies with real time ownership information of stocks for improved investor relations and engagement

Researched motivations in institutional shareholder movements and their impact on valuation

Provided sophisticated analysis on capital markets to investment banks and publicly traded companies EDUCATION

Colby College Waterville, ME

B.A. – Mathematics, Economics (double major) 2010

Mathematics: GPA 3.78 (with distinction), Economics: GPA 3.63 (with distinction) London School of Economics and Political Science London, UK B.A. Economics, Mathematics 2009

ADDITIONAL

Colby Fund, Class of 2010 Fundraising Committee Member Sept 2009 – Present o Leverage personal relationships with former classmates to raise money for the college o Organized the 5th year reunion for the Class of 2010

Colby African Students Society, Treasurer Sept 2007 – Sept 2008 o Managed club’s purse and left a surplus in the budget o Successfully fundraised for a team of 10 students to attend the Harvard African Business Conference

Colby College Rugby, Flanker Sept 2006 – May 2008 o Aggressively gained and retained possession as key member of the forwards o Honed leadership skills on and off the field, and participated in team-building activities

Skills: Bloomberg, Microsoft Office Suite Advanced (Macros, Pivot Tables, VLookup and VBA) /Spanish - intermediate

Interests: Golf, entrepreneurship, debate and public speaking, mentoring

Contact this candidate