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 (Store Equipment) Freight Out HDMF Premium Payable 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 (Store Equipment) Freight Out HDMF Premium Payable 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

PLEASE HELP ASAP!
Hi! Can you help me solve this problem? Thank you
only answer d now please
Assume a world that meets all assumptions of the portfolio theory. In this world we solely trade in securities A and B like depicted in the graph below. Short selling is allowed. xA and XB indicate the proportions of security A and B within a portfolio respectively. P1, P2, P3 and P4 represent portfolios that can be created by trading (either long and/or short) in securhies A and B. P3 is the portfolio with the lowest risk; the risk of P3 is 0%. The risk of security A and B is measured by the standard deviation of the returns in the particular security and equals 20% for both. The correlation coefficient of the returns between A and B is -1. 40% P1 E(R) A 30% P2 20% P3 10% P4 ++ 30% 0% 10% 20% 40% O(R) Question: Indicate which statements are correct. Take into account that everything is possible, from all correct to all wrong.
Please send me answer as soon as possible
Explain the Golsen Rule and, in your own words, provide an example of the application of the Golsen Rule. 4 MacBook Air Fo
How does someone set up an RRSP account? What is an RRSP
How do you find yeild to call?
Hh1.
What is an invoice extension and how is it calculated?