FILL IN THE BLANK:

According to Yahoo Finance and NASDAQ websites Walmart has approved an annual cash dividend for fiscal year 2017 of $2.00 per share, which is an increase of two percent from the $1.96 per share paid for the last fiscal year. The fiscal year 2017 annual dividend of $2.00 per share will be paid in four quarterly installments of $0.50 per share. The stocks last closing price was $____ and the dividends will grow constantly at ___% yearly. The required rate has been estimated to be ____%. In developing the spreadsheet for the estimation we used a data range for the next ten years (2016-2026). We have shown the predicted stream of dividends and stock prices along with annual values or the dividend yield, the capital gain yield, and the expected total return. According to the calculations, the dividend would increase from $2.00 to $___. The dividend was calculated by taking the initial dividend and multiplying it by 1 plus the constant growth rate of ____%. The estimated prices were calculated ranged from $____ - $____. Using this information, I was able to calculate the Present Value of each dividend and the total sum calculated equaled $_____.

FILL IN THE BLANKS IN THE EXCEL SPREADSHEET ATTACHED: (Please include calculations and formulas)

Walmart D0 g rs P0 At year end 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 $___ ____% _____% $_____ Dividend $_____ $_____ $_____ $_____ $_____ $_____ $_____ $_____ $_____ $_____ $_____ Price $______ $______ $______ $______ $______ $______ $______ $______ $______ $______ $______ Dividend Yield Capital Gain Yield $______ $______ $______ $______ $______ $______ $______ $______ $______ $______ ______% ______% ______% ______% ______% ______% ______% ______% ______% ______% Total Return _____% _____% _____% _____% _____% _____% _____% _____% _____% _____% Sum of PV PV of Dividend $_______ $_______ $_______ $_______ $_______ $_______ $_______ $_______ $_______ $_______ $______