Attronica Externship via ExternI am strengthening my resume through finance-focused externship work and coursework to become competitive for internships and entry roles.
Portfolio of externship deliverables and coursework related to FP&A and private company valuation, showing applied modeling and analysis practice.
.png)
Attronica · ✅ Verified by Extern · ⏱️ In progress
A 40-year-old, $80M family-owned IT firm is preparing to sell — and they need real FP&A work to back it: clean financials, a defensible forecast, and a valuation. Organize the books, model the forecast, and deliver a valuation that lands on the CEO's desk and on a buyer's table.
Built an Excel DCF model to evaluate intrinsic equity value, incorporating operating assumptions, WACC, cash flows, and valuation outputs. Calculated a 5.70% WACC using CAPM, beta, risk-free rate, equity risk premium, and after-tax cost of debt to support valuation analysis. Performed sensitivity and scenario analysis across key assumptions, producing a valuation range of $53.52–$120.70 per share and assessing downside/upside risk. Compared estimated intrinsic value of $71.40 with a $64.42 market price to develop and communicate an investment conclusion.
I am strengthening my resume through finance-focused externship work and coursework to become competitive for internships and entry roles.
I am Bhavya Mehta, a fourth-year bachelor's student at the University of Cincinnati. I have limited professional experience and am focused on building my resume and competitiveness for jobs and internships. I completed the Attronica Financial Planning & Analysis and Private Company Valuation externship.
Externships
Attronica Financial Planning & Analysis and Private Company Valuation Externship
In progress
Experience
Associate
Columbia Sportswear · Aug 2026 – Present
Crew Member
Chipotle · Sep 2024 – Jun 2026
Education
University of Cincinnati, Carl H. Lindner College of Business
Bachelor of Business Administration, Finance Major | Accounting Minor · Class of 2027
Skills
✅ Verified by Extern · ⏱️ In progress
A 40-year-old, $80M family-owned IT firm is preparing to sell — and they need real FP&A work to back it: clean financials, a defensible forecast, and a valuation. Organize the books, model the forecast, and deliver a valuation that lands on the CEO's desk and on a buyer's table.
The externship treated a 40-year-old, $80M family-owned IT firm as the case organisation and required FP&A and valuation deliverables. The work involved organizing historical financials, building a defensible forecast model, and producing a valuation-ready output. Deliverables included cleaned financial statements, a forecast model, and a valuation report.
I completed a sequence of practical FP&A tasks for the engagement, from administrative setup through financial cleanup and valuation modeling. Below are the specific items I delivered.
Built an Excel DCF model to evaluate intrinsic equity value, incorporating operating assumptions, WACC, cash flows, and valuation outputs. Calculated a 5.70% WACC using CAPM, beta, risk-free rate, equity risk premium, and after-tax cost of debt to support valuation analysis. Performed sensitivity and scenario analysis across key assumptions, producing a valuation range of $53.52–$120.70 per share and assessing downside/upside risk. Compared estimated intrinsic value of $71.40 with a $64.42 market price to develop and communicate an investment conclusion.
Conducted customer and market research to evaluate credit-card product positioning, customer needs, adoption drivers, and competitive considerations. Analyzed projected adoption, profitability, and usage trends to support a data-driven recommendation. Developed a PowerPoint recommendation deck for senior leadership, translating analysis into concise business conclusions.
Directed fundraising strategy and developed financial projections for SafeSip to evaluate the business model and communicate expected performance. Presented product strategy and financial projections to an audience of 100+.
Compete in Bloomberg’s global student trading competition, managing a simulated portfolio against participants worldwide. Build and execute trade ideas by analyzing company fundamentals, valuation, and market catalysts to identify mispriced securities. Manage risk through position sizing, diversification, and disciplined exit rules to protect capital and improve risk-adjusted returns.
