Homework Help is Here – Start Your Trial Now!
Business
Accounting
Jan Feb ABC Company Monthly Income Statements Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total

Jan Feb ABC Company Monthly Income Statements Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total

Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
8th Edition
ISBN:9781305961883
Author:Carl Warren
Publisher:Carl Warren
Chapter4: Accounting For Retail Operations
Section: Chapter Questions
Problem 4.4MBA
See similar textbooks
icon
Related questions
Question
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. A. Rent expense is $1,000 per month. However, the landlord has indicated that rent will go up to $1,250 in the fourth quarter. B. Depreciation expense is $2,250 per month and does not change throughout the year. C. 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. d. 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. E.Interest expense is $500 per month. F. Income tax is 25% of operating income less interest expense.
Gross Sales % of Annual Sales Sales Returns & Allowances Net Sales Cost of Goods Sold Gross Margin Rent Expense Depreciation Expense Salaries Expense Utility Expense Operating Income Interest Expense Income Tax Expense Net Income ABC Company Monthly Income Statements Apr May Jun Jul Aug Sep Oct Nov $41,800 $43,890 $51,700 $61,600 $66,000 $78,100 $58,300 $58,300 $50,600 $40,700 $42,900 $34,100 $627,990 7.0% 7.3% 8.2% 9.7% 10.4% 12.3% 9.2% 9.2% 8.0% 6.4% 6.8% 5.4% 100.0% $418 $ 439 $ 517 $ 616 $ 660 $ 781 $ 583 $ 583 $ 506 $ 407 $ 429 $ 341 $ 6,280 Jan Feb Mar Dec Total 41,382 43,451 51,183 60,984 65,340 77,319 57,717 57,717 50,094 40,293 42,471 33,759 24,829 26,071 30,710 36,590 39,204 46,391 34,630 34,630 30,056 24,176 25,483 20,255 16,553 17,380 20,473 24,394 26,136 30,928 23,087 23,087 20,038 16,117 16,988 13,504 621,710 373,026 248,684
Transcribed Image Text:Gross Sales % of Annual Sales Sales Returns & Allowances Net Sales Cost of Goods Sold Gross Margin Rent Expense Depreciation Expense Salaries Expense Utility Expense Operating Income Interest Expense Income Tax Expense Net Income ABC Company Monthly Income Statements Apr May Jun Jul Aug Sep Oct Nov $41,800 $43,890 $51,700 $61,600 $66,000 $78,100 $58,300 $58,300 $50,600 $40,700 $42,900 $34,100 $627,990 7.0% 7.3% 8.2% 9.7% 10.4% 12.3% 9.2% 9.2% 8.0% 6.4% 6.8% 5.4% 100.0% $418 $ 439 $ 517 $ 616 $ 660 $ 781 $ 583 $ 583 $ 506 $ 407 $ 429 $ 341 $ 6,280 Jan Feb Mar Dec Total 41,382 43,451 51,183 60,984 65,340 77,319 57,717 57,717 50,094 40,293 42,471 33,759 24,829 26,071 30,710 36,590 39,204 46,391 34,630 34,630 30,056 24,176 25,483 20,255 16,553 17,380 20,473 24,394 26,136 30,928 23,087 23,087 20,038 16,117 16,988 13,504 621,710 373,026 248,684
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS