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 DocumentRight 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 DocumentRight 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 DocumentRight 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.

This note was uploaded on 04/07/2011 for the course ISYS 100 taught by Professor Msexcell during the Winter '11 term at BYU.

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
Ask a homework question - tutors are online