Concept explainers
Compare the accounting cycle using receivable transactions (LO5–1, 5–3, 5–4, 5–5, 5–6, 5–7, 5–8)
On January 1, 2018, the general ledger of 3D Family Fireworks includes the following account balances:
Accounts | Debit | Credit |
Cash | $ 23.900 | |
13.600 | ||
Allowance for Uncollectible Accounts | $ 1.400 | |
Supplies | 2.500 | |
Notes Receivable (6%. due in 2 years) | 20.000 | |
Land | 77.000 | |
Accounts Payable | 7.200 | |
Common Stock | 96.000 | |
32,400 | ||
Totals | $137,000 | $137,000 |
During January 2018, the following transactions occur.
January 2 Provide services to customers for cash. $35,100.
January 6 Provide services to customers on account, $72,400.
January 15 Write off accounts receivable as uncollectible, $1,000.
January 20 Pay cash for salaries, $31,400.
January 22 Receive cash on accounts receivable, $70,000.
January 25 Pay cash on accounts payable, $5,500.
January 30 Pay cash for utilities during January, $13,700.
Required:
1. Record each of the transactions listed above.
2. Record
a. At the end of January, $5,000 of accounts receivable are past due, and the company estimates that 20% 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 $20,000 is considered fully collectible and therefore is not included in the estimate of uncollectible accounts.
b. Supplies at the end of January total $700.
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 $33,500.
3. Prepare an adjusted
4. Prepare an income statement for the period ended January 31, 2018.
5. Prepare a classified balance sheet as of January 31, 2018.
6. Record closing entries.
7. 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?
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?
1.
To record: Each of the transactions of Fireworks 3D.
Explanation of Solution
Date | Account Title and Explanation | Debit ($) | Credit ($) | |
January 2 | Cash | 35,100 | ||
Service revenue | 35,100 | |||
(To record the service provided for cash) | ||||
January 6 | Accounts receivable | 72,400 | ||
Service Revenue | 72,400 | |||
(To record the services provided on account ) | ||||
January 15 | Allowance for uncollectible accounts | 1,000 | ||
Accounts receivable | 1,000 | |||
(To record the writing-off uncollectible accounts) | ||||
January 20 | Salaries expense | 31,400 | ||
Cash | 31,400 | |||
(To record receipt of cash for salaries ) | ||||
January 22 | Cash | 70,000 | ||
Accounts receivable | 70,000 | |||
(To record receipt of cash on account) | ||||
January 25 | Accounts payable | 5,500 | ||
Cash | 5,500 | |||
(To record paying cash on account) | ||||
January 30 | Utilities expense | 13,700 | ||
Cash | 13,700 | |||
(To record utilities expenses paid) |
Table (1)
2.(a)
To record: Adjusting entry at the end of January for Allowance for uncollectible accounts.
Answer to Problem 5.21E
Journal entry for adjustment of Allowance for uncollectible accounts:
Date | Particulars | Debit | Credit | |
January 31 | Bad debt Expense (1) | 1,100 | ||
Allowance for uncollectible accounts | 1,100 | |||
(To record adjustment of allowance for uncollectible accounts) |
Table (2)
Explanation of Solution
- Bad debt expense is a component of stockholders’ equity and decreased it. So, debit bad debt expense for $1,100 and,
- Allowance for uncollectible accounts is a contra asset account and decreased it. So, credit allowance for uncollectible accounts for $1,100.
Working notes:
Calculation of Allowance for uncollectible accounts:
Calculation of remaining accounts receivable:
Calculation for estimation of uncollectible accounts:
(b)
To record: Adjustment of supplies expenses account.
Answer to Problem 5.21E
Journal entry for adjustment of supplies expenses account;
Date | Particulars | Debit | Credit | |
January 31 | Supplies Expense (4) | 1,800 | ||
Supplies | 1,800 | |||
(To record adjustment of supplies expense accounts) |
Table (3)
Explanation of Solution
- A supplies expense is an expense which is a component of stock holders equity and it decreases. Hence, debit the supplies expenses account with $1,800.
- A supply is an asset and it decreases. Hence, credit the supplies account with $1,800.
Working notes:
Calculation of adjustment for supplies:
(c)
To record: The adjustment of interest receivable.
Answer to Problem 5.21E
Date | Account Title and Explanation | Debit ($) | Credit ($) | |
January 31 | Interest receivable (5) | 100 | ||
Interest revenue | 100 | |||
(To record adjustment for accrued interest) |
Table (4)
Explanation of Solution
For Adjustment of interest revenue on January 31:
- Interest receivable is an asset and it increases. Hence debit the interest receivable
- Interest revenue is a component of stock holders’ equity and increased it. Hence credit the interest revenue.
Working notes:
Calculation of adjustment of interest revenue:
(d)
To record: Adjustment of unpaid salaries.
Answer to Problem 5.21E
Journal entry for adjustment of unpaid salaries account;
Date | Particulars | Debit | Credit | |
January 31 | Salaries Expense (4) | 33,500 | ||
Salaries payable | 33,500 | |||
(To record adjustment of salaries payable accounts) |
Table (5)
Explanation of Solution
For Adjustment of Unpaid salaries on January 31:
- Salaries expense is a expense which is a component of stock holders’ equity and it decreases. Hence, debit the salaries expenses account.
- Salaries payable is a liability and it increases. Hence, credit the salaries payable account.
3.
To Prepare: An adjusted trial balance as of January 31, 2018, after updating beginning balances for transactions during January in the requirement 1 and adjusting entries at the end of January in the requirement 2.
Answer to Problem 5.21E
Fireworks 3D | ||
Adjusted Trial Balance as of | ||
For the year January 31, 2018 | ||
Accounts | Debit ($) | Credit ($) |
Cash(6) | $78,400 | |
Accounts Receivable(7) | 15,000 | |
Interest Receivable(8) | 100 | |
Supplies(9) | 700 | |
Notes Receivable(10) | 20,000 | |
Land(11) | 77,000 | |
Allowance for Uncollectible Accounts(12) | $1,500 | |
Accounts Payable(13) | 1,700 | |
Salaries Payable(14) | 33,500 | |
Common Stock(15) | 96,000 | |
Retained Earnings(16) | 32,400 | |
Service Revenue(17) | 107,500 | |
Interest Revenue(18) | 100 | |
Supplies Expense(19) | 1,800 | |
Salaries Expense(20) | 64,900 | |
Utilities Expense(21) | 13,700 | |
Bad Debt Expense(22) | 1,100 | |
Total | $272,700 | $272,70 |
Table (6)
Explanation of Solution
Adjusted trial balance:
Adjusted trial balance is a summary of all the ledger accounts, and it contains the balances of all the accounts after the adjustment entries are journalized, and posted.
Working notes:
4.
To Prepare: An income statement for the period ended January 31, 2018 of Fireworks 3D.
Explanation of Solution
Fireworks 3D | ||
Income statement | ||
For the year ended January 31, 2018 | ||
Particulars | Amount ($) | Amount ($) |
Revenues: | ||
Service revenue | $107,500 | |
Interest revenue | 100 | |
Total revenues | 107,600 | |
Expenses: | ||
Supplies expense | 1,800 | |
Salaries expense | 64,900 | |
Utilities expense | 13,700 | |
Bad debt expense | 1,100 | |
Total expenses | 81,500 | |
Net income | $26,100 |
Table (7)
5.
To Prepare:A classified balance sheet as of January 31, 2018.
Answer to Problem 5.21E
Fireworks 3D | |||
Balance sheet | |||
January 31, 2018 | |||
Assets | Amount ($) | Liabilities | Amount ($) |
Cash | $78,400 | Accounts payable | $1,700 |
Accounts receivable | $15,000 | Salaries payable | 33,500 |
Less: Allowance | (1,500) | Total current liabilities | 35,200 |
Net accounts receivable | 13,500 | ||
Interest receivable | 100 | ||
Supplies | 700 | ||
Total current assets | 92,700 | Stockholders’ Equity | |
Common stock | 96,000 | ||
Notes receivable | 20,000 | Retained earnings (23) | 58,500 |
Land | 77,000 | Total stockholders’ equity | 154,500 |
Total assets | $189,700 | Total liabilities and stockholders’ equity |
$189,700 |
Table (8)
Explanation of Solution
Income statement:
This is the financial statement of a company which shows all the revenues earned and expenses incurred by the company over a period of time.
Working notes:
6.
To record: Closing entries of Fireworks 3D.
Answer to Problem 5.21E
Journal entry for closing revenue accounts of Fireworks 3D:
Date | Particulars | Debit | Credit | |
January 31, 2018 | Service Revenue | 107,500 | ||
Interest Revenue | 100 | |||
Retained Earnings | 107,600 | |||
(To record closing of revenue accounts) |
Table (9)
Journal entry for closing expense accounts of Fireworks 3D:
Date | Particulars | Debit ($) | Credit ($) | |
January 31, 2018 | Retained Earnings | 81,500 | ||
Supplies expense | 1,800 | |||
Salaries expense | 64,900 | |||
Utilities expense | 13,700 | |||
Bad debt expense | 1,100 | |||
(To record closing of expense accounts) |
Table (10)
Explanation of Solution
Classified balance sheet:
This is the financial statement of a company which shows the grouping of similar assets and liabilities under subheadings.
For closing revenue accounts of fireworks 3D:
- Service revenue is a component of stock holders’ equity and decreased it. So debit service revenue account.
- Interest revenue is a component of stock holders’ equity and decreased it. So debit the interest revenue.
- Retained earnings are a liability and increased it. So credit the retained earnings.
For closing expense accounts of fireworks 3D:
- Retained earnings are a liability and decreased it. So debit the retained earnings.
- Supplies expenses are an expense which is a component of stock holder’s equity and decreases it. So credit the supplies expense account.
- Salaries expenses are an expense which is a component of stock holder’s equity and decreases it. So credit the salaries expense account.
- Utilities expenses are an expense which is a component of stock holder’s equity and decreases it. So credit the utilities expense account.
- Bad debt expenses are an expense which is a component of stock holder’s equity and decreases it. So credit the bad debt expense account.
7.a.
To Calculate: The receivables turnover ratio for the month of January and if the industry average of the receivables turnover ratios for the month of January is 4.2 times and whether the company is collecting cash from customers more or less efficiently than other companies in the same industry.
Answer to Problem 5.21E
Determine the Receivables turnover ratio:
Explanation of Solution
Accounts receivable turnover ratio:
Accounts receivable turnover is a liquidity measure of accounts receivable in times, which is calculated by dividing the net credit sales by the average amount of net accounts receivables and it indicates the number of times the average amount of net accounts receivables collected during a particular period
Higher receivables turnover ratio is preferable, since the more number of times the average amount of net accounts receivables collected during a particular period is better.
Average collection period:
Average collection period refers to the way to express the efficiency measure. Average collection period of receivables are measured in terms of days. It indicates the average number of days required for collecting invoiced amounts from the customers and it determines the effectiveness of the companies’ credit policies and collectable efforts and lower average collection period is preferable.
Working notes:
Determine the average accounts receivable:
- A ratio of 5.1 gives that credit sales are about five times the average balance of accounts receivable.
- Fireworks 3D allow customers to purchase goods and services on account to boost companies revenues, Higher receivables turnover ratio is preferred typically because those credit sales also create a risk of the customer not paying.
Compared to the industry average receivables turnover ratio of 4.2 Fireworks 3D is collecting cash more efficiently from customers on credit sales.
b.
To Calculate: The ratio of allowance for uncollectible accounts to accounts receivable at the end of January and based on a comparison of this ratio to the same ratio at the beginning of January, and to see whether the company expect an improvement or worsening in cash collections from customers on credit sales.
Answer to Problem 5.21E
Determine the ratio at the end of January:
Explanation of Solution
In comparison the ratio at the beginning of January was 10.3% where,
- The allowance is lower in relation to accounts receivable at the end of the month indicating the Fireworks 3D expects an improvement in cash collections from customers.
Want to see more full solutions like this?
Chapter 5 Solutions
FINANCIAL ACCOUNTINGLL W/CONNECT >IC<
- On January 1, 2021, the general ledger of Big Blst Fireworks includes the following account balances: Debit $ 23, 300 Accounts Credit Cash Accounts Receivable Allowance for Uncollectible Accounts Inventory Land Accounts Payable Notes Payable (6%, due in 3 years) 48, e00 $ 4, 580 37,e00 72,100 28,900 37,8ee 63,0ne 39,eee Common Stack Retained Earnings Totals $172, 488 $172,480 The $37,000 beginning balance of inventory consists of 370 units, esch costing $100. During Janusry 2021, Big Blest Fireworks had the following inventory transactions: January 3 Purchase 1,688 units for $168,888 on account ($18s each). January 8 Purchase 1,78e units for $187, 800 on account ($118 cach). January 12 Purchase 1,88e units for $287, e00 on account ($115 cach). January 15 Return 135 of the units purchased on January 12 because of defects. January 19 Sell 5,2ee units on account for $788,eee. The cost of the units sold is deternined using a FIFO perpetual inventory systen. January 22 Receive $753, eee…arrow_forwardOn January 1, 2021, the general ledger of Big Blest Fireworks includes the following account balances: Accounts Debit Credit Cash $ 23, 308 Accounts Receivable Allowance for Uncollectible Accounts 48, B00 $ 4, 580 Inventory Land Accounts Payable Notes Payable (6%, due in 3 years) 37, e00 72,100 28,980 37,000 Comnon Stack Retained Earnings 63, eee 39,eee Totals $172,400 $172,400 The $37,000 beginning belance of inventory consists of 370 units, each costing S100. During Janusry 2021, Big Blast Fireworks had the following inventory transactions: January 3 Purchase 1,68e units for 168,088 on account ($10s cach). January 8 Purchase 1,78e units for $187, 880 on account ($110 cach). January 12 Purchase 1,88e units for $287,000 on account ($115 cach). January 15 Return 135 of the units purchased on 3anuary 12 because of defccts. January 19 Sell 5,2ee units on account for $788,8ee. The cost of the units sold is deternined using a FIFO perpetual inventory systen. January 22 Receive $753, eee…arrow_forward(Accounts receivable and uncollectible accounts) The following information relates to Bedford Company’s accounts receivable: Accounts receivable balance on December 31, 2023 $ 900,000Allowance for expected credit losses balance on December 31, 2023 55,000Credit sales made in 2024 5,800,000Collections from customers on account in 2024 4,900,000Accounts receivable written off in 2024 70,000Accounts previously written off that were recovered in 2024(not included in the collections above) 6,000After grouping its receivables by geographic region, the credit risk characteristic identified as being best for determining credit losses, and estimating the expected rate of credit losses for each group, the company estimates that the total expected credit losses at December 31, 2024, will be $80,000. The allowance account is to be adjusted accordingly. Required Calculate the ending balance in Accounts Receivable, as at December 31, 2024.Calculate the Allowance for Expected Credit…arrow_forward
- At December 1, 2021, Vaughn Company's accounts receivable balance was $1860. During December, Vaughn had credit revenues on account of $7080 and collected accounts receivable of $6070. At December 31, 2021, the accounts receivable balance is $850 credit. Ⓒ $850 debit Ⓒ $2870 debit. O $2870 credit.arrow_forwardAt what amount will accounts receivable be reported on the balance sheet if the gross receivable balance is $42,500 and the allowance for uncollectible accounts is estimated at 16% of gross receivables? Select one: a. $42,500 b. $35,700 c. $28,900 d. $6,800arrow_forwardwestigate Paragraph S a. Accounts receivable turnover b. Number of days' sales in receivables Accounts receivable, end of year Sales on account EX.17-09.ALGO - Accounts Receivable Analysis The following data are taken from the financial statements of Sigmon Inc. 1. Accounts receivable turnover F5 2. Number of days' sales in receivables 2013 F6 W6-Financial Ratio Analysis - Exercise #1.docx Q Search 20Y2 $182,600 $197,000 1,043,900 1,001,560 For 20Y2 and 20Y3, determine (1) the accounts receivable turnover and (2) the number of days' sales in receivables. Round answers to one decimal place. Assume a 365-day year. 20Y3 F7 20 8 18.3 F8 I Styles days F9 20Y1 $211,800 Days prt sc F10 20Y2 DALL home F11 W Days end F12 insertarrow_forward
- Required Information On January 1, 2024, the general ledger of TNT Fireworks includes the following account balances: Accounts Cash Debit Credit Accounts Receivable $ 58,800 25,200 Allowance for Uncollectible Accounts $ 2,300 Inventory 36,480 Notes Receivable (5%, due in 2 years) 13,200 Land 156,000 Accounts Payable Common Stock Retained Earnings 14,900 221,200 51,408 Totals $ 289,680 $ 289,600 During January 2024, the following transactions occur. January 1 Purchase equipment for $19,600. The company estimates a residual value of $1,608 and a six-year service life. January 4 Pay cash on accounts payable, $9,600. January 8 Purchase additional inventory on account, $83,980. January 15 Receive cash on accounts receivable, $22,100. January 19 Pay cash for salaries, $29,900. January 28 Pay cash for January utilities, $16,600. January 30 Firework sales for January total $221,000. All of these sales are on account. The cost of the units sold is $115,500. Information for adjusting entries: a.…arrow_forwardAt December 1, 2022, Swifty Corporation Accounts Receivable balance was $12770. During December, Swifty had credit sales of $34200 and collected accounts receivable of $27360. At December 31, 2022, the Accounts Receivable balance is $19610 credit $19610 debit $12770 debit $46970 debitarrow_forwardTB Problem 7-170 (Algo) Cordova, Incorporated, reported the following... Cordova, Incorporated, reported the following receivables in its December 31, 2023, year-end balance sheet: Current assets: Accounts receivable, net of $50,000 in allowance for uncollectible accounts Interest receivable Notes receivable Additional information: 1. The notes receivable account consists of two notes, a $100,000 note and a $280,000 note. The $100,000 note is dated October 31, 2023, with principal and interest payable on October 31, 2024. The $280,000 note is dated March 31, 2023, with principal and 8% interest payable on March 31, 2024. 2. During 2024, sales revenue totaled $2,100,000, $1,960,000 cash was collected from customers, and $39,000 in accounts receivable were written off. All sales are made on a credit basis. Bad debt expense is recorded at year-end by adjusting the allowance account to an amount equal to 8% of year-end gross accounts receivable. Required: 1. In addition to sales revenue,…arrow_forward
- Required Information On January 1, 2024, the general ledger of TNT Fireworks includes the following account balances: Accounts Cash Accounts Receivable Debit $ 58,800 25,200 Credit Allowance for Uncollectible Accounts $ 2,300 Inventory 36,400 Notes Receivable (5%, due in 2 years) 13,200 Land 156,000 Accounts Payable Common Stock 14,900 221,000 51,400 $ 289,600 $ 289,608 Retained Earnings Totals During January 2024, the following transactions occur. January 1 Purchase equipment for $19,680. The company estimates a residual value of $1,600 and a six-year service life. January 4 Pay cash on accounts payable, $9,600. January 8 Purchase additional inventory on account, $83,980. January 15 Receive cash on accounts receivable, $22,100. January 19 Pay cash for salaries, $29,980. January 28 Pay cash for January utilities, $16,500. January 38 Firework sales for January total $221,008. All of these sales are on account. The cost of the units sold is $115,580. Information for adjusting entries: a.…arrow_forwardCurrent Attempt in Progress At December 1, 2022, Tamarisk, Inc. Accounts Receivable balance was $17470. During December, Tamarisk had credit sales of $46800 and collected accounts receivable of $37440. At December 31, 2022, the Accounts Receivable balance is O $64270 debit O $17470 debit O $26830 credit O $26830 debit Save for Later Attempts: 0 of 1 used Submit Answerarrow_forwardSrivastava Co.'s Balance Sheet had the following line item: 12/31/2012| 12/31/2011 Accounts Receivable, net of allowances of $200 and $150, respectively $4,900 $4,100 What percentage of gross accounts receivable does Srivastava expect to be uncollectable as of 12/31/2012? 3.92% 4.08% 3.66% 3.53% 4.01% O O O O Oarrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education