Financial Accounting 1A Project 2 (30 points) DUE March 28 1) Prepare the Items listed in the Required Section below using the Transactions at the Bottom. 2) Use your Text-Book and Chapter Notes as a Guide on how to prepare the Required items 3) All Required ltems must be completed using a Computer spreadsheet program such as Microsoft Excel. Please see me if you have not used a computerized spreadsheet before, also we will have an in class short lesson. 4) Points will be scored based on the Following: Accounting Formats, Proper Accounting Presentation, Organization, 5) Please make sure to record All Transactions and prepare all Required Reports even if you are not completely sure of their accuracy as more points will be awarded for effort than for blank, skipped, or missing reports and transactions. 6) Assume you are working with the Shark-Corp and you are preparing the Financial Statements for review by Investors and Bankers. 7) You may Do This Assignment in a Group of T wo or By Yourself (your choice) Each Group can turn in one report for the group, but the group must prepare their Own Spreadsheets!!( Do not copy or use another Day to start this project or you will not have enough time to complete the assignment. REQUIRED (Prepare and Deliver in The Following Order) 1) Prepare a Cover Page as Follows Name(s). Course, Assignment, Current Date b) No Bulky Binder or Plastic Covers Please just Pages of Paper stapled together in Order c) Pictures on Cover or elsewhere are not require Prepare a Table of Contents (Name of Each Report and the Prepare the Accounting t are encouraged and look great Journal, record all Accounting Entries based on the Transactions Below into the Journal using 2) 3) reports .. the proper Pve the Journal Format. (Include explanations and also calculations where needed) 4) Prepa are the General Ledger/T-Accounts, post all transactions from the Journal into the GL. Accounts. . Use the Accounting Transaction Reference Numbers from Below to identify amounts in your T-Accounts 5) Prepare the Adjusted Trial Balance with Debits and Credits and Totals 6) Prepare the Income Statement for the Month ended 12-31 7) Prepare the Retained Earnings Statement for the Month ended 12-31 8) Prepare the Classifed Balance Sheet as of 12-31 BUSINESS TRANSACTIONS for the Month of December, 1) 12-1 The Shark Corp Received $200,000 from SJ Sharkie in exchange for 5,000 shares of Common Stock. 2) 12-2 The Shark Corp Borrowed $40,000 from Wells Fargo Bank and signed a Note. 3) 12-3 The Shark Corp purchased Office Furniture for $120,000(5 year lide), on account from IKEA 4) 12-4 The Shark Corp purchased Computer Equipment for $60,000(5 year life), on account from Office Depot 5) 12-5 The Shark Corp paid $18,000 with Check 101 for Corporate Insurance for the next 12 months (Dec-Nov) 6) 12-10 The Shark Corp paid $20,000 with Check# 102 for December Rent 7) 12-11 The Shark Corp provided a mascot Seminar for the NIKE Corp and Billed Nike $120.000 on account REQUIRED (Prepare and Deliver in The Following Order 1) Prepare a Cover Page as Follows. a) Name(s), Course. Assignment, Current Date b) No Bulky Binder or Plastic Covers Please just Pages of Paper stapled together in Order c). Pictures on Cover or elsewhere are not required but are encouraged and look great 2) Prepare a Table of Contents (Name of Each Report and the page the report starts and ends on) 3) Prepare the Accounting Journal, record all Accounting Entries based on the Transactions Below into the Journal using the proper Journal Format. (Include explanations and also calculations where needed) 4) Prepare the General Ledger/T-Accounts, post all transactions from the Journal into the GL Accounts Use the Accounting Transaction Reference Numbers from Below to identify amounts in your T-Accounts. . 5) Prepare the Adjusted Trial Balance with Debits and Credits and Totals 6) Prepare the Income Statement for the Month ended 12-31 Prepare the Retained Earnings Statement for the Month ended 12-31 7) 8) Prepare the Classified Balance Sheet as of 12-31 BUSINESS TRANSACTIONS for the Month of December 1) 12-1 The Shark Corp Received $200,000 from SJ Sharkie in exchange for 5,000 shares of Common Stock 2) 12-2 The Shark Corp Borrowed $40,000 from Wells Fargo Bank and signed a Note. 3) 12-3 The Shark Corp purchased Office Furniture for $120,000(5 year life), on account from IKEA. 4) 12-4 The Shark Corp purchased Computer Equipment for $60,000(5 year life), on account from Office Depot 5) 12-5 The Shark Corp paid S 18.000 with Check#101 for Corporate Insurance for the next 12 months (Dec-Nov) 6) 12.10 The Shark Corp paid S20.000 with Check# 102 for December Rent. 7) 12-11 The Shark Corp provided a mascot Seminar for the NIKE Corp and Billed Nike $120,000 on account. 8) 12-15 The Shark Corp received the December Utility Bill from PGE in the amount of $5,000 to be paid in Jan 9) 12-16 The Shark Corp received the December Telephone Bill from SBC for $6,000 to be paid Later. 10) 12-17 The Shark Corp received a $70,000 Check from Nike Corp on account for services previously provided. 11) 12-20 The Shark Corp paid $10,000 with check #103 to Mark's Marketing for Professional Fees Expense. 12) 12.25 The Shark Corp paid $40000 with Check #104 for December Salary expenses. 13) 12-27 The Shark Corp received a $25,000 Check from Buick Corp for services to be provided in January 14) 12-28 The Shark Corp Paid S 100.000 with Check# 105 to IKEA Corp for the Office Furniture purchased above. 15) 12-29 The Shark Corp Paid S6.000 with Check #106 to SBC on account for the Telephone Bill. 16) 12-30 The Shark Corp Paid $11,000 with Check# 107 to Mr. SJ Sharkie for Dividends to the owner 17) 12-30 The Shark Corp paid S3,000 with check #108 to wF Bank on the note. S 1,000 was for Interest Expense. 18) 12-31 The Shark Corp recorded one Month of Insurance expense from the Prepaid Insurance account. 19) 12-31 The Shark Corp recorded one Month of Depreciation Expense on the Furniture and the Computer Equip. 20) 12-31 The Shark Corp recorded Income Tax Payable and Income Tax Expense for December, which is 40% of Net Income.(Taxes to be discussed in class)