RISK ANALYSIS IN INVESTMENT DECISIONS- analyzing financial statements by evaluating the potential of mutually exclusive investments

 

This assignment lets you practice analyzing financial statements by evaluating the potential of mutually exclusive investments.
Property Description and Background Information
The Hamptons Hotel is located in the Hamptons Road area of Virginia Beach, Virginia.  The hotel is rated as a 4-diamond hotel based on the United States hotel rating system.  The hotel is considered as being unpretentious but luxurious.  The Hamptons Hotel is approximately 7 years old.  The Hotel consists of 250 guestrooms including 50 premium rooms and 200 standard rooms.  Its restaurant seats 150 people, and the lobby bar connects to the restaurant.  The only entrance to the hotel is through the lobby bar.  In addition, the hotel offers a full range of services to guests, including a large conference and event space for up to 200 people, an exercise room overlooking the ocean, an outdoor pool and recreation area, free parking for guests, and room service.  The average annual occupancy is 63%.  The Hotel’s market segments include business, leisure, tour, contract, large groups, and small groups. Three years ago, the Four-Star Hotel Group acquired the Hamptons Hotel. The U.S. publicly traded corporation owns and operates only 4-diamond luxury properties.  The Four-Star Hotel Group owns 10 additional 4-diamond properties in various Oceanside locations throughout the U.S.  The Four-Star Hotel Group initially paid $31.5 million for The Hamptons Hotel and invested an additional $2.0 million in renovations and furnishings.  The Hotel was financed by an exchange of shares with the prior owner and $11.5 million in cash obtained from a bond issue.Restaurant Dilemma Although management has been highly successful in increasing hotel room occupancy and improving overall hotel revenue, the restaurant continues to be unprofitable even with increased food and beverage revenue (See Exhibit 1). After undistributed operating expenses and fixed charges allocated to the restaurant, the restaurant continues to operate at a loss, and it is not capable of absorbing its share of overhead.  Unfortunately, the hotel restaurant has followed a trend in the U.S. hotel industry, which began in the 1980s and 1990s. Currently, the hotel restaurant only serves an average of 60% of hotel guests at breakfast and only 22% of hotel guests at dinner.  Walk-ins from the outside account for the remaining 7% of total customers served. The corporate financial manager and The Hamptons’ general manager are at odds about the future of the restaurant. The corporate financial manager argues that the company should close the restaurant and offer it to a suitable chain restaurant group under a leasing arrangement. The general manager, however, is certain that if corporate could provide additional funding to construct an access to the restaurant from the street and make the restaurant’s style trendier, then the hotel restaurant could show profitability in the future. The corporate financial manager has already approached three reputable upscale chain restaurants. The restaurant chains have agreed to review the offer if the Four-Star Hotel Group agrees to construct an entrance with street access to the restaurant. The most feasible of the three is Rick’s Steak and Seafood, a very popular upscale restaurant with locations in beachfront cities on the eastern coast of the U.S. The leasing agreement will be for 5 years and provides for $62,000 in lease income each year. Renewal of the lease will be at the option of the Four Star Hotel Group. Therefore, the projections will be based on a 5-year leasing period. The initial investment to provide street accessibility is estimated to cost $950,000.  Although Rick’s Steak and Seafood will provide alcoholic and non-alcoholic beverages, Rick’s has agreed not to operate a bar or lounge area for customers, but it will allow customers waiting for seating or wish to meet in the bar after dining to use the hotel’s lobby bar. The financial manager has estimated that this will increase the bar revenue net of costs by $9,700 for the first year and an additional increase of 5% per year for each year thereafter. The financial manager also realizes that not all of the overhead charged to the restaurant will be eliminated and other hotel-operated departments will have to absorb some of the overhead costs. His best estimate of the overhead that can be eliminated from the hotel is $200,000 per year.  In addition, the financial manager estimates that the working capital required will be reduced by approximately $70,000 per year as a result of lower accounts receivables and lower inventories. Although some portion of existing equipment will be included in the lease, the remaining equipment and furnishings will be sold at a cash gain before taxes of $80,000 (The sale will occur in Year 1 of the lease.)  Since the firm has an average tax rate of 25%, the financial manager has completed a schedule of net cash flow from leasing (See Exhibit 2, Proposal 2). The general manager discussed his proposal for renovation and construction of the street access with an architect. In the architect’s opinion, the cost to renovate the restaurant in an appropriate style and construct the street access would cost $1.8 million.  The general manager has also forecasted the increase in potential restaurant revenue and increase in potential restaurant costs for the next 5 years (See Exhibit 2, Proposal 1). The general manager has based his projections on 5 years since corporate has made it clear that if the restaurant remains in-house, then the restaurant must be profitable over the next 5 years. The general manager has also included an additional investment in required working capital based on the increased sales, inventories, and purchases payable (See Exhibit 2, Proposal 1). Although the restaurant will be renovated, some of the older equipment will remain.  Therefore, the general manager has included some additional expenditures for future replacement of equipment (See Exhibit 2, Proposal 1). The general manager has applied an average tax rate of 25% to the projected operating cash flows.Additional Information The Four Star Hotel Group has a current price per share of $55 per share.  The total number of shares issued and outstanding is 5.5 million. The most recent estimation of the group’s beta is 1.5, the average premium on the market is 7.5%, and the risk-free rate of return on short-term U. S. government bonds is 2.2%. The Four Star Hotel Group also has total debt financing of $90 million with an average interest rate on the debt of 4%. Since the Hotel Group consists of only 4-diamond luxury properties, the group considers all of its hotels to have the same average risk as the Hotel Group. For income tax purposes, the original investment for either proposal will be depreciated using the straight-line method based on a 5-year life with no salvage value. The average tax rate for the group is also 25%.Meeting with the Managers You have been requested to consult the Four Star Hotel Group and participate in the meeting in order to make a decision on which investment is the optimal choice, i.e., creates the most value for the shareholders. Before attending the meeting, you are requested to complete the analysis of the mutually exclusive investments. In preparation for the meeting, you will prepare a formal paper analyzing the two investments.Guidance and Expectations for Assignment
Type of Writing: Business supported by AcademicLength: Approximately 1,500 words plus references and any appendicesFormat: Standard APA
This is not an opinion paper, but a document that will go to management. Therefore, supporting documentation is necessary for all conclusions reached.The assignment should respond to the following questions:1. What is the cost of capital for the investment proposals? Even though the Four Star Hotel Group considers both proposals to be in the same risk category as their other hotel investments, how would you assess the proposals’ risk? Justify your response with adequate supporting citations.2. Based on the cost of capital for the Four Star Hotel Group and its average risk assets, which proposal creates more value? In presenting your results, provide justification as to why you have selected one proposal over the other proposal. This will require a discussion of the pros and cons of the valuation methods presented in the proposal.3. The current beta for the Four Star Hotel Group is 1.0 based on the most recent estimation.  Assume that the beta increases to 1.6.  What is the new cost of capital? Does your response to Question 2 above change? Why or why not? What does this tell you about the proposals’ sensitivity to the cost of capital chosen?4. What, if any, additional information would you require to make a more informed decision as to the optimal investment opportunity? Justify your response.
Exhibit 1: Food and Beverage Departmental Income and Allocated Overhead for the three previous years. Schedule of F & B and Allocated Overhead: Previous Previous Previous (all amounts in US dollars) Year 3 ($) Year 2 ($) Year 1 ($) Food Revenue 1822860 3097780 3100800 Beverage Revenue 160344 435165 440200 Other Revenue 135270 138868 141600 Total Revenue 2118474 3671813 3682600 Food & Beverage Cost 2900528 2558252 2668300 Food & Beverage Departmental Profit (782054) 1113561 1014300 Allocated Overhead 1110897 1460833 1483079 Food & Beverage Income after allocated overhead and before income taxes (1892951) (347272) (468779) Income Taxes (25%) (473238) (86818) (117195) Food & Beverage Net Loss (1419713) (260454) (351584) Exhibit 2:  Presentation of Cash Flows from the two proposed investments. Proposal 1: The Hamptons Hotel proposal to renovate the restaurant with restaurant access directly from the street. Year  (all amounts in US dollars) 0 1 2 3 4 5 Initial renovation costs -1800000 Cash Increase in Food & Beverage Revenue 775200 852720 937992 1031791 1134970 Cash Increase in Food & Beverage Costs 271320 298452 328297 361127 397240 Net Increase in Food & Beverage Operating Cash Flow 503880 554268 609695 670664 737731 Less: Depreciation on the original investment 360000 360000 360000 360000 360000 Net Taxable after Depreciation 143880 194268 249695 310664 377731 Less: Income Taxes on Net Operating Cash Flow 35970 48567 62424 77666 94433 Add: Depreciation (noncash) 360000 360000 360000 360000 360000 Additional investment in Working Capital Required 15504 1550 1706 1876 2063 Reserve for Equipment Replacements (CAPEX) 6000 22004 24554 26760 29636 Net Cash Flow -1800000 446406 482147 521011 564362 611599 Net Working Capital Required 0 15504 17054 18760 20636 22699 Cost of Capital Beta of the equity ? Premium on the market ? Risk free rate of return ? Cost of Equity Financing ? Percentage of equity financing ? Cost of Debt Financing ? Percentage of debt financing ? Weighted Average Cost of Capital ? Note:  All perecentages should be stated in two decimal places. Evaluation of Proposal 1: Payback Periods ? Average Return on Investment ? Internal Rate of Return ? Net Present Value (Discounted Cash Flows) ? Proposal 2:  Leasing the restaurant to Rick’s Steak and Seafood Year  (all amounts in US dollars) 0 1 2 3 4 5 Initial investment to provide street accessibility -950000 Annual Lease income 62000 62000 62000 62000 62000 Increase in Lobby Bar sales net of costs 9700 10185 10694 11229 11790 Decrease in overhead costs 200000 200000 200000 200000 200000 Net cash gain from sale of bar equipment 80000 0 0 0 0 Less: Depreciation on original investment 190000 190000 190000 190000 190000 Net Taxable after depreciation 161700 82185 82694.25 83228.9625 83790.41063 Income Taxes (25%) 40425 20546 20674 20807 20948 Add: Depreciation 190000 190000 190000 190000 190000 Add: Decrease in Working Capital 70000 0 0 0 0 Net Cash Flow -950000 381275 251639 252021 252422 252843 Cost of Capital Beta of the equity ? Premium on the market ? Risk free rate of return ? Cost of Equity Financing ? Percentage of equity financing ? Cost of Debt Financing ? Percentage of debt financing ? Weighted Average Cost of Capital ? Note:  All perecentages should be stated in two decimal places. Evaluation of Proposal 1: Payback Periods ? Average Return on Investment ? Internal Rate of Return ? Net Present Value (Discounted Cash Flows) ?

READ ALSO :   accounting extra credit