Would you help me with these questions please. I need the formulas and which values I have to put in excel. Thank you.

1. Calculate the required return Stock Values Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri Paste Clipboard C1 B 1 u. 2.. A Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Styles Font The next dividend payment by Blue Cheese, Inc., will be $1.89 per share. The dividends are anticipated to maintain a growth rate of 5 percent forever. If the stock currently sells for $38 per share, what is the required return? Dividend paid Dividend growth rate Stock price 1.89 5% 38.00 10 Complete the following analysis. Do not hard code values in your calculations. 12 13 14 15 16 Required return 1. Calculate the payment for the company's stock. Stock Valuation - Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri Paste A-Alignment Number Conditional For mat as Cell Cells Editing Formatting Table Styles - Clipboard r Font Styles E F Staal Corporation will pay a $3.40 per share dividend next year. The company pledges to increase its dividend by 4.5 percent per year indefinitely. If you require a return of 11 percent on your investment, how much will you pay for the company's stock today? 4 Dividend next year $ Dividend growth rate Required return 3.40 450 % 11% 10 Complete the following analysis. Do not hard code values in your calculations. 12 13 14 Price