please help due by 4/20/22

F s 1 Use this Excel template file (see tabs) to complete the required accounting activities and rename it to begin with your last name (i.e. Doe_Jane ACC 120 Midterm). Note: The Unadjusted Trial Balance and the Adjusted Trial Balance have been completed for you. 2 Journalize the routine transactions described on the Journal Tab. You do not need to complete the PR section for this assignment Use the Account Names shown on the ATB 3 3 Use the Unadjusted Trial Balance and adjusting information provided (See Journal tab) to journalize the 7 adjusting entries (a-g.) 4 Use the Adjusted Trial Balance provided to prepare an Income Statement (Multi-Step) appropriate to a merchandising business, a Statement of Owner's Equity, and a report form Balance Sheet. These should be completed on the Financial Statements tab. 5 6 17 o - o o o Notes/Tips: There were no investments by owner during the reporting period. 21 This company prepares an Adjusted Thal Balance and Financial Statements at the end of each month. All adjustments are for the last 30 days (Emewe date Dec 31) Print the Adjusted Trial Balance to help complete the Financial Statements Print the linance Tral Balance to heln enolete the Directions Journal Unadjusted Trial Balance Adjusted Trial Balance Financial Statements 23 Notes/Tips There were no investments by owner during the reporting period. This company prepares an Adjusted Trial Balance and Financial Statements at the end of each month. All adjustments are for the last 30 days. (Effective date Dec 31) 23 Print the Adjusted Trial Balance to help complete the Financial Statements. Print the Unadjusted Tral Balance to help complete the Jouma/ 26 Directions Journal Financial Statements Unadjusted Trial Balance Adjusted Trial Balance Ready ABC Company INote: There is no correlation between the placement of the financial transactions listed below and their placement in the journal. General Journal Page 1 Description P.R. Debit Credit Date During the last month of the year, the following transactions were completed: Dec 1 Paid rent for December, $5000, Dec 3 Purchased merchandise from Goat Company for $10,000 under terms 1/15, n/30, FOB Shipping Point 8 9 10 11 12 Dec 4 Paid $500 cash for freight charges on purchase of Dec 3. 13 Dec 5 Sold merchandise to Beaver company for $12,000 under credit terms 2/10, n/60, FOB Shipping Point. The merchandise had a cost of $5,000. 14 16 Dec 6 Purchased merchandise from Duck Company for $25,000, under terms nleom (netet end of month). - n 2 - 0 2 8 18 Dec 8 Received $22,400 on account from Warthog Company, no discount. This sale was made in November. 22 23 Dec 9 After negotiations with Goat Company concerning problems with the Financial statements Adjusted Trial Balance Directions Journal Unadjusted Trial Balance (1) 5:59 PM 4/19/2022 72F Sunny Ready zo 3 D E F G H J K L Dec 10 Paid part-time sales clerk $3,000 which included $2,000 of Sale Salaries Payable on December 1st. (Hint: This entry will require three lines.) M Dec 11 Sold merchandise on account to Cow company, terms 2/10, n/60, FOB destination, $15,000. The merchandise had a cost of $9,000. Dec 12 Paid $600 cash for shipping charges related to the Dec 11 sale to Cow Company. Dec 13 Paid the amount due to Goat Company for the Dec 3 purchase less the allowance granted on Dec 9. Dec 15 Received balance due from Beaver Company for merchandise sold on Dec 5. 5 Dec 16 Cow company returned merchandise from the Dec 11 sale that had cost ABC Company $2,000 and been sold for $5,000. The merchandise was restored to inventory. Dec 21 Received amount due from Cow company for the Dec 11 sale less the sale return on Dec 16. Dec 23 Paid advertising expense for ads running the last week of December, $1,000. Dec 24 Paid part-time sales clerk for two weeks' salary, $3,000. NO Financial Statements 10085 E Adjusted Trial Balance Directions Journal Unadjusted Trial Balance 5:59 PM 4/19/2022 72F Sunny Alfa the nternet can contain viruses. Unless you need to edit it's safer to stay in Protected View. Comments 4 Enable Editing A B C DE F H 1 J Dec 27 Purchased office supplies on account. 5800. Dec 31 Paid Duck Company amount due from the Dec 6 purchase At the end of December, the following adjustment data were assembled. After a physical count of inventory, it was determined that $134,500 of inventory exists at December 31. b 1% of sales is expected to be refunded. Estimated Cost of Merchandise that will be returned in the next year is $3.000 d Insurance Expired during the year. $3,300. e Office supplies on hand at Dec 31, $1,250. f Depreciation for December is $700. 9 Sales clerk earned $1.500 of unpaid and unrecorded salary as of Dec 31. Financial Statements Directions Journa! Unadjusted Trial Balance Adjusted Trial Balance 72Sunny AB 119/2022 B C D ABC Company Unadjusted Trial Balance December 31, 20xx Debit Credit Cash 47,760 Petty Cash 1,000 Notes Receivable 30,000 Accounts Receivable 52,430 Merchandise Inventory 135,220 Estimated Returns Inventory 0 Prepaid Insurance 8,740 Office Supplies 2,050 Delivery Equipment 60,150 Accumulated Depreciation-Delivery Equipment 22,950 Accounts Payable 64,900 Salaries Payable 0 Customer Refunds Payable 4,100 R.W. Miller, Capital 193,870 R.W. Miller, Drawing 30,000 Sales 1,043,160 Interest Revenue 1,650 Cost of Merchandise Sold 653,070 Sales Salaries Expense 92.330 Directions Journal Unadjusted Trial Balance Adjusted Trial Balance Financial Statem EC ave Midterm Excel lemplate A - Protected View Search (Alt+0) Home Insert Page Layout Formulas Data Review View Developer Help ROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View. C E F D 64,900 0 4,100 193,870 30,000 1,043,160 1,650 B Accounts Payable Salaries Payable Customer Refunds Payable R.W. Miller, Capital R.W. Miller, Drawing Sales Interest Revenue Cost of Merchandise Sold Sales Salaries Expense Rent Expense Delivery Expense Deprecation Expense-Delivery Equipment Advertising Expense Miscellaneous Selling Expense Office Salaries Expense Insurance Expense Office Supplies Expense Miscellaneous Administrative Expense Interest Expense Total 653,070 92,330 60,000 39,360 7,630 13,030 5,090 52,300 15,280 8,700 14,490 2,000 1,330,630 1,330,630 Cash Petty Cash Notes Receivable Accounts Receivable Merchandise Inventory Estimated Returns Inventory Prepaid Insurance Office Supplies Delivery Equipment Accumulated Depreciation-Delivery Equipment Accounts Payable Salaries Payable Customer Refunds Payable R.W. Miller, Capital R.W: Miller, Drawing Sales Interest Revenue Cost of Merchandise Sold Directions Journal Unadjusted Trial Balance Debit Credit 47,760 1,000 30,000 52,430 134,500 8,000 5,440 1,250 60,150 23,650 64,900 1,500 14,532 193,870 30,000 1,032.728 1,650 645,790 Adjusted Trial Balance Financial Statements E F G 1,032,728 1,650 D R.W. Miller, Drawing 30,000 Sals Interest Revenue Cost of Merchandise Sold 645,790 Sales Salaries Expense 93,830 Rent Expense 60,000 Delivery Expense 39,360 Deprecation Expense-Delivery Equipment 8,330 Advertising Expense 13,030 Miscellaneous Selling Expense 5,090 # Office Salaries Expense 52,300 # Insurance Expense 18,580 # Office Supplies Expense 9,500 # Miscellaneous Administrative Expense 14.490 Interest Expense 2,000 Total 1,332,830 ABC Company considers these items "Selling Expenses. #ABC Company considers these items "Administrative Expenses." 1,332,830 B File Home Insert Page Layout Formulas Data Review View Developer Help Comments Share PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View. Enable Editing A2 fx A BCD E F G H M N O P Q R S 1 2 3 4 Note: See Chapter 6 (Exhibits 11,12,14) for proper formatting of Financial Statements DO NOT MODIFY FORMATTING (Multi-Step Income Statement and Report Form Balance Sheet) ABC Company ABC Company Income Statement Balance Sheet Assets Tips Assets = Llabilities - Owners Equity All Account balances will be reflected on the Financial Statements Essure you reported the correct balances from the Adeusted Thal All Financial Statements require a date 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 26 27 Journal Unadjusted Trial Balance Adjusted Trial Balance Financial Statements 2003 6:01 PM 72 Sunny 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 46 46 47 48 ABC Company Statement of Owner's Equity Journal Unadjusted Trial Balance Adjusted Trial Balance Financial Statement Meady 1 hp