You have an opportunity to buy a $25,000 bond for $15,000. The coupon amount is $1,000...

You have an opportunity to buy a $25,000 bond for $15,000. The coupon amount is $1,000 each year. It is a 15 year bond.
Part A. Your MARR is 8%. Should you buy the bond? [Leave these calculations on the sheet and then add columns for Part B.]
Part B. If the anticipated rate of inflation is 2.5% and you are willing to accept a MARR of 6% that accounts for inflation, should you buy the bond.

Please use Excel functions and show

Expert Solution

(a) If the bond is purchased, coupon amount of $1000 is received each year for 15 years and $25000 is received at end of 15 years. Hence, cash inflows are $1000 for 14 years and $26000 in 15th year

Let us calculate the Present Value of these returns -

PV Factor = 1 / (1+r)ⁿ

PV = Cash Flow * PV Factor

Hence, PV of returns = $16440.52

Hence, we should purchase the bond for $15000

(b) Let us calculate the above using MARR of 6%

In this case also, we should purchase the bond

jeff jeffy answered 2 years ago

Suppose you buy a bond with a coupon of 7.6 percent today for $1,000. The bond...

Suppose you buy a bond with a coupon of 7.6 percent today for $1,000. The bond has 15 years to maturity. Two years from now, the YTM on your bond has increased by 2 percent, and you decide to sell. What is the percentage realized rate of return? Assume that interest payments are reinvested at the original YTM. The bond pays coupons twice a year. (Do not round intermediate calculations. Round your answer to 2 decimal places.)

Lucia just bought one coupon bond with a principal amount of $1,000 with an annual coupon...

Lucia just bought one coupon bond with a principal amount of $1,000 with an annual coupon rate of 7.1%. The bond pays annual interest payment and will mature in three years. The yield to maturity of this coupon bond is 2.31%. How much did Lucia pay to buy this 3-year coupon bond? Please round your answer to the second decimal. E.g. 1234.56

You buy a 6% coupon $1,000 par T-bond 59 days after the last coupon payment. Settlement...

You buy a 6% coupon $1,000 par T-bond 59 days after the last coupon payment. Settlement occurs in two days. You become the owner 61 days after the last coupon payment (59+2), and there are 121 days remaining until the next coupon payment. The bond’s clean price quote is 120:19. What is the full or dirty price (sometimes called the invoice price)?

You buy a 12-year 5 percent annual coupon bond at par value, $1,000. You sell the...

You buy a 12-year 5 percent annual coupon bond at par value, $1,000. You sell the bond three years later for $1,200. What is your rate of return over this three-year period?

You have a portfolio with $15,000 invested in Stock A with a beta of 2.5, $25,000...

You have a portfolio with $15,000 invested in Stock A with a beta of 2.5, $25,000 invested in stock B with a beta of 0.7, and $10,000 invested in Stock C with a beta of 1.0. If the risk-free rate is 2% and the market risk premium is 6%, what is the required return of the portfolio?

Suppose you buy a 30-year, $1,000 par value bond for $975. The coupon rate is 8%...

Suppose you buy a 30-year, $1,000 par value bond for $975. The coupon rate is 8% and coupon payments are issued annually. You plan to sell the bond in 12 years, at which point you believe the bond's yield to maturity will be 9%. You also forecast a reinvestment rate on the coupons of 7%. What is the annualized compound return on this investment? -6.42% 3.93% 4.99% 7.58% 11.62

A 30 year corporate bond with a face amount of $1,000 and a 5.6% coupon (paid...

A 30 year corporate bond with a face amount of $1,000 and a 5.6% coupon (paid semi-annually) was issued 15 years ago. Given a 30 BPS, what is its effective duration? Assume the current yield to maturity is 6.0%. Show all work.

Assume that you wish to buy a bond with 19 years to maturity, with a par value of $1,000, and a coupon rate of 20.02%.

Assume that you wish to buy a bond with 19 years to maturity, with a par value of $1,000, and a coupon rate of 20.02%. Assume semi-annual payments. If the yield to maturity (YTM) is 20.69%, what is today's price of this bond?

Suppose that you have just paid $1,000 for a 10% coupon bond that matures in 5...

Suppose that you have just paid $1,000 for a 10% coupon bond that matures in 5 years. The face value of the bond is $1,000. You expect that in 1 year you will be able to sell the bond for $1,100. What is the expected rate of return of this investment? A) 0% B) 10% C) more than 10% D) not enough information to answer the question

You are ready to buy a house, and you have $25,000 for a down payment and...

You are ready to buy a house, and you have $25,000 for a down payment and closing costs. Closing costs are estimated to be 4% of the loan value. You have an annual salary of $48,000 (monthly income $4000) , and the bank is willing to allow your monthly mortgage payment to be equal to 25% of your monthly income. The interest rate on the loan is 7.2% per year with monthly compounding (.6% per month) for a 30-year fixed...

Question