Question
Read ALL instructions before getting started! ABC Corporation is a new company that buys and sells office supplies. Business began on January 1, 2014. Given
Read ALL instructions before getting started! ABC Corporation is a new company that buys and sells office supplies. Business began on January 1, 2014. Given on the first two tabs are ABC's 12/31/14 Unadjusted Trial Balance and a list of needed adjustments. 1. Make all 16 adjustments on the "Adjusting Journal Entries" tab. Remember to include a description under each journal entry. 2. Post the adjustments to the general ledger on the "12-31-14 T-Accounts" tab. You may have to add T-Accounts for new accounts. Link your T-Account entries to your Journal Entries. PLEASE NOTE THAT THE "BB" (BEGINNING BALANCES) FOR THE T-ACCOUNTS REPRESENT THE UNADJUSTED BALANCES AS OF 12/31/14. 3. Once the 12/31/14 T-Accounts are complete, prepare the Adjusted Trial Balance. There may be some accounts with zero dollars, and you may have to insert lines for new accounts (some blank T-Accounts have already been provided for you). Link the Adjusted Trial Balance to your T-Accounts. 4. Use the Adjusted Trial Balance numbers to complete the Income Statement, Statement of Retained Earnings, Balance Sheet, and Statement of Cash Flows. For purposes of the Income Statement, prepare using the multiple step format and assume that Rent Revenue, any Unrealized Holding Gains/Losses, Interest Expense, Interest Revenue, and any other Gains/Losses are NOT part of the major central ongoing operations of the company. Link your financial statements to your Adjusted Trial Balance. Use the Income Statement and Balance Sheet to finish the partially completed Statement of Cash Flows. Since this is ABC's first year of operations, several line items on the Statement of Cash Flows have already been supplied to you. If necessary, review financial statement preparation in Chapters 4 and 5 of your textbook for a quick refresher. Plan on using your knowledge gained in completing Chapter 23 to help with the preparation of the Statement of Cash Flows. Additionally, since this is ABC Corporation's first year of operations, the adjusted trial balance for all current assets and liabilities represents the change during the year for Statement of Cash Flows analysis purposes. 5. When the Financial Statements are complete, make the closing entries on the "Closing Entries" tab being mindful of the four closing entries you've learned. 6. When closing entries have been made, post the entries to the general ledger on the "Post-Close T-Accounts" tab. Make sure your adjusting journal entries are also posted on your Post-Close T-Accounts. They will not automatically flow from tab-to-tab. Suggestion: As an alternative, after you've finished posting your adjusting journal entries to the accounts in the "12-31-14 T Accounts" tab, make a duplicate of this worksheet to use for posting your closing entries and then just relabel the tab as "Post-Close T-Accounts." Just be sure to delete the original "Post-Close T-Accounts" tab already in the workbook before you do this since you can't have two worksheets with the same name.
I have excel attachement with full problem. I do not know how to upload
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started