Prepare a spreadsheet identifying the expected cash flows associated with the Alexandria TreeHouse project. | Homework Help
TreeHouse Hotels
FIN 301-B Spring 2017
After extensive research, TripleTrees Hotel chain has developed a new concept for family friendly suite hotels called TreeHouse. The executive committee must now determine if the project is a viable one. Each unit in a TreeHouse Hotel is a suite that includes a sitting room, kitchenette, and 2 bedrooms. In aIDition, each property would include a playground for children, child-appropriate videos on demand, an indoor swimming pool, and a gym for adults.
The plan is to locate TreeHouse Hotels just outside cities that regularly receive a large number of visitors. The company plans to locate its TreeHouse Hotels within 15 miles of the city center on highways that provide ready access to the city with a number of family-friendly restaurant chains in the immediate area. TripleTrees executives have also noted the importance of locating these new hotels in the safer areas of the metropolitan region.
Although the ultimate goal is to open TreeHouse Hotels around the country, TripleTree has built its success on a conservative approach. The company regularly develops new hotel concepts by opening one or two properties and making adjustments as necessary before expanding in a more aggressive manner. You are being asked to contribute to the financial analysis that helps determine whether the time is ripe to launch the TreeHouse Hotel concept.
The property committee has paid a $15,000 retainer to local commercial real estate companies to identify possible locations in the Washington, DC and Orlando, FL areas. The DC firm has identified a possible location in Alexandria, Virginia, just outside of Washington, DC. The location would provide families with ready access to historic Old Town Alexandria and Mount Vernon, home of President George Washington. Owners of a hotel built in the 1950s are looking to retire and are interested in selling their property. The location has several restaurants (including Applebees, Wendys, Jerrys, Subway, Chiles, Fridays, etc.) as well as a grocery store and drug stores within a 5-minute drive. The property is 20 to 30 minutes from downtown Washington, DC, and there is a Metro station approximately 10 minutes away. (Developers have also suggested that the hotel could provide a shuttle to and from Metro at regular intervals.)
TripleTree property managers believe they can purchase the property for $950,000. The current hotel would be torn down, and a new facility would be built. Construction costs associated with the new hotel are estimated to be $5.5 million. The building will be depreciated on a straight-line basis over 39 years, although only 6-months depreciation will be taken during the first year.
TripleTree Corp. typically looks for positive returns from its projects over a 20-year life. For the purposes of this evaluation, you should assume that the company will sell the hotel in 20 years. TripleTree Corp. has a policy of undertaking general upgrades in its properties every 10 years to keep its hotels looking fresh. The new hotel would be due for an upgrade in Year 10. The expected cost of the upgrade is $700,000. Further, during Year 11 while the hotel is undergoing its upgrade, only 75 percent of the rooms will be available to book at any given point, thereby cutting into revenues for the year.
Based on recent trends in real estate prices, TripleTrees real estate consultants have predicted that the land and TreeHouse hotel will be worth $3.25 million at the end of 20 years, assuming the upgrades are undertaken.
Demolition of the existing building and construction of the new hotel are expected to take 18 months, so that the hotel would not begin leasing rooms until the second half of the first year. Based on occupancy and rates of other hotels in the area, TripleTree believes its new TreeHouse Hotel will generate $1,500,000 in revenues the first 6 months it is open. Operating expenses during this first 6-month period are expected to be 70 percent of revenues before depreciation (as training of staff, aIDitional advertising, sourcing of inputs, etc. will aID to start-up expenses). The investment in inventories (cleaning supplies, complementary soaps, shampoos, etc.) for the start-up is expected to be $50,000. Accounts payable for the hotel chain are expected to increase by $5,000.
In its first full year of operation (Year 2), the Alexandria TreeHouse Hotel is expected to generate $3.5 million in revenues, and operating expenses will fall to 60 percent of total revenues before depreciation.
As the financial analyst charged with assessing the TreeHouse proposal, you will also need to determine the appropriate weighted average cost of capital. The CFO has provided you with the following information.
TripleTree will issue new bonds to help fund the project. The company currently has 20-year bonds outstanding with a face value of $1,000 and a coupon rate of 5 percent, payable annually. The bonds are currently selling for $1,136. The CFO expects to be able to issue new bonds at the rate indicated by the yield on existing bonds.
TripleTree will also use retained earnings to help fund the project. TripleTree just paid a dividend of $1.50 per share, and its dividends have been growing steadily at 2 percent per year. Its stock currently sells for $12.50 per share.
The firms target capital structure is 50 percent debt and 50 percent common equity.
TripleTree Corporations marginal tax rate is 40 percent.
Identify any other questions about the cash flows you would want to ask the executive in charge of the TreeHouse Hotel project. AIDress those questions to the hotel chains consultant, Dr. Catherine England.
Prepare a spreadsheet identifying the expected cash flows associated with the Alexandria TreeHouse project. (45 points)
Calculate the firms weighted average cost of capital (WACC). (20 points)
Prepare a memo indicating whether the Alexandria hotel project should be pursued. Different members of the firms board of directors prefer different measures of a projects viability, so you will need to provide feedback using NPV, IRR, and MIRR. (15 points)
DUE DATE: Friday, May 5 @ 11:59 p.m.
AIDITIONAL NOTES:
All work must be submitted electronically, either by posting the assignment on Canvas or submitting files via email.
There are 5 bonus points included in this assignment. Late submissions will lose 5 points for each day after May 5.
This assignment will not be accepted for any credit after 11:59 p.m. on Tuesday, May 9.
We've got everything to become your favourite writing service
Money back guarantee
Your money is safe. Even if we fail to satisfy your expectations, you can always request a refund and get your money back.
Confidentiality
We don’t share your private information with anyone. What happens on our website stays on our website.
Our service is legit
We provide you with a sample paper on the topic you need, and this kind of academic assistance is perfectly legitimate.
Get a plagiarism-free paper
We check every paper with our plagiarism-detection software, so you get a unique paper written for your particular purposes.
We can help with urgent tasks
Need a paper tomorrow? We can write it even while you’re sleeping. Place an order now and get your paper in 8 hours.
Pay a fair price
Our prices depend on urgency. If you want a cheap essay, place your order in advance. Our prices start from $11 per page.