(a)
A financial statement is the complete record of financial transactions that take place in a company, at a particular period of time. It provides important financial information like assets, liabilities, revenues and expenses of the company to its internal and external users. It helps them to know the exact financial position of the company.
Profitability ratios are the metrics used to measure the profit generating ability of a company for a specific period of time.
To Prepare: The multi-step income statement, retained earnings statement, and classified
(a)
Explanation of Solution
Prepare the multi-step income statement of W Departmental Store.
Multi-step Income Statement: A multiple step income statement refers to the income statement that shows the operating, and non-operating activities of the business, under separate head. In different steps of the multi-step income statement, principal operating activities are reported that starts from the record of sales revenue with all contra sales revenue account like sales returns, allowances and sales discounts.
W Departmental Store | ||
Income Statement | ||
For the Year Ended November 30, 2017 | ||
Particulars | Amount($) | Amount($) |
Sales revenue | 904,000 | |
Less: Sales returns and allowances | (20,000) | |
Net sales | 884,000 | |
Less: Cost of goods sold | (614,300) | |
Gross profit | 269,700 | |
Less: Operating expenses: | ||
Salaries and wages expenses | 117,000 | |
Depreciation expenses | 13,500 | |
Advertising expense | 33,500 | |
Freight-out | 6,200 | |
Insurance expense | 9,000 | |
Rent expense | 34,000 | |
Utilities expense | 10,600 | |
Total operating expenses | (223,800) | |
Income from operations | 45,900 | |
Add: Other revenues and gain: | ||
Gain on disposal of plant assets | 2,000 | |
Less: Other expenses and losses: | ||
Interest expense | (5,000) | |
Income before income taxes | 42,900 | |
Less: Income tax expense | (10,000) | |
Net income | 32,900 |
Table (1)
Prepare the retained earnings statement of W Departmental Store.
Retained Earnings Statement: This is a financial statement that shows the amount of net income retained by a company at a particular point of time for reinvestment, and to pay its debts, and obligations. It shows the amount of retained earnings that is not paid as dividends to shareholders.
W Departmental Store | |
Retained Earnings Statement | |
For the Year Ended November 30, 2017 | |
Details | Amount ($) |
Beginning Balance of Retained earnings | 14,200 |
Add: Net Income for the year | 32,900 |
Total Retained Earnings | 47,100 |
Less: Dividends | (12,000) |
Ending balance of Retained Earnings | 35,100 |
Table (2)
Prepare the classified balance sheet of W Departmental Store.
Classified Balance Sheet: This is a financial statement where the assets, liabilities, and
W Departmental Store | ||
Classified Balance Sheet | ||
As of November 30, 2017 | ||
Particulars | Amount ($) | Amount ($) |
Current assets: | ||
Cash | 8,000 | |
Accounts receivable | 17,200 | |
Inventory | 26,200 | |
Prepaid Insurance | 6,000 | |
Total current assets | 57,400 | |
Plant assets: | ||
Equipment | 157,000 | |
Less: | -68,000 | |
Total plant assets | 89,000 | |
Total assets | 146,400 | |
Liabilities and Stockholders’ equity | ||
Current liabilities: | ||
Accounts payable | 26,800 | |
Salaries and wages payable | 6,000 | |
Total current liabilities | 32,800 | |
Long-term liabilities: | ||
Notes payable | 43,500 | |
Total liabilities | 76,300 | |
Stockholders’ Equity: | ||
Common stock | 35,000 | |
Retained earnings | 35,100 | |
Total stockholders’ equity | 70,100 | |
Total liabilities and stockholders’ equity | 146,400 |
Table (3)
(b)
The gross profit rate and profit margin of W Departmental Store for 2017.
(b)
Explanation of Solution
Gross profit rate is the financial ratio that shows the relationship between the gross profit and net sales. Gross profit is the difference between the total revenues and cost of goods sold. It is calculated by using the following formula:
Calculate the gross profit rate.
Gross profit = $269,700 (Refer Table 1)
Net sales = $884,000 (Refer Table 1)
Profit margin measures the amount of net income earned from each dollar of sales revenue generated by a company. Thus, it shows the relationship between the net income and net sales. It is calculated by using the following formula:
Calculate the profit margin.
Net income = $32,900 (Refer Table 1)
Net sales = $884,000 (Refer Table 1)
Therefore, the gross profit rate and profit margin of W Departmental Store is 30.51% and 3.72% respectively.
(c)
To Calculate: The expected new net income, revised gross profit rate, and profit margin of W Departmental Store for 2017 if net sales are increased 15%, gross profit is increased by $40,443 and expenses are increased by $58,600.
(c)
Answer to Problem 5.4AP
Calculate the expected new net income.
New gross profit = $310,143 (1)
New expenses = $274,400 (2)
Calculate the revised gross profit rate.
New gross profit = $310,143 (1)
Expected net sales = $1,016,600 (3)
Calculate the revised profit margin.
Expected net income = $35,743 (a)
Expected net sales = $1,016,600 (3)
Working Notes:
Calculate the new gross profit.
Old gross profit = $269,700 (Refer Table 1)
Increased gross profit = $40,443
Calculate the new expenses.
Old expenses = $223,800 (Refer Table 1)
Increased expenses = $50,600
Calculate expected net sales.
Net sales = $884,000
Percentage increased = 15%
Therefore, the expected new net income, revised gross profit rate, and profit margin of W Departmental Store for 2017 are $35,743, 30.51% and 3.52% respectively.
Explanation of Solution
After increase in net sales by 15%, gross profit by $40,443 and expenses by $58,600 the profit margin decreased from 3.72% to 3.52%. However, the gross profit rate remain same in both of the cases.
The second plan presented by the marketing department, and human resource department of W Departmental Store has a merit in higher net sales, that results in higher net income of the company.
Want to see more full solutions like this?
Chapter 5 Solutions
Financial Accounting: Tools for Business Decision Making, 8th Edition
- Bad Debt Expense: Percentage of Credit Sales Method The Glass House, a glass and china store, sells nearly half its merchandise on credit. During the past 4 years, the following data were developed for credit sales and losses from uncollectible accounts: Required: 1. Calculate the loss rate for each year from 2016 through 2018. ( Note: Round answers to three decimal places.) 2. Determine whether there appears to be a significant change in the loss rate over time. 3. CONCEPTUAL CONNECTION If credit sales for 2020 are $400,000, determine what loss rate you would recommend to estimate bad debts. ( Note: Round answers to three decimal places.) 4. Using the rate you recommend, record bad debt expense for 2020. 5. CONCEPTUAL CONNECTION Assume that the increase in The Glass Houses sales in 2020 was largely due to granting credit to customers who would have been denied credit in previous years. How would this change your answer to Requirement 4? Describe a legitimate business reason why The Glass House would adopt more lenient credit terms. 6. CONCEPTUAL CONNECTION Using the data from 2016 through 2019, estimate the increase in income from operations in total for those 4 years assuming (a) the average gross margin is 25% and (b) 50% of the sales would have been lost if no credit was granted.arrow_forwardMartel Co. has 320,000 in Accounts Receivable on December 31, 20-1, the end of its first year of operations. The business is new, so it has no prior experience with uncollectible accounts. In Martels overall industry, the percentage of uncollectible accounts receivable is about 3%. For companies similar to Martel in size and operations, the percentage is about 5%. Martel decides to use the overall industry experience as the basis for its estimate of uncollectible accounts. Prepare the adjusting entry on December 31, 20-1 for Martel Co.s uncollectible accounts.arrow_forwardVo Manufacturing is the biggest snowmobile manufacturer in the world. It reported the following amounts in its financial statements (in millions): 2017 2018 Net Sales Revenue $ 4, 200 $ 3,660 Cost of Goods Sold 3,470 2,950 Average Inventory 430 370 Required: 1-a. Calculate the inventory turnover ratio for 2018 and 2017. 1-b. Calculate the average days to sell inventory for 2018 and 2017. 2. Did inventory turnover at Vo improve or decline in 2018? 3. Calculate the 2018 gross profit percentage. 4. The main competitor for Vo is Arctic Cat. Prior to being acquired by Textron, Incorporated, Arctic Cat reported its inventory turnover was 3.9 and its gross profit percentage was 4.5 percent. Why was Arctic Cat more likely than Vo to require a write-down for LCM/NRV? Complete this question by entering your answers in the tabs below. Req 1A Req 1B Req 2 Req 3 Req 4 Calculate the inventory turnover ratio for 2018 and 2017. (Round your answers to 1 decimal place.) Times per Year 2018 2017…arrow_forward
- I need help with using the direct method in E23.4. Plus, I'll add additional info in E23.3 to type. Accounts Receiv. decreased $360,000 during the year. Prepaid expenses increased $170,000 during the year. Accounts Pay. to suppliers of merchandise decreased $275,000 during the year. Accrued expenses payable decreased $100,000 during the year. Administrative expenses include Deprec. Exp. of $60,000.arrow_forwardDuring the month of April, Jeff's Seashell Store sold $35000 of inventory, with $25000 sold on credit and the remaining for cash. The business collected $15000 from the previous month's credit sales that excluded a bad debt of $750. The inventory sold was purchased at a cost of $21000. What was the total revenue recognised in the month of April? (Ignore GST for this question)A. None of the other answers B. 35,000 C. 34,250 D. 10,000 E. 50,000arrow_forwardThe Glass House, a glass and china store, sells nearly half its merchandise on credit. During the past 4 years, the following data were developed for credit sales and losses from uncollectible accounts: Required:1. Calculate the loss rate for each year from 2016 through 2018. (Note: Round answers to threedecimal places.)2. Determine whether there appears to be a significant change in the loss rate over time.3. CONCEPTUAL CONNECTION If credit sales for 2020 are $400,000, determine what loss rateyou would recommend to estimate bad debts. (Note: Round answers to three decimal places.)4. Using the rate you recommend, record bad debt expense for 2020.5. CONCEPTUAL CONNECTION Assume that the increase in The Glass House’s sales in2020 was largely due to granting credit to customers who would have been denied credit inprevious years. How would this change your answer to Requirement 4? Describe a legitimatebusiness…arrow_forward
- On 1st Nov 2020, a business had inventory of $380,000. During the month, sales totalled $650,000 and purchases $480,000. On 30th Nov 2020 a flood destroyed some of the inventory. The undamaged goods in inventory were valued at $220,000. The business operates with a standard gross profit margin of 25%.Based on this information, what is the cost of the inventory destroyed in the flood?arrow_forwardCapetown Company began operations on January 1, 2010. Capetown has found that its estimated bad debt expense has been consistently higher than actual bad debts. Management proposes lowering the percentage from 3% of credit sales to 2%. Credit sales for 2011 totaled P5,000,000, and accounts written off as uncollectible during 2011 totaled P550,000. What is the bad debt expense for 2011?arrow_forwardThe following information is taken from the financial statements of Down Home Deli for the last three years. The owner, John Walton is quite pleased to see that his sales are growing steadily. 2018 2017 2016 Sales $ 61,500 $ 50,400 $ 42,000 Cost of goods sold 27,670 21,170 16,800 Operating income 7,530 6,050 4,620 Net income 3,075 4,030 2,940 Instructions: (a) Calculate gross profit margin, profit margin, and profit margin using operating income. (b) Comment on whether the Deli is, in fact, doing better over the three years as John believes.arrow_forward
- The Glass House, a glass and china store, sells nearly half its merchandise on credit. During the past 4 years, the following data were developed for credit sales and losses from uncollectible accounts: Year of Sales Credit Sales Losses fromUncollectible Accounts* 2016 $200,000 12,700 2017 203,000 13,297 2018 213,000 13,313 2019 225,000 18,563 Total $841,000 $57,873 *Losses from uncollectible accounts are the actual losses related to sales of that year (rather than write-offs of that year). Required: 1. Calculate the loss rate for each year from 2016 through 2019. Round your answers to three decimal places. Year Loss Rate 2016 2017 2018 2019arrow_forwardIn its first year of operations, Cloudbox has credit sales of $210,000. Its year-end balance in accounts receivable is $11,000, and the company estimates that $2,000 of its accounts receivable is uncollectible.a. Prepare the year-end adjusting entry to estimate bad debts expense.b. Prepare the current assets section of Cloudbox’s classified balance sheet assuming Inventory is $24,500, Cash is $16,500, and Prepaid Rent is $3,250. Note: The company reports Accounts receivable, net on the balance sheet.arrow_forwardAt the end of the current year, the accounts receivable account has a debit balance of $1,191,000 and sales for the year total $13,510,000. a. The allowance account before adjustment has a debit balance of $16,100. Bad debt expense is estimated at 1/2 of 1% of sales. b. The allowance account before adjustment has a debit balance of $16,100. An aging of the accounts in the customer ledger indicates estimated doubtful accounts of $51,500. c. The allowance account before adjustment has a credit balance of $8,600. Bad debt expense is estimated at 3/4 of 1% of sales. d. The allowance account before adjustment has a credit balance of $8,600. An aging of the accounts in the customer ledger indicates estimated doubtful accounts of $71,400. Determine the amount of the adjusting entry to provide for doubtful accounts under each of the assumptions (a through d) listed above. 51,450 X a. b. $ C. $ d. $ Feedbackarrow_forward
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning