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) Does an employee who is terminated by her employer, allegedly based on violation of the employer's "No Call/No Show" policy, have a valid claim against her employer? (b) How should her employer...
-
Better Fitness, Inc. (BFI) manufactures exercise equipment at its plant in Freeport, Long Island. It recently designed two universal weight machines for the home exercise market. Both machines use...
-
Consider the regression model in Problem 3.43. The value of the adjusted $R^{2}$ is Data From Problem 3.43 You have fit a linear regression model with three predictors to a sample of 50 observations....
-
Suppose you are the victim of an identity thief who continues to use your identity and to ruin your credit rating after you have discovered the problem. What problems do you have in clearing your...
-
Figure 1 of 1 EXECUTE Part E Write the equation for the x-coordinate of the ball as a function of time t. Express your answer in terms of the variables vo, 0, 0, t, and the acceleration due to...
-
After its first month of operations, Paquette Advisors showed the following account balances in its General Ledger accounts as at January 31, 2014. During February, the following transactions...
-
9. The following taxpayers need help in determining their current adjusted basis. Complete the last column.(14 points) er Proerty Stock Cost* Detail Adjusted Basis 100,000 | A purchased 100 shares...
-
When a manager makes a decision about someones annual pay raise only after looking at his or her current salary, the risk is that the decision will be biased because of ____________. (a) a framing...
-
A common method of prioritizing stakeholders is based on the stakeholders: a. legitimacy b. power c. urgency d. all of the above
-
All of these are stages of team development except: a. adjourning b. storming c. learning d. performing
-
The MedCottagesometimes called a granny pod or, more properly, an auxiliary dwelling unit (ADU)is a portable hospital room that can be placed next to a private residence. The units are designed as a...
-
It is December of 2021. The NHL Health System has many decisions to make. Its capital budgeting process requires that the largest capital investments, those more than $5 million, be approved by the...
-
In the medicine market, there is a difference between the demand for medicines produced under a patent, medicines that have a well-established brand (such as Bayer) and generic medicines. Discuss the...
-
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...
-
Journalize the transactions of Luna Technology Solutions. Include an explanation with each journal entry. Use the following accounts: Cash; Accounts Receivable; Supplies; Prepaid Advertising; Land;...
-
As the manager of Yum Yum Thai, you must deal with a variety of business transactions. Provide an explanation for the following transactions: a. Debit Equipment and credit Cash. b. Debit Saelim,...
-
Schuster Services reported assets of $800 and equity of $480. What is Schuster Services debt ratio? a. 60% b. 40% c. 67% d. Not enough information is provided.
Study smarter with the SolutionInn App