HGHenry Gui

Finance & Economics · Santa Clara University

I turn financial analysis into business decisions.

I'm Henry Gui, a Finance and Economics double major at Santa Clara University in Silicon Valley.

I underwrite properties, build pitch models, map data in QGIS and R, and help fintech brands launch online. Next stop: management and analytics consulting.

Where I can help

Three kinds of work I take on, in class, in teams and for companies.

Finance

Financial analysis & modeling

Valuation, underwriting and pitch models built on the case's own definitions, not textbook shortcuts.

  • DCF and free cash flow models
  • CAPM and cost of capital
  • Real estate underwriting
Data

Data & spatial analytics

From messy public data to a map and a regression that explains what's happening and why.

  • QGIS mapping and spatial joins
  • Regression analysis in R
  • Industry and market sizing
Launch

Digital launches for businesses

Brand websites for fintech companies, from first draft to a live custom domain with HTTPS.

  • Bilingual websites (EN · 中文)
  • Domain, DNS and hosting setup
  • Brand and logo refresh

Experience

Work with companies alongside my coursework at Santa Clara.

2026

Website & digital launch

Taozixiong (桃子熊) · Fintech, Hong Kong · New York

Designed and launched the company's bilingual website for its multi-currency virtual card business, and set up the custom domain, hosting and secure connection.

taozixiong.global ↗
2026

Brand & website launch

Luminal Ads · Virtual cards for advertisers

Rebuilt the logo in high resolution and launched a bilingual site covering ad spend, AI subscriptions, pricing, compliance and FAQ.

luminaladpay.com ↗
Current

Finance and Economics, double major

Santa Clara University

Coursework across financial modeling, real estate finance and economics, investor pitches, strategy and spatial analysis.

Selected projects

Team and individual work where I owned a clear piece of the analysis.

FNCE 128 · Real Estate Finance

Ridgeline Terrace revenue underwriting

Led the investment thesis and projected performance for a property investment case, carrying the analysis into later course topics.

UnderwritingPro formaInvestment thesis
ECON 156 · Real Estate Economics

Who voted for San Francisco's Proposition L?

Joined precinct votes to census tracts with area weighting across 712 areas, mapped the results, and found renter and minority shares both significantly predicted support (p < 0.001).

QGISROLS regression
FNCE 143

TAbot investor pitch

Built the business model and market opportunity sections of a startup pitch and financial model, and presented the final recommendation.

Market sizingPitch deckFinancial model
MGMT 162

Chipotle and U.S. fast-casual industry analysis

Industry analysis of customizable fast-casual restaurants for a capstone strategy project, plus the Ford "Disruption in Detroit" case.

Industry analysisStrategyCase presentation
FNCE 124

What moves U.S. stock prices?

Research on how rate hikes, rate cuts and inflation shifts drive equity prices over time, delivered as a report and presentation.

Macro researchEquities
Financial modeling

DCF valuation in Excel

Free cash flow and DCF model for a valuation case, with CAPM inputs for the risk-free rate, equity risk premium and beta.

ExcelDCFCAPM

Skills & tools

What I use to get from a question to an answer.

Finance

  • Valuation and DCF
  • Real estate underwriting
  • Pitch decks and models

Analytics

  • Excel modeling
  • R and regression
  • QGIS and GIS methods

Digital

  • HTML websites
  • Domains, DNS, hosting
  • Brand assets

Languages

  • English
  • Mandarin Chinese

What are you working on?

Recruiting for consulting or analytics, launching a company website, or looking for a teammate who builds the model and the deck. I'd like to hear about it.

Email
henryguiceo@gmail.com
Based in
Santa Clara, California · Bay Area