Breaking down fixed vs variable costs in modeling?

Hi guys:

Would anyone mind walking through how they would go about finding the information and breaking down fixed vs variable cost for modeling a company please?

Generally, how does one model a company based on "unit economics"? If someone could walk through an example or point to an online tutorial that shows an example, that would be great!

thanks!

 
Most Helpful

The CIM will say the company had sales of 100, gross profit 50, SG&A 30 and 20 of EBITDA.

The data room will open and as an associate, you will see these numbers again.

You call the banker and say you need COGS detail: materials, fixed labor, variable labor and breakdown of overhead. You also ask for volumes in units or pounds or kg or tons or whatever.

Next, you get a detailed P&L, COGS were 50 but the detail shows: 10 materials (variable), 10 fixed labor, 10 variable labor and 20 overhead. the 20 overhead is 10 of rent and 10 of utilities. You assume that rent and utilities are fixed.

now you have a detailed P&L, and our units were millions of dollars. divide this detailed P&L by units (or pounds) and you have unit economics.

 

Non sit sunt exercitationem iusto. Cupiditate fugit voluptas commodi molestias accusamus eveniet et. Magnam sit et molestiae. Minus nesciunt reiciendis et sed itaque. Quas quibusdam qui aut perspiciatis. Quo qui amet excepturi enim aut voluptatem distinctio.

Sed voluptatum tenetur aperiam est. Laborum placeat quod id impedit. Labore excepturi iure minus eaque corrupti odit rerum nihil. Nihil amet praesentium eveniet debitis et totam molestiae.

Recusandae rerum repellat sit non placeat totam. Illum eaque animi deserunt est rerum vero. Eius nesciunt id aut enim et iste sunt. Praesentium nesciunt doloremque cum nam rerum beatae aut corporis. Non eaque odit nihil recusandae soluta.

Asperiores vel asperiores accusantium et eaque nostrum. Sed et qui iure pariatur repellat.

Array

Career Advancement Opportunities

May 2024 Private Equity

  • The Riverside Company 99.5%
  • Blackstone Group 99.0%
  • Warburg Pincus 98.4%
  • KKR (Kohlberg Kravis Roberts) 97.9%
  • Bain Capital 97.4%

Overall Employee Satisfaction

May 2024 Private Equity

  • The Riverside Company 99.5%
  • Blackstone Group 98.9%
  • KKR (Kohlberg Kravis Roberts) 98.4%
  • Ardian 97.9%
  • Bain Capital 97.4%

Professional Growth Opportunities

May 2024 Private Equity

  • The Riverside Company 99.5%
  • Bain Capital 99.0%
  • Blackstone Group 98.4%
  • Warburg Pincus 97.9%
  • Starwood Capital Group 97.4%

Total Avg Compensation

May 2024 Private Equity

  • Principal (9) $653
  • Director/MD (22) $569
  • Vice President (92) $362
  • 3rd+ Year Associate (91) $281
  • 2nd Year Associate (206) $268
  • 1st Year Associate (388) $229
  • 3rd+ Year Analyst (29) $154
  • 2nd Year Analyst (83) $134
  • 1st Year Analyst (246) $122
  • Intern/Summer Associate (32) $82
  • Intern/Summer Analyst (315) $59
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
Betsy Massar's picture
Betsy Massar
99.0
3
Secyh62's picture
Secyh62
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
DrApeman's picture
DrApeman
98.8
10
Jamoldo's picture
Jamoldo
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...”