Extern logoCurrently an Extern @Extern
Edwin Gutierrez Hernandez portrait

First-Gen Student at CUNY Hunter | B.S. Accounting, Econ Minor | Aspiring CPA & Auditor

I'm an accounting student at CUNY Hunter College, building the skills, confidence, and technical skills for a successful career in public accounting and CPA license

Work samples

I have engaged in projects like financial modeling, combining Excel and AI for real-world applications in finance.

  • Excel & AI Financial-Modeling Sprint
    Extern logo

    Extern · ✅ Verified by Extern · ⏱️ In progress

    Excel & AI Financial-Modeling Sprint

    Build a three-statement model, forecast with drivers, run a DCF, and pitch a company like a pro. In this 3-week sprint, GPT helps you work faster—so you can walk away with real valuation skills and a polished investor deck.

  • Strategy & Outreach Plan

    OptiPath Advising · Aug 2026

    Strategy & Outreach Plan

    At OptiPath Advising, a healthcare consulting firm, I developed and executed an outreach strategy to attract new clients. I evaluated current messaging, identified target healthcare organizations, and created a streamlined messaging framework that effectively communicated OptiPath's value.

    B2B MarketingChatGPTEmail MarketingCommunicationBusiness Strategy

About me

I'm an accounting student at CUNY Hunter College, building the skills, confidence, and technical skills for a successful career in public accounting and CPA license

I'm a first-generation Mexican American junior at Hunter College (CUNY), pursuing a B.S. in Accounting with an Economics minor and Business Studies certificate while working toward my CPA. Experienced in nonprofit data reconciliation, financial modeling, DCF valuations, real estate underwriting, and AI-assisted outreach. Selected for EY, McKinsey, RSM, BASTA, and BDO programs. Seeking accounting opportunities to learn, contribute, and grow.

Externships

Excel & AI Financial-Modeling Sprint

Extern

Experience

Development & Events Marketing Intern

St. Nicks Alliance · Jul 2026 - Aug 2026

Food Service Worker

Chopt Creative Salad Company · Jul 2026 - Aug 2026

Floor Staff

Regal Cinemas · Feb 2026 - Jun 2026

Retail Sales Associate

Burlington Stores, Inc · Jun 2025 - Dec 2025

Education

Hunter College CUNY

B.S. Accounting | Minor: Economics, Business Studies · Class of 2028

Skills

Financial ModelingExcelAI IntegrationValuation SkillsAccountingBusiness StrategyBusiness DevelopmentChatGPTCommunication

✅ Verified by Extern · ⏱️ In progress

Excel & AI Financial-Modeling Sprint

Build a three-statement model, forecast with drivers, run a DCF, and pitch a company like a pro. In this 3-week sprint, GPT helps you work faster—so you can walk away with real valuation skills and a polished investor deck.

Overview

The externship produced a three-statement financial model and a DCF-style valuation for a publicly filed tech company. Work began with a one-page synthesis of the company's 10-K, then historical cash flows and balance-sheet ties were reconstructed and documented. Finally, a Driver tab translated assumptions into a linked three-year Income Statement, Balance Sheet, and Cash Flow.

Excel & AI Financial-Modeling Sprint

What I've accomplished

I delivered a model-ready one-page company snapshot, a reconciled cash-flow mapping that ties to the balance sheet, and a Driver tab powering a linked three-year forecast used in a DCF-style valuation.

Project breakdown

I read the company 10-K and condensed its business into a one-page snapshot. I summarized segments (Mobility, Benefits, Corporate Payments), revenue streams, key risks, competitors, management tone, and listed positives and red flags.

Google Docs
Access

I extracted the cash flow lines from the filings, mapped each item to the required CF categories, and built CF_Final with formulas that aggregated period flows and tied cash at beginning/end to the balance sheet. I documented category rules and FX mapping.

Google Sheets
Access

The task set a company forecast, I built a Driver tab in Excel, translated assumptions into model line items, and linked the Driver inputs to a three-year Income Statement, Balance Sheet, and Cash Flow so changes updated across the model.

View all work
Back to work

Strategy & Outreach Plan

At OptiPath Advising, a healthcare consulting firm, I developed and executed an outreach strategy to attract new clients. I evaluated current messaging, identified target healthcare organizations, and created a streamlined messaging framework that effectively communicated OptiPath's value.

B2B MarketingChatGPTEmail MarketingCommunicationBusiness Strategy

Overview

At OptiPath Advising, a healthcare consulting firm, I developed and executed an outreach strategy to attract new clients. I evaluated current messaging, identified target healthcare organizations, and created a streamlined messaging framework that effectively communicated OptiPath's value.

Strategy & Outreach Plan

What I've accomplished

I built messaging around their care management platform, centered on four value drivers: higher quality scores, reduced readmissions, streamlined preventive care, and increased recurring provider revenue. Using AI tools, I crafted and sent a personalized outreach campaign to a consolidated FQHC target list, reaching 500+ emails at a 4% response rate.

View all work