who can type this up for me using excel i already have the answers serious inquires only ,the answers are in the notebook drawn below , i just need help doing the graph on excel because everytime i type it writes value for me , for any questions or concern ill give you my number

2 7 Used 2019 Civic Compe ????????? - Monthly Payments = $309 permo Car Costa $18, 876) Down Payment = $5,000 $13,875 with a minimum down payment of $1,868 This is what the bank has to loon you. so this is what you're borrowing Chase bank will loan you $13,875 with an interest rate of 4.51% for 60 months (60 months = 5years) $13,875.00 (your money borrowed/loan) x .0451% $13,875.00 +$ 1625.76 = Total amount of interest paid during life of loan $14,500.76 = Total amount paid to bank during life of loan 6. Using any online site, please find any new car you wish to purchase, the purchase price must be between $15,000 and $30,000. Once you find the car please answer the following questions. (Please do not worry about including sales tax in this problem. a. State the price of the car you will purchase: This will be the price from the online site b. If you provide a down payment of $5000.00 and finance the remaining amount, how much money will you need to borrow? C. Go on line to any bank and find a common interest rate for a new car loan and state the bank and interest rate. d. Using the interest rate from above, find the monthly payment for this loan. The time in years for the loan is for you to choose, but you must stay within the guidelines of 4 to 6 years. e. What it is the total amount paid back to the bank during the life of the loan and how much interest has been paid for the life of the loan. Please DO NOT hand this in YET, keep your answers, as you will need all this information for creating and amortization schedule for the information. You MUST keep all these answers as you will need them to complete the next assignment. I will check to make sure you that you have completed the answers to the above 6 questions before we begin the next part of the assignment. MacBook Air Dungary directions: Please use only one excel file showing 6 worksheets, 1 work sheet per loan. For each loan please ensure to state the amount borrowed, the interest rate, the amount paid back to the bank over the life of the loan, and the interest paid for the life of the loan. You will also show those answers in the MS Excel Spread sheet per class instructions. Please also place these answers in a text box next to your amortization schedules in the top right near payment numbers 1-5, please see the example if you are not sure exactly where I want this shown. The example is listed under the assignment tab under Amortization Assignment, named Amortization example. Please do not forget to ensure that all the cells that should be formatted as money are formatted as money. This means that aside from the payment number, all other cells will be formatted as money. If your turn in a schedules are not correct, you will lose many points, the reason for this is because as per the classroom instructions and directions, all amortizations schedules will have a similar finality to them. Make sure you are aware of the number of payments for your schedule, which is not the same as the cell number. Please take your time and please do these correctly. It is imperative that you can create the amortization schedule as demonstrated in class. The amortization schedules are DUE in Black Board in the assignments due section no later the date provided in class. It is imperative that you learn how to create an amortization schedule. There are written directions on blackboard. I will again repeat that anyone using any other method than the method MacBook Air LT View Insert Format Tools Data Window Help ONI SU: w Page Layout Formulas Data Review View fx =H3(0.0451/12) CD Amortization Schedule - Saved Tell me Payment Number Payment Interest Principle Outstanding Balance #VALUE! +