Question: Cam someone please double check my work and help me with the analysis tab? On January 1, 2021, the general ledger of 3D Family Fireworks

Cam someone please double check my work and help me with the analysis tab?  Cam someone please double check my work and help me with
the analysis tab? On January 1, 2021, the general ledger of 3D
Family Fireworks includes the following account balances: Credit Debit $ 26,100 14.700
$3,000 Accounts Cash Accounts Receivable Allowance for Uncollectible Accounts Supplies Notes Receivable

On January 1, 2021, the general ledger of 3D Family Fireworks includes the following account balances: Credit Debit $ 26,100 14.700 $3,000 Accounts Cash Accounts Receivable Allowance for Uncollectible Accounts Supplies Notes Receivable (64, due in 2 years) Land Accounts Payable Common Stock Retained Earnings Totals 3,600 15,000 80,000 7.900 95,000 33,500 $139,400 $139,400 During January 2021, the following transactions occur: January 2 Provide services to customers for cash, $46,100. January 6 Provide services to customers on account, $83,400. January 15 Write of accounts receivable as uncollectible, $2,500. January 20 Pay cash for salaries, $32,500. January 22 Receive cash on accounts receivable, $81,000. January 25 Pay cash on accounts payable, $6,600. January 30 Pay cash for utilities during January, $14,800. The following information is available on January 31, 2021. a. The company estimates future uncollectible accounts. The company determines $4,000 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 $800. 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,600. Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Analysis 1. Record each of the transactions listed above in the 'General Journal' tab (these are shown as items 1-7). Review the "General Ledger and the Trial Balance' tabs to see the effect of the transactions on the account balances. 2. Record the adjusting entries in the General Journal' tab (these are shown as items 8-11). 3. Review the adjusted "Trial Balance as of January 31, 2021, in the 'Trial Balance' tab. 4. Prepare an income statement for the period ended January 31, 2021, in the 'Income Statement' tab. 5. Prepare a classified balance sheet as of January 31, 2021 in the Balance Sheet' tab. 6. Record the closing entries in the 'General Journal' tab these are shown as items 12 and 13). 7. Using the information from the requirements above, complete the 'Analysis' tab. Debit No Credit General Journal Date 1 Jan 02, 2021 Cash 46,100 Service Revenue 46,100 2 Jan 06, 2021 83,400 Accounts Receivable Service Revenue 83,400 3 Jan 15, 2021 Allowance for Uncollectible Accounts 2,500 Accounts Receivable 2,500 Jan 20, 2021 32,500 Salaries Expense Cash 32,500 5 Jan 22, 2021 Cash 81,000 Accounts Receivable 81,000 6 Jan 25, 2021 6,600 Accounts Payable Cash 6,600 2 7 Jan 30, 2021 Utilities Expense Cash 14,800 14,800 8 Jan 31, 2021 830 Bad Debt Expense Allowance for Uncollectible Accounts 830 9 Jan 31, 2021 2,800 Supplies Expense Supplies 2,800 10 Jan 31, 2021 Interest Receivable 75 Interest Revenue 75 11 Jan 31, 2021 Salaries Expense Salarios Payable 34,600 34,600 . 12 Jan 31, 2021 Service Revenue Interest Revenue 129,500 75 10 Jan 31, 2021 Interest Receivable 75 Interest Revenue 75 11 Jan 31, 2021 Salaries Expense Salaries Payable 34,600 34,600 12 Jan 31, 2021 Service Revenue Interest Revenue Retained Earnings 129,500 75 129,575 13 Jan 31, 2021 85,530 Retained Earnings Salaries Expense Utilities Expense Supplies Expense Bad Debt Expense 67,100 14,800 2,800 830 The following information is available on January 31, 2021. a. The company estimates future uncollectible accounts. The company determines $4,000 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 $800. 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,600. Requirement General General Income Journal Trial Balance Balance Sheet Ledger Statement Analysis Enter your Accounts Receivable turnover value in 1 decimal place and Ratio of Allowance for Uncollectible Accounts in Whole number Analyze how well 3D Family Fireworks manages its receivables (a) Calculate the receivables tumover 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.4 times, is the company collecting cash from customers more or less officiently than other companies in the same industry? Accounts Receivable turnover times The company is collecting more efficiently. (true or false) (6) 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!