Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Create t accounts in excel

20/10/2021 Client: muhammad11 Deadline: 2 Day

Accounting Excel Assignment

Instructions
ACTG 381
Pre-requisite Knowledge Assessment
Spring 2020
Purpose of the Assessment: This take home assessment has been designed as a review of the pre-requisite accounting knowledge necessary to be successful in ACTG 381. This assessment focuses on recording basic accounting transactions/journal entries, understanding T accounts, and creating a set of financial statements. It is also intended as an opportunity to practice using basic Excel functions. The accounting issues included in this assessment are assumed to have been covered in your prerequisite financial accounting course. If you need a reference, you could refer to the textbook from your pre-requisite accounting course, WileyPlus Chapter 0 Reading Assignment and Problems, or Chapter 3 in the textbook for this class. Students who are unable to successfully complete this assessment should consider taking ACTG 281 prior to ACTG 381.
Possible Points: 25 points; 20 for accounting accuracy and 5 for appropriate Excel technique (i.e., internal referencing among spreadsheets, auto-sum, dr/cr control total, formatting).
Due Date: Your Excel file should be turned in to the D2L Assignments by 10pm on Friday April 3rd. Late assignments will receive a score of zero as the solution will be posted on D2L the next day. If you are unfamiliar with D2L, please refer to http://www.pdx.edu/oit/d2l
Background: Green Thumb Corporation was founded in 2014 by Erica Green. The company provides plant maintenance services to businesses such as medical offices, professional services firms and corporations. In the last couple of years the business has really taken off as decor trends shifted to real rather than artificial plants, and individuals wanted the health benefits of plants in enclosed buildings. Green Thumb has part time employees, mostly college students, who go into the buildings to water, fertilize and replace plants as necessary. To date Erica has been doing all the accounting for the company, but since she really prefers working with plants to computers, she hired you as an accounting intern in December 2019 to assist with the month's accounting, close the books and produce the year-end accrual basis financial statements that conform to GAAP.
Required:
Erica has just provided you with the trial balance at 11/30/19. Assume this trial balance has been correctly prepared. Use the balances in the 11/30/19 Trial Balance tab as your beginning balances for all T-Accounts. Green Thumb's year end is December 31st.
(A) Using the Excel General Journal spreadsheet in this file, record the December transactions listed below AND the necessary year end adjusting journal entries. Label the transactions in numeric sequence corresponding to the numbers below. Each of the transactions below requires a journal entry. Note that there is a debit and credit control total at the top of the general journal so that you can check after each entry to see if you are in balance.
1. Issued an additional 50,000 shares of common stock on December 2. The stock was sold to Erica's parents for $100,000, which equals the par value of the stock.
2. Received cash payment of $14,000 for outstanding accounts receivable on December 3.
3. Purchased a new truck for $26,000 cash on December 3.
4. Provided services for cash of $12,000 on December 3.
5. Provided services on credit for $16,000 on December 10.
6. Received bill and paid utilities of $900 on December 11.
7. Paid employee salaries of $8,700 on December 11.
8. Declared and paid dividends to stockholders of $500 on December 11.
9. Incurred legal fees of $2,000 on December 13, but did not pay for these services.
10. Collected $14,000 from customers on December 15.
11. Collected $3000 on December 15th for plant maintenance services to be provided 12/15/19 to 1/15/20.
12. Sold land with cost of $100,000 for $106,000 cash on December 15.
13. Paid $18,000 for a three-year insurance policy on December 15 with coverage beginning on 12/15/19
14. Paid $1,000 on December 20 related to legal legal fees incurred on December 13.
15. Paid $900 for miscelaneous supplies on December 20. Supplies are expensed upon purchase.
Erica also provided you the following information that she thought may be helpful in preparing the year-end financial statements.
16. As of December 31, Green Thumb has not recorded any insurance expense for the new policy purchased in #13 above.
17. Green Thumb depreciates its equipment at a rate of $7,000 per year. No depreciation expense has been recorded yet for 2019.
18. For the service revenue collected on December 15th (#11 above), record the appropriate amount of revenue for 2019.
19. Erica let you know that she provided $2,900 of services to a customer in December that had not yet been billed.
20. Green Thumb has incurred salaries of $3,000 at the end of the year. The next payroll date is 1/2/20. (Ignore payroll taxes and withholdings)
Note: Do not prepare the closing journal entries at this point! Closing journal entries should be prepared as part of step C below.
(B) "Post" journal entries 1-20 from the General Journal to the Excel spreadsheet of T-accounts in this file. All necessary T-accounts have been provided. This should be completed through the use of Excel formulas rather than retyping the numbers in your T-accounts. Please also place the number of each transaction next to each journal entry (see transaction ‘1’ in the Excel T-Account sheet for an example) and be sure to create formulas so that each T accounts automatically calculates its ending balance (see the Cash t-account for an example). TIP: Set up your spreadsheet to have debit and credit control totals so that you can check after each entry to see if you are in balance.
(C) In Excel, prepare a balance sheet as of 12/31/19 and a SINGLE-STEP income statement for the year ended 12/31/19. This should be completed through the use of Excel referencing formulas rather than retyping the ending balances from your T-accounts in the financial statements. (Note that at this point your balance sheet will be out of balance because Retained Earnings hasn't yet been updated!) After you have prepared your balance sheet and income statement, prepare closing entries in the General Journal but do not post them to the T accounts so that the pre-closing ending balances continue to flow to the Income Statement using the Excel referencing formulas. Then the final Net Income amount from your Income Statement should be referenced using Excel formulas to the Statement of Retained Earnings. Once reconciled, your ending Retained Earnings balance should be referenced using Excel formulas back to your 12/31/19 Balance Sheet. You do NOT need to prepare a Statement of Shareholders’ Equity or Statement of Cash Flows. Income taxes should be ignored.
Trial Balance 11-30-19
Unadjusted Trial Balance
General Ledger Account Name 11/30/19
Debit Credit
Cash 37,000
Accounts Receivable 24,500
Prepaid Insurance 0
Equipment 88,000
Accum Depreciation
Land 100,000
Accounts Payable 4,500
Unearned Service Revenue 0
Salaries Payable 0
Long Term Notes Payable 16,000
Common Stock 60,000
Retained Earnings 97,200
Dividends
Service Revenue 165,000
Gain on Sale of Land
Depreciation Expense
Insurance Expense 4,500
Legal Fees Expense
Supplies Expense 1,400
Salaries Expense 82,000
Utilities Expense 5,300
Total 342,700 342,700 0.00 Control totals
Note: All the accounts in this trial balance
will be used. No additional accounts are needed.
GeneralJournal
Green Thumb Corporation
General Journal
100,000 100,000 (Control totals)
# Date Transaction Debit Credit
1 12/2/19 Cash 100,000
Common Stock 100,000
To record issuance of common stock.
T-Accounts
Green Thumb Corporation NAME:
Cash Accounts Receivable Prepaid Insurance
beg 37,000
1 100,000
end 137,000
Equipment Accum Depreciation Land
Accounts Payable Unearned Services Rev Salaries Payable
Long Term Notes Payable Common Stock Retained Earnings
60,000 beg
100,000 1
160,000 end
Dividends Service Revenue Gain on Sale of Land
Salaries Expense Legal Fees Expense Rental Expense
Insurance Expense Depreciation Expense Utilities Expense
Income Stmt
Student Name:
Section:
Revenues
Service Revenue 0.00
Total Revenues 0.00
Expenses
Total Expenses 0.00
Check Figure
Net Income $ 87,450
Balance Sheet
Student Name:
Section:
Assets
Cash 137,000.00
Total Current Assets
Total Assets
Liabilities and Stockholders' Equity
Liabilities
Total Current Liabilities
Total Liabilities
Stockholders' Equity
Common Stock
Retained Earnings 0.00
Total Stockholders' Equity
Total Liabilities and Stockholders' Equity
Check Figure Total Assets $ 370,150
Stmt Retained Earnings
Student Name:
Section:
Green Thumb Corporation
Statement of Retained Earnings
For the year ended 12/31/19
Beginning Retained Earnings $ - 0
Net Income - 0
Less: Dividends - 0
Ending Retained Earnings $ - 0
Note: Per instruction C, to calculate Ending Retained Earnings you should
use Excel formulas to pull values in from the appropriate T accounts.
Ending Retained Earnings calculated here should flow into the 12/31
Balance Sheet.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Academic Guru
Academic Master
Exam Attempter
Fatimah Syeda
Assignment Solver
Math Exam Success
Writer Writer Name Offer Chat
Top Academic Guru

ONLINE

Top Academic Guru

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$15 Chat With Writer
Academic Master

ONLINE

Academic Master

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$36 Chat With Writer
Exam Attempter

ONLINE

Exam Attempter

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$26 Chat With Writer
Fatimah Syeda

ONLINE

Fatimah Syeda

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$15 Chat With Writer
Assignment Solver

ONLINE

Assignment Solver

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$18 Chat With Writer
Math Exam Success

ONLINE

Math Exam Success

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$16 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Professional capstone and practicum reflective journal - Moodle coleg y cymoedd - Penetration test proposal deliverable 1 rules of engagement - The curious researcher online free - What is character construction - In economic downturns, forecasters may witness rising sales in which of the following industries? - Fundamental concepts of organizational behavior ppt - National aged care alliance - Dr jekyll and mr hyde setting chapter 1 - Round orange pill 10 dan 5554 - Panchromatic in a sentence - Charting examples for physical assessment - Teenage wasteland anne tyler - Case Scenario - Andrew balding stable tour - Doing ethics 5th edition pdf - 50-100 Word Discussion Reply 2 - Ipip neo short form - Comparitive economics - 3.4 Week Three Reflection - Www kidsastronomy com solar system htm - Of mice and men gcse essay - The farm angola usa summary - My saint leo university - Discussion- Finance- 1 page – APA Format - Mgt - Www science teachers com earth htm answers - How to make a mousetrap car with cds - Boston va research institute - Community health and population focused nursing c228 - Abou el sid menu arabic - Excel capstone project 1 - Match these values of r with the accompanying scatterplots - For this assignment, you will read the article posted on eConestoga - Art discussion questions - 1984 war is peace ignorance is strength - Calamine oily lotion apf - Programming - Advertising 8 - Emotion coaching handout for parents - The lovesong of j alfred prufrock cliff notes - Configure global catalog server 2012 - Peer response - Angove heavyweight shiraz 2015 - Oracle noaudit logon logoff - Dq response - BUSM3199 Ethics and Governance RMIT - Risk Manager in the Healthcare Setting Week 5 Discussion - Cognitive behavioral family therapy treatment plan - What are the key considerations when printing a graphic novel? - Southwest airlines swot analysis - Sistema tegumentario - African tuned percussion instruments - Transaction Processing Systems, Customer Relationship Management System and Supply Chain Management - Calculate gdp as the value added in production pizzania - 10 pp slide usa correctional facilities - Attention getter for sleep deprivation - National Parks - Cravat sales company master budget solution - Dichotomous key to the animal kingdom answers - How to create a hexagon in a circle - 5000 invested for 10 years at 10 percent compounded annually - Mt albert postcode nz - Preliminary investigation report sample - Foreign exchange market quiz - Pros and cons of arming probation officers - The phenotypic classes of offspring representing double crossovers: - Which is more precise a beaker or a buret - Humanistic, Transpersonal and Existential Psychology - Sociology final exam multiple choice - The saunders investment bank has the following financing outstanding. - California climograph - Data flow diagram symbols and rules - Sss e1 form online print out - The nanjing 1.19 dismemberment case - A bag contains chips of which 27.5 percent are blue - HELP NEED HELP - Homework assighment on Is 100 - A cylindrical specimen of stainless steel - Chapter 7 constructing bar graphs data analysis practice answers - C11 Lesson 6 & 7 Exam SCORE 92.5 PERCENT - Pre u physics past papers - Wray common term dates - Peterborough regional college jobs - Bashundhara group share price - Develop and maintain networks and collaborative partnerships - Information system of coca cola company - Old testament character sketch - International social work day - Present perfect subjunctive sentences - Achieving a cost advantage over rivals entails - Week 4 - Diverse range of entrepreneurial ventures - Nichols and Gehart& Tutttle - Australian institute of embalmers - Are you interested in learning how brochure designers affect advertising campaigns? - Simpson taxonomy of psychomotor domain - Tip of nose twitching superstition - Abercrombie and fitch wiki - Freshwater east beach parking