Please solve these questions in excel

niecount rate in APY, NOT QUARTERLY 20.00% Formula Bar 12 -. J, NOT YEARS 0 1 2 3 4 5 6 7 8 9 10 1 1 Periodic cash flows at the end of each QUARTER 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 You may not need all lines below Discount rate per QUARTER: r Net present value of these cash flows at time 0Interest rate per MONTH 2.00% mums. not months: i Periodic cash flows at the end of each QUARTER 0.00 200.00 230.00 240.00 250.00 260.00 270.00 280.00 290.00 300.00 310.00 You may NOT need all rows below. Compound interest rate per quarter: r Future value of the cash flow stream at the end 0.00 Face value you will receive at maturity Coupon rate: APR paid QUARTERLY Maturity in years Discount rate: APY Pmt: Periodic coupon received Bond price you will need to (pay) at the time of issue: Negative number Amount you will deposit into savings account at the END each MONTH APY that the bank is promising you Number of years for which you will save FV: Future value, the balance you will receive at the end 1 000. 00 6. 00% 1 0. 00 6. 00% 1 00. 00 5. 00% 20. 00