please explain this in excel with formulas given

what else you need? as you mentioned it's incomplete question??

it's a zero coupan bond,

you still need a interest rate or Yield?

B D E F G H N - 1 2 3 A) An investor considers the purchase of 1-year annual zero- coupon Bond H to be issued 1 year from today with a face 6 value of $100. The price of the Bond H is closet to: 4 5 7 8 10 a 11 b 9 Group of answer choices 97.266 97.276 98.266 98.276 12 C 13 d 14 15 16 B) 17 An investor considers the purchase of 2-year annual zero-coupon 19 Bond I to be issued 1 year from today with a face value of $100. 20 The price of the Bond I is closet to: 18 21 22 Group of answer choices 23 a 94.719 24 b 95.719 25 c 96.719 97.719 27 26 d 28 B D E F G H N - 1 2 3 A) An investor considers the purchase of 1-year annual zero- coupon Bond H to be issued 1 year from today with a face 6 value of $100. The price of the Bond H is closet to: 4 5 7 8 10 a 11 b 9 Group of answer choices 97.266 97.276 98.266 98.276 12 C 13 d 14 15 16 B) 17 An investor considers the purchase of 2-year annual zero-coupon 19 Bond I to be issued 1 year from today with a face value of $100. 20 The price of the Bond I is closet to: 18 21 22 Group of answer choices 23 a 94.719 24 b 95.719 25 c 96.719 97.719 27 26 d 28