Attronica logoAttronica Externship via Extern

Accounting student and entry-level sales associate building finance skills

Sophomore at Baruch CUNY studying accounting, working retail while completing FP&A and valuation externships and virtual audit experience.

Work samples

Portfolio includes an FP&A and private-company valuation externship for a family-owned IT firm and a PwC audit virtual experience, with deliverables built in Excel and presentation tools.

  • 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

Sophomore at Baruch CUNY studying accounting, working retail while completing FP&A and valuation externships and virtual audit experience.

I am Ryan H, a sophomore at Baruch College studying accounting at the Zicklin School of Business. I work as a Sales Associate at Primark and I'm building finance and analysis experience through externships and virtual programs while I complete my BBA.

Externships

Attronica Financial Planning & Analysis and Private Company Valuation Externship

In progress

Experience

Sales Associate

Primark · November 2023 - Present

Participant

PwC Audit Virtual Experience Program (Forage) · September 2025

Education

Baruch College/CUNY, Zicklin School of Business

Bachelor of Business Administration · Class of 2029

Skills

Microsoft ExcelMicrosoft PowerPointMicrosoft WordGoogle DocsGoogle SlidesCanva

✅ 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 organized historical financials, constructed a multi-year forecast model, and produced a valuation for a 40-year-old, family-owned IT firm preparing for sale. Work included reconciling accounts, building drivers-based projections, and calculating valuation outputs using standard approaches.

  Attronica Financial Planning & Analysis and Private Company Valuation Externship

What I've accomplished

I produced a formula-driven workbook that consolidated five years of audited statements, implemented an Inputs tab, built income statement, balance sheet, cash flow, equity rollforward, ratio analysis, and 15 automated audit checks.

Project breakdown

I consolidated five years of audited statements into a formula-driven workbook, set up an Inputs tab with sourced values, built the income statement, balance sheet, cash flow, equity rollforward, ratio analysis, and 15 automated audit checks. The model produced audited financial schedules and a…

I analyzed Attronica's FY customer, expense, and cash data, then wrote a one-page memo for leadership that identified customer concentration, rising wage-driven operating costs, and an 87-day cash conversion cycle, and recommended Q1 actions.

View all work