A 1 2 On January 1, Ruiz Company issued bonds as follows: 3 4 Face Amount: 5 6 16 a) Market Interest Rate: 17 B Semiannual Interest Payment: Bond Selling Price: Number of Years: Stated Interest Rate: 7 Interest payments per year 8 Note: The bonds pay interest semiannually. 9 10 Required: 11 1) Given the different market interest rates below, calculate the following items. 12 Calculate the bond selling price using the Excel PV function. Enter all function arguments as cell references. 13 $500,000 30 7% 2 14 (Use cells A4 to B7 from the given information to complete this question.) 15 Semiannual Interest Payment: Bond Selling Price: 26 The bond in (a) sold at a: 27 The bond in (b) sold at a: 28 C 9% 18 19 20 b) Market Interest Rate: 21 22 23 24 2. Use the answer either "Premium" or "Discount" to the following items. 25 D 5.50% F G H
Q: The following static budget is provided: Per Unit Total Sales $ 70 $ 1,050,000 Less variable costs:…
A: Volume variance :— It is the difference between flexible budget and static budget. Flexible…
Q: Taylor Swift Corporation purchases a patent from Salmon Company on January 1, 2025, for $54,000. The…
A: Intangible assets are those that cannot be touched or seen and have no inherent worth. They are…
Q: Bisbee Health Products invests heavily in research and development (R&D), although it must currently…
A: The economic value added is computed by the business organizations so as to determine a company's…
Q: July 1 beginning merchandise inventory 18 units @ $53 each. July 8 purchase 13 units @ $56 each.…
A: Inventory means the detailed list or stock of items, goods, or materials held by a business or…
Q: The master budget at Monroe Manufacturing last period called for sales of 43,700 units at $59 each.…
A: Flexible budget :— It is calculated by multiplying standard amount per unit with actual units.…
Q: As a result of a slowdown in operations, Mercantile Stores is offering to employees who have been…
A: Present value (PV) is defined as the current or present value of all future sums of cash flow or…
Q: Prepare the journal entries to record the restricted stock on January 1, 2025 (the date of grant),…
A: Employee stock options are a type of employee benefit plan provided by the company for its employees…
Q: A business operated at 100% of capacity during its first month, with the following results: Sales…
A: Absorption costing is one of the techniques used to calculate the amount of profit generated by the…
Q: Before purchasing a used car, Cody Lind checked www.kbb.com to learn what he should offer for the…
A: Introduction:- This question involves a scenario where a person named Cody Lind purchases a used car…
Q: Prepare a complete statement of cash flows using the indirect method for the current year. Note:…
A: The cash flow statement is prepared to record the cash flow from various activities during the…
Q: Tharaldson Corporation makes a product with the following standard costs: Standard Quantity or Hours…
A: Variance can be defined as the difference between the actual cost and standard cost. it is used to…
Q: Tupper Inc. and Victory Inc. are two small clothing companies that are considering leasing a dyeing…
A: Standalone Method :— In this method, Common cost is allocated between the performance obligations on…
Q: On May 15, Baxtor, Inc. sold $26,000 of merchandise to James, on account. Baxtor could not collect…
A: Accounts receivable means those customer accounts to whom credit sales has been made and amount has…
Q: 5. Prepare journal entries for all the preceding transactions and events. Note: Do not round your…
A: The journal entry is used to record the day-to-day business transactions in the books. The journal…
Q: March, April, and May have been in partnership for a number of years. The partners allocate all…
A: Liquidation of partnership refers to the process of closing a partnership firm. It is critical to…
Q: Sell or Process Further Manufacturing Company makes a partially completed assembly unit that it…
A: Introduction:- The given problem is about Turner Manufacturing Company which produces partially…
Q: IMC Pty Ltd produces plastic ice cube trays in two processes: heating and stamping. All materials…
A: Process costing either makes use of weighted average method or FIFO method for preparing the…
Q: Current Attempt in Progress The South Division of Concord Company reported the following data for…
A: Variable costs are costs that varies with the change in the level of output whereas fixed costs are…
Q: The comparative temporary investments and inventory balances of a company follow: Current Year…
A: The horizontal analysis is performed to compare the data of two different years. The previous year…
Q: Identify the event as an accrual, deferral, neither, or both. 2. Create the journal entry that…
A: In accrual basis company record revenue before receiving payment from debtors for sale of goods or…
Q: A company reports net accounts receivable of $251,000 on its December 31, 2019 balance sheet. The…
A: Net accounts receivables = $251,000 Allowances for doubtful accounts = $22,000 (credit) Balance in…
Q: At the end of the first year of operations, Mayberry Advertising had accounts receivable of $20,500.…
A: Journal entry is the first stage of accounting process. Journal entry used to record business…
Q: Last month when Holiday Creations, Inc., sold 35,000 units, total sales were $309,000, total…
A: Contribution margin is the amount of earnings made by an entity after deducting the variable costs…
Q: The master budget at Monroe Manufacturing last period called for sales of 43,500 units at $57 each.…
A: Flexible budgets are prepared at standard cost for the actual production or sales level . sales…
Q: Comparing Three Depreciation Methods Dexter Industries purchased packaging equipment on January 8…
A: Business organizations are required to charge the depreciation expense in the books of accounts so…
Q: Ivanhoelnc. leased a new crane to Bridgeport Construction under a 5-year, non-cancelable contract…
A: To keep track of a business transaction, the business organizations record the entries in the…
Q: Sanchez & Vukmin, LLP, is a full-service accounting firm located near Chicago, Illinois. Last year,…
A: Variable costs are the costs that vary with the change in the level of production. On the other…
Q: At the beginning of the year, Young Company bought machinery, shelving, and a forklift. The…
A: Depreciation is recorded as reduction in value of fixed asset over its useful life. By units of…
Q: a) Prepare an "installment payments schedule" for the first four payments of the mortgage payable…
A: Particulars Values Mortgage note $ 8,00,000 Interest rate 8% Number of years 10 Annual…
Q: On January 1, 2020, Lovely Company paid P1,200,000 for 40,000 ordinary shares of Lonely Corporation…
A: Investments is one of the important assets of the business. This can be investment in shares or…
Q: Predetermined Factory Overhead Rate Exotic Engine Shop uses a job order cost system to determine the…
A: Total budgeted Overhead cost = Shop and repair equipment Depreciation + Shop supervisor salaries +…
Q: Exercise 10-15 (Algo) Effect of Convertible Bonds on Earnings per Share LO 10-4 Poppy Corporation…
A: Earnings per share are the net income after the preferred dividend attributable to one common share…
Q:
A: JOURNAL ENTRIES Journal Entry is the First stage of Accounting Process. Journal Entry is the Process…
Q: On November 30, Petrov Company has $127,000 of accounts receivable and uses the perpetual inventory…
A: Journal entry is an art of recording, classifying and summarising the business transaction into…
Q: Grass Cutters Manufacturing produces lawn mowers. The company has a policy that the ending inventory…
A: The production budget is prepared to estimate the number of units to be produced during the period.…
Q: Required Information [The following information applies to the questions displayed below.] On…
A: The allowance for doubtful accounts is created to record estimated bad debt expense for the period.…
Q: The stockholders' equity section of Blossom Inc. at the beginning of the current year appears below.…
A: Balance sheet refers to the statement which shows the financial position of the company during the…
Q: Compute the additional Medicare tax for the following taxpayers. If required, round your answers to…
A: Medicare tax : It is a federal employment tax which provides funds to the portion of the Medicare…
Q: Aday Hotels operates a hotel in San Francisco with two departments. Below is the sales and gross…
A: COST OF GOODS MANUFACTURED Cost Of Goods Manufactured are those Cost Which is Directly or Indirectly…
Q: Distinguish among the three methods of allocating the costs of support departments to operating…
A: The three methods of allocating the costs of support departments to operating departments are the…
Q: Kahn Inc. has a target capital structure of 60 percent common equity and 40 percent debt to fund its…
A: WACC means weighted average cost of capital of funds being used in business. It includes cost of…
Q: Down Under Products, Limited of Australia has budgeted sales of its popular boomerang for the next…
A: Production budget is usually based on the sales budget and the desired ending inventory levels. It…
Q: Corporation P owns 93 percent of the outstanding stock of Corporation T. This year, the…
A: Taxable income refers to the amount that is charged by the government and corporation on the…
Q: Knowledge Check 01 On January 1, Year 1, McClurg Corporation issues 5%, 11-year bonds with a face…
A: Journal Entry is the primary step to record the transaction in the books of accounts. The increase…
Q: You plan on starting a lawn mowing business by investing $700 of your own money and purchase $500 of…
A: An income statement is a financial report that indicates the revenue and expenses of a business. It…
Q: Required information A potential investment has a cost of $395,000 and a useful life of 7 years.…
A: Capital budgeting is a process used by the companies to determine profitability from investment to…
Q: Lopez Company is considering replacing one of its old manufacturing machines. The old machine has a…
A: Whenever organization to choose between whether to continue operation or close the operation of any…
Q: Millard Corporation is a wholesale distributor of office products. It purchases office In the West,…
A: The contribution segment income statement is a statement that is helpful in finding our contribution…
Q: Doer Company reports year-end credit sales in the amount of $390,000 and accounts receivable of…
A: Sales are made on cash basis and credit basis. the amount to be collected from Sales made on credit…
Q: [The following information applies to the questions displayed below.] A company reports the…
A: First In, First Out, generally known as FIFO, is a valuation technique in which assets created or…
Please answer all yellow boxes, and show the formulas (work).
Thank you!
Trending now
This is a popular solution!
Step by step
Solved in 3 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, 2021BlueLtd. 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…
- 2. On 1/1/08, Discount Firm issues: $10,000, 8% bonds Due December 31, 2011 Interest payable annually Market rate of interest = 12% Determine the issue price of bonds: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…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…The notes to the Thorson Ltd.financial statements reported the following data on December 31, Year 1 (end of the fiscal year): Thorson amortizes bond discounts using the effective-interest method and pays all interestamounts at December 31. Requirements1. Assume the market interest rate is 6% on January 1 of year 1, the date the bonds are issued.a. Using the PV function in Excel, what is the issue price of the bonds?b. What is the maturity value of the bonds?c. What is Thorson’s annual cash interest payment on the bonds?d. What is the carrying amount of the bonds at December 31, year 1?2. Prepare an amortization table through the maturity date for the bonds using Excel. (Roundall amounts to the nearest dollar.) How much is Thorson’s interest expense on the bonds forthe year ended December 31, Year 4?3. Show how Thorson would report these bonds and notes at December 31, Year 4.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.…