Question
Based on the Trial Balance PDF for Larry's Landscaping , prepare for 12/31/2014 the following Financial Statements in Microsoft Excel - Income Statement - Statement
Based on the Trial Balance PDF for Larry's Landscaping, prepare for 12/31/2014 the following Financial Statements in Microsoft Excel
- Income Statement
- Statement of Owners Equity
- Balance Sheet using Microsoft Excel.
Larry's Landscaping & Garden Supply - Trail Balance
| DEBIT | CREDIT | |
| Checking | 99,250.02 | |
| Cash Expenditures | 225.23 | |
| Saving | 5,987.50 | |
| Barter Account | 0.00 | |
| Accounts Receivable | 35,810.02 | |
| Prepaid Insurance | 500.00 | |
| Employees Advances | 100.00 | |
| Inventory Assets | 6,937.08 | |
| Undeposited Funds | 110.00 | |
| Truck :Accumulated Depreciation | 1,725.00 | |
| Truck:Original Purchase | 13,750.00 | |
| A/P | 2,578.69 | |
| CalOil Card | 1,403.99 | |
| QuickBooks Credit Card: QBCC Field Office | 45.00 | |
| QuickBooks Credit Card: QBCC Home Office | 25.00 | |
| Payroll Liabilities | 5,520.47 | |
| Payments on Account | 1,520.00 | |
| Sales Tax Payable | 2,086.50 | |
| Bank of Anycity Loan | 19,932.65 | |
| Equipment Loan | 3,911.32 | |
| Bank Loan | 5,369.06 | |
| Opening Bal Equity | 151,970.07 | |
| Owner's Equity: Owner's Draw | 5,000.00 | |
| Retained Earning | 40,118.74 | |
| Landscaping Services:Design services | 13,510.00 | |
| Landscaping Services: Job Materials:Misc Materials | 141.30 | |
| Landscaping Services: Job Materials:Decks & Patios | 45.00 | |
| Landscaping Services: Job Meterials: Fountains & Garden | 6,803.40 | |
| Landscaping Services: Job Maerials:Plants and sod | 5,341.95 | |
| Landscaping Services: Job Materials: Sprinklers & Drip Syst. | 3,887.21 | |
| Landscaping Services; Labor:Installation | 24,567.00 | |
| Landscaping services: Labo: Maintenance & Repairs | 3,564.50 | |
| Markup Income | 815.00 | |
| Retail Sales | 383.03 | |
| Services | 6,640.00 | |
| Cost of Goods Sold | 4,220.25 | |
| Payrol Expenses | 37,820.65 | |
| Automobile: Insurance | 427.62 | |
| Automobile: Fuel | 55.93 | |
| Automobile: Maintenance & Repairs | 254.50 | |
| Bank Service Charges | 73.50 | |
| Delivery Fee | 15.00 | |
| Insurance | 200.00 | |
| Insurance: Disability | 150.00 | |
| Insurance: Liability | 855.00 | |
| Insurance: Worker's Comp | 630.00 | |
| Interest Expense | 470.91 | |
| Job Expense: Job Materials: Deck & Patio | 0.00 | |
| Job Expense: Job Materials: Fountains & Garden lighting | 1,150.00 | |
| Job Expense: Job Materials : Plants & Sod | 902.25 | |
| Job Expense: Permits | 0.00 | |
| Job Expenses: Subcontractors | 375.00 | |
| Mileage Reimbursement | 0.00 | |
| Professional Fees: legal | 375.00 | |
| Rent | 2,400.00 | |
| Repairs: Equipment Repairs | 45.00 | |
| Tools and Misc. Equipment | 735.00 | |
| Uncategorized Expenses | 0.00 | |
| Utilities; Gas and Electric | 424.42 | |
| utilites: Telephones | 149.96 | |
| utilities: Water | 81.17 | |
| Misc Income | 762.5 | |
| Interest Income | 91.11 | |
| TOTAL | 261,119.75 | $ 261,119.75 |
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
Essential Strategies For Financial Services Compliance
Authors: Annie Mills, Peter Haines
2nd Edition
1118906136, 978-1118906132
