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
Develop a Budget for an Airline’s Inflight Group
Nidhi Trambadia
Nidhi Trambadia
Get updates
Register today
Apply now

Develop a Budget for an Airline’s Inflight Group

Prepare multifaceted financial analysis to plan operating expenses for an airline’s Inflight department.

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

Just like in our personal lives, budgeting for an organization is an important process that entails excellent communication, analytical and personable skills. In this Build Project, you’ll wear the hat of a Financial Analyst and prepare a reasonable hypothetical budget for an airline’s Inflight group. Under the supervision of an experienced Build Fellow, you'll develop multifaceted financial models and conduct analysis with tools most commonly used in the industry: Microsoft Excel and PowerPoint. You'll also become familiar with aviation terminology and advanced modeling techniques like block hours/staffing and Excel model ‘dials’, respectively. All this will happen in an environment that simulates the operations of a real Financial Planning and Analysis (FP&A) team.

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 use Microsoft Excel Advanced formulas for data analysis.
  • Prepare budget using Microsoft Excel and present outcome using Microsoft PowerPoint to a C-Suite replica.
  • Learn the basics of airline operations/terminology and tailored details pertaining to union contractual language.

Project workshops

1
Introductions
2
Introduction to Aviation
3
Introduction to Financial Statements
4
Microsoft Excel Exercises
5
Introduction to Case Study: Part One
6
Introduction to Case Study: Part Two
7
Introduction to Case Study: Part Three
8
Final Presentations

Prerequisites

  • Basic/intermediate knowledge of Microsoft Excel: you should be able to use formulas such as IF Statements (SUMIF/COUNTIF), VLOOKUP, and formatting (for example, converting data into pivot tables).  
  • Basic knowledge of Microsoft PowerPoint: you should be able to build charts to visually present data and explain these visual aids in a summary on the same slide (helpful tip: always assume your audience does not know everything you know).  
  • Other prerequisites: before the project starts, you'll need to have Microsoft 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

Nidhi

'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

Nidhi Trambadia is a Finance Build Fellow at Open Avenues, where she works with students leading projects in Finance. Nidhi is a Sr. Financial Analyst at Air Wisconsin Airlines where she works on developing and analyzing multifaceted financial models and budgets to support decision making. Nidhi has over four years of experience in Finance and Aviation/Airlines. She has also worked with an aftermarket aircraft parts company and interned with another US airline. She holds multiple Master's degrees in Aviation Finance and Business Administration.A fun fact about Nidhi: she has spent almost a decade in each of three separate countries: India, Kenya and the US!

Visit
Nidhi
's Linkedin
More like this Project