14. (12 points) Visit the homework-related module in Canvas and find the Excel spreadsheet for traditional homework item no. 14. The spreadsheet contains the unadjusted trial balance for Acme Company for the year ended 12-31-16. Acme only prepares AJEs once each year as of year-end Prepare the AJEs for the following situations:+ a Included in Acme's cash account is an interest-bearing checking account. As of 12-31-16, Acme had earned, but not yet recorded, $250 of interest income. b. Acme's prepaid rent balance of $8,000 relates to Acme's January 2016 rent. During February, 2016 Acme paid $120,000 of rent for the period of February 1, 2016 to January 31, 2017. Acme recorded the payment in a temporary account" c. As of 12-31-16, Acme had $1,000 of office supplies on hand (based on a physical count of its office supplies).. d. Acme's prepaid insurance balance of $4,200 relates to Acme's January through March 20106 insurance. During March, 2016 Acme pari $18,000 of insurance for the period of April 1, 2016 to March 31, 2017. Acme recorded the payment in a temporary account. ed $26,000 of annual depreciation expense. e. Acme f As of 12-31-16. Acme incurred, but did not yet pay, $11,000 of wage expense and $$,200 of utilities expense.- g. On 12-15-16, Acme received $15,000 from a customer for work Acme will perform during 2017. h, Acme's note payable has been outstanding since November 1, 2016. It's a 490, one-year note. The note requires Acme to pay interest every quarter with the first interest payment due on February 1 2017 L Acme's income tax rate is 30% Post the necessary AJEs to the Excel spreadsheet. Using formulas within the Excel spreadsheet, calculate the adjusted debit and credit balances for each account. Using the adjusted account balances, prepare, in good form, Acme's income statement for the year ended 12-31-16 and Acme's balance sheet as of 12-31-16