Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

1. (12.5 Points) What is the market interest rate on XYZ’s debt and its component cost

Question

1. (12.5 Points) What is the market interest rate on XYZ’s debt and its component cost

of debt? I know n=30, PV=1153.72, PV=1000, however I am not sure where to go from here within excel.

Coupon rate = 12%

Coupons per year = 2

Years to maturity = 15

Price = $1,153.72

Face value = $1,000

Tax rate = 40%

I need to find the following

What is the Market Interest Rate =

What is the Cost of Debt = 

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"