Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need Ledger, Worksheet, Financial statement Worksheet: Account Trial Balance Dr. Gr. Adjustments Dr. Cr. Income Statement Dr. Cr. Statement of Financial Position Dr. Cr.
I need "Ledger", "Worksheet", "Financial statement"
Worksheet: Account Trial Balance Dr. Gr. Adjustments Dr. Cr. Income Statement Dr. Cr. Statement of Financial Position Dr. Cr. B Assignment 2 Instructions Use the tabs on the bottom of this excel file to navigate between sheets. You are asked to fill out the Journal Entries, Ledger, Worksheet, and Financial Statements for this assignment. This answer sheet should help you with the format. Cash Accounts Receivable Supplies Prepaid insurance Accounts Payable Junearned Service Revenue Service Revenue Salaries Expense 10 11 12 13 14 15 16 17 18 Net Income 19 20 22 Note: Alter finishing the worksheet use the final balances to finale financial statements (only Income Statement, and Statement of Financial Position on the next tab General Ledger: T Accounts Cash Accounts Receivable Financial Statements: Assignment 2 Company Income Statement For the period ending on December 31, 20x1 Service Revenue Expenses: Assignment 2 Company Statement of Financial Position December 31, 20x1 Assets Liabilities Cash Supplies 10 T Prepaid Insurance Accounts Payable Total Liabilities 0 11 Net Income Unearned Service Revenue Service Revenue *Note: the specific number of accounts is not shown here 0 Owners' Equity Retained Earnings Total Owners' Equity Total Liabilities and Owner 0 Total Assets 0 Salaries Expense *Note: the specific number of accounts is not shown here *Note: After finishing the Taccounts, use the tab on the bottom and fill in the Worksheet next Journal: Date Dr. Cr. Account Dr. Cr. Note: Purchased a prepaid 2-year insurance policy for $2,000 Jan. 1 Jan. 21 Note: Performed services for $5,000, where half is received in cash and the other half received on account Feb. 14 Note: Purchased supplies on account for $1,000 Mar. 1 Note: Paid in cash for $500 of supplies that were previously purchased on account on Feb. 14th Apr. 20 Note: Received $2,000 cash payment from services previously performed on January 21st Jun. 1 Note: Paid salaries for $1,000 Aug. 15 Note: Received $5,000 cash payment for services not yet performed yet Oct. 3 Note: Performed services worth $3,000 for a client who already paid on August 15th Oct. 9 Note: Purchased supplies for $250 cash Dec. 1 Note: Paid salaries for $1,400 *Note: After finishing the journal, use the tab on the bottom and fill out the General Ledger nextStep 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