Working from the top down, enter data needed from the text question. Calculate a solution for each cell back-lighted in yellow. Build your formulas in calculation cells by referencing cells above that in turn reference numbers directly from the text problem.

fx A B D E F G H 1 J K L 1 e Calculating the monthly payment for an N=Year mortgage 2. 3 What will be the monthly payment on a home mortgage o $76,000.00 at 3.7% interest, to be amortized ove 30 years? How much interest will be paid over the life of the loan? 4 5 6 Interest rate= 3.7% 7 8 Monthly Payments 9 10 Interest Paid= 11