SC_Excel2010_C3_L1a_JennaSicard_2

SC_Excel2010_C3_L1a_ - 6,877,820 8,402,925 10,266,210 12,542,666 15,323,908 Supplies 1,876,506 2,292,607 2,800,975 3,422,070 4,180,889 5,107,969

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

View Full Document Right Arrow Icon
SAM Projects Office 2010 SC EXCEL 2010 C3 L1a - Med Supply Online Warehouse DO NOT DELETE--> %(01EA3486D896CC2B-3E5108501C7C7E93)% Author Jenna Sicard %(01EA3486D896CC2B-3E5108501C7C7E93)% mhqqdvlfdug Note: Do not edit this sheet. If your name does not appear in cell B4, please download  a new copy of the start file from the SAM web site.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Med Supply Online Warehouse Six-Year Financial Projection 7-Feb-12 Sales 144,346,583  176,354,356  215,459,611  263,236,164  321,606,810  392,920,708  Cost of Goods 94,587,864  115,562,013  141,187,023  172,494,187  210,743,479  257,474,265  Gross Margin 49,758,719  60,792,342  74,272,588  90,741,978  110,863,331  135,446,443  Expenses Advertising 11,548,227  14,108,848  17,237,269  21,059,393  25,729,045  31,434,157  Maintenance 1,605,000  4,378,000  5,920,000  5,050,000  3,200,000  4,250,000  Rent 2,700,000  3,024,000  3,386,880  3,793,306  4,248,502  4,758,323  Salaries 24,538,919  29,980,240  36,628,134  44,750,148  54,673,158  66,796,520  Shipping  5,629,517 
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 6,877,820 8,402,925 10,266,210 12,542,666 15,323,908 Supplies 1,876,506 2,292,607 2,800,975 3,422,070 4,180,889 5,107,969 Web Services 250,000 287,500 330,625 380,219 437,252 502,839 Total Expenses 48,148,168 60,949,015 74,706,808 88,721,346 105,011,510 128,173,716 Operating Income 1,610,551 (156,673) (434,219) 2,020,632 5,851,820 7,272,727 Income Tax 724,748 0 0 909,284 2,633,319 3,272,727 Net Income 885,803 (156,673) (434,219) 1,111,347 3,218,501 4,000,000 Assumptions Units Sold in Prior Year 1,589,712 Unit Cost $59.50 Annual Sales Growth 25.50% Annual Price Decrease 2.65% Margin 34.47% Y e a r 1 2 3 4 5 6 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 (500,000) 0 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 4,500,000 Six-Year Net Income Projection...
View Full Document

This note was uploaded on 02/06/2012 for the course BUSA 1101 taught by Professor Staff during the Fall '11 term at Georgia Southern University .

Page1 / 3

SC_Excel2010_C3_L1a_ - 6,877,820 8,402,925 10,266,210 12,542,666 15,323,908 Supplies 1,876,506 2,292,607 2,800,975 3,422,070 4,180,889 5,107,969

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

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