Correct my formulas and find missing yellow rows. Also, show the Excel Formulas that you use to find the answer, please. 1516Annual Interest Payment:35,000.00=C3/(1/C14/C6)^(C4*1)=pv(C14/1,C4*1,C16)397,263.46$417PV of Face Value:+PV of Interest Payments:Bond Selling Price:1819%D2021 b)Market Interest Rate:5.5%2223Annual Interest Payment:$35,000.0024PV of Face Value:+PV of Interest Payments:=Bond Selling Price:=C325262$609,003.092728 2. Use the Excel IF function to answer either "Premium" or "Discount" to the following items.2930The bond in (a) sold at a:Discount3132The bond in (b) sold at a:=IF(C3 FILEHOIMEIINSERTPAGE LAY OUTFORIMULASDATAREVIEWVIEVVSign imCalibri11A A%PasteВ I UAlignment NumberConditional Format asCellCellsEditingFormatting - Table - Styles -ClipboardFontStylesA1feOn January 1, Ruiz Company issued bonds as follows:AВCDEFFace Value:Number of Years:Stated Interest Rate:Interest payments per year3$500,00043057%6.7(Note: the bonds pay interest annually.)89 Required:10 1) Calculate the bond selling price given the two market interest rates below.11 Use formulas that reference data from this worksheet and from the appropriate future or12 present value tables (found by clicking the tabs at the bottom of this worksheet).13 Note: Rounding is not required.14 а)Market Interest Rate:9%1516Annual Interest Payment:$35,000.00>

The bond is said to be issued at discount if the selling price if less than face value and at…

Annual Interest Payment: PV of Face Value: +PV of Interest Payments: =Bond Selling Price: $ 35,000.00 =C3/(1/C14/C6)^(C4*1) =pv(C14/1,C4*1,C16) 397,263.46 $ Market Interest Rate: 5.5% Annual Interest Payment: PV of Face Value: +PV of Interest Payments: $ 35,000.00 =C3 =Bond Selling Price: $ 609,003.09 . Use the Excel IF function to answer either "Premium" or "Discount" to the following items. The bond in (a) sold at a: Discount The bond in (b) sold at a: =IF(C3

Annual Interest Payment: PV of Face Value: +PV of Interest Payments: =Bond Selling Price: $ 35,000.00 =C3/(1/C14/C6)^(C41) =pv(C14/1,C41,C16) 397,263.46 $ Market Interest Rate: 5.5% Annual Interest Payment: PV of Face Value: +PV of Interest Payments: $ 35,000.00 =C3 =Bond Selling Price: $ 609,003.09 . Use the Excel IF function to answer either "Premium" or "Discount" to the following items. The bond in (a) sold at a: Discount The bond in (b) sold at a: =IF(C3

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter9: Long-term Liabilities

Section: Chapter Questions

Problem 96PSA

See similar textbooks

Similar questions

2.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…
HİLİ Corporation had the following bond issue: Date of issue/sale: May 1, 20-A Principal: $500,000 Sale price of bonds: 100 Life of bonds: 10 years Stated rate: 6% a year payable semiannually on October 31 and April 30 Required: Prepare the following general journal entries. a. The issuance of the bonds on May 1, 20-A. b. The first interest payment for 20-A. C. The adjusting entry for December 31, 20-A. d. The reversing entry for January 1, 20-B.-
Enviro Company issues 8%, 10-year bonds with a par value of $250,000 and semiannual interest payments. On the issue date, the annual market rate for these bonds is 10%, which implies a selling price of 87 2. Prepare the journal entry for the issuance of the bonds for cash on January 1. View transaction list Journal entry worksheet Record the issue of bonds with a par value of $250,000. Note: Enter debits before credits. Date General Journal Debit Credit Jan 01 ...
eBook Show Me How eck My Work conLocator=&lhprogress=false 000 000 0 Issuing Bonds at a Premium $1,454,364. On the first day of the fiscal year, a company issues a $1,200,000, 6%, 8-year bond that pays semiannual interest of $36,000 ($1,200,000 x 6% x 12), receiving cash of Journalize the bond issuance. If an amount box does not require an entry, leave it blank. Upda < Previous Next
owv21 Online teachin X signment/takeAssignmentMain.do?invoker &takeAssignmentSessionLocator-assignment-take&inprogress-false еBook Calculator Print Item Present Value of Bonds Payable; Premium Moss Co. issued $105,000 of five-year, 12 % bonds, with interest payable semiannually, at a market (effective) interest rate of 11%. Determine the present value of the bonds payable, using the present value tables in Exhibit 5 and Exhibit 7. Note: Round final answer to the nearest dollar. 6,300 oeqpaay Remember, the selling price of a bond is the sum of the present values of: the face amount of the bonds due at the maturity date interest to be paid on the bonds. The market rate of interest is used to compute the present value of both the face amount and the periodic interest. Pre Check imWork de Up
4. MC.11.162 A company issued $1,000,000 of 30-year, 8% callable bonds on April 1, with interest payable on April 1 and October 1. The fiscal year of the company is the calendar year. What is the journal entry needed when the bonds are issued at face value? O a. debit Cash and Discount on Bonds Payable, credit Bonds Payable O b. debit Cash, credit Bonds Payable O c. debit Bonds Payable, credit Cash O d. debit Cash, credit Premium on Bonds Payable and Bonds Payable 5. MC.11.163 A company issued $1,000,000 of 30-year, 8% callable bonds on April 1, with interest payable on April 1 and October 1. The fiscal year of the company is the calendar year. The bonds are called at the end of year 3 for 104. What is the entry to record the redemption? (Assume the interest payment has been recorded separately.) O a. Bonds Payable 1,000,000 Gain on Redemption of Bonds 40,000 Cash 1,040,000 O b. Bonds Payable 1,000,000 Loss on Redemption of Bonds 40,000 Cash 1,040,000 O c. Bonds Payable 1,040,000 Cash…
BONDS ISSUED AT FACE VALUE Ramona Arroyo Co. issued the following bonds: REQUIRED Prepare journal entries for: (a) Issuance of the bonds. (b) Interest payment on the bonds on September 30, 20-1. (c) Year-end adjustment on the bonds for 20-1. (d) Reversing entry for the beginning of 20-2. (e) Interest payments on the bonds for 20-2 (March 31 and September 30). (f) Redemption at maturity.
Wilbury Corporation issued 1 million of 13.5% bonds for 985,071.68. The bonds are dated and issued October 1, 2019, are due September 30, 2020, and pay interest semiannually on March 31 and September 30. Assume an effective yield rate of 14%. Required: 1. Prepare a bond interest expense and discount amortization schedule using the straight-line method. 2. Prepare a bond interest expense and discount amortization schedule using the effective interest method. 3. Prepare adjusting entries for the end of the fiscal year December 31, 2019, using the: a. straight-line method of amortization b. effective interest method of amortization 4. If income before interest and income taxes of 30% in 2020 is 500,000, compute net income under each alternative. 5. Assume the company retired the bonds on June 30, 2020, at 98 plus accrued interest. Prepare the journal entries to record the bond retirement using the: a. straight line method of amortization b. effective interest method of amortization 6. Compute the companys times interest earned (pretax operating income divided by interest expense) for 2020 under each alternative.
Dixon Inc. issued bonds with a $500,000 face value, 10% interest rate, and a 4-year term on July 1, 2018 and received $480,000. Interest is payable annually. The discount is amortized using the straight-line method. Prepare journal entries for the following transactions. A. July 1, 2018: entry to record issuing the bonds B. June 30, 2019: entry to record payment of interest to bondholders C. June 30, 2019: entry to record amortization of discount D. June 30, 2020: entry to record payment of interest to bondholders E. June 30, 2020: entry to record amortization of discount
Volunteer Inc. issued bonds with a $500,000 face value, 10% interest rate, and a 4-year term on July 1, 2018 and received $540,000. Interest is payable annually. The premium is amortized using the straightline method. Prepare journal entries for the following transactions. A. July 1, 2018: entry to record issuing the bonds B. June 30, 2019: entry to record payment of interest to bondholders C. June 30, 2019: entry to record amortization of premium D. June 30, 2020: entry to record payment of interest to bondholders E. June 30, 2020: entry to record amortization of premium
Bats Corporation issued 800,000 of 12% face value bonds for 851,705.70. The bonds were dated and issued on April 1, 2019, are due March 31, 2023, and pay interest semiannually on September 30 and March 31. Bats sold the bonds to yield 10%. Required: 1. Prepare a bond interest expense and premium amortization schedule using the straight-line method. 2. Prepare a bond interest expense and premium amortization schedule using the effective interest method. 3. Prepare any adjusting entries for the end of the fiscal year, December 31, 2019, using the: a. straight-line method of amortization b. effective interest method of amortization 4. Assume the company retires the bonds on June 30, 2020, at 103 plus accrued interest. Prepare the journal entries to record the bond retirement using the: a. straight-line method of amortization b. effective interest method of amortization