Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi, I need help getting the attached work done. It's basic accounting and making t-accounts, balance sheets, etc. Please do everything in Excel with the

Hi, I need help getting the attached work done. It's basic accounting and making t-accounts, balance sheets, etc.

Please do everything in Excel with the formulas, thank you!

image text in transcribed Financial Accounting 1A Project 2 (30 points) DUE March 31 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. 7) Prepare the Retained Earnings Statement for the Month ended 12-31 8) Prepare the Balance Sheet as of 12-31 BUSINESS TRANSACTIONS for the Month of December. 1) 2) 3) 4) 5) 6) 7) 8) 9) 10) 11) 12) 13) 14) 15) 16) 17) 18) 19) 20) 12-1 The Shark Corp Received $200,000 from SJ Sharkie in exchange for 5,000 shares of Common Stock. 12-2 The Shark Corp Borrowed $40,000 from Wells Fargo Bank and signed a Note. 12-3 The Shark Corp purchased Office Furniture for $100,000(5 year life), on account from IKEA.. 12-4 The Shark Corp purchased Computer Equipment for $60,000(5 year life), on account from Office Depot 12-5 The Shark Corp paid $18,000 with Check#101 for Corporate Insurance for the next 12 months.(Dec-Feb) 12-10 The Shark Corp paid $20,000 with Check#102 for December Rent. 12-11 The Shark Corp provided a mascot Seminar for the NIKE Corp and Billed Nike $120,000 on account. 12-15 The Shark Corp received the December Utility Bill from PGE in the amount of $5,000 to be paid in Jan. 12-16 The Shark Corp received the December Telephone Bill from SBC for $6,000 to be paid Later. 12-17 The Shark Corp received a $70,000 Check from Nike Corp on account for services previously provided. 12-20 The Shark Corp paid $10,000 with check #103 to Mark's Marketing for Professional Fees Expense. 12-25 The Shark Corp paid $40,000 with Check #104 for December Salary expenses. 12-27 The Shark Corp received a $25,000 Check from Buick Corp for services to be provided in January. 12-28 The Shark Corp Paid $100,000 with Check#105 to IKEA Corp for the Office Furniture purchased above. 12-29 The Shark Corp Paid $6,000 with Check #106 to SBC on account for the Telephone Bill. 12-30 The Shark Corp Paid $11,000 with Check#107 to Mr. SJ Sharkie for Dividends to the owner. 12-30 The Shark Corp paid $3,000 with check #108 to WF Bank on the note, $1,000 was for Interest Expense. 12-31 The Shark Corp recorded one Month of Insurance expense from the Prepaid Insurance account. 12-31 The Shark Corp recorded one Month of Depreciation Expense on the Furniture and the Computer Equip. 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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Stacey WhitecottonRobert LibbyRobert Libby, Patricia LibbyRobert Libby, Fred Phillips

1st Edition

0078110777, 9780078110771

More Books

Students also viewed these Accounting questions

Question

2. Use the working-backward strategy to plan a party.

Answered: 1 week ago

Question

2. In what way can we say that method affects the result we get?

Answered: 1 week ago