Chat with us, powered by LiveChat Spreadsheet Need | Writedemy

Spreadsheet Need

Spreadsheet Need

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.
  1. Create journal entries to record the transactions that occurred during the month of December. (Completed in Unit 3)
  2. Prepare an unadjusted trial balance (Completed in Unit 3)
  3. Create adjusting journal entries at the end of the year, December 31 based on the adjustment data.
  4. Prepare an adjusted trial balance.
  5. Prepare an income statement, statement of stockholders’ equity, and classified balance sheet.
  6. Create closing journal entries to close all temporary accounts.
  7. Prepare post-closing trial balance.
  8. In addition, answer TWO of the questions below in 1-2 fully developed paragraphs.  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!!!
    1. 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.
    2. Discuss the financial position of Trap Adventures, Inc. using the following ratios:
      1. Current ratio
      2. 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.?
    3. 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?
    4. 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

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

About Writedemy

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order