Question

In: Accounting

Using the data provided, perform the steps below to complete the final project. On December 1,...

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.

I am having issues with these two questions:

  1. Prepare an adjusted trial balance.
  2. Prepare an income statement, a statement of retained earnings, and a classified balance sheet as of December 31, 2019

Solutions

Expert Solution



Related Solutions

Complete the steps below using cell references to given data or previous calculations. In some cases,...
Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference...
Using the data below, perform a two-way ANOVA. Test the hypothesis of interaction at the 1%...
Using the data below, perform a two-way ANOVA. Test the hypothesis of interaction at the 1% level of significance. Also, use a 1% level of significance to test the null hypotheses of equal column and equal row means. Factor Level 1 Level 2 Level A 14 16 18 12 16 16 Level B 10 12 16 12 12 14
Final Project Data On December 1, 2015 John Trap created a new travel agency, Trap Adventures,...
Final Project Data On December 1, 2015 John Trap created a new travel agency, Trap Adventures, Inc. providing exclusive adventure trips. The following transactions occurred during December 2015. (NOTE: There are no beginning balances – this is a new company.) Dec 1 John Trap invested $60,000 cash in the company for common stock. 2 Purchase office equipment for $17,500 cash. 2 The company rented furnished office space by paying $18,000 cash for the first six months (December 2015 - May...
Part 3: Risk analysis and project evaluation 3.1 Perform a scenario analysis on the data provided...
Part 3: Risk analysis and project evaluation 3.1 Perform a scenario analysis on the data provided Case Study: Assume that the company, where you are working as a team in Financial Department, is considering a potential project with a new product that is expected to sell for an average price of $22 per unit and the company expects it can sell 650 000 unit per year at this price for a period of 4 years. Launching this project will require...
Using R and the data in the table below, perform the regression of D on C...
Using R and the data in the table below, perform the regression of D on C (i.e., report the regression equation). C D 3 2 6 7 8 5 9 4 1 0 3 4 Hint: The code to enter the vectors C and D into R is: C <- c(3, 6, 8, 9, 1, 3) D <- c(2, 7, 5, 4, 0, 4) You must figure out how to obtain the regression equation from R. Enter the code below...
Using the data provided in the ‘Data Task B’ worksheet, complete the flexible budget for T&K...
Using the data provided in the ‘Data Task B’ worksheet, complete the flexible budget for T&K Solutions and calculate flexible budget variances using the proforma in ‘Schedule 2’. For each variance, indicate if it is U (unfavourable), F (favourable) 2018 BUDGETED DATA Taxation Bookkeeping Advisory Total Billable hours 4400 1200 5200 10800 Professional labour hours 4600 1320 5720 11640 Charge out rate per billable hour $                     210.00 $                     180.00 $                     210.00   Professional labour per worked hour $                      90.00 $                      75.00...
Using the information provided in the table below, find the probability of completing the project in...
Using the information provided in the table below, find the probability of completing the project in 46 weeks? Activity Immediate Predecessor(s) Optimistic Time Estimate (weeks) Most Likely Time Estimates (weeks) Pessimistic Time Estimates (weeks) A none 3 6 9 B A 3 5 7 C A 4 7 12 D B, C 4 8 10 E B, C 9 12 18 F D 5 10 13 G E 3 6 8 H F 1 5 12 I G 7 8...
What are the 8 steps in the “process of development of a project”? HINT: the final...
What are the 8 steps in the “process of development of a project”? HINT: the final one is “Operation”.
Multivariate analysis Using the data provided, perform the following analysis: Determine the explanatory and response variables....
Multivariate analysis Using the data provided, perform the following analysis: Determine the explanatory and response variables. Run a multivariate regression analysis on all three variables. Interpret the results by answering the following questions: What is the calculated correlation coefficient? Do the sales figures correlate with the marketing expenditure and price? Comment on the coefficient of determination. What percentage of the response data can be explained by the explanatory variables? Determine the multiple regression line equation in the form: sales^ =...
Complete the pension worksheet using the information provided below: Items Balance, Jan. 1, 2020 Annual Pension...
Complete the pension worksheet using the information provided below: Items Balance, Jan. 1, 2020 Annual Pension Expense Cash OCI - Prior Service Cost OCI- Gains/ Losses Pension Asset/ Liability Projected Benefit Obligation Plan Assets Service cost Interest cost Actual return Unexpected gain/loss Amortization of PSC Contributions Benefits Journal entry for 2020 2020 records of Lexxus Company provided the following data related to its noncontributory defined benefit pension plan. ACCOUNT BALANCES (‘000s)    Jan. 1, 2020                Activity (‘000s)                                              2020 Projected Benefit Obligation...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT