Now, given the following information (Oct 30, 2020) and the same procedure of calculation that we used in AAPL DGM spreadsheet, is AAPL still undervalued?

The Dividend Growth Model assumes that the firm will grow indefinitely with a single growth rate that you plug in. In this case, you somehow believe that the perpetual growth is the latest 1-year growth. Given all these inputs, you calculate the value of the stock to be $XX.XX. The current price of the stock is $108.86 as shown below. So the stock is now overvalued. That is, you pay $108.86 for something that is worth only $XX.XX.

Now, given the following information (Oct 30,2020 ) and the same procedure of calculation that we used in AAPL DGM spreadsheet, is AAPL still undervalued? The Dividend Growth Model assumes that the firm will grow indefinitely with a single growth rate that you plug in. In this case, you somehow believe that the perpetual growth is the latest 1-year growth. Given all these inputs, you calculate the value of the stock to be $XX.XX. The current price of the stock is $108.86 as shown below. So the stock is now overvalued. That is, you pay $108.86 for something that is worth only $XX.XX. Now, given the following information (Oct 30,2020 ) and the same procedure of calculation that we used in AAPL DGM spreadsheet, is AAPL still undervalued? The Dividend Growth Model assumes that the firm will grow indefinitely with a single growth rate that you plug in. In this case, you somehow believe that the perpetual growth is the latest 1-year growth. Given all these inputs, you calculate the value of the stock to be $XX.XX. The current price of the stock is $108.86 as shown below. So the stock is now overvalued. That is, you pay $108.86 for something that is worth only $XX.XX