Hi, Hi, I need help filling out this excel sheet for my Accounting class. Any help would be appreciated, Thanks :)

A sLA 11 PV, LoanAm,Bonds F22 stucont. Home Insert Draw Page Layout Formulas Data Review View Automate Q Tell me Calculate the price of the bond if the market interest rate is 8%. N (period of time) 23 I (Interest) 24 PV [Present Value 25 FV (Future Value) 26 PMT (Annuity) 27 28 29 A sLA 11 PV, LoanAm,Bonds F22 stucont. Home Insert Draw Page Layout Formulas Data Review View Automate Q Tell me c D 6 H I J K L M N D P Q R 5 T Q& amount to put into your 401k every year Part II: You have just won the state lottery and have two choices for collecting your winnings. You can collect $2,000,000 (Option 1) today or receive $500,000 (Option 2) per year for the next four years. A financial analyst has told you that you can earn 6% on your investments. Which option 10 would you choose? \begin{tabular}{|l|l|l|} \cline { 3 - 4 } 11 & & \\ \hline 12 & N (period of time] & \\ \hline 13 & 1 (interest) & \\ \cline { 2 - 3 } 14 & PV \{Present Value & \\ \hline 15 & FV [Future Value) & \\ \hline 16 & PMT [Annuity] & \\ \hline 17 & & \end{tabular} Part IIl: 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 savines account returns an 19 interest rate of 3.50%. 21N (period of time) 22 I (interest) 23 PV \{Present Value 4 FV (Future Value) 25 PMT [Annuity] determine annulty payment to put aside, save which is a monthiy sovings of? Stos BSL, I can wo tiv! You would like to buy a used pick-up truck and will need to borrow $10,000. Your loan will be repaid monthly over 5 years at a 6.75% annual interest rate. Calculate your monthly payment. Students may follow basic amortization formulas (hints in row 12) OR use IPMT, PPMT functions to create table If use IPMI, PPMT then the column for Monthly Payment must be the sum