Question

Please solve the below showing all work (no excel, no financial cal.). Thanks. An asset is...

Please solve the below showing all work (no excel, no financial cal.). Thanks.

  1. An asset is expected to make single cash flow payment in 20 years. Calculate its %change in price from a 4% to a 5% yield.

  1. A 20-year annuity pays 5 annually. What is its price at a 4% yield? At 5%? Calculate the %change in price between the two market situations.

  1. Consider a 20-year bond, annual coupon=5. What is its price at a 4% yield? 5%? Calculate the %change in price between the two market situations. How does your answer relate to those in Question 0 and Question 1?

Homework Answers

Answer #1

The solution is provided below:

An asset is expected to make single cash flow payment of 100 in 20 years. Calculate its %change in price from a 4% to a 5% yield.
=(100/1.05^20)/(100/1.04^20)-1=-17.419%

A 20-year annuity pays 5 annually. What is its price at a 4% yield?
=5/4%*(1-1/1.04^20)=67.95163172

At 5%?
=5/5%*(1-1/1.05^20)=62.31105171

Calculate the %change in price between the two market situations.
=(5/5%*(1-1/1.05^20))/(5/4%*(1-1/1.04^20))-1=-8.301%

Consider a 20-year bond, annual coupon=5. What is its price at a 4% yield?
=5/4%*(1-1/1.04^20)+100/1.04^20=113.5903263

At 5%?
=5/5%*(1-1/1.05^20)+100/1.05^20=100

Calculate the %change in price between the two market situations.
=100/113.5903263-1
=-11.964%

How does your answer relate to those in Question 0 and Question 1?

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Please solve this for me step by step (no excel, no financial cal. show algebra)? Thank...
Please solve this for me step by step (no excel, no financial cal. show algebra)? Thank you. You put 100,000 into a money market instrument September 4 2018 for six calendar months at 3%. When it matures, you roll it over for the next six months at 4%. What are the proceeds? Be careful with the day counts. What would need to be the (“equivalent”) rate on a one-year (i.e., non-money market) semi-annual compounding instrument in order to produce the...
Please show how to solve using EXCEL ONLY. 10. Calculate the duration of a $1,000, 12‐year...
Please show how to solve using EXCEL ONLY. 10. Calculate the duration of a $1,000, 12‐year zero coupon bond using annual compounding and a current market rate of 9 percent. 12. Calculate the duration for a $1,000, 4‐year bond with a 4.5 percent annual coupon, currently selling at par. Use the bond’s duration to estimate the percentage change in the bond’s price for a decrease in the market interest rate to 3.5 percent. How different is your answer from the...
Hello, Can you please answer this question with showing work. A four-year bond has an 8%...
Hello, Can you please answer this question with showing work. A four-year bond has an 8% coupon rate and a face value of $1,000. If the current price of the bond is $870.51, calculate the yield to maturity of the bond (assume annual interest payments). Also, indicate whether the bond is a discount bond or a premium bond or a par bond. Thanks
Please show the work in excel be sure to use appropriate formulas to solve each exercise...
Please show the work in excel be sure to use appropriate formulas to solve each exercise or problem. A1 If you deposit $12,000 in a bank account that pays 10% interest annually, how much will be in your account after 7 years? A2.    What is the present value of a security that will pay $10,000 in 20 years at an interest rate of 8%? A3.                 Find the future value of the following ordinary annuities: $600 per year for...
Module 3 Bond Valuation Worksheet – Complete in Excel. Please answer the following questions. 1. Renfro...
Module 3 Bond Valuation Worksheet – Complete in Excel. Please answer the following questions. 1. Renfro Rentals has issued bonds that have an 7% coupon rate, payable semiannually. The bonds mature in 10 years, have a face value of $1,000, and a yield to maturity of 8%. What is the price of the bonds? 2. Thatcher Corporation’s bonds will mature in 30 years. The bonds have a face value of $1,000 and an 7% coupon rate, paid semiannually. The price...
plz show all calculations and don't use excel or financial calculator or table. Suppose there are...
plz show all calculations and don't use excel or financial calculator or table. Suppose there are only 2 investment alternatives: a bank deposit that pays 4% per year and a 2-year coupon bond with 5% annual coupon rate and face value of $1,000. Assume the bank deposit and coupon bond are perfect substitutes. What is the market price of the bond at beginning of year 1? And year 2? Assume now that at the beginning of year 2, the deposit...
SHOW YOUR FULL WORK THANKS 1. Consider two bonds, A and B. Both bonds presently are...
SHOW YOUR FULL WORK THANKS 1. Consider two bonds, A and B. Both bonds presently are selling at their par value of $1,000. Each pays interest of $120 annually. Bond A will mature in five years, while bond B will mature in six years. If the yields to maturity on the two bonds change from 12% to 10%, A. both bonds will increase in value, but bond A will increase more than bond B. B. both bonds will increase in...
PLEASE SOLVE IN EXCEL SHOW ALL WORK! MUST USE FORMULAS!! Thank you!! You are saving for...
PLEASE SOLVE IN EXCEL SHOW ALL WORK! MUST USE FORMULAS!! Thank you!! You are saving for retirement in 40 years. You deposit $20,000 in a bank account today that pays 3.5% interest, compounded semiannually. You leave those funds on deposit until you retire. You also contribute $5,000 a year to a pension plan for 20 years and then you stop making contributions to the fund. You leave your money in the pension fund until you retire. The pension plan grows...
Solve the following question by using the excel sheet on your computer If a bond pays...
Solve the following question by using the excel sheet on your computer If a bond pays $70 in one year and $140 in two years, its present value is $200. Find the interest rate which equates the price of the bonds with the future values discounted. Use in your experiment 10 interest rates (hint: start your calculation from interest rate =1%). Based on your results what is the relationship between the interest rate and the price of the bond?           
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems (provided on page 4) related to risk and return characteristics and stock/bond valuation. You are required to show the following three steps for each problem (sample problems and solutions are provided for guidance): (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. A company’s non-callable...