Finance Intern

Yichun Wang

+1-646-***-**** ******@********.*** New York, NY 10025

EDUCATION

Columbia University, School of International and Public Affairs New York, NY, U.S. Master of Public Administration, International Finance& Data Analytics GPA: 3.85/4 Sep 2024 - Jun 2026

Coursework: Corporate Finance, Quantitative Analysis(A+), Sustainable Finance, Machine Learning, Data Visualization Central University of Finance and Economics, School of Public Finance and Taxation Beijing, China Bachelor of Science in Economics, Taxation Sep 2020 - Jun 2024

Coursework: Micro/Macroeconomics, International Economics, Econometrics, MATLAB Programming, SQL and Database Management, Intermediate Financial Accounting, Tax Planning, Financial Management & Analysis, International Taxation, Public Finance, Investment

Awards: Academic Excellence Scholarship, Moral Excellence Scholarship, Aesthetic Excellence Scholarship, All-Round Development Scholarship

EXPERIENCE

Sealand Securities Beijing, China

Strategy Analyst Intern, Strategy Research Department Oct 2023 – Jan 2024

Monitored key economic and financial meetings held by central authorities and new policies, summarized key takeaways, compared with past policies, discovered potential shifts in national development priorities and forecasting potential market impact(e.g., deposit rate cuts and game license approvals)

Utilized Excel VBA to automate updates of market liquidity data from Wind, providing weekly summaries and analyses of liquidity trends

Conducted comprehensive industry research on the Antibody-Drug Conjugate (ADC) sector, evaluated the clinical development progress of major ADC drug manufacturers, tracking FDA approvals, clinical trial results, and competitive positioning

Designed PowerPoint slides for several finished researches Ernst & Young Hua Ming LLP Beijing, China

Forensics Intern, Forensics Department Jul 2023 – August 2023

Prepared due diligence reports: Reviewed corporate governance structure, understood business model, checked regulatory compliance risks and identified ongoing or potential litigations by analyzing financial statements, business registrations and other data

Performed expense testing: Performed cutoff testing to ensure the authenticity and compliance of expenses by analyzing client invoices and checking with vendors

ByteDance Beijing, China

Tax Analyst Intern, Financial Department Jul 2022 – Oct 2022

Prepared monthly VAT drafts based on financial statements and other documents, independently completed tax return forms.

Maintained Corporate Income Tax System using for tax analysis, consolidated tax data from all branches

Recorded inquiries and requirements from tax authorities, prepared materials for tax audits, assisted tax officers in communicating and negotiating tax-related matters with authorities, and responded to questions raised by the tax bureau.

Analyzed and validated over 500,000 individual income tax records using Excel (VLOOKUP, pivot tables), identifying potential tax risks and enhancing data accuracy for reporting. Grant Thornton Beijing, China

Tax Intern, Department of Tax Nov 2021 – Feb 2022

Conducted preparation and review of tax returns for about 40 subsidies tailored to needs of investment management firms, including organizing accounting vouchers, updating input VAT ledger

Compiled detailed expense schedules and reconciliations aligned with accounting standards, supporting accurate financial reporting and audit documentation.

PROJECTS

Corporate Finance Case Study Feb 2025 - May 2025

Financial Analysis of the Return of USEC

Developed a DCF model and comparable company analysis using Excel to assess whether USEC was fairly valued based on projected cash flows

Conducted a comprehensive investment analysis, calculating NPV, IRR, and Payback Period to determine the project ’s investment potential.

Analysis of the Financial Position of Clarkson

Forecast the future financial situation based on the business situation, analyzed the company’s capital structure, prepare the budget, and identify the optimal amount of debt and potential optimizations to enhance financial health and efficiency

Evaluated Clarkson’ s financial position and stability by calculating, interpreting key financial ratios (liquidity, profitability, and leverage ratios) and performance metrics, and then identified trends and features SKILLS & OTHERS

Applications: Excel(VLOOKUP, pivot table), Python, MATLAB, Stata, SPSS, VBA, SQL, Tableau, Bloomberg Languages: English (Professional Working Proficiency), Mandarin (Native) Financial Modeling: Experienced in creating DCF models, KPI dashboards, and budget forecasts using Excel Activities: Publicity Committee Chair at Student Union, Vice President at University Arts Group Interests: Jogging, Music composition and arrangement Certifications: Certified Junior Accounting Professional

Contact this candidate