create a general journal, general ledger, accounts recievable ledgar, accounts payable ledgar, inventory COGS calculations, trial balance
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
X f 2 3 4 21 22 23 Star Wars Practice Set - Fall 2017 Jose L.xlsx File Edit Insert Format Help A B 29 30 31 Calibri C D T F 32 33 Check Figures: 34 Net Income BIUS A F G H ». 8- I J 29 + K S Instructions: You are the controller at Star Wars, Inc., a wholesale clistributor of light sabers and other interstellar weaponry. The corporation was founded in galaxy far, far away a long time ago. The company has 420,000 share of common stock authorized with a par value of $18. Currently, 28,000 shares are issued and outstanding. In your role as controller, you are responsible for the company's 6 accounting records, financial statement preparation, and ensuring that the company has adequate internal controls. You also 7 support management at Star Wars by providing required financial reports. You supervise a staff that takes care of the other 5 8 aspects of accounting, but ultimately you oversee all the functions of the accounting department. Star Wars, Inc. maintains a 10 9 calendar year-end (the books are closed on December 31 of each year). Adjusting entries are only prepared annually. Therefore, when you prepare the adjusting entries, they will need to be for the entire year, not just for December. In order to complete this practice set, you will need to record all regular transactions for the month of December 2014 (all other regular 11 12 transactions have already been recorded for the year) and all of the year-end adjusting entries. You will journalize 13 all transactions and adjustments in the general journal, post them to the general ledger accounts, prepare an adjusted trial 14 balance, prepare the financial statements, prepare closing entries, and finally a post-closing trial balance for the year ended December 31, 2014. 15 16 17 18 19 20 L E. The following information pertains to the various accounting practices applicable to Star Wars, Inc. 1. Star Wars, Inc. maintains inventory using the perpetual method. All inventory costs are tracked using last in, first out (LIFO) cost flows. (See the cost of goods sold sheet for details regarding inventory) 2. Purchases of inventory are recorded at the net amount (discounts are recognized on the date of purchase, if applicable! The purchase terms are different for each supplier. Forfeited discounts are recorded separately as cast of goods sald. 3. Sales on account are subject to torms 2/15, n/40 and are recorded at gross value. 4. The company utilizes a general journal and general ledger, but also tracks detailed information on suppliers and customers M 24 in accounts payable and accounts receivable subsidiary lodgers, respectively. You will need to maintain the subsidiary lodgers. 25 5. Salaried employees are paid monthly at the end of the month (on the last day of the monthl. Hourly employees are paid every two weeks. Each two week pay period ends on the Friday of the second work. 25 27 28 6. The Company's chart of accounts is listed on the right side of this spreadsheet. 7. The Company uses the Allowance Method of accounting for bad debt. The Company calculates bad debt expense at the end of the fiscal year at 5% of ending A/R (using the % of receivables method). N O P Chart of Accounts: Name of Account Cash Petty Cash Q Accounts Receivable Allowance for Doubtful Accounts Notes Receivable Interest Receivable Inventory Supplies Prepaid Insurance Prepaid Rent Other Assets Land Buildings Accumulated Depreciation Buildings Equipment Accumulated Depreciation Equipment Space Ships Accumulated Depreciation-Space Ship Notes Payable Accounts Payable Salaries and Wages Payable FICA Taxes Payable Income Taxes Payable Federal Withholding Taxes Payable R Number of Account 101 104 111 112 115 118 120 125 128 130 131 135 140 141 146 147 155 156 200 201 210 211 212 213 214 S 215 216 225 226 230 232 T U State Withholding Taxes Payable FUTA Taxes Payable SUTA Taxes Payable Interest Payable Dividends Payable Notes Payable (long-term) Bonds Payable $1,227,435 Instructions Trial Balance at 11.30 2014 General Journal General Ledger Accounts Receivable ledger Accounts Payable sedner Inventory COGS calculations Teal Balance at 12:31 2014 Financial Stateme V W Download X Y B Share Post Closing AA 40 X f 2 3 4 21 22 23 Star Wars Practice Set - Fall 2017 Jose L.xlsx File Edit Insert Format Help A B 29 30 31 Calibri C D T F 32 33 Check Figures: 34 Net Income BIUS A F G H ». 8- I J 29 + K S Instructions: You are the controller at Star Wars, Inc., a wholesale clistributor of light sabers and other interstellar weaponry. The corporation was founded in galaxy far, far away a long time ago. The company has 420,000 share of common stock authorized with a par value of $18. Currently, 28,000 shares are issued and outstanding. In your role as controller, you are responsible for the company's 6 accounting records, financial statement preparation, and ensuring that the company has adequate internal controls. You also 7 support management at Star Wars by providing required financial reports. You supervise a staff that takes care of the other 5 8 aspects of accounting, but ultimately you oversee all the functions of the accounting department. Star Wars, Inc. maintains a 10 9 calendar year-end (the books are closed on December 31 of each year). Adjusting entries are only prepared annually. Therefore, when you prepare the adjusting entries, they will need to be for the entire year, not just for December. In order to complete this practice set, you will need to record all regular transactions for the month of December 2014 (all other regular 11 12 transactions have already been recorded for the year) and all of the year-end adjusting entries. You will journalize 13 all transactions and adjustments in the general journal, post them to the general ledger accounts, prepare an adjusted trial 14 balance, prepare the financial statements, prepare closing entries, and finally a post-closing trial balance for the year ended December 31, 2014. 15 16 17 18 19 20 L E. The following information pertains to the various accounting practices applicable to Star Wars, Inc. 1. Star Wars, Inc. maintains inventory using the perpetual method. All inventory costs are tracked using last in, first out (LIFO) cost flows. (See the cost of goods sold sheet for details regarding inventory) 2. Purchases of inventory are recorded at the net amount (discounts are recognized on the date of purchase, if applicable! The purchase terms are different for each supplier. Forfeited discounts are recorded separately as cast of goods sald. 3. Sales on account are subject to torms 2/15, n/40 and are recorded at gross value. 4. The company utilizes a general journal and general ledger, but also tracks detailed information on suppliers and customers M 24 in accounts payable and accounts receivable subsidiary lodgers, respectively. You will need to maintain the subsidiary lodgers. 25 5. Salaried employees are paid monthly at the end of the month (on the last day of the monthl. Hourly employees are paid every two weeks. Each two week pay period ends on the Friday of the second work. 25 27 28 6. The Company's chart of accounts is listed on the right side of this spreadsheet. 7. The Company uses the Allowance Method of accounting for bad debt. The Company calculates bad debt expense at the end of the fiscal year at 5% of ending A/R (using the % of receivables method). N O P Chart of Accounts: Name of Account Cash Petty Cash Q Accounts Receivable Allowance for Doubtful Accounts Notes Receivable Interest Receivable Inventory Supplies Prepaid Insurance Prepaid Rent Other Assets Land Buildings Accumulated Depreciation Buildings Equipment Accumulated Depreciation Equipment Space Ships Accumulated Depreciation-Space Ship Notes Payable Accounts Payable Salaries and Wages Payable FICA Taxes Payable Income Taxes Payable Federal Withholding Taxes Payable R Number of Account 101 104 111 112 115 118 120 125 128 130 131 135 140 141 146 147 155 156 200 201 210 211 212 213 214 S 215 216 225 226 230 232 T U State Withholding Taxes Payable FUTA Taxes Payable SUTA Taxes Payable Interest Payable Dividends Payable Notes Payable (long-term) Bonds Payable $1,227,435 Instructions Trial Balance at 11.30 2014 General Journal General Ledger Accounts Receivable ledger Accounts Payable sedner Inventory COGS calculations Teal Balance at 12:31 2014 Financial Stateme V W Download X Y B Share Post Closing AA 40
Expert Answer:
Related Book For
College Accounting A Contemporary Approach
ISBN: 978-0077639730
3rd edition
Authors: David Haddock, John Price, Michael Farina
Posted Date:
Students also viewed these economics questions
-
Create unadjusted trial balance including Schedule of Accounts Receivable and Accounts Payable Submit the perpetual and periodic general journal the unadjusted trial balance schedule for accounts...
-
A general ledger trial balance at June 30, 2013, for Millar City is as follows: Millar City uses a purchases basis in accounting for supplies. Open encumbrances are considered constrained by the...
-
A general ledger trial balance for Any City contained the following balances at June 30, 2011, just before closing entries were made: Due from other funds......... $ 600 Fund...
-
In this assignment, you will take on the role of the Warden of a maximum custody state correctional facility. Your unit's use of force incidents has dramatically increased over the last year to...
-
Answer the following questions by referring to the 2011 financial statements for each of Danier and WestJet in Appendix II. Required 1. How much of Daniers total assets are financed by debt? by...
-
Some experts argue that the debt levels for some nations are so high that their entire external indebtedness, not just part, should be written off. What do you see as the pros and cons of this...
-
Reconsider the data from Problem 56. What is the capital recovery cost of Model 127B? Data from problem 56 Octavia Bakery is planning to purchase one of two ovens. The expected cash flows for each...
-
Large frauds can often be detected by performing financial statement analysis. Although such analysis can raise areas of concern, not all red flags are the result of fraudulent activities. Reasonable...
-
An 76 kg man starts from rest and after 1.60 seconds is running at a speed of 11.0 m/s. The force needed for this man to get up to this speed in 1.60 seconds is ____ N.
-
The proposed rates were not in the range the CEO expected given the pricing analysis. The CEO has asked the pricing actuary to verify the total projected loss cost excluding potential large storm...
-
When Every Wear started with the production of dairy products, competition soon emerged and sales were slow. Consequently a trademark logo, in the shape of a cow, was designed and registered during...
-
Identify three characteristics or attributes that should be integrated into a personal mission statement. How do you plan to use your personal mission statement in defining your future? Please share...
-
USING PESTLE P --- Political E --- Economical S --- Sociocultural T --- Technology L --- Legal E --- Environmental discuss how each one of the elements from the General Environment has an affect or...
-
1) Drawing from Chapter 5 in your textbook and other course materials, discuss the ways in which the energy crisis could be offset by measures taken in and by developed nations. 2) Discuss potential...
-
https://www.coursehero.com/u/file/130136645/Enterprise-Rental-Case-Culture-People-Centric-Practicesdocx/ Show how this case follows the classical management practices and theories of Taylor, Weber,...
-
Write a Java function that efficiently calculates the edit distance between two strings.
-
The interest rate (yield) on Treasury bonds is 3.3% and the expected inflation rate is 1.3%. Part 1 What is the exact real rate of interest? Attempt 1/5 for 10 pts.
-
Using Apple, demonstrate how the differentiation strategy can be well implemented.
-
The Artisan Wines is a retail store selling vintage wines. On December 31, 2016, the firms general ledger contained the accounts and balances below. All account balances are normal....
-
Why are MICR numbers printed on deposit slips and checks?
-
The supplies adjustment records the supplies used for the month from a cupboard that is filled at various times of the month. Molly asks you to record a larger supplies adjustment than is indicated...
-
The financial records of Dunbar Inc. were destroyed by fire at the end of 2015. Fortunately, the controller had kept the following statistical data related to the income statement. 1. The beginning...
-
Maher Inc. reported income before income tax during 2015 of 790,000. Additional transactions occurring in 2015 but not considered in the 790,000 are as follows. 1. The corporation experienced an...
-
Presented below is the trial balance of Thompson Corporation at December 31, 2015. Instructions Prepare an income statement and a retained earnings statement. Assume that the only changes in retained...
Study smarter with the SolutionInn App