Need to create an accrual income statement and balance sheet for a manufacturing corporation that makes dogs clothes.
Corporate Tax Return Instructions Part I Instructions Fall 2019 Oscar Myer Wiener Corporation is one of your new clients. Their previous accountant was known to have poor record-keeping habits, and as a result, Oscar Myer Wiener Corporation’s financial records are incomplete and hard to decipher. 1. Access the 2018TransactionList.xlsx file and code each transaction. Use your professional judgment to determine the best way to organize this data. 2. Using the information from Step 1, create an accrual income statement and balance sheet. Please ensure that these statements are formatted properly and understandable. 3. Submit your coded and filtered 2018TransactionList.xlsx and your accrual income statement and balance sheet in the dropbox provided in Blackboard. Additional information: · Book depreciation for 2018 is $38,057. · Bad debt expense for 2018 is $7,152. (Accrual – reserve method) · Actual debts written off during the year were $8,950. · Accrual gross revenue during 2018 was $1,930,000. · Sales returns during 2018 was $245,662 (The square deposits in the transaction list are net of returns). · Ending accounts payable (accrual) and ending accrued expenses (accrual) are $165,882 and $12,894. · You may need to use the information from ClientEmail.docx to correctly code each transaction. Chart of Accounts: 11000 Cash 41000 Sales 12000 Accounts receivable 41100 Sales returns 12100 Allowance for doubtful accounts 45000 Dividend income 13000 Notes receivable 46000 Interest income 14100 Raw materials 47000 Gain 14200 Work in process 50000 Cost of goods sold 14300 Finished goods 51000 Salaries and wages expense 15100 Investment in municipal bonds – SLC 52100 Repairs 15200 Investment in common stock – Pioneer 52200 Property taxes 15300 Investments – Domestic Corporation 52300 Licenses and fees 16000 Land 52400 Payroll taxes 16100 Building 52500 Depreciation expense 16200 Machinery and equipment 52600 Bad debt expense 16250 Accumulated depreciation 52700 Advertising 21000 Bank loans 52800 Insurance 21200 Accounts payable 52900 Utilities 21300 Accrued expenses 53000 Travel expense 22000 Bonds payable 53100 Administrative expense 30000 Preferred stock 54000 Interest expense 31000 Common stock 55000 Charitable contributions 31100 Additional paid in capital 56000 Legal fees 32000 Retained earnings 70000 Factory overhead 33000 Dividends Accounting & Tax Solutions, Thank you so much for assisting us with our 2018 tax return. I know that we already missed the extension deadline, but I am hoping that we can get this resolved before the end of the year. We asked our previous accountant for as much information as possible, and he sent us the following account balances: Here are some other notes that I think will be pertinent: *The only cost that is ever on account is raw materials. The only cost that is ever credited to accrued expenses is other factory costs. All other costs are paid for in cash immediately, so they have no relation to accounts payable or accrued expenses. *The work in process inventory always has a $0 beginning and ending balance. *The 9/5 payment to Adams Cruise and Air includes $450 for meals. *The 12/23/18 payment to Adams Cruise and Air includes $1,400 for meals. *The 5/20 payment to Adams Cruise and Air includes $150 for meals. *A list of vendors that service the factory exclusively: Factory Payroll Processing: The Payroll People Other Factory Costs: Nichols Equipment Maintenance Mimi Cleaning Triana Wolf Leasing Placeholder Company *The St. Lucie Bonds that is listed on that 2017 balance sheet are actually Hillsborough County bonds. The Hillsborough County bonds were purchased on July 6, 2003 and were sold on November 16, 2018 for $3,215. *The shares of Pioneer Corp common stock on March 14, 2018 for $26,300. The stock was purchased for $18,200 on May 9, 2000. *We did not purchase or dispose of any machinery and equipment during the year. Again, thank you for your help! My entire staff and I are about to go on vacation until January 2, 2020, so we will be unreachable for questions. I trust that you will be able to file the return on time. Best Regards, 10/7/19 Accounting & Tax Solutions, I think this is the information you were asking for. I referred to our end of year counts, and I found the ending inventory balances: The ending balance in raw materials is $77616. The ending balance in finished goods is $140625. According to the December 31st statements, the bank loan balance as of 12/31/18 was $76651. As of the end of the year, we owed $165882 in AP and $12894 in accrued expenses. Cheers,