Equity reconciliation
So I'm working through a 3 statement model that projects out over 5 years. I had to do a model in the interview today and he gave me another model to take home and complete to discuss tomorrow AM. I have completed forecasting out the AR and Inventory but I'm lost on how to balance out the equity portion as my "check" is like $3k off. Can someone please help me figure this out and then explain to me how they did this? I'm not sure what to even google to find out how to finish this thing.
Also, the interviewer told me that forecasting out the non-cash items (you'll see if you open the file) is not important. Would you let me know your thoughts on this too?
I would really appreciate the help, this is the furthest I've ever gotten in an IB interview!!
Glossing over it now. Found something weird. PM me.
Three things I've caught so far.
CAPEX on your cash flow statement is positive when it should be negative.
You calculated interest expense using the interest rate on cash. Use the interest rate on debt instead.
You left out dividends in your equity value calculation.
EDIT: See my PM.
EDIT2: Unfortunately, I reached my limit for PMs. If you have any other questions let me know. Otherwise, best of luck with the interview!
Not sure if my PM went through so I’ll post here. If I interpreted the question correctly, the easiest way to approach the question would be to calculate a WACC and then some debt ratios and coverage ratios. If the company can handle raising additional debt and still be able to cover its interest expenses, then raising debt would be optimal because it’s generally cheaper. If the company can’t raise more debt without putting too much stress on the balance sheet, raise equity.
Alternatively, if the VP is looking for an answer in the context of M&A, look at the cash on hand available, amount of debt on the BS already, and cost of equity (inverse PE ratio). From there, you can take your answer as you see fit. Is there enough cash on hand to make a value add acquisition and sustain minimum cash requirements? What do the company’s debt ratios look like and can they raise additional debt and still cover interest expenses? What is the cost of equity compared to the cost of debt and cost of cash? Although it is exceedingly rare, sometimes it may be cheaper to issue shares instead of using cash on hand or raising additional debt. Perhaps the best answer is a combination of two considerations.
Repellendus sunt voluptas repellat dolorum laudantium recusandae nihil. Odio eos distinctio molestiae optio iure illo aut. Incidunt nostrum possimus repellat qui voluptate quasi vero facere. Dolor dolor fugiat non vero mollitia rem.
Repellat sequi asperiores rerum id deleniti doloribus. Consequatur voluptate voluptate odio minima. Veniam non quis molestiae dolore optio.
Dolorem sit aut laudantium sapiente. Aliquid praesentium commodi quibusdam omnis qui eligendi qui. Placeat porro atque eos quia voluptatem cupiditate. Est commodi dicta vel occaecati qui. Blanditiis iusto est a est.
Illo consequuntur aliquid nisi quibusdam. Provident sunt saepe velit incidunt corrupti facere natus. Officiis aspernatur vero ducimus eum sint.
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...