Excel Online Structured Actty: Bond valuation You are considering a 30-year, $1,000 par value bond. Its...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Excel Online Structured Actty: Bond valuation You are considering a 30-year, $1,000 par value bond. Its coupon rate is 8%, and interest is paid semiannually. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. X Open spreadsheet If you require an "effective" annual interest rate (not a nominal rate) of 10.9%, how much should you be willing to pay for the bond? Do not round intermediate steps. Round your answer to the nearest cent. $ Check My Work Reset Problem 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Bond valuation Years to maturity Par value of bond Coupon rate Frequency interest paid per year Effective annual rate Calculation of periodic rate: Nominal annual rate Periodic rate Calculation of bond price: Number of periods 15 Interest rate per period Coupon payment per period Par value of bond 16 17 18 Price of bond 30 $1,000.00 8.00% 2 10.90% 0.00% $1,000.00 Formulas #N/A #N/A Formulas #N/A #N/A #N/A Excel Online Structured Actty: Bond valuation You are considering a 30-year, $1,000 par value bond. Its coupon rate is 8%, and interest is paid semiannually. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. X Open spreadsheet If you require an "effective" annual interest rate (not a nominal rate) of 10.9%, how much should you be willing to pay for the bond? Do not round intermediate steps. Round your answer to the nearest cent. $ Check My Work Reset Problem 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Bond valuation Years to maturity Par value of bond Coupon rate Frequency interest paid per year Effective annual rate Calculation of periodic rate: Nominal annual rate Periodic rate Calculation of bond price: Number of periods 15 Interest rate per period Coupon payment per period Par value of bond 16 17 18 Price of bond 30 $1,000.00 8.00% 2 10.90% 0.00% $1,000.00 Formulas #N/A #N/A Formulas #N/A #N/A #N/A
Expert Answer:
Answer rating: 100% (QA)
Bond Valuation Given Par value 1000 Coupon rate 8 paid semiannually Years to maturity 30 Effective a... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Excel Online Structured Activity: Personal taxes Mary Jarvis is a single individual who is working on filing her tax return for the previous year. She has assembled the following relevant...
-
You are an analyst of the FHA program. The program has an upfront insurance premium of 1.75 percent and an annual premium of .85 percent. If a borrower gets a 30-year, 4 percent, fixed-rate mortgage,...
-
SAHOL paid a dividend of 4 TRY last year. The growth rate is 10% and the required rate of return is 30% . What is the intrinsic value of SAHOL share?calculate.
-
There is a bond on the spot-market. Price is 87.63 USD. Risk-free interest rate is 1.22%. The forward-price is 102.78 USD. Is there any arbitrage possibility if time to maturity is 9 months?
-
A telephone line has the following parameters: R = 40 /m, G = 400S/m, L = 0.2H/m, C = 0.5nF/m (a) If the line operates at 10 MHz, calculate the characteristic impedance Zo and velocity u. (b) After...
-
Are exempt employees paid more than nonexempt employees? Are exempt employees expected to complete tasks regardless of the required hours? Why must the job description be reviewed before new hires...
-
What are the key skills required of a key account manager?
-
Video Company, Inc., produces and markets two popular video games, High Ranger and Star Bounder. The closing account balances on the companys balance sheet for last year are as follows: Cash,...
-
A building acquired at the beginning of the year at a cost of $74,000 has an estimated residual value of $3,700 and an estimated useful life of 4 years. Determine the following. (a) The...
-
The model with all useable variables is? Round to 2 decimal places If an answer is 0 (Zero) enter 0.00 4 Price 25099.34 + A A/ * SqFt + Thatched Roof + 46 a
-
How many times is function F called in each code segment? Clearly explain your answer and express bounds in terms of n in big-O notation. Bounds should be as tight as possible. [Of course, you can...
-
Was there ever a concern over the discovery of the investigation and possible destruction of evidence?
-
Is Fairmont in compliance with Federal withholding requirements for FICA and Medicare?
-
Review a gamified system that demonstrates the principles of cognitive apprentice ship. How is the system using expert modeling and other support structures to encourage players to learn to be...
-
Which WorldCom employee initially confessed to the fraud and what was his position?
-
Review a gamified system and look at the ways it provides scaffolding through feedback, modeling, collaboration and recursion.
-
Kula Company Ltd manufactures two products, Flora and Fauna. Estimates for the company's products for next year are provided below: Flora Fauna Estimated production volume 3 000 4 000 Direct material...
-
Rosalie owns 50% of the outstanding stock of Salmon Corporation. In a qualifying stock redemption, Salmon distributes $80,000 to Rosalie in exchange for one-half of her shares, which have a basis of...
-
You are a venture capitalist and have been approached by Cirrus Electronics, a private firm. The firm has no debt outstanding and does not have earnings now but is expected to be earning $15 million...
-
Assume that the average variance of return for an individual security is 50% and that the average covariance is 10%. What is the expected variance of a portfolio of 5, 10, 20, 50, and 100 securities....
-
You have estimated the following cash flows on a project: Year Cash Flow to Equity ($) 0 .. 5,000,000 1 .. 4,000,000 2 .. 4,000,000 3 .. 3,000,000 Plot the NPV profile for this project. What is the...
-
The heat of vaporization of ether is \(25.98 \mathrm{~kJ} / \mathrm{mol}\) at its boiling point, \(34.5^{\circ} \mathrm{C}\). (a) Calculate the rate of change of vapour pressure with temperature...
-
For a gas obeying the equation of state \(V=B+\frac{R T}{P}\), the Joule-Thomson coefficient is given by \[ \mu_{\mathrm{JT}}=-\frac{1}{C_{P}}\left(T \frac{d B}{d T}-B ight) \]
-
Calculate the residual enthalpy and entropy for carbon dioxide at \(393 \mathrm{~K}\) and \(12 \mathrm{MPa}\) using any equation of state.
Study smarter with the SolutionInn App