Week 6: Financial Statements Complete this assignment using the Excel workbook provided (add any necessary...
50.1K
Verified Solution
Link Copied!
Question
Accounting
Week 6: Financial Statements Complete this assignment using the Excel workbook provided (add any necessary additional lines), and submit your work by the end of Week 6, 11:59pm EST. Now that you have completed most of the steps in the accounting cycle, it is time to complete the cycle with the last steps. This week, you are to prepare the multiple-step income statement, statement of owners equity, and classified balance sheet. You should use the information completed in prior weeks. Prepare the income statement, where net income will be carried through to the statement of owners equity as one of the adjustments to the final balance in the equity account. You will then need to prepare the balance sheet, where you will show the updated owners equity balance. Prepare a May (xxxx) multiple-step income statement, a May (xxxx) statement of owner's equity, and a May 31, (xxxx), classified balance sheet. Prepare a post-closing trial balance.
Scenario
You have just been promoted to the Senior Accountant position for Northridge LLC. During your first month in your new role, you will be completing a full accounting cycle for the month. Your Supervisor, Mr. Jones, requests that he previews your work since you are new to the position.
Directions
For this project, you will be using the Excel workbook provided in week 3.
Deliverable items for the Portfolio Project will be required at different points during the course as indicated in the table above, and then a final submission that includes corrected versions of each of the three submissions (as needed) .
Northridge LLC
Trial Balance
April 30, 20XX
Debit
Credit
Cash
$58,791
Accounts receivable
18,495
Merchandise inventory
85,221
Store Supplies
2250
Office Supplies'
885
Prepaid Insurance
1659
Office equipment
2500
Accumulated depreciation-Office Equipment
$658
Store equipment
16580
Accumulated depreciation-Store Equipment
2,268
Accounts Payable
50921
J. Spark, Capital
132,534
Totals
$186,381
$186,381
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!