43 Review Problems

Chapter 4 Review Problems

1. ABC Company has the following data for its monthly sales. Complete the % of Annual Sales row.The monthly income statement of ABC company shows gross sales by month: January - $40,000; February - $42,000; March - $47,000; April - $56,000; May - $60,000; June - $71,000; July - $53,000; August - $53,000; September - $46,000; October - $37,000; November - $39,000; and December - $31,000. The total sales for the year is $575,000.

 

2. Using the same data as in Problem 1, assume that ABC Company expects a 10% increase in sales in the coming year (10% more than the $575,000 it had in the past year). Prepare its sales forecast, assuming the company breaks its sales down by month using the same percentages as the actual sales from the past year, which you calculated in the first problem.

Monthly income statement of ABC company shows empty cells for gross sales on a monthly basis and the percentage of annual sales.

 

3. ABC Company anticipates its sales being a bit lower than normal in January and February of the coming year due to major road construction on the street where it is located, which will draw away foot traffic from the store. The company anticipates that this will reduce its sales in these two months by 5%. Use the information from Problems 1–2 to update the sales forecast.

4.ABC Company’s cost of goods sold last year was 60%. It anticipates that this will be the same in the coming year. Its sales returns and allowances are small, normally 1% of sales. Use the information from Problems 1–3 to estimate the company’s sales returns and allowances, net sales, and cost of goods sold and calculate its gross margin.

 

The monthly income statement of ABC company shows gross sales by month: January - $41,800; February - $43,890; March - $51,700; April - $61,600; May - $66,000; June - $78,100; July - $58,300; August - $58,300; September - $50,600; October - $40,700; November - $42,900; and December - $34,100. The total sales for the year is $627,990. It also shows the % of annual sales by month: January – 7%; February – 7.3%; March – 8.2%; April – 9.7%; May – 10.4%; June – 12.3%; July – 9.2%; August – 9.2%; September – 8.0%; October – 6.4%; November – 6.8%; and December – 5.4%. The total percentage for all of the months equals 100%. There are blank cells for every month for the sales returns and allowances, net sales, cost of goods sold, and gross margin.

 

5. Use the partial income statement generated in Problem 4 along with the following additional information to complete ABC Company’s forecasted income statement in Excel.

  1. Rent expense is $1,000 per month. However, the landlord has indicated that rent will go up to $1,250 in the fourth quarter.
  2. Depreciation expense is $2,250 per month and does not change throughout the year.
  3. Salaries expense is $1,500 per month and is expected to go up by 10% in the second half of the year, when a new compensation plan will be implemented.
  4. Utilities expense is $5,000 for the entire year and should be allocated to each month based on that month’s percentage of annual sales.
  5. Interest expense is $500 per month.
  6. Income tax is 25% of operating income less interest expense.

The monthly income statement of ABC company shows gross sales by month: January - $41,800; February - $43,890; March - $51,700; April - $61,600; May - $66,000; June - $78,100; July - $58,300; August - $58,300; September - $50,600; October - $40,700; November - $42,900; and December - $34,100. The total sales for the year is $627,990. It also shows the % of annual sales by month: January – 7%; February – 7.3%; March – 8.2%; April – 9.7%; May – 10.4%; June – 12.3%; July – 9.2%; August – 9.2%; September – 8.0%; October – 6.4%; November – 6.8%; and December – 5.4%. The total percentage for all of the months equals 100%. The sales returns and allowances by month are: January - $418; February - $439; March - $517; April - $616; May - $660; June - $781; July - $583; August - $583; September - $506; October - $407; November - $429; December - $341. The total sales returns and allowances for the year are $6,280. The net sales by month are: January - $41,382; February - $43451; March - $51,183; April - $60,984; May - $65,340; June - $77,319; July - $57,717; August - $57,717; September - $50,094; October - $40,293; November - $42,471; December - $33,759. The total net sales for the year are $621,710. The cost of goods sold by month are: January - $24,829; February - $26,071; March - $30,710; April - $36,590; May - $39,204; June - $46,391; July - $34,630; August - $34,630; September - $30,056; October - $24,176; November - $25,483; and December - $20,255. The total cost of goods sold for the year are $373,026. The gross margin by month are: January - $16,553; February - $17,380; March - $20,473; April - $24,394; May - $26,136; June - $30,928; July - $23,087; August - $23,087; September - $20,038; October - $16,117; November - $16,988; and December - $13,504. The total gross margin for the year is $248,684. There are blank cells for each month for rent expense, depreciation expense, salaries expense, utility expense, operating income, interest expense, income tax expense, and net income.

 

Attribution:

This chapter is from “Principles of Finance”  https://openstax.org/books/principles-finance/pages/1-why-it-matters by Dahlquist and Knight. This book is licensed under the CC-BY 4.0 license. 2022 OpenStax.

License

Icon for the Creative Commons Attribution-ShareAlike 4.0 International License

PPSC FIN 2010 Principles of Finance by Cristal Brietbeil and Eric Schroeder is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License, except where otherwise noted.

Share This Book