needs to be entered in excel format

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? $ Cost of Car Discount rate # of years # of times compounded per year 79,500 5.8% 5 12 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. Payment Effective interest rate 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? $ Payment for X Number of years for X 4,700 8 $ Payment for Y Number of years for Y 6,700 5 Discount rate Discount rate 5% 15% Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. Value of X at 5% B D E F G H J $ Payment for Y Number of years for Y 6,700 5 Discount rate Discount rate 5% 15% Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. Value of X at 5% Value of Y at 5% Value of X at 15% Value of Y at 15% Find the EAR in each of the following cases: Complete the following analysis. Do not hard code values in your calculations. Effective rate (EAR) Stated rate (APR) 7% 17% 13% Times compounded per year 4 12 365