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: 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

See similar textbooks

Similar questions

Excel Online Structured Activity: Balance Sheet Analysis Consider the following financial data for J. White Industries: Total assets turnover: 1.2Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 27%Total liabilities-to-assets ratio: 45%Quick ratio: 0.90Days sales outstanding (based on 365-day year): 29.5 daysInventory turnover ratio: 4.0 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Complete the balance sheet and sales information in the table that follows for J. White Industries. Do not round intermediate calculations. Round your answers to the nearest whole dollar. Partial Income StatementInformation Sales $ fill in the blank 2 Cost of goods sold $ fill in the blank 3 Balance Sheet Cash $ fill in the blank 4 Accounts payable $ fill in the blank 5 Accounts receivable $ fill in the blank 6 Long-term debt $…
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image) Presented below is information related to Ivan Calderon Corp. for the year 2025. Net sales $1,560,000 Cost of goods sold 936,000 Selling expenses 78,000 Administrative expenses 57,600 Dividend revenue 24,000 Interest revenue 8400 Write-off of inventory due to obsolescence $96,000 Depreciation expense omitted by accident in 2024 66000 Casualty loss 60,000 Cash dividends declared 54,000 Retained earnings at December 31, 2024 1,176,000 Effective tax rate of all items 20% Instructions Prepare a multiple-step income statement for 2025. Assume that 72960 shares of common stock are outstanding for the entire year. Prepare a separate retained earnings statement for 2025.
Calculate the inventory turnover, days sales outstanding (DSO), fixed assets turnover, and total assets turnover. Has the company’s ability to manage its assets improved or worsened? Explain. A computer manufacturer has financial statements as follows: Income Statements for Year Ending December 31 (Thousands of Dollars) 2019 2018 Sales $945,000 $900,000 Expenses excluding depreciation and amortization 812,700 774,000 EBITDA $132,300 $126,000 Depreciation and amortization 33,100 31,500 EBIT $99,200 $94,500 Interest Expense 10,470 8,600 EBT $88,730 $85,900 Taxes (25%) 22,183 21,475 Net income $66,547 $64,425 Common dividends $56,609 $54,115 Addition to retained earnings $9,938 $10,310 Balance Sheets for Year Ending December 31 (Thousands of Dollars) Assets 2019…
Instructions (a) Prepare a cost of goods manufactured schedule for Superior Company for 2010. (b) Prepare an income statement for Superior Company for 2010. (c) Assume that Superior Company’s ledgers show the balances of the following current asset accounts: Cash $17,000, Accounts Receivable (net) $120,000, Prepaid Expenses $13,000, Short-term Investments $26,000. Prepare the current assets section of the balance sheet for Superior Company as of December 31, 2010.
Analyze transactions and make and post journal entries.Makeadjusting entries, produce financial statements, and close nominal accounts. Selfish Gene Company is a merchandising firm. The following events occurredduring the month of May. ( Note: Selfish Gene maintains a perpetual inventorysystem.) Instructions:1.Record the preceding events in general journal form. 2.Which event do you think had the most significant economic impact on SelfishGene Company? Are all economically relevant events recorded in the financialrecords?
Record the journal enteries under the appropiate accounts that are provided. Account # Account Title 100000 Bank Account 110100 Miscellaneous Accounts Receivable 110400 Allowance for Bad Debt 200600 Inventory-Operating Supplies 200900 Inventory-Raw Materials (Direct Post) 200910 Inventory-Finished Goods (Direct Post) 200920 Inventory-Trading Goods (Direct Post) 210000 Prepaid Insurance 212000 Prepaid Advertising 216000 Deposits on Purchases 220110 Land (Direct Post) 220210 Property, Plant & Equipment (Direct Post) 220310 Accumulated Depreciation-PP&E (Direct Post) 300200 Payables-Miscellaneous 300700 Payables-Salaries and Wages 300800 Accrued Expenses 320000 Accrued Tax-Output 329000 Common Stock 330100 Retained Earnings (Direct Posting) 600000 Sales Revenue 610000 Sales Discounts 780000 Cost of Goods Sold January 3GBI received $55,692 in safety product inventory and $37,128 in raw materials from Dallas Bike Basics. This…
(Inventoriable Goods and Costs—Perpetual) Colin Davis Machine Company maintains a general ledger account for each class of inventory, debiting such accounts for increases during the period and crediting them for decreases. The transactions below relate to the Raw Materials inventory account, which is debited for materials purchased and credited for materials requisitioned for use.1. An invoice for $8,100, terms f.o.b. destination, was received and entered January 2, 2017. The receiving report shows that the materials were received December 28, 2016.2. Materials costing $28,000, shipped f.o.b. destination, were not entered by December 31, 2016, “because they were in a railroad car on the company’s siding on that date and had not been unloaded.”3. Materials costing $7,300 were returned to the supplier on December 29, 2016, and were shipped f.o.b. shipping point. The return was entered on that date, even though the materials are not expected to reach the supplier’s place of business until…
A company shows the following data in their accounting records for 2014. Inventory 12/31/14 = $2,000,000 Inventory 1/1/14 = $1,800,000 Purchases = $20,000,000 Purchase Returns = $3,000,000 Freight – In = $40,000 Determine the amount the company recorded for Cost of Goods Sold in 2014. Show your work!
Apply mathematical skills around cost structures and appropriate equations to answer the following, inclusive of all associated workings to maximise marks: The inventory value for the financial statements of Zyon for the year ended 31st Oct 2022 was based on an inventory count on 3rd Nov 2022, which gave a total inventory value of $836,200.Between 31st Oct and 3rd Nov, the following transactions took place:Purchases of goods $8,600. Sales of goods (profit margin 35% on sales $14,000). Goods returned by Zyon to supplier $878. What adjusted figure should be included in the financial statements for inventories at 31st Oct 2022 to nearest hundred?
On December 31, 2016, after closing, the ledgers of Premium Company contained these accounts and balances:Cash P 93,000 Accounts Receivable P 105,000 Retained Earnings P74,000Finished Goods P 65,000 Work In Process P 15,000Materials P 44,000 Machinery P 70,000Accounts Payable P 118,000 Common Stock P 200,000Details of the three inventories are:Finished Goods Inventory: Materials Inventory:Item A- 2,000 units at P 12.50 P 25,000 Material X (P5/ unit) P 20,000Item B- 4,000 units at P 10.00 40,000 Material Y (P3/ unit) 24,000Work in Process Inventory: JOB 101 JOB 102Direct Materials: 1,000 units at P 5.00 P 5,000 400 units at P 3.00 P 1,200Direct Labor: 1,000 hours at P 4.00 4,000400 hours at P 5.00 2,000Factory Overhead: Applied at P 2.00/hour 2,000 800During January, 2012, these transactions were completed:a. Purchases on account: Material X- 20,000 units at P 5.60; Material Y- 24,000 units at P 3.75; indirectmaterials- P 35,040.b. Payroll totaling P 220,000 was paid. Of the total…
The following data pertain to 2012 activities of Twisp Industries: Use your completed worksheet to determine the firms cost of goods sold for 2012. Remember to change the year in row 24 and to enter new beginning inventory balances. Save the 2012 file as MFG3. Print the worksheet when done. If sales and other expenses were identical in 2011 and 2012, during which year did Twisp earn more income? Why?
Inventory Analysis The following account balances are taken from the records of Lewis Inc., a wholesaler of fresh fruits and vegetables: Required Compute Lewiss inventory turnover ratio for 2016 and 2015. Compute the number of days sales in inventory for 2016 and 2015. Assume 360 days in a year. Comment on your answers in parts (1) and (2) relative to the companys management of inventory over the two years. What problems do you see in its inventory management?