Your application

Please complete the following fields to be considered for this project.

Please fill in this required field.
Please fill in this required field.
Please fill in this required field.
Please fill in this required field.
Please fill in this required field.
How much commitment will you have to this project?
Please select an option.
Are you available to dedicate 1-2 hours per week to the Build Project?
Please select an option.
Your application has been 
successfully submitted!
Explore more projects
Close
You already submitted an application for this project.
Explore more projects
Close
There was an error submitting your form. Please try again later or contact us.
Oops! Something went wrong while submitting the form.

This project is no longer accepting applications. Subscribe to our newsletter to be notified of new projects!

Get updates
Public Equity Valuation and Investment
Bill Cui
Bill Cui
Get updates
Register today
Apply now

Public Equity Valuation and Investment

Learn to evaluate a publicly traded company and produce an investment recommendation.

Register today
Apply now
Tuesdays
 at
8:00
P.M.
 ET /
5:00
P.M.
PT
8 weeks, 2-3 hours per week
Intermediate
No experience required
No experience required
Some experience required
Degree and experience required

Description

Detailed analyses and accurate predictions based on fundamental understanding of a company are key to becoming a successful public equity investing professional. In this Build Project, you will wear the hat of a fundamental analyst and develop investment recommendations about a publicly traded company’s stock. Under the supervision of an experienced industry expert, you will dive deep into understanding the company’s business model, evaluating its business strategies and competitive landscapes, analyzing its financial data, and predicting its future growth potential. You will also become familiar with tools such as Python to conduct statistical analysis on macroeconomic data and apply various valuation methods in Excel to support your investment theses. The analytical and modeling skills gained from this project will help you become more competitive in the recruiting process for a junior equity investment role.

Session timeline

  • Applications open
    December 1, 2024
  • Application deadline
    January 15, 2025
  • Project start date
    Week of July 8, 2024
    Week of
    February 3, 2025
  • Project end date
    Week of

What you will learn

  • Understand how to read and interpret company financial models
  • Leverage macroeconomic data in statistical analysis through Python to understand the current business environment a company operates in
  • Build detailed financial models in Microsoft Excel to arrive at a fair value for a company’s publicly traded stock
  • Create and deliver a PowerPoint presentation with clear investment theses based on quantitative and qualitative analyses

Project workshops

1
Introduction to Public Market Investing
2
Understanding Business Models and Drivers
3
Industry Analysis and Competitive Landscape
4
Relevant Macroeconomic Data Analysis
5
Deep Dive into Company Fundamentals
6
Quantitative Valuation
7
Risks and Scenario Analysis
8
Final Presentations

Prerequisites

  • Interest in the financial market (e.g. tracking daily market news through reputable sources) and willingness to perform detailed due diligence
  • Basic skills and experiences with Excel and PowerPoint
  • Experience with basic Python (conditions, loops, pandas, matplotlib) or another statistical/coding tool

Sign up today

Get access to all of our Build projects, including this one, by creating your Build account!

Register today
Log in

Apply to

Bill

's project today!

Get started by submitting your application.

Apply now

Stay updated!

Subscribe to our newsletter to be notified when projects reopen!

Please fill in this required field.
By clicking “Subscribe” you agree to our Terms of Services and Privacy Policy.

Thanks for subscribing!

We'll notify you when projects reopen. In the meantime, you can explore our resources and learn more about our Fellows.

Discover our articles
There was an error submitting your form. Please try again later or contact us.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
About the expert

Bill Cui is a Finance Build Fellow at Open Avenues Foundation, where he works with students leading projects in financial analysis. Bill is a fundamental analyst at Citadel Securities, where he focuses on conducting financial analysis on companies and commodities. Bill has over three years of experience in the finance field. He has covered assets in Industrials, Materials, and Energy sectors. He holds a Bachelor's degree in Economics and Quantitative Social Science from Dartmouth College. A fun fact about Bill is that he loves hiking and playing soccer.

Visit
Bill
's Linkedin
More like this Project