Read prompts and fill out the missing info with full excel formulas.

1 Richmond Company issues bonds with a face value of $20,000,000 that pay 6% interest semiannually and mature in 10 years. Calculate the price of the bond if the market interest rate is 6%. Calculate the price of the bond if the market interest rate is 4%. N (period of time) I (Interest) PV (Present Value 8%. 2N (period of time) 3 I (Interest) 4 PV (Present Value 401k each year, which is $19,500. If your 401k earns 8% each year, what will your balance be when you turn 53 years old? Part II: You have just won the state lottery and have two choices for collecting your winnings. You can collect $1,200,000 (Option 1) today or receive $300,000 (Option 2) per year for the next four years. A financial analyst has told you that you can earn 5.50% on your investments. Which option would you choose? Part III: You have decided that you would like to buy a townhouse in 8 years and will need a down payment of $30,000. How much do you need to save each year if your savings account returns an interest rate of 3.50% You would like to buy a motorcycle and will need to borrow $10,000 to do so. Your loan will be repaid monthly over 4 years at a 7.50% annual interest rate. Calculate your monthly payment