Net Present Value Method—Annuity for a Service Company
Amenity Hotels Inc. is considering the construction of a new hotel for $81 million. The expected life of the hotel is 7 years with no residual value. The hotel is expected to earn revenues of $22 million per year. Total expenses, including depreciation, are expected to be $16 million per year. Amenity Hotels’ management has set a minimum acceptable rate of return of 9%.
a. Determine the equal annual net cash flows
from operating the hotel. Enter your answer in million.
Round your answer to two decimal places.
$ million
| Present Value of an Annuity of $1 at Compound Interest | |||||||
| Periods | 8% | 9% | 10% | 11% | 12% | 13% | 14% |
| 1 | 0.92593 | 0.91743 | 0.90909 | 0.90090 | 0.89286 | 0.88496 | 0.87719 |
| 2 | 1.78326 | 1.75911 | 1.73554 | 1.71252 | 1.69005 | 1.66810 | 1.64666 |
| 3 | 2.57710 | 2.53129 | 2.48685 | 2.44371 | 2.40183 | 2.36115 | 2.32163 |
| 4 | 3.31213 | 3.23972 | 3.16987 | 3.10245 | 3.03735 | 2.97447 | 2.91371 |
| 5 | 3.99271 | 3.88965 | 3.79079 | 3.69590 | 3.60478 | 3.51723 | 3.43308 |
| 6 | 4.62288 | 4.48592 | 4.35526 | 4.23054 | 4.11141 | 3.99755 | 3.88867 |
| 7 | 5.20637 | 5.03295 | 4.86842 | 4.71220 | 4.56376 | 4.42261 | 4.28830 |
| 8 | 5.74664 | 5.53482 | 5.33493 | 5.14612 | 4.96764 | 4.79677 | 4.63886 |
| 9 | 6.24689 | 5.99525 | 5.75902 | 5.53705 | 5.32825 | 5.13166 | 4.94637 |
| 10 | 6.71008 | 6.41766 | 6.14457 | 5.88923 | 5.65022 | 5.42624 | 5.21612 |
b. Compute the net present value of the new
hotel, using the present value of an annuity of $1 table above.
Round to the nearest million dollars. If required,
use the minus sign to indicate a negative net present value.
Net present value of hotel project: $ million
c. Does your analysis support construction of
the new hotel?
Yes/No , because the net present value is positive/negative .
In: Accounting
Net Present Value Method—Annuity for a Service Company
Welcome Inn Hotels is considering the construction of a new hotel for $70 million. The expected life of the hotel is 10 years with no residual value. The hotel is expected to earn revenues of $19 million per year. Total expenses, including depreciation, are expected to be $14 million per year. Welcome Inn management has set a minimum acceptable rate of return of 10%. Assume straight-line depreciation.
a. Determine the equal annual net cash flows
from operating the hotel. Round to the nearest million
dollars.
$ million
| Present Value of an Annuity of $1 at Compound Interest | |||||||
| Periods | 8% | 9% | 10% | 11% | 12% | 13% | 14% |
| 1 | 0.92593 | 0.91743 | 0.90909 | 0.90090 | 0.89286 | 0.88496 | 0.87719 |
| 2 | 1.78326 | 1.75911 | 1.73554 | 1.71252 | 1.69005 | 1.66810 | 1.64666 |
| 3 | 2.57710 | 2.53129 | 2.48685 | 2.44371 | 2.40183 | 2.36115 | 2.32163 |
| 4 | 3.31213 | 3.23972 | 3.16987 | 3.10245 | 3.03735 | 2.97447 | 2.91371 |
| 5 | 3.99271 | 3.88965 | 3.79079 | 3.69590 | 3.60478 | 3.51723 | 3.43308 |
| 6 | 4.62288 | 4.48592 | 4.35526 | 4.23054 | 4.11141 | 3.99755 | 3.88867 |
| 7 | 5.20637 | 5.03295 | 4.86842 | 4.71220 | 4.56376 | 4.42261 | 4.28830 |
| 8 | 5.74664 | 5.53482 | 5.33493 | 5.14612 | 4.96764 | 4.79677 | 4.63886 |
| 9 | 6.24689 | 5.99525 | 5.75902 | 5.53705 | 5.32825 | 5.13166 | 4.94637 |
| 10 | 6.71008 | 6.41766 | 6.14457 | 5.88923 | 5.65022 | 5.42624 | 5.21612 |
b. Calculate the net present value of the new
hotel using the present value of an annuity of $1 table above.
Round to the nearest million dollars. If required, use the minus
sign to indicate a negative net present value.
Net present value of hotel project: $ million
c. Does your analysis support the purchase of
the new hotel?
, because the net present value is .
In: Accounting
The Wilton is an all-inclusive spa and hotel in the heart of
Brooklyn and uses guests as its measure of activity. During June,
The Wilton budgeted for 2,000 guests, but it actually hosted 2,100
guests. The hotel used the following revenue and cost formulas in
its budgeting, where q is the number of guests:
Revenue: $62.90q
Personnel expenses: $28,500 + $20.40q
Food and beverage supplies: $1,400 + $9.90q
Occupancy expenses: $8,200 + $3.30q
Spa expenses: $4,000 + $0.40q
The hotel reported the following actual results for June:
Revenue $129,450
Personnel expenses $ 74,770
Food and beverage supplies $ 22,940
Occupancy expenses $ 14,640
Spa expenses
$ 4,740
Required:
a. Prepare a flexible budget performance report showing The
Wilton’s revenue and spending variances and activity variances for
June. Label each variance as favorable (F) or unfavorable (U),
filling out the shaded squares. (22 points)
|
Actual Results |
Revenue & Spending Variances |
F/U |
Flexible Budget |
Activity Variance |
F/U |
Planning Budget |
|
|
Guests |
|||||||
|
Revenue |
|||||||
|
Expenses: |
|||||||
|
Personnel |
|||||||
|
Food & Beverage Expenses |
|||||||
|
Occupancy |
|||||||
|
Spa Expenses |
|||||||
|
Total Expenses |
|||||||
|
Net Income |
b. Describe at least two potential reasons for the revenue, spa expenses and food/beverage supplies variances found above. Are any of the variances related? Describe. (6 pts)
In: Accounting
In January 2017, Mitzu Co. pays $2,700,000 for a tract of land with two buildings on it. It plans to demolish Building 1 and build a new store in its place. Building 2 will be a company office; it is appraised at $570,000, with a useful life of 20 years and a $85,000 salvage value. A lighted parking lot near Building 1 has improvements (Land Improvements 1) valued at $570,000 that are expected to last another 19 years with no salvage value. Without the buildings and improvements, the tract of land is valued at $1,860,000. The company also incurs the following additional costs:
| Cost to demolish Building 1 | $ | 346,400 | |
| Cost of additional land grading | 187,400 | ||
| Cost to construct new building (Building 3), having a useful life of 25 years and a $398,000 salvage value | 2,242,000 | ||
| Cost of new land improvements (Land Improvements 2) near Building 2 having a 20-year useful life and no salvage value |
178,000 |
Journal entry worksheet
Record the cost of the plant assets, paid in cash.
In: Accounting
8. Peter Griffin calculates that his portfolio's risk, as measured by the standard deviation, is 19.67%. His portfolio is made up of many stocks from just two companies, South Park Company and Quahog Company. South Park Co.'s returns have a standard deviation of 12.9% and Quahog Co.'s returns have a standard deviation of 28.84%. If the weight of Quahog Co. in his portfolio is 48.21%, what is the correlation between the returns of Quahog and South Park.
9.
A portfolio has an excess return of 15.9 % and a standard deviation of 15.23 %. What is the Sharpe Ratio for this portfolio?
In: Finance
3. Design and draw a circuit using the cascade system to operate two cylinders (A and B) which, on the operation of a start valve, produces the sequence A – B + B – A+. The cylinders should park in the positions B – A + when the start switch is in the ‘off’ position.
4. Modify the circuit designed for question 3 to provide an emergency stop which will park both cylinders in the extended position (i.e. A + B +).
5. Modify the circuit designed for question 3 to provide a fail safe. The fail safe should:
(a) act in the event of a reduced pressure at inlet to the group selecting valve
(b) park the cylinders in the retracted position
In: Mechanical Engineering
A new wastewater treatment plant was built to treat the wastewater flow 800,000 gpd. The capital cost to build the wastewater treatment plant was $6,000,000. The annual operation and maintenance costs of operating the plant is $700,000/year. Estimate the cost of treating 1000 gallons of wastewater ($/1000 gallon). Assume the design life as 20 years and interest rate of 4%.
In: Chemistry
In: Economics
An amusement park wants to assess how much money its patrons intend to spend at the park today (aside from the price of admission). You will use convenience sampling.
1. Explain how you would select the sample.
2. Explain how you would gather the data.
In: Statistics and Probability
The Royal Hotel is being sold. The underwriter requests the pro forma statements showing future projected cash flows from the hotel owner. If the underwriter only uses this information, (a) which approach to valuation are they using? Please also (b) name and (c) briefly describe the other two approaches.
In: Finance