Each of the following should be presented as a separate page (or worksheet) in the Excel...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Each of the following should be presented as a separate "page" (or worksheet) in the Excel workbook. • A cover page. The cover page should be the first sheet of your project. It should include your name, the name of your company (if different), and the name of the other members of your group. Also list on this page the amount of cash on hand when you ended the game as well as the place your token ended on. (It is not necessary to include the name of the other members of your group if you are playing individually per my instructions). • The general journal (example provided in Illustration 3-7 of the text). You should record your transactions as you play the game. Make sure that you have recorded journal entries in the proper format - including a description of the transaction and the date (turn). • The general ledger (example provided in Illustration 3-8). Set up the general ledger using the chart of accounts I've provided. Post all transactions to the general ledger. An unadjusted trial balance (example provided in Illustration 3-20). Year-end adjusting entries. . An adjusted trial balance (example provided in Illustration 3-35). • Year-end financial statements including a multi-step income statement (Illustration 4-2), and a classified balance sheet (Illustration 5-16) and a Statement of Retained Earnings (Illustration 3-36). (See note under Project Format.) Closing entries. (Please use the Income Summary method of closing accounts, Illustration 3-38) A post-closing trial balance (example, Illustration 3-40). Reversing entries, where appropriate (Chapter 3, Appendix 3B). . . . Please do not use a worksheet format. Instead, present the trial balances and adjusting entries on individual sheets. The sheets must be in order of the accounting cycle. All journal entries should be dated by turn. One of the main purposes of this project is to show me that you understand the accounting processing cycle. Therefore, make sure everything is in proper order. Additionally, beginning with the unadjusted trial balance, each sheet should be connected by a formula—again illustrating your knowledge of the accounting processing cycle as well as your understanding of the relationships between the data. Please use formulas on each individual sheet as well; for example, to calculated subtotals on the income statement and balance sheet. TURN 1 Pentonville Road $120 TURN 2 free space TURN 3 Marylebone Station $200 TURN 4 Leicester Square $260 TURN 5 Liverpool St Station $200 TURN 6 Salary Revenue passing go $200 Old Kent Road $60 TURN 7 pay The angel, islington $6 TURN 8 pass TURN 9 Strand $220 TURN 10 pass TURN 11 receive rent $22 Leicester Square TURN 12 Park Lane $350 TURN 13 passing go Salary Revenue $200 TURN 14 chance card, passing go Salary Revenue $200 Kings Cross Station $200 TURN 15 free space TURN 16 recive $8 Pentonville Road Income tax refund $20 TURN 17 Fleet Street $220 TURN 18 pay $26 rent Regent street TURN 19 Chance card collect go $200 Salary Revenue pay $6 euston road TURN 20 Electric Company $140 TURN 21 Bow Street $180 TURN 22 pay $20 trafalgar sqaure TURN 23 Recive $8 Pentonville Road TURN 24 pay 26 regent street TURN 25 recive $14 Bow Street TURN26 Pay $100 tax Ending balance $38 CASH Each of the following should be presented as a separate "page" (or worksheet) in the Excel workbook. • A cover page. The cover page should be the first sheet of your project. It should include your name, the name of your company (if different), and the name of the other members of your group. Also list on this page the amount of cash on hand when you ended the game as well as the place your token ended on. (It is not necessary to include the name of the other members of your group if you are playing individually per my instructions). • The general journal (example provided in Illustration 3-7 of the text). You should record your transactions as you play the game. Make sure that you have recorded journal entries in the proper format - including a description of the transaction and the date (turn). • The general ledger (example provided in Illustration 3-8). Set up the general ledger using the chart of accounts I've provided. Post all transactions to the general ledger. An unadjusted trial balance (example provided in Illustration 3-20). Year-end adjusting entries. . An adjusted trial balance (example provided in Illustration 3-35). • Year-end financial statements including a multi-step income statement (Illustration 4-2), and a classified balance sheet (Illustration 5-16) and a Statement of Retained Earnings (Illustration 3-36). (See note under Project Format.) Closing entries. (Please use the Income Summary method of closing accounts, Illustration 3-38) A post-closing trial balance (example, Illustration 3-40). Reversing entries, where appropriate (Chapter 3, Appendix 3B). . . . Please do not use a worksheet format. Instead, present the trial balances and adjusting entries on individual sheets. The sheets must be in order of the accounting cycle. All journal entries should be dated by turn. One of the main purposes of this project is to show me that you understand the accounting processing cycle. Therefore, make sure everything is in proper order. Additionally, beginning with the unadjusted trial balance, each sheet should be connected by a formula—again illustrating your knowledge of the accounting processing cycle as well as your understanding of the relationships between the data. Please use formulas on each individual sheet as well; for example, to calculated subtotals on the income statement and balance sheet. TURN 1 Pentonville Road $120 TURN 2 free space TURN 3 Marylebone Station $200 TURN 4 Leicester Square $260 TURN 5 Liverpool St Station $200 TURN 6 Salary Revenue passing go $200 Old Kent Road $60 TURN 7 pay The angel, islington $6 TURN 8 pass TURN 9 Strand $220 TURN 10 pass TURN 11 receive rent $22 Leicester Square TURN 12 Park Lane $350 TURN 13 passing go Salary Revenue $200 TURN 14 chance card, passing go Salary Revenue $200 Kings Cross Station $200 TURN 15 free space TURN 16 recive $8 Pentonville Road Income tax refund $20 TURN 17 Fleet Street $220 TURN 18 pay $26 rent Regent street TURN 19 Chance card collect go $200 Salary Revenue pay $6 euston road TURN 20 Electric Company $140 TURN 21 Bow Street $180 TURN 22 pay $20 trafalgar sqaure TURN 23 Recive $8 Pentonville Road TURN 24 pay 26 regent street TURN 25 recive $14 Bow Street TURN26 Pay $100 tax Ending balance $38 CASH
Expert Answer:
Answer rating: 100% (QA)
Cover Page Name Company Name if different Group Members Cash on Hand when Ended Token Ended On General Journal The general journal is a record of all transactions that occur during the game Each journ... View the full answer
Related Book For
Advanced Accounting
ISBN: 978-0538480284
11th edition
Authors: Paul M. Fischer, William J. Tayler, Rita H. Cheng
Posted Date:
Students also viewed these accounting questions
-
Set up general ledger accounts using the chart of accounts provided in Exercise 4-4B. Post the transactions from Exercise 4-4B to the general ledger accounts and prepare a trial balance.
-
Set up general ledger accounts using the chart of accounts provided in Exercise 4-4A. Post the transactions from Exercise 4-4A to the general ledger accounts and prepare a trial balance.
-
Name the instrument that best fits each of the following descriptions: a. Short-term unsecured loan issued directly by the company. b. An agreement by a government bond dealer to buy back a bond that...
-
The Commerce Department reported that in December 2015, retail sales rose by 0.2, net exports decreased, inventories held by businesses rose by 0.1 percent, and total sales by businesses fell by 0.6...
-
Use the Nonlinear Shooting method with TOL = 104 to approximate the solution to the following boundary-value problems. The actual solution is given for comparison to your results. a. y" = e2y, 1 x ...
-
Maria & Co. expects its EBIT to be $80,000 every year forever. The firm can borrow at 14 percent. Maria currently has no debt, and its cost of equity is 25 percent. If the tax rate is 35 percent,...
-
The procedure in Exercise 10.46 also calculates the chi square test for independence. Do Exercise 10.40 using the computer. Data From Exercise 10.46 Data From Exercise 10.40 10.46 A chi square test...
-
1. There is asymmetric information in the used-car market because _________ (buyers/sellers) cannot distinguish between lemons and plums but _________ (buyers/sellers) can. 2. The supply curve for...
-
RITY (Percent of terrorists caught) The blue curve on the following graph shows the tradeoff between security and tourism; that is, combinations of security and tourism above the blue curve are not...
-
Jack Tasker opened his Auto Repair Shop in November 2023. The balance sheet at November 30, 2023, prepared by an inexperienced part-time bookkeeper, is shown below. Required Prepare a correct balance...
-
Sundae Inc. is deciding whether to undertake a new project. The project is expected to be riskier than the firm's current operations. For cost of capital estimation management wants to use the...
-
What are the best takeaways we can take from situational leadership. b) How can situational leadership help us in our workplace. c) How can we turn situational leadership into habits.
-
Jeff purchased a card for $180 that gives him 20 visits to a new gym and includes a one time fee for unlimited use of the sauna. After 5 visits, he has $123.75 left on the card, and after 11 visits,...
-
URSING PEER INTERVIEWS ASSIGNMENT INSTRUCTIONS OVERVIEW explore delegation policies as listed on the State Board of Nursing website for the state in which you hold your nursing license. You will also...
-
15. An empty swimming pool with a square floor dimension has a volume of 3y m. Given the weight of air in the swimming pool is about 500 N and the air density is 1.29 kg/m. (a) (b) Find the length of...
-
Christensen spoke in depth about how disruptive technologies can affect existing market leading companies. Considering this, explain how 3D Printing has created a new market and how an existing...
-
Job No. 469 Item: White Lion Cages For: Zawadi Company Job Cost Sheet Quantity: 2,000 Date Requested: 7/2 Date Completed: 7/31 Date Direct Materials Direct Labour Manufacturing Overhead 7/10 $880 12...
-
(a) What do data breach notification laws require? (b) Why has this caused companies to think more about security?
-
Mode Engineering is a large corporation with the ability to obtain financing by selling its bonds at favorable rates. Currently, it pays 6% interest on its 10-year bond issues. In the past year, Mode...
-
Pam Company acquires the net assets of Jam Company for an agreed-upon price of $900,000 on July 1, 2011. The value is tentatively assigned as follows: Current assets .............. $ 100,000 Land...
-
Select the best answer for each of the following multiple-choice items. Items (1) through (3) are based on the following: The Bayview Humane Society, a VHWO caring for lost animals, had the following...
-
The overall process of creating a capital budget proposal has a lot of similarities to writing a business plan for a start-up company. Describe three aspects of the similarities between a budget...
-
There are three general categories of capital budget scenarios: replacement, expansion, and investment in a NewCo. Describe the overall decision-making context for each. How do they draw on similar...
-
In analysis, some focus seems to be on the need for NPV equations to be applied to projects that are mutually exclusive. But in practice we find that the lines are blurred in capital budgeting....
Study smarter with the SolutionInn App