FINANCE
You’ve collected the following information from your favorite financial website. 
52Week Price

Stock (Div)  Div Yld % 
PE Ratio 
Close Price 
Net Chg 

Hi  Lo  
77.40  10.43  Palm Coal 0.36  2.6  6  13.90  –0.24 
56.06  33.67  Lake Lead Grp 1.79  4.4  10  40.68  –0.01 
130.93  69.50  SIR 2.00  2.2  10  88.97  3.07 
50.24  13.95  DR Dime 0.80  5.2  6  15.43  –0.26 
35.00  20.74  Candy Galore 0.32  1.5  28  ??  0.18 

Find the quote for the Lake Lead Group. Assume that the dividend is constant. 
Requirement 1: 
What was the highest dividend yield over the past year? (Do not round intermediate calculations.Round your answer to 2 decimal places (e.g., 32.16).) 
Requirement 2: 
What was the lowest dividend yield over the past year? (Do not round intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).) 
You’ve collected the following information from your favorite financial website. 
52Week Price

Stock (Div)  Div Yld % 
PE Ratio 
Close Price 
Net Chg 

Hi  Lo  
77.40  10.43  Palm Coal 0.36  2.6  6  13.90  –0.24 
55.81  33.42  Lake Lead Grp 1.54  3.8  10  40.43  –0.01 
130.95  69.60  SIR 2.10  2.4  10  88.99  3.07 
50.24  13.95  DR Dime 0.80  5.2  6  15.43  –0.26 
35.00  20.74  Candy Galore 0.32  1.5  28  ??  0.18 

According to your research, the growth rate in dividends for SIR for the next five years is expected to be 20.5 percent. Suppose SIR meets this growth rate in dividends for the next five years and then the dividend growth rate falls to 5.5 percent indefinitely. Assume investors require a return of 13 percent on SIR stock. 
Requirement 1: 
According to the dividend growth model, what should the stock price be today? (Do not round intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).) 
Requirement 2: 
Based on these assumptions, is the stock currently overvalued, undervalued, or correctly valued? 
You’ve collected the following information from your favorite financial website. 
52Week Price

Stock (Div)  Div Yld % 
PE Ratio 
Close Price 
Net Chg 

Hi  Lo  
78.5  10.54  Palm Coal 0.47  3.1  6  15.00  –0.24 
55.81  33.42  Lake Lead Grp 1.54  3.8  10  40.43  –0.01 
130.93  69.50  SIR 2.00  2.2  10  88.97  3.07 
50.24  13.95  DR Dime 0.80  5.2  6  15.43  –0.26 
35.00  20.74  Candy Galore 0.32  1.5  28  ??  0.18 

According to your research, the growth rate in dividends for Palm Coal for the previous 10 years has been 4.25 percent. 
Required: 
If investors feel this growth rate will continue, what is the required return for Palm Coal stock? (Do not round intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).) 
You’ve collected the following information from your favorite financial website. 
52Week Price

Stock (Div)  Div Yld % 
PE Ratio 
Close Price 
Net Chg 

Hi  Lo  
77.40  10.43  Palm Coal 0.36  2.6  6  13.90  –0.24 
55.81  33.42  Lake Lead Grp 1.54  3.8  10  40.43  –0.01 
130.93  69.50  SIR 2.00  2.2  10  88.97  3.07 
50.33  14.04  DR Dime .89  5.7  6  15.52  –0.26 
35.00  20.74  Candy Galore 0.32  1.5  28  ??  0.18 

According to your research, the growth rate in dividends for DR Dime for the previous 10 years has been –14 percent. 
Required: 
If investors feel this growth rate will continue, what is the required return for DR Dime stock? (Do not round intermediate calculations. Negative amount should be indicated by a minussign. Round your answer to 2 decimal places (e.g., 32.16).) 
You’ve collected the following information from your favorite financial website. 
52Week Price

Stock (Div)  Div Yld % 
PE Ratio 
Close Price 
Net Chg 

Hi  Lo  
77.40  10.43  Palm Coal .36  2.6  6  13.90  –0.24 
55.81  33.42  Lake Lead Grp 1.54  3.8  10  40.43  –0.01 
130.93  69.50  SIR 2.00  2.2  10  88.97  3.07 
50.24  13.95  DR Dime .80  5.2  6  15.43  –0.26 
36.60  20.90  Candy Galore 0.48  1.5  28  ??  0.18 

Requirement 1: 
Using the dividend yield, calculate the closing price for Candy Galore on this day. (Do not round intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).) 
Requirement 2: 
Assume the actual closing price for Candy Galore was $31.69. Your research projects a 4.25 percent dividend growth rate for Candy Galore. What is the required return for the stock using the dividend discount model and the actual stock price? (Do not round intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).) 