3 questions in the attached word document that need to be calculated into the attached spreadsheets.

Chapter 5 Problems 1, 2, 3, 4, 5 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-In" be installed in Excel. To install these, click on the Office button then "Excel Options," "Add-Ins" and select "Go." Check "Analyis ToolPak" and "Solver Add-In," then click "OK." ets may require that nstalled in Excel. Chapter 5 Question 3 Output area: Input area: Present value $ $ $ $ Years - Interest rate Future value Chapter 5 Question 4 Input area: Present value Output area: Years Interest rate Future value Err:502 Err:502 Err:502 Err:502 Chapter 8 Problems 4, 6, 7, 32 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-In" be installed in Excel. To install these, click on the Office button then "Excel Options," "Add-Ins" and select "Go." Check "Analyis ToolPak" and "Solver Add-In," then click "OK." ets may require that nstalled in Excel. Chapter 8 Question 6 Input area: Stock price Required return Output area: Next year's dividend $ - Current dividend $ - 3.Calculating Present Values [LO2] For each of the following, compute the present value: 4Calculating Interest Rates [LO3] Solve for the unknown interest rate in each of the following: 6. Stock Valuation [LO1] Suppose you know that a company's stock currently sells for $63 per share and the required return on the stock is 10.5 percent. You also know that the total return on the stock is evenly divided between a capital gains yield and a dividend yield. If it's the company's policy to always maintain a constant growth rate in its dividends, what is the current dividend per share