Kindly provide step-by-step instructions;

Apply PRICE and YIELD excel functions to calculate the price and YTM of the firm A, and see if your calculation outcomes "match" the stated price and yield quotes in the below data.

Firm A Bond (US Corporate Bond)

Coupon rate: 7.00% (Semi-annual)

Issue date 6/11/2001

First coupon date: 12/1/2001

Maturity: 06/01/2031

Last Trade Price: $164.93

Price Last trade Yield: 2.460%

Last Trade Date: 3/5/2020