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: 9780324312140
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...

Presented below is the trial balance of John Nalezny Corporation at December 31, 2008. Instructions Prepare a balance sheet at December 31, 2008, for John Nalezny Corporation. Ignore incometaxes. $...

Although they are not defined on all of space R 3 , the fields associated with are conservative. Find a potential function for each field and evaluate the integrals as in Example 6. EXAMPLE 6 Show...

Weekly earnings for workers. The table in the next column lists the median weekly earnings (in dollars) for fulltime wage and salary workers over the years 20102019, categorized by gender. a....

A local TV station claims that 60% of people support Candidate A, 30% support Candidate B, and 10% support Candidate C. A survey of 500 registered voters is taken. The accompanying table indicates...

Required information (The following information applies to the questions displayed below.] Haven received 200 NQOs (each option gives him the right to purchase 20 shares of Barlow Corporation stock...

Section Three Answer the questions below 1.While pulling out of her driveway, Bethany becomes distracted by a bee and strikes Melanie, who is riding past on a bicycle. Bethany suffers serious injury...

help part a b and c thank you 2 Your grandmother would like to share some of her fortune with you. She offers to give you money under one of the following scenarios (you get to choose) 1. $7.250 a...

Some people jump at the chance to be a change agent while others run from the role. Why is this the case? What are some characteristics of successful change agentry? These factors should refer to the...

An S corporation with $50,000 of earnings and profits owns rental real estate and has interest income producing investments. For the last two years, 50% of its gross receipts came from passive...

How has Biden Lowered premiums and out of pocket costs for millions of Americans?

Product costs using activity rates BodySolid Inc. manufactures elliptical exercise machines and treadmills. The products are prouced in its Fabrication and Assembly production departments. In...

How to start an essay on the multigenerational workforce and your experiences working with each of the generations. Begin your essay with an introduction that outlines the current generations in the...

AutoSave CHO Homework (2)  Excel TL Home incert Page Layout Formulas Review Virw Help Pade Calib MAN == 1 Wrap leert BUDA. SEE Merge & Center Tunt Alun X General 5  % Conditional to Forutting...

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...

10.9. Investco, a West Coast research company, must decide on the level of computer technology it will buy for its analysis department. Package A, a midlevel technology, would cost $2.5 million for...

10.6. Consider the cash flows associated with undertaking project X. a. Is this an early or later cash flow stream? b. Based on the term structure of interest rates in exercise 10.5, what is the...

10.8. ABC Metalworks wants to determine which model sheetcutter to purchase. Three choices are available, (1) machine 1 costs the least but must be replaced the most frequently, (2) machine 2 has...
Study smarter with the SolutionInn App