In need of help with the following information being added to my excel pictured below. The info below is what needs to be added.Thanks!
Second years Income Statement, Second year-end
Balance Sheet, all related General Journal entries including adjusting entries,
General Ledger with account balances and Statement of Retained Earnings.
The Second years Income Statement Multiple Step, must have at least the following
accounts and may have others
i.Sales and/or Service Revenue, ii.Returns and allowances, iii.Sales Discounts, iv.Cost of goods sold, v.Expenses
1.Rent Expense, 2.Utility Expense,3.Salary Expense, 4.Insurance Expense, 5.Depreciation Expense, 6.Interest Expense, 7.Income tax expense
vi.Net Income
b. Second year ending balance sheet
i.The Balance Sheet must have at least the following asset accounts and may
have others as needed.
1.Cash, 2.Accounts Receivable, 3.Supplies,4.A Prepaid Asset,5.Equipment and accumulated depreciation,6.Building and accumulated depreciation
ii.The Balance Sheet must have at least the following three Liability Accounts and may have more as needed.
1.Accounts Payable, 2.Salary Payable,3.Unearned Revenue,4.Mortgage, 5.Notes Payable
iii.The Balance Sheet must have at least the following two Stockholders Equity
Accounts and may have others as needed.
1.Common Stock,2.Retained Earnings
c. All general journal entries related to the second years Income Statement and Balance
Sheet at the end of the second year.
d.General Ledger
i. Prepare an account in the General Ledger for each account used in the Balance
Sheet, ii. Prepare a balance for each account in the General Ledger
AutoSave OFF OFF A SUBES Kato subs, Excel sheet, Ben and Trey pt.2 Home Insert Draw Page Layout Formulas Review View Developer Tell me Share Comments X Calibri (Body) v A v 12 et Wrap Text General Insert v Y , 4 v Delete v Paste B 1 I U Av = = = - Merge & Center v Conditional Format Cell Formatting es Table Styles Ideas Y Sort Filter Sensitivity # Format Find & Select V H164 fx f B D H L M N N 0 P O U V w X Liabilities Current Liabilities Accounts Payable Notes Payable Income Tax Payable Total Liabilities $20,000 $10,000 $10,000 $40,000 Stockholders Equity Commen stock $30,000 Retained earnings $100,000 Service Revenue $10,000 Total Stockholer Equity $140,000 Total Stockholer Equity & liabilities $180.000 7 Assets a Current Assets 9 Cash $100,000 10 Prepaid insurance $5,000 11 Supplies $25,000 12 Equipment $40.000 12 Accounts Recevable $10,000 14 Total Assets $180,000 15 16 17 18 19 20 21 jan 1. Cash 22 Common Shares 23 24 jan. Prepaid insurance Cash 26 27 jan! Supplies Cash Kato Sub Journal Entry 1/29/21 $30,000 $30,000 $5,000 $5,000 $25,000 $25,000 30 jan 18 31 Accounts recievable Services $10,000 $10,000 33 jan 23 34 Equipment $40,000 Cash $40,000 37 Kata Subs General Ledger 1/29/21 co Supalles $25,000 Equipment $40,000 Accounts Recievable $10,000 41 22 Cash $100,000 $5,000 $30,000 $ $25,000 $40,000 44 $60,000 27 Accounts payable Nates Payable Income Tax Insurance Sheet1 Sheet2 + Ready # E- 36% AutoSave OFF OFF A SUBES Kato subs, Excel sheet, Ben and Trey pt.2 Home Insert Draw Page Layout Formulas Review View Developer Tell me Share Comments X Calibri (Body) v A v 12 et Wrap Text General ... Insert v 7 0 4 v Delete Paste BIU Av - = = = Merge & Center Y Conditional Format Cell Formatting es Table Styles Ideas Sort Filter Sensitivity # Format Find & Select V H164 fx B HISIAL $5,000 H L P 5 U W X RIXIALISIE $20,000 NRPS PSYC $10,000 N 0 TRI $10,000 49 51 54 Retained Camings $100,000 Common Stock $30,00 Service Revenue $10,000 57 59 HD 62 62 Kata Subs Trial Balance 1/29/21 Kato Subs Income statement 1/30/21 64 Revenues Service Revenue $10,000 6 prepaid Insurance 67 Cash m Accounts recievable S Supplies 70 Equipment 71 Accounts Payable 72 Notes Payable 72 Income tax Payabla 74 Common stock 75 Retained earrings & Service Reverde 77 Total $5,000 $100,000 $10,000 $25,000 $40,000 $20,000 $10,000 $10,000 $30,000 $100,000 $10,000 $180.000 $180,000 Exp. k La hillities Rent experise Utility expense Wages. Expense Insurance experise Total Net income $2.000 SGCO $1,500 $750 $4,850 $5,150 79 30 Kato Subs Cassified blance sheet 1/30/21 Kata Subs Journal entry 1/30/21 B2 B2 Current assets Cash Accounts receivable Jan 3.1 30 $10,000 Service Revenue Income suminary B5 $10,000 Supplies $100,000 $10,000 $25,000 $5,000 B7 Jan 31 $ $4,850 Prepaid insurance Tral Sheet2 + Income summary Bentence $200 Sheet1 Ready # - 86% AutoSave OFF OFF A SUBES Kato subs, Excel sheet, Ben and Trey pt.2 Home Insert Draw Page Layout Formulas Review View Developer Tell me Share Comments X Calibrl (Body) v 12 ~ A 2 Wrap Text Insert v General E. 7 0 4 v Delete v Paste B 1 Av = = = - Merge & Center Ideas Y Conditional Format Cell Formatting es Table Styles Sort Filter Sensitivity # Format Find & Select V H164 fx B S H L M 0 P O U V w X 89 D Property.plant &equipment Building $50,00 Equipment $40,000 Acc. Depreciation $20,000 Total $110,000 Utilities experse Wages expense Insurance expense S600 $1,500 $750 91 ) Feb.1 $5,150 Income summary Retained earnings 94 $5,150 Total Assets $250,000 97 Liabilities and stockholders Equity Current liabilities Notes payable $10,000 Accounts payable $20,000 Salary payable $15,000 Unearned serv. Rev $25,000 Tata! $70,000 Kata Subs General ledger 1/30/21 Accounts redevable $10.000 Supplies $25,000 Prepaid Insurance $5,000 95 100 101 102 103 104 105 106 107 106 109 110 1 111 112 Long-term liabilities Mortgage payable Total liabilities Cash $100,000 $5,000 $30,000 $25,000 $50,000 $10.00 $80,000 Stockholders equity Common stock Retained earnings Total L& SE $30,000 $100.000 $210,000 $50,000 $10,000 $25,000 $5,000 Huilding $50,000 ccumulated depreciatia $20.000 Notes payable $10,000 Accounts payable $20.000 $50,000 $20.000 114 115 116 117 11B 119 120 121 127 123 124 125 126 127 128 129 $10,000 $20,000 Salary Payable $15,000 Inearned service revenu $25.000 Mortgage payable $10,000 Common Stocks $30,000 Retained eamines $100.000 Sheet1 Sheet2 + Ready # . - 36% AutoSave OFF OFF A SUBES Kato subs, Excel sheet, Ben and Trey pt.2 Home Insert Draw Page Layout Formulas Review View Developer Tell me Share Comments X Calibri (Body) v A v 12 et Wrap Text General Insert v Y , 4 v Delete v Paste B 1 I U Av = = = - Merge & Center v Conditional Format Cell Formatting es Table Styles Ideas Y Sort Filter Sensitivity # Format Find & Select V H164 fx f B D H L M N N 0 P O U V w X Liabilities Current Liabilities Accounts Payable Notes Payable Income Tax Payable Total Liabilities $20,000 $10,000 $10,000 $40,000 Stockholders Equity Commen stock $30,000 Retained earnings $100,000 Service Revenue $10,000 Total Stockholer Equity $140,000 Total Stockholer Equity & liabilities $180.000 7 Assets a Current Assets 9 Cash $100,000 10 Prepaid insurance $5,000 11 Supplies $25,000 12 Equipment $40.000 12 Accounts Recevable $10,000 14 Total Assets $180,000 15 16 17 18 19 20 21 jan 1. Cash 22 Common Shares 23 24 jan. Prepaid insurance Cash 26 27 jan! Supplies Cash Kato Sub Journal Entry 1/29/21 $30,000 $30,000 $5,000 $5,000 $25,000 $25,000 30 jan 18 31 Accounts recievable Services $10,000 $10,000 33 jan 23 34 Equipment $40,000 Cash $40,000 37 Kata Subs General Ledger 1/29/21 co Supalles $25,000 Equipment $40,000 Accounts Recievable $10,000 41 22 Cash $100,000 $5,000 $30,000 $ $25,000 $40,000 44 $60,000 27 Accounts payable Nates Payable Income Tax Insurance Sheet1 Sheet2 + Ready # E- 36% AutoSave OFF OFF A SUBES Kato subs, Excel sheet, Ben and Trey pt.2 Home Insert Draw Page Layout Formulas Review View Developer Tell me Share Comments X Calibri (Body) v A v 12 et Wrap Text General ... Insert v 7 0 4 v Delete Paste BIU Av - = = = Merge & Center Y Conditional Format Cell Formatting es Table Styles Ideas Sort Filter Sensitivity # Format Find & Select V H164 fx B HISIAL $5,000 H L P 5 U W X RIXIALISIE $20,000 NRPS PSYC $10,000 N 0 TRI $10,000 49 51 54 Retained Camings $100,000 Common Stock $30,00 Service Revenue $10,000 57 59 HD 62 62 Kata Subs Trial Balance 1/29/21 Kato Subs Income statement 1/30/21 64 Revenues Service Revenue $10,000 6 prepaid Insurance 67 Cash m Accounts recievable S Supplies 70 Equipment 71 Accounts Payable 72 Notes Payable 72 Income tax Payabla 74 Common stock 75 Retained earrings & Service Reverde 77 Total $5,000 $100,000 $10,000 $25,000 $40,000 $20,000 $10,000 $10,000 $30,000 $100,000 $10,000 $180.000 $180,000 Exp. k La hillities Rent experise Utility expense Wages. Expense Insurance experise Total Net income $2.000 SGCO $1,500 $750 $4,850 $5,150 79 30 Kato Subs Cassified blance sheet 1/30/21 Kata Subs Journal entry 1/30/21 B2 B2 Current assets Cash Accounts receivable Jan 3.1 30 $10,000 Service Revenue Income suminary B5 $10,000 Supplies $100,000 $10,000 $25,000 $5,000 B7 Jan 31 $ $4,850 Prepaid insurance Tral Sheet2 + Income summary Bentence $200 Sheet1 Ready # - 86% AutoSave OFF OFF A SUBES Kato subs, Excel sheet, Ben and Trey pt.2 Home Insert Draw Page Layout Formulas Review View Developer Tell me Share Comments X Calibrl (Body) v 12 ~ A 2 Wrap Text Insert v General E. 7 0 4 v Delete v Paste B 1 Av = = = - Merge & Center Ideas Y Conditional Format Cell Formatting es Table Styles Sort Filter Sensitivity # Format Find & Select V H164 fx B S H L M 0 P O U V w X 89 D Property.plant &equipment Building $50,00 Equipment $40,000 Acc. Depreciation $20,000 Total $110,000 Utilities experse Wages expense Insurance expense S600 $1,500 $750 91 ) Feb.1 $5,150 Income summary Retained earnings 94 $5,150 Total Assets $250,000 97 Liabilities and stockholders Equity Current liabilities Notes payable $10,000 Accounts payable $20,000 Salary payable $15,000 Unearned serv. Rev $25,000 Tata! $70,000 Kata Subs General ledger 1/30/21 Accounts redevable $10.000 Supplies $25,000 Prepaid Insurance $5,000 95 100 101 102 103 104 105 106 107 106 109 110 1 111 112 Long-term liabilities Mortgage payable Total liabilities Cash $100,000 $5,000 $30,000 $25,000 $50,000 $10.00 $80,000 Stockholders equity Common stock Retained earnings Total L& SE $30,000 $100.000 $210,000 $50,000 $10,000 $25,000 $5,000 Huilding $50,000 ccumulated depreciatia $20.000 Notes payable $10,000 Accounts payable $20.000 $50,000 $20.000 114 115 116 117 11B 119 120 121 127 123 124 125 126 127 128 129 $10,000 $20,000 Salary Payable $15,000 Inearned service revenu $25.000 Mortgage payable $10,000 Common Stocks $30,000 Retained eamines $100.000 Sheet1 Sheet2 + Ready # . - 36%
