How do you complete the problems below in Excel worksheet.

1. For question 1, how to calculate if Billy Bob deposits $2000.00 in an account that pays 4.25% compounded annually. How much will BB have in his account in 10 years?
2. For question to what are the variables, how to solve the problem, what is the EAR of rate, if Fifteen years ago, Bob purchased an investment for $1,500.If the investment averaged 6% per year return.How much is the investment worth today?
3. For question 3, how to calculate a$1000 deposit in an account earns interest at an annual nominal rate of 8.00%. Interest is compounded monthly in the account.How much money will be in the account at the end of the 10th year?
4. For question 4, how to calculate a zero-coupon bond matures in 10 years and will be worth $1000.00 to the holder. If the bondwas purchased 10 years ago, and yielded a return of 5% per year, how much did the holder pay for the bond? (Assume annual compounding, and answer to the nearest cent-$0.01).
5. For question 5, how to calculate the growth rate and the average annual growth for Big Corporation had the following sales over the last 4 years;
6. For question 6, how to Calculate the EAR for the following annual nominal rates;
7. For question 7, how do you calculate the missing variables in the table below

3) A $1000 deposit in an account earns interest at an annual nominal rate of 8.00%. Interest is compounded monthly in the account. How much money will be in the account at the end of the 10th year? Identify variables given; a) Solve the problem using the cells above. Answer II b) What is the EAR of the rate above compounded monthly? 4) A zero-coupon bond matures in 10 years and will be worth $1000.00 to the holder. If the bond was purchased 10 years ago, and yielded a return of 5% per year, how much did the holder pay for the bond? (Assume annual compounding, and answer to the nearest cent-$0.01).5) Big Corporation had the following sales over the last 4 years; Year Sales (in 0005) 225.00 2 236.25 243.125 4 248.00 a) What was the growth rate in sales between years 1 & 2; b) What is the growth rate in sales between years 3 & 4; c) What is the average annual growth rate for these years? (hint: this is a geometric mean) 6) Calculate the EAR for the following annual nominal rates; Annual Rt. Compounding/yr 10.000% semi-annual 9.875% monthly 9.625% daily7) Complete the missing variables in the table below; Annual nominal Cmpdyear # years 1%/yr (nom) PV FV H H 10.0% $ 1,000.00 5 10.0% $ 1,000.00 10 10.0% $ 1,000.00 1 10 5.0% $ 1,000.00 4 5 10.0% $ 1,000.00 12 5 10.0% $ 1,000.00 10 5.00% $2,000.00 10 10.00% $2,000.00 5 10.00% $2,000.00 4 5 10.00% $2,000.00 12 10.00% $2,000.00 5 $ 1,000.00 $1,338.23 1 10 $ 1,000.00 $1,480.24 12 10 $ 1,000.00 $ 2,451.36 1 8.00% S 1.00 2.00