Please answer the following questions:

$1.$ Gary will invest the donations from a wealthy investor in CDs$.$ How much will the Center have accumulated on the day of the last donation? $($Use Sun Trust$).$

$2.$ If the Center takes out a $5-$year term loan that would be repaid in equal annual installments, how much will it owe to the bank if Gary decides to pay off the loan early, at the end of the third year? $($Use the term loan interest rate from Bank South$).$

$3.$ If the Center takes out a $7-$year term loan that would be repaid in different annual much would the fixed annual installment be at the end of each year from Year $4$ through Year $7?($Use the term loan interest rate offered by Bank South$).$

$4.$ Gary will invest the contributions to the board$-$designated building fund in CDs$.$ How much will the equal annual contributions in years $5,6,$ and $7$ have to be to ensure the Center will have sufficient funds to pay for projected facility renovations? $($Use the CD interest rate offered by Bank South$)($Hint: Use a time line to lay out the year $0-4$ and $8-11$ annual cash flows and then use Goal Seek in Excel to solve for the year $5-7$ cash flows.$)$