Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need the following created from Trail Balance: Income Statement Balance Sheet Retained Earnings Statement Cash Flow Statement 2:50 PM 12/15/15 Accrual Basis Rock Castle Construction
Need the following created from Trail Balance:
2:50 PM 12/15/15 Accrual Basis Rock Castle Construction Trial Balance As of December 31, 2019 Dec 11, 10 Delt Credit 35.00 75509 92.70793 2.440.00 30.663 38 B92.00 4.000.00 3.703.02 4.000.00 34325.00 78.936.91 335.000.00 15.300.00 00.000.00 110,344.60 1.72000 15.536.30 150.094 20 382 62 1,364.00 2.118.82 0.00 10300 Savings 10100 Checking 10400 - Petty cash 11000 Accounts Receivable 12000 Undeposed Funds 12100. Inventory Asset 12000 - Employee Advances 13100. Pre-paid Insurance 13400 - Retinage Receivable 1600 - scooter 15000 - Furniture and Equipment 15100 Vehicles 15200 Buildings and improvements 15300 Construction Equipment 16900 - Land 17000. Accumulated Depreciation 16700 Security Deposits 20000 Accounts Payable 20500 QuickBooks Credit Card 20600 Caloll Credit Card 24000. Payroll Liabilities:24010. Federal Withholding 24000. Payroll Liabilities:24020 FICA Payable 24000 Payroll Liabilities: 24036 - AEIC Payable 24000. Payroll Liabilities: 24040-FUTA Payable 24000 Payroll Liabilities:24050 State Withholding 24000 - Payroll Liabilities:24000 SUTA Payable 24000. Payroll Liabilities:24070 - State Disability Payable 24000 - Payroll Liabilities:24080 - Worker's Compensation 24000. Payroll Liabilities:24100 Emp, Health Ins Payable 25500 Sales Tax Payable 2600 - Scooter Loan 23000. Loan Vehicles (Van) 23100 Loan. Vehicles (Utility Truck) 23200 - Loan Vehicles (Pickup Truck) 28100. Loan - Construction Equipment 28200. Loan - Furniture Office Equip 28700 - Note Payable - Bank of Anycity 28900 - Mortgage - Office Building 30100 Capital Stock 32000 - Retained Earnings 40100 - Construction Income 40100 Construction Income:40110 - Design Income 40100 - Construction Income:40130 - Labor Income 40100 - Construction Income:40140 - Materials Income 100.00 299.19 110.00 48.13 1.214 31 150,00 957 63 4,000.00 10.501 47 19.936.91 22,54100 13.911 32 21,000.00 2.693 21 298.283.00 39.273.75 61,756.76 0.00 35,729 25 208,225.42 119.920,67 Page 2:50 PM 12/15/19 Accrual Basis Rock Castle Construction Trial Balance As of December 31, 2019 Dec 21,10 Debit Credit 52.710 35 45.35 1,22375 89505 14. 756.19 1650.00 99,435.90 700.00 63 21795 797.10 201.81 40100 - Construction Income:40150 - Subcontracted Labor Income 40100. Construction Income:40199. Less Discounts given 40500 Reimbursement Income: 40520 . Permit Reimbursement Income 40500 - Reimbursement Income: 40530 - Reimbursed Freight & Delivery 50100 Cost of Goods Sold 54000 Job Expenses:54200 Equipment Rental 54000. Job Expenses 54300 - Job Materials 54000 Job Expenses 54400. Permits and Licenses 54000. Job Expenses:54500 Subcontractors 54000 Job Expenses: 54520. Freight & Delivery 54000. Job Expenses:54599- Less Discounts Taken food 60100 - Automobile:60110. Fuel 60100 - Automobile:60120 - Insurance 60100 - Automobile:60130 - Repairs and Maintenance 60300 - Bad debt 60600 - Bank Service Charges 62100 - Insurance:62110 - Disability Insurance 62100 Insurance:62120 - Liability Insurance 62100 - Insurance:62130 - Work Comp 62400 - Interest Expense:62420 - Loan Interest 62700. Payroll Expenses:62710 Gross Wages 62700. Payroll Expenses:62720. Payroll Taxes 62700. Payroll Expenses:62730. FUTA Expense 62700. Payroll Expenses:62740 - SUTA Exponse 63100 Postage 63600. Professional Fees:63610 - Accounting 64200. Repairs:64210. Building Repairs 64200. Repairs:64220. Computer Repairs 64200. Repairs:64230. Equipment Repairs 64800 Tools and Machinery 65100 - Utilities:65110 Gas and Electric 65100 Utilities:65120 - Telephone 65100 - Utilities:65130 - Water 70100. Other Income 70200 . Interest Income TOTAL 44.95 1.588.70 2.850.24 2,405.00 300.00 125 00 582.00 5,885.96 13,657.07 151,995.65 110,400.10 8.445.61 268.00 1,233.50 104 20 250.00 175.00 0.00 1,350.00 2.820.68 1.164.16 841.15 264.00 146.80 229.16 1,225,000.48 1,225,000.48 2:54 PM 12115/19 Accrual Basis Rock Castle Construction Trial Balance As of December 31, 2018 Dec 31, 18 Debit Credit 15 01.03 36.610.10 500.00 21 24930 18.252.08 12.767.04 77000 4,943.02 1.790.72 22.826.00 78.936.91 325,000.00 15,300.00 90,000.00 110,344.60 1,720.00 13,100.00 000 530.00 10300 - Savings 10100 Checking 10400. Petty Cash 11000 - Accounts Receivable 12000. Undeposited Funds 12100: Inventory Asset 12800 - Employee Advances 13100. Pre-paid Insurance 13400. Retainage Receivable 15000 - Furniture and Equipment 15100 Vehicles 15200 - Buildings and improvements 15300 - Construction Equipment 16900 - Land 17000 Accumulated Depreciation 18700 - Security Deposits 20000 Accounts Payable 20500 QuickBooks Credit Card 20600. Caloll Credit Card 24000 - Payroll Liabilities:24010. Federal Withholding 24000. Payroll Liabilities:24020 - FICA Payable 24000 - Payroll Liabilities:24040-FUTA Payable 24000. Payroll Liabilities:24050 State Withholding 24000 - Payroll Liabilities:24060. SUTA Payable 24000. Payroll Liabilities:24070 - State Disability Payable 24000. Payroll Liabilities:24080. Worker's Compensation 25500 - Sales Tax Payable 23000 Loan - Vehicles (Van) 23100 - Loan - Vehicles (Utility Truck) 23200 Loan - Vehicles (Pickup Truck) 28100 - Loan - Construction Equipment 28200 - Loan - Furniture Office Equip 28700 - Note Payable - Bank of Anycity 28900. Mortgage - Office Building 30100. Capital Stock 32000. Retained Earnings 40100 - Construction Income:40110 - Design Income 40100 Construction Income:40130 - Labor Income 40100 - Construction Income:40140 - Materials Income 40100. Construction Income: 40150 - Subcontracted Labor Income 40500 - Reimbursement Income:40520 - Permit Reimbursement Income 50100 Cost of Goods Sold 54000. Job Expenses:54300. Job Materials 54000 - Job Expenses:54400. Permits and Licenses 0.00 0.00 0.00 0.00 0.00 0.00 0.00 72.18 16.290.52 19.936.91 22,841.00 14,343 11 21.00000 31.180 52 296.283.00 39.273.75 36.213.97 3,400.00 16,335.00 36,023.77 112566 50 83500 5.620.95 12.171.50 225.00 2:54 PM 12/15/19 Accrual Basis Rock Castle Construction Trial Balance As of December 31, 2018 Dec 31, 18 54000. Job Expenses:54500 Subcontractors 60100. Automobile:60110 . Fuel 60100 . Automobile:60120 Insurance 60100. Automobile:60130. Repairs and Maintenance 60600. Bank Service Charges 60900. Depreciation Expenso 62100. Insurance:62110 Disability Insurance 62100 Insurance:62120 Liability Insurance 62100. Insurance:62130 Work Comp 62400. Interest Expense:62420 Loan Interest 63600. Professional Fees:63610. Accounting 64200. Repairs:64220. Computer Repairs 64200. Repairs:64230. Equipment Repairs 64800 Tools and Machinery 65100 Utilities:65110 Gas and Electric 65100 - Utilities:65120. Telephone 65100. Utilities:65130. Water 70200. Interest Income TOTAL Debit Credit 53,350.00 1.715.00 2.850.24 2,550.00 150.00 44,435.91 600.00 5,092.98 3.300.00 4,705.48 250.00 714.00 1,800.00 1,457.91 1.841.43 880.00 288.00 281.03 790,750.86 790,750.86 Income Statement
Balance Sheet
Retained Earnings Statement
Cash Flow Statement
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started