This project is presented in three-parts that assesses your knowledge of financial accounting and the accounting...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
This project is presented in three-parts that assesses your knowledge of financial accounting and the accounting cycle. In the first part, you are required to prepare joumal entries, T-accounts and a trial balance for a variety of transactions for a new company. In part 2, you are asked to analyze certain transactions, prepare adjusting entries post to T-accounts and prepare an adjusted trial balance. In the third part of the project you will prepare closing journal entries, post to T-accounts, prepare an income statement and balance sheet and prepare a post- closing trial balance. Everything flows from the first part of the assignment through the end of the assignment BACKGROUND After graduating, you have decided to open your own business as a corporation. The project is a company called ABC, Inc. Since you have taken a financial accounting class as part of your undergraduate degree, you have decided to save the money do your own accounting work. This includes understanding that all transactions are recorded properly in appropriate journals, T-Accounts and trial balances and prepare the the financial statements. To accomplish these goals, you must have a full understanding of the accounting cycle. REQUIREMENTS 1. Create necessary Excel spreadsheets to complete this work. Handwritten journals, T-accounts, or trial balance will not be accepted nor will any other file format. You will be assigned a unique ID number that will be used throughout this project. Several of the transactions will require you to multiply your ID Number by a specific amount. This is how each project will have unique results. When using Excel, formulas must be used when possible and numbers should not be hardcoded. For instance, the transaction occurring on June 1 is ID X 500. Do not just solve this using your calculator and type in the answer in Excel, you must have a formula such as-500 x ID There should be only formulas on the T-accounts and trial balance. 2. All dollar figures should be rounded to the nearest dollar with no decimals included. Make sure that your submission is formatted with dollar signs and commas and that no decinals are given This project is presented in three-parts that assesses your knowledge of financial accounting and the accounting cycle. In the first part, you are required to prepare joumal entries, T-accounts and a trial balance for a variety of transactions for a new company. In part 2, you are asked to analyze certain transactions, prepare adjusting entries post to T-accounts and prepare an adjusted trial balance. In the third part of the project you will prepare closing journal entries, post to T-accounts, prepare an income statement and balance sheet and prepare a post- closing trial balance. Everything flows from the first part of the assignment through the end of the assignment BACKGROUND After graduating, you have decided to open your own business as a corporation. The project is a company called ABC, Inc. Since you have taken a financial accounting class as part of your undergraduate degree, you have decided to save the money do your own accounting work. This includes understanding that all transactions are recorded properly in appropriate journals, T-Accounts and trial balances and prepare the the financial statements. To accomplish these goals, you must have a full understanding of the accounting cycle. REQUIREMENTS 1. Create necessary Excel spreadsheets to complete this work. Handwritten journals, T-accounts, or trial balance will not be accepted nor will any other file format. You will be assigned a unique ID number that will be used throughout this project. Several of the transactions will require you to multiply your ID Number by a specific amount. This is how each project will have unique results. When using Excel, formulas must be used when possible and numbers should not be hardcoded. For instance, the transaction occurring on June 1 is ID X 500. Do not just solve this using your calculator and type in the answer in Excel, you must have a formula such as-500 x ID There should be only formulas on the T-accounts and trial balance. 2. All dollar figures should be rounded to the nearest dollar with no decimals included. Make sure that your submission is formatted with dollar signs and commas and that no decinals are given
Expert Answer:
Answer rating: 100% (QA)
To complete the project requirements for ABC Inc you will need to create Excel spreadsheets for jour... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
For the Kelvin state as considered in Example 15.4, explicitly justify the displacement and stress results given in relations (15.2.8) and (15.2.10). Data from example 15.4 Equation 15.2.8 Equation...
-
On January 1, 2011, Nover Solar Systems purchased 10,000 shares of Reilly Manufacturing for $190,000. The investment represented 25 percent of Reillys outstanding common stock. Nover intended to hold...
-
A blunt-nosed aerodynamic model is mounted in the test section of a supersonic wind tunnel. If the tunnel reservoir pressure and temperature are \(10 \mathrm{~atm}\) and \(800^{\circ} \mathrm{R}\),...
-
Milo's Market operates four departments. Management is concerned about the financial results of the dried goods department, which has shown a loss for the past 3 years according to the companys...
-
Portions of the financial statements for Parnell Company are provided below. Required: 1. Prepare the cash flows from operating activities section of the statement of cash flows for Parnell Company...
-
Evaluate the thermodynamic properties and behavior of complex fluids, such as liquid crystals, surfactant solutions, and polymeric materials, in terms of phase transitions, self-assembly phenomena,...
-
A B E F 1 Better Bottles, Inc., uses a periodic inventory system and has the following information available: 2 Cost per Unit 20 $ 3 Description 4 Beginning Inventory 5 Jan. 15 Purchase 6 Jan. 20...
-
Your cars 40.0-W headlight and 2.70-kW starter are ordinarily connected in parallel in a 12.0-V system. What power would one headlight and the starter consume if connected in series to a 12.0-V...
-
Many companies have determined that their biggest asset is their employees, so taking care of employees is a mission-critical objective. Research companies that use benefits packages as a way to make...
-
DSSs are used most often by a. managers who make decisions based on current data. b. employees who decide how to solve technical problems. c. clerical staff who organize and format documents and...
-
Following information is given below : calculate the closing capital Creditors Bills payable Loan Bills receivable Stock Cash Jan. 01, 2005 Rs. 5,000 10,000 30,000 5,000 2,000 Dec. 31, 2005 Rs....
-
Businesses have experienced several major data breaches in the last few years. How do you see these lapses in corporate security affecting consumers? Does it make you less likely to purchase from...
-
Examine the PBS Frontline episode Generation Like at www.pbs.org. Are young people and their social media sites being exploited by marketing professionals? Or is this generation especially skilled in...
-
If revenue from a sale was $4,800 and variable costs were $2,304, what is the variable cost percentage? (1 points) E8.1 A restaurant has sales revenue of $240,000, fixed costs of $100,800, and...
-
Propose a reasonable mechanism for the following reaction. OH
-
Carl and Jenny adopt a Russian orphan. The adoption takes 2 years and two trips to Russia and is final in 2012. They pay $6,000 in 2011 and $7,500 in 2012 of qualified adoption expenses, and have AGI...
-
Van makes an investment in a partnership in 2012. Van's capital contributions to the partnership consisted of $30,000 cash and a building with an adjusted basis of$70,000, subject to a nonrecourse...
-
In 2012, Gale and Cathy Alexander hosted an exchange student, Axel Muller, for 9 months. Axel was part of International Student Exchange Programs (a qualified organization). Axel attended tenth grade...
-
You are setting up a chatbot agency to service marketing, sales and customer services teams. Discuss the advantages and disadvantages of setting up the business as a sole trader or company and the...
-
Principles for Responsible Management Education (PRME) is a not-for-profit entity. It engages business schools to ensure they provide future leaders with the skills needed to balance economic and...
-
Entities are expected to perform in environmental, governance and social areas as well as profit (unless a not-for-profit entity). List some key performance indicators applicable to each sphere.
Study smarter with the SolutionInn App