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...
-
Hydrogen peroxide is capable of oxidizing (a) Hydrazine to N2 and H2O (b) SO2 to SO42- (c) NO2- to NO3- (d) H2S(g) to S(s) (e) Fe2+ to Fe3+. Write a balanced net ionic equation for each of these...
-
At June 30, 2020, the end of its most recent fiscal year, Green River Computer Consultants post-closing trial balance was as follows (amounts in thousands): The company underwent a major expansion in...
-
Why is the current best price to charge for the unsold trees the one at which the price elasticity of demand equals 1? (Assume no disposal costs.)
-
From S. K. Grinnell and H. P. Apple (When Two Bosses Are Better Than One, Machine Design, January 1975, pp. 8487): People trained in single-line-of-command organizations find it hard to serve more...
-
Holdier Corp. $1,000 par value zero coupon bonds mature in 12 years. If your required rate of return is 7.9%, how much are you willing to pay for the bond today? Assume annual compounding and round...
-
PART-4 PART-5 PART-6 Jaguar Plastics Company has been operating for three years. At December 31 of last year, the accounting records reflected the following: Cash Investments (short-term) Accounts...
-
What is comparative advantage, and what are some examples of this concept at work in the United States? What are the advantages to a firm of using licensing as a method of entry in global markets?...
-
#11. Exercise 11 of Chapter 5 describes a palindrome. Can you use one of the ADTS described in this chapter instead of a stack to see whether a string is a palindrome? Write a program with an...
-
A human heart weighs about 311 grams. How much does the heart weigh in ounces (oz)? (453.6 g 1 lb, 16 oz 1 lb) = = Have factor (convert to oz) 3. 311 grams 1. 2. 4. Fill in the correct values for 1,...
-
Two important differences between symmetric key encryption and public key encryption are: Select one: O a. (1) Symmetric key encryption is faster to perform the encryption than Public key encryption...
-
I recently had a prospective client ask, "D o yo ur clients with hedge accounts make money trading futures and options most years?" The truth is no, they don't because the purpose of a hedge is to...
-
Identifying and Assessing Risks of Material Misstatement and Cloud9 Case Study documents as a guide to assist in answering the following questions. For each of the responses and topics discussed...
-
List and describe Customer needs in terms of the Women's Clothing industry in Ontario, Canada List references used in the written report
-
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...
-
Let \(\left(B_{t} ight)_{t \geqslant 0}\) be a \(\mathrm{BM}^{1}\) and denote by \(g_{t}\) the last zero before time \(t>0\). a) Use Theorem 11.25 to give a further proof of Lvy's arc-sine law (cf....
-
Let \(\left(B_{t} ight)_{t \geqslant 0}, d_{t}\) and \(g_{t}\) be as in Corollary 11.26. Define \[L_{t}^{-}:=t-g_{t} \quad \text { and } \quad L_{t}:=d_{t}-g_{t}\] Find the laws of \(\left(L_{t}^{-},...
-
Let \(X=\left(X_{t} ight)_{t \geqslant 0}\) be a one-dimensional process satisfying (B0), (B1), (B2). Assume, in addition, that \(X\) is continuous in probability, i.e. \(\lim _{t ightarrow 0}...
Study smarter with the SolutionInn App