Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help creating the general ledger (include adjusted entry and closing entry for revenue & expense), income statement, balance sheet, and analysis please. On

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

I need help creating the general ledger (include adjusted entry and closing entry for revenue & expense), income statement, balance sheet, and analysis please.

On January 1, 2021, the general ledger of 3D Family Fireworks includes the following account balances: Credit Debit $ 26,700 15,000 Accounts Cash Accounts Receivable Allowance for Uncollectible Accounts Supplies Notes Receivable (6%, due in 2 years) $ 3,600 3,900 18,000 80,300 Land Accounts Payable Common Stock Retained Earnings Totals 8,500 98,000 33,800 $143,900 $143,900 During January 2021, the following transactions occur: January 2 Provide services to customers for cash, $49,100. January 6 Provide services to customers on account, $86,400. January 15 Write off accounts receivable as uncollectible, $3,300. January 20 Pay cash for salaries, $32,800. January 22 Receive cash on accounts receivable, $ 84,000. January 25 Pay cash on accounts payable, $6,900. January 30 Pay cash for utilities during January, $15,100. The following information is available on January 31, 2021. a. The company estimates future uncollectible accounts. The company determines $4,300 of accounts receivable on January 31 are past due, and 20% of these accounts are estimated to be uncollectible. The remaining accounts receivable on January 31 are not past due, and 5% of these accounts are estimated to be uncollectible. (Hint: Use the January 31 accounts receivable balance calculated in the general ledger.) b. Supplies at the end of January total $950. c. Accrued interest revenue on notes receivable for January. Interest is expected to be received each December 31. d. Unpaid salaries at the end of January are $34,900. Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Analysis Prepare the journal entries for transactions. (If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field.) View transaction list Journal entry worksheet accounts receivable on January 31 are not past due, and 5% of these accounts are estimated to be uncollectible. (Hint: Use the January 31 accounts receivable balance calculated in the general ledger.) Record the adjusting entry for uncollectible accounts. Note: Enter debits before credits. Debit Credit Date General Journal Jan 31, 2021 Bad Debt Expense Allowance for Uncollectible Accounts 490 1,565 Adjusted 3D Family Fireworks Income Statement For Month Ended January 31, 2021 Revenue: Total Revenue $ 0 Expenses: Total Expenses 0 3D Family Fireworks Balance Sheet January 31, 2021 Assets Liabilities Current Assets: Current Liabilities: $ 0 0 0 O 0 Total Current Liabilities 0 Total Current Assets 0 Total Liabilities O Long-term assets: Stockholders' Equity 0 0 0 0 Total Stockholders' Equity 0 Total Liabilities & Stockholders' Equity Total Assets $ 0 Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Analysis Enter your Accounts Receivable turnover value in 1 decimal place and Ratio of Allowance for Uncollectible Accounts in Whole nu Analyze how well 3D Family Fireworks manages its receivables (a) Calculate the receivables turnover ratio for the month of January (Hint: For the numerator, use total services provided to customers on account). If the industry average of the receivables turnover ratios for the month of January is 4.7 times, is the company collecting cash from customers more or less efficiently than other companies in the same industry? Accounts Receivable turnover: times The company is collecting more efficiently. (true or false) (b) Calculate the ratio of Allowance for Uncollectible Accounts to Accounts Receivable at the end of January. Based on a comparison of this ratio to the same ratio at the beginning of January, does the company expect an improvement or worsening in cash collections from customers on credit sales? Ratio of Allowance for Uncollectible Accounts to Accounts Receivable % Should the company expect improving or worsening conditions

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

Managerial Accounting

Authors: Charles E. Davis, Elizabeth Davis

2nd edition

1118548639, 9781118800713, 1118338448, 9781118548639, 1118800710, 978-1118338445

More Books

Students also viewed these Accounting questions