The file P02_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...

The file P02_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.