This is part 2 of my homework. I was able to complete part 1 but part 2 has stumped me. I am supposed to have an excel spreadsheet for the amortization table. Thank you for your help!

2.

For the following exercises, create an amortization table for $135,000 home purchase at 4.6% fixed APR. Remember mortgages are generally paid monthly. a. 30 years b. 15 years c. How do the 15-year and 30-year loans compare in total amount paid and interest paid? d. How much is saved if you round each payment up to the nearest $100?