Scribd Logo
Upload

Welcome to Scribd!

  • 31 views

    Samar Rahul

    Uploaded by

    Samar Sarna
    This document contains an economic-financial plan and investment proposal for a hotel network in northern Italy. It includes projections for room investments and costs from 2010-2017 for hotels in 5 cities - Bergamo, Firenze, Genova, Monza, and Verona. The plan estimates revenues, operating costs, earnings before taxes, and property revaluations for the network over this period. It concludes that the implementation of this hotel investment plan is sustainable and the investment can be remunerated based on the financial analysis and projections provided in the document.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPT, PDF, TXT or read online from Scribd

    Samar Rahul

    Uploaded by

    Samar Sarna
    31 views10 pages
    This document contains an economic-financial plan and investment proposal for a hotel network in northern Italy. It includes projections for room investments and costs from 2010-2017 for hotels in 5 cities - Bergamo, Firenze, Genova, Monza, and Verona. The plan estimates revenues, operating costs, earnings before taxes, and property revaluations for the network over this period. It concludes that the implementation of this hotel investment plan is sustainable and the investment can be remunerated based on the financial analysis and projections provided in the document.

    Original Description:

    hotel industry

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PPT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains an economic-financial plan and investment proposal for a hotel network in northern Italy. It includes projections for room investments and costs from 2010-2017 for hotels in 5 cities - Bergamo, Firenze, Genova, Monza, and Verona. The plan estimates revenues, operating costs, earnings before taxes, and property revaluations for the network over this period. It concludes that the implementation of this hotel investment plan is sustainable and the investment can be remunerated based on the financial analysis and projections provided in the document.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    31 views10 pages

    Samar Rahul

    Uploaded by

    Samar Sarna
    This document contains an economic-financial plan and investment proposal for a hotel network in northern Italy. It includes projections for room investments and costs from 2010-2017 for hotels in 5 cities - Bergamo, Firenze, Genova, Monza, and Verona. The plan estimates revenues, operating costs, earnings before taxes, and property revaluations for the network over this period. It concludes that the implementation of this hotel investment plan is sustainable and the investment can be remunerated based on the financial analysis and projections provided in the document.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    You are on page 1of 10

    ECONOMIC-FINANCIAL PLAN

    INVESTMENT PLAN

    room number

    Bergamo
    project
    120

    Firenze
    Project
    120

    Genova
    project
    100

    Monza
    project
    120

    Verona
    project
    100

    sq.m./room Ratio *

    33

    34

    35

    34

    33

    33,8

    total sq.m. *

    3.960

    4.080

    3.500

    4.080

    3.300

    18.920

    sq.m.cost *
    room cost
    total cost

    2.500
    82.500
    9.900.000

    2.700
    91.800
    11.016.000

    2.500
    87.500
    8.750.000

    2.500
    85.000
    10.200.000

    2.400
    79.200
    7.920.000

    2.520
    85.200
    47.786.000

    * Estimation

    Total
    560

    HOTEL DATA (Start Up and Established Stage)

    Bergamo

    Occupancy
    Average Rate
    Fequency Index
    (per Room )

    Average Rate
    (Breakfast)

    Average Rev.
    (Bar)

    Average Rate
    (Restaurant)

    Firenze

    Monza

    Establ. Start up
    72%
    52%
    79
    71

    Genova

    Start up
    52%
    73

    Establ.
    65%
    77

    Start up
    55%
    75

    Establ. Start up
    65%
    56%
    75
    73

    1,15

    1,15

    1,4

    1,4

    1,15

    1,15

    25

    26

    25

    26

    Verona

    Establ.
    64%
    77

    Start up
    54%
    72

    Establ.
    70%
    76

    1,25

    1,25

    1,3

    1,3

    25

    26

    25

    26

    25

    26

    INCOME STATEMENT - Revenues

    Total
    investment

    2010

    2011

    2012

    2013

    2014

    2015

    2016

    2017

    BG-FI

    BG-FI-GE-MZ

    BG-FI-GEMZ-VR

    BG-FI-GEMZ-VR

    BG-FI-GEMZ-VR

    BG-FI-GEMZ-VR

    BG-FI-GEMZ-VR

    BG-FI-GEMZ-VR

    Revenues
    Room
    revenues

    3.153.998

    6.542.642

    8.762.525

    9.559.823

    10.333.457

    11.232.721

    11.190.702

    11.470.470

    % on Total
    revenues

    73,8%

    73,9%

    74,1%

    74,4%

    74,5%

    74,7%

    74,6%

    74,6%

    Rest/Bar
    revenues

    933.482

    1.956.595

    2.627.487

    2.864.999

    3.098.068

    3.366.793

    3.352.909

    3.436.732

    % on Total
    revenues

    21,9%

    22,1%

    22,2%

    22,3%

    22,3%

    22,4%

    22,4%

    22,4%

    Parking
    revenues

    183.960

    352.590

    429.240

    429.240

    433.839

    442.769

    453.838

    465.184

    % on Total
    revenues

    4,3%

    4,0%

    3,6%

    3,3%

    3,1%

    2,9%

    3,0%

    3,0%

    TOT. REV.

    4.271.440

    8.851.826

    11.819.252

    12.854.062

    13.865.364

    15.042.283

    14.997.450

    15.372.386

    INCOME STATEMENT - Costs


    Operating Costs
    Personnel Costs

    2010
    1.222.660

    2011
    2.512.669

    2012
    3.327.277

    2013
    3.589.240

    2014
    3.791.120

    2015
    3.983.801

    2016
    4.033.799

    2017
    4.134.644

    % on Total Revenues

    28,6%

    28,4%

    28,2%

    27,9%

    27,3%

    26,5%

    26,9%

    26,9%

    Room Costs

    94.620

    196.279

    262.876

    286.795

    310.004

    336.982

    335.721

    344.114

    % on Room Revenues

    3,0%

    3,0%

    3,0%

    3,0%

    3,0%

    3,0%

    3,0%

    3,0%

    Raw Material Costs

    205.366

    430.451

    578.047

    630.300

    681.575

    740.695

    737.640

    756.081

    % on Bar/Rest. Revenues

    22,0%

    22,0%

    22,0%

    22,0%

    22,0%

    22,0%

    22,0%

    22,0%

    Commercial Costs

    40.000

    100.000

    165.000

    192.000

    211.050

    216.326

    221.734

    227.278

    % on Total Revenues

    0,9%

    1,1%

    1,4%

    1,5%

    1,5%

    1,4%

    1,5%

    1,5%

    103.025

    105.601

    108.241

    110.947

    0,9%

    0,9%

    0,8%

    0,8%

    0,7%

    Administrattion
    Costs
    % on Total Revenues

    Maintenance Costs

    40.000
    0,9%

    50.000

    81.000

    113.720
    0,8%

    243.541

    116.563
    0,8%

    110.000

    175.000

    212.250

    231.806

    237.601

    % on Total Revenues

    1,2%

    1,2%

    1,5%

    1,7%

    1,7%

    1,6%

    1,6%

    1,6%

    249.630

    Energy Costs

    200.000

    440.000

    600.000

    646.500

    669.663

    686.404

    703.564

    721.153

    % on Total Revenues

    4,7%

    5,0%

    5,1%

    5,0%

    4,8%

    4,6%

    4,7%

    4,7%

    Other Costs

    427.144

    885.183

    1.181.925

    1.285.406

    1.386.536

    1.504.228

    1.499.745

    1.537.239

    % on Total Revenues

    10%

    10%

    10%

    10%

    10%

    10%

    10%

    10%

    Comfort Costs

    85.429

    177.037

    236.385

    257.081

    277.307

    300.846

    299.949

    307.448

    % on Total Revenues

    2,0%

    2,0%

    2,0%

    2,0%

    2,0%

    2,0%

    2,0%

    2,0%

    Total Costs

    2.365.219

    4.932.618

    6.629.535

    7.205.173

    7.667.302

    8.117.830

    8.189.415

    8.394.150

    INCOME STATEMENT Operating Results

    G.O.P.

    2010
    1.897.030

    2011
    3.899.966

    2012
    5.168.226

    2013
    5.619.176

    2014
    6.170.366

    2015
    6.893.442

    2016
    6.777.516

    2017
    6.946.954

    % on Total Revenues

    44%

    44%

    44%

    44%

    45%

    46%

    45%

    45%

    % on Investiment

    9%

    10%

    11%

    12%

    13%

    14%

    14%

    15%

    Leasing
    % on Investiment
    Pre-Opening Exp.

    898.218

    2.111.980

    2.992.936

    3.371.506

    220.000

    100.000

    4.136.065
    8,7%
    0

    4.066.510
    8,5%
    0

    4.168.172
    8,7%

    240.000

    3.702.219
    7,7%
    0

    EBITDA
    % on Investiment

    598.812
    3%

    1.407.986
    4%

    1.995.290
    4%

    2.247.670
    5%

    2.468.146
    5%

    2.757.377
    6%

    2.711.006
    6%

    2.778.782
    6%

    Tot. Depreciation
    Financial Charges

    873.818
    76.800

    1.668.061
    147.200

    2.008.061
    179.200

    2.008.061
    179.200

    2.008.061
    179.200

    2.008.061
    179.200

    2.008.061
    179.200

    1.768.061
    179.200

    Earnings before
    Taxes

    -351.806

    -407.274

    -191.970

    60.410

    280.886

    570.116

    523.746

    831.521

    NETWORK REVALUATION

    2010

    2011
    2012
    BG-FI-GE- BG-FI-GEMZ
    MZ-VR
    39.866.000 47.786.000

    2013
    BG-FI-GEMZ-VR
    47.786.000

    2014
    BG-FI-GEMZ-VR
    47.786.000

    2015
    2016
    2017
    BG-FI-GE- BG-FI-GE-MZ- BG-FI-GE-MZMZ-VR
    VR
    VR
    47.786.000 47.786.000
    47.786.000

    627.480

    1.214.804

    1.470.024

    1.477.681

    1.477.910

    1.477.917

    1.477.918

    1.477.918

    2.994.060

    7.039.932

    9.976.452

    11.238.352

    12.340.731

    13.786.885

    13.555.032

    13.893.908

    3.621.540
    24.537.540

    8.254.736 11.446.477
    48.120.736 59.232.477

    12.716.032
    60.502.032

    13.818.642
    61.604.642

    15.264.802
    63.050.802

    15.032.950
    62.818.950

    15.371.825
    63.157.825

    BG-FI
    Investiment Value
    Property
    Revaluation
    (Investiment * 3%)
    Network
    Management
    Revaluation
    (EBITDA * 5)
    Total Revaluation
    New Network Value

    20.916.000

    CONCLUSIONS

    After a detailed analysis of the Investment Plan and the Network


    Income Statement, we can conclude that the implementation of this
    project is sustainable and that the investment can be remunerated.

    References:
    Comune di Bergamo
    Provincia di Bergamo
    Dedalonews
    Aeroporto di Bergamo
    Wikipedia
    Regione Lombardia
    Provincia di Monza
    Bergamo Congress Center
    Aica
    Comune di Genova
    Provincia di Verona
    Fiera di Genova
    Aerporto di Genova
    Comune di Verona
    Aeroporto di Verona

    Verona Fiere
    Comune di Firenze
    Firenze Fiera
    Monza e Brianza in Rete
    Brianzabusiness
    Google Maps
    Viamichelin
    Hotelmonza
    Bestwestern
    UNA Hotel
    Regione Veneto
    Trail Liguria
    NH Hotels
    Comune di Monza
    Regione Liguria

    Thank you!
    CONTACT
    Master in Tourism Management
    Universit IULM
    Via Carlo Bo, 1 - 20143 - Milano
    Tel. +39 (0)2 891412815; Fax +39 (0)2 891412814
    website: www.mtm.iulm.it
    Mail: master.turismo@iulm.it

    10

    You might also like