You are expected to show all work in your spreadsheet in a professional manner. IfI cannot find the work in your spreadsheet, you will receive a ofor the question. Questions 1. Amortized loan. Suppose you want to purchase a 2024 Ford Mustang Mach-E from a local Ford dealer. Its out-the-door price is $55,000. You plan to finance the car with a 5-year loan. The loan's annual interest rate is 7.99%, and it requires a down payment of $18,000 (made today) and additional 60 equal monthly payments. The first monthly payment is scheduled in a month. - First, colnpute the equal monthly payment using your financial calculator. Show the setup of your calculator in the corresponding area of "sheet 1 " of the attached excel spreadsheet. - Set up the amortization schedule that shows the monthly payments, interest payments, principal repayments, and beginning and ending loan balances from months 1 to 60 in the corresponding area of "sheet 1 " of the attached Excel spreadsheet. 2. Risk and Return. Complete the "sheet 2 " of the attached Excel spreadsheet by filling out all the green cells. The probability distribution is a listing of all possible outcomes and the corresponding probability. A problem sometimes arises when comparing standard deviations of different securities. If they have different expected returns, you may not be able to compare them. The coefficient of variation shows risk per unit of expected return. 52 SAMPLE More often in finance, you are dealing with a sample of historical data. In this case you need to calculate a sample average return and sample standard deviation. 4. Find Sample Average and Sample Standard Deviation Based on Historical Data 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71