Hi Brian thank you for providing this. The question I ask is, what do you think of EBITDAR on "calculating" income on retail company. Do you think it is the best way or relevance, or do you still prefer using EBITDA? And why you think so? Thank you, looking forward for your answer
It depends completely on the company's accounting system and whether you're doing a standalone analysis or a comparison. EBITDAR is useful for comparison purposes especially when dealing with U.S. GAAP vs. IFRS (see the lease accounting tutorials). But it's not necessary for standalone analysis, and it doesn't mean anything at all for a standalone IFRS-based company because they no longer have Rental Expense on the IS... just Interest + Depreciation for all lease types.
# of square feet and sales per square foot (or meters) or # of stores and sales per store. Expenses are linked to employees per store or per square foot and fixed maintenance CapEx for existing stores and growth CapEx for new ones.
What type of IT companies? We have an overview of different sectors here: mergersandinquisitions.com/technology-investment-banking-group/ and mergersandinquisitions.com/tmt-investment-banking-group/
Click on "Show More" and scroll to the bottom to get the link. Actually, here's the direct link: youtube-breakingintowallstreet-com.s3.us-east-1.amazonaws.com/CEC-Revenue-Model.xlsx
Hi, how can I do if they don't give me the amount of comparable store sales but do tell me the growth over comp sales each year (like Home Depot)? How can I manage to arrive to that or what other similar option can I use?
Just use whatever data you have and make estimates. Assume the growth rate applies to all existing stores and then assume a certain number of new stores open and some existing stores close. The specifics matter less than the overall growth rates.
Hello. I have a question. Is it a true statement that Growth in Total Sales = Growth in Sales per Comparable Store + Growth in Sales per New Store? By the way, is Growth in Sales per Comparable Stores the same as Like-for-Like Growth in Sales?
The first statement is not necessarily true because Total Sales is measured across all stores, so you can't compare it to per-store metrics (maybe the # of stores has changed). Growth in Sales per Comparable Store is similar to "Like-for-Like Growth in Sales" but may not always be exactly the same, depending on how the company has defined comparable vs. like-for-like.
hello I have been assigned to rebuild the excel model from your videos of EBITDA and revenue model by my university can u pleas share the excel file so I can re build it .Kindly help Thank you