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: The Impact on Decision Makers
10th Edition
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Gary A. Porter, Curtis L. Norton
Chapter7: Receivables And Investments
Section: Chapter Questions
Problem 7.3AP
Related questions
Question
100%
PLEASE DO THIS TYPEWRITTEN ONLY FOR UPVOTE. SKIP THIS IF YOU ALREADY ANSWERED. THANK YOU.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning