Attronica logoCurrently an Extern @Attronica
Cooper Hildebrand portrait

Financial planning, analysis, and private company valuation

I apply FP&A and private company valuation techniques learned in the Attronica externship to solve financial questions and model outcomes.

Work samples

Portfolio of models and analyses from the Attronica externship, showing financial forecasts, sensitivity testing, and valuation outputs for private-company cases.

  • 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 apply FP&A and private company valuation techniques learned in the Attronica externship to solve financial questions and model outcomes.

I'm Cooper Hildebrand. I completed the Attronica Financial Planning & Analysis and Private Company Valuation Externship, where I worked on financial planning, analysis, and valuation methods for private companies.

Externships

Attronica Financial Planning & Analysis and Private Company Valuation Externship

Attronica

Experience

Intern

Collective Advisors · May 2026 - Aug 2026

Education

University of Colorado Boulder

Accounting and Finance · Class of 2029

Skills

Financial planning and analysisPrivate company valuationFinancial modelingForecasting and scenario analysisSensitivity and valuation testing

✅ 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 delivered financial-cleanup, forecasting, and valuation work for a privately held IT company preparing for sale. The work involved organizing historical financial statements, building a multi-year forecast model, and producing a valuation built from those outputs. Deliverables included cleaned financial schedules, a forecast model, and a valuation summary.

Attronica Financial Planning & Analysis and Private Company Valuation Externship

What I've accomplished

I delivered a single workbook consolidating five years of audited statements, an inputs-driven financial model with IS/BS/CFS, an equity rollforward, an 8-ratio analysis, and 15 audit checks, all documented with data sources and model conventions.

Project breakdown

I consolidated five years of audited statements into a single workbook, moved all hardcoded values to an Inputs tab, implemented formula-driven IS/BS/CFS, added an equity rollforward, 8-ratio analysis, and 15 audit checks. The workbook documented conventions, data sources, and known limitations.

View all work