How to calculate a bond price with real bond data with a par value of $1,000?

Bond in question:

Macy's HLDGS INC

Symbol- MT.AL

Callable - No

Type - Corporate Bond

Coupon - 6.79

Maturity- 7/15/2027

Price - $110.375

Yield- 5.123

When I do PV in excel I come up with a bond price of $586.15, shouldn't I come up with a value closer to the last price sold of $110.375 ?

Bond YTM Maturity Years Since Issued Years to Maturity 30 -22 Compounded Yearly 2 Coupon Rate 6.79% Par Value $ 1,000.00 Payment O PV of Bond ($586.15) PV((rate/compounded),Int* Compounded,pmt, fv)