Preparein MicrosoftExcelor Word.

• Ch. 5: Questions 3 & 4 (Question and Problems section): MicrosoftExceltemplates provided for Problems 3 and 4
• Ch. 6: Questions 2 & 20 (Questions and Problems section)
• Ch. 7: Questions 3 &11 (Questions and Problems section)
• Ch. 8: Questions 1 & 6 (Questions and Problems section): MicrosoftExceltemplate provided for Problem 6

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." equire that 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." equire that Chapter 8 Question 6 Input area: Stock price Required return Output area: Next year's dividend $ - Current dividend $ - Week 2 Problem and Questions Finance 2. Present Value and Multiple Cash Flows [LO1] Investment X offers to pay you $4,700 per year for eight years, whereas Investment Y offers to pay you $6,700 per year for five years. Which of these cash flow streams has the higher present value if the discount rate is 5 percent? If the discount rate is 15 percent? 20. Calculating Loan Payments [LO2, 4] You want to buy a new sports coupe for $79,500, and the finance office at the dealership has quoted you an APR of 5.8 percent for a 60-month loan to buy the car. What will your monthly payments be? What is the effective annual rate on this loan? 3. Valuing Bonds [LO2] Even though most corporate bonds in the United States make coupon payments semiannually, bonds issued elsewhere often have annual coupon payments. Suppose a German company issues a bond with a par value of 1,000, 23 years to maturity, and a coupon rate of 5.8 percent paid annually. If the yield to maturity is 4.7 percent, what is the current price of the bond? 8. Coupon Rates [LO2] DMA Corporation has bonds on the market with 14.5 years to maturity, a YTM of 5.3 percent, a par value of $1,000, and a current price of $965. The bonds make semiannual payments. What must the coupon rate be on these bonds