Question about building a model for interview
I've been asked to build a model for an interview in M&A. There are a couple questions I have. I'm supposed to project out the financial statements for 5 years, and they've provided the WACC, capex and NWC as a % of sales. Then I'm supposed to give 2 valuation methodologies.
-
I've been given an income statement, where the business pays interest expense, but no debt balance has been provided- how do I model interest expense going forwards? I can't do an FCFF valuation if I can't project out the interest expense.
-
Bad debts, bank charges and leases- to me these should all fall under operating expenses under IFRS, but it'd be helpful for someone to clarify
-
Other than a cash flow valuation, what else can I do? Asset based is impossible without a balance sheet, the company doesn't pay dividends so no DDM, no comparables have been produced either. So I'm kinda stuck on this one.
Thanks
We're not here to do your modelling test for you.
1.They've given you the WACC so they want you to do a firm valuation, no cost of equity? I presume they want you to value the equity, which would be easy enough if they gave you a debt balance since you'd subtract it off the firm valuation to get the equity. Not sure how to get equity value without debt, if the company is paying debt. I'd be interested in the answer to this too
Bank charges would just be fees I presume so that's opex. Leases depending on whether they're capital or operating, but I'd classify them as opex. You can reclassify the interest and operating expenses if they've given you a breakdown of the leases. Bad debts, I guess would be opex but I'm not sure on this one.
I barely think you have enough detail to do an equity valuation let alone a second valuation. At a minimum without the debt balance you'll need to the cost of equity.
Maiores ea odit eveniet unde sint. Accusamus delectus iusto ut rerum sunt. Illo aliquam enim voluptas sit.
Eaque aut nihil voluptatem amet ducimus. Labore velit id sunt impedit enim corrupti reprehenderit. Corrupti vel natus suscipit magni.
Cupiditate facilis nesciunt est soluta sapiente quos. Alias minus atque inventore porro et.
Placeat vel ut dolores dolores et doloribus sed veniam. Autem ratione consectetur dicta. Quas quod nobis fugiat molestias. Maxime rerum blanditiis sapiente occaecati quod quia et qui. Nihil debitis harum aut amet.
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...