Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribed

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 next

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

Payroll Accounting 2022

Authors: Bernard J. Bieg, Judith A. Toland

32nd Edition

0357518756, 9780357518755

More Books

Students also viewed these Accounting questions

Question

=+46. Monthly gas prices, part 3. Using the data from Exercise

Answered: 1 week ago

Question

Determine miller indices of plane A Z a/2 X a/2 a/2 Y

Answered: 1 week ago

Question

What are employee assistance programs and wellness programs?

Answered: 1 week ago