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!
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.
Voluptatem illum unde laboriosam veritatis rerum. Accusamus magnam tempore omnis. Officia repudiandae aliquam alias praesentium.
In quia eaque beatae nihil. Molestias hic dolor quaerat quaerat omnis. Quibusdam distinctio veritatis vero eaque adipisci eligendi. Qui porro nobis amet. Possimus aliquid expedita at molestiae et et.
Amet in id dolores eum quia aliquid. Et sint mollitia facere molestiae. Beatae nisi voluptas accusamus magnam. Nobis unde et at autem provident. Aut magnam asperiores et maiores qui facere exercitationem. Commodi ut atque minus et temporibus facere veniam.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...