際際滷

際際滷Share a Scribd company logo
Assumption
Unit Sold in Prior Year    11,459,713
Unit Cost                       13.40
Annual Sales Growth            4.50%
Annual Price Decrease          4.25%
Margin                        39.25%



SALIOTO AUTO PARTS
EIGHT-YEAR FINANCIAL PROJECTION
                            1




                                          2




                                                        3




                                                                        4




                                                                                     5




                                                                                                    6
                            ar




                                          ar




                                                        ar




                                                                        ar




                                                                                     ar




                                                                                                    ar
                          Ye




                                        Ye




                                                      Ye




                                                                      Ye




                                                                                   Ye




                                                                                                  Ye
Sales                     252,773,916 252,922,421 253,071,013 253,219,692           253,360,459 253,517,313
Cost of goods             153,560,154 153,650,371 1,537,406,403 153,830,963         153,921,339 154,011,767
Gross Margin               99,213,762 99,272,050     99,330,373 99,388,729           99,447,120 99,505,545
Expenses
Advertising                32,861,109 32,880,415        32,899,732 32,919,060        23,938,400 32,957,751
Maintenance                 1,905,000 5,550,000          4,250,000 5,050,000          2,500,000 3,150,000
Rent                        1,700,000 1,870,000          2,057,000 2,262,700          2,488,970 2,737,867
Salaries                   56,242,196 56,275,239        56,308,300 56,341,382        56,374,482 56,407,602
Supplies                    3,791,609 3,793,836          3,796,065 3,798,295          3,800,527 3,872,760
Toal Expenses              96,499,914 100,369,490       99,311,097 100,371,437       89,102,379 99,125,980




Operating Income            2,713,848    -1,097,439          19,275     -982,708      1,344,741      449,566
Income Taxes                1,085,539             0           7,710            0        537,897      179,826
Net Income                  1,628,309    -1,097,439          11,565     -982,708        806,845      269,739
6




         7




                       8
  ar




         ar




                       ar
Ye




       Ye




                     Ye




       253,666,254, 253,815,283
       154,102,249 154,192,784
        99,564,005 99,622,499

        32,977,113 32,996,487
         2,945,000 3,560,000
         3,011,654 3,312,819
        56,440,742 56,473,900
         3,804,994 3,807,229
        99,179,503 100,150,435




           384,503     -527,937
           153,801            0
           238,702     -527,937

More Related Content

Similar to chap3lab1 (20)

XLSX
Castillon chap3 lab1
celeste_castillon
XLSX
Sryhsdhxdfgh
johnmagto
XLSX
Campus clothiers semmiannual financial projection
brittneytaylor
XLSX
3 d pie chart
brittneytaylor
PPT
011707 Sales Meeting
Mike Thornburg
PPT
Cognizant Technology Solutions - Revenue Analysis & Operating Metrics 2006-2011
Rajesh Prabhakar
PDF
autozone AZO_2007AR
finance46
PDF
advance auto parts 2003_ar
finance48
PDF
advance auto parts 2003_ar
finance48
PDF
BBBY_AR2007_proxy_v3
finance44
PDF
bed bath&beyond BBBY_AR2007_proxy_v3
finance44
PDF
Twin Cities Market Update June 2012
mgootee1
PDF
Twin cities market update june 2012
mgootee1
PDF
ct_065963
finance21
PDF
parker hannifin ar2000
finance25
PDF
parker hannifin _ar2000
finance25
PDF
Janet miller - Leveraging The Music City Brand
NAMA
PDF
lowe's Annual Report2002
finance5
PDF
bed bath&beyond AnnualReport2006
finance44
PDF
bed bath&beyond AnnualReport2006
finance44
Castillon chap3 lab1
celeste_castillon
Sryhsdhxdfgh
johnmagto
Campus clothiers semmiannual financial projection
brittneytaylor
3 d pie chart
brittneytaylor
011707 Sales Meeting
Mike Thornburg
Cognizant Technology Solutions - Revenue Analysis & Operating Metrics 2006-2011
Rajesh Prabhakar
autozone AZO_2007AR
finance46
advance auto parts 2003_ar
finance48
advance auto parts 2003_ar
finance48
BBBY_AR2007_proxy_v3
finance44
bed bath&beyond BBBY_AR2007_proxy_v3
finance44
Twin Cities Market Update June 2012
mgootee1
Twin cities market update june 2012
mgootee1
ct_065963
finance21
parker hannifin ar2000
finance25
parker hannifin _ar2000
finance25
Janet miller - Leveraging The Music City Brand
NAMA
lowe's Annual Report2002
finance5
bed bath&beyond AnnualReport2006
finance44
bed bath&beyond AnnualReport2006
finance44

More from landiza (16)

XLSX
chap3lab2
landiza
XLSX
chap3lab2
landiza
XLSX
chap3lab3
landiza
XLSX
chap3lab2
landiza
XLSX
Landiza chap2 lab3
landiza
XLSX
Landiza chap1 lab3
landiza
XLSX
Landiza chap1 lab3
landiza
XLSX
Landiza chap1 lab2
landiza
XLSX
Landiza chap2 lab1
landiza
XLSX
Landiza cha1 lab2
landiza
XLSX
Landiza chap2 lab1
landiza
XLSX
Landiza chap2 lab2
landiza
XLSX
Landizachap1 lab2
landiza
XLSX
Excel suzette
landiza
XLSX
Excel suzette1
landiza
DOCX
Envelop long
landiza
chap3lab2
landiza
chap3lab2
landiza
chap3lab3
landiza
chap3lab2
landiza
Landiza chap2 lab3
landiza
Landiza chap1 lab3
landiza
Landiza chap1 lab3
landiza
Landiza chap1 lab2
landiza
Landiza chap2 lab1
landiza
Landiza cha1 lab2
landiza
Landiza chap2 lab1
landiza
Landiza chap2 lab2
landiza
Landizachap1 lab2
landiza
Excel suzette
landiza
Excel suzette1
landiza
Envelop long
landiza
Ad

chap3lab1

  • 1. Assumption Unit Sold in Prior Year 11,459,713 Unit Cost 13.40 Annual Sales Growth 4.50% Annual Price Decrease 4.25% Margin 39.25% SALIOTO AUTO PARTS EIGHT-YEAR FINANCIAL PROJECTION 1 2 3 4 5 6 ar ar ar ar ar ar Ye Ye Ye Ye Ye Ye Sales 252,773,916 252,922,421 253,071,013 253,219,692 253,360,459 253,517,313 Cost of goods 153,560,154 153,650,371 1,537,406,403 153,830,963 153,921,339 154,011,767 Gross Margin 99,213,762 99,272,050 99,330,373 99,388,729 99,447,120 99,505,545 Expenses Advertising 32,861,109 32,880,415 32,899,732 32,919,060 23,938,400 32,957,751 Maintenance 1,905,000 5,550,000 4,250,000 5,050,000 2,500,000 3,150,000 Rent 1,700,000 1,870,000 2,057,000 2,262,700 2,488,970 2,737,867 Salaries 56,242,196 56,275,239 56,308,300 56,341,382 56,374,482 56,407,602 Supplies 3,791,609 3,793,836 3,796,065 3,798,295 3,800,527 3,872,760 Toal Expenses 96,499,914 100,369,490 99,311,097 100,371,437 89,102,379 99,125,980 Operating Income 2,713,848 -1,097,439 19,275 -982,708 1,344,741 449,566 Income Taxes 1,085,539 0 7,710 0 537,897 179,826 Net Income 1,628,309 -1,097,439 11,565 -982,708 806,845 269,739
  • 2. 6 7 8 ar ar ar Ye Ye Ye 253,666,254, 253,815,283 154,102,249 154,192,784 99,564,005 99,622,499 32,977,113 32,996,487 2,945,000 3,560,000 3,011,654 3,312,819 56,440,742 56,473,900 3,804,994 3,807,229 99,179,503 100,150,435 384,503 -527,937 153,801 0 238,702 -527,937