complete revenue & cost model

On the modelling part, could someone be so kind to post or PM the parte of a model that builds up in detail the revenue and cost lines in the income statement (just that part, i am not looking for a 3 state model plus valuation) ? The fact is that sometimes i have a wealth of data and observstions to pour into modelling but i can't seem to manage to assemble them in a sensibile mathematical way. For instance, in the airline industry , i may have All kinds of views on passenger growth, cost per seat, load factors, market share, supply capacity, etc... But they don't do me any good if i can't translate in sensibile Financial inputs. (Also to test different thesis eith differenti numbers)

As much as i realize modelling may vary a great deal among different sectors, i am just trying to find some model to begin diving a little deeper.

Thank you for time.

 

Take a look at some quarterly press releases for the companies you are interested in modeling. They will give you operating data for the quarter. From there, you should be able to pick out a couple of revenue/cost drivers for your operating model.

Disclaimer for the Kids: Any forward-looking statements are solely for informational purposes and cannot be taken as investment advice. Consult your moms before deciding where to invest.
 
captainkoolaid:

Take a look at some quarterly press releases for the companies you are interested in modeling. They will give you operating data for the quarter. From there, you should be able to pick out a couple of revenue/cost drivers for your operating model.

ah I see I could not explain myself. I did my research and looked over the presentations and much over to address how sensible those business inputs were. what I cannot seem to do is to use such data (and relative projections) and link them to financial inputs in order to make a model for the main stuff: revenue and major cost lines.

(capex for instance is relatively easy in this case when you approximately know how they will scale the purchase of the airplanes: trickier to model if some oversupply will result in a higher cost per unit for instance)

 

Use the line items that they report on their I/S and use that as a guide. Most of the info they give you on the press release should allow you to at least model revenue, interest expense, taxes, etc. If you cant figure out how to model costs you could always do revenue * %margin to get op income.

Disclaimer for the Kids: Any forward-looking statements are solely for informational purposes and cannot be taken as investment advice. Consult your moms before deciding where to invest.
 

Excepturi molestias nam veniam corrupti vero dolorem in exercitationem. Aliquid voluptate nostrum aliquam sit harum nihil maxime. Aut possimus nam explicabo reprehenderit quia corporis incidunt.

Minus qui veniam perspiciatis tempore. Facilis omnis saepe impedit velit ut. Consequatur qui quis dolorem quo laudantium eius error. Id atque est quae qui eos odio neque sunt. Ratione quas tenetur amet.

Quia impedit debitis officiis qui molestias aliquid rerum nisi. Occaecati ducimus sequi ex quaerat delectus. Ad est necessitatibus necessitatibus.

A quasi omnis cupiditate saepe totam. Eveniet autem non quae. Quae nihil sed repudiandae voluptates vero. Quae totam omnis cum ut voluptas odit quia. Sint iste recusandae quo dolorem. Totam fuga veniam modi a atque minus.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
kanon's picture
kanon
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
numi's picture
numi
98.8
10
Kenny_Powers_CFA's picture
Kenny_Powers_CFA
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”