Products

About

©2019 88306.com


Phuket Doll Phuket Beach Hotel

Topics: WACC, Período de retorno, Contrato de compraventa Pages: 8 (620 words) Published: April 12, 2015
EXHIBIT TN-1
Decrease in net
Patronage factor room revenue 25%
Tiempo Proy (Años)
Costo de Renovacion (Bath)
WACC
Reparacion/Mantenimiento (Bath)
Patronage factor
Año

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 4

 
 
 
 
 
 770,000.00
10.75%

 
 
 
 
 
 
 
 10,000.00

 

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 0.50

 

0
0.25
0.5
0.75
1

0%
6.25%
12.50%
18.75%
25.00%

0

1

2

Net room revenue
Reduction in net room revenue

12.50%

Año

13,200,000.00
1,650,000.00

0

1

Ingresos Renta

Depresiacion
Increase
 in
 repairs
 &
 maintenance
Reduction
 in
 net
 room
 revenue
 (a)
Incremental
 operating
 income
 (b),
 (
 c
 )
Tasa
 (30%)
NOPAT
Depresiacion
Less
 Capital
 Expenditure

770,000.00
1

FCF

2

2,040,000.00
192,500.00
10,000.00
1,650,000.00
187,500.00
56,250.00

2,040,000.00
192,500.00
10,000.00
1,683,000.00
154,500.00
46,350.00

131,250.00
192,500.00
192,500.00

108,150.00
192,500.00
192,500.00

323,750.00

300,650.00

770,000.00

-­‐770,000.00
 

Tasa Descuento

Desc
 FCF

13,464,000.00
1,683,000.00

1.00

0.9029

0.82

-­‐770,000.00
 

292,325.06

245,117.17

1
323,750.00
292,325.06

2
300,650.00
245,117.17

-477,674.94
N/A
N/A

-232,557.77
N/A
N/A

Proyecto 1
12%

Tasa
Año
FCF
Desc FCF
FCF Acumu.
Periodo de Retorno
Periodo de Retorno Descontado
IRR
MIRR

0
-770,000.00
-770,000.00
N/A
N/A

23.20%
17.78%

NPV
Prof Index
Interes Anual =[(1+k)n - 1]/k
EAA
ROI

214,849.48
1.28
3.12
68,882.36
0.64
Profitability Index

Opcion 1
Lease

Opcion 2
Construccion

1.28

1.22
Net present Value

Opcion 1
Lease

Opcion 2
Construccion

214849

373,043.31
Equivalent Annual Annuity

Opcion 1
Lease

Opcion 2
Construccion

3.12

4.26

EXHIBIT TN-2

Tiempo Proy (Años)
Inversion
Renovacion (Bath)
Equipamento (Bath)
Interes
WACC
3

4

14,137,000.00
1,767,125.00
3

14,844,000.00
1,855,500.00
4

2,142,000.00
192,500.00
10,000.00
1,767,125.00
172,375.00
51,712.50

2,249,100.00
192,500.00
10,000.00
1,855,500.00
191,100.00
57,330.00

120,662.50
192,500.00
192,500.00

133,770.00
192,500.00
192,500.00

313,162.50

326,270.00

0.74

0.66

230,535.89

216,871.36

Incremento Ventas (De Ventas)
Food and beverage cost (De Ventas)
Salario ( DE Ventas)
Gastos Operativos (De Ventas)
Reparaciones/Mantenimiento (Bath)
Annual capital expenditure
Patronage factor

Año
Net room revenue
Reduction in net room revenue
Año
Ventas
Food and beverage cost
Other operating expenses

Depreciation
 expenses
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Phuket Beach Hotel Essay

    ...To: Michael Campbell, General Manager, Phuket Beach Hotel From: Albert, Andy, Becca, Chris, & Derek Consulting Date: June 14, 2011 Re: Valuation of Potential Karaoke Pub Projects Thank you for retaining AaBCD Consulting in the valuation of your future capital improvement project. There are two mutually exclusive capital improvement projects under consideration: lease under-utilized space to an unrelated third party, Planet Karaoke Pub, or invest greater capital to open and manage your own nightclub, Beach Karaoke Pub. Using the predominant valuation methods, we have analyzed the relevant quantitative and qualitative data over their useful lives. In our assessment, we discuss the strengths and weaknesses of each approach as well as their relative weights in determining the financial viability of each project. There are three underlying assumptions driving our calculations: 1) a 10.75% discount rate, 2) a 10% guest room erosion rate, and 3) the omission of irrelevant staffing costs (16% of sales) due to long-term salary contracts. We have determined that while both options are profitable, Beach is more so. However, before a final decision is made, more research into the qualitative aspects of these undertakings needs to be done; community footprint impacts and room revenue erosion rates must also be examined in more detail. Relevant Economic Benefits (1) In order to assess the viability of...

    Read More
    1569 Words 5 Pages
  • Essay on phuket

    ...Phuket Beach Hotel Case Analysis Phuket Beach Hotels (PBH) management has been approached by Planet Karaoke Pub (PKP) to lease a vacant space within the hotel. Management is intrigued by the offer because the space is currently not being used. Due to the recent success of karaoke pubs management is also considering creating a pub which they would call Beach Karaoke Pub (BKP). Finally, there is a possibility that the best option will be to seek an entirely different user type where the Karaoke Pub crowd may alienate 25% of the hotel patrons with young children. This paper seeks to use capital budgeting analysis tools; net present value, internal rate of return, equivalent annual annuity and profitability index to definitively say which project has the best financial viability. The data used to generate the key decision metrics were provided by PBH management and are as follows. Planet Karaoke Pub -Four-year lease, monthly 170,000.00 baht for the first 2 years and 5% increase 2 additional years -Upfront costs to PBH range between 770,000.00 baht and 1,000,000.00 baht with zero salvage -Pro-rata allocation of the common area maintenance fee is 55,000 baht -10,000.00 baht will be charged for common area maintenance fees Beach Karaoke Pub -Up-front investment will range between...

    Read More
    1206 Words 14 Pages
  • Essay on Phuket Beach Hotel Case Studey

    ...000 -770,000 323,750 292,325 300,650 245,117 154,500 -46,350 108,150 192,500 Payback Period Discounted Payback Period Average Return on Investment NPV PI IRR Equivalent Annuity 2.46 yrs 3.01 yrs 39% 165,017 baht 1.21 21% 52,906 baht Working Notes 1. Rental income = baht 170,000*12 for the years 1 and 2 and increase by 5% in the years 3 and 4 2. Straight line depreciation 3. Patronage factor taken as 0.5 i.e. 12.5% reduction in net room revenue 4. Taxes at 30% 5. Base capital cost = baht 770,000 6. WACC = 10.75% Yr. 3 Yr. 4 2,142,000 2,142,000 -192500 -192500 -10,000 -10,000 -1,767,125 -1,855,500 172,375 -51,713 120,662 192,500 84,000 -25,200 58,800 192,500 313,162 230,536 251,300 167,039 Analysis of Cash Flow - Beach Karaoke Pub figures in baht Yr. 0 Sales less less less less less Food and Beverage Cost Other Operating Expenses Depreciation Increase in repair and maintenance expenses Decrease in net room revenue Additional Operating Income less Taxes NOPAT add less Depreciation Capital Expenditure Operating Cash Flow Discounted Operating Cash Flow @ 10.75% Yr. 1 4,672,000 -1,168,000 -1,027,840 -283,333 -10,000 -1,650,000 532,827 -159,848 372,979 283,333 -283,333 372,979 336,775 Yr. 2 4,905,600 -1,226,400 -1,079,232 -283,333 -10,000 -1,683,000 623,635 -187,090 436,544 283,333 -283,333 436,544 355,911 -1,700,000 -1,700,000 -1,700,000 Payback Period Discounted Payback Period Average Return on Investment NPV PI IRR Equivalent...

    Read More
    1177 Words 4 Pages
  • Essay about Phuket Beach Resort

    ... 21,00,000 Beach Karaoke Club Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Revenue 46,72,000 49,05,600 51,50,880 54,08,424 56,78,845 59,62,787 Food and Bev 11,68,000 12,26,400 12,87,720 13,52,106 14,19,711 14,90,697 Other Operating Expenses 10,27,840 10,79,232 11,33,194 11,89,853 12,49,346 13,11,813 Depriciation-Equipment 3,50,000 3,50,000 3,50,000 3,50,000 3,50,000 3,50,000 Room Revenue Loss 16,50,000 16,83,000 17,67,125 18,55,500 18,92,500 19,30,375 Repair and Mantainance 10,000 10,000 10,000 10,000 10,000 10,000 EBT 4,66,160 5,56,968 6,02,841 6,50,965 7,57,288 8,69,902 Taxes 1,39,848 1,67,090 1,80,852 1,95,289 2,27,186 2,60,971 Net Income 3,26,312 3,89,878 4,21,989 4,55,675 5,30,102 6,08,932 Cash Flow (21,00,000) 3,26,312 3,89,878 4,21,989 4,55,675 5,30,102 6,08,932 DCF 2,94,638 3,17,864 3,10,649 3,02,887 3,18,156 3,29,994 IRR 7% MIRR 9% Payback-Discounted 6.75 Payback 5.11 NPV (2,25,811.82) (56,453) Capital Investment 8,00,000 Capital Investment-equipment 9,00,000 Total Capital 17,00,000...

    Read More
    939 Words 4 Pages
  • Phuket Beach Resort Essay

    ...Case Report : Phuket Beach Hotel Executive Summary Phuket Beach Hotel has space located on second floor of the main building which was underutilized. Planet Karaoke pub was expanding in Thailand and looking for a venue in patong beach area for setting up another outlet. Planet Karaoke Pub found unused space of the hotel most suitable for their new venture. The space at second floor reserved for the construction of new wing of the hotel which will take atleast two years. Phuket Beach hotel had two options. Option – 1 : Planet Karaoke pub offered to sign a four year lease agreement with the hotel for renting available space and offered 1,70,000 baht for the first two years and at 5% increment for next two years. |Assumptions | | | |Rental Income @170000*12 for first two years and 5% increase in next two years | |Straight line depreciation method | | | |Corporate tax @30% | | | |Base capital cost 1,000,000.00 | | | |Patronage factor :...

    Read More
    544 Words 4 Pages
  • Phuket Beach Analysis Essay

    ...Log In Sign Up Explore Phuket Beach Resort Case AnalysisGraduate School of BusinessDe La Salle University I.Statement of the Problem Should the management of Phuket Beach Resort accept the offer made by PlanetKaraoke Pub to set up an outlet inside the hotel or should the managementoperate a pub, Beach Karaoke Pub, by itself? II.Case Background Mike Campbell, General Manager of Phuket Beach Hotel is considering an offermade by Planet Karaoke Pub, a fast expanding company, which is looking for avenue in Patong beach area for setting up another outlet. The Board of Directorsof the establishment had previously rejected several old offers because it offerslow return on investment. The space was located on the second floor of the main building and was verymuch under-utilised. Planat Karaoke Pub offered to sign a four-year leaseagreement with the hotel for rending part of the unused space. It proposed topay:a.a monthly rental fee of 170,000 baht for the first two years; andb.thereafter, a 5% increment for the next two years.Planet Karaoke Pub required only 70% of the unused space measuring 3,000 sq.feet. This would allow the hotel to keep the remaining space for the creation of analley two years later.Mike Campbell is contemplating on creating a pub operated by the managementof the hotel...

    Read More
    1234 Words 7 Pages
  • Phuket Essay

    ...to Thai Oil Ltd’s factory in Phuket, Thailand. In order to re-exporting the retail bottle groundnut oil to Phuket. There is few factor we have considering on our logistics planning. We choose shipping to transport the bottled Groundnut oil to Thai Oil Ltd’s factory in Phuket, in order to saving the cost for the company, considering the one bottle oil itself is heavy. Thus, if using the airplane as our vehicle, the cost of one bottle’s oil transportation expenses will even high than the profit will get. In addition, the shipping industry in Phuket and Singapore are well-developed and convenient. Because both of them are coastal city. the way of sipping use was put the product inside of the container. After that, they charge depending on how many container was used. When the cargo arrived the port of Phuket , we suggest Thai Oil Ltd’s factory apportion they own vehicle to sign for and taking the oil, in order to make sure the cargo was safe and save the cots of finding other vehicle for their company. The logistic planning was start from the port of Singapore to the port of Phuket, the distance between port of Singapore and port of Phuket was 653nm, and the time cost was around 4-5days. The time advantage we found was Singapore’s company was nearby the Phuket Island, the ship can direct arrived at Phuket, there is no transit shipment processing...

    Read More
    441 Words 2 Pages
  • Essay about Phuket Case

    ...TO: General Manager of Phuket Beach Hotel RE: Investment Consultation: Planet Karaoke Pub Vs. Beach Karaoke The Phuket Beach Hotel faces development options in its future. Planet Karaoke Pub, a restaurant chain, has approached the hotel to obtain a 4 year lease to occupy a 3,000 square foot space. Should the Phuket Beach Hotel invest in Planet Karaoke’s proposal? Or, should the hotel develop its own karaoke business? Kornkrit and Wanida believe Group 3 is the most equipped to handle the analysis. Planet Karaoke plans to pay the Phuket hotel ฿170,000 per month for the first two years (฿2,020,000/year). The hotel will charge Planet Karaoke at a 5% increment for years 3 and 4, or ฿178,500 per month (฿2,152,000/year). The Phuket Hotel is responsible for the repair and maintenance of the facilities (i.e. toilets, elevators) and has prorated this cost over the next 4 years to be an additional ฿10,000 per year for Planet Karaoke. The total revenue over the next 4 years is estimated to be ฿8,404,000. The projected capital expenditure for the hotel is between ฿770,000 and ฿1,000,000. We will assume this expenditure is ฿885,000. It is predicted that unwelcome guests at the Planet Karaoke Pub might deter guests from the...

    Read More
    1351 Words 4 Pages

Popular Essays

Become a StudyMode Member

Sign Up - It's Free