Please answer all parts
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), A wall save time since you can grab the lower right corner of the cell to drop 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.01*C2/D2, Make sure you use the arrow key or the mouse to navigate out of the cell. Then, grab the lower right corner of cell E2, and drag the formula down to E6. All of the periodic interest rates wat be calcutated and the precise unrounded values wal be stored in the applet for future reference. Even when rounded values are displayed, the precise values are saved in the background. If you docide 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 sccount options - Account 1 offers an APR of 7.822%, compounded weekly. - Account 2 offers an APR of 8.928%, compounded annually. - Account 3 otfers an APR of 11.036%, compounded daily. - Account 4 offers an APR of 11.679%, compounded quarterly. - Mccount 5 offers an APR of 9,84%, compounded monthly. Use this account information to answer the questions below. Round all dollar amounts to the nearest cent (2 docimal 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 DB. If you type a formula into cell D9 with cell references to B9 and CP included in that formula, then you can drag the formula through to D13. This Wit display ali 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 grestest yield down to the account with the lowest yield. Each account's APY should be given as a percent rounded to 3 decimal places. - Account with an APY of 10 . - Account - with an APr of - - Account - with an APY of K. - Account - wath an APY of - 15. - Accocint - with an APY of F. (b) Sam is planning to open a bar and orill in Boston, MA, in 8 years. Sam cheoses Account 2 at CCCU and deposits 589,750 . At the end of 8 years, Sam will have a total of: in total, Sam will earn 1 in interest. (c) Carla has managed to save a total of $13,750 for her wedding 45 moaths ago, Carla invested her savings in Account 1 at CCCU. We can conclude that the amount of Carla's original invesument was s and that she earned s in interest during the 45 months. (d) Coach Pantusso needs $1,337 for new equipment for his intle league baseball team. He decides to deposi $1,182 at cCcu into Account 3 . (b) Sam is planning to open a bar and grill in Boston, MA, in 8 years, Sam chooses Account 2 at cccu and deposits $89,750. At the end of 8 years, Sam will have a total of $ In total, Sam will earn 1 in interest. (c) Carla has managed to save a total of $13,750 for her wedding. 45 months ago, Carla invested her savings in Account 1 at CCCU. We can conclude that the amount of Caria's original investment was $ and that she earned 1 in interest during the 45 months. (d) Coach Pantusso needs $1,337 for new equipment for his litte league basoball team. He docides to deposit $1,182 ot CCCU into Account 3 . How long will Coach need to wait until he can afford the new equipenent? 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). Coachwillneedtowaitforatimeoftseyears,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,625 he had saved so far. It turns out that over a term of 4.9 years with the Howe's IB account, Woody has earned $1,456.93 in interest. This means that Woody now has a total (future value) of 4 and we can conclude that his continuousty compounded interest rate at Howe's is was approximately % (round the percentage to 3 decimal places)
