Question: Regarding my previous post can someone answer 4-7 if not possible than just 4 a. Part 2 - Instruction Instruction: You will prepare the following
Regarding my previous post can someone answer 4-7 if not possible than just 4
a. Part 2 - Instruction Instruction: You will prepare the following in excel - 1. General Journal Prepare adjusted journal entries 2. Ledger - Taccounts a. Show beg. Unadjusted balance from part 1 b. Post adjusting activity - with Journal entry reference add on to unadjusted balance (this is your beginning) C. Show adjusted ending balance in ledger account 3. Trial Balance a. Prepare and Adjusted Trial Balance 4. Financial Statements (Multi-step) Income statement (do not forget the EPS disclosure) b. Statement of Retained Earnings C. (Classified) Balance Sheet (remember all disclosures) d. Cash Flow - prepare a direct method (remember that GAAP requires a reconciliation when the direct method is used) 5. General Journal e. Prepare closing journal entries 6. Ledger - Taccounts Show Beg adjusted balance from #2 b. Post the closing activity with Journal entry reference Show ending closing balances 7. Trial Balance Prepare a Post-Closing trial balance a. a. C. a. Remember to use proper formatting for everything you do! Financial statements should be GAAP format and look professional (and printer ready). Assume you are making this for a client. a. Part 2 - Instruction Instruction: You will prepare the following in excel - 1. General Journal Prepare adjusted journal entries 2. Ledger - Taccounts a. Show beg. Unadjusted balance from part 1 b. Post adjusting activity - with Journal entry reference add on to unadjusted balance (this is your beginning) C. Show adjusted ending balance in ledger account 3. Trial Balance a. Prepare and Adjusted Trial Balance 4. Financial Statements (Multi-step) Income statement (do not forget the EPS disclosure) b. Statement of Retained Earnings C. (Classified) Balance Sheet (remember all disclosures) d. Cash Flow - prepare a direct method (remember that GAAP requires a reconciliation when the direct method is used) 5. General Journal e. Prepare closing journal entries 6. Ledger - Taccounts Show Beg adjusted balance from #2 b. Post the closing activity with Journal entry reference Show ending closing balances 7. Trial Balance Prepare a Post-Closing trial balance a. a. C. a. Remember to use proper formatting for everything you do! Financial statements should be GAAP format and look professional (and printer ready). Assume you are making this for a client
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
