Docstoc

xlsx file

Document Sample
xlsx file Powered By Docstoc
					9432b52a-4328-40ff-bdc7-193b6faf05c1.xlsx -- FIRST HALF                                                                      6/1/2013 -- 10:25 AM




               2013 First Half Budget
               (Euro)

               INCOME                   JAN               FEB             MAR         APR             MAY             JUN
               Bilkent Translations      €     150,000     €    130,000    €  150,000 €     200,000    €    190,000    €    185,000
               METU Translations         €     100,000     €     90,000    €  120,000 €     150,000    €    120,000    €    125,000
               Other Translations        €      50,000     €     40,000    €   50,000 €      60,000    €     40,000    €     40,000
               Total Income              €     300,000     €    260,000   €   320,000 €     410,000   €     350,000    €    350,000

               % OF INCOME FOR
               ADVERTISING                          10%

               EXPENSES
               Advertising              €       30,000 €         26,000 €       32,000 €     41,000 €        35,000 €        35,000
               Salary                   €      140,000 €        140,000 €      140,000 €    140,000 €       140,000 €       140,000
               Lease                    €       45,000 €         45,000 €       45,000 €     45,000 €        45,000 €        45,000
               Miscellaneous            €       20,000 €         20,000 €       20,000 €     20,000 €        20,000 €        20,000
               Overhead                 €       45,000 €         45,000 €       45,000 €     45,000 €        45,000 €        45,000
               Total Expenses           €      280,000 €        276,000 €      282,000 €    291,000 €       285,000 €       285,000

               PROFIT                   €       20,000 €        (16,000) €      38,000 €    119,000 €        65,000 €        65,000




Erin Maloney                                                                                                                          Page 1 of 6
9432b52a-4328-40ff-bdc7-193b6faf05c1.xlsx -- FIRST HALF                                                                        6/1/2013 -- 10:25 AM




                    2013 First Half Budget
                    (Euro)
                                                                                     6-MONTH
                    INCOME                     TOTAL           AVERAGE              MINIMUM        MAXIMUM      PROPORTION
                    Bilkent Translations        €    1,005,000 €    167,500         €    130,000   €    200,000          51%
                    METU Translations           €      705,000 €    117,500         €     90,000   €    150,000          35%
                    Other Translations          €      280,000 €     46,667         €     40,000   €     60,000          14%
                    Total Income                €    1,990,000 €    331,667         €    260,000   €    410,000         100%

                    % OF INCOME FOR
                    ADVERTISING

                    EXPENSES
                    Advertising                 €           199,000   €    33,167   €     26,000   €     41,000         12%
                    Salary                      €           840,000   €   140,000   €    140,000   €    140,000         49%
                    Lease                       €           270,000   €    45,000   €     45,000   €     45,000         16%
                    Miscellaneous               €           120,000   €    20,000   €     20,000   €     20,000          7%
                    Overhead                    €           270,000   €    45,000   €     45,000   €     45,000         16%
                    Total Expenses              €         1,699,000   €   283,167   €    276,000   €    291,000        100%

                    PROFIT                      €          291,000 €       48,500 €       (16,000) €    119,000




Erin Maloney                                                                                                                            Page 2 of 6
9432b52a-4328-40ff-bdc7-193b6faf05c1.xlsx -- SECOND HALF                                                                      6/1/2013 -- 10:25 AM




               2013 Second Half Budget
               (Euro)

               INCOME                    JUL            AUG            SEP             OCT             NOV             DEC
               Bilkent Translations       €    150,000                  €    150,000    €    200,000    €    190,000    €    185,000
               METU Translations          €    100,000                  €    120,000    €    150,000    €    120,000    €    125,000
               Other Translations         €     50,000                  €     50,000    €     60,000    €     40,000    €     40,000
               Total Income               €    300,000 €          -     €    320,000   €     410,000   €     350,000   €     350,000

               % OF INCOME FOR
               ADVERTISING                        10%

               EXPENSES
               Advertising               €      30,000 €          -   €       32,000 €        41,000 €        35,000 €        35,000
               Salary                    €     140,000 €      140,000 €      140,000 €       140,000 €       140,000 €       140,000
               Lease                     €      45,000 €       45,000 €       45,000 €        45,000 €        45,000 €        45,000
               Miscellaneous             €      20,000 €       20,000 €       20,000 €        20,000 €        20,000 €        20,000
               Overhead                  €      45,000 €       45,000 €       45,000 €        45,000 €        45,000 €        45,000
               Total Expenses            €     280,000 €      250,000 €      282,000 €       291,000 €       285,000 €       285,000

               PROFIT                    €     20,000 €       (250,000) €     38,000 €       119,000 €        65,000 €        65,000




Erin Maloney                                                                                                                           Page 3 of 6
9432b52a-4328-40ff-bdc7-193b6faf05c1.xlsx -- SECOND HALF                                                                   6/1/2013 -- 10:25 AM




           2013 Second Half Budget
           (Euro)
                                                                           6-MONTH                                     12-MONTH
           INCOME                    TOTAL                 AVERAGE        MINIMUM        MAXIMUM      PROPORTION         TOTAL
           Bilkent Translations       €      875,000        €   175,000   €    150,000   €    200,000          51%   € 1,880,000
           METU Translations          €      615,000        €   123,000   €    100,000   €    150,000          36%   € 1,320,000
           Other Translations         €      240,000        €    48,000   €     40,000   €     60,000          14%   €     520,000
           Total Income               €    1,730,000        €   288,333   €        -     €    410,000         100%   € 3,720,000

           % OF INCOME FOR
           ADVERTISING

           EXPENSES
           Advertising                €        173,000     €     28,833   €        -     €     41,000         10%    €     372,000
           Salary                     €        840,000     €    140,000   €    140,000   €    140,000         50%    €   1,680,000
           Lease                      €        270,000     €     45,000   €     45,000   €     45,000         16%    €     540,000
           Miscellaneous              €        120,000     €     20,000   €     20,000   €     20,000          7%    €     240,000
           Overhead                   €        270,000     €     45,000   €     45,000   €     45,000         16%    €     540,000
           Total Expenses             €      1,673,000     €    278,833   €    250,000   €    291,000        100%    €   3,372,000

           PROFIT                     €         57,000 €          9,500 €      (250,000) €    119,000                €    348,000




Erin Maloney                                                                                                                         Page 4 of 6
9432b52a-4328-40ff-bdc7-193b6faf05c1.xlsx -- SECOND HALF                                                          6/1/2013 -- 10:25 AM




               2013 Second Half Budget
               (Euro)

               INCOME                    JUL           AUG         SEP         OCT          NOV             DEC


                                                       December 2013 Budgeted Income

                                                             11%


                                                                         53%         Bilkent Translations
                                                 36%
                                                                                     METU Translations
                                                                                     Other Translations




Erin Maloney                                                                                                               Page 5 of 6
9432b52a-4328-40ff-bdc7-193b6faf05c1.xlsx -- SECOND HALF                                                   6/1/2013 -- 10:25 AM




           2013 Second Half Budget
           (Euro)
                                                                      6-MONTH                          12-MONTH
           INCOME                    TOTAL                 AVERAGE   MINIMUM    MAXIMUM   PROPORTION     TOTAL




Erin Maloney                                                                                                        Page 6 of 6

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:5/27/2013
language:Unknown
pages:6
tang shuming tang shuming
About