Exp19 Excel_Ch07_CapAssessment_Shipping Project Description: You will prepare a partial loan amortization table for a new delivery van./ Steps to Perform: Step Instructions Points Possible 1 2 2 3 2 4 4 5 5 Start Excel. Download and open the file named Exp 19_Excel Cho7_CapAssessment_Shipping.xlsx. Grader has automatically added your last name to the beginning of the filename. Use the Loan worksheet to complete the loan amortization table. In cell B4, enter a formula that calculates the monthly interest rate, based on the APR provided (B3). In cell B6, enter a formula that calculates the total number of months for the loan, based on the Years for Loan provided (B5). In cell B7, insert a Function to calculate the Monthly Payment based on the Monthly Rate (B4), NPER (B6), and Loan PV (B2). In cell F2, insert the IPMT function to calculate the interest for the first payment. Copy the function to the range F3:F25. (The results will update after you complete the other functions and formulas.) In cell G2, insert the PPMT function to calculate the principal paid for the first payment. Copy the function to the range G3:G25. In cell H2, insert a formula to calculate the ending principal balance. Copy the formula to the range H3:H25. Now you want to determine how much interest was paid during the first two years. In cell B10, insert the CUMIPMT function to calculate the cumulative interest after the first two years. Make sure the result is positive. In cell B11, insert the CUMPRINC function to calculate the cumulative principal paid at the end of the first two years. Make sure the result is positive. Insert a custom footer on all sheets with the sheet name code in the center, and the file name code on the right side. Save and close Exp19_Excel_Cho7_CapAssessment_Shipping.xlsx. Exit Excel. Submit the file as directed 6 5 7 5 8 5 9 5 10 2 11 0 Total Points 35