Attronica logoAttronica Externship via Extern·🟢 Open to work

First-year finance student building practical experience

I study finance at George Mason University and am gaining hands-on experience while preparing for a professional career in finance.

Work samples

A collection of coursework and early practical tasks that show how I apply finance concepts while I continue my studies and build experience.

  • Spire Financial Modeling Tool, https://spire-pi.vercel.app
    Spire Financial Modeling Tool, https://spire-pi.vercel.app

    Built and deployed a five-module finance platform in TypeScript and React covering portfolio risk, company valuation, M&A analysis, stock screening, and personal finance tracking. Implemented DCF, LBO, and M&A accretion/dilution models from the underlying financial formulas, drawing company data from SEC EDGAR through a weekly automated pipeline. Developed a Monte Carlo engine running thousands of simulated trials to model the full range of portfolio outcomes, weighing downside risk against expected return. Designed a SQL-based stock screener ranking 189 companies against sector medians, verifying results against each company's 10-K filing.

    TypeScriptReactSQL
  • Attronica Financial Planning & Analysis and Private Company Valuation Externship
      Attronica Financial Planning & Analysis and Private Company Valuation Externship
    Attronica logo

    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

I study finance at George Mason University and am gaining hands-on experience while preparing for a professional career in finance.

I am Kerolous Aziz, a first-year finance student at George Mason University. I have some early work experience and am exploring how finance skills and real projects fit together as I prepare for a career in the field.

Externships

Attronica Financial Planning & Analysis and Private Company Valuation Externship

In progress

Experience

Financial Operations Manager

Rita & Brother LLC, Aldie, VA · Feb 2024 – Present

Education

George Mason University, Fairfax, VA

Bachelor of Science in Finance and Accounting, Honors College Student · Class of 2029

Skills

Introductory finance conceptsFinancial analysis basicsSpreadsheet proficiencyFinancial courseworkLearning and adapting to practical workAccountingExcelSQL Analytics

Spire Financial Modeling Tool, https://spire-pi.vercel.app

Built and deployed a five-module finance platform in TypeScript and React covering portfolio risk, company valuation, M&A analysis, stock screening, and personal finance tracking. Implemented DCF, LBO, and M&A accretion/dilution models from the underlying financial formulas, drawing company data from SEC EDGAR through a weekly automated pipeline. Developed a Monte Carlo engine running thousands of simulated trials to model the full range of portfolio outcomes, weighing downside risk against expected return. Designed a SQL-based stock screener ranking 189 companies against sector medians, verifying results against each company's 10-K filing.

TypeScriptReactSQL
View all work

✅ 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 produced cleaned financial statements, a forecast model, and a valuation for a 40-year-old, $80M family-owned IT firm preparing for sale. The work involved normalizing accounting records, constructing a multi-year financial forecast, and calculating a valuation using standard approaches.

  Attronica Financial Planning & Analysis and Private Company Valuation Externship

What I've accomplished

I produced a formula-driven workbook consolidating FY2022–FY2025 audited statements, migrated hardcoded figures to an Inputs tab, implemented income statement, balance sheet, cash flow, equity rollforward, ratio analysis, and 15 audit checks to deliver a single auditable model.

Project breakdown

I consolidated FY2022–FY2025 audited statements into a formula-driven workbook, moved all hardcoded values to an Inputs tab, implemented the income statement, balance sheet, cash flow, equity rollforward, ratio analysis, and 15 audit checks, producing a single auditable model.

View all work