Reference no: EM13886062
Whistling Winds Resort Spa
This spa has just opened. The owner has estimated sales, cost of sales, payroll, operating expenses for the first five years. Compute the Gross Profit and EBITDA for these five years:
|
|
Year 1
|
Year 2 est
|
Year 3 est
|
Year 4 est
|
Year 5 est
|
|
Total Spa Revenue
|
$3,200,000
|
$5,758,317
|
$6,503,677
|
$7,279,858
|
$8,086,863
|
|
Cost of Goods Sold
|
160,000
|
287,915
|
325,183
|
363,992
|
404,343
|
|
Gross Profit
|
|
|
|
|
|
|
Payroll
|
2,304,000
|
3,278,150
|
3,559,542
|
3,901,888
|
4,256,566
|
|
Operating Expenses
|
896,000
|
1,111,380
|
1,197,812
|
1,297,296
|
1,404,492
|
|
EBITDA
|
|
|
|
|
|
Now use a 10% discount factor and the Excel NPV function to compute the present value of the five years of EBITDA (Year 1 through Year 5).
Net Present Value of Year 1 through Year 5 EBITDA @10%:
Suppose that the EBITDA in Year 5 continues at that level in all subsequent years, forever. Treat this as a perpetuity to determine its capitalized value. What would the value of this endless stream of cash flow be worth, at a discount rate of 10%? Insert it in the cell above the arrow.
Finally, recompute the NPV of the projected EBITDAs from Year 1 through Year 6, (i.e., including the capitalized value in Cell H11):
Net Present Value of all future projected EBITDA @10%:
Is this a reasonable estimate of the value of the spa?
How does this value compare to the value you would obtain if you applied a normal (9X to 12X) EBITDA valuation approach to the Year 1 EBITDA?
|
Estimate the force on the sign
: A 220-cm-square sign is impacted straight on by a 50 m=s 10-C wind. Estimate the force on the sign. If the sign is held by a single 3-m-high post imbedded in concrete, what moment would exist at the base of the post?
|
|
How many combinations of ice cream are there
: At an ice cream there there are 10 flavors of ice cream, four toppings, three types of sprinkles, and either whipped cream or chocolate sauce. How many combinations of ice cream are there?
|
|
What are the core principles of management
: What are the core principles of management, explain in one page.
|
|
Calculate the drag force
: Atmospheric air at 20-C is flowing at 10 m=s. Calculate the drag force on a 10-cm-diameter smooth sphere,
|
|
What would value of endless stream of cash flow be worth
: What would the value of this endless stream of cash flow be worth, at a discount rate of 10%? Insert it in the cell above the arrow.
|
|
Estimate the area under the curve
: Estimate the area under the curve f(x) = 16 - x^2 from x = 0 to x = 3 by using three inscribed (under the curve) rectangles. Answer to the nearest integer.
|
|
. what are the various systems in supply chain management
: . What are the various systems in supply chain management to reduce costs, speed delivery and boost productivity? Give 3-5 detailed examples.
|
|
Find the length of the chord
: A chord subtends an angle of 68° at the centre of a circle of radius 200mm. Find the length of the chord.
|
|
What is its speed if it is submerged in water
: A 2-cm-diameter sphere moves at Re ¼ 10 (separation is just occurring). What is its speed if it is submerged in (a) water at 10-C, (b) air at 40-C and 400 kPa, and (c) water at 90-C.
|