The general importance of the task is big – This is for a job opportunity, so please pay attention to this detail. The forecast to be extended for the next four quarters, so Q2 2024 – Q1 2025 and an additional two quarters. So including Q2 2025 and Q31) would make sure the financial model is formatted well. It doesn’t/shouldn’t necessarily match the formatting of the raw data tabs but should be formatted in a visually appealing way2) the forward projections/estimates should be relatively in line with street consensus (i.e. – the projections from JP Morgan) but will obviously be different because of assumptions used to make those forecasts deliverables are putting together a financial model and a one page write up deciding whether I’m long or short the stock I was given.
The financial model should support the investment thesis in the write up.The stock is shake shack. I was given a company model for them from JP Morgan research so a lot of the historical data can be pulled from that. The model should be a three statement model that builds to a price target. The difficult part will be determining what to make assumptions and how they should be projected. The one pager should have an analysis overview, industry overview/where it’s headed, operational analysis, risks, something notable/tailored to shake shack, and a conclusion. It should also include the price target, buy/sell rating and an eps estimateSo to be clear the model should be a discounted cash flow analysis (DCF). So it should have the three financial statements like I outlined in my email with estimates and projections and then also have a free cash flow build, quick weighted average cost of capital build, and then a DCF valuation that takes enterprise value based on the DCF, backs into equity value and finds the implied share price from there.
Ensure you make use of the Excel spreadsheet for the modelling and write a one page pitch desk.
Requirements: 1 page | .doc file