use excel it solve

6. You are considering buying a bond on the secondary market issued by Tesla, Inc., an American automotive and energy company. The bond has a face value of $1,000. a 4% coupon rate, and has three years left to maturity. (a) (10 points) Suppose that comparable bonds to the Tesla bond (i.e., same risk pro- file, time to maturity, etc.) are newly issued today with a coupon rate of 2%. What will the price of the Tesla bond be in relation to the face value of the Tesla bond (i.e., will the Tesla bond trade a discount, premium. or at the par value)? Explain your answer. (b) (10 points) What is the general relationship between bond prices and market in- terest rates