how do you do questions 6-11 with the given data , I know you can see all the rows on the excel bt if i could just have the formulas or the how to do it for the stock tick UPS
19 6) Calculate the 5-year beta using monthly data in the Data_for_Beta sheet. It should be close to the beta from Question 5. See slide 34 in Handout_3and4, slides 18, 19 in Handout_5, and Volatility_Beta_examples spreadsheet. 7) Calculate the equity discount rate, using the beta, an expected equity market return of 9%, and a risk-free rate of 3.0%. See slide 3 in Handout_5. 8) Assumed Dividend per Share growth rate of x.x% and the beta from question 7. Calculate the intrinsic value using the single stage dividend discount model (the Gordon Growth model) See growth_rates sheet for x.xx%. See slides 13-15 in Handout_6. See AAPL_DCFs_2022.xlsx spreadsheet. 9) Assume a FCFE per Share growth rate of x.xx% and the equity discount rate from question 7. Calculate the intrinsic value using the single stage FCFE discounted cash flow model. See growth_rates sheet for x.xx%. See slide 20 in Handout_6. See AAPL_DCFs_2022.xlsx spreadsheet. 10) Assume a FCFE per Share growth rate of x.xx% and the equity discount rate from question 7. Calculate the intrinsic value using the single stage FCFE discounted cash flow model. See growth_rates sheet for x.xx%. See slide 20 in Handout_6. See AAPL_DCFs_2022.xlsx spreadsheet. 11) Assume a FCFE per Share growth rate of x.xx%. Reduce the equity discount rate from question 7 by 1%. Calculate the intrinsic value using the single stage FCFE discounted cash flow model. See growth_rates sheet for x.xx%. See slide 20 in Handout_6. See AAPL_DCFs_2022.xlsx spreadsheet. 19 6) Calculate the 5-year beta using monthly data in the Data_for_Beta sheet. It should be close to the beta from Question 5. See slide 34 in Handout_3and4, slides 18, 19 in Handout_5, and Volatility_Beta_examples spreadsheet. 7) Calculate the equity discount rate, using the beta, an expected equity market return of 9%, and a risk-free rate of 3.0%. See slide 3 in Handout_5. 8) Assumed Dividend per Share growth rate of x.x% and the beta from question 7. Calculate the intrinsic value using the single stage dividend discount model (the Gordon Growth model) See growth_rates sheet for x.xx%. See slides 13-15 in Handout_6. See AAPL_DCFs_2022.xlsx spreadsheet. 9) Assume a FCFE per Share growth rate of x.xx% and the equity discount rate from question 7. Calculate the intrinsic value using the single stage FCFE discounted cash flow model. See growth_rates sheet for x.xx%. See slide 20 in Handout_6. See AAPL_DCFs_2022.xlsx spreadsheet. 10) Assume a FCFE per Share growth rate of x.xx% and the equity discount rate from question 7. Calculate the intrinsic value using the single stage FCFE discounted cash flow model. See growth_rates sheet for x.xx%. See slide 20 in Handout_6. See AAPL_DCFs_2022.xlsx spreadsheet. 11) Assume a FCFE per Share growth rate of x.xx%. Reduce the equity discount rate from question 7 by 1%. Calculate the intrinsic value using the single stage FCFE discounted cash flow model. See growth_rates sheet for x.xx%. See slide 20 in Handout_6. See AAPL_DCFs_2022.xlsx spreadsheet
