\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & B & c & D & E & F & 6 & H \\ \hline 2 & ? & 11.167 & 12 & ? & ? & ? & ? \\ \hline 3 & ? & 10.414 & 365 & ? & ? & ? & ? \\ \hline 4 & ? & 11.025 & 1 & ? & ? & ? & ? \\ \hline 5 & ? & 8.994 & 4 & ? & ? & ? & ? \\ \hline 6 & ? & 9.553 & 52 & ? & ? & ? & ? \\ \hlinea & APR & Periods & "(1+r))n1" & APY & & & \\ \hline 9 & 11.167 & 12 & ? & ? & & & \\ \hline 10 & 10.414 & 365 & ? & ? & & & \\ \hline 11 & 11.025 & 1 & ? & ? & & & \\ \hline 12 & 8.994 & 4 & ? & ? & & & \\ \hline 13 & 9.553 & 52 & ? & ? & & & \\ \hline \end{tabular} 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 rormulas that contain cell references (rather than just the numbers), it will save time since you can grab the lower night corner of the cell to drog such formulas down the column: For 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 cell. 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 reference, Even when rounded values are displayed, the precise values are saved in the background. If you decide not to use the spreadsheet, remember that you should not round intermediate steps and only round final answers. Chambers and Crane Credit Union (CCCU) offers customers five different savings account options: - Account 1 offers an APR of 11.167% compounded monthly. - Account 2 offers an APR of 10.414%, compounded dally. - Account 3 offers an APR of 11.025% compounded annually. - Account 4 offers an APR of 8.994% compounded quarterly. - Account 5 offers an APR of 9.553% compounded weekly. Use this account information to answer the questions below. Round all dollar amounts to the nearest cent ( 2 decimal places). (a) Use the orange block of the spreadsheet applet to find the APY for each account. The formula to use is given in the column heading D8. If you type a formuls into cell D9 with cell references to 89 and C9 included in that formula, then you can drog the formula through to D13. This will display all of the APVs in column E? After computing each account's APY, rank cccurs five account options below by listing them in order from the account producing the greatest yield down to the account whth the lowest yield. Each account's APY should be given as a percent rounded to 3 decimal places. - 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 %. (b) Sam is planning to open a bar and grit in Boston, MA in 7 years, Sam chooses Account 1 at CcCu and deposits $203,400. At the end of 7 years, Sam will have a total of 5 in total Sam will earn! in interest. (c) Cara has manvged to save a tota of \$14,000 for her wedding. 15 montrs ago, Carla invested her savings in Account 5 at CcCu. We can conclude that the amount of Carla's original investment was! and that she earned! in interest during the 15 months. (d) Cosch Pantusso needs \$1,731 for new equipment for his nitte lespue baseball team. He decides to deposit \$1, 507 at CCCU into Account 4. How long will Cosch need to wait until he can afford the new equipment? Answer first in years rounded to 2 decimal places, Then, round that answer to days, rounded to the nearest whole number of day lusing 365 doys persear)? Coach will need to wat for a time of t a years, which rounds to days account at cccu and had to instesd do busineas with Howe s livestnent eane. Howes offered form an account with cont inuous compound ing and Woody deposited the Sh round the percentage to 3 gecimal places