You are analyzing the Victoria Inc. (VI Stock). Assume that VI's required rate of return is 15 percent. Assume that VI is a constant growth company whose last dividend D0, was $3.0, and whose dividend is expected to grow indefinitely at a 6 percent rate forever.

Answer the following:

a. What is the firm's expected dividend in 3 years?

b. What is the firm's current stock price?

c. What is the stock's expected value 1 year from now?

d. What is the expected dividend yield, the capital gains yield, and the total return during the first year?

e. What would the stock price be if its dividends were expected to have zero growth? (Zero growth model, K is the same but g=0)

PLEASE ANSWER USING EXCEL! AND SHOW HOW YOU GOT THE ANSWER. THANK YOU.