Business Finance Homework Help

AIU Financial Reporting Excel Spreadsheet

Get Your Custom Essay Written From Scratch
We have worked on a similar problem. If you need help click order now button and submit your assignment instructions.
Just from $13/Page
Order Now

You will create this assignment following the Assignment Detail instructions below.

Review the tutorial How to Submit an Individual Project.

You will have an Excel file for this assignment. 

Using the data provided, perform the steps below to complete the final project.On December 1, 2019, SoccerBox Inc. started operations. The following transactions occurred during December 2019.

NOTE: There are no beginning balances-this is a new company.Dec 1

Randol Espy invested $80,000 cash in the company for common stock.2

SoccerBox purchased soccer equipment for $20,000 cash.2

SoccerBox rented an old warehouse for $30,000 cash for the first year’s (December 2019-November 2020) rent.3

SoccerBox purchased $500 of office supplies with cash.10

SoccerBox paid $12,000 cash for an annual insurance policy.14

SoccerBox paid $4,000 cash for the first payroll earned by its employees.24

SoccerBox received $85,000 cash from soccer fees paid by parents for a private youth soccer lesson.28

SoccerBox paid $4,000 cash for 2 weeks’ salaries earned by its employees.29

SoccerBox paid $200 cash for minor repairs to its soccer equipment.30

SoccerBox paid $150 cash for this month’s telephone bill.30

Dividends of $1,000 cash were paid by SoccerBox to its current shareholders.

Using this spreadsheet

 and the information above, complete the following:
  1. Record the journal entries that occurred during the month of December.
  2. Prepare an unadjusted trial balance.
  3. Create adjusting journal entries at the end of the year (December 31) based on the following adjustment data:
    1. One month’s insurance coverage has expired (refer to the December 10 entry).
    2. The company occupied the warehouse space for the month of December (refer to the December 2 entry).
    3. At the end of the month, $100 worth of office supplies are still available (refer to the December 3 entry).
    4. This month’s depreciation on the soccer equipment is $250.
    5. Employees earned $300 of unpaid and unrecorded salaries as of month-end.
  4. Prepare an adjusted trial balance.
  5. Prepare an income statement, a statement of retained earnings, and a classified balance sheet as of December 31, 2019.

The following are some tips if you have problems submitting your assignment:

  1. Resave in the proper format per the Assignment Detail instructions, and resubmit.
  2. Submit with a different Web browser.
  3. Submit from a different computer.
  4. Call Technical Support at 877-221-5800, Menu Option 2. They are open 24/7.
  5. If you are still having difficulties after trying steps 1 to 4, please contact your course instructor.