Professional Resume Template for
Financial Analyst Intern
Jonathan R. Mercer
Chicago, IL
(312) 555-0143
jonathan.mercer@email.com
linkedin.com/in/jonathan-mercer | github.com/jonathanmercer
Professional Summary
Methodical Financial Analyst Intern with 2 years of internship and academic project experience building financial forecasting models, performing variance analysis, and automating corporate treasury workflows. Proficient in advanced Excel financial modeling, SQL database querying, and Power BI visualization. Successfully optimized a division cash flow forecasting tool to improve forecast accuracy by 14% and designed a SQL query structure that reduced weekly reporting run times by 12 hours. Collaborates effectively with cross-functional treasury, accounting, and sales operations teams to ensure compliance with US GAAP guidelines.
Work Experience
Financial Analyst Intern — Valor Capital Partners
Chicago, IL | May 2025 – Present
- Developed a comprehensive 3-statement financial model for a mid-market logistics client in Excel, improving revenue forecasting precision by 12% over 6 months.
- Automated weekly cash reconciliation and treasury reporting for 14 bank accounts using VBA and SQL, reducing manual data entry tasks by 9 hours per week.
- Conducted monthly budget-to-actual variance analysis on a $4.2M departmental operating budget, flagging $180,000 in projected cost overruns for management review.
- Prepared 12 financial presentation decks for executive leadership, summarizing key cash flow trends and working capital metrics to support strategic allocation decisions.
Corporate Finance Intern — Apex Logistics Group
Chicago, IL | September 2024 – April 2025
- Analyzed historical working capital trends using SQL and Power BI, identifying $240,000 in idle cash reserves and recommending optimization pathways.
- Constructed a division-level cash flow forecasting tool that reduced the standard deviation of historical forecast variance from 8% to 2.5% over a 3-month trial.
- Audited 150+ corporate operational expense records for vendor contract compliance, detecting $34,000 in billing discrepancies and retrieving 100% of overpayments.
- Assisted with the quarterly corporate financial consolidation process by reconciliating 8 subsidiary balance sheets, reducing the overall consolidation timeline by 2 days.
Education
Bachelor of Science in Finance
Illinois Institute of Technology · Chicago, IL · 2025
Skills
Financial modeling, Variance analysis, Budget forecasting, Cash flow reconciliation, Working capital management, Corporate treasury, US GAAP, Microsoft Excel (VBA), SQL, Power BI, Tableau, Bloomberg Terminal, QuickBooks, Jira
Projects
Corporate Valuation and LBO Model Development
Role: Financial Analyst Intern (Academic)
Tools: Microsoft Excel, Capital IQ, Bloomberg Terminal
Constructed a comprehensive Leveraged Buyout (LBO) model for a target retail company, yielding an estimated IRR within 1.5% of actual transaction outcomes.
Portfolio Optimization Simulation
Role: Treasury Analyst Lead (Student)
Tools: Python (Pandas/NumPy), MS Excel, Power BI
Designed a mean-variance optimization model for a $500,000 student-managed investment fund, increasing Sharpe ratio by 18% over a 2-semester period.
Certifications
- Financial Modeling & Valuation Analyst (FMVA) - CFI (2025)
- Bloomberg Market Concepts (BMC) (2024)
Additional information
- Languages: English (Native), Spanish (Conversational)
- Volunteer Work: Financial literacy tutor for local high school programs (2024-present)
- Availability: Immediate
Job Market Insights
Market data and opportunities for
Financial Analyst Intern
Job Market Insights
$42,000
-
$68,000
Avg:
$54,000
Growth Outlook:
The employment of financial analysts is projected to grow by 6% from 2024 to 2034, which is faster than the average for all occupations. The demand is driven by the increasing complexity of corporate financial structures, the need for data-driven strategic planning, and the expansion of investment products. Internships play a critical role in this market, serving as the primary pipeline for corporate treasury and investment management divisions to secure entry-level talent with hands-on forecasting, Excel modeling, and data extraction capabilities.
6% growth over 10 years
Key Skills Required
Focus on these skills when customizing your resume for recruiter screenings.
Search Jobs
Explore live openings for
Financial Analyst Intern
roles and tailor your resume to match the market demand.
Search
Financial Analyst Intern
FAQ
Common questions about the
Financial Analyst Intern
position