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

College Accounting, Chapters 1-27 (New in Accounting from Heintz and Parry)

22nd Edition

ISBN:9781305666160

Author:James A. Heintz, Robert W. Parry

Publisher:James A. Heintz, Robert W. Parry

Chapter15: Financial Statements And Year-end Accounting For A Merchandising Business

Section: Chapter Questions

Problem 9SPA: FINANCIAL RATIOS Use the work sheet and financial statements prepared in Problem 15-8A. All sales...

See similar textbooks

Similar questions

Data table (Click on the icon in order to copy its contents into a spreadsheet.) Inventory Common stock Cash Operating expenses Short-term notes payable Interest expense Depreciation expense Sales Accounts receivable Accounts payable Long-term debt Cost of goods sold Buildings and equipment Accumulated depreciation Taxes General and administrative expense Retained earnings 6,470 45,070 16,570 1,380 600 870 540 12,740 9,560 4,750 54,860 5,710 122,330 33,960 1,400 870 ? I X
Pro Forma Financial Statement Information for Ideko 2014 - 2019 Year 1. Raw Material 2. Depreciation 3. Wages Payable 4. Interest Expense 5. Finished Goods 6. Other Accounts Payable 7. Accounts Receivable 8. Cash Balance 10. Interest Tax $22,170 $30,510 $35,195 $26,420 $21,260 2014 1,973 5,500 1,294 75 4,192 3,360 18,493 6,164 3,736 2015 1,534 5,450 1,433 6,800 4,967 4,099 14,525 7,262 2,796 2016 1,775 5,405 1,695 6,800 5,838 4,953 16,970 8,485 3,364 2017 2,039 6,865 1,941 6,800 6,815 5,938 19,689 9,845 3,748 The amount of net working capital for Ideko in 2017 is closest to: 2018 2,329 7,678 2,211 7,820 7,911 6,900 22,709 11,355 4,513 2019 2,646 7,710 2,570 8,160 9,138 7,878 26,059 13,030 5,678
Use a spreadsheet and the following excerpts from Hileah Companys financial information to build a template that automatically calculates (A) inventory turnover and (B) number of days sales in inventory, for the year 2018.
Presented below are selected accounts of Blue Company at December 31, 2025. Inventory (finished goods) Unearned Service Revenue Equipment Inventory (work in process) Cash Debt Investments (trading) Customer Advances Restricted Cash for Plant Expansion 1. 2. 3. 4. 5. 6. $ 59,800 7. 94,800 The following additional information is available. 261,700 43,100 40,000 39,500 54,800 59,500 Cost of Goods Sold Notes Receivable Accounts Receivable Inventory (raw materials) Supplies Expense Allowance for Doubtful Accounts Licenses Additional Paid-in Capital Treasury Stock $2,113,900 40,400 170,720 183,830 55,820 12,420 16,580 80,630 22,540 Inventories are valued at lower-of-cost-or-market using LIFO. Equipment is recorded at cost. Accumulated depreciation, computed on a straight-line basis, is $46,245. The short-term investments have a fair value of $27,640. The notes receivable are due April 30, 2027, with interest receivable every April 30. The notes bear interest at 6%. (Hint: Accrue interest due…
Test Company (S millions) Income Statement Revenues Cost of Goods Sold Operating Income Interest Expenses Net Income 2016 2017 2018 126,034 51,556 27,414 4,733 131,650 125,980 52,557 51,424 27,059 4,376 33,060 4,920 You will receive company financials in class for assignment. Analysis 17,879 13,127 30,101 the company's financial condition: Balance Sheet Current Assets Cash & Cash Equivalents Receivables Inventory 1) liquidity 22,355 4,820 29,913 2,079 23,493 26,395 2,880 13,457 17,513 1,202 2) asset management 1,252 1,034 33,037 3) profitability Current Liabilities Payables 35,052 19,362 30,340 19,593 21,232 4) leverage Long-term Debt Shareolders Equity Total Assets 103,240 17,842 105,433 113,642 24,032 44,687 244,175 244,180 257,143 5) overall financial condition a debt and equity investor Other Data 44,368 17,830 EBITDA 42.987 Capital Expenditures 49,077 27,717 17,593 Company Stock Price Beta Dividend Payout Ratio Estimated Long-term Growth Common Shares Outstanding 10-year U.S.…
Required information Use the following information for the Problems below. (Algo) [The following information applies to the questions displayed below.] Lansing Company's current-year income statement and selected balance sheet data at December 31 of the current and prior years follow. LANSING COMPANY Income Statement For Current Year Ended December 31 Sales revenue Expenses Cost of goods sold Depreciation expense Salaries expense Rent expense Insurance expense Interest expense Utilities expense Net income $ 124,200 At December 31 Accounts receivable Inventory Accounts payable Salaries payable Utilities payable Prepaid insurance Prepaid rent 51,000 16,500 27,000 9,900 4,700 4,500 3,700 $ 6,900 LANSING COMPANY Selected Balance Sheet Accounts Current Year $ 6,500 2,880 5,300 1,060 400 350 400 Prior Year $ 7,600 1,990 6,400 790 250 460 270
ement. From the following income statement accounts in the popup window, ne income statement for the year. ne operating cash flow for the year. 6 Data Table ne income statement for the year. e income statement below. (Round to the nearest dollar. (Click on the following icon in order to copy its contents into a spreadsheet.) Income Statement Income Statement Accounts for the Year Ending 2017 Year Ending December 31, 2017 Account Cost of goods sold Interest expense Balance $345,000 $82,000 $42,000 $744,000 $66,000 $112.000 Taxes Revenue Selling, general, and administrative expenses Depreciation Print Done income any list or enter any number in the input fields and then continue to the next question. %24 %24 %24 %24
Required: Prepare the cash flows from operating activities section only of the company's 2018 statement of cash flows using the direct method. (Amounts to be deducted should be indicated with a minus sign.) LANSING COMPANY Cash Flows from Operating Activities-Direct Method For Year Ended December 31, 2018 Cash flows from operating activities Cash receipts from customers Cash payments to suppliers Cash payments for salaries Cash payments for rent Cash payments for insurance Cash payments for interest. Cash payments for utilities $ 0
FINANCIAL RATIOS Use the work sheet and financial statements prepared in Problem 15-8A. All sales are credit sales. The Accounts Receivable balance on January 1,20--, was 3,800. REQUIRED Prepare the following financial ratios: (a) Working capital (b) Current ratio (c) Quick ratio (d) Return on owners equity (e) Accounts receivable turnover and average number of days required to collect receivables (f) Inventory turnover and average number of days required to sell inventory
Homework i os Me LOGIC COMPANY Comparative Income Statement For Years Ended December 31, 2022 and 2023 Gross sales Sales returns and allowances Net sales Cost of merchandise (goods) sold Gross profit Operating expenses: Depreciation Selling and administrative Research Miscellaneous Total operating expenses Income before interest and taxes Interest expense Income before taxes Provision for taxes Net income Current assets: Cash Plant and equipment: Building (net) Land Accounts receivable Merchandise inventory. Prepaid expenses Total current assets Total assets Total plant and equipment Assets Current liabilities: Accounts payable Salaries payable Total current liabilities Common stock Retained earnings Liabilities Long-term liabilities: Mortgage note payable Total liabilities. LOGIC COMPANY Comparative Balance Sheet December 31, 2022 and 2023 Stockholders' Equity Asset turnover ratio, Total stockholders' equity Total liabilities and stockholders' equity 2023 $ 19,600 1,000 2023 $ 18,600…
Operating and Nonoperating Items in Boston Scientific's Income Statement EXHIBIT 3.6 For Year Ended December 31, S mllllons 2018 2017 2016 Net sale . Cost of products sold $9,823 $9,048 2,593 $8,386 2,424 2,813 Gross profit. Operating expenses Selllng, general and admlnIstratlve expenses. Research and development expenses Royalty expense Amortlzatlon expense Intanglble asset Impalrment charges ContIngent conslderatlon expense (beneflt) . RestructurIng charges. LItigatlon-related charges 7,010 6,455 5,962 3,569 1,113 3,294 3,099 997 920 70 68 79 599 565 545 35 4 11 (21) (80) 29 36 37 28 103 285 804 Operating expenses - 5,504 5,170 5,515 Operating income . Other expense (income) Interest expense 1,506 1,285 447 241 229 233 Other expense (income), net. (156) 124 37 Income before income taxes 1,422 932 177 Income tax expense (benefit) . (249) 828 (170) Net income. $1,671 $ 104 $ 347 Calculate the operating expense margin ratio for 2016
Income statement data: Advertising expense Cost of goods sold Delivery expense Depreciation expense-office buildings and equipment Depreciation expense-store buildings and equipment Income tax expense Interest expense Interest revenue Miscellaneous administrative expense Miscellaneous selling expense Office rent expense Office salaries expense Office supplies expense Sales Sales commissions Sales salaries expense Store supplies expense Retained earnings and balance sheet data: Accounts payable Accounts receivable Accumulated depreciation-office buildings and equipment Accumulated depreciation-store buildings and equipment Allowance for doubtful accounts Bonds payable, 5%, due in 10 years Cash Common stock, $20 par (400,000 shares authorized; 85,000 shares issued, 94,600 outstanding), January 1, 20Y8 Dividends: Cash dividends for common stock Cash dividends for preferred stock Goodwill Income tax payable $150,000 3,700,000 30,000 30,000 100,000 140,500 21,000 30,000 7,500 14,000 50,000…