Net Present Value and Papa Geo free essay sample

The restaurant would be located in Orlando, Florida and would majorly target middle to lower-middle class families with children, as well as adults and seniors, thus making it a friendly and family place. The major product and service provided by the restaurant would be Italian food served buffet style with an all-you-can-eat format with a lot of variety including a salad bar, pizza, several different types of pasta with three or four types of sauces, soup, desserts, and a self-serve soda bar. There would also be a gaming area within the restaurant with gaming machines installed which would be of interest to children. The business would provide wholesome and fresh food, in a simple format, with very good prices and is located in a densely populated area, all of which would help the restaurant to do well and establish itself as a popular and profitable business. * * * Also, provide a second paragraph which describes how the budget supports the company’s strategy. We will write a custom essay sample on Net Present Value and Papa Geo or any similar topic specifically for you Do Not WasteYour Time HIRE WRITER Only 13.90 / page * * Finally, provide a third paragraph where you summarize the key points from your budget, including the planning horizon, the amount of up-front investment, the NPV, Payback and IRR of the project, as well as key figures from your income statement, cash flow statement, and balance sheet. * Remember, this is not a thesis or introduction of what you will talk about – it contains the major, specific content of each section. The second and third paragraph should be written after you have completed all other sections of this template. * * As you complete sections of this template, please remove all italicized text in all sections of this template and replace it with your own or you will lose points! * * 2. 0 Sales Forecast 2. 0 Sales Forecast * * This section forecasts the sales of Papa Geo’s restaurant over a five-year period. Section 2. 1 gives the estimated sales figures and a brief explanation on the changes in these figures over the planning period. * Section 2. 2 delves into the details of how this sales estimate has been arrived at, calculations involved and the methods and assumptions used in the process. * Overall, this section is useful is providing an estimate of how much the restaurant can make in sales, given its internal specifics and external environment. * 2. 1 Sales Forecast * * The yearly sales forecast for Papa Geo’s restaurant is given below. In $ | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Sales | 933,504. 00 | 1,555,840. 00 | 1,616,517. 76 | 1,679,561. 95 | 1,745,064. 87 | * My methods and assumptions for arriving at the sales figures in the table are detailed in section 2. 2 The sales figure estimated per my calculations is taken as the sale figure for Year 2. This is because the sales figure arrived at from the calculations cannot be assumed to be sales for Year 1 as the restaurant might not be able to realize its full potential and attract the estimated number of customers from day one itself. Also, teething problems with marketing, operations etc might not lead to optimum sales. Therefore, we will project only 60% of this figure as first year sales and use the estimated figure as the sales figure for Year 2. Over the planning period, starting from Year 2 onwards, sales are expected to grow at a rate of 3. 9% every year, in line with industry estimates of the average growth of the restaurant industry in the US (Source: Mintel International, cited in section 6. 0). * * 2. 2 Methods and Assumptions * According to the brief given on Papa Geo’s restaurant, there are about 10,000 families living within 15 minutes of the restaurant. Of these, between 3% and 5% are rich households (Phoenix marketing international, Wikipedia) and it is assumed that another 15% comprise of high income and upper middle class households. That leaves about 80% of the 10000 families in the area,that are the target market for the restaurant. * * According to a research paper (in restaurant. org), American families eat out about 4 times a week. However, considering that our target market comprises of mostly middle and lower income families, I’ve assumed that they eat out only about 2 times a week on an average. This means that, about 16000 families [(80%*10,000)*2] eat out in a week in that area in Ohio, Florida. * * In terms of competition, although it is mentioned that McDonalds, Taco Bell and Wendy’s operate in the area, we assume there are other small places that people might visit to eat out. Also, people might venture out beyond their areas to eat out. Keeping these in mind, we’ve assumed that these four places (Papa Geo’s, McDonald’s, Taco Bell and Wendy’s) will be able to capture only about 85% of these families. (16000*85%=13600/week). Of these four places, since the others are fast food and fast food restaurants generally command a larger footfall than other format restaurants we assume the following about their share in the pie of families: Taco Bell: 30%, McDonald’s: 30%, Wendy’s: 30% and Papa Geo’s: 10% * * i. e, Papa Geo’s can expect to capture 1360 (10%*13600) families per week. Since this is a family dining place, we make another assumption about the composition of the family. We assume that out of a family of 4, two are kids and two adults. Which means that about 2720 (1360*2) kids and 2720 adults (1360*2) will eat from Papa Geo’s per week. * * Given that a meal (including drinks) cost about $7, we make the following assumptions: * Adults visiting the restaurant will have meals (@ $7), on an average. * Kids visiting the restaurants with their families will make a bill of about $4 per head. Given this, we now estimate the weekly sales for adults and kids. Therefore, d * Sales from Adults per week: 2720*7 = 19040 * Sales from Kids per week: 2720*4 = 10880 * * Now, the total sales (both adults and kids, as part of families) per week can be estimated at: 19040+10880 = $29920 * Therefore, average sales per year = 1,555,840 * The sales figure estimated by these calculations is taken as the sale figure for Year 2. This is because the sales figure arrived a t from the calculations cannot be assumed to be sales for Year 1 as the restaurant might not be able to realize its full potential and attract the estimated number of customers from day one itself. Also, teething problems with marketing, operations etc might not lead to optimum sales. Therefore, we will project only 60% of this figure as first year sales, and use the estimated figure as the sales figure for Year 2. Over the planning period, starting from Year 2 onwards, sales are expected to grow at a rate of 3. 9% every year, in line with industry estimates of the average growth of the restaurant industry in the US (Source: Mintel International, cited in section 6. 0). * * * * * * * * * * * * * * * * * * 3. Capital Expenditure Budget 3. 0 Capital Expenditure Budget * * Capital Expenditure Budget: * Item| Cost| Quantity| Total cost| Source| Notes and Assumptions| Cost of registering a business| 300| | 300| ehow. com| Cost of registering includes: actual cost of registering ($70), legal fees and misc expenses (approx $230)| Renovation of facility| 15000| 1| 15000| Given| This includes all kinds of beautification etc that the restaurant needs to start operations| Soda fountain ba r| 3621| 1| 3621| Soda-dispenser. om| Prices quoted may or may not be the same at later dates| 2 pizza ovens| 849| 2| 1698| ebay| Prices quoted may or may not be the same at later dates| salad and Pizza/dessert bar| 1450| 1| 1450| ebay| Prices quoted may or may not be the same at later dates| Commercial Refrigerator| 3529| 1| 3529| Coldtechcommercial. com| Prices quoted may or may not be the same at later dates| Cash Register| 170| 2| 340| ebay| Prices quoted may or may not be the same at later dates| Video game vending machine| | | | | | Type 1| 550| 2| 1100| ebay| Prices quoted may or may not be the same at later dates| Type 2| 750| 2| 1500| ebay| Prices quoted may or may not be the same at later dates| Laptop for management| 275| 1| 275| ebay| Laptop purchased with Warranty, Price quoted may or may not be the same at later dates| desk for mgmt| 25| 1| 25| ebay| Prices quoted may or may not be the same at later dates| Staff Microwave| 319| 1| 319| ebay| Prices quoted may or may not be the same at later dates| Staff cupboard| 100| 1| 100| Assumed| | taff refriferator| 700| 1| 700| ebay| Prices quoted may or may not be the same at later dates| Tables for the restaurant| 279| 20| 5580| tableschairsbarstools. com| Prices quoted may or may not be the same at later dates| Chairs for the restaurant| 55| 80| 4400| restaurant-services. com| Prices quoted may or may not be the same at later dates| Busing cart for restaurant| 50| 1| 50| ebay| Prices quoted may or may not be the same at later dates| Commercial dishwasher| 2500| 1| 2500| ebay| Prices quoted may or may not be the same at later dates| Restaurant signage| 124| 1| 124| brightledsigns. om| Although this is a form of advertising, this wouldnt be considered as an operating cost given the long term (more than a year) nature of its use| Total| Â  | Â  | 42611| | | * * The above table provides an estimate of the capital budget required for Papa Geo’s restaurant. For each item, sources and assumptions used are explained towards the right side of the table. Other generic assumptions beyond those already mentioned are provided below: * Miscellaneous cooking and handling equipment cost will be considered operational expenses and will not be capitalized given the short term (less than a year) use of such assets.