Calculate the duration (and price) of a bond with the following characteristics: A semi-annual payment bond with a $1,000 face value, a 4,5% coupon rate, a 7.8% YTM, and 8 years to maturity. Show your table of calculations or show Excel inputs if using the Excel commands.
Q: A 30-year fully amortizing mortgage loan was made 10 years ago for $75,000 at 6 percent interest.…
A: A debt is a source of capital that is borrowed by institutions at a predetermined rate of interest,…
Q: You deposit $700 each month into an account earning 3% interest compounded monthly. a) How many…
A: Future value is the amount that existing assets are worth at a specific future date after they have…
Q: Greta has risk aversion of A = 3 and a 1-year investment horizon. She is pondering two portfolios,…
A: An investment or portfolio's risk-adjusted return is measured by the Sharpe Ratio. It was created by…
Q: The $45 million lottery prize that you have just won actually pays out $4.5 million a year for 20…
A: The topic is related to financial mathematics, more precisely to the process of calculating a cash…
Q: Nokela Industries purchases a $ 38.8 million cyclo-converter. The cyclo-converter will be…
A: Depreciation and its tax shield do not affecct the cash flows directly but it have an indirect…
Q: You are a manager at Northern Fibre, which is considering expanding its operations in synthetic…
A: Cash flow refers is a financial concept that shows the cash generated by the company after deducting…
Q: All the securities below have annual payments. [Do not round interim calculations] Security…
A: Price of the bond refers to the current price or present value of the bond if it is held until…
Q: Assuming a 10 percent annual interest rate, create a table showing the factor by which $1 will grow…
A: The time value of money recognizes the idea that the value of an amount of money today differs from…
Q: splits two-tor-one in the last period. 90 P1 100 95 200 45 200 110 A B C Po 90 50 100 Rate of return…
A: StocksPrice at time =0Shares outstandingPrice at time= 1Outstanding shares at 1Price at time…
Q: You have been scouring The Wall Street Journal looking for stocks that are "good values" and have…
A: To solve this question we will apply the concept and theory of CAPM here.CAPM stands for Capital…
Q: Find the value of the annuity at the end of the indicated number of years. Assume that the interest…
A: Amount of deposit = 250Interest rate= 3%Time =20 yearsTo find: The value of the annuity at the end…
Q: (Computing rates of return) From the following price data, compute the annual rates of return for…
A: Rate of return = [(V1 - V0) / V0 ] X 100WhereV1= Current valueV0 = Previous value
Q: What would be the average tax rate for a person who paid taxes of $4,584 on a taxable income of…
A: Tax paid = $4,584Taxable Income = $41,670Average tax rate is the tax paid, expressed as a percentage…
Q: A Family certifies it has or owns the following items: 10,000 in a foreign bank savings account Two…
A: The word "cash value" describes an asset's monetary worth, usually expressed as its face value or…
Q: $11,000 each after three years and after five years. If the company requires a return on investment…
A: The net present value compares the present value of anticipated cash inflows and expenditures to…
Q: Consider the following information for stocks A, B, and C. The returns on the three stocks are…
A: As per CAPM :-Expected Return, E(R) = Rf + (Rm - Rf) * Betawhere Rf = Risk free return,Rm = Market…
Q: Taylor & Co. had earnings per share of $3.50, and it paid a $0.90 dividend. Total retained earnings…
A: Earnings per share$3.50Dividend paid$0.90Retained earnings increased$5,200,000Book value per…
Q: In analyzing two firms in the same industry, we gather the following information: Firm A Net income…
A: Return on equity is the important measure of profitability and its shows the profit earned by equity…
Q: A company reports the following for the prior year: $1.6 million in sales $1 million in total assets…
A: Sales last year=$1600000Total assets=$1000000Net income=$160000Account payable=$48000Accrued…
Q: Financial analysts have estimated the returns on shares of the Goldday Corporation and the overall…
A: Covariance between the two portfolios refers to the relationship between two portfolios and the…
Q: of 13.7% and the US treasury bill rate is 1.53% p.a., what is the expected return on the market for…
A: The capital asset pricing model aids analysts and investors in calculating the expected return on…
Q: today and $515 in 10 months at 2.95% interest compounded semi-annually. Due to insufficient funds,…
A: First payment $350 todaySecond payment of 515 in 10 monthInterest rate=2.95% compounding semi…
Q: Required information Assume you pay the reduced amount of $4,405 for a corporate stock that has a…
A: Present value:A financial concept known as "present value" shows how much a future cash flow or…
Q: If you do not have past data to generate cash flows forecasting, which approach should you adopt for…
A: Valuing a new non-public company without past data for cash flow forecasting can be a challenging…
Q: Q2 (Exercise 5.8) The S&R index spot price is 1100, the continuously compounded risk-free rate is…
A: Cash and carry arbitrage:Cash and carry arbitrage is a trading strategy that involves buying an…
Q: Hungry Whale Seacraft Company has 9% annual coupon bonds that are callable and have 18 years left…
A: YTM is yield to maturity It is the percentage of earnings or return an investor expects if the…
Q: Ratios Calculated Year 1 Year 2 5.20 Inventory turnover 10.40 Debt-to-equity 0.70 Price-to-cash-flow…
A: Financial ratios are based on the relationship between two financial line items. For instance the…
Q: A bond has 4-years left to maturity and offers a 5.5% coupon rate paid annually. The bond is priced…
A: Current price of bond is the price which can be paid for purchase of the bond. It is also called…
Q: Amount to be invested Annual net cash flows: Year 1 Year 2 Year 3 Year Maintenance Equipment…
A: Net present value or NPV is the modern technique for capital budgeting. It is the most appropriate…
Q: Your answer is incorrect. A bank is currently offering a savings account paying an interest rate of…
A: Interest rate = 8.4%Compounding frequency = 4New compounding frequency = 12
Q: In saving for a future major purchace, Oksana has been making uniform deposits of $4,000 per year in…
A: Annual deposits = $4000Interest rate from period 1 till 3 = 8%Interest rate from period 4 till 5 =…
Q: Problem 1-44 (LO 1-3, LO 1-4) (Algo) Hugh has the choice between investing in a City of Heflin bond…
A: Interest rate on City of Heflin bond = 3.45%Interest rate on Surething Incorporated bond = 4.75%Tax…
Q: The Bandon Pine Corporation's purchases from suppliers in a quarter are equal to 65 percent of the…
A: Cash budget is that which is prepared in every organization. It helps in future cash maintenance for…
Q: For the year ended June 30, 20X9, a university assessed its students a total of $4,000,000 for…
A: The objective of the question is to calculate the net revenue from tuition and fees that should be…
Q: A-17. A taxpayer (civilian) was transferred by his employer from Miami to Los Angeles in 2022 and…
A: When a taxpayer undergoes a job-related relocation, the reimbursement for moving expenses is a…
Q: Stinnett Transmissions, Incorporated, has the following estimates for its new gear assembly project:…
A: GivenUnit sales = 90000Unit price = $1220Unit variable = $380Fixed cost (million) = $3.75
Q: Present Value of an Annuity What is the present value of a $1,600 annuity payment over 6 years if…
A: An annuity refers to a series of cash flows occurring at regular periodic intervals. Here the amount…
Q: A particular stock has a dividend yield of 1.3 percent. Last year, the stock price fell from $72 to…
A: Ending Price = $56Initial Price = $72Capital gains yield = (Ending Price - Initial Price) / Initial…
Q: Suppose Jorge Otero has set up an annuity due with a certain credit union. At the beginning of each…
A: Compound = Monthly = 12Payment = p = $140Interest rate = r = 6 / 12 = 0.5%Time = t = 17Payment Type…
Q: Sparkle, Inc., sells customized accessories. Currently, it sells 10, 000 sparkly phone cases…
A: Incremental cash flows in capital budgeting refer to the additional cash flows generated by a…
Q: Consider the portfolios constructed from the two risky securities with expected turns, standard…
A: In finance, the minimum variance line signifies the ideal balance between risk and return in a…
Q: Which of the following statements is incorrect? a. when market rates are changing, the discount rate…
A: b. money market interest rates tend to respond quickly to Federal Reserve open market operations:…
Q: . Which financial information is found in a company's annual report? A. Employee salaries B.…
A: Financial statements are legal documents that show the business and financial condition of a…
Q: Man - Duen wants to buy a $28, 000.00 T-bill that matures on 2019-12-08. His target price is $…
A: Face value=28000Price=27729.66Simple interest=3.12%
Q: As part of your retirement plan, you have decided to deposit $6,000 at the beginning of each year…
A: “Since you have posted a question with multiple sub parts, we will provide the solution only to the…
Q: (1) (11) (III) Your manager has asked you (i) to compute the rate of return and standard deviation…
A: Risk and return are essential concepts that symbolize the trade-offs that investors must make.…
Q: John and Rosamond want to retire in 5 years and can save $140 every three months. They plan to…
A: Future value is a financial concept that is crucial to understanding the satisfaction of income over…
Q: fter 5 years, you decide not to use the money for a car. Instead, you'll take $10,000 to buy a…
A: Price of home=$375000Down payment=$8000Interest rate=5.75%Period=30 years(Note=in this first three…
Q: Your car dealer is willing to lease you a new car for $399 a month for 48 months. Payments are due…
A: The monthly payment is $399.The period of the lease i 48 months.The cost of money is 3%.
Q: The following table contains yearly rate of returns on Pepsi and Sprite from 2020 to 2023: 2020 2021…
A: The solution requires understanding of the portfolio theory. RRC stands for return per unit of risk…
Calculate the duration (and price) of a bond with the following characteristics: A semi-annual payment bond with a $1,000 face value, a 4,5% coupon rate, a 7.8% YTM, and 8 years to maturity. Show your table of calculations or show Excel inputs if using the Excel commands.
Step by step
Solved in 3 steps with 1 images
- Calculate the duration (and price ) of a bond with the following characteristics: A semi - annual payment bond with a $1,000 face value, a 4.5% coupon rate, a 7.8% YTM, and 8 years to maturity. Show your table of calculations or show Excel inputs if using the Excel commands.Submit your solutions as an Excel document. Be sure to clearly label the various parts of the problem. 1. Consider the following two bonds that make semi- annual coupon payments. Assume the first coupon payment occurs in exactly six months, and the bond has a face value of $1000 Coupon Rate Time to Maturity YTM Bond A 3.80 % 8 years 3.6% Bond B 3.80% 18 years 4.2% d.) Use a spreadsheet to compute the annualized Macaulay duration and modified duration for Bond A at a yield to maturity of 3.6% Provide an interpretation of the modified duration with regards to maturity and interest rate risk. e.) Use a spreadsheet to calculate the annualized convexity measure of Bond A at a YTM of 3.696. f.) Using the duration approximation formula with a convexity adjustment. what percentage change in the price of Bond A would you expect if the yield decreases by 150 ?Show all workings. Complete the following table and draw a graph showing how bond pricefor each bond changes over time as they move towards their maturitydates. Describe the relationship between bond prices and timeremaining for maturity.YearsreminingtomaturityBOND ACoupon rate = 8% p.a.Market interest rate =6% p.a.BOND BCoupon rate = 6% p.a.Market interest rate =6% p.a.BOND CCoupon rate = 4% p.a.Market interest rate =6% p.a.109876543210
- All computations must be done and shown manually Question 4 Complete the following table and draw a graph showing how bond price for each bond changes over time as they move towards their maturity dates. Describe the relationship between bond prices and time remaining for maturity. Please include graph as per above information Years remaining to maturity BOND A Coupon. rate = 8% p.a. Market interest rate = 6% p.a. BOND B Coupon rate = 6% p.a. Market interest rate = 6% p.a. BOND C Coupon rate = 4% p.a. Market interest rate = 6% p.a. 10 9 8 7 6 5 4 3 2 1 0Submit your solutions as an Excel document. Be sure to clearly label the various parts of the problem. 1. Consider the following two bonds that make semi - annual coupon payments. Assume the first coupon payment occurs in exactly six months, and the bond has a face value of $1000. Coupon Rate Time to Maturity YTM Bond A 3.80% 8 years 3.6% Bond B 3.80% 18 years 4.2% a.) What is the current price (t = 0) of Bond A? Be sure to set up the valuation equation. b.) What will be the price of Bond A exactly halfway in between t = 0 and the first coupon date? c.) Using a spreadsheet, plot the price - yield relationship for both Bond A and Bond B on the same set of axes. Do this for a range of yields from 2% to 11% (in increments of 50 basis points). d.) Use a spreadsheet to compute the annualized Macaulay duration and modified duration for Bond A at a yield - to - maturity of 3.6%. Provide an interpretation of the modified duration with regards to maturity and interest rate risk. e.) Use a…Calculate YTC using a financial calculator by entering the number of payment periods until call for N, the price of the bond for PV, the interest payments for PMT, and the call price for FV. Then you can solve for 1/YR YTC. Again, remember you need to make the appropriate adjustments for a semiannual bond and realize that the calculated 1/YR is on a periodic basis so you will need to multiply the rate by 2 to obtain the annual rate. In addition, you need to make sure that the signs for PMT and FV are identical and the opposite sign is used for PV; otherwise, your answer will be incorrect. A company is more likely to call its bonds if they are able to replace their current high-coupon debt with less expensive financing. A bond is more likely to be called if its price is above par-because this means that the going market interest rate is less than its coupon rate. Quantitative Problem: Ace Products has a bond issue outstanding with 15 years remaining to maturity, a coupon rate of 8.4%…
- Using a spreadsheet, find the yield-to-maturity (YTM) on an 8-year, 6% coupon bond such that the present value of its coupons equals the present value of its par value. Report your answer as a percentage with 2-digit precision (ex. show 12.3456% as 12.35). hint: "Goal seek"An investor has two bonds in her portfolio, Bond C and Bond Z. Each bond matures in 4 years, has a face value of $1,000, and has a yield to maturity of 8.9%. Bond C pays a 11% annual coupon, while Bond Z is a zero coupon bond. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Assuming that the yield to maturity of each bond remains at 8.9% over the next 4 years, calculate the price of the bonds at each of the following years to maturity. Do not round intermediate calculations. Round your answers to the nearest cent. Years to Maturity Price of Bond C Price of Bond Z 4 $ fill in the blank 2 $ fill in the blank 3 3 $ fill in the blank 4 $ fill in the blank 5 2 $ fill in the blank 6 $ fill in the blank 7 1 $ fill in the blank 8 $ fill in the blank 9 0 $ fill in the blank 10 $ fill in the blank 11Unlike the coupon interest rate, which is fixed, a bond's yield varies from day to day depending on market conditions. To be most useful, it should give us an estimate of the rate of return an investor would earn if that investor purchased the bond today and held it for its remaining life. There are three different yield calculations: Current yield, yield to maturity, and yield to call. A bond's current yield is calculated as the annual interest payment divided by the current price. Unlike the yield to maturity or the yield to call, it does not represent the actual return that investors should expect because it does not account for the capital gain or loss that will be realized if the bond is held until it matures or is called. This yield was popular before calculators and computers came along because it was easy to calculate; however, because it can be misleading, the yield to maturity and yield to call are more relevant. The yield to maturity (YTM) is the rate of return earned on a…
- Use of a financial calculator or Excel (functions PRICE and YIELD will be helpful) will be helpful to calculate the following problems. Show your work, include your calculator entries (i.e. N, PV, PMT, FV, IM, and/or Excel formulas where applicable. 1. Suppose there is a bond with a par value of $1,000 that matures in 6 years. Coupon payments are made annually. The coupon rate is 9%. It has a 12% yield to maturity. The annual coupon payments = $ b. The price of the bond today (present value) = $Suppose you looking at a certain bond whose current market price is $935. The bond has a 6.00% coupon rate, pays annual coupon payments and has a 12 year maturity. Assume also that the current open market YTM is 7.00%. Based upon this information, answer the following questions. [3 parts] Show all work. Clearly label your answers for Part A, Part B, and Part C. Carry all calculations out to four (4) decimal places (except dollars and cents). Highlight in bold your answer. a) Based upon the bond’s features, determine what the bond’s current price ($) should be. (Use the present value method to determine the price) b) Based upon your calculated price in Part 1, is the open market price of the bond correct? If the bond is over/under priced, by how much is the bond mispriced? c) Based strictly upon your answer in part 2, would you buy the bond? Explain your answer.All computations must be done and shown manually Question 4 Complete the following table and draw a graph showing how bond price for each bond changes over time as they move towards their maturity dates. Describe the relationship between bond prices and time remaining for maturity. Years remaining to maturity BOND A Coupon. rate = 8% p.a. Market interest rate = 6% p.a. BOND B Coupon rate = 6% p.a. Market interest rate = 6% p.a. BOND C Coupon rate = 4% p.a. Market interest rate = 6% p.a. 10 9 8 7 6 5 4 3 2 1 0