Comp_Usage_Final.xlsx - Sales Branch Bangkok Phuket Pattaya Chiang Mai Year Revenue Revenue Revenue Revenue 2014 THB100,000 THB210,000 THB150,000

Comp_Usage_Final.xlsx - Sales Branch Bangkok Phuket Pattaya...

This preview shows page 1 - 11 out of 41 pages.

Sales Branch Bangkok Phuket Pattaya Chiang Mai Year Revenue Revenue Revenue Revenue 2014 THB100,000 THB210,000 THB150,000 THB350,000 2015 THB300,000 THB250,000 THB200,000 THB250,000 2016 THB400,000 THB220,000 THB250,000 THB200,000 2017 THB550,000 THB210,000 THB350,000 THB100,000 2018 THB500,000 THB200,000 THB490,000 THB175,000 2019 THB510,000 THB220,000 THB530,000 THB120,000 Total THB2,360,000 THB1,310,000 THB1,970,000 THB1,195,000 Average THB393,333 THB218,333 THB328,333 THB199,167 Min THB100,000 THB200,000 THB150,000 THB100,000 Max THB550,000 THB220,000 THB530,000 THB200,000 Grand Total THB6,835,000 Expense Branch Bangkok Phuket Pattaya Chiang Mai Year Expense Expense Expense Expense 2014 (THB200,000) (THB100,000) (THB175,000) (THB90,000) 2015 (THB197,000) (THB145,000) (THB130,000) (THB120,000) 2016 (THB250,000) (THB120,000) (THB170,000) (THB100,000) 2017 (THB160,000) (THB145,000) (THB150,000) (THB105,000) 2018 (THB150,000) (THB105,000) (THB120,000) (THB100,000) 2019 (THB130,000) (THB100,000) (THB160,000) (THB125,000) Total (THB1,087,000) (THB715,000) (THB905,000) (THB640,000) Average (THB181,167) (THB119,167) (THB150,833) (THB106,667) Min (THB250,000) (THB145,000) (THB175,000) (THB125,000) Max (THB130,000) (THB100,000) (THB120,000) (THB90,000) Grand Total (THB3,347,000.00)
Image of page 1
Pro Total Branch Bangkok Phuket Year Profit/Loss Profit/Loss THB810,000 2014 -THB100,000 THB110,000 THB1,000,000 2015 THB103,000 THB105,000 THB1,070,000 2016 THB150,000 THB100,000 THB1,210,000 2017 THB390,000 THB65,000 THB1,365,000 2018 THB350,000 THB95,000 THB1,380,000 2019 THB380,000 THB120,000 THB6,835,000 Total THB1,273,000 THB595,000 THB1,139,167 Average THB212,167 THB99,167 THB810,000 Min -THB100,000 THB65,000 THB1,380,000 Max THB390,000 THB120,000 Grand Total Total (THB565,000) (THB592,000) (THB640,000) (THB560,000) (THB475,000) (THB515,000) (THB3,347,000) (THB557,833) (THB640,000) (THB475,000)
Image of page 2
ofit/Loss Pattaya Chiang Mai Total Profit/Loss Profit/Loss -THB25,000 THB260,000 THB245,000 THB70,000 THB130,000 THB408,000 THB80,000 THB100,000 THB430,000 THB200,000 -THB5,000 THB650,000 THB370,000 THB75,000 THB890,000 THB370,000 -THB5,000 THB865,000 THB1,065,000 THB555,000 THB3,488,000 THB177,500 THB92,500 THB581,333 -THB25,000 -THB5,000 THB245,000 THB370,000 THB260,000 THB890,000 THB3,488,000
Image of page 3
Rates Member Discount Room Price/day Yes 5% Regular THB 1,300 No 0% Deluxe THB 1,400 Suite THB 1,900 Royal Suite THB 2,200 Regular + Breakfast THB 1,250 Deluxe + Breakfast THB 1,700 Suite + Breakfast THB 2,200 Royal Suite + Breakfast THB 2,399 Worst Case Most Likely Best Case Revenue 1% 2% 4% Exepnses 3% 1% 1%
Image of page 4
Criteria for days stayed Days 0 5 10 25 32 Discount 0% 5% 7% 10% 15%
Image of page 5
Executive Lounge Yes THB 20,000 No THB - Meeting Room Yes THB 10,000 No THB -
Image of page 6
Loan to build a restaurant in Pattaya Branch Type of Cost Cost Building THB 400,000 Administrative Cost THB 9,000 Kitchen, Grocery, and Packaging THB 1,300,000 Pre-Opening Expense (advertising) THB 20,000 Tables and Chairs THB 1,000,000 Staff Uniform THB 10,000 Total THB 2,739,000 Bank Loan Loan THB2,739,000 Rate 7% Term 15 years Period 12 months Payment (THB24,618.91) (THB24,618.91) 4069000 4569000 4% (THB30,097.90) (THB33,796.34) 4.50% (THB31,127.58) (THB34,952.54) 5% (THB32,177.39) (THB36,131.36) 5.50% (THB33,247.13) (THB37,332.54) 6% (THB34,336.53) (THB38,555.82) 6.50% (THB35,445.36) (THB39,800.90) 7% (THB36,573.32) (THB41,067.46) 7.50% (THB37,720.13) (THB42,355.19) rate #NAME? pmt (THB100,000.00) pv THB2,739,000 fv 0 type 0 Number of periods #NAME? nper 60 pmt (THB10,000.00) pv 0 fv THB2,739,000.00 Rate 4% Number of periods needed to pay off 2,739,000THB at an interest rate of 8%. Payment of 100000 per month. Payment made at the end of each month Monthly interest rate required to save 2739000 over 5 years, with an investment of $10000 per year (payment made at end of each month)
Image of page 7
rate #NAME? nper 60 pmt (THB20,000.00) Present Value #NAME? Present value of hotel annuity with an interest rate of 5% per year and payment of THB20000 per month over 5 years (payment made at the end of each month)
Image of page 8
Loan Cost 4069000 Per Interest Rate 7% Maturity 15 years 1 Period 2 times per year 2 3 4 5 6 7 8 9 10 11 12 13 5069000 5569000 6069000 6569000 14 (THB37,494.78) (THB41,193.22) (THB44,891.66) (THB48,590.10) 15 (THB38,777.51) (THB42,602.48) (THB46,427.44) (THB50,252.41) 16 (THB40,085.33) (THB44,039.30) (THB47,993.27) (THB51,947.23) 17 (THB41,417.96) (THB45,503.38) (THB49,588.79) (THB53,674.21) 18 (THB42,775.10) (THB46,994.39) (THB51,213.67) (THB55,432.96) 19 (THB44,156.43) (THB48,511.97) (THB52,867.51) (THB57,223.04) 20 (THB45,561.61) (THB50,055.75) (THB54,549.89) (THB59,044.03) 21 (THB46,990.26) (THB51,625.32) (THB56,260.38) (THB60,895.44) 22 23 24 25 26 27 28 29 30
Image of page 9
Amortization Table Principal Payment Interest Payment Payment Balance THB4,069,000.00 (THB78,821.95) (THB142,415.00) (THB221,236.95) THB3,990,178.05 (THB81,580.72) (THB139,656.23) (THB221,236.95) THB3,908,597.34 (THB84,436.04) (THB136,800.91) (THB221,236.95) THB3,824,161.29 (THB87,391.30) (THB133,845.65) (THB221,236.95) THB3,736,769.99 (THB90,450.00) (THB130,786.95) (THB221,236.95) THB3,646,319.99
Image of page 10
Image of page 11

You've reached the end of your free preview.

Want to read all 41 pages?

  • One '19
  • Willa McDonald
  • Bangkok, Chiang Mai, ISO 3166-2:TH

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes