Question
John Trap invested $60,000 cash in the company for common stock.2Purchase office equipment for $17,500 cash.2The company rented furnished office space by paying $18,000 cash
John Trap invested $60,000 cash in the company for common stock.2Purchase office equipment for $17,500 cash.2The company rented furnished office space by paying $18,000 cash for the first six months (December 2015 - May 2016) rent.3The company purchased $1,500 of office supplies on account.10The company paid $3,600 cash for the premium on a 12-month insurance policy.14The company paid $10,750 cash for two weeks' salaries earned by employees.24The company collected $54,000 cash on commissions from airlines on tickets obtained for customers.28The company paid $12,125 cash for two weeks' salaries earned by employees.29The company paid $350 cash for minor repairs to the company's computer.30The company paid $450 cash for this month's telephone bill.30Dividends of $3,000 cash were paid.
Final Project Requirements
Using the spreadsheet found here and information above, complete the following:
Adjustment Data:
- One month's insurance coverage has expired.
- The company occupied the office space for the month of December.
- At the end of the month, $600 of office supplies are still available.
- Create journal entries to record the transactions that occurred during the month of December. (Completed in Unit 3)
- Prepare an unadjusted trial balance (Completed in Unit 3)
- Create adjusting journal entries at the end of the year, December 31 based on the adjustment data.
- Prepare an adjusted trial balance.
- Prepare an income statement, statement of stockholders' equity, and classified balance sheet.
- Create closing journal entries to close all temporary accounts.
- Prepare post-closing trial balance.
- In addition, answer TWO of the questions below in 1-2 fully developed paragraphs on the last tab of the Excel spreadsheet you downloaded.A fully developed paragraph should have a major point with 3 to 5 support sentences.One or two sentences is not acceptable or does not discuss the question.Be sure to show what you know!!!
- Trap Adventures, Inc. is looking for an accountant.In your own words, explain to Trap's hiring team the role of accountant and accounting within business.Provide examples of the expectations of the accountant.
- Discuss the financial position of Trap Adventures, Inc. using the following ratios:
- Current ratio
- Return on equity: For each ratio, provide the calculation and an explanation of the meaning.Is this a positive or negative result for the Trap Adventures, Inc.?
- Using Trap Adventures, Inc.'s income statement, evaluate the operations for the month of December.Complete a common-size income statement using sales as the base number.What is the largest percentage?What is the smallest percentage?What recommendations could be made to increase Trap's net income?
- Currently, Trap Adventures, Inc. does not own any loans or bank notes (long-term liabilities).What would happen if Trap decides to obtain a bank loan for $25,000 to fund daily operations?How would this transaction impact the financial statements - which accounts would be affected?What is the debt to equity ratio?What does the debt to equity ratio represent
If you are planning to repurpose an assignment or submit one you have used before, please let your instructor know. If an instructor is not made aware of work being repurposed or reused, he or she will treat the assignment as a plagiarized task and reserves the right to post an F grade and submit a task for review to administration until proof of originality is provided.Click here for more information.
The following are some tips if you have problems submitting your assignment:
- Resave in the proper format per the Assignment Detail instructions, and resubmit.
- Submit with a different Web browser.
- Submit from a different computer.
- Call Technical Support at 877-221-5800, Menu Option 2. They are open 24/7.
- If you are still having difficulties after trying steps 1-4, please contact your course instructor.
Make sure you submit this assignment by the listed due date. Late deductions will apply for this assignment as follows:
- Assignments submitted within 7 calendar days after the stated due date: 10% penalty of total assignment points.
- Assignments submitted 8-14 calendar days after the stated due date: 20% penalty of total assignment points.
- Assignments submitted 15-21 calendar days after the stated due date: 30% penalty of total assignment points.
- Assignments submitted 22-28 calendar days after the stated due date: 40% penalty of total assignment points.
- No assignments, including late assignments, will be accepted after the end of the course unless an approved Incomplete has been granted.
Your assignment will be graded in accordance with the following criteria.Click here to view the grading rubric.
please answer
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started