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%. What was the price of this bond when it was issued? 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 Coupon rate Yield to maturity Coupon Bond price 10 $ 1,000 7% 6% In cell D11, by using cell references, calculate the coupon payment of the bond In cell D12, by using cell references, calculate the price of the bond when it was issued. 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%. What was the price of this bond when it was issued? 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 Coupon rate Yield to maturity Coupon Bond price 10 $ 1,000 7% 6% In cell D11, by using cell references, calculate the coupon payment of the bond In cell D12, by using cell references, calculate the price of the bond when it was issued. Note: The output of the expression or function you typed in this cell is expected as a positive number.
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
A torsion pendulum consists of a metal disk with a wire running through its center and soldered in place. The wire is mounted vertically on clamps and pulled taut. Figure a gives the magnitude ? of...
-
How many possible IRRs could you find for the following set of cash flows? Discuss. Time 1 4 Cash Flow -$211,000 -$39,350 $440,180 $217,520 -$2,000
-
Discuss how economic, global, and ethical environments interact with respect to an organization like Mercy Corps?
-
Marathon Manufacturing, which produces running shoes, has enough idle capacity available to accept a special order of 1,000 pairs of shoes at \(\$ 24\) per pair. The following data has been obtained...
-
Falcon Crest Aces (FCA), Inc., is considering the purchase of a small plane to use in its wing-walking demonstrations and aerial tour business. Various information about the proposed investment...
-
sin(xy+x) (a) Let f(x, y) = x+y2 if x + y 0, 0 if x + y = 0. (i) Determine whether or not f(x, y) is continuous at (0,0). a (ii) Find the partial derivatives of (0,0) and of (0,0), and determine...
-
A charge q is surrounded by a closed surface consisting of an inverted cone of height hand base radius R, and a hemisphere of radius R as shown in the figure. The electric flux through the conical...
-
Prescott Inc. sells coffee mugs and water bottles. Sales of coffee mugs traditionally run around 2 7 5 , 0 0 0 per year and sales of water bottles are 5 0 0 , 0 0 0 sharply increasing over the past 3...
-
You are defining how the brand will evolve in the next 5-10 years as the marketplace makes radical changes. For starters, you will want to have ownership of several key terms: (a) Information...
-
On November 1 , the company agreed to do a special six - month course for a client. The contract calls for a monthly fee of $ 9 0 0 , and the client paid the first five months' revenue in advance....
-
Microchip began the year with $2,600 in its asset account, supplies. During the year, $7,100 in supplies were purchased and debited to supplies. At year-end, supplies costing $3,550 remain on hand....
-
According to the Portland Business Journal, Jim Houser, a Portland auto specialist, landed a key Small Business Administration appointment. Help Jim reconcile Remington s Auto Clinic s checkbook and...
-
Two alternatives to investing in an e-commerce business with a five-year horizon are being considered. The first alternative (A) has an initial investment cost of 21,000 Euros and it is estimated...
-
Modify the CYK algorithm so that it applies to any CFG, not just those in CNF.
Study smarter with the SolutionInn App