Lab 3-1 Salioto Auto Parts Eight-Year Fianancial Projection part3-1

Lab 3-1 Salioto Auto Parts Eight-Year Fianancial Projection part3-1

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

View Full Document Right Arrow Icon
Fausto Morales  ISAM 3033.06 William Saad Assumptions Units Sold in Prior Year    11,459,713 Unit Cost  $13.40  Annual Sales Growth     7.45% Annual Price Decrease   5.25% Margin   39.25% Salioto Auto Parts Eight-Year Financial Projection 25-Sep-10 Sales  252,773,916  257,346,281  262,001,353  266,740,630  271,565,635  276,477,918  281,479,057  286,570,662  Cost of Goods 153,560,154  156,337,865  159,165,822  162,044,933  164,976,123  167,960,335  170,998,527  174,091,677  Gros Margin 99,213,762  101,008,415  102,835,531  104,695,697  106,589,512  108,517,583  110,480,530  112,478,985  Expenses Advertising  32,861,109  33,455,516  34,060,676  34,676,782  35,304,033  35,942,629  36,592,777  37,254,686  Maintenance 1,905,000  5,550,000  4,250,000  5,050,000  2,500,000  3,150,000  2,945,000  3,560,000  Rent 1,700,000  1,870,000  2,057,000  2,262,700  2,488,970  2,737,867  3,011,654 
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 3,312,819 Salaries 56,242,196 57,259,547 58,295,301 59,349,790 60,423,354 61,516,337 62,629,090 63,761,972 Supplies 3,791,609 3,860,194 3,930,020 4,001,109 4,073,485 4,147,169 4,222,186 4,298,560 Total Expenses 96,499,914 101,995,258 102,592,997 105,340,382 104,789,841 107,494,002 109,400,707 112,188,037 Operating Income 2,713,848 (986,843) 242,534 (644,684) 1,799,671 1,023,581 1,079,823 290,947 Income Taxes 1,085,539 0 97,014 0 719,868 409,432 431,929 116,379 Net Income 1,628,309 (986,843) 145,520 (644,684) 1,079,803 614,149 647,894 174,568 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 1 2 3 4 5 6 7 8 (1,000,000) (500,000) 0 500,000 1,000,000 1,500,000 2,000,000 Eight-Year Net Income Projection...
View Full Document

This note was uploaded on 09/23/2010 for the course ISAM 3033 taught by Professor Staff during the Spring '08 term at UH Clear Lake.

Page1 / 2

Lab 3-1 Salioto Auto Parts Eight-Year Fianancial Projection part3-1

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

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