John Levitt owns a popular burger stand on a trendy section of Melrose Boulevard. Following the success of his first burger stand, "Johnny's Burgers," which has been in operations for five years, John is now considering opening a second burger stand in another trendy location, on Sunset Boulevard in the Silver Lake area. John's market research shows that the clientele in both areas is similar: young professionals, typically without children, who like the traditional aspect of eating burgers, but also relish his gourmet, specially manufactured low-fat burgers and the healthy side dishes his stand also sells. John's overall plan is to get the second stand up and running for four years, and then sell both stands off to a new owner and retire to Santa Barbara.

John estimates that the cost of starting up a second stand will be as follows:

Purchase of retail kiosk (mobile retail food outlet) $750,000

Specialized kitchen equipment $60,000

Installation of the kitchen equipment $20,000

Furniture and fittings $50,000

John estimates that annual operating costs of the new location would be identical to those of his current stand:

Labor costs, inclusive of all overhead costs:

Kitchen and service staff (5 people) $200,000

License and rent costs $150,000

Raw materials:

Burgers (275 per day x 7 days x 52 weeks), see burgers' cost below

Drinks $38,400

Other food supplies $145,800

Nonfood supplies $50,200

The revenues at his current location are as follows:

Sales of burgers $6 per burger

Average daily sales 275 burgers

Other food items $270,000

Drinks $190,000

In addition to contributing profits, John expects that opening a second stand will decrease the cost of purchasing gourmet burgers from $1.5 cents to $1.35 cents in both locations. This is due to economies of scale. John also expects that he will be able to manage both locations himself, avoiding hiring a manager for the new location.

Assume that:

Increase in the receivables (AR) is expected to be equal to 12% of gross sales; the project will require additional cash (for giving change to the stand's customers paying cash) in the amount of 5% of gross sales. There will be no considerable investment in inventory as John implements "just-in-time" inventory system to keep the products fresh. Increase in payables associated with the new stand is estimated to be equal to 15% of the cost of raw products

Net working capital is fully recovered (i.e., reduced to zero) at the end of year 4

The marginal tax rate is 34 percent.

Cost of Capital is 10 percent.

Cost of the stand (kiosk), together with the cost of the equipment and the installation, is depreciated over five years according to the straight-line method.

Note: The definition of an asset's cost is all costs that are necessary to get an asset in place and ready for use. Therefore, the cost of the installation labor (wages and related fringe benefits) is part of the cost of the asset (and not an immediate expense of the accounting period).

The stand (together with the kitchen equipment) is expected to be worth $300,000 after four years of service.

1. Construct a model in Excel to evaluate the project.

You may use "Home Net" spreadsheet for inspiration. DO NOT follow it literally though as this is a different project with its own unique features.

2. What is the NPV of this investment?

3. Consider several values of cost of capital (for example, check values between 7% and 13% with 1% step) and compute NPV for each of these values. Use "Data Table" Construct NPV profile: Let cost of capital be your X-variable and NPV be your Y-variable.

4. Set some goal value for NPV (choose a value yourself) and use "goal seek" to find number of burgers that the new stand must sell annually to achieve the goal.

5. Suppose that you are unsure about the price John would be able to charge. John would like to generate at least $200,000 in NPV with the new kiosk. Using "goal seek" find price per burger necessary to achieve this goal

The following seven elements explain the fundamentals of sports economics for professional leagues: Advertising Attendance Fan Demand Player Salaries Team Revenues Using the diagram below, 1) place the seven elements in the appropriate box and 2) explain why you placed them there: Year 2010 Year 2011 Year 2012 Price Quantity Price Quantity Price Quantity Chips $4 100 $4 110 $5 80 Dips $5 50 $4 40 $3 50 Sodas $3 50 $5 60 $5 70 Question 1. GDP [10 Points in Total] a. (3 points) Compute nominal GDP in 2010, 2011, and 2012. [Show your computation work] b. (3 points) Compute real GDP in 2010, 2011, and 2012 (base year method). [Show your computation work] c. (2 points) Compute GDP deflator in 2010, 2011, and 2012. [Show your computation work] d. (2 points) Compute growth rates of nominal GDP and real GDP from 2010 to 2011 and from 2011 to 2012. [Show your computation work] Question 2. Inflation [7 Points in Total] a. (3 points) Compute cost of CPI basket in 2010, 2011, and 2012. [Show your computation work] b. (2 points) Compute CPI in 2010, 2011, and 2012. [Show your computation work] c. (2 point) Compute inflation rates (based on CPI) from 2010 to 2011 and from 2011 to 2012. [Show your computation work] Question 3. Business Cycle [3 Points in Total] a. (2 points) Based on your answers on Question 1 and 2 above, did Aggieland experience an expansion or a recession from 2010 to 2011? How about from 2011 to 2012? Was it at peak or trough or neither in year 2011? b. (1 point) From 2010 to 2011, did Aggieland experience an inflation or deflation? How about from 2011 to 2012?QUESTION 30 The rule of 70 states that O the number of years it takes an economy to double in size is the growth rate divided by 70. O the number of years it takes an economy to double in size is 70 divided by the growth rate. the number of years it takes an economy to double in size is the growth rate times 70. it takes an economy 70 years to double its real GDP QUESTION 31 Matt works only part-time due to the not so ideal economy situation in Connecticut, he is willing and activel time job even though he has a part-time job. In a normal calculation of U6, as measured by the BLS, Matt w Included in both the numerator and denominator Included in the denominator only O Included in the numerator only Not in Not included in either the numerator or denominator QUESTION 32QUESTION 1 All risk that stockholders bear should be compensated with higher expectations for returns True False. Only firm risk compensates through higher expected returns )False, Only market risk compensates through higher expected returns False. Only interest rate risk compensates through higher expected returns QUESTION 2 For the majority of stocks, what percentage of their returns fall between 1 and 2 standard deviations away from their average return? About equal to 27% Greater than 279% Less than 2796 About 13.5%X InQuizitive: Chapter 26: The Aggregate Demand-Aggregate Supply Model e Page 847 26.4. How does the aggregate demand-aggregate supply model help us understand the economy? Que supply model? Which of these are conditions for long-run equilibrium in the aggregate demand-aggregate YOU C Correct Answer(s) Long-run aggregate supply equals aggregate Curr demand. You mutt ana Short-run aggregate supply equals aggregate demand. Question H 9 M acer