K M N 2 3 B D F G H Your solution is expected to be completely based on using Excel Functions. a. A WMU engineering graduate buys a car for $18,000 with no money down. She negotiated and the lender agreed for her to pay for the car in 20 equal quarterly payments with interest at 12% per annum, compounded quarterly. What is her quarterly loan payment? 5 b. Right after 12 payments she hits a jackpot and is expected to receive a large payout from the jackpot in two years time. How much is the balance of the loan right after she makes the 12th payment? 6 7 8 9 10 11 12 C. She re-negotiated with the lender and the lender approved her request that she could make one lumpsum payment at the time she receives the large payout from the jackpot in two years but the new interest rate is 1% per month compounded monthly. How much is the