On January 1. Ruiz Company issued bonds as follows: Face Value: Number of Years: Stated Interest...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
On January 1. Ruiz Company issued bonds as follows: Face Value: Number of Years: Stated Interest Rate: Interest payments per year 500,000 15 7% Required: 1) Calculate the bond selling price given the two market interest rates below. Use formulas that reference data from this worksheet and from the appropriate future or present value tables (found by clicking the tabs at the bottom of this worksheet). Note: Rounding is not required. a) Annual Market Rate 9% Semiannual Interest Payment: PV of Face Value: +PV of Interest Payments: =Bond Selling Price: b) Annual Market Rate 6.0% Semiannual Interest Payment: IDV of Eaca Value A1 On January 1, Ruiz Company issued bonds as follows: B D E Bond Selling Price: 19 20 21 b) Annual Market Rate 6.0% 22 Semiannual Interest Payment: PV of Face Value: +PV of Interest Payments: Bond Selling Price: 23 24 25 26 27 28 2. Use the Excel IF function to answer either "Premium" or "Discount" to the following items. 29 30 The bond in (a) sold at a: 31 32 The bond in (b) sold at a: 33 34 3. Use the Excel PV FUNCTION (fx) to verify the selling prices of the bonds. 35 a) Annual Market Rate 9% 36 Bond Selling Price 37 38 b) Annual Market Rate 6% 39 Bond Selling Price 40 41 42 ... ty of $1 Present Value of Annuity of $1 Sheet1 +) READY 100% Attemntis Llint On January 1. Ruiz Company issued bonds as follows: Face Value: Number of Years: Stated Interest Rate: Interest payments per year 500,000 15 7% Required: 1) Calculate the bond selling price given the two market interest rates below. Use formulas that reference data from this worksheet and from the appropriate future or present value tables (found by clicking the tabs at the bottom of this worksheet). Note: Rounding is not required. a) Annual Market Rate 9% Semiannual Interest Payment: PV of Face Value: +PV of Interest Payments: =Bond Selling Price: b) Annual Market Rate 6.0% Semiannual Interest Payment: IDV of Eaca Value A1 On January 1, Ruiz Company issued bonds as follows: B D E Bond Selling Price: 19 20 21 b) Annual Market Rate 6.0% 22 Semiannual Interest Payment: PV of Face Value: +PV of Interest Payments: Bond Selling Price: 23 24 25 26 27 28 2. Use the Excel IF function to answer either "Premium" or "Discount" to the following items. 29 30 The bond in (a) sold at a: 31 32 The bond in (b) sold at a: 33 34 3. Use the Excel PV FUNCTION (fx) to verify the selling prices of the bonds. 35 a) Annual Market Rate 9% 36 Bond Selling Price 37 38 b) Annual Market Rate 6% 39 Bond Selling Price 40 41 42 ... ty of $1 Present Value of Annuity of $1 Sheet1 +) READY 100% Attemntis Llint
Expert Answer:
Answer rating: 100% (QA)
Face value 500000 Number of years 15 Stated Interest Rate 7 Interest payment per year 2 1 a Annual m... View the full answer
Related Book For
Intermediate Accounting
ISBN: 978-0324312140
16th Edition
Authors: James D. Stice, Earl K. Stice, Fred Skousen
Posted Date:
Students also viewed these accounting questions
-
The following data represents the prices (in R) of 50 items purchased by a shopper. Price R Frequency 0.00 > 20.00 6 20.00 < 40.00 9 40.00 < 60.00 18 60.00 < 80.00 13 80.00 < 100.00 4...
-
You and a business partner opened a fitness gym three years ago. Your partner oversees managing the operations of the gym, ensuring the right equipment is on hand, maintenance is conducted, and the...
-
A pair of points is given. (0, 8), (3, 0) (b) Find the distance between them. (c) Find the midpoint of the segment that joins them. (x, y) = ------- Find an equation of the circle that satisfies the...
-
The registers values in AX and BX can be exchanged using stack operations that are: Select one: a. PUSH bx PUSH ax POP bx POP AX b. none C. PUSH ax PUSH bx POP ax POP bx d. PUSH ax POP ax PUSH bx POP...
-
A 25.0-mL sample of sodium sulfate solution was analyzed by adding an excess of barium chloride solution to produce barium sulfate crystals, which were filtered from the solution. Na2SO4(aq) +...
-
One challenge that businesses confront is cutting costs in ways that do not erode their competitiveness. Many cost-cutting techniques, such as scaling back on hiring, lowering marketing expenses, or...
-
What is the most important aspect of using Automatic Lubers for grease application to a bearing?
-
Of the 217 airports available for public use in Belgium, 132 are paved. For a simple random sample of n = 50, what is the probability that at least 22 of the airports in the sample will be paved?
-
The preceding section reveals that management accounting has evolved parallel with the development of technology and business environment. It is apparent that management accounting information has...
-
A researcher is interested in how episodes which prime mortality salience (events that trigger thoughts about death) may trigger physical symptoms and anxiety, and may be related to the tendency to...
-
A study of about 1,800 U.S. colleges and universities resulted in the demand equation q = 9,900 2.2p, where q is the enrollment at a college or university, and p is the average annual tuition (plus...
-
Explain two methods that a central bank might employ to devalue its currency.
-
Explain crowding out.
-
Explain how economic growth may bring about an increase in potential output. the world, especially China. China's foreign direct investment in new projects such as renewable energy, textile factories...
-
Explain how investment may result in economic growth.
-
Explain two policies that might be used to reduce the natural rate of unemployment.
-
The current price of stock A (B) is $87.20 ($62.50). Analysts expect that in one year a dividend of $3.64 ($3.12) will be paid on stock A (B). In addition, analysts expect the price of stock A (B) in...
-
Describe a job you have had in the past or a job you are very familiar with. Indicate the negative aspects of the job and how it could be improved with current human resource management techniques.
-
Astle Manufacturing Company manufactures and leases a variety of items. On January 2, 2008, Astle leased a piece of equipment to Haws Industries Co. The lease is for six years for an annual amount of...
-
The following is an excerpt from an article dealing with accounting and banks in The Wall Street Journal, GAO Says Accountants Auditing Thrifts Are Hiding Behind Outdated Standards (February 6, 1989)...
-
Foley Industries purchases new specialized manufacturing equipment on July 1, 2008.The equipment cash price is $79,000. Foley signs a deferred payment contract that provides for a down payment of...
-
The procedure in Exercise 10.46 also calculates the chi square test for independence. Do Exercise 10.40 using the computer. Data From Exercise 10.46 Data From Exercise 10.40 10.46 A chi square test...
-
A chi square test is easily implemented on a computer. With the counts from Example 8 in columns 1-4, the MINITAB commands produce the output Expected counts are printed below observed counts Repeat...
-
With reference to Exercise 10.48, test the null hypothesis \(p=0.20\) versus the alternative hypothesis \(p Data From Exercise 10.48 10.48 In a sample of 100 ceramic pistons made for an ex-...
Study smarter with the SolutionInn App