'here is a bug in the spreadsheet applet that causes it to reset and clear all entered values when you Submit Answers. Be aware of this before you click Submit. For example, complete all the blanks in part a) before submitting to check answers. DO NOT hit the Enter key within the spreadsheet, as this will trigger a submission and also clear the spreadsheet. The most efficient way to find answers to all of the questions below is to use correct formulas in the spreadsheet applet above. If you use formulas that contain cell references (rather than just the numbers), it ill save time since you can grab the lower right corner of the cell to drag such formulas down the column. or example, you can calculate the interest per period in cells E2 to E6 as follows. First, type the following into cell E2: =0.01C2/D2. Make sure you use the arrow key or the mouse to navigate out of the ell. Then, grab the lower right comer of cell E2, and drag the formula down to E6. All of the periodic interest rates will be calculated and the precise unrounded values will be stored in the applet for future eference. Even when rounded values are displayed, the precise values are saved in the background. you decide not to use the spreadsheet, remember that you should not round intermediate steps and only round final answers. inambers and Crane Credit Union (CCCU) offers customers five different savings account options: - Account 1 offers an APR of 9.949%, compounded monthly. - Account 2 offers an APR of 8.797%, compounded annually. - Account 3 offers an APR of 10.827%, compounded quarterly. - Account 4 offers an APR of 9.006%, compounded daily. - Account 5 offers an APR of 11.599%, compounded weekly. Ise this account information to answer the questions below. Round all dollar amounts to the nearest cent ( 2 decimal places). Use this account information to answer the questions below. Round all dollar amounts to the nearest cent (2 decimal places). included in that formula, then you can drag the formula through to D13. This will display all of the APYs in column E. APY should be given as a percent rounded to 3 decimal places. \begin{tabular}{l|l|l} - Account & with an APY of & %. \\ - Account & with an APY of & %. \\ Account & with an APY of & %. \\ - Account & with an APY of & %. \\ Account & with an APY of & %. \\ \hline \end{tabular} (b) Sam is planning to open a bar and grill in Boston, MA, in 7 years. Sam chooses Account 5 at CCCU and deposits $96,350. At the end of 7 years, Sam will have a total of $ In total, Sam will earn $ in interest. and that she earned $ in interest during the 18 months. equipment? Answer first in years, rounded to 2 decimal places. Then, round that answer to days, rounded to the nearest whole number of days (using 365 days per year). Coachwillneedtowaitforatimeoftyears,whichroundstodays. years with the Howe's IB account, Woody has earned $1,114.51 in interest. This means that Woody now has a total (future value) of $ and we can conclude that his continuously compounded interest rate at Howe's IB was approximately % (round the percentage to 3 decimal places)