Requesting assistance in account homework, have attached the homework in a word doc and excel spreadsheet

Thank You!

1.) XYZ Company's December 31, 2015, trial balance is as follows: XYZ Company Trial Balance December 31, 2015 Account Debit Credit Cash $ 43,500 Accounts Receivable 53,500 Allowance for Doubtful Accounts 1,500 Notes Receivable 30,000 Merchandise Inventory 55,000 Land 20,000 Building 150,000 Accumulated Depreciation, Building $ 15,000 Equipment 50,000 Accumulated Depreciation, Equipment 21,000 Goodwill 26,000 Accounts Payable 25,000 Long-Term Notes Payable 75,000 Common Stock, $10 par, 2,000 shares authorized and outstanding 20,000 Retained Earnings 147,000 Sales Revenue 700,000 Salaries Expense 150,000 Utilities Expense 3,500 Cost of Goods Sold 350,000 Administrative Expenses 55,000 Sales Expenses 15,000 _______ $1,003,00 $1,003,00 Totals 0 0 XYZ is a small company and records adjusting entries and closing entries only at fiscal (calendar) year end. Correcting and adjusting entries have not been recorded. Additional Information: a. Notes Receivable is a 3-month, 6% note accepted on November 1, 2015. b. Long-Term Notes Payable is a 5-year, 5% note that was signed on July 1, 2015. Interest is payable annually. c. Building is depreciated at 3% per year. There is no salvage value. d. Equipment is depreciated at 15% per year. There is no salvage value. e. XYZ discovered, on December 30, that the inexperienced bookkeeper recorded in the general journal and general ledger that day's $1,500 cash sales as a debit to Accounts Receivable and a credit to Sales Revenue. f. The year-end physical count for Merchandise Inventory reflected a value of $51,500. Any difference in value will not be considered theft or loss. g. Salaries for the last half of December, payable in January, amount to $5,500. h. XYZ estimates that of the Accounts Receivable, 5% will not be collectable. Required: a. Prepare in journal form, any required correcting entries. b. Prepare in journal form, all end-of-the-period adjusting entries. c. Prepare a December adjusted trial balance. d. Prepare a classified balance sheet for the year ended December 31, 2015. e. Prepare in journal form, the closing entries for the year ended December 31, 2015. 2.) XYZ Company uses the periodic method and had the following inventory events during January: Date Jan. 1 Jan. 5 Jan. 10 Jan. 15 Jan. 20 Jan. 25 Jan. 30 Units Purchased 150 225 100 150 200 Unit Date Cost $7.00 Jan. 2 7.20 Jan. 7 Jan. 7.50 12 Jan. 7.80 17 Jan. 7.95 24 150 8.00 75 8.20 Units Sold 100 125 Unit Sales Price $10.00 10.00 75 12.00 200 12.50 150 15.00 Note: The January 1 amounts were the beginning inventory and unit value. (Round all total dollar values to the nearest dollar. Round all unit values to the nearest penny.) Required: a. Calculate the cost of goods available for sale. b. Calculate the dollar value of sales. c. Calculate the value of Ending Inventory and Cost of Goods Sold under the following independent assumptions: (1) LIFO method (2) FIFO method (3) Average-cost method 3.) Prepare Acme Supply Company's general journal entries for the following transactions: Jan. 1 Accepted RunTimeCo's 120-day, 10% note as settlement of an outstanding $15,000 account receivable for goods sold last year. Jan. Purchased $10,000 Equipment from XYZ, signing a 9-month, 12% note. 15 Jan. Loaned Warner Co. $30,000 cash, accepting a 90-day, 10% note. 15 Jan. Prepared accrual adjusting entry for any interest revenue. 31 Apr. Received payment in full from Warner Co. for outstanding note and interest. 15 May 1 Received payment in full from RunTimeCo for outstanding note and interest. Oct. Paid XYZ in full. 15 4.) XYZ Company purchased a refrigerated delivery truck for $65,000 on January 1, 2015. The plan is to use the truck for 5 years and then replace it. At the end of its useful life, the truck is expected to have a salvage value of $10,000. The fiscal year ends December 31. a. Prepare the depreciation table for XYZ's truck, assuming that the company uses the straight-line method for depreciation. b. Prepare the depreciation table for XYZ's truck, assuming that the company uses the doubledeclining-balance depreciation method. c. Compute the depreciation expense for 2015 for XYZ's truck, assuming the truck has an expected life of 200,000 miles and during 2015 the truck was driven 24,540 miles. Round your depreciation expense per mile to three decimal places. 5.) Acme Company has a January 15 mid-month gross salaries expense of $25,000. All is subject to FICA Social Security (6.2%), FICA Medicare (1.45%), state income tax (5%) and federal income tax (15%) withholdings. Additionally, all is subject to employer taxes to include FUTA (0.8%) and SUTA (5.4%) taxes. (Round all calculations to the nearest penny.) Required: a. Prepare the general journal entry to record the employer's payroll liability. b. Prepare the general journal entry to record the employer's payroll-tax liability. c. Prepare the general journal entry to liquidate the liabilities accrued in parts (a) and (b) on January 22. 6.) At the end of the fiscal 2015 year, Acme Company has the following information: Credit Sales, $2,500,000; Sales Returns and Allowances, $25,000; Accounts Receivable, $200,000; and Allowance for Doubtful Accounts with a Debit, $1,500. Required: a. Prepare the general journal entry to record the end-of-the-year adjusting entry if Acme uses 0.5% of Net Credit Sales as the basis for determining Bad-Debt Expense. b. Prepare the general journal entry to record the end-of-the-year adjusting entry if Acme uses 5% of Accounts Receivable as the basis for determining Bad-Debt Expense. Question 7 c. After the bank reconciliation is prepared, the entry to record bank service charges would have a credit to _______________. Question 7 options: Bank Service Charge Expense Cash Petty Cash Cash Short and Over None of the above Question 8 Malloy Company estimates uncollectible accounts using the percentage-of-receivables method and expects that 5 percent of outstanding receivables will be uncollectible for 2015. The balance in Accounts Receivable is $200,000, and the allowance account has a $3,000 credit balance before adjustment at year end. The uncollectible accounts expense for 2015 will be _______________. d. Question 8 options: $7,000 $10,000 $13,000 $9,850 None of the above e. Question 9 f. Malloy Company issued its own $10,000, 90-day, non-interest-bearing note to a bank. The only payment Malloy will ever make to the bank will be for $10,000 at the maturity date of the loan as the bank discounts the note at 10 percent. The proceeds to Malloy are _______________. g. Question 9 options: $10,000 $9,000 $9,750 $10,250 None of the above Question 10 Malloy company uses a calendar year. On 2015 July 1, Malloy Company purchased equipment for $400,000, and installation and testing costs totaled $40,000. The equipment has an estimated useful life of 10 years and an estimated salvage value of $40,000. If Malloy uses the double-declining-depreciation method, the depreciation expense for 2015 is _______________. h. Question 10 options: $88,000 $72,000 $36,000 $44,000 $40,000 i. Question 11 j. k. The result of recording a capital expenditure as a revenue expenditure is an _______________. Question 11 options: overstatement of current year's expense understatement of current year's expense understatement of subsequent year's net income overstatement of current year's net income None of the above l. Question 12 m. n. Cole Inc., a new company, purchases a two-year insurance policy for $12,000. Six months later, the correct balance in the prepaid insurance account would be _______________. o. Question 12 options: $12,000 $6,000 $9,000 None of the above p. Question 13 q. r. Which of the following is not an advantage of the corporate form of organization? s. Question 13 options: continuous existence of the entity limited liability of stockholders government regulation easy transfer of ownership t. Question 14 u. v. Treasury stock should be shown on the balance sheet as a(n) _______________. w. Question 14 options: reduction of the corporation's stockholders' equity current asset current liability investment asset Question 15 When the stockholders invest cash in the business, what is the effect on the accounting equation? Question 15 options: x. Liabilities increase and stockholders' equity increases. Both assets and liabilities increase. Both assets and stockholders' equity increase. None of the above Question 16 y. z. aa. The ending balance in retained earnings is shown in the _______________. ab. Question 16 options: income statement statement of retained earnings balance sheet both (b) and (c) both (a) and (c) (a), (b), and (c) ac. Question 17 ad. ae. A cash dividend of $500 was declared and paid to stockholders simultaneously. The correct journal entry to record the declaration and payment simultaneously is _______________. af. Question 17 options: debit Capital Stock 500 and credit Cash 500 debit Cash 500 and credit Dividends 500 debit Dividends 500 and credit Cash 500 debit Cash 500 and credit Capital Stock 500 ag. Question 18 ah. ai. If $3,000 has been earned but not yet paid to a company's workers since the last payday within an accounting period, the necessary adjusting entry at the end of that accounting period would be _______________. aj. Question 18 options: debit an expense and credit a liability debit an expense and credit an asset debit a liability and credit an asset debit a liability and credit an expense ak. Question 19 al. The accrual basis of accounting _______________. am. Question 19 options: recognizes revenues only when cash is received is used by almost all companies recognizes expenses only when cash is paid out recognizes revenues when sales are made or services are performed, and recognizes expenses only when cash is paid out an. Question 20 ao. ap. The need for adjusting entries is based on _______________. aq. Question 20 options: the matching principle source documents the cash basis of accounting activity that has already been recorded in the proper accounts ar. Question 21 as. Which of the following statements is false regarding the closing process? at. Question 21 options: The Dividends account is closed to Income Summary. The closing of expense accounts results in a debit to Income Summary. The closing of revenues results in a credit to Income Summary. The Income Summary account is closed to the Retained Earnings account. au. Question 22 av. aw. Which of the following statements is true regarding the classified balance sheet? ax. Question 22 options: Current assets include cash, accounts receivable, and equipment. Plant, property, and equipment is one category of long-term assets. Current liabilities include accounts payable, salaries payable, and notes receivable. Stockholders' equity is subdivided into current and long-term categories. ay. Question 23 az. The underlying assumptions of accounting include all the following except _______________. ba. Question 23 options: business entity going concern matching money measurement and periodicity bb. Question 24 bc. Malloy Company began the accounting period with $60,000 of merchandise, and the net cost of purchases was $240,000. A physical inventory showed $72,000 of merchandise unsold at the end of the period. The cost of goods sold of Malloy Company for the period is _______________. bd. Question 24 options: $300,000 $228,000 $252,000 $168,000 None of the above be. Question 25 bf. A classified income statement consists of all of the following major sections except _______________. bg. Question 25 options: Operating revenues Cost of goods sold Operating expenses Non-operating revenues and expenses Current assets bh. Question 26 bi. A business purchased merchandise for $12,000 on account; terms are 2/10, n/30. If $2,000 of the merchandise was returned and the remaining amount due was paid within the discount period, the purchase discount would be _______________. bj. Question 26 options: $240 $200 $1,200 $1,000 $3,600 bk. Question 27 bl. Malloy Company began the accounting period with inventory of 3,000 units at $30 each. During the period, the company purchased an additional 5,000 units at $36 each and sold 4,600 units. Assume the use of periodic inventory procedure. The cost of ending inventory using weightedaverage is _______________. bm. Question 27 options: $114,750 $157,600 $122,400 $109,650 None of the above bn. Question 28 bo. Malloy Company began the accounting period with inventory of 3,000 units at $30 each. During the period, the company purchased an additional 5,000 units at $36 each and sold 4,600 units. Assume the use of periodic inventory procedure. The cost of goods sold using weighted-average is _______________. bp. Question 28 options: $147,200 $160,350 $155,250 $114,000 None of the above bq. Question 29 br. During a period of rising prices, which inventory method might be expected to give the highest net income? bs. Question 29 options: Weighted-average FIFO LIFO Specific identification Cannot determine bt. Question 30 bu. The following information is related to the bank reconciliation of the Acme Company: Balance per bank statement Balance per ledger Deposits in transit Outstanding checks NSF check Service charges $1,951.2 0 1,869.60 271.20 427.80 61.20 13.80 bv. The adjusted/correct cash balance is _______________. bw. Question 30 options: $1,794.60 $1,719.60 $1,638.00 $1,713.00 $1,876.20 bx. Question 31 by. In a bank reconciliation, deposits in transit should be _______________. bz. Question 31 options: deducted from the balance per books deducted from the balance per bank statement added to the balance per ledger added to the balance per bank statement disregarded in the bank reconciliation