Answered step by step
Verified Expert Solution
Question
1 Approved Answer
On January 1, 2021, the general ledger of TNT Fireworks includes the following account balances: Credit Debit $ 60,700 29,000 $ 4,200 Accounts Cash Accounts
On January 1, 2021, the general ledger of TNT Fireworks includes the following account balances: Credit Debit $ 60,700 29,000 $ 4,200 Accounts Cash Accounts Receivable Allowance for Uncollectible Accounts Inventory Notes Receivable (5%, due in 2 years) Land Accounts Payable Common Stock Retained Earnings Totals 38,300 36,000 175,000 16,800 240,000 78,000 $ 339,000 $ 339,000 During January 2021, the following transactions occurred: January 1 Purchased equipment for $21,500. The company estimates a residual value of $3,500 and a five-year service life. January 4 Paid cash on accounts payable, $11,500. January 8 Purchased additional inventory on account, $102,900. January 15 Received cash on accounts receivable, $24,000 January 19 Paid cash for salaries, $31,800. January 28 Paid cash for January utilities, $18,500. January 30 Firework sales for January totaled $240,000. All of these sales were on account. The cost of the units sold was $125,000. The following information is available on January 31, 2021. a. Depreciation on the equipment for the month of January is calculated using the straight-line method. b. At the end of January, $5,000 of accounts receivable are past due, and the company estimates that 50% of these accounts will not be collected. Of the remaining accounts receivable, the company estimates that 2% will not be collected. The note receivable of $36,000 is considered fully collectible and therefore is not included in the estimate of uncollectible accounts. c. Accrued interest revenue on notes receivable for January. d. Unpaid salaries at the end of January are $34,600. e. Accrued income taxes at the end of January are $11,000. 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-8) assuming a perpetual FIFO inventory system. The transaction on January 30 requires two entries: one to record sales revenue and one to record cost of goods sold. 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 9-13). 3. Review the adjusted 'Trial Balance' as of January 31, 2021, in the 'Trial Balance' tab. 4. Prepare a multiple-step 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 14-15). 7. Using the information from the requirements above, complete the 'Analysis' tab. Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Analysis Using the information from the requirements above, complete the 'Analysis'. (Round final answers to 1 decimal place.) Analyze how well TNT Fireworks manages its assets: (a) Calculate the return on assets ratio for the month of January. If the average return on assets for the industry in January is 2%, is the company more or less profitable than other companies in the same industry? The return on assets ratio is: % The company is more profitable. (True or False) (b) Calculate the profit margin for the month of January. If the industry average profit margin is 4%, is the company more or less efficient at converting sales to profit than other companies in the same industry? The profit margin is: The company is more efficient at converting sales to profit. (True or False) c) Calculate the asset turnover ratio for the month of January. If the industry average asset turnover is 0.4 times per month, is the company more or less efficient at producing revenues with its assets than other companies in the same industry? The asset turnover ratio is: times The company is more efficient at producing revenues with its assets. (True or False) On January 1, 2021, the general ledger of TNT Fireworks includes the following account balances: Credit Debit $ 60,700 29,000 $ 4,200 Accounts Cash Accounts Receivable Allowance for Uncollectible Accounts Inventory Notes Receivable (5%, due in 2 years) Land Accounts Payable Common Stock Retained Earnings Totals 38,300 36,000 175,000 16,800 240,000 78,000 $ 339,000 $ 339,000 During January 2021, the following transactions occurred: January 1 Purchased equipment for $21,500. The company estimates a residual value of $3,500 and a five-year service life. January 4 Paid cash on accounts payable, $11,500. January 8 Purchased additional inventory on account, $102,900. January 15 Received cash on accounts receivable, $24,000 January 19 Paid cash for salaries, $31,800. January 28 Paid cash for January utilities, $18,500. January 30 Firework sales for January totaled $240,000. All of these sales were on account. The cost of the units sold was $125,000. The following information is available on January 31, 2021. a. Depreciation on the equipment for the month of January is calculated using the straight-line method. b. At the end of January, $5,000 of accounts receivable are past due, and the company estimates that 50% of these accounts will not be collected. Of the remaining accounts receivable, the company estimates that 2% will not be collected. The note receivable of $36,000 is considered fully collectible and therefore is not included in the estimate of uncollectible accounts. c. Accrued interest revenue on notes receivable for January. d. Unpaid salaries at the end of January are $34,600. e. Accrued income taxes at the end of January are $11,000. 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-8) assuming a perpetual FIFO inventory system. The transaction on January 30 requires two entries: one to record sales revenue and one to record cost of goods sold. 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 9-13). 3. Review the adjusted 'Trial Balance' as of January 31, 2021, in the 'Trial Balance' tab. 4. Prepare a multiple-step 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 14-15). 7. Using the information from the requirements above, complete the 'Analysis' tab. Requirement General Journal General Ledger Trial Balance Income Statement Balance Sheet Analysis Using the information from the requirements above, complete the 'Analysis'. (Round final answers to 1 decimal place.) Analyze how well TNT Fireworks manages its assets: (a) Calculate the return on assets ratio for the month of January. If the average return on assets for the industry in January is 2%, is the company more or less profitable than other companies in the same industry? The return on assets ratio is: % The company is more profitable. (True or False) (b) Calculate the profit margin for the month of January. If the industry average profit margin is 4%, is the company more or less efficient at converting sales to profit than other companies in the same industry? The profit margin is: The company is more efficient at converting sales to profit. (True or False) c) Calculate the asset turnover ratio for the month of January. If the industry average asset turnover is 0.4 times per month, is the company more or less efficient at producing revenues with its assets than other companies in the same industry? The asset turnover ratio is: times The company is more efficient at producing revenues with its assets. (True or False)
Step 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