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
Build a Working 5-year Financial Model
Dana Rakhimzhanova
Dana Rakhimzhanova
Get updates
Register today
Apply now

Build a Working 5-year Financial Model

Analyze organic growth potential of a publicly traded company.

Register today
Apply now
Mondays
 at
7:00
P.M.
 ET /
4: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

In this Build Project, you will wear the hat of a Corporate Strategy Team Leader and will be asked to analyze the organic growth potential of a publicly traded company. Under the supervision of an experienced Build Fellow, you will learn how to look at a company’s financial statement, how to do an industry analysis and how to come up with reasonable assumptions to project accurate growth. You will become familiar with financial modeling techniques that are widely used across a variety of firms in any industry. This work is very common in the roles of financial analysts, senior financial analysts, corporate finance analysts and many others.

Session timeline

  • Applications open
    May 27, 2024
  • Application deadline
    June 23, 2024
  • Project start date
    Week of July 8, 2024
    Week of
    July 8, 2024
  • Project end date
    Week of

What you will learn

  • Learn how to create work products that are formatted well and presentable in a workplace environment
  • Learn how a to build a 5-year financial model and create financial projections to deliver your analysis and support your insights
  • Become familiar with financial analysis, key financial metrics and various research methodologies that will aid you in your conclusion

Project workshops

1
Introductions and initial setup
2
Data review
3
Assumptions review
4
Model Setup
5
Model Build
6
Discount Rate and Terminal Value
7
Valuation and Market sensitivity
8
Presentations

Prerequisites

  • Basic/intermediate knowledge of Financial Analysis Principles: you should be able to analyze financial statements, understand ratio analysis and business principles. These topics are usually covered within Corporate Finance classes or similar.  
  • Basic knowledge of Excel: you should be able to create Excel formulas (such as “sum” and “total” and understand relational datasets.  
  • Basic knowledge of Power Point Skills
  • Other prerequisites: before the project starts, you'll need to have Excel and PowerPoint installed on your computer.  

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

Dana

'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

Dana is a Finance Build Fellow at Open Avenues, where she works with students leading projects in finance.

Dana has 6 years of finance experience, and is currently a Finance Manager at Audax Group, a middle-market private equity company. Dana has worked across multiple industries, such as banking, wealth management, consumer staples and manufacturing. Dana holds a Bachelor degree from Vanderbilt University and 2 Masters degrees from IE Business School and Babson College.

She speaks 4 languages and is currently studying Spanish quite intensively. She loves to cook, run and travel.

Visit
Dana
's Linkedin
More like this Project