IN DESPERATE NEED! I cant seem to understand how to get these answers in EXCEL. Points given immediately for the help and forever gratitude!

5 banks offer nominal rates of 6%, but differ in their compounding frequency. Deposit $5.000. What is FV1? Deposit $5.000. What is FV2? Would they be equally able to attract funds? No. People would prefer more compounding to less, What nominal rate would cause all banks to provide same EAR as Bank A? Each of these nominal rates based on the frequency of compounding will provide an EAR of 6% You need $5.000 at the end of the year. How much do you need to deposit annually for A, semiannually, for B, etc. beginning today, to have S5.000 at the end of the year? Even if the banks provided the same EAR, would a rational investor be indifferent between the banks? Probably not. An investor would probably prefer the bank that compounded more frequently. 5 banks offer nominal rates of 6%, but differ in their compounding frequency. Deposit $5.000. What is FV1? Deposit $5.000. What is FV2? Would they be equally able to attract funds? No. People would prefer more compounding to less, What nominal rate would cause all banks to provide same EAR as Bank A? Each of these nominal rates based on the frequency of compounding will provide an EAR of 6% You need $5.000 at the end of the year. How much do you need to deposit annually for A, semiannually, for B, etc. beginning today, to have S5.000 at the end of the year? Even if the banks provided the same EAR, would a rational investor be indifferent between the banks? Probably not. An investor would probably prefer the bank that compounded more frequently