Особисті дані приховані

Mykhailo Virshylo
Email: [відкрити контакти](див. вище в блоці «контактна інформація») | LinkedIn: Mykhailo Virshylo | LinkedIn
EDUCATION
Master’s in Business Economics and Finance: Kyiv School of Economics Expected: 2026
Bachelor of Science in Econophysics: Taras Shevchenko National University of Kyiv 2021 – 2025

SKILLS: Git, Statistics, SQL, Power BI, Python, Financial modeling (DCF, M&A, Relative Valuation),
Accounting, Excel, Power Point, Machine Learning.

EXPERIENCE
Research Assistant at Kyiv School of Economics | Gathered and analyzed legislative and 2025
research information. Conducted data analysis via Python and Excel

Sales Manager at Ontrack Transportation | Negotiated prices with US market freight 2022 – 2023
brokers and truck drivers, oversaw subsequent logistical delivery

Geophysicist (Contract)| Conducted electromagnetic investigations of archeological 2018 – 2026
sites via georadar spatial analysis. Constructed subsurface 3D models and resistivity spectrum imaging
via Res2Dinv, Surface 3D and Synchro 3

PROJECTS
Sydney Property Market Q1 2026 Investment Dashboard (link)
I. Gathered and cleaned five quarters of NSW Fair Trading rent data. NSW Valuer General sales
records, RBA F5 investor mortgage rates, and ATO postcode-level tax statistics in Python.
Declared valuation metrics (Gross Yield, Price-to-Rent, Price-to-Income, Affordability Index,
Implied Cap Rate at 4/5/6% scenarios etc.)
II. Constructed a four-page Power BI dashboard covering Sydney Metro area postcodes, made a
subsequent deep-dive into rent dynamics and highest yielding property types.
III. Set up a ranked Investment list of lucrative postcodes by Gross Yield with supporting housing
market metrics.
AT&T - Time Warner Acquisition (link)
I. Investigated WACC and DCF valuation for Time Warner ahead of AT&T's 2016 acquisition.
Calculated beta via regression against S&P 500 monthly returns and arrived at WACC 8.3%
based on CAPM.
II. Projected 5-year free cash flows under multiple growth scenarios with a Gordon growth terminal
value. Obtained DCF-implied value of $78.11 per share.
III. Built a relative valuation against six media peers, 14.5x median P/E, 8.9x EV/EBITDA and
precedent M&A transactions (12.45x EV/EBITDA). Formed a valuation range of $66.94-$105.72
per share. Assessed whether AT&T's $107.50 2016’s offer was justified.
Lockheed Martin DCF (link)
I. Built a 5-year free cash flow model for a production line investment from EBITDA, working
capital, and CapEx assumptions.
II. Obtained WACC via CAPM using Damodaran industry beta and bond-rating-implied cost of debt.
Ran sensitivity analysis, found the breakeven point.
III. Constructed an executive summary recommending project approval under the base case NPV of
$27M, IRR of 12.7%.

PUBLICATIONS: Bondar, Kseniia, Iryna Tsiupa, and Mykhailo Virshylo. (2025). Monitoring Air Pollution
in Wartime Kyiv (Ukraine): PM2.5 and PM10 Spikes During Russian Missile and Drone Attacks.(link)

CERTIFICATIONS: MIT - Machine Learning with Python-From Linear Models to Deep Learning(link)