BALANCE SHEET EXCEL ACTIVITY Directions: Create a Balance Sheet using Microsoft excel given the following information. Sales Office Equipment Accumulated Depreciation (Office Equipment) Retained Earnings, Jan 1 2016 Net Income 2016 Finished Goods Inventory Work in Process Inventory Cash on Hand Cash in Bank Raw Material Inventory Factory Supplies Inventory Machinery Accumulated Depreciation (Machinery) Salaries and Commissions Sales Men Accounts Receivable Allowance for Bad Debts Share, Capital 1,500,000.00 120,000.00 12,000.00 89,400.00 534,182.00 14,250.00 27,650.00 494,000.00 610,050.00 18,000.00 1,750.00 150,000.00 15,000.00 55,000.00 350,000.00 12,200.00 800,000.00 Interest Expense Prepaid Factory Insurance Company Land Accounts Payable Notes Payable Real Estate Loan payable 10 years Store Equipment Accumulated Depreciation Income Tax Payable Accrued Wages Witholding Taxes Payable SSS Premiums Payable Philhealth Premium Payable Office Suplies Inventory Depreciation Expense Store Equipment Freight Out HDMF Premium Payable (Store Equipment) 20,000.00 10,000.00 5,000,000.00 200,000.00 150,000.00 5,000,000.00 70,000.00 7,000.00 14,650.00 1,950.00 14,500.00 7,659.00 3,070.00 650.00 7,000.00 2,000.00 4,739.00

BALANCE SHEET EXCEL ACTIVITY Directions: Create a Balance Sheet using Microsoft excel given the following information. Sales Office Equipment Accumulated Depreciation (Office Equipment) Retained Earnings, Jan 1 2016 Net Income 2016 Finished Goods Inventory Work in Process Inventory Cash on Hand Cash in Bank Raw Material Inventory Factory Supplies Inventory Machinery Accumulated Depreciation (Machinery) Salaries and Commissions Sales Men Accounts Receivable Allowance for Bad Debts Share, Capital 1,500,000.00 120,000.00 12,000.00 89,400.00 534,182.00 14,250.00 27,650.00 494,000.00 610,050.00 18,000.00 1,750.00 150,000.00 15,000.00 55,000.00 350,000.00 12,200.00 800,000.00 Interest Expense Prepaid Factory Insurance Company Land Accounts Payable Notes Payable Real Estate Loan payable 10 years Store Equipment Accumulated Depreciation Income Tax Payable Accrued Wages Witholding Taxes Payable SSS Premiums Payable Philhealth Premium Payable Office Suplies Inventory Depreciation Expense Store Equipment Freight Out HDMF Premium Payable (Store Equipment) 20,000.00 10,000.00 5,000,000.00 200,000.00 150,000.00 5,000,000.00 70,000.00 7,000.00 14,650.00 1,950.00 14,500.00 7,659.00 3,070.00 650.00 7,000.00 2,000.00 4,739.00

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Can you explain what I might be missing throughly please? I have it correct but it claims that it's not complete. What am I missing?
Clicking Generate at the bottom of the A/P Create Payment Batch form creates a payment batch. Group of answer choices. True False
Not a previously submitted question. Thank you
Answer the following questions by writing down the correct letter next to the relevant number:
Kindly answer #4 will surely given an upvote thank you
All blanks need to be filled please and thank you, it's incomplete as of now.
Not a previously submitted question. Thank you
What does the QuickBooks Online Check Register do?
Could I see the journal entries please?
True or false? In a manual system, it is proper to splits journal entry at the bottom page.
Subject : Accounting what is the lowest subscription level of QuickBooks online that allows custom fields to be added to purchase orders?
Select the best answer for the question 13. The process of transferring the information contained in the journal to the ledger is called A. cross-referencing OB. balancing the accounts OC. cross-adding D. posting. Mark for review (Will be highlighted on the review page) << Previous Question Next Quesmon