Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

for my accounting excel assignment, I now have the general journal and worksheet filled out. can someone help me solve the income statement, changes in

for my accounting excel assignment, I now have the general journal and worksheet filled out. can someone help me solve the income statement, changes in owners equity, and balance sheet?
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
it is also due in 4 hours so I need an answer before then if possible!
Account Number Name 1110 Cash 1120 Accounts Receivable 1130 Prepaid Insurance 1 1140 Prepaid Rent 2 1150 Office Supplies 3 1211 Office Equip 1212 Accum. Depr.-Office Equip. 1311 Computer Equip. 5 1312 Accum. Depr.-Computer Equip. 7 1411 Building Cost 3 1412 Accum. Depr.-Building 1510 Land 2101 Accounts Payable 1 2102 Advanced Payments 2. 2103 Interest Payable 3 2105 Salaries Payable 5 2201 Mortgage Payable B 2202 Notes Payable 7 3100 Hudson Bloom, Capital 8 3300 Hudson Bloom, Withdrawals 9 0 4100 Computer & Consulting Revenue 1 5010 Rent Expense 2 5020 Salary Expense 3 5030 Advertising Expense 4 5040 Repairs & Maint. Expense 5 5050 Oil & Gas Expense 8 5080 Supplies Exponse 7 5090 interest Expense 8 5100 Insurance Expense 9 5110 Depreciation Expense 0 1 Total 2 NET INCOME 3 Balance Unadjusted Trial Balance Debit Credit 54,702.00 0.00 1,155.00 0.00 4,968.00 0.00 9,600.00 0.00 705.00 0.00 2,450.00 0.00 0.00 0.00 215,610.00 0.00 0.00 0.00 95,000.00 0.00 0.00 0.00 18,000.00 0.00 0.00 1,595.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 101,700.00 0.00 100,250.00 0.00 187,195.00 1,900.00 0.00 Adjusting Entries Debit Credit 0.00 0.00 5,625.00 0.00 0.00 207.00 0.00 2,400.00 0.00 413.00 0.00 0.00 0.00 25.60 0.00 0.00 0.00 3,593.50 0.00 0.00 0.00 228.83 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,399.78 0.00 531.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,770.00 450.00 1,290.00 890.00 0.00 0.00 0.00 0.00 17 750.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,400.00 531.00 0.00 0.00 0.00 413.00 1,399.78 207.00 3,847,93 5,625.00 0.00 0.00 0.00 0.055 0.00 0.00 0.00 0.00 0.00 408,490.00 408,490.00 14,423.71 14,423.71 Income Statement Debit Credit 0.00 0.00 07.00 00.00 13.00 0.00 25.60 0.00 -93.50 0.00 28.83 0.00 0.00 0.00 399.78 531.00 0.00 0.00 0.00 0.00 Adjusted Tral Balance Debit Credit 54,702.00 6,780.00 4,761.00 7,200.00 292.00 2,450.00 25.60 215,610.00 3,593.50 95,000.00 228.83 18,000.00 1,595.00 Balance Sheet Debit Credit 54,702.00 6,780.00 4,761.00 7,200.00 292.00 2,450.00 25.60 215,610.00 3,593.50 95,000.00 228.83 18,000.00 1,595.00 1,399.78 531.00 101.700.00 100,250.00 187,895.00 1,399.78 531.00 101,700.00 100,250.00 187,195.00 1,900.00 1,900.00 23,375.00 23,375.00 B25.00 0.00 0.00 0.00 0.051 0.00 0.00 0.00 0.00 0.00 2,400.00 2,301.00 450.00 1.290.00 890.00 413.00 1,399.78 207.00 3,847.93 2,400.00 2,301.00 450.00 1,290.00 890.00 413.00 1,399.78 207.00 3,847.93 423.71 419,893.71 419,893.71 23,375.00 406,695.00 13,198.71 10,176.29 23,375.00 396,518.71 10,176.29 406,695.00 23,375.00 406,695.00 A Byte of Accounting Income Statement For Month Ending June 30, 2021 Revenues Computer Revenue Expenses Rent Expense Salary Expense Advertising Expense Repairs & Maint. Expense Oil & Gas Expense Supplies Expense Interest Expense Insurance Expense Depreciation Expense Total Net Income A Byte of Accounting Statement of Owner's Equity For Month Ending June 30, 2021 Total Balance, Beginning of Period Investment Net Income Withdrawals Balance, End of Period A Byte of Accounting Balance Sheet As of June 30, 2021 Assets 0 1 2 3 Current Assets Cash Accounts Recelvable Prepaid Insurance Prepaid Rent Office Supplies Total 7 Long-Term Assets Office Equip Accum. Depr. Office Equip Computer Equip Accum. Depr.-Computer Equip. Building Cost Accum. Depr.-Building Land Total Total Assets Liabilities Current Liabilities Accounts Payable Svanced Payment Interest Payable Salaries Payable Total Long-Term Liabilities Mortgage Payable Notes Pavable Welcome Chart of Accounts Transactions General Journal Current Llabilities Accounts Payable Advanced Payment Interest Payable Salaries Payable Total Long-Term Liabilities Mortgage Payable Notes Payable Total Total Liabilities Owner's Equity Hudson Bloom, Capital Total Liabilities and Owner's Equity Welcome Chart of Accounts Transactions General Journal

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statutory Audits In Europe

Authors: Michael Kend, Giulia Leoni, Cristina Florio, Silvia Gaia

1st Edition

1032201738, 978-1032201733

More Books

Students also viewed these Accounting questions