{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

100-7 - Profit Statement Division A Revenue Cost of Goods...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Profit Statement Division A Revenue $250,000 Cost of Goods Sold $162,500 Margin $87,500 Administrative Expenses $37,500 Interest $5,000 Income Before Taxes $45,000 Taxes $15,750 Net Income $29,250
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Profit Statement Division B Revenue $105,000 Cost of Goods Sold $63,000 Margin $42,000 Administrative Expenses $10,500 Interest $3,500 Income Before Taxes $28,000 Taxes $8,400 Net Income $19,600
Background image of page 2
Profit Statement Division C Revenue $400,000 Cost of Goods Sold $280,000 Margin $120,000 Administrative Expenses $80,000 Interest $7,000 Income Before Taxes $33,000 Taxes $13,200 Net Income $19,800
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Summary Statement Income Tax Table June 4, 2005 Division A Division B Division C Tax Rate: Revenue $250,000 $105,000 $400,000 Income 2003 Cost of Goods Sold $162,500 $63,000 $280,000 $0 15% Margin $87,500 $42,000 $120,000 $10,000 20% Administrative Expenses $37,500 $10,500 $80,000 $20,000 24% Interest $5,000 $3,500 $7,000 $30,000 29% Income Before Taxes $45,000 $28,000 $33,000 $40,000 33% Taxes $17,969 $8,131 $11,580 $50,000 35% Net Income $27,032 $19,869 $21,420 Rate 40% 29% 35% Year: Column Number: Days until Taxes Due: Net Income by Division Division A $29,250 Division B $19,600 Division C $19,800 Total All Divisions $48,850 =VLOOKUP(B8,$F$4:$J$9,$H$12)
Background image of page 4
2004 2005 2006 17% 18% 20% 22% 24% 27% 26% 29% 32% 32% 35% 39% 36% 40% 44% 39% 42% 47% 2005 4 -2899 =DATE(2003,4,30)-TODAY()
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Employees Page 6 Employee Data Date 4/7/2011 Sales Performance: SSN
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.
  • Winter '11
  • MSExcell
  • Division, Revenue, manager Position sales rep Position Manager Position sales rep Position Manager Position sales rep Position Manager Position sales rep, Position Manager Sales Rep Sales Rep Manager Sales Rep Sales Rep Sales Rep Manager Sales Rep, Taxes Taxes Net

{[ snackBarMessage ]}

Page1 / 8

100-7 - Profit Statement Division A Revenue Cost of Goods...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon bookmark
Ask a homework question - tutors are online