[EXCEL] Zero coupon bonds: Diane Carter is interested in buying a five-year zero coupon bond with a face value of $1,000. She understands that the market interest rate for similar investments is 9...

[EXCEL] Zero coupon bonds: Diane Carter is interested in buying a five-year zero coupon bond with a face value of $1,000. She understands that the market interest rate for similar investments is 9 percent. Assume annual coupon payments. What is the current value of this bond?
Please use Excel