Changing compounding frequencyUsing annual, semiannual, and quarterly compounding periods, (1) calculate the future value if

$6,000 is deposited initially at 11% annual interest for 5 years, and (2) determine the effective annual rate (EAR).

1. For quarterly compounding, the future value, is _________$. (Round to the nearest cent).

2. If the 11% annual nominal rate is compounded quarterly, the EAR is _________%. Round to two decimal places.

Please use an Excel Spreadsheet with formula to show the computations and results).