I need help doing this whole thing.
Horizon Company Trial Balance December 31, 2016 Prepare an income statement, statemmt of comprchensive income and balance sheet from mached trial halance i hese statenen arc to be peepareia Microsott Excel. Each tatement must fit to one page. Account Title Anach your financial statements to this sover sheet in the ordar Sisted bel Polrm-ill be deleted if the "umm "'n na mperly Handwritnes, individal or lau assigmnts will nox be acceptal Debit Credit Cash Receivables. In $197,000 470,000 620,000 725,000 .. 589,000 STATEMENTS CHECKLIST Income Statement Statemest of Comprehensive Income Balance Set Land. Buildings Accumulated depreciation- machinery Machinery.... Goodwill. Patent Sales Revenuc.... Payables.. Gain on operation of a discontinued segment of the business Restructuring costs.... 460,000 195,000 $8,313,000 2565,000 78,000 Selling Expense.... Unrealized loss on available for sale investments..... Administrative expense.. Interest expense. Research and development expense. 4,870,000 1,225,000 25,000 ..975,000 156,000 256,000 Dividend revenue Common Stock, SI par... Retained carmings. Paid-in capital in excess ofpar 400,00 199,00 400,000 Long 80,010 Moncy markct furd 85,000 Investmest ut the 12.315000 Additional information 1. Cash inclades: Cash in City Bank checking account Cash in a savings account at State Bank representing a compensating balance for a long-term loan from this bank Restricted cash in a savings account to pay a long-term loan due 08/28/2020 Currency and coins in the office Bank overdraft at Peoples' bank Total cash $ 6,500 100,000 95,000 55,00 Owed to sapplien for merchundve and servios perchasad on account. 715,000 Donds payable dha matares 123 1/212 Stude Baik nclsded in 2015 500 clling expensc. This aost is considered aigrificent $197.000 stocks Payable January 18, 2017 This uunktion was s.wanded e empany"a merm & One million shares of SI par valse common soxk are authorined of which ste,000 sherts were sed 2. Receivables include Amount owed by customers Allowance for uncollectible accounts from customers Prepaid rent (January 2017 to September 2017) Nontrade note receivable due 2 years Short-term loan receivable Total receivables $380,000 (15,000) 36,000 49,000 Use Micnsd Excel to prepare the following 2016 nacial staneneets for or Company b Statement of comprehetsive iscone. e Clasified helance sheet 479.000 3 Inventory includes damaged goods that cost $32,000. These goods must be written off Horizon Company Trial Balance December 31, 2016 Prepare an income statement, statemmt of comprchensive income and balance sheet from mached trial halance i hese statenen arc to be peepareia Microsott Excel. Each tatement must fit to one page. Account Title Anach your financial statements to this sover sheet in the ordar Sisted bel Polrm-ill be deleted if the "umm "'n na mperly Handwritnes, individal or lau assigmnts will nox be acceptal Debit Credit Cash Receivables. In $197,000 470,000 620,000 725,000 .. 589,000 STATEMENTS CHECKLIST Income Statement Statemest of Comprehensive Income Balance Set Land. Buildings Accumulated depreciation- machinery Machinery.... Goodwill. Patent Sales Revenuc.... Payables.. Gain on operation of a discontinued segment of the business Restructuring costs.... 460,000 195,000 $8,313,000 2565,000 78,000 Selling Expense.... Unrealized loss on available for sale investments..... Administrative expense.. Interest expense. Research and development expense. 4,870,000 1,225,000 25,000 ..975,000 156,000 256,000 Dividend revenue Common Stock, SI par... Retained carmings. Paid-in capital in excess ofpar 400,00 199,00 400,000 Long 80,010 Moncy markct furd 85,000 Investmest ut the 12.315000 Additional information 1. Cash inclades: Cash in City Bank checking account Cash in a savings account at State Bank representing a compensating balance for a long-term loan from this bank Restricted cash in a savings account to pay a long-term loan due 08/28/2020 Currency and coins in the office Bank overdraft at Peoples' bank Total cash $ 6,500 100,000 95,000 55,00 Owed to sapplien for merchundve and servios perchasad on account. 715,000 Donds payable dha matares 123 1/212 Stude Baik nclsded in 2015 500 clling expensc. This aost is considered aigrificent $197.000 stocks Payable January 18, 2017 This uunktion was s.wanded e empany"a merm & One million shares of SI par valse common soxk are authorined of which ste,000 sherts were sed 2. Receivables include Amount owed by customers Allowance for uncollectible accounts from customers Prepaid rent (January 2017 to September 2017) Nontrade note receivable due 2 years Short-term loan receivable Total receivables $380,000 (15,000) 36,000 49,000 Use Micnsd Excel to prepare the following 2016 nacial staneneets for or Company b Statement of comprehetsive iscone. e Clasified helance sheet 479.000 3 Inventory includes damaged goods that cost $32,000. These goods must be written off
