Prepare two spreadsheets of amortization schedules for two different loans. The schedule should

show monthly payments, interest$/$principal payments, and balance information on each loan. See

below for a typical presentation of a loan amortization schedule.

Format the table so that the entire table can fit in a single page, by hiding some of the middle

rows; Show only the first $24$ months and the last $12$ months. $($Use "hide"or "Group" command

to hide rows that you do not want to print$).$

Do this for each of two loans; one for a $15-$year $$153,000$ loan at

$8\mathrm{.}40\%$ APR $($Ioan $A),$ and the other for a $20-$year $$269,000$ loan

at $8\mathrm{.}75\%$ APR $($loan B$).$

Important: Name the loan amount and interest rate using your last name, e$.$g$.,$ moon$\_$loan

and moon$\_$APR, and use the names in your formulas.

At the top of each table, compute the total amount of interest payments.

Loan Amortization Schedule Example

Monthly Payment is the amount the borrower pays monthly for a loan. Use the $"=$pmt$($