please complete all parts of the question. the general journal, the income statement, the balance sheet, and analysis. added extra pictures so question is easier to understand.
Exercise 7-36 (Algo) General Ledger Exercise (LO7-5, 7-6, 7-7, 7-9) On January 1, 2021, the general ledger of 3D Family Fireworks includes the following account balances: Credit Debit $ 22,600 11,700 $ 1,500 Accounts Cash Accounts Receivable Allowance for Uncollectible Accounts Supplies Notes Receivable (6#, due in 2 years) Land Accounts Payable Common Stock Retained Earnings Totals 2,700 21,600 54,100 5,400 72,000 35,300 $114,200 $112,700 During January 2021, the following transactions occur: 1. January 2 Provide services to customers for cash, $24,800. 2. January 6 Provide services to customers on account, $63,900. 3. January 15 Write off accounts receivable as uncollectible, $900. 4. January 20 Pay cash for salaries, $28,000. 5. January 22 Receive cash on accounts receivable, $62,400. 6. January 25 Pay cash on accounts payable, $4, 150. 7. January 30 Pay cash for utilities during January, $10,600. The following information is available on January 31, 2021. 8. At the end of January, $3,600 of accounts receivable are past due, and the company estimates that 25% of these accounts will not be collected. Of the remaining accounts receivable, the company estimates that 5% will not be collected. The note receivable of $13,000 is considered fully collectible and therefore is not included in the estimate of uncollectible accounts. 9. Supplies at the end of January total $740. 10. Accrued interest revenue on notes receivable for January, Interest is expected to be received each December 31 11. Unpaid salaries at the end of January are $25,500. 8. At the end of January, $3,600 of accounts receivable are past due, and the company estimates that 25% of these accounts will not be collected. Or the remaining accounts receivable, the company estimates that 5% will not be collected. The note receivable of $13,000 is considered fully collectible and therefore is not included in the estimate of uncollectible accounts. 9. Supplies at the end of January total $740. 10. Accrued interest revenue on notes receivable for January. Interest is expected to be received each December 31. 11. Unpaid salaries at the end of January are $25,500. 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 adjusting entries on January 31, 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 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. ces Regement General Journal > Check my 11. Unpaid salaries at the end of January are $25,500. 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 1 Provide services to customers for cash, $24,800. 2 Provide services to customers on account, $63,900. 3 Write off accounts receivable as uncollectible, $900. 4 Pay cash for salaries, $28,000. 5 Receive cash on accounts receivable, $62,400. Credit 6 Pay cash on accounts payable, $4,150. 7 Pay cash for utilities during January, $10,600. 8 At the end of January, $3,600 of accounts receivable are Note : - journal entry has been entered 11. Unpaid salaries at the end of January are $25,500. 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 require in the first account field.) View transaction list 8 > 13 At the end of January, $3,600 of accounts receivable are past due, and the company estimates that 25% of these accounts will not be collected. Of the remaining accounts receivable, the company estimates that 5% will not be collected. The note receivable of $13,000 is considered fully collectible and therefore is not included in the estimate of uncollectible accounts. 9 Supplies at the end of January total $740. Credit 10 Accrued interest revenue on notes receivable for January. Interest is expected to be received each December 31. 11 Unpaid salaries at the end of January are $25,500. Note : - journal entry has been entered 14 !!! 11. Unpaid salaries at the end of January are $25,500. General Journal General Ledger Income Statement Trial Balance Requirement 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 receivable, the company estimates that 5% will not be collected. The note receivable of $13,000 is considered fully collectible and therefore is not included in the estimate of uncollectible accounts. ences 9 Supplies at the end of January total $740. 10 Accrued interest revenue on notes receivable for January. Interest is expected to be received each December 31. Credit 11 Unpaid salaries at the end of January are $25,500. 12 Record the closure revenue accounts. 13 Record the closure expense accounts. Note : = journal entry has been entered Check my work 10. Accrued interest revenue on notes receivable for January. Interest is expected to be received each December 31. 11. Unpaid salaries at the end of January are $25,500. Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Analysis Prepare an income statement for the period ended January 31, 2021. Choose the appropriate accounts to complete the company's income statement. The unadjusted, adjusted, or post-closing balances will appear for each account, based on your selection. Unadjusted - Dates: Jan 02 3 to: Jan 30 3D FAMILY FIREWORKS Income Statement For the Month Ended January 31, 2021 Revenues: Total revenues Expenses Total expenses Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Analysis Prepare a classified balance sheet as of January 31, 2021. Choose the appropriate accounts to complete the company's balance sheet. The unadjusted, adjusted, or post-closing balances will appear for each account, based on your selection. Unadjusted - Dates: Jan 02 to: Jan 30 3D FAMILY FIREWORKS Balance Sheet January 31, 2021 Assets Liabilities Current Assets: Current Liabilities: Total Current Liabilities 0 of 0 Total Liabilirsies Total Current Assets Long-term Assets Stockholders' Equity of 0 0 Total Stockholders' Equity Total Liabilities & Stockholders' Equity Total Assets $ S 9. Supplies at the end of January total $740. 10. Accrued interest revenue on notes receivable for January. Interest is expected to be received each December 31. 11. Unpaid salaries at the end of January are $25,500. Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Analysis Using the information from the requirements above, complete the 'Analysis' tab. (Enter your Accounts receivable turnover ratio in 1 decimal place and Ratio of allowance for uncollectible accounts in whole number.) Unadjusted - Dates: Jan 02 to: Jan 30 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.2 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 Alowance for Uncollectible Accounts to Accounts Receivable Should the company expect improving or worsening conditions? Improving Balance Sheet Exercise 7-36 (Algo) General Ledger Exercise (LO7-5, 7-6, 7-7, 7-9) On January 1, 2021, the general ledger of 3D Family Fireworks includes the following account balances: Credit Debit $ 22,600 11,700 $ 1,500 Accounts Cash Accounts Receivable Allowance for Uncollectible Accounts Supplies Notes Receivable (6#, due in 2 years) Land Accounts Payable Common Stock Retained Earnings Totals 2,700 21,600 54,100 5,400 72,000 35,300 $114,200 $112,700 During January 2021, the following transactions occur: 1. January 2 Provide services to customers for cash, $24,800. 2. January 6 Provide services to customers on account, $63,900. 3. January 15 Write off accounts receivable as uncollectible, $900. 4. January 20 Pay cash for salaries, $28,000. 5. January 22 Receive cash on accounts receivable, $62,400. 6. January 25 Pay cash on accounts payable, $4, 150. 7. January 30 Pay cash for utilities during January, $10,600. The following information is available on January 31, 2021. 8. At the end of January, $3,600 of accounts receivable are past due, and the company estimates that 25% of these accounts will not be collected. Of the remaining accounts receivable, the company estimates that 5% will not be collected. The note receivable of $13,000 is considered fully collectible and therefore is not included in the estimate of uncollectible accounts. 9. Supplies at the end of January total $740. 10. Accrued interest revenue on notes receivable for January, Interest is expected to be received each December 31 11. Unpaid salaries at the end of January are $25,500. 8. At the end of January, $3,600 of accounts receivable are past due, and the company estimates that 25% of these accounts will not be collected. Or the remaining accounts receivable, the company estimates that 5% will not be collected. The note receivable of $13,000 is considered fully collectible and therefore is not included in the estimate of uncollectible accounts. 9. Supplies at the end of January total $740. 10. Accrued interest revenue on notes receivable for January. Interest is expected to be received each December 31. 11. Unpaid salaries at the end of January are $25,500. 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 adjusting entries on January 31, 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 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. ces Regement General Journal > Check my 11. Unpaid salaries at the end of January are $25,500. 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 1 Provide services to customers for cash, $24,800. 2 Provide services to customers on account, $63,900. 3 Write off accounts receivable as uncollectible, $900. 4 Pay cash for salaries, $28,000. 5 Receive cash on accounts receivable, $62,400. Credit 6 Pay cash on accounts payable, $4,150. 7 Pay cash for utilities during January, $10,600. 8 At the end of January, $3,600 of accounts receivable are Note : - journal entry has been entered 11. Unpaid salaries at the end of January are $25,500. 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 require in the first account field.) View transaction list 8 > 13 At the end of January, $3,600 of accounts receivable are past due, and the company estimates that 25% of these accounts will not be collected. Of the remaining accounts receivable, the company estimates that 5% will not be collected. The note receivable of $13,000 is considered fully collectible and therefore is not included in the estimate of uncollectible accounts. 9 Supplies at the end of January total $740. Credit 10 Accrued interest revenue on notes receivable for January. Interest is expected to be received each December 31. 11 Unpaid salaries at the end of January are $25,500. Note : - journal entry has been entered 14 !!! 11. Unpaid salaries at the end of January are $25,500. General Journal General Ledger Income Statement Trial Balance Requirement 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 receivable, the company estimates that 5% will not be collected. The note receivable of $13,000 is considered fully collectible and therefore is not included in the estimate of uncollectible accounts. ences 9 Supplies at the end of January total $740. 10 Accrued interest revenue on notes receivable for January. Interest is expected to be received each December 31. Credit 11 Unpaid salaries at the end of January are $25,500. 12 Record the closure revenue accounts. 13 Record the closure expense accounts. Note : = journal entry has been entered Check my work 10. Accrued interest revenue on notes receivable for January. Interest is expected to be received each December 31. 11. Unpaid salaries at the end of January are $25,500. Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Analysis Prepare an income statement for the period ended January 31, 2021. Choose the appropriate accounts to complete the company's income statement. The unadjusted, adjusted, or post-closing balances will appear for each account, based on your selection. Unadjusted - Dates: Jan 02 3 to: Jan 30 3D FAMILY FIREWORKS Income Statement For the Month Ended January 31, 2021 Revenues: Total revenues Expenses Total expenses Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Analysis Prepare a classified balance sheet as of January 31, 2021. Choose the appropriate accounts to complete the company's balance sheet. The unadjusted, adjusted, or post-closing balances will appear for each account, based on your selection. Unadjusted - Dates: Jan 02 to: Jan 30 3D FAMILY FIREWORKS Balance Sheet January 31, 2021 Assets Liabilities Current Assets: Current Liabilities: Total Current Liabilities 0 of 0 Total Liabilirsies Total Current Assets Long-term Assets Stockholders' Equity of 0 0 Total Stockholders' Equity Total Liabilities & Stockholders' Equity Total Assets $ S 9. Supplies at the end of January total $740. 10. Accrued interest revenue on notes receivable for January. Interest is expected to be received each December 31. 11. Unpaid salaries at the end of January are $25,500. Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Analysis Using the information from the requirements above, complete the 'Analysis' tab. (Enter your Accounts receivable turnover ratio in 1 decimal place and Ratio of allowance for uncollectible accounts in whole number.) Unadjusted - Dates: Jan 02 to: Jan 30 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.2 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 Alowance for Uncollectible Accounts to Accounts Receivable Should the company expect improving or worsening conditions? Improving Balance Sheet