Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Follow up from my last post I need part 2 questions 3-7 done ASAP please answer a. Part 2 - Instruction Instruction: You will prepare
Follow up from my last post I need part 2 questions 3-7 done ASAP please answer
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 clientStep 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