STEP 1 Using the following historical actions, complete a horizontal worksheet of accounting events in the Excel spreadsheet file provided:

2014 Events

1) Received $86,000 cash from issuing common stock to investors

2) Purchased $2,500 supplies on account

3) Paid $20,000 cash for 12 months of rent beginning March 1

4) Paid $700 cash for a portion of the supplies amount due in accounts payable

5) Received $30,000 for two future unearned corporate events

6) Sold $14,000 of arcade wristbands to themed events for cash revenue

7) Paid cash for $6,500 of arcade technician salaries expense

8) Recognized expense through December 31 for the rent prepaid in transaction #3 above

9) Determined that $700 of supplies remained on hand as of December 31 and recognized the rest as expense

10) Recognized $10,000 of revenue earned through December 31 for the corporate event under the contract detailed in transaction #5 above

2015 Events

11) Expensed all rent remaining on the prepaid lease from #3

12) Paid $30,000 cash for 24 months of rent beginning March 1

13) Sold $27,000 of arcade wristbands at the summer arcade expo with 55% purchased on account

14) Determined that the amount of revenue remaining uncollected at the end of the year was $18,000 and realized the cash receipts

15) Recognized the remaining revenue earned under the corporate event contract signed in #5

16) Paid cash to purchase $3,500 of game supplies

17) Reviewed the total supplies to determine that $800 remained on December 31 and recognized the rest as expense

18) Paid cash for $9,000 of arcade technician salaries expense

19) Hired new special events manager for $2,750 per month salary to start on January 1 next year

20) Recognized the expense through December 31 for the rent prepaid in transaction #12 above

2016 Events

21) Recognized the full current year expense for the rent prepaid in transaction #12 last year

22) Paid cash salaries to the new special events manager hired in #19 above for one year and another $6,100 total for the year to an additional arcade technician

23) Received $55,000 cash from new bank loan

24) Paid remaining amount payable for the supplies previously purchased on account

25) Sold $50,000 of arcade annual passes with 90% purchased on account

26) Determined that the amount of revenue remaining uncollected at the end of the year was $16,500 and realized the cash receipts

27) Purchased new storage building for $27,000 cash

28) Recognized one year of depreciation for the building from #27 based on a 15-year useful life

29) Determined that $500 of supplies remained on December 31 and recognized the rest as expense

30) Paid cash for $25,000 of new advertising

STEP 2 Using the horizontal worksheet results, next build the Income Statement, Statements of Changes in Stockholders Equity, Balance Sheet, and Statements of Cash Flows for all three years.

Assume there are no taxes and all transactions are in cash unless specified. Complete the above in Excel by placing each entry in the appropriate cell.