Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Data for the next ll questions: The beginning account balances of Moon Office Cleaning Service Company as of Jan. 1, 2020 is as follows: Credit

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Data for the next ll questions: The beginning account balances of Moon Office Cleaning Service Company as of Jan. 1, 2020 is as follows: Credit Trial Balance As of January 1, 2020 Accounts Cash Accounts Receivable Prepaid Insurance Supplies Equipment Accumulated Depreciation-Equipment Accounts Payable Common Stock, par $10 Retained Earnings Total Debit 6,170 1.800 2.400 2.900 25,500 4,820 2.650 25,000 6,300 38,770 38,770 Mrs. Kate Moon started the company about four years ago upon graduation from college. The following is the list of transactions that Moon Company had in 2020. Mrs. Kate Moon started the company about four years ago upon graduation from college. The following is the list of transactions that Moon Company had in 2020. 1) Kate Moon, the owner, invested additional $30,000 of her own money in the business for expansion of the company in exchange for 3,000 shares of common stock (S10 par value per share). 2) Company borrowed $40,000 from bank by issuing a 5-year note. 3) Company purchased $15,000 of equipment - paid $5.000 in cash and signed a 3-year note for the rest. 4) Company purchased a truck for business use at $20,000 in cash. 5) Company provided $85,000 services to customers of which $78,000 was collected in cash, the rest was on account. 6) During the year, Company incurred $60,000 of salaries expense of which $2000 was still not paid as of Dec. 31st. 7) During the year, Company paid $3000 interest on the note to the Bank. 8) During the year, Kate Moon took out $3,000 as dividend. 9) During the year. Company collected $150 interest from bank on company account. 10) During the year, Company purchased $2000 of supplies in cash. 11) During the year Company sold $500 of unnecessary equipment in cash at cost. 12) Company collected $3,500 of accounts receivable. 13) During the year. Company paid $12000 of rent. 14) During the year, company paid $3000 to IRS for income tax expense. 15) During the last week of the year, Company collected $3000 from a customer for services to be rendered next year. 16) Depreciation on equipment for year was estimated to be $2000. 17) A physical inventory revealed that $500 of the supplies was left As of Dec. 31. 18) As of Dec. 31. $2,000 of prepaid insurance was expired. Requirements: a) Journalize the above 18 transactions on the General Journal in Tab 3 of the Excel File, b) post journal entries from the General Journal to the General Ledger on Tab 4 of the Excel File, c) based on the updated balance of accounts on the General Ledger, prepare a Trial Balance on Tab 5 of the Excel File, d) based on the balance of accounts on the Trial Balance, prepare an Income Statement on Tab 6 of the Excel File, e) prepare a Statement of Retained Earnings on Tab 7 of the Excel File, f) based on the balance of accounts on the Trial Balance and Statement of Retained Earnings, prepare a classified Balance Sheet on Tab 8 of the Excel File, g) based on Cash account and transactions taken place, prepare a Statement of Cash Flows on Tab 8 of the Excel file h) using the information on your Excel file, answer the following questions, then submit your Excel file through the dropbox on D2L. What is the balance of Cash account in the General Ledger

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions

Question

Describe effectiveness of reading at night?

Answered: 1 week ago

Question

find all matrices A (a) A = 13 (b) A + A = 213

Answered: 1 week ago