explain the work please.... do it in excel

Loan Amortization Assignment Outline A family is trying to decide which of the two loan options offered to them by a mortgage broker to take for the purchase of their new home The options are: a) Loan Amount-$ 520,000.00, Interest Rate-% 5.75 . Term of the Loan 1 5 yeas (# of payments 180) b) Loan Amount-$ 520,000.00 , Interest Rate-% 6.75. Term of the Loan 30 yeas (# of payments 360) To help them with their decision, provide them with the total savings in interest payments between the 15 years and the 30 years loan terms. Show your 15-yr term table on the first sheet and the 30-yr term table on the second sheet of your excel file. Follow the format and standards of the emailed 1 s page of the 15-yr loan SAMPLE 9 e7 3 0927 9525 939 99-3 9 2 9 3 6 la 0 6295 28 396 7 le 351 186 12 456 8912 4 5 7802 35 6 1 245 56 7 ti 6625 9 87 2 te -222-2222222 555 4: 48 2|2|2|2 2-2-2-2-2-2 3-3-3-3 3-3-3 3-3 3 3|3|3 0 2 123456789 01 345 678 0 2-2-2-2