ECON 134A CASE STUDY 2 - Upland Restaurant Case

Hello, if you have any need, please feel free to consult us, this is my wechat: wx91due

ECON 134A

CASE STUDY 2 - Upland Restaurant Case

Valuing Mutually Exclusive Capital Projects

Instructions

This case study will ask you to evaluate mutually exclusive investment opportunities by putting yourself in the shoes of two recent graduates turned restaurant owners and investors. After reading the background scenario carefully, you will have to answer a series of preparatory questions and write an executive summary. The questions are meant to guide you to prepare the executive summary. You are free (and encouraged) to work on additional analyses to make your executive summary stronger.

You will have to upload a single pdf document containing 1) the one-page executive summary, 2) answers to the preparatory questions,  and 3) all the tables and appendices  backing up your analysis, including  any additional work you think is helpful.

Note that points will be awarded for presentation. This includes the ease with which one can understand your work, whether your final document is nicely formatted,  whether tables and exhibits  are clear and well- documented, etc. You may want to think of your report as something you would feel comfortable handing in to your boss if you were a financial analyst.

You may work in groups of up to four students, in which case you only needto submit one reportPlease make sure to include the names and student IDs of all students in the file. Working in groups is highly recommended.

Background

After graduating from  UCI  2 years ago, you and three friends decided to start  Upland  Restaurant.   After searching for several months for a location in Irvine, you decided togo a different route and buy 5 acres of land including an old restaurant and a small building, formerly used for offices, at the edge of town. After renovating the old restaurant, you were able to open and grow sales over the past 2 years.  However, lacking the initial capital, you never did anything with the other smaller building.   Now that you have saved up some cash, you and your friends feel like you can generate some extra income from the existing building. To that end, you and your team  have  paid $20,000 to a consulting firm for a forecast of the future  revenues and costs associated with the different options you are considering. The exhibits given below are the outcome of the consulting firmsresearch.

Your first option is to enter a leasing agreement with a former Anteater who runs an event planning company called Diamond Events.  After describing the location and space to her, she is interested in renting it out to host a variety of events. To make this possible, you will have to renovate the space first, which will take time and money. Additionally, if Diamond Events were to lease the space, you and your team expect there to bean increase in repairs, maintenance, and utilities as well as a slight decrease in restaurant sales from an overall decrease in ambience from the additional event goers (loud partyers, congested parking lot, etc.).   Diamond Events is willing to sign a 4-year lease with an annual rent of $84,000 in the first year, growing at 5% thereafter. The team’s additional assumptions are given below in Exhibit 1; where the renovation cost is a one-time capital expenditure and the increase in repairs, maintenance, and utilities, is an annual cost.

Note: All operating income are taxable, therefore operating expenses reduce the taxable income, while capital expenditures such as renovation costs and equipment costs are not tax deductible.

Exhibit 1: Leasing to Diamond Events Assumptions

Project life

4

years

Renovation cost

90,000

USD

Tax rate

21%

Cost of capital

13.00%

Rental growth rate

5%

Increase in repairs, maintenanceand utilities

15,000

USD

Decrease in restaurant sales

8.0%

Below in Exhibit 2 are the original projections of net restaurant sales for the next 6 years, were you not to undertake any new project with the small building.

Exhibit 2: Baseline Projection of Restaurant Sales

Year

1

2

3

4

5

6

Net restaurant sales

$ 225,000

$ 240,000

$ 260,000

$ 285,000

$      300,000

$      310,000

The other option the team is considering is starting a small craft brewery in the space.  While the renovations would be much less expensive, in order to start the brewery, your team would need to buy and install the required equipment.   Additionally,  there would  be  other  increases  in costs to consider.   A  major  benefit, however, is that the brewery would serve as a complement to your existing restaurant business.  Your team feels that offering your own unique craft beers will lead to more food sales than would otherwise occur without them. You project that your craft beverage sales will start at $85,000 in year 1 and grow at 7.5% annually after that. Additional assumptions are found below in Exhibit 3; where the renovation and equipment costs are one-

time capital expenditures and the increase in repairs, maintenance, and utilities, is an annual cost. NoteThe equipment is assumed not to depreciate overtime.

Exhibit 3: Building Craft Brewery Assumptions

Project life

6

years

Renovation cost

25,000

USD

Equipment cost

150,000

USD

Tax rate

21%

Cost of capital

13.00%

Sales growth rate

7.5%

Brewing ingredient costs

40%

of sales

Other operating expense

12%

of sales

Increase in repairs, maintenanceand utilities

10,000

USD

Increase in restaurant sales

15.0%

Lastly, your team needs to consider what you can do with the craft brewery after the project life is over. After brainstorming, you feel that there are 2 possible outcomes after the 6 years are up. The first outcome, outcome A, is that the project does not go as planned, in which case you will have no other option than simply ceasing operations. The second outcome, outcome B, is that the project goes well, you develop a good menu of craft beverages and a steady customer base. In this case, you believe that you will have two options after Year 6. The first option, option B.1., is for an outside investor to purchase the craft brewery portion of your business.


The second option, option B.2., is to simply continue operations, which you will value as a perpetuity.  The necessary assumptions are given below in Exhibit 4.

Exhibit 4: Terminal Options

Outcome A - Cease Operations

Outcome B, Option 1 - Sell to Investor

Outcome BOption 2 - Continue Operations

Project ends after 6th year. No future cash flows.

Sell craft brewery operations to an outside investor for an estimated $600,000 at the end of the 6th year.  Capital gains tax rate is 15%.

Continue operations indefinitely after the 6th year.  Net operating profits after taxes is expected to grow 1.5% annually.

For outcome B, your team is unsure about what the best option is and is hoping you can help them determine which one would add the most value to the business.  Additionally, from your time in business school, you are aware that valuation techniques are very sensitive to the assumptions that are made.  While you and your team worked very hard on projecting sales, growth rates, etc., you understand that these are just expectations and that actual values can be higher or lower, impacting the attractiveness of the options.  Therefore, it will be important to conduct sensitive analyses on some of the key parameters.

Preparatory Questions

1)    Lease option

a.    What are the relevant costs and benefits of leasing the additional space to Diamond Events?

b.    Are any costs or benefits irrelevant?

c.    What is the NPV of leasing the additional space to Diamond Events?

d.    What is the IRR?

e.    Do the NPV and IRR decision making rules agree?

f.     Sensitivity analysis

i.    Construct a cost of capital sensitivity table for all valuation types with costs of capital

ranging from 11% to 15% in increments of 0.5%. That is fill in the following chart:

LEASE OPTION COST OF CAPITAL SENSITIVTY

Cost of Capital 11.0%      11.5%     12.0%      12.5%     13.0%      13.5%      14.0%     14.5%      15.0%

NPV

ii.    Construct 3x3 NPV and IRR Sensitivity Analyses reflecting the following information

LEASE OPTION NPV SENSITIVITY

Increase in repairs, maintenance, and utilities

7,500 15,000                  22,500

Decrease in

restaurant sales

4%

8%

12%


2)    Build option - Outcome A:  Cease operations

a.    What are the relevant costs and benefits of starting the brewery?

b.    Are any costs or benefits irrelevant?

c.    What is the NPV of starting the brewery?

d.    What is the IRR?

e.    Do the NPV and IRR decision making rules agree?

f.     Sensitivity analysis

i.    Construct a cost of capital sensitivity table for all valuation types with costs of capital

ranging from 11% to 15% in increments of 0.5%. That is fill in the following chart:

Build OPTION COST OF CAPITAL SENSITIVTY

Cost of Capital 11.0%      11.5%     12.0%      12.5%     13.0%      13.5%      14.0%     14.5%      15.0%

NPV

i.       Construct 3x3 NPV and IRR Sensitivity Analyses reflecting the following information

BUILD OPTION (A) NPV SENSITIVITY

Brewing ingredient costs

30% 40% 50%

Increase in restaurant

sales

0%

15%

30%

3)    Assuming the worst outcome for the craft brewery project (outcome A), which option should Upland choose: do nothing, lease to Diamond event, or open craft brewery? Why?

4)    Assuming a good outcome for the craft brewery (outcome B), which of the two options (B.1. or B.2.) offers most value?

Executive Summary

Prepare a short (less than 1 page) executive summary that lays out major assumptions you used and what decision you have arrived at: should you go ahead with the leasing option, the craft brewery option, or leave the small building idle?




发表评论

电子邮件地址不会被公开。 必填项已用*标注