Part(a): It is said that the Indian who sold Manhattan for $33 was a sharp salesman. If he had put his $33 away at 5% compounded semiannually, it would now be worth more than $6 billion, and he could buy most of the now-improved land back Assume that this seller invested on January 1 1701, the $33 he received. (Enter amounts In whole dollars, not in billions. Round finel answers to nearest whole dollar amount.) Required: 1. Use Excel to determine the balance of the investment as of December 31, 2021, assuming a 5% interest rate compounded semiannually (Hint Use the FV function in Excel) 2 Use Excel to determine the balance of the investment as of December 31, 2021, assuming an 6% annual interest rate, compounded semiannually (Hint Use the FV function in Excel) 3. What would be the balances for requirements 1 and 2 if interest id.compounded quarterly 4. Assume that the account consisting of this investment had a balance of $6.5 bilion as of December 31, 2021 How much would the total amount be on December 31, 2027. If the annual interest rates 6 compounded semiannually + Dar Complete this question by entering your answers in the tabs below. Rolosi Reg A2 Req A3 Reg A4 Reg 81 Rog B2 Reg 03 Use Excel to determine the balance of the investment as of December 31, 2021, assuming a 5% interest rate compounded semiannually. (HintUse the FV function in Excel.) Balance of the investment S 188.100.450 Complete this question by entering your answers in the tabs below. Reg A1 Reg AZ Reg AB RM Reg B: Reg 02 Reg Use Excel to determine the balance of the investment as of December 31, 2021, suming an 6% annual interest rate compounded semiannually. (Hint: Use the FV function in Excel.) Balance of the investment Complete this question by entering your answers in the tabs below. Reg A1 Reg A2 Req A3 R44 Req B1 Req B2 Reg B3 Assume that the account consisting of this investment had a balance of $6.5 billion as of December 31, 2021. How much would the total amount be on December 31, 2027, if the annual interest rate is 6%, compounded semiannually? Total amount $