Need help with questions 1-10

First, please follow the steps to calculate expected growth rate of dividends (g): 1. Obtain annual dividends by adding quarterly dividends in each given year. 2. Calculate percentage changes of annual dividends year over year = (D1/D0)-1. 3. Average the four percentage changes. This average will serve as the 'g', the expected growth rate. 6 points What is the expected growth rate of dividends that you calculated by following the steps in the instruction? Answer in % in the nearest tenth. Type your answer... 6 points Assume the discount rate for APPL, ' r ', is 7%. Use the annual dividend in 2022 as D0. What is the value of stock for APPL assuming zero-growth? Type your answer... 6 points Assuming the same ' r ' and using the expected growth rate calculated previously, what is the value of stock for APPL assuming constant-growth? Use the annual dividend in 2022 as DO. Answer in the nearest tenth. 6 points Assuming the same ' r ' but using a different growth rate g=6%, what is the value of stock for APPL assuming constant growth? Use the annual dividend in 2022 as D0. Answer in the nearest tenth. 6 points Holding everything else the same, what is the effect of decreasing ' g ' on the value of stock? decreases stock value. increases stock value. no effect. 6 points Assuming the expected growth rate of 6% but using a different discount rate r=8%, what is the value of stock for APPL assuming constant growth? Answer in the nearest tenth. Type your answer... 6 points Holding everthing else the same, what is the effect of increasing ' r ' on value of stock? decreases stock value. increases stock value. no effect. 8 points Now, let's try to price APPL using the two-stage growth model. We will assume that APPL expects to go through a rapid expansion and fast growth over the next two years. Assume that g1=30%,g2=4%, and r=5% and that APPL's dividends enter the second stage of growth after two years (that is, D1 and D2 grow at the rate of g1, and dividends from D3 grows at the new lower rate of g2). What is the value of stock for APPL assuming two stage growth model? Please answer in the nearest tenth. Type your answer... decreases stock value. increases stock value. no effect. 8 points Now, let's try to price APPL using the two-stage growth model. We will assume that APPL expects to go through a rapid expansion and fast growth over the next two years. Assume that g1=30%,g2=4%, and r=5% and that APPL's dividends enter the second stage of growth after two years (that is, D1 and D2 grow at the rate of g1, and dividends from D3 grows at the new lower rate of g2). What is the value of stock for APPL assuming two stage growth model? Please answer in the nearest tenth. ype your answer... 6 points What happens to the stock value when g is greater than r ? Try g=6% and r=5%. Stock value turns negative, so assuming g>r is an invalid assumption. Stock value is still positive, so assuming g>r is a valid assumption. Stock value turns negative, but whatever. 6 points The actual market price at year end of 2022 was $129.93. Using the constant growth model assuming g=6.5\%, try to find ' r ' (in the nearest tenth) that leads us to the stock value that is closest to the market price of $129.93. You can use either Excel or manual calculation. First, please follow the steps to calculate expected growth rate of dividends (g): 1. Obtain annual dividends by adding quarterly dividends in each given year. 2. Calculate percentage changes of annual dividends year over year = (D1/D0)-1. 3. Average the four percentage changes. This average will serve as the 'g', the expected growth rate. 6 points What is the expected growth rate of dividends that you calculated by following the steps in the instruction? Answer in % in the nearest tenth. Type your answer... 6 points Assume the discount rate for APPL, ' r ', is 7%. Use the annual dividend in 2022 as D0. What is the value of stock for APPL assuming zero-growth? Type your answer... 6 points Assuming the same ' r ' and using the expected growth rate calculated previously, what is the value of stock for APPL assuming constant-growth? Use the annual dividend in 2022 as DO. Answer in the nearest tenth. 6 points Assuming the same ' r ' but using a different growth rate g=6%, what is the value of stock for APPL assuming constant growth? Use the annual dividend in 2022 as D0. Answer in the nearest tenth. 6 points Holding everything else the same, what is the effect of decreasing ' g ' on the value of stock? decreases stock value. increases stock value. no effect. 6 points Assuming the expected growth rate of 6% but using a different discount rate r=8%, what is the value of stock for APPL assuming constant growth? Answer in the nearest tenth. Type your answer... 6 points Holding everthing else the same, what is the effect of increasing ' r ' on value of stock? decreases stock value. increases stock value. no effect. 8 points Now, let's try to price APPL using the two-stage growth model. We will assume that APPL expects to go through a rapid expansion and fast growth over the next two years. Assume that g1=30%,g2=4%, and r=5% and that APPL's dividends enter the second stage of growth after two years (that is, D1 and D2 grow at the rate of g1, and dividends from D3 grows at the new lower rate of g2). What is the value of stock for APPL assuming two stage growth model? Please answer in the nearest tenth. Type your answer... decreases stock value. increases stock value. no effect. 8 points Now, let's try to price APPL using the two-stage growth model. We will assume that APPL expects to go through a rapid expansion and fast growth over the next two years. Assume that g1=30%,g2=4%, and r=5% and that APPL's dividends enter the second stage of growth after two years (that is, D1 and D2 grow at the rate of g1, and dividends from D3 grows at the new lower rate of g2). What is the value of stock for APPL assuming two stage growth model? Please answer in the nearest tenth. ype your answer... 6 points What happens to the stock value when g is greater than r ? Try g=6% and r=5%. Stock value turns negative, so assuming g>r is an invalid assumption. Stock value is still positive, so assuming g>r is a valid assumption. Stock value turns negative, but whatever. 6 points The actual market price at year end of 2022 was $129.93. Using the constant growth model assuming g=6.5\%, try to find ' r ' (in the nearest tenth) that leads us to the stock value that is closest to the market price of $129.93. You can use either Excel or manual calculation