Questions
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years...

  1. Horizontal Analysis of the Income Statement

    Income statement data for Winthrop Company for two recent years ended December 31, are as follows:

        Current Year     Previous Year
    Sales $800,000 $640,000
    Cost of goods sold 676,500 550,000
    Gross profit $123,500 $90,000
    Selling expenses $35,650 $31,000
    Administrative expenses 31,980 26,000
    Total operating expenses $67,630 $57,000
    Income before income tax $55,870 $33,000
    Income tax expenses 22,300 13,200
    Net income $33,570 $19,800

    a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place.

    Winthrop Company
    Comparative Income Statement
    For the Years Ended December 31
    Current
    year
    Amount
    Previous
    year
    Amount
    Increase
    (Decrease)
    Amount
    Increase
    (Decrease)
    Percent
    Sales $800,000 $640,000 $ %
    Cost of goods sold 676,500 550,000 %
    Gross profit $123,500 $90,000 $ %
    Selling expenses $35,650 $31,000 $ %
    Administrative expenses 31,980 26,000 %
    Total operating expenses $67,630 $57,000 $ %
    Income before income tax $55,870 $33,000 $ %
    Income tax expense 22,300 13,200 %
    Net income $33,570 $19,800 $ %

    Feedback

    b. The net income for Winthrop Company increased between years. This increase was the combined result of an

    • increase
    • decrease
    in sales and
    • higher
    • lower
    percentage
    • increase
    • decrease
    in cost of goods sold. The cost of goods sold increased at a
    • slower
    • faster
    rate than the increase in sales, thus causing the percentage increase in gross profit to be
    • greater
    • less
    than the percentage increase in sales.

In: Accounting

The adjusted trial balance for Tybalt Construction as of December 31, 2018, follows. TYBALT CONSTRUCTION Adjusted...

The adjusted trial balance for Tybalt Construction as of December 31, 2018, follows.

TYBALT CONSTRUCTION
Adjusted Trial Balance
December 31, 2018
No. Account Title Debit Credit
101 Cash $ 7,500
104 Short-term investments 22,000
126 Supplies 9,200
128 Prepaid insurance 8,600
167 Equipment 55,000
168 Accumulated depreciation—Equipment $ 27,500
173 Building 162,000
174 Accumulated depreciation—Building 54,000
183 Land 64,470
201 Accounts payable 16,000
203 Interest payable 2,000
208 Rent payable 3,200
210 Wages payable 2,700
213 Property taxes payable 900
233 Unearned professional fees 7,100
251 Long-term notes payable 69,500
307 Common stock 7,500
318 Retained earnings, December 31, 2017 123,300
319 Dividends 12,600
401 Professional fees earned 103,000
406 Rent earned 17,500
407 Dividends earned 2,200
409 Interest earned 2,800
606 Depreciation expense—Building 11,880
612 Depreciation expense—Equipment 8,250
623 Wages expense 27,500
633 Interest expense 3,500
637 Insurance expense 9,400
640 Rent expense 12,300
652 Supplies expense 5,700
682 Postage expense 2,200
683 Property taxes expense 3,700
684 Repairs expense 6,900
688 Telephone expense 2,800
690 Utilities expense 3,700
Totals $ 439,200 $ 439,200


The December 31, 2017, credit balance of the Retained Earnings account was $123,300. Tybalt Construction is required to make a $7,000 payment on its long-term notes payable during 2019.

Required:
1a.
Prepare the income statement for the calendar-year 2018.
1b. Prepare the statement of retained earnings for the calendar-year 2018.
1c. Prepare the classified balance sheet at December 31, 2018.
2. Prepare the necessary closing entries at December 31, 2018.
3. Use the information in the financial statements to compute the following ratios:

In: Accounting

The adjusted trial balance for Tybalt Construction as of December 31, 2018, follows. TYBALT CONSTRUCTION Adjusted...

The adjusted trial balance for Tybalt Construction as of December 31, 2018, follows.

TYBALT CONSTRUCTION
Adjusted Trial Balance
December 31, 2018
No. Account Title Debit Credit
101 Cash $ 7,500
104 Short-term investments 22,000
126 Supplies 9,200
128 Prepaid insurance 8,600
167 Equipment 55,000
168 Accumulated depreciation—Equipment $ 27,500
173 Building 162,000
174 Accumulated depreciation—Building 54,000
183 Land 64,470
201 Accounts payable 16,000
203 Interest payable 2,000
208 Rent payable 3,200
210 Wages payable 2,700
213 Property taxes payable 900
233 Unearned professional fees 7,100
251 Long-term notes payable 69,500
307 Common stock 7,500
318 Retained earnings, December 31, 2017 123,300
319 Dividends 12,600
401 Professional fees earned 103,000
406 Rent earned 17,500
407 Dividends earned 2,200
409 Interest earned 2,800
606 Depreciation expense—Building 11,880
612 Depreciation expense—Equipment 8,250
623 Wages expense 27,500
633 Interest expense 3,500
637 Insurance expense 9,400
640 Rent expense 12,300
652 Supplies expense 5,700
682 Postage expense 2,200
683 Property taxes expense 3,700
684 Repairs expense 6,900
688 Telephone expense 2,800
690 Utilities expense 3,700
Totals $ 439,200 $ 439,200


The December 31, 2017, credit balance of the Retained Earnings account was $123,300. Tybalt Construction is required to make a $7,000 payment on its long-term notes payable during 2019.

Required:
1a.
Prepare the income statement for the calendar-year 2018.
1b. Prepare the statement of retained earnings for the calendar-year 2018.
1c. Prepare the classified balance sheet at December 31, 2018.
2. Prepare the necessary closing entries at December 31, 2018.
3. Use the information in the financial statements to compute the following ratios:

Use the information in the financial statements to compute the following ratios:

(a) Return on assets (total assets at December 31, 2017, was $200,000)
Numerator: / Denominator: = Return on total assets
Net income / Total assets = Return on total assets
0
(b) Debt ratio
Numerator: / Denominator: = Debt ratio
/ = Debt ratio
0
(c) Profit margin ratio (use total revenues as the denominator)
Numerator: / Denominator: = Profit margin
/ = Profit margin
0 %
(d) Current ratio
Numerator: / Denominator: = Current ratio
/ = Current ratio
0

Prepare the classified balance sheet at December 31, 2018.

TYBALT CONSTRUCTION
Balance Sheet
December 31, 2018
Assets
Current assets
Cash $7,500
Short-term investments 22,000
Supplies 9,200
Prepaid insurance 8,600
Total current assets $47,300
Equipment 55,000
Accumulated depreciation—Equipment 27,500 27,500
Building 162,000
Accumulated depreciation—Building 54,000 108,000
199,970
$335,470
382,770
Accounts payable 16,000
Interest payable 2,000
Rent payable 3,200
Wages payable 2,700
Property taxes payable 900
Unearned professional fees 7,100
Current portion of long-term notes payable 7,000
Total current liabilities $38,900
Long-term notes payable 62,500
Total liabilities 101,400
Equity
Common stock 7,500
Retained earnings 138,370
Total equity 145,870
Total liabilities and equity $247,270

In: Accounting

The adjusted trial balance for Tybalt Construction as of December 31, 2017, follows. TYBALT CONSTRUCTION Adjusted...

The adjusted trial balance for Tybalt Construction as of December 31, 2017, follows.

TYBALT CONSTRUCTION
Adjusted Trial Balance
December 31, 2017
No. Account Title Debit Credit
101 Cash $ 7,500
104 Short-term investments 23,000
126 Supplies 8,800
128 Prepaid insurance 7,700
167 Equipment 50,000
168 Accumulated depreciation—Equipment $ 25,000
173 Building 168,000
174 Accumulated depreciation—Building 56,000
183 Land 62,280
201 Accounts payable 16,500
203 Interest payable 2,000
208 Rent payable 3,200
210 Wages payable 2,000
213 Property taxes payable 1,000
233 Unearned professional fees 7,900
251 Long-term notes payable 67,500
301 O. Tybalt, Capital 131,300
302 O. Tybalt, Withdrawals 11,300
401 Professional fees earned 99,000
406 Rent earned 17,500
407 Dividends earned 2,300
409 Interest earned 2,700
606 Depreciation expense—Building 12,320
612 Depreciation expense—Equipment 7,500
623 Wages expense 28,500
633 Interest expense 3,000
637 Insurance expense 7,100
640 Rent expense 10,300
652 Supplies expense 5,200
682 Postage expense 2,100
683 Property taxes expense 4,900
684 Repairs expense 8,500
688 Telephone expense 2,600
690 Utilities expense 3,300
Totals $ 433,900 $ 433,900

O. Tybalt invested $7,500 cash in the business during year 2017 (the December 31, 2016, credit balance of the O. Tybalt, Capital account was $123,800). Tybalt Construction is required to make a $6,500 payment on its long-term notes payable during 2018.
  
Required:
1a.
Prepare the income statement for the calendar-year 2017.
1b. Prepare the statement of owner's equity for the calendar-year 2017.
1c. Prepare the classified balance sheet at December 31, 2017.
2. Prepare the necessary closing entries at December 31, 2017.
3. Use the information in the financial statements to compute the following ratios:

In: Accounting

Ball Construction Corporation You are the audit senior of Ball Construction Corporation (BC), a small public...

Ball Construction Corporation

You are the audit senior of Ball Construction Corporation (BC), a small public company that enters into construction contracts with individuals and developers and builds to their specifications. BC is a Canadian company, but recently opened a branch in the southwestern United States.

It is September and the audit fieldwork for this year's audit engagement has just been completed. You are in the process of finalizing the audit file. The following is documented in the audit file:

Risk Assessment

Although BC's audit is recurring and we are familiar with its operations and systems, we determined that the audit risk for this year has increased from medium to high. There are three main reasons for the change:

  • •Recent declines and instability in the U.S. housing market have created a high-credit-risk situation.
  • •BC's controller left in March 2020, and the position had not been filled by year end.
  • •The bank increased the interest rate on the company's operating line during the year, suggesting that it views BC as a higher risk than before.

Audit Approach

No information systems issues were noted in prior years. While we identified isolated control weaknesses in this year's review of the systems, overall the controls appear reliable. We will use a combined approach, and, because of the increased risk, we will increase the amount of substantive work.

Materiality

Planning materiality was set at $242,000.

  • 1.Internal control
    • (a)When the controller left, the finance department staff took on additional duties. We noted that during the latter part of the year, the same individual was creating purchase orders, entering invoices into the system, and preparing the cheque runs. The CFO said the situation was unavoidable, and noted that the accounting manager reviewed the cheque runs and prepared the bank reconciliations.
    • (b)We noted that many journal entries had not been approved. The CFO said that he trained most of the employees responsible for the entries, so he knows what the entries are for. He also said, “Our management review of reports and financial statements would uncover any incorrect entries.”
    • (c)The CFO relies on senior management to review, approve, and sign reports generated by the finance department, such as the costing report by project. Testing of a sample of reports indicated that most reports had been appropriately approved. However, some reports were found on a construction manager's desk. When asked about them, she explained, “I'm so busy managing the jobs that I have that I haven't had time yet to look them over.” The signed reports were given to the audit team the next day and the audit testing was completed.
  • 2.Accounts receivable and allowance for doubtful accounts

We sent confirmations to a sample of accounts receivable and noted the following issues based on the responses received:

  • •One confirmation was returned stating that a receivable balance, related to a $1,542,000 contract, was overstated based on the progress report. Upon examination of the relevant report, we noted that a transposition error had occurred (86 percent completion was used when it should have been 68 percent). This represents a known error of $277,560. The CFO agreed that it was an error but was satisfied that this was an isolated issue and would normally have been caught by the supervisor's review. The CFO does not want to adjust for this error.
  • •The CFO was quite adamant that no adjustments be made to the financial statements, declaring that “the statements fairly and accurately represent the financial situation of BC.”

Required

a.  

What type of audit report should be prepared, assuming the CFO does not change his position? Discuss.

b.  

Prepare the draft management letter.

In: Accounting

The adjusted trial balance for Tybalt Construction as of December 31, 2019, follows. TYBALT CONSTRUCTION Adjusted...

The adjusted trial balance for Tybalt Construction as of December 31, 2019, follows.

TYBALT CONSTRUCTION
Adjusted Trial Balance
December 31, 2019
No. Account Title Debit Credit
101 Cash $ 6,000
104 Short-term investments 24,000
126 Supplies 8,300
128 Prepaid insurance 7,300
167 Equipment 50,000
168 Accumulated depreciation—Equipment $ 25,000
173 Building 177,000
174 Accumulated depreciation—Building 59,000
183 Land 53,520
201 Accounts payable 15,000
203 Interest payable 2,300
208 Rent payable 3,600
210 Wages payable 2,900
213 Property taxes payable 800
233 Unearned professional fees 7,600
244 Current portion of long term note payable 9,000
251 Long-term notes payable 63,500
307 Common stock 6,000
318 Retained earnings 126,700
319 Dividends 11,900
401 Professional fees earned 99,000
406 Rent earned 16,500
407 Dividends earned 2,500
409 Interest earned 2,900
606 Depreciation expense—Building 12,980
612 Depreciation expense—Equipment 7,500
623 Wages expense 30,500
633 Interest expense 3,900
637 Insurance expense 9,400
640 Rent expense 13,100
652 Supplies expense 6,500
682 Postage expense 2,800
683 Property taxes expense 3,800
684 Repairs expense 7,000
688 Telephone expense 3,200
690 Utilities expense 3,600
Totals $ 442,300 $ 442,300


O. Tybalt invested $6,000 cash in the business in exchange for common stock during year 2019. The December 31, 2018, credit balance of the Retained Earnings account was $126,700.  

Required:
1a. Prepare the income statement for the calendar-year 2019.
1b. Prepare the statement of retained earnings for the calendar-year 2019.
1c. Prepare the classified balance sheet at December 31, 2019.
2. Prepare the necessary closing entries at December 31, 2019.

In: Accounting

On February 1, 2021, Arrow Construction Company entered into a three-year construction contract to build a...

On February 1, 2021, Arrow Construction Company entered into a three-year construction contract to build a bridge for a price of $8,225,000. During 2021, costs of $2,090,000 were incurred, with estimated costs of $4,090,000 yet to be incurred. Billings of $2,608,000 were sent, and cash collected was $2,340,000.

In 2022, costs incurred were $2,608,000 with remaining costs estimated to be $3,735,000. 2022 billings were $2,858,000, and $2,565,000 cash was collected. The project was completed in 2023 after additional costs of $3,890,000 were incurred. The company’s fiscal year-end is December 31. This project does not qualify for revenue recognition over time.

Required:
1. Calculate the amount of revenue and gross profit or loss to be recognized in each of the three years.

In: Accounting

The adjusted trial balance for Tybalt Construction as of December 31, 2015, follows. TYBALT CONSTRUCTION Adjusted...

The adjusted trial balance for Tybalt Construction as of December 31, 2015, follows.

TYBALT CONSTRUCTION
Adjusted Trial Balance
December 31, 2015
No.   Account Title   Debit   Credit
101   Cash      $   5,000                 
104   Short-term investments         23,000                 
126   Supplies         8,100                 
128   Prepaid insurance         7,000                 
167   Equipment         40,000                 
168   Accumulated depreciation—Equipment                  $   20,000     
173   Building         150,000                 
174   Accumulated depreciation—Building                     50,000     
183   Land         55,000                 
201   Accounts payable                     16,500     
203   Interest payable                     2,500     
208   Rent payable                     3,500     
210   Wages payable                     2,500     
213   Property taxes payable                     900     
233   Unearned professional fees                     7,500     
251   Long-term notes payable                     67,000     
301   O. Tybalt, Capital                     126,400     
302   O. Tybalt, Withdrawals         13,000                 
401   Professional fees earned                     97,000     
406   Rent earned                     14,000     
407   Dividends earned                     2,000     
409   Interest earned                     2,100     
606   Depreciation expense—Building         11,000                 
612   Depreciation expense—Equipment         6,000                 
623   Wages expense         32,000                 
633   Interest expense         5,100                 
637   Insurance expense         10,000                 
640   Rent expense         13,400                 
652   Supplies expense         7,400                 
682   Postage expense         4,200                 
683   Property taxes expense         5,000                 
684   Repairs expense         8,900                 
688   Telephone expense         3,200                 
690   Utilities expense         4,600                 
      

   

    Totals      $   411,900         $   411,900     
      

   

  
O. Tybalt invested $5,000 cash in the business during year 2015 (the December 31, 2014, credit balance of the O. Tybalt, Capital account was $121,400). Tybalt Construction is required to make a $7,000 payment on its long-term notes payable during 2016.
  
Required:
1.1  
Prepare the income statement for the calendar year 2015.
      


1.2  
Prepare the statement of owner's equity for the calendar year 2015.
      
  

  
1.3  
Prepare the classified balance sheet at December 31, 2015.
      
  

  
2.   Prepare the necessary closing entries at December 31, 2015.
      
    Closing entries (all dated December 31, 2015):
      

  
3.  
Use the information in the financial statements to compute the following ratios:
      
  

This is the last question in the assignment. To submit, use Alt + S. To access other questions, proceed to the question map button.Next

In: Accounting

The adjusted trial balance for Tybalt Construction as of December 31, 2017, follows. TYBALT CONSTRUCTION Adjusted...

The adjusted trial balance for Tybalt Construction as of December 31, 2017, follows.

TYBALT CONSTRUCTION
Adjusted Trial Balance
December 31, 2017
No. Account Title Debit Credit
101 Cash $ 8,000
104 Short-term investments 22,500
126 Supplies 9,100
128 Prepaid insurance 8,800
167 Equipment 50,000
168 Accumulated depreciation—Equipment $ 25,000
173 Building 177,000
174 Accumulated depreciation—Building 59,000
183 Land 54,420
201 Accounts payable 17,500
203 Interest payable 2,600
208 Rent payable 3,000
210 Wages payable 2,300
213 Property taxes payable 900
233 Unearned professional fees 7,800
251 Long-term notes payable 67,000
301 O. Tybalt, Capital 131,300
302 O. Tybalt, Withdrawals 12,300
401 Professional fees earned 103,000
406 Rent earned 17,500
407 Dividends earned 2,100
409 Interest earned 2,300
606 Depreciation expense—Building 12,980
612 Depreciation expense—Equipment 7,500
623 Wages expense 31,000
633 Interest expense 3,400
637 Insurance expense 7,600
640 Rent expense 10,100
652 Supplies expense 6,100
682 Postage expense 2,900
683 Property taxes expense 4,700
684 Repairs expense 7,200
688 Telephone expense 2,400
690 Utilities expense 3,300
Totals $ 441,300 $ 441,300

O. Tybalt invested $8,000 cash in the business during year 2017 (the December 31, 2016, credit balance of the O. Tybalt, Capital account was $123,300). Tybalt Construction is required to make a $6,500 payment on its long-term notes payable during 2018.
  
Required:
1a.
Prepare the income statement for the calendar-year 2017.
1b. Prepare the statement of owner's equity for the calendar-year 2017.
1c. Prepare the classified balance sheet at December 31, 2017.
2. Prepare the necessary closing entries at December 31, 2017.
3. Use the information in the financial statements to compute the following ratios:
  

In: Accounting

Require filling out worksheet templet.*- You are the accountant for Smart Construction Company, a large construction...

Require filling out worksheet templet.*-

You are the accountant for Smart Construction Company, a large construction company in Colorado. You have been presented with the following financial information for Smart and asked to prepare the Statement of Cash Flows for the year ended June 30, 2017. You will complete all work for the project in this excel file, which includes the following tabs: 1. Facts - Information taken from Smart's accounting records and additional information regarding the cash flows as of June 30, 2017. 2. Worksheet - Worksheet template (also see Example 21.3a in text). 3. Cash Flows - Statement of Cash Flows template (also see Example 21.3b in text). Account Balances June 30, 2016 June 30, 2017 Debits Cash $361,700 $880,550 Accounts Receivable 100,000 125,000 Marketable Securities (at cost) 11,700 13,000 Allowance for Change in Value 1,500 1,800 Construction in Process 168,750 405,000 Prepaid Expenses 45,000 10,000 Investments (long-term) - 13,500 Leased Equipment - 20,000 Building 30,000 - Deferred tax asset 5,375 2,200 Land 10,500 10,500 Discount on Bonds Payable - 1,305 Totals 734,525 1,482,855 Credits Allowance for doubtful accounts $6,000 $4,500 Accounts Payable 87,500 210,000 Deferred tax liability 1,000 3,300 Income Taxes Payable 3,500 9,000 Note Payable (long-term) 3,500 - Accumulated Depreciation on Building 2,500 - Accumulated Depreciation on Leased Asset - 3,000 Lease obligation - 18,000 Interest payable on lease obligation - 1,800 Interest payable (Bonds) - 1,800 Bonds payable - 45,000 Billings on contruction in process 150,000 325,000 Pension liability 150,000 400,000 Convertible preferred stock, $100 par 9,000 - Common Stock, $10 par 14,000 24,500 Additional Paid-in Capital 8,700 13,700 Unrealized Increase in Value of Marketable Securities 1,500 1,800 Retained Earnings 297,325 421,455 Totals 734,525 1,482,855 Additional information: a. Dividends declared and paid totaled $650. b. 300 shares of common stock (at par) were issued for cash. c. On July 1, 2016, convertible preferred stock that had originally been issued at par value were converted into 500 shares of common stock. The book value method was used to account for the conversion. d. The long-term note payable was paid by issuing 250 shares of common stock at the beginning of the fiscal year. e. Short-term marketable securities were purchased at a cost of $1,300. The portfolio was increased by $300 to a $14,800 fair value at year-end by adjusting the related allowance account. f. During the year, a 30% interest in Ricochet Co. was purchased as an investment for $9,500. Ricochet reported $20,000 in net income for the year and paid dividends of $2,000 to Smart. g. $5,000 of accounts receivable were written off as uncollectible during the year. h. Smart’s inventory consists of Construction-in-Process in excess of the Billings on Construction-in-Process account balance. i. A building was destroyed by fire during the year and insurance proceeds of $26,000 were collected. j. The 12% bonds payable were issued on February 28, 2017, at 97. They mature on February 28, 2027. The company uses the straight-line method to amortize bond premiums and discounts. k. Smart recorded pension expense of $350,000 for the year. l. A lease agreement was signed on July 1st, 2016 for the use of equipment worth $20,000. The company determined that the transaction should be recorded as a capital lease.

Worksheet:

SMART CONSTRUCTION COMPANY
Cash Flows Worksheet
For Year Ended June 30, 2017
Balances Change Worksheet Entries
Account Titles 6/30/2016 6/30/2017 Increase (Decrease) Debit Credit
Debits
Noncash Accounts:
Credits
Cash Flows from Operating Activities:
Cash Flows from Investing Activities:
Cash Flows from Financing Activities
Investing and Financing Activities Not Affecting Cash:
Net Increase in Cash
Totals

In: Accounting