Mico Chip Computer Corporation
Mico Chip Computer Corporation
Net Sales
11,062
11,933
9,181
6,141
8,334
9,167
Year to Year Growth
-23.1%
-33.1%
35.7%
Micro Chip Computer Corporation
Calculations for determining year-to-year percentage annual growth
(2001) 11,062-11,933=-871
-871/11,062=-0.078= 7.8%
(2002) 11,933-9,181=2,752
2,752/11,933=0.2306= -23.1%
(2003) 9,181-6,141=3,040
3,040/9,181=0.3311= -33.1%
(2004) 6,141-8,334=-2,193
-2,193/6,141=-0.357= 35.7%
Finding 10% increase in sales (Target Revenue Figure)
(2005) 8,334*1.1=9,167
8,334-9167=-833
-8,33/8334=-.0999= 10%
Arriving at a target figure of $9,167 one can deduce that in 2005 that the company can meet its sales goal of +10% likely that the company would meet its sales goal of+10%. Looking at the sales growth overall one can see how the company has done over the past several years. Starting from the year 2000 till 2001, the sales grew by roughly 8%; the next two years showed a sharp decline that resulted from troubled economic times for the nation. Then in year five rose to exceed expectations. Year six shows good promise that the +10% annual revenue growth can be attained.
Micro Chip Computer Corporation Consolidated Statement
Consolidated Statement of Operations
Sales
8,334.00
10,000.80
Cost of Sales
5,458.00
65.5%
6549.60
65.5%
Gross Margin
2,876.00
34.5%
3451.20
34.5%
Operating Expenses
525.00
630.00
Selling General and Administrative
691.00
829.20
In Process R&D
Restructuring Cost
200.02
Total Operating expenses
1,216.00
14.6%
1659.22
16.6%
Operating Income
1,660.00
1791.98
17.9%
Total Income and Other Income Net
194.00
232.80
Income Before Provision For Income Taxes
1,854.00
22.2%
2,024.78
20.2%
Provision for Income taxes (15%)
278.10
303.72
Net Income
1,575.90
1,721.07
17.2%
Calculations for Pro Forma Statement
Sales 8,334+20%=10,000.80
Cost of Sales 5,458+20%=6,549.6
Gross Margin 10,000.80-6,549.6=3,451.2
R&D 525+20%=630
SG&A 691+20%=829.2
Restructuring Cost 10,000.80*2%=200.02
Total Operating Expenses 630+829.2+200.02=1,659.22
Operating Income 3,451.2-1,659.22=1,791.98
Total Income and Other Net Income 194+20%=232.80