On January 1, Ruiz Company issued bonds as follows: Face Amount: $500,000 Number of Years: 15 Stated Interest Rate: 7% Interest payments per year 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 th this worksheet). Note: Rounding is not required. a) Annual Market Rate 9%
Q: How long will $13,000, in an investment account that earns 3.75% comp
A: All sorts of future cash flows in respect of adding interest on present value are known as future…
Q: What are the formulas used to get the answer in dividens, addition to retained earnings, short-term…
A:
Q: not identify which shares she sold. What basis should she use for computing gain or loss?
A: Answer
Q: P Co is a much higher leveraged company providing greater finenciel risk for investors but potential…
A: Debt and equity form the company’s capital structure or how it finances its operations. Debt and…
Q: On May 1, Foress Corporation incorporated and authorized 211,000 preferred shares and an unlimited…
A: The journal entries are prepared to keep the record of day to day transactions of the business.
Q: ne beginning inventory at Dunne Co. and data on purchases and sales for a three-month period are as…
A: The inventory using LIFO method is computed as new inventory is sold first and old units are left in…
Q: Backyard World buys plastic pools from a supplier with an invoice amount of $13,500. The terms of…
A: Introduction:- Backyard World buys plastic pools from a supplier Total Invoice amount of $13,500…
Q: Identify the Given and the Unknown or what is being asked in the problem (b)Provide the formula to…
A: Deposits which are made by the depositor into the bank will earn an income on it which is known as…
Q: Beginning inventory, purchases, and sales for Item Copper are as follows: Mar. 1 Inventory 450 units…
A: FIFO states that the inventory purchased first would be sold first by the company. Whereas, LIFO…
Q: The business paid cash for the goods which was purchased on credit last month. Which of the…
A: Introduction: Journals: Recording of a business transactions in a chronological order. First step in…
Q: On March 18, 2021, Nicanor consulted you on the sale of his principal residence located in Recto,…
A: Capital gain tax is calculated on principal residence @ 6% of the highest value of the propety . It…
Q: TB TF Qu. 09-28 (Static) The amount of Federal Insurance Contributions Act (FICA) tax. The amount of…
A: In this question, we just ask that the statement is True or False.
Q: Required information [The following information applies to the questions displayed below.] The…
A: The bank reconciliation statement is prepared to equate the balances of cash book and pass book with…
Q: The wholesale cost of a desk is $490. The original markup was 67% based on selling price. Find the…
A: The correct answer for the above mentioned question is given in the following steps for your…
Q: Hurtt’s Java Seeds is an independent roaster of specialty coffee beans. The company budgets 2 months…
A: Particular Amount beginning direct material inventory $5,000 (+) Cost of Direct Material…
Q: PROBLEM IV On December 31, 2017, Ann and Win have capital balances of P40,000 and P32,000…
A: Lets understand the basics. Partnership is an agreement between two person who works together for…
Q: The selling price of a particular product is $81.00 per unit, the variable expense is $55.00 per…
A: Cost volume profit analysis is the technique used by the management for decision-making. The methods…
Q: 2021 $ 464,837 225,622 22,638 2020 2915 $ 244,973 120,B87 16, ses 2018 sales cost of goods sold…
A: A trend percentage is a sort of horizontal analysis that depicts the evolution of a financial…
Q: Kumar Transport Limited is running four buses between two towns which are fifty miles apart. Seating…
A: Service costing seems to be a sort of operation costing that is used in businesses that develop and…
Q: Operating profit is affected by changes in production under both the variable costing and absorption…
A: Operating profit is profit earned by the company from its primary or core purpose of the business.…
Q: A certain copier machine cost P150,000 with a trade-in value of P15,000 after making 800,000 copies.…
A: The declining balance method is one of the two accelerated depreciation methods and it uses a…
Q: Royal Gift Shop sells cards, supplies, and various holiday greeting cards. Sales to retail customers…
A: A journal entry is a form of accounting entry that is used to report a business transaction in a…
Q: 3. The inventory at May 1 and the costs charged to Work in Process--Department B Olga Company are as…
A: Input output Direct Material Added Conversion cost Particular Unit Particular Units % Units %…
Q: Absorption costing is more compatible with cost-volume-profit analysis than is variable costing.…
A: Variable costing simply covers the variable costs actually incurred in production, but not any of…
Q: Alpha Company is considering the purchase of Beta Company. Alpha has collected the following data…
A: Solution Goodwill is an intangible assets which is earn by a business for good relations with their…
Q: Gomez and Cruz formed a partnership on January 1, 2020 and contributed the following assets: Gomez…
A: Lets understand the basics. Partnership is an agreement between two or more person who works…
Q: Bettinghaus Corporation began business on January 2, 2019, with five employees. Its sick leave and…
A: The financial statements which covers a period of less than one year is known as interim financial…
Q: Nguyen Company has an opportunity to purchase an asset that will cost company $59,000. The asset is…
A: Unadjusted rate of return = Annual net income / Average investment where, Average investment = (Cost…
Q: 37)At Dec 31, Michael Corp has the following bank information: Cash balance per bank $4,500…
A: Introduction: Bank Reconciliation statement: To reconcile the difference between cash and pass book…
Q: Carol is starting a virtual craft workshop business. Currently she is planning to have 3 different…
A: Notes Party A Party B Party C Totals Sales Mix A:B:C = 7:1:2 70% 10% 20% 100% Selling price…
Q: For a construction job, a contractor can haul rock by means of an ordir yard dump truck, or he can…
A: In the given question we are provided with the data of a construction job. In it, there are details…
Q: Complete this question by entering your answers in the tabs below. Req 1A Req 1B Req 2A Req 2B…
A: Calculation of unit cost under Absorption Costing Particular Amount Direct Material 11 ADD…
Q: What is the general rule for recognizing property taxes as revenues? How would property taxes be…
A: According to the definition of Property Tax Money, it is the amount of revenue earned by the…
Q: Mr. J, Capital Office Equipment Accounts Payable 85 000.00 Notes Receivable 1 200.00 12 000.00 Notes…
A: Formula: Net income = Revenues - Expenses.
Q: llustration 1. Share-for-share exchanges On January 1, 2022, Frank Co. and Richard, Inc. combined.…
A: 1. Goodwill (gain on bargain purchase) on the business combination
Q: Calculate the horizontal (trend) analysis, and horizontal % change for 2020, 2019, 2018 in excel.…
A: An income statement is a financial report that indicates the revenue and expenses of a business. It…
Q: Understand the estimate tax payment obligations of corporations.
A: Tax Obligation refers to a taxpayer's legal obligation under the tax code to compute the tax…
Q: Equity method journal entries (price equals book value) Prepare journal entries for the transactions…
A: Equity stock or share is also written as common stock. Common stock is the shares which represents…
Q: Reyes Corporation apples overhead using an actual costing approach Budgeted factory overhead was…
A: Solution Predetermined overhead rate = Budgeted factory overhead / Budgeted machine hours . =268704…
Q: Case 1: last year, on July 1, 2021, Tatay, Co. acquired 45% ownership interest in Walanay, Inc. for…
A: At the time of obtaining control as a subsidiary in any entity, if there is any previously held…
Q: a. Applying the FICA tax rates and rules for 2022, calculate how much you would pay in FICA taxes if…
A: * As per Bartleby policy, if question are different then answer first question only. For 2022, the…
Q: In the financial year to June 30, 2021, HiFi Ltd issued options for 400,000 shares. During that…
A: Lets understand the basics. For calculating basic EPS, we need to use below formula. Basic EPS =…
Q: Calculate the return on assets and the return on shareholders' equity for both companies. (Round…
A: Financial ratios are calculated to determine the financial position of the company. These ratios…
Q: Clay LLC placed in service machinery and equipment (seven-year property) with a basis of $3,468,000…
A: Answer: Maximum depreciation expense = $466,711
Q: GRADUATED TAX TABLE UNDER TRAIN LAW (January 1, 2018 to December 31, 2022)
A: Solution: Taxable Income for the Year 2021 a) Gross income from commercial spaces = $60,000 Add :…
Q: How are duplicate checks useful in determining expected food revenue in nonautomated food…
A: A duplicate guest check technique provides a control system wherein the server gives the kitchen an…
Q: In the financial year to June 30, 2021, HIFI Ltd issued options for 400,000 shares. During that…
A: Earnings per share are the amount of net income that is held in hands of each shareholder of the…
Q: The Vermillion Corporation has 116,60O $2.0 noncumulative preferred shares that have been issued. It…
A: Annual preferred dividend = Number of preferred shares x Preferred dividend per share Quarterly…
Q: GG Merchandising has two producing and two service departments labeled P1, P2, S1 and S2,…
A: The distribution of a single cost over various departments, functional areas, or cost centres is…
Q: erials cost per unit of $140. The budgeted conversion cost for the year is $180,600 for 2,150…
A: These are the accounting transactions that are having a monetary impact on the financial statement…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
- 5 On January 1, Ruiz Company issued bonds as follows: Face Value: Number of Years: Stated Interest Rate: Interest payments per year 7 B 9 0 1 2 AWN IC $500,000 a) 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 botto this worksheet). Note: Rounding is not required. 15 7% 2 Annual Market Rate Semiannual Interest Payment: PV of Face Value: +PV of Interest Payments: Bond Selling Price: Annual Market Rate Semiannual Interest Payment: PV of Face Value: +PV of Interest Payments: = Bond Selling Price: 9% $17,500 133,500.01 285,055.55 418,555.56 6.00% $17,500 205,993.38 5343,007.72 $549,001.10 +On January 1, Ruiz Company issued bonds as follows: Face Value: $500,000 Number of Years: 15 Stated Interest Rate: 7% Interest payments per year 2 Question: 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. Use (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1.)1. Calculate the price of a bond using the Excel PV function. Bond Pricing - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In fx Calculate Now Calculation a Calculate Sheet Function Defined Formula Library Names Auditing Options Calculation B14 fe A B D E F G 1 On January 1, Ruiz Company issued bonds as follows: 2 Face Value: 3 Number of Years: 4 Stated Interest Rate: 5 Interest payments per year 6 (Note: the bonds pay interest annually.) $ 500,000 30 7% 7 8 Required: 9 1) Given the different market interest rates below, calculate the following items. 10 Calculate the bond selling price USING THE EXCEL PV FUNCTION (fx). Note: Enter all 11 function arguments as cell references. 12 13 a) Market Interest Rate: 9% 14 Annual Interest Payment: 15 Bond Selling Price: 16 17 b) Market Interest Rate: 5.5% 18 Annual Interest Payment: 19 Bond Selling Price: 20 21 2. Use the Excel IF function to answer either "Premium" or "Discount" to the following items. 22 23 The bond in (a)…
- tELLiy, you must enter your ID number on the first sheet! On January 1, 2020 Omsk Corporation issued Bonds pay interest each July 1 and January 1. 150,000 of 5 % bonds, due in 17 years 12 % market rate of interest. Assume Requirements (Round to 0 decimals, Rounding errors do not matter): 1. Compute market price of bonds. Provide detailed computation. Use functions in Excel 2. What is an amount of discount /premium? Indicate, what it is (discount or premium). Computation. 3. Prepare amortization schedule for first 5 years. Use formulas in Excel. 4. Prepare journal entry to record bond issue. 5. Prepare journal entry on July 1, 2020. 6. Prepare journal entry on December 31, 2020. 7. Prepare journal entry on January 1, 20212.cengagenow.com/ilm/takeAssignment/takeAssignmentMain.do?invoker3D&takeAssignmentSessionLocator=&inprogress3false eBook Show Me How Calculator Print Item Entries for Issuing Bonds and Amortizing Discount by Straight-Line Method On the first day of its fiscal year, Chin Company issued $18,200,000 of five-year, 9% bonds to finance its operations of producing and selling home improvement products. Interest is payable semiannually. The bonds were issued at a market (effective) interest rate of 11%, resulting in Chin receiving cash of $16,828,145. a. Journalize the entries to record the following: 1. Issuance of the bonds. 2. First semiannual interest payment. The bond discount is combined with the semiannual interest payment. (Round your answer to the nearest dollar.) 3. Second semiannual interest payment. The bond discount is combined with the semiannual interest payment. (Round your answer to the nearest dollar.) If an amount box does not require an entry, leave it blank. Round your…Analyzing and Reporting Financial Statement Effects of Bond Transactions On January 1 of the current year, Shields Inc. issued $700,000 of 9%, 20-year bonds for $769,275, yielding a market (yield) rate of 8%. Semiannual interest is payable on June 30 and December 31 of each year. a. Show Excel inputs to confirm the bond issue price. Note: Round your answer to two decimal places. rate= nper pmt FV => Answer = $ b. Indicate the financial statement effects using the template for (1) bond issuance, (2) semiannual interest payment and premium amortization on June 30 of the current year, and (3) semiannual interest payment and premium amortization on December 31 of the current year. Note: For each account category, indicate the appropriate account name. Enter "N/A" for any account category that is not used for a given transaction. Note: Indicate a decrease in an account category by including a negative sign with the amount. Note: Round your answers to the nearest whole dollar. Balance Sheet…
- Knowledge Check A bond issue of 6%, 7-year bonds with a face value of $35,500 with interest payable annually on January 1. Market interest rate is 8%. What is the present value of the bonds? (For calculation purposes, use five decimal places as displayed in the factor table provided. Round your answers to O decimal places (e.g., 5,275).) Click here to view the factor table. Present value of interest payments $ Present value of principal $ Present value of the bonds $BlueLtd. Issued a $1,164,000, 10-year bond dated January 1, 2020. The bond was sold to yield 12% effective interest. The bond paid 10% interest on January 1 and July 1 each year. The company's year-end was December 31, and Blue followed IFRS. Using 1 factor Tables 2. a financial calculator, or 3. Excel function PV, calculate the amount received for the bond, and any discount or premium on the bond. Click here to view the tactor table PRESENT VALUE OF 1. Click here to view the factor table PRESENT VALUE OF AN ANNUITYOF 1 (For calculation purposes, use 5 decimal places as displayed in the factor table provided and final answers to 0 decimal places, e.g. 5,275.) Proceeds from sale of bond : on bond Prepare the journal entries for above transactions. (Round answers to 0 decimal places, e.g. 5,275. Credit account titles are automatically indented when the amount is entered. Do not Indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the…Metlock Ltd. issued a $791,000, 10-year bond dated January 1, 2023. The bond was sold to yield 12% effective interest. The bond paid 10% interest on January 1 and July 1 each year. The company's year-end was December 31, and Metlock followed IFRS. Using 1. factor Tables 2. a financial calculator, or 3. Excel function PV, calculate the amount received for the bond, and any discount or premium on the bond. Click here to view the factor table PRESENT VALUE OF 1. Click here to view the factor table PRESENT VALUE OF AN ORDINARY ANNUITY OF 1. (Round present value factor calculations to 5 decimal places, e.g. 1.25124 and final answers to 0 decimal places e.g. 58,971.) Proceeds from sale of bond Discount on bond Prepare the journal entries for above transactions. (Round answers to 0 decimal places, e.g. 5,275. Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the…
- Kingbird Ltd. issued a $778,000, 10-year bond dated January 1, 2023. The bond was sold to yield 12% effective interest. The bond paid 10% interest on January 1 and July 1 each year. The company's year-end was December 31, and Kingbird followed IFRS. Using 1. factor Tables 2. a financial calculator, or 3. Excel function PV, calculate the amount received for the bond, and any discount or premium on the bond. Click here to view the factor table PRESENT VALUE OF 1. Click here to view the factor table PRESENT VALUE OF AN ORDINARY ANNUITY OF 1. (Round present value factor calculations to 5 decimal places, e.g. 1.25124 and final answers to O decimal places e.g. 58,971.) Proceeds from sale of bond on bond Prepare the journal entries for above transactions. (Round answers to O decimal places, e.g. 5,275. Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter O for the…Kingbird Ltd. issued a $778,000, 10-year bond dated January 1, 2023. The bond was sold to yield 12% effective interest. The bond paid 10% interest on January 1 and July 1 each year. The company's year-end was December 31, and Kingbird followed IFRS. Using 1. factor Tables 2. a financial calculator, or 3. Excel function PV, calculate the amount received for the bond, and any discount or premium on the bond. Click here to view the factor table PRESENT VALUE OF 1. Click here to view the factor table PRESENT VALUE OF AN ORDINARY ANNUITY OF 1. (Round present value factor calculations to 5 decimal places, eg. 1.25124 and final answers to O decimal places eg. 58,971.) Proceeds from sale of bond on bond Date $ Prepare the journal entries for above transactions. (Round answers to 0 decimal places, e.g. 5,275. Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter O for the…Waterway Ltd. issued a $1,062,000, 10-year bond dated January 1, 2023. The bond was sold to yield 12% effective interest. The bond paid 10% interest on January 1 and July 1 each year. The company's year-end was December 31, and Waterway followed IFRS. Using 1.factor Tables 2. a financial calculator, or 3. Excel function PV, calculate the amount received for the bond, and any discount or premium on the bond. Click here to view the factor table PRESENT VALUE OF 1. Click here to view the factor table PRESENT VALUE OF AN ANNUITY OF 1 (Round present value factor calculations to 5 decimal places, eg. 1.25124 and final answers to 0 decimal places eg. 58,971.) Proceeds from sale of bond on bond Date $ $ Prepare the journal entries for above transactions. (Round answers to O decimal places, e.g. 5,275. Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter O for the amounts.…