Please answer all questions based on 'Dataset_1'. If a measure cannot be calculated due to insufficient data, enter 'NA'. Negative values are
I am lost on problems 1-6, a detailed walk through of the answer would be great for studying.
Please answer all questions based on 'Dataset_1'. If a measure cannot be calculated due to insufficient data, enter 'NA'. Negative values are possible. Do notchange the formatting of the yellow cells. Round to three digits after decimal.Yeworks has been growing at a rate of 22% per year in recent years. This same growth rate is expected to last for another 3 years, then to decline to gn =4.3%.1) If D1 = $1.02 and rs = 12.60%, what is the company's stock worth today?answer2) Determine the expected dividend yield of the stock.answerAfter some research you conclude that even though the company pays dividends the dividends paid differ significantly from the company's capacity to pay3)dividends. Therefore, you decided to use the Free Cash Flow model (aka corporate valuation model) since it provides a much deeper insight into the financialsituations of the company. Use the free cash flow projections and financing structure information provided in dataset_1 to answer the following questions:What is the WACC of this company in percent? Assume a tax rate of 28%.answer4) What is total firm value of the company (in $M)?answer5) What is the price of the stock today?answer6)After you finished your model, the company announced to issue a new bond with expected proceeds of USD 42 million. Could this decision affect the stock price?If yes, determine the new stock price otherwise enter 'NA'. Assume no change in the cost of debt.answ
Show more
