Suppose that General Motors Acceptance Corporation issued a bond with 10 years until maturity, a face...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Suppose that General Motors Acceptance Corporation issued a bond with 10 years until maturity, a face value of $1,000, and a coupon rate of 7% (annual payments). The yield to maturity on this bond when it was issued was 6%. Assuming the yield to maturity remains constant, what is the price of the bond immediately after it makes its first coupon payment? Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section. Maturity (years) Face value 2 3 Coupon rate Yield to maturity Coupon Remaining Maturity (years) Bond price Requirements 1 10 1,000 7% 6% In cell D11, by using cell references, calculate the coupon payment of the bond (1 pt.). In cell D12, by using cell references, calculate the number of periods left on the bond (1 pt.). In cell D13, by using cell references, calculate the price of the bond (1 pt.). Note: The output of the expression or function you typed in this cell is expected as a positive number. Suppose that General Motors Acceptance Corporation issued a bond with 10 years until maturity, a face value of $1,000, and a coupon rate of 7% (annual payments). The yield to maturity on this bond when it was issued was 6%. Assuming the yield to maturity remains constant, what is the price of the bond immediately after it makes its first coupon payment? Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section. Maturity (years) Face value 2 3 Coupon rate Yield to maturity Coupon Remaining Maturity (years) Bond price Requirements 1 10 1,000 7% 6% In cell D11, by using cell references, calculate the coupon payment of the bond (1 pt.). In cell D12, by using cell references, calculate the number of periods left on the bond (1 pt.). In cell D13, by using cell references, calculate the price of the bond (1 pt.). Note: The output of the expression or function you typed in this cell is expected as a positive number.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these finance questions
-
Derby Chips is an international producer of corn chips. At the end of 2006, Mary Hahn, president of Derby, appointed a task force to focus on the packaging and product use segments of its products...
-
Suppose that Ally Financial Inc. issued a bond with 10 years until maturity, a face value of $1000, and a coupon rate of 7% (annual payments). The yield to maturity on this bond when it was issued...
-
Suppose that General Motors Acceptance Corporation issued a bond with 10 years until maturity, a face value of $1000, and a coupon rate of 7% (annual payments). The yield to maturity on this bond...
-
In a closed economy, prices are constant/fixed. Behaviour is characterised by the following relationships. C=0.9375 (Y-T), T=10 and I=50-250i Money demand Md=Y-100i The supply of money and government...
-
First-order Bragg diffraction is observed at 25.2 related to the crystal surface, with spacing between atoms of 0.24 nm. (a) At what angle will second order be observed? (b) What is the wavelength of...
-
Consider the fuel element of Example 5.9. Initially, the element is at a uniform temperature of 250C with no heat generation. Suddenly, the element is inserted into the reactor core causing a uniform...
-
By using the five principles of regulatory design outlined in this chapter, consider how ecological reporting to external stakeholders provides a fundamental foundation for regulation of...
-
The following is an alphabetical list of the December 31, 2007 balance sheet accounts and amounts for the Green Manufacturing Company: Required Prepare a properly classified balance sheet for the...
-
In a water pump device, a rope-pulley system is used to connect a diesel engine to the pump transferring 650 kW. The pulley has a diameter of 350 cm and runs at 100 r.p.m. The angle of lap is 150 and...
-
A $1000, 9.5% bond with semi-annual coupons redeemable at par on March 1, 2026, was purchased on September 19, 2017, to yield 7% compounded semi-annually. What was the purchase price?
-
In February, the price of gasoline increased by 30 % from January. In March, the price of gasoline decreased by 20%. By what percentage did the gasoline price change during this 2 months period?
-
Raner, Harris and Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices-one in Chicago and one in Minneapolis. The firm classifies...
-
Consider what stakeholders must be present to implement these initiatives, and reflect on the leadership strategies needed for success in promoting quality improvement initiatives in healthcare...
-
A patient with a dislocated shoulder is put into a traction apparatus as shown in the figure below. The pulls A and B have equal magnitudes and must combine to produce an outward traction force of...
-
How does advanced pavement engineering utilize techniques such as mechanistic-empirical design and life cycle cost analysis to develop sustainable transportation infrastructure that can withstand...
-
How do advanced seismic hazard assessment methods, including probabilistic seismic hazard analysis (PSHA) and ground motion simulation techniques, contribute to the development of resilient...
-
Nick's Novelties, Incorporated, is considering the purchase of new electronic games to place in its amusement houses. The games would cost a total of $380,000, have a fifteen-year useful life, and...
-
The process of collaborative goal setting by a manager and subordinate, the extent to which goals are accomplished is a major factor in evaluating and rewarding the subordinate's performance. It is...
-
You own your own firm, and you want to raise $30 million to fund an expansion. Currently, you own 100% of the firms equity, and the firm has no debt. To raise the $30 million solely through equity,...
-
Using the same data as in Problem 11, estimate the 95% confidence interval for the alpha and beta of Nike and Dell stock using Excels regression tool (from the data analysis menu) or the linest()...
-
You are considering moving your money to a new bank offering a one-year CD that pays an 8% APR with monthly compounding. Your current banks manager offers to match the rate you have been offered. The...
-
The armature of a variable-speed electric motor, of mass \(200 \mathrm{~kg}\), has an unbalance due to manufacturing errors. The motor is mounted on an isolator having a stiffness of \(10 \mathrm{kN}...
-
It is found that an exhaust fan, of mass \(80 \mathrm{~kg}\) and operating speed \(1000 \mathrm{rpm}\), produces a repeating force of \(10,000 \mathrm{~N}\) on its rigid base. If the maximum force...
-
A dishwashing machine weighing \(75 \mathrm{~kg}\) operates at \(300 \mathrm{rpm}\). Find the minimum static deflection of an isolator that provides 60 percent isolation. Assume that the damping in...
Study smarter with the SolutionInn App