Answered step by step
Verified Expert Solution
Link Copied!

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 image text in transcribed

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

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

Accountants Guide To Fraud Detection And Control

Authors: Howard R. Davia, Patrick C. Coggins, John C. Wideman, Joseph T. Kastantin

2nd Edition

0471353787, 9780471353782

More Books

Students also viewed these Accounting questions

Question

A 300N F 30% d 2 m Answered: 1 week ago

Answered: 1 week ago