Ware Co. produces and sells motorcycle parts. On the first day of its fiscal year, Ware issued $42,000,000 of four-year, 12% bonds at a market (effective) interest rate of 11%, with interest payable semiannually. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Compute the following: The amount of cash proceeds from the sale of the bonds. Round your answer to the nearest dollar. $ fill in the blank 2 The amount of premium to be amortized for the first semiannual interest payment period, using the interest method. Round your answer to the nearest dollar. $ fill in the blank 3 The amount of premium to be amortized for the second semiannual interest payment period, using the interest method. Round your answer to the nearest dollar. $ fill in the blank 4 The amount of the bond interest expense for the first year. Round your answer to the nearest dollar. $ fill in the blank 5

Ware Co. produces and sells motorcycle parts. On the first day of its fiscal year, Ware issued $42,000,000 of four-year, 12% bonds at a market (effective) interest rate of 11%, with interest payable semiannually. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Compute the following: The amount of cash proceeds from the sale of the bonds. Round your answer to the nearest dollar. $ fill in the blank 2 The amount of premium to be amortized for the first semiannual interest payment period, using the interest method. Round your answer to the nearest dollar. $ fill in the blank 3 The amount of premium to be amortized for the second semiannual interest payment period, using the interest method. Round your answer to the nearest dollar. $ fill in the blank 4 The amount of the bond interest expense for the first year. Round your answer to the nearest dollar. $ fill in the blank 5

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter11: Bond Pricing And Amortization (bonds)

Section: Chapter Questions

Problem 1R: The University Club recently issued 1,500,000 of 10-year, 9% bonds at an effective interest rate of...

See similar textbooks

Similar questions

Please help me
Please show work. On July 1 of the current year, Rio Bravo factored receivables with a carrying value of $250,000 to a local bank. The transfer was made with a recourse of $3000. The bank assesses a finance charge of 3% of the amount of accounts receivable and retains an amount equal to 5% of the accounts receivable (for probable adjustments). The journal entry for this transaction will include which of the following? A. Debit to Recourse Liability of $3,000 B. Debit to Cash of $233,000. C. Debit to Due from Bank of $15,500. D. Debit to Loss on Sale of Receivables of $10,500. E. Mor than one of these.
For the purpose of borrowing $100,000 (10-year loan with 12% interest annually), Shannon Merchandising Company has submitted the following audited Balance Sheet and Income Statement to Bank. Statement Of Financial Position (Balance Sheet) As of Dec. 31st, 2021 Cash $40,000 Accounts receivable 170,000 Merchandise Inventory 220,000 Land 50000 Building and equipment (net) 470,000 Total assets $950,000 Accounts payable $140,000 Wages payable 100,000 Notes Payable (5-year note) 300,000 Total liabilities 540,000 Common stock, $10 par 310,000 Retained earnings 110,000 Total stockholders' equity 410000 Total liabilities and stockholders' equities $950,000 Income Statement For the Year Ending December 31, 2021 Revenues: Sales $2,880,000 Expenses: Cost of goods sold 1,512,000 Operating expenses 1,128,000 Interest expense 40,000 Income tax expense 80,000 Total Expenses 2,760,000 Net income $120,000 Assume you are the…
Barton Company has a line of credit with Sea View Bank. Barton can borrow up to $200,000 at any time over the course of Year 2. The following table shows the interest rate expressed as an annual percentage along with the amounts borrowed and repaid during the first three months of Year 2. Funds are borrowed or repaid on the first day of each month. Interest is payable in cash on the last day of the month. The interest rate is applied to the outstanding monthly balance. Month January February March Multiple Choice $1,500. Borrowed/ (Repaid) $25,000 (5,000) 20,000 Based on this information, the amount of interest expense Barton would recognize in February is $1,800. $150. Amount $125. Annual Interest Rate 6% 9% 9%
The University Club recently issued 1,500,000 of 10-year, 9% bonds at an effective interest rate of 10%. Bond interest is payable annually. You have been asked to calculate the issuance price of the bonds and prepare amortization schedules for any discount or premium. The worksheet BONDS has been provided to assist you. Note that the worksheet contains a scratch pad at the bottom that has been preprogrammed to automatically compute and display the relevant cash flows needed for bond pricing.
Sylvestor Systems borrows $51,000 cash on May 15 by signing a 120-day, 7%, $51,000 note. 1. On what date does this note mature? 2-a. Prepare the entry to record issuance of the note. 2-b. First, complete the table below to calculate the interest expense at maturity. Use those calculated values to prepare your entry to record payment of the note at maturity. Complete this question by entering your answers in the tabs below. Required 2B Interest at Maturity On what date does this note mature? Required 1 Required 2A On what date does this note mature? Required 2B General Journal
Sylvestor Systems borrows $75,000 cash on May 15 by signing a 60-day, 7%, $75,000 note. 1. On what date does this note mature? 2-a. Prepare the entry to record issuance of the note. 2-b. First, complete the table below to calculate the interest expense at maturity. Use those calculated values to prepare your entry to record payment of the note at maturity. Complete this question by entering your answers in the tabs below. Required 1 Required 2A Required 2B Interest at Maturity Principal Rate (%) Time Total interest First, complete the table below to calculate the interest expense at maturity. (Use 360 days a year. Round final answers to the nearest whole dollar.) Required 2B General Journal Interest at Maturity
Sylvestor Systems borrows $50,000 cash on May 15 by signing a 60-day, 5%, $50,000 note. 1. On what date does this note mature?2-a. Prepare the entry to record issuance of the note.2-b. First, complete the table below to calculate the interest expense at maturity. Use those calculated values to prepare your entry to record payment of the note at maturity. First, complete the table below to calculate the interest expense at maturity. (Use 360 days a year. Round final answers to the nearest whole dollar.) Interest at Maturity Principal Rate (%) Time Total interest
Please show how to do this in Excell. Thank you.
Sylvestor Systems borrows $103,000 cash on May 15 by signing a 150-day, 4%, $103,000 note. 1. On what date does this note mature? 2-8. Prepare the entry to record issuance of the note. 2-b. First, complete the table below to calculate the interest expense at maturity. Use those calculated values to prepare your entry to record payment of the note at maturity. Complete this question by entering your answers in the tabs below. Required 28 Interest at Matunity On what date does this note mature? On what date does this note mature? Required 1 Required 2A Required 281 General Journal
Sylvestor Systems borrows $98,000 cash on May 15 by signing a 30-day, 7%, $98,000 note. 1. On what date does this note mature? 2-a. Prepare the entry to record issuance of the note. 2-b. First, complete the table below to calculate the interest expense at maturity. Use those calculated values to prepare your entry to record payment of the note at maturity. Complete this question by entering your answers in the tabs below. Required 1 Required 2A Required 2B Interest at Maturity Required 2B General Journal On what date does this note mature? On what date does this note mature? 1-Record the issuance of the note. Interest at Maturity Principal Rate (%) Time Total interest
Sylvestor Systems borrows $154,000 cash on May 15 by signing a 150-day, 7%, $154,000 note. 1. On what date does this note mature? 2-a. Prepare the entry to record issuance of the note. 2-b. First, complete the table below to calculate the interest expense at maturity. Use those calculated values to prepare your entry to record payment of the note at maturity. Complete this question by entering your answers in the tabs below. Required 2B Interest at Maturity On what date does this note mature? Required 1 Required 2A On what date does this note mature? Required 2B General Journal