**Question **# The final value in each Amount column represents the value of yourinvestment at the end of four years at the particular bank for that column. 1) What is your final balance in Bank C after 4 years (48 months)? 2) Which bank will maximize the return on your investment? 3) How does the frequency of compounding affect the growth of investment? 4) Which has a greater impact on the rate of growth of your investment, the change from annual to quarterly compounding, or the change from quarterly to monthly compounding? 5) To appreciate the power of your spreadsheet, try changing the annual interest rates (APR) for banks A and B so that all three banks produce the same final balance. 6) Then change the APRS back to 4.0% and try extending the spreadsheet to find the balances for all three banks after 6 years. Find how much money needs to be deposited now into an account to obtain$4,100 (Future Value) in 6 years if the interest rate is 6% per year compounded monthly (12 times per year). Find the time required for an investment of 5000 dollars to grow to 7000dollars at an interest rate of 7.5 percent per year, compounded quarterly.Round your answer to two decimal places Your answer is ou currently have $3,500 (Present Value) in an account that has an interest rate of 7% per year compounded daily (365 times per year). You want to withdraw all your money when it reaches $8,750 (Future Value). In how many years will you be able to withdraw all your money? The number of years is 10) Suppose you want to have $800,000 for retirement in 30 years. Your account earns 10% interest. How much would you need to deposit in the account each month? You want to buy a $205,000 home. You plan to pay 20% as a down payment,and take out a 30 year loan for the rest. a) How much is the loan amount going to be? What will your monthly payments be if the interest rate is 6%? ) What will your monthly payments be if the interest rate is 7%? 12) The city of Raleigh has 8600 registered voters. There are two candidates for city council in an upcoming election: Brown and Feliz. The day before the election, a telephone poll of 550 randomly selected registered voters was conducted. 277 said they'd vote for Brown, 234 said they'd vote for Feliz, and 39were undecided. Give the sample statistic for the proportion of voters surveyed who said they'd vote for Brown.percent.: The proportion should be a fraction or decimal, not a percent