Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help making the 2019 Balance Sheet Retained Earnings is supposed to be $731,489.20 The first picture is the adjusted trial balances. The second

I need help making the 2019 Balance Sheet

Retained Earnings is supposed to be $731,489.20

The first picture is the adjusted trial balances. The second picture is what I have done, but it is incorrect I think. Please help me find my mistake, and please post answers in similar formatting. Thank you.image text in transcribedimage text in transcribed

Excel Project #2 Information - FALL 2019 Q Search Sheet Review View + Share DO = Home Insert Page Layout Formulas Data Arial 12 -A- A- 2 BI VA G32 x fx OS Wrap Text General Insert ** Delete E'A Paste Merge & Center $ % ) 0 .00 4 Conditional Format Formatting as Table Cell Styles 7, ZT Sort & Filter Format K L M N O P Q R S T U Credits 19.726 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 30,000 15,000 Stone Hill Enterprises Adjusted Trial Balance As of December 31, 2019 ACCOUNT Numbers Account Names Debits 1000 Cash 300,000 1100 Marketable Securities, Current 120,000 1200 Account Receievable 185,000 1201 Allowance for Uncollectible Accounts 1301 Prepaid Rent 45,000 1400 Inventory 160,000 1500 Supplies 53,000 1600 Marketable Securities, Non-Current 200,000 1650 Land, not in use 350,000 1700 Land, in use 1,000,000 1701 Buildings 800,000 1702 Accumulated Depreciation - Buildings 1704 Equipment 500,000 1705 Accumulated Depreciation - Equipment 1800 Copyright 65,000 2000 Accounts Payable 2020 Interest Payable 2050 Wages & Salaries Payable 2070 Warranty Liability 2090 Deferred Revenue 2100 Notes Payable 2200 Bonds Payable 3000 Common Stock 3500 Retained Earnings 4000 Sales Revenue 5000 Cost of Goods Sold 126.000 5100 Utilities Expense 65,000 5101 Internet Expense 36,000 5102 Salaries and Wages Expense 105,000 5103 Supplies Expense 1,500 5104 Rent Expense 48,000 5105 Depreciation Expense 5,000 5150 Interest Expense 725 6000 Interest Income $4,165,225 460 300 12,000 55,000 30,000 500,000 1,000,000 920,000 850,000 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 1,250 $ 4,165,225 40 42 43 Instructions 2019 Adjusted Trial Balance 2019 Balance Sheet 2020 Information 2019 Accts Rec Aging Info 2019 Income Statement Comparative Income Statement 0 - - Comparative Ba + + 80% Ready Excel Project #2 Information - FALL 2019 Q Search Sheet + Share 22 DO = Home Insert Page Layout Formulas Data 8 Calibri (Body) 12 - A- A = 2 BI USA x fx Review = = 3 View den E> Wrap Text General H D A D Insert * Delete Paste Merge & Center $ % ) 0 .00 Conditional Format Formatting as Table Cell Styles Format Sort & Filter G28 M N O P Q R Stone Hill Enterprises Balance Sheet As of December 31, 2019 $ $ 30 300,000.00 120,000.00 165 274.20 160.000.00 45,000.00 51.000.00 843 274 20 $ 6 Current Assets Cash 8 Marketable Securities Accounts Receivable (net) inventories 11 Prepaid Expenses Supplies 13 Total Current Assets 14 Investments 15 Marketable Securities 16 Land 17 Total Investments 18 Property, Plant, and Equipment Land 20 Buildings 21 Equipment Less: Accumulated Depreciation 23 Net Property, Plant, and Equipment 24 Intangible Assets 25 Copyright 26 Total Assets 120,000.00 350,000.00 470,000.00 $ 1,000,000.00 800,000.00 500 000.00 (45,000.00) 2.255,000.00 $ $ $ 65,000.00 Liabilities & Owner's Equity 460.00 12,000.00 300.00 55.000.00 30.000.00 97,750.00 29 Current Liabilities Accounts Payable Wages & Salaries Payable Interest Payable 33 Warranty Liability 34 Deferred Revenue 35 Total Current Liabilities 36 Long Term Liabilities 37 Notes Payable 38 Bonds Payable 39 Total Long Term Liabilities 40 Total Liabilities 41 Common Stock 42 Retained Earnings 43 Total Owner's Equity 44 Total Liabilities & Owner's Equity $ $ $ 500,000.00 1000,000.00 1.500,000.00 $ $ 920,000.00 731,489.20 1,651,489.20 52 Instructions 2019 Adjusted Trial Balance 2019 Balance Sheet 2020 Information 2019 Accts Rec Aging Info 2019 Income Statement Comparative Income Statement 6 - - Comparative Bal + + 70% Ready

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions