Richard Borgman and Kirk Ramsay Kirk Ramsay was a serial entrepreneur. Another way to characterize him was as a small businessman who enjoyed new challenges and new adventures. After earning his business degree at the state university, Kirk built several successful businesses. He designed and built homes, owned several rental properties, and ran a property management business, and continued to follow his musical passion by playing lead guitar in a successful local cover band. In the small city in New England where he lived, he saw a need for a local no-frills, good food, breakfast and lunch eatery located downtown, where the national chains did not locate. He had found his next potential projectwhich he planned to call The Local Caf. And he had found the empty storefront in which to put the restaurant. The landlord had urged Kirk to make his decision in a few days, because he claimed to have another interested party. To make the decision, Kirk would calculate NPV, IRR, and payback period. The restaurant was part of a clearly defined life plan. His children were now grown; Kirk and his wife hoped to work about ten years more to solidify their retirement, and in ten years move to a warmer climate, hopefully fully retired or, if necessary, semi-retired. So if opened, Kirk expected to own and operate the restaurant for about 10 years. After establishing it as a successful business, he planned to sell the restaurant as part of his plan to move at least part of the year to a warmer climate. The space Kirk had found was about 3,000 square feet, enough for a kitchen and ten tables. The monthly rent was $600, leased triple net, meaning that the renter was responsible for all other costs, including utilities. He anticipated other building-related costs of $300/month for insurance and $500/month for utilities (water, sewer, gas, trash removal). He believed these costs would increase at least with inflation, which he assumed to be about 4 percent per year. To prepare the space, which had not previously been a restaurant, Kirk anticipated the following costs: stove, $1,600; double fryer, $800; sinks, $700; preparation tables, $1,500; pots and pans, utensils, glasses, and dishes, $1,500; 10 tables and 40 chairs, $2,000 in total. The costs to renovate the space (plumbing, electric, carpentry, and signage) would be $10,000. All these costs were subject to depreciation. Kirk assumed a 5-year depreciable life and prepared a modified accelerated cost recovery system (MACRS) schedule. For the first year, Kirk assumed the following revenues. The average breakfast patron would spend about $7.50. He assumed that with a 40-person capacity, there would be about 30 people per sitting, and about two turns per day. The average lunch patron would spend about $11.50. There would be 30 people per sitting, and about three turns per day. The restaurant would close in the early afternoon and would not serve dinner. The plan would be for the restaurant to be open 5 days a week (260 days per year). To control costs, the restaurant would not have an extensive menu, serving standard breakfast fare (eggs and bacon and the like) and having rotating specials for lunch plus a standard menu. Kirk anticipated consumables and perishables costs to be about 60 percent of revenues. Other non-labor costs would be about 3 percent of revenues. There would be three cooks working three overlapping 8 hour shifts, making $11 an hour. There would be two servers working two overlapping 8 hour shifts, making $4 per hour (plus tips). Finally, there would be a manager who normally operated a register as well, making $12 per hour for a daily 8 hour shift. Over the following years, Kirk expected revenues to increase at least with inflation (as before, assumed to be about 4 percent per year). Costs would remain at the current percentage of revenues. Net working capital (NWC) was assumed to be 5 percent of revenues in the upcoming year (for example, NWC at t = 1 equals 5 percent of t = 2 revenues). The change in net working capital was calculated as NWC in the current year minus NWC in the previous year (thus change in NWC for t = 1 is NWC (t = 1) minus NWC (t = 0). Kirk faced a 35 percent tax rate. He could borrow from a local bank at 9 percent. The loan would have five-year amortizing, monthly payments, and no prepayment penalty. The loan was secured by the equipment and, as was usual, required a personal guarantee by Ramsay. He estimated his cost of equity and financing weights using data from a sample of 84 publicly traded restaurant firms compiled by Answath Damodaran (http://pages.stern.nyu.edu/~adamodar/). These firms had an average unlevered beta (unlevered means the beta if there was no debt in their capital structure) of 0.69, an average debt-to-equity (D/E) ratio of 0.2757, and an average correlation with the market of 0.3053. He knew that he could calculate a levered beta using the following simplified Hamada equation: BetaLevered = BetaUn-levered * (1+(1-T) * (D/E)) Ramsay assumed that his mixture of debt and equity financing (D/E) would be close to the industry average. Ramsay also realized that he was relatively undiversified in comparison with the stockholders of a large publicly traded firm. Damodaran suggested that an undiversified beta, called total beta, could be approximated by dividing the market beta (the firms levered beta) by the correlation between the market and the individual restaurant firms. Radd = Adjustment factor * BetaUn-levered* (Rm Rf) The security market line equation from the capital asset pricing model, used to calculate the cost of equity, is: RL = Rf + BetaLevered * (Rm Rf) Cost of Equity = Re = RL + Radd where MRP is the market risk premium, gRF is the risk-free rate, and beta in this case is the total beta. He planned to calculate his project weighted average cost of capital (WACC) as, WACC = weRe + wdRd(1 T) where w are the weights of equity and debt, respectively, and g refers to the costs of equity and debt, respectively. T is the tax rate. In ten years, when Kirk expected to sell the restaurant to fund his retirement, he knew the value would depend on cash flow. To be conservative, he valued the sale in ten years as a no-growth perpetuity; that is, the firm would be worth the present value of a perpetual series of constant cash flows (based on t = 10 cash flow). Also, to be conservative, he assumed that the sale would be fully taxable. Kirk wanted a payback within three years, assuming a risk-free rate of 3.04 percent and an equity risk premium of 5 percent. Questions: I have worked out an excel template for your analysis. However, all the results are hard-coded numbers. You need to figure out the excel formula to replicate my analysis. Such an exercise also can server as a template for your other work in project analysis. Once you have created a spreadsheet to analyze the project, you should be able to create additional scenarios. Here are some of the changes you need to make Reduce the lunch price from 11.5 to 11. Inflation is scaled down from 4% to 3%. Tax rate is scaled down from 35% to 30%. Average S&P500 risk premium is adjusted from 5% to 5.5%. Cost of debt adjusted from 9% to 8%. Please incorporate the above changes into your Excel worksheet and update the calculations. With the updated calculations, please answer the following questions.

What is Ramsays cost of capital to use in the analysis?

Calculate the expected sale price of the restaurant at the end of year 10 (that is, at t = 10).

Using all these answers, calculate the projects NPV, IRR, and payback period. Based on these calculations, should Ramsay go ahead with the project?

	Industry	Number of firms in sample	Unlevered beta	Unsystematic risk adjustment factor for beta			Number of firms in sample	Unlevered beta	Unsystematic risk adjustment factor for beta
	Advertising	65	0.73	4.266		Heavy construction	46	1.22	1.2203
	Aerospace, defense	95	0.92	2.1175		Homebuilding	32	1.23	1.2515
	Air transport	25	0.52	2.7867		Hotel, gaming	89	0.9	2.5806
	Apparel	70	0.99	2.7381		Household products	139	0.89	3.8576
	Auto parts	75	1.23	1.8859		Information services	71	0.81	1.7
	Beverages	47	1.24	3.5149		Internet software and services	330	1.05	4.4316
	Beverages (alcoholic)	19	0.93	2.7359		Machinery	141	0.96	1.6138
	Biotechnology	349	1.07	4.2222		Metals and mining	134	0.9	3.8475
	Broadcasting	30	1.1	1.9887		Office equipment and services	30	0.82	1.4741
	Brokerage and investment banking	49	0.33	1.5462		Oil and gas distribution	80	0.55	1.8186
	Building materials	37	1.07	1.343		Oilfield services, equipment	163	1.17	1.9525
	Business and consumer services	179	0.75	2.2246		Packaging and container	24	0.73	1.0791
	Chemical (specialty)	100	0.95	1.7817		Paper, forest products	21	0.93	1.7822
	Computer services	129	0.82	2.9972		Pharmaceuticals and drugs	138	1.03	3.2703
	Computer software	273	1.04	2.6655		Publishing and newspapers	52	0.87	2.6891
	Computers, peripherals	66	1.13	2.8819		Real estate (development)	22	0.85	2.8024
	Construction	18	0.77	2.4059		Real estate (operations and services)	47	0.94	4.0758
	Educational services	40	1.04	3.3313		Recreation	70	1.11	2.8666
	Electrical equipment	135	1.07	3.0638		Restaurant	84	0.71	2.3116
	Electronics	191	1	3.2237		Retail (automotive)	30	0.8	1.8263
	Electronics (consumer and office)	26	1.08	2.6005		Retail (distributors)	87	0.74	2.38
	Engineering	56	1.13	1.5648		Retail (general)	21	0.8	1.8299
	Entertainment	85	0.99	3.3646		Retail (groceries and food)	21	0.58	2.4285
	Environmental and waste services	108	0.81	3.9113		Retail (Internet)	47	1.02	3.1829
	Financial services	76	0.58	2.2173		Retail (special lines)	137	0.78	2.2239
	Food processing	97	0.71	2.6459		Semiconductor	104	1.14	1.7847
	Furniture, home furnishings	36	1.03	2.1108		Semiconductor equipment	51	1.21	1.9286
	Healthcare equipment	193	0.77	3.22		Shoes	14	0.81	2.0437
	Healthcare facilities	47	0.56	2.0639		Telecommunication equipment	131	1.11	2.57
	Healthcare products	58	0.89	2.7051		Telecommunication services	82	0.63	3.4359
	Healthcare services	126	0.72	3.2714		Trucking	28	0.77	1.6574
	Healthcare information and technology	125	0.92	3.6152		Total market	7766	0.64	2.5729

Number of firms in Unsystematic risk adjustment factor for beta Number of firms inUnlevered beta Unsystematic risk adjustment factor for beta Unlevered beta 2 5 2 Beverages (alcoholic) 9 2 Brokerage and investment banking Building materials Business and consumer services Chemical (specialty Oil and gas distribution Oilfield services, equipment 1 Computers, peripherals Real estate (operations and services 1 2 6 Electronics (consumer and office) Retail (distributors 1 Environmental and waste services 1 2 5 Retail (special lines) Semiconductor equipment Telecommunication equipment Furniture, home f 2 4 Healthcare facilities Healthcare information and technology Total market