Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What would be needed for your DCF model to produce a price of $ 4 2 per share ( the high price on the first
What would be needed for your DCF model to produce a price of $ per share the high price on the first day of trading Specifically, by changing your revenue growth or cost assumptions, find a set of assumptions that would produce a stock price of approximately $ You should comment about the reasonableness of these assumptions in your writeup. NOTE: There are many combinations of assumptions that will workthere is no 'right' answer here.
An alternative way to value a stock is by use of multiples. NOTE: There is no reason to expect the multiplesbased valuation to agree with your DCFbased valuation because different assumptions underly the two methods.
a Multiples valuation should be forward looking, so start with Instacart's Base Case projected Earnings Before Interest, Taxes, Depreciation and Amortization EBITDA a standard cash flow measure from your DCF and compute its total Enterprise ValuetoEBITDA ratio. Enterprise Value is Equity Value Cash Debt postIPO, Instacart has $ billion in cash and not enough debt to be material
b Compare this with the ratios for: Uber EVEBITDA DoorDash and a global mobility comparison set Be sure to comment on whether Instacart's multiple seems reasonable given its growth prospects.
c If you were to apply the comparison multiples to Instacart's EBITDA, what share prices would that imply? Take EBITDA x Multiple as your new total Enterprise Value, convert to equity by adding in the cash and calculate the share price from there.
Overall, what is your estimate of what Instacart's stock price should be and what range of valuations do you think are reasonable? Defend your conclusion by discussing and referencing the outcomes of the valuations in steps to as well as your thoughts on Instacart's competitive landscape. You will have arrived at a range of prices, and you will need to take a stand on how to interpret this range and which prices and assumptions to weigh more heavily.
Your answer should take the form of a writeup maximum singlespaced pages that refers to spreadsheet exhibits the exhibits do not count toward the page limit Do NOT write a chronological history of what you did to solve this case and do NOT write it as # answer, # answer, etc. You are supposed to explain the highlights of your approach, synthesize what you found, draw a conclusion, and defend it
This is a group case. Submission is electronic and MUST also include your Excel file ending in xlsx
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started