Reference no: EM132953461
Create an Excel File to answer the following questions:
1. A bond has a 5% coupon rate, and matures in 18 years, and has par value $1000. Find the price of the bond today if the yield to maturity is 4% first assuming annual payments, then again with semi-annual.
2. What is the yield to maturity on a semiannual bond with a 9% coupon rate, $1000 par value, and 3 years to maturity if the price of the bond today is $800?
3. Consider two bonds, both with a current YTM of 3.6%. The first pays no coupon (Cr=0%) and matures in 26 years. The second pays an 8% coupon annually and matures in 4 years.
a) Find the price of both bonds under the current YTM of 3.6%
b) Find the price of both bonds if yields drop to 3.3% and the % change in price
c) Find the price of both bonds if yields rise to 3.9% and the % change in price
d) Which bond has more interest rate risk?
|
What is the company wacc
: Smothers Brothers Ltd. is estimating its WACC. The company has collected the following information:
|
|
What is the gross profit margin for swank
: If swank clothier had sales of 368,000 and cost of goods sold of 323,000. What is the gross profit margin (ratio of gross profit to sales)?
|
|
Calculate gain or loss on disposal
: Genetic Insights has a tax rate of 30%. The asset is sold at the end of six years for $3,777. Calculate gain or loss on disposal
|
|
Find the amount of direct materials issued
: During the month of April, the company has the following cost information: Beginning materials inventory 50,100. Find the amount of direct materials issued
|
|
Find the price of bonds under current ytm
: 1. A bond has a 5% coupon rate, and matures in 18 years, and has par value $1000. Find the price of the bond today if the yield to maturity is 4% first assuming
|
|
What is the financial advantage of accepting the offer
: Macy's makes 10,000 units per year of X, and has direct material cost of $10 per unit, What is the financial advantage of accepting the offer
|
|
What will the p-e ratio be for vriend software inc
: Earnings per share is $1.76, and the firm's stock trades in the stock market at 2.5 times book value per share. What will the P/E ratio be?
|
|
What is the value of inventory listed on firm balance sheet
: Accounts receivable makes up another 21 percent of current assets. Burt's current ratio = .86 times. What is the value of inventory listed on the firm's balance
|
|
What will be the value after eight years
: Question - What will be the value after eight years if $10,000 is invested at an annual rate of 3.4% compounded monthly
|