Prepare a spreadsheet identifying the expected cash flows associated with the Alexandria TreeHouse project. | Homework Market 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.

Don't use plagiarized sources. Get Your Custom Essay on
Prepare a spreadsheet identifying the expected cash flows associated with the Alexandria TreeHouse project. | Homework Market Help
Just from $13/Page
Order Essay

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 Applebee’s, Wendy’s, Jerry’s, Subway, Chile’s, Friday’s, 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, TripleTree’s 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 firm’s target capital structure is 50 percent debt and 50 percent common equity.

TripleTree Corporation’s 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 chain’s consultant, Dr. Catherine England.

Prepare a spreadsheet identifying the expected cash flows associated with the Alexandria TreeHouse project. (45 points)

Calculate the firm’s weighted average cost of capital (WACC). (20 points)

Prepare a memo indicating whether the Alexandria hotel project should be pursued. Different members of the firm’s board of directors prefer different measures of a project’s viability, so you will need to provide feedback using NPV, IRR, and MIRR. (15 points)
DUE DATE: Friday, May 5 @ 11:59 p.m.

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.

Homework Market Pro
Calculate your paper price
Pages (550 words)
Approximate price: -

Our Unique Features

Custom Papers Means Custom Papers

This is what custom writing means to us: Your essay starts from scratch. Plagiarism is unacceptable. We demand the originality of our academic essay writers and they only deliver authentic and original papers. 100% guaranteed! If your final version is not as expected, we will revise it immediately.

Qualified and Experienced Essay Writers

Our team consists of carefully selected writers with in-depth expertise. Each writer in our team is selected based on their writing skills and experience. Each team member is able to provide plagiarism-free, authentic and high-quality content within a short turnaround time.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Assuarance

We understand you. Spending your hard earned money on a writing service is a big deal. It is a big investment and it is difficult to make the decision. That is why we support our claims with guarantees. We want you to be reassured as soon as you place your order. Here are our guarantees: Your deadlines are important to us. When ordering, please note that delivery will take place no later than the expiry date.

100% Originality & Confidentiality

Every paper we write for every order is 100% original. To support this, we would be happy to provide you with a plagiarism analysis report on request.We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

We help students, business professionals and job seekers around the world in multiple time zones. We also understand that students often keep crazy schedules. No problem. We are there for you around the clock. If you need help at any time, please contact us. An agent is always available for you.

Try it now!

Calculate the price of your order

Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Our services are second to none. Every time you place an order, you get a personal and original paper of the highest quality.


Essay Writing Service

While a college paper is the most common order we receive, we want you to understand that we have college writers for virtually everything, including: High school and college essays Papers, book reviews, case studies, lab reports, tests All graduate level projects, including theses and dissertations Admissions and scholarship essays Resumes and CV’s Web content, copywriting, blogs, articles Business writing – reports, marketing material, white papers Research and data collection/analysis of any type.


Any Kind of Essay Writing!

Whether you are a high school student struggling with writing five-paragraph essays, an undergraduate management student stressing over a research paper, or a graduate student in the middle of a thesis or dissertation, has a writer for you. We can also provide admissions or scholarship essays, a resume or CV, as well as web content or articles. Writing an essay for college admission takes a certain kind of writer. They have to be knowledgeable about your subject and be able to grasp the purpose of the essay.


Quality Check and Editing Support

Every paper is subject to a strict editorial and revision process. This is to ensure that your document is complete and accurate and that all of your instructions have been followed carefully including creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.


Prices and Discounts

We are happy to say that we offer some of the most competitive prices in this industry. Since many of our customers are students, job seekers and small entrepreneurs, we know that money is a problem. Therefore, you will find better prices with us compared to writing services of this calibre.