Answered step by step
Verified Expert Solution
Question
1 Approved Answer
it uploaded backwards Enter your Accounts Receivable turnover value in 1 decimal place and Ratio of Allowance for Uncollectible Accounts in Whole number. Analyze how
it uploaded backwards
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 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.5 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 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? Choose the appropriate accounts to complete the company's balance sheet. Make sure to select 'adjusted' from the dropdown, which will then populate the balances in those accounts from the adjusted trial balance. Unadjusted 3D Family Fireworks Balance Sheet January 31, 2021 Assets Liabilities Current Assets: Current Liabilities: Total Current Liabilities Total Current Assets Total Liabilities Stockholders' Equity Long-term assets: Total Stockholders' Equity Total Liabilities & Stockholders' Equity Total Assets Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Analysis Choose the appropriate accounts to complete the company's income statement. Select 'adjusted' from the dropdown, which will then populate the balances in those accounts from the adjusted trial balance. Unadjusted 3D Family Fireworks Income Statement For Month Ended January 31, 2021 Rever Total Revenue Expenses: Total Expenses Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Analysis Notice the dropdown below that gives the options to select the unadjusted, adjusted or post-closing trial balance. The option you choose will be the values used to populate the income statement and balance sheet tabs. Unadjusted 3D Family Fireworks Trial Balance January 30, 2021 Account Title Debit Credit Cash 25,100 14,200 Accounts Receivable Allowance for Uncollectible Accounts 2,000 Notes Receivable 26,000 3,100 Supplies Land Accounts Payable 77,600 9,000 102,0 Common Stock Retained Earnings 33,000 Total 146,000 $ 146,000 Each journal entry is posted automatically to the general ledger. Notice the dropdown below that gives the options to select the unadjusted, adjusted or post-closing account balance. The option you choose will be the values used to populate the trial balance, income statement and balance sheet tabs. Unadjusted General Ledger Account Accounts Receivable Cash Debit No. Credit No. Debit Credit Date Jan 01, 2021 Balance 25,100 Date Jan 01, 2021 Balance 14,200 Allowance for Uncollectible Accounts Notes Receivable No. Debit Credit No. Debit Credit Date Jan 01, 2021 Balance 2,000 Date Jan 01, 2021 Balance 26.000 Land Supplies Debit No. Date Credit No. Date Debit Credit Balance Balance 3,100 Jan 01, 2021 Jan 01, 2021 77,600 Accounts Payable Common Stock No. Date Debit Credit No. Date Debit Credit Balance Balance 9,000 Jan 01, 2021 Jan 01, 2021 102.000 Retained Earnings No. Date Debit Credit Balance 33,000 Jan 01, 2021 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 Provide services to customers for cash, $41,100. Note: Enter debits before credits. Date General Journal Debit Credit Jan 02, 2021 Record entry Clear entry View general journal 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. On January 1, 2021, the general ledger of 3D Family Fireworks includes the following account balances: Credit Debit $ 25, 100 14,200 $ 2,000 Accounts Cash Accounts Receivable Allowance for Uncollectible Accounts Supplies Notes Receivable (6%, due in 2 years) Land Accounts Payable Common Stock Retained Earnings Totals 3,100 26,000 77,600 9,000 102,000 33,000 $146,000 $146,000 During January 2021, the following transactions occur: January 2 Provide services to customers for cash, $41,100. January 6 Provide services to customers on account, $78,400. January 15 Write off accounts receivable as uncollectible, $1,600. January 20 Pay cash for salaries, $32,000. January 22 Receive cash on accounts receivable, $76,000. January 25 Pay cash on accounts payable, $6,100. January 30 Pay cash for utilities during January, $14,300. The following information is available on January 31, 2021. a. The company estimates future uncollectible accounts. The company determines $5,600 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 $1,000. 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,100Step 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