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

Perform an incremental analysis of the two finalist projects using the data provided below. The company...
Perform an incremental analysis of the two finalist projects using the data provided below. The company uses a MARR of 10% and depreciates its assets using 7-year MACRS. The company’s effective income tax rate is 25%. Project 1: Milling machines Equipment cost: Two (2) machines that each cost $380,000 including trade-in allowance and sales tax. The total cost of the freight and handling is expected to be $25,000. The total cost to install the machines is $30,000. Total testing and...
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
Using the steps in Benchmarking (see below), perform an internal and competitive benchmarking of section/department and...
Using the steps in Benchmarking (see below), perform an internal and competitive benchmarking of section/department and Company. The 10 Steps of Benchmarking 1. Determine processes to be benchmarked. 2. Determine organizations to be benchmarked. 3. Gather data. 4. Locate deficiencies. 5. Determine future trends. 6. Reveal results and sell the process. 7. Achieve consensus on revised goals. 8. Establish procedures. 9. Implement procedures and monitor results. 10. Recalibrate benchmarks.
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...
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^ =...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT