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
Finance & Economics · Santa Clara University
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.
Three kinds of work I take on, in class, in teams and for companies.
Valuation, underwriting and pitch models built on the case's own definitions, not textbook shortcuts.
From messy public data to a map and a regression that explains what's happening and why.
Brand websites for fintech companies, from first draft to a live custom domain with HTTPS.
Work with companies alongside my coursework at Santa Clara.
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.
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.
Santa Clara University
Coursework across financial modeling, real estate finance and economics, investor pitches, strategy and spatial analysis.
Team and individual work where I owned a clear piece of the analysis.
Led the investment thesis and projected performance for a property investment case, carrying the analysis into later course topics.
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).
Built the business model and market opportunity sections of a startup pitch and financial model, and presented the final recommendation.
Industry analysis of customizable fast-casual restaurants for a capstone strategy project, plus the Ford "Disruption in Detroit" case.
Research on how rate hikes, rate cuts and inflation shifts drive equity prices over time, delivered as a report and presentation.
Free cash flow and DCF model for a valuation case, with CAPM inputs for the risk-free rate, equity risk premium and beta.
What I use to get from a question to an answer.
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.