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

Pharmacy written exam sample questions - Threaded 2 - Harriet tubman conductor on the underground railroad - Navyreserve navy mil nrows - Human body temperatures have a mean of - Artifact ideas for school - Factset excel add in - Camel roaming call flow - The overhang beam is subjected to the uniform distributed load having an intensity of - Targeting minorities is a sound business practice - Compare and contrast service and manufacturing operations - Evaluate the Benefits and Cost of Diversity - International journal of sustainable economies management - Malawi versus the world bank - Msf access campaign jobs - Biology unit 3 practice sac - The success of 7 eleven japan pdf - What is pressure at stp - Reflection 7 - Compare and contrast short term and long term memory - Panera bread company case study answers - Solar geometry calculator - Python coding - Case 2 apple's winning marketing strategy - Non Compete - A subsidiary ledger frees the general ledger from details of - Specializes in making a physics lab - Two questions due tomorrow - Bj heating and cooling albury - Leccion 8 recapitulacion - Ap chemistry free response - Pshy - Functionalism crime and deviance - Dunkin donuts financial ratios - Clear to percussion and auscultation - Name and explain two types of prewriting weegy - Molar mass of nitrogen gas - In defense of mind body dualism - Dicussion 4 ( Business Ethics) - Tuck everlasting chapter 11 - A nurse-manager appropriately behaves as an autocrat in which situation? - Fedex case study pdf - Worksheet on transport and communication for grade 4 - Mcgraw hill operations management simulation - Betty parris personality traits - Niche partitioning and species coexistence answers - Ion exchange chromatography questions answer - Health care issues are receiving much attention - 12 angry men 1997 version - Website content planning worksheet - Golden leaf foundation board of directors - The strategy that beanstalk would most likely want to follow is called a ________ strategy. - Ronnie lui optometrist sunnybank - 7 koonunga avenue rostrevor - A1 measurements in cm - Article 37c of ucp 600 - Financial technologies in banking - Letter of warning template - Holyrood secondary school number - Pepsico 10k 2014 - Jealous husband returns in form of parrot character analysis - Muslim Molvi 7340613399 OnLine No 1 FaMOUs VashIKaraN sPecIaLIsT IN Bellary - Hospitality management in perth - Introduction to the practice of statistics moore 9th edition pdf - The conscience of huckleberry finn jonathan bennett summary - Essay on impact of social networking sites on students - Nursing care plan for self mutilation - Bay leather republic armchair - Homeric hymn to demeter - 5 1 midway company performance summary powerpoint - Infj humanmetricswhy is it important to address opposing point of views within your argumentative essay? - Go absent without permission crossword clue - Restaurants near the kitchener aud - Charisma wrinkle shield sheets costco - 1a farnham street parnell - Respond to student post - Merge sort pros and cons - How to write a mixed methods methodology chapter - Ipo cycle diagram of computer - Single channel hypothesis a level pe - Which defense mechanism aids children's resolution of the oedipus and electra complexes? - Clinical centre for interventions - Production of sound is evidence of a chemical change - Number of orders per year formula - Discussion - Dock leveler parts list - 8 week hypertrophy program - Quest on virgin media - Jet ski license qld - October glory maple problems - 132 33 kv substation training report pdf - What shape has the smallest surface area to volume ratio - Circular flow of national income in two sector economy - Difference between aesthetic features and stylistic devices - Access Control - Laws - WK 1, HCS 457: DR 1 - Reaction paper about health - Speech peer review - Assignment 2: New Venture: Launch Plan - Essay mrkt