Spreadsheet eBook The file PO2_43.xlsx contains a template for a car loan. Specifically, once values are entered in the blue cells, you need to enter formulas in the gray cells to calculate the amount financed, the monthly payment (assuming that monthly payments stay the same throughout the term of the loan), the total interest paid, and an amortization schedule. For the latter, fill in the entire gray area with formulas, but use IF functions so that blanks appear past the term of the loan. What is the total interest paid over the life of the loan? Round your answer to a whole dollar amount. A B D E F G Can be any multiple of 12, up to 60 Interest Principal Ending balance 1 Calculating car payments 2 3 Price $30,000 4 Down payment $5,000 5 Amount financed 6 Term in months 36 7 Annual interest rate 8% 8 Monthly interest rate 9 Monthly payment 10 Total interest paid 11 12 Payment schedule (works for any term up to 60 months) 13 Month Beginning balance Payment 14 1 15 2 16 3 17 4 18 5 19 6 20 7 21 8 22 9 23 10 24 11 25 12 26 13 27 14 28 15 29 16 17 31 18 32 19 Model + 30