Question
In: Finance
Owners of an economy motel chain are considering building a new 200-unit motel in Riverside, CA....
Owners of an economy motel chain are considering building a new 200-unit motel in Riverside, CA. The present worth cost of building the motel is $8,000,000; the firm estimates furnishings for the motel will cost an additional $800,000 and will require replacement every 5 years. Annual operating and maintenance costs for the facility are estimated to be $800,000. The average rate for a unit is anticipated to be $60/day. A 15-year planning horizon is used by the firm in evaluating new ventures of this type; a terminal salvage value of 15% of the original building cost is anticipated; furnishings are estimated to have no salvage value at the end of each 5-year replacement interval. Assume an average daily occupancy percentage of 80%, a MARR of 12%, 365 operating days/year, and ignore the cost of the land. (Assume the furnishings are not replacement at EOY 15.)
What is the present worth, internal rate of return, external rate of return?
Please answer all parts of the question, and include a cashflow diagram.
Solutions
Expert Solution
| All cash in millions | ||||||||||||||||
| 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | |
| Building the motel | $ -8.00 | |||||||||||||||
| Furnishing | $ -0.80 | |||||||||||||||
| Revenue | $ 3.50 | $ 3.50 | $ 3.50 | $ 3.50 | $ 3.50 | $ 3.50 | $ 3.50 | $ 3.50 | $ 3.50 | $ 3.50 | $ 3.50 | $ 3.50 | $ 3.50 | $ 3.50 | $ 3.50 | |
| Maintenance | $ -0.80 | $ -0.80 | $ -0.80 | $ -0.80 | $ -0.80 | $ -0.80 | $ -0.80 | $ -0.80 | $ -0.80 | $ -0.80 | $ -0.80 | $ -0.80 | $ -0.80 | $ -0.80 | $ -0.80 | |
| Depreciation of motel | $ -0.45 | $ -0.45 | $ -0.45 | $ -0.45 | $ -0.45 | $ -0.45 | $ -0.45 | $ -0.45 | $ -0.45 | $ -0.45 | $ -0.45 | $ -0.45 | $ -0.45 | $ -0.45 | $ -0.45 | |
| Depreciation of furnishing | $ -0.20 | $ -0.20 | $ -0.20 | $ -0.20 | $ -0.20 | $ -0.20 | $ -0.20 | $ -0.20 | $ -0.20 | $ -0.20 | $ -0.20 | $ -0.20 | $ -0.20 | $ -0.20 | $ -0.20 | |
| EBIT | $ 2.05 | $ 2.05 | $ 2.05 | $ 2.05 | $ 2.05 | $ 2.05 | $ 2.05 | $ 2.05 | $ 2.05 | $ 2.05 | $ 2.05 | $ 2.05 | $ 2.05 | $ 2.05 | $ 2.05 | |
| Tax | $ 0.72 | $ 0.72 | $ 0.72 | $ 0.72 | $ 0.72 | $ 0.72 | $ 0.72 | $ 0.72 | $ 0.72 | $ 0.72 | $ 0.72 | $ 0.72 | $ 0.72 | $ 0.72 | $ 0.72 | |
| EBIAT | $ 1.33 | $ 1.33 | $ 1.33 | $ 1.33 | $ 1.33 | $ 1.33 | $ 1.33 | $ 1.33 | $ 1.33 | $ 1.33 | $ 1.33 | $ 1.33 | $ 1.33 | $ 1.33 | $ 1.33 | |
| Depreciation of motel | $ 0.45 | $ 0.45 | $ 0.45 | $ 0.45 | $ 0.45 | $ 0.45 | $ 0.45 | $ 0.45 | $ 0.45 | $ 0.45 | $ 0.45 | $ 0.45 | $ 0.45 | $ 0.45 | $ 0.45 | |
| Depreciation of furnishing | $ 0.20 | $ 0.20 | $ 0.20 | $ 0.20 | $ 0.20 | $ 0.20 | $ 0.20 | $ 0.20 | $ 0.20 | $ 0.20 | $ 0.20 | $ 0.20 | $ 0.20 | $ 0.20 | $ 0.20 | |
| Capital expenditure | $ - | $ - | $ - | $ - | $ -0.80 | $ - | $ - | $ - | $ - | $ -0.80 | $ - | $ - | $ - | $ - | $ - | |
| Terminal Value of motel | $ 1.20 | |||||||||||||||
| FCFF | $ -8.80 | $ 1.99 | $ 1.99 | $ 1.99 | $ 1.99 | $ 1.19 | $ 1.99 | $ 1.99 | $ 1.99 | $ 1.99 | $ 1.19 | $ 1.99 | $ 1.99 | $ 1.99 | $ 1.99 | $ 3.19 |
| PV | $ -8.80 | $ 1.77 | $ 1.58 | $ 1.41 | $ 1.26 | $ 0.67 | $ 1.01 | $ 0.90 | $ 0.80 | $ 0.72 | $ 0.38 | $ 0.57 | $ 0.51 | $ 0.46 | $ 0.41 | $ 0.58 |
| NPV | $ 4.24 | |||||||||||||||
| IRR | 20.31% | |||||||||||||||
| External Rate of return | 14.97% | |||||||||||||||
| Given |
 jeff jeffy answered 2 years agoRelated SolutionsOwners of an economy motel chain are considering building a new 200-unit motel. The present worth...Owners of an economy motel chain are considering building a new
200-unit motel. The present worth cost of building the motel is
$8,000,000 and the firm estimates furnishings for the motel will
cost an additional $800,000 and will require replacement every 5
years. Annual operating and maintenance costs for the facility are
estimated to be $750,000 and the average rate for a unit is
anticipated to be $50/day. A 15 year planning horizon is used by
the firm for ventures...
Owners of an economy motel chain are considering building a new 200-unit motel. The present worth...Owners of an economy motel chain are considering building a new
200-unit motel. The present worth cost of building the motel is
$8,000,000 and the firm estimates furnishings for the motel will
cost an additional $800,000 and will require replacement every 5
years. Annual operating and maintenance costs for the facility are
estimated to be $750,000 and the average rate for a unit is
anticipated to be $50/day. A 15 year planning horizon is used by
the firm for ventures...
Value Lodges owns an economy motel chain and is considering building a new 200-unit motel. The...Value Lodges owns an economy motel chain and is considering
building a new 200-unit motel. The cost to build the motel is
estimated at $320,000; Value Lodges estimates furnishings for the
motel will cost an additional $620,000 and will require replacement
every 5 years. Annual operating and maintenance costs for the motel
are estimated to be $140,000. The average rental rate for a unit is
anticipated to be $30/day. Value Lodges expects the motel to have a
life of 15...
Owners of a motel chain are considering a new investment. The cost of the 125-unit motel...Owners of a motel chain are considering a new investment. The
cost of the 125-unit motel (excluding furnishings) is $10 million
and the furnishings, which cost $2 million must be replaced every
five years (with no salvage value). The annual O&M costs are
$200,000 per year, the average daily room rate is $110/day
(increasing by 3% per year), and the buildings will be sold in 15
years for 20% of the original building cost. Ignoring taxes, if the
motel operates...
Goodfood is a supermarket chain. During the current year it started building a new store. The...Goodfood is a supermarket chain. During the current year it
started building a new store. The directors are aware that in
accordance with IAS23 Borrowing costs certain borrowing
costs have to be capitalised.
Details relating to the construction of Goodfood’s new
store:
Goodfood took out a €10 million loan with an interest rate of
7.5% per annum on 1 April 2017. The loan was specifically taken to
finance the building of the new store which meets the definition of
a...
A retailer is considering building a large store. If the local economy experiences expansion, the firm...
A retailer is considering building a large store. If the local economy experiences expansion, the firm expects the store to earn a $2,000,000 profit next year. If the local economy experiences a contraction, the firm expects the store to lose $400,000 next year. Analysts estimate a 20% chance for the local economy to experience an expansion next year (hence an 80% chance for contraction). What is the expected monetary value (EMV) of building the large store
Acme Development Company is considering building a twenty-five (25) unit apartment building near Catholic University due...Acme Development Company is considering building a twenty-five
(25) unit apartment building near Catholic University due to the
demand for off-campus student housing. Given the unique needs of
the student population, Acme anticipates they will achieve 75%
occupancy over the course of a year. Acme is basing their decision
on the following assumptions:
MARR:15%
Land Acquisition:$150,000
Construction Cost:$2,250,000
Investment Period:20-years
Maintenance Expenses:Years 1 to 10: $500 per unit, Years 11 to
20: $1,000 per unit
...
A student is considering publishing a new magazine aimed directly at owners of Japanese automobiles. He...
A student is considering publishing a new magazine aimed
directly at owners of Japanese automobiles. He wanted to estimate
the fraction of cars in the United States that are made in Japan.
The computer output below summarizes the results of a random sample
of 50 autos.
z-interval for
proportion
With 90.00%
confidence
0.29938661 < p(japan) <
0.46984416
Interpret the computer output.
Explain what “90% confidence” means.
c. A politician urging consumers to purchase products
manufactured in the United States says,...
1. Company Amliba.Inc is considering building a second headquarter in a new city. The new office...1. Company Amliba.Inc is considering building a second
headquarter in a new city. The new office will create 5000 new jobs
for the city. So the government is incentivized to support the
project.
The company plans to issue $100 million bond with coupon rate of
8%. Coupon will be paid annually and the bond matures in 5
year.
As a form of support, local government guarantee the bond, so
the YTM of the bond at issuance is 5%.
Another bond...
Q2. XYZ company is considering building a new office building. XYZ already owns a plot of land...Q2. XYZ company is considering building a new office
building. XYZ already owns a plot of land worth $2M and
has paid an architectural firm $300k for building
designs. Construction cost for the building is
$1M. Projected rent income from the building is
$400k/year and interest expense will be
$300k/year. After three years XYZ expects to sell the
building and land for $2.5M. If XYZ has a required rate
of return of 10%, what is the NPV and IRR of building the office
building?
Please...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|