Advanced Excel Modeling Capstone Project
Executed an advanced Excel capstone project focused on financial analysis, model building, data organization, and efficiency using industry-standard Excel functions and shortcuts
Excel
Attronica Externship via ExternYM
Finance student focused on FP&A and valuation
Sophomore at University of Houston building hands-on FP&A and private company valuation experience through an Attronica externship.
Work samples
Portfolio of coursework and deliverables from the Attronica FP&A and private company valuation externship, showing models, analyses, and learning outcomes.
Advanced Excel Modeling Capstone Project Attronica Financial Planning & Analysis and Private Company Valuation Externship .png)
Attronica · ✅ Verified by Extern · ⏱️ In progress
Attronica Financial Planning & Analysis and Private Company Valuation Externship
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.
Financial ModelingFinancial Statement AnalysisExcelValuationForecasting
About me
Sophomore at University of Houston building hands-on FP&A and private company valuation experience through an Attronica externship.
I am Yahyobek Mamirov, a sophomore Finance student at the University of Houston pursuing a bachelors degree. I have limited work experience and am completing the Attronica Financial Planning & Analysis and Private Company Valuation externship to build practical finance skills.
Externships
Attronica Financial Planning & Analysis and Private Company Valuation Externship
In progress
Experience
Individual Investor
Personal Portfolio Management · December 2023 - Present
Concierge
Thames Services · May 2025-August 2025
Education
C. T. Bauer College of Business, University of Houston
Bachelor of Business Administration in Finance · Class of 2028
Lone Star College Systems
Associate of Arts in Business Administration
Skills
Financial planning and analysis (FP&A)Private company valuationUndergraduate finance courseworkFinancial modeling basicsMicrosoft Excel
Advanced Excel Modeling Capstone Project
Executed an advanced Excel capstone project focused on financial analysis, model building, data organization, and efficiency using industry-standard Excel functions and shortcuts
Excel
✅ Verified by Extern · ⏱️ In progress
Attronica Financial Planning & Analysis and Private Company Valuation Externship
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.
Financial ModelingFinancial Statement AnalysisExcelValuationForecasting
Overview
The externship addressed FP&A and private company valuation for a family-owned IT business preparing for a sale. The work involved organizing historical financials, building a forecast model, and producing a valuation. Deliverables included cleaned financial statements, a defensible forecast model, and a valuation report.
What I've accomplished
I carried out the initial confidentiality step required to access the company's financial data so I could proceed with transactional cleanup, forecasting, and valuation work.
