Create an Excel spreadsheet to complete the quantitative analysis questions $($be sure to clearly label and show your work$)$ and a Word document to explain your analysis posed by the questions below.

Which of the following methods do you think is most appropriate for valuing Wal$-$Mart$$s stock? Compute the intrinsic value of Wal$-$Mart$$s stock price based on:

Perpetual growth in dividends

Forecasted dividends for the next several years plus future sale of the stock

The three$-$stage dividend model

The price$/$earnings approach