3.9

a,b,c,d,e

Many companies must file financial reports with the SEC. Many of these reports are available electronically through the EDGAR database. EDGAR is an acronym for Electronic Data Gathering. Analysis, and Retrieval system, and it is accessible through the World Wide Web on the internet. Instruction for using EDGAR are in Appendix A. Using the most current 10-K available on EDGAR or on the company's answer the following questions about Nike company: In what year did Nike begin operations? Other than the Nike brand, what business does Nike operate? How many employees does Nike have? Describe, in dollar amounts, Nike's accounting equation at the end of the most recent year. Has Nike's performance been improving or deteriorating over the past three years? Explain your answer. Adams Company started operations on January 1, 2013. Six months later on June 30, 2013, the company decided to prepare financial statements. The company's accountant decided to problem solve for the adjusting journal entries and the final adjusted account balances by using an electronic spreadsheet. Once the spreadsheet is complete, she will record the adjusting entries in the general journal and post to the ledger. The accountant has started the following spreadsheet but wants you to finish it for her. On a blank spreadsheet, enter the following trial balance in Columns A through C. Also enter the headings for Columns E through I. On January 1 invested in a one-year, $10,000 certificate of deposit that has a 5 percent interest rate. On January 1 paid $12,000 in advance for a one-year on office space. Received in the mail a utility bill dated June 30 for $150. Purchased $1,500 of supplies on January 1. As of June 30,$700 of supplies remained on hand Develop formulas to sum both the Debit and Credit columns under the Adjusting Journal Entries heading. Develop formulas to derive the adjusted balances for the adjusted trail balance. For example, the formula for the ending balance of Unearned Revenue is =C10-E10-G10. In other words, a credit balance minus debit entries plus credit entries equals the ending copied to all other credit account; the same is true for debit accounts, Once an ending balance is formulated for a debit account, that formula can be copied to all other debit accounts. Develop formulas to sum both the Debit and Credit columns under the Adjusted Trial Balance heading. Rows and columns can be inserted by positioning the mouse on the immediate row or column after desired position. Click on the right mouse button. With the left mouse button, choose Insert and then either Entire Column or Entire Row. Use the same method to delete columns or rows. Enter the sequential numbering of the adjusting entries as labels rather than values by positioning an apostrophe in front of each entry should be labeled '(1). At the end of the accounting period, Adams Company's general ledger contained the following adjusted balances