could you please help me solve B and E the parts in red are ones i am struggling with! thank you!!

Chambers and Crane Crodit Union (Cecu) oftors customers tive diferent savings account options: - Account 1 offers an APR of 8.8%, compounded annually. - Account 2 offers an APR of 8.841%, compounded monthly. - Account 3 offers an APR of 11.067%, compounded daly. - Account 4 otfers an APR of 9.878%, compounded weekly. - Acoount 5 offers an APR of 11.414%, compounded quarterly. Use this account information to answer the questions bolow. 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 formula into cell D9 with cell references to B9 and C9 included in that formula, then you can drag the formula through to D13, This will display all of the APYs in column E. After computing each account's APY, rank cCCU's five account options below by listing them in order from the account producing the greatest yieid down to the account with the lowest yield. Each account's APY should be given as a percent rounded to 3 decimal places. b) Sam is planning to open a bar and grill in Boston, MA, in 5 years. Sam chooses Account 4 at CCCU and deposits $95,900. At the end of 5 ears, Sarn will have a total of $ in total, Sam will earn s in interest. (b) Sam is planning to open a bat and arill in Boston, MA, in 5 years. Sam chooses Account 4 at CCCU and deposits $95,900. At the end of 5 . years, Sam will have a total of $ In total, Sam will earn $ in interest. (c) Carla has managed to save a total of $12,980 for her wedding. 18 months ago, Carla invested her savings in Account 3 at cCcU. We can conclude that the amount of Carla's original investment was $ and that she earned s in interest during the 18 months: (d) Coach Pantusso needs $1,258 for new equipment for his little league baseball team. He decides to deposit $1,106 at cccu into Account 2 How long will Coach 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 days (using 365 days per year). Coachwillneedtowaitforatimeoftadyears,whichroundstodays. (e) Woody has been saving money because Norm and Cliff have promised to take him on a cross-country snipe hunt. However, Woody was unable to get approved for an account at CCCU and had to instead do business with Howe's investment Bank. Howe's offered him an account with continuous compounding and Woody deposited the $2,545 he had saved so far. It turns out that over a term of 5 years with the Howe's is account, Woody has earned \$724ghin interest. This means that Woody now has a total (future value) of $ and we can conclude that his continuously compounded intelidt rate at Howe's iB was approximately (round the percentage to 3 decimal places)