THE CASE: Guthries restaurant was started in 1965 in Haleyville, Alabama, by Hal Guthrie. The restaurant began serving Chicken Fingers in 1978. In 1982, Hal and his oldest son Chris opened a Guthries in Auburn, Alabama. Originally, Guthries had a large menu including hamburgers, steak sandwiches, and chicken fingers. Soon after opening, however, the menu was limited to the overwhelmingly popular Chicken Finger box. The Box includes chicken fingers, French fires, cole slaw, Texas toast, and Guthries Signature Sauce. During the 1980s, The Guthrie family opened Guthries locations in several college towns throughout the Southeast, including Athens, Georgia, Tallahassee, Florida, and Tuscaloosa, Alabama. Hey also opened them in several towns. By the end of the 1980s, Guthries was a household name throughout much of the Southeast.

Now, more than 50 years since first opening, Guthries continues as a specialty restaurant with a limited menu focusing on Fried Chicken Fingers. It is still a family business, but its franchise business is steadily growing. As a result, people all over the U.S. can now enjoy Guthries Golden Fried Chicken Fingers.

You and your business partners are considering applying for a franchise. If approved, you expect startup costs to be $350,000 in real estate costs, which are not depreciable, plus another $500,000 in equipment that is depreciable. You will be allowed to depreciate the $500,000 in equipment on a five-year MACRS schedule. The $350,000 in real estate costs is not depreciable and should be included in the book value of the fixed assets associated with the franchise when it is sold. Your plan is to start and operate the business for 7 years at which time you expect to sell the business for $1,600,000. You expect to initially have working capital needs of $30,000, but these needs will grow by $5,000 per year. You expect sales in the first year to be $200,000 and that sales will grow by 10% per year. You project annual fixed operating expenses of $50,000 in the first year. These fixed expenses will grow by $3,000 per year. Your annual variable operating expenses are expected to be 50% of sales.

You expect to pay taxes of 21%. Assume your required return is 11%. Should you apply for a Guthries Franchise? Prepare a report responding to the following prompts:

Prepare pro forma income statements and operating cash flow projections. Explain your pro forma statements in your report.

Estimate the total cash flows for this opportunity. Explain your estimates in your report.

Estimate the opportunitys NPV. Explain how you arrived at your NPV estimates in the report.

Consider what happens to cash flows and NPV if Sales are 20% more than expected. What if sales are 20% less than expected? Discuss this analysis in your report.

What is your recommendation? Should you and your partners pursue this opportunity? Explain your recommendation and provide your rationale.

Hi, can you check my calculations for this project if I am doing it right. Below is the attached screenshots of my calculations for this project. I will really appreciate your help in correcting my calculations. Thank you very much in advance.

Sale $200,000 and will grow 10% per year Variable costs 50% of sales Fixed expenses is $50,000 in the first year and will grow $3,000bper year Tax rate is 21% Equipment $500,000 depreciable using MACRS depreciation of 5 years Zero Year Cash Flows Startup cost Cost of Equipment Working Capital $ $ $ $ $ (350,000) (500,000) (30,000) (880,000) 1 2 3 Total Cash Flow Sale Value of Business $ Working Capital $ - Total Cash Flow $ 3 1,600,000 70,000 (($30,000 + ($5,000 times number of years from year 0 to year 7)) 1,670,000 Q1 5 6 e Year Sales Variable Cost Fixed Costs = Depreciation Expense EBIT Taxes Net Income Pro Forma Income Statement A 1 2 3 3 4 7 $ 200,000.00 $ 220,000.00 $ 242,000.00 $ 266,200.00 $ 292,820.00 $ 322,102.00 $ 354,312.20 $ 100,000.00 $ 110,000.00 $ 121,000.00 $ 133,100.00 $ 146,410.00 $ 161,051.00 $ 177,156.10 $ 50,000.00 $ 53,000.00 $ 56,000.00 $ 59,000.00 $ 62,000.00 $ 65,000.00 $ 68,000.00 $ 100,000.00 $ 160,000.00 $ 96,000.00 $ 57,600.00 $ 57,600.00 $ 28,800.00 $ $ (50,000.00) $(103,000.00) $ (31,000.00) $ 16,500.00 $ 26,810.00 $ 67,251.00 $ 109,156.10 $ 10,500.00 $ 21,630.00 $ 6,510.00 $ (3,465.00) $ (5,630.10) $ (14,122.71) $ (22,922.78) $ (39,500.00) $ (81,370.00) $ (24,490.00) $ 13,035.00 $ 21,179.90 $ 53,128.29 $ 86,233.32 1 2 1 7 Year Ebit Depreciation Expense 5 Taxes Networking Capital Annual OCH Annual Cash Flow 2 3 4 5 6 $ (50,000.00) $(103,000.00) $ (31,000.00) $ 16,500.00 $ 26,810.00 $ 67,251.00 $ 109,156.10 $ 100,000.00 $ 160,000.00 $ 96,000.00 $ 57,600.00 $ 57,600.00 $ 28,800.00 $ $ 10,500.00 $ 21,630.00 $ 6,510.00 $ (3,465.00) $ (5,630.10) $ (14,122.71) $ (22,922.78) $ 5,000.00 $ 5,000.00 $ 5,000.00 $ 5,000.00 $ 5,000.00 $ 5,000.00 $ 5,000.00 $ 55,500.00 $ 73,630.00 $ 66,510.00 $ 65,635.00 $ 73,779.90 $ 76,928.29 $ 81.233.32 3 3 1 2 Year - Cash Flows Required Return Discounted Factor Net Present Value 0 1 2 3 4 5 6 $ (880,000.00) $ 55,500.00 $ 73,630.00 $ 66,510.00 $ 65,635.00 $ 73,779.90 $ 76,928.29 $ 11% 11% 11% 11% 11% 11% $ (880,000.00) $ 50,000.00 $ 59,759.76 $ 48,631.54 $ 43,235.81 $ 43,784.78 $ 41,129.01 $ 7 81,233.32 $ 11% 39,126.71 $ 7 NPV 1,670,000.00 11% 804,369.55 $ 250,037.15 4 47 48 Q4-A 49 If Sales are 20% more than the expected 50 Year 1 2 3 5 5 6 7 51 Sales $ 240,000.00 $ 264,000.00 $ 290,400.00 $ 319,440.00 $ 351,384.00 $ 386,522.40 $ 425,174.64 52 Variable Cost (50% of the sales) $ 120,000.00 $ 132,000.00 $ 145,200.00 $ 159,720.00 $ 175,692.00 $ 193,261.20 $ 212,587.32 53 Fixed Costs $ 50,000.00 $ 53,000.00 $ 56,000.00 $ 59,000.00 $ 62,000.00 $ 65,000.00 $ $ 68,000.00 54 Depreciation Expense $ 100,000.00 $ 160,000.00 $ 96,000.00 $ 57,600.00 $ 57,600.00 $ 28,800.00 $ 55 EBIT $ (30,000.00) $ (81,000.00) $ (6,800.00) $ 43,120.00 $ 56,092.00 $ 99,461.20 $ 144,587.32 56 Tax @21% $ (6,300.00) $ (17,010.00) $ (1,428.00) $ 9,055.20 $ 11,779.32 20,886.85 $ 30,363.34 57 Net Income $ (23,700.00) $ (63,990.00) $ (5,372.00) $ 34,064.80 $ 44,312.68 (5,372.00) $ 34,064.80 $ 44,312.68 $ 78,574.35 $ 114,223.98 58 59 60 Annual Cash Flows 61 Year 1 2 3 4 5 6 7 62 EBIT $ (30,000.00) $ (81,000.00) $ (6,800.00) $ 43,120.00 $ 56,092.00 $ 99,461.20 $ 144,587.32 63 Depreciation Expense $ 100,000.00 $ 160,000.00 $ 96,000.00 $ 57,600.00 $ 57,600.00 $ 28,800.00 $ 64 Networking Capital 5000 5000 5000 5000 5000 5000 5000 65 Tax $ (6,300.00) $ (17,010.00) $ (1,428.00) $ 9,055.20 $ 11,779.32 $ 20,886.85 $ 30,363.34 66 Annual OCF $ 71,300.00 $ 91,010.00 $ 85,628.00 $ 86,664.80 $ 96,912.68 $ 102,374.35 $ 109,223.98 67 68 69 Net Present Value 70 Year 0 1 2 3 4 5 6 7 71 Cash Flow $ (880,000.00) $ 71,300.00 $ 91,010.00 $ 85,628.00 $ 86,664.80 $ 96,912.68 $ 102,374.35 $ $ 102,374.35 $ 109,223.98 $ 72 Required Return 11% 11% 11% 11% 11% 11% 11% 73 Discounted Factor $ (880,000.00) $ 64,234.23 $ 73,865.76 $ 62,610.46 $ 57,088.79 $ 57,512.96 $ 54,733.51 $ 52,608.65 $ 7 NPV 1,670,000.00 11% 804,369.55 $ 347,023.90 75 Q4-B 76 If Sales are 20% less than expected 77 Year 1 2 3 4 5 6 7 78 Sales $ 160,000.00 $ 176,000.00 $ 193,600.00 $ 212,960.00 $ 234,256.00 $ 257,681.60 $ 283,449.76 79 Variable costs $ 80,000.00 $ 88,000.00 $ 96,800.00 $ 106,480.00 $ 117,128.00 $ 128,840.80 $ 141,724.88 80 Fixed costs $ 50,000.00 $ 53,000.00 $ 56,000.00 $ 59,000.00 $ 62,000.00 $ 65,000.00 $ 68,000.00 81 Depreciation Expense $ 100,000.00 $ 160,000.00 $ 96,000.00 $ 57,600.00 $ 57,600.00 $ 28,800.00 $ 82 EBIT $ (70,000.00) $(125,000.00) $ (55,200.00) $ (10,120.00) $ (2,472.00) $ 35,040.80 $ 73,724.88 83 Tax @21% $ (14,700.00) $ (26,250.00) $ (11,592.00) $ (2,125.20) $ (519.12) $ 7,358.57 $ 15,482.22 84 Net Income $ (55,300.00) $ (98,750.00) $ (43,608.00) $ (7,994.80) $ (1,952.88) $ 27,682.23 $ 58,242.66 85 86 87 Annual Cash Flows 88 Year 1 2 3 4 5 6 7 89 EBIT $ (70,000.00) $(125,000.00) $ (55,200.00) $ (10,120.00) $ (2,472.00) $ 35,040.80 $ 73,724.88 90 Depreciation Expense $ 100,000.00 $ 160,000.00 $ 96,000.00 $ 57,600.00 $ 57,600.00 $ 28,800.00 $ 91 Networking Capital $ 5,000.00 $ 5,000.00 $ 5,000.00 $ 5,000.00 $ 5,000.00 $ 5,000.00 $ 5,000.00 92 Tax $ (14,700.00) $ (26,250.00) $ (11,592.00) $ (2,125.20) $ (519.12) $ 7,358.57 $ 15,482.22 93 Annual OCF $ 39,700.00 $ 56,250.00 $ 47,392.00 $ 44,605.20 $ 50,647.12 $ 51,482.23 $ 53.242.66 94 95 96 Net Present Value 97 Year 0 1 2 3 4 5 6 7 98 Cash Flows $ (880,000.00) $ 39,700.00 $ 56,250.00 $ 47,392.00 $ 44,605.20 $ 50,647.12 $ 51,482.23 $ 53,242.66 $ 99 Required Return 11% 11% 11% 11% 11% 11% 11% 100 Discounted Factor $ (880,000.00) $ 35,765.77 $ 45,653.76 $ 34,652.62 $ 29,382.83 $ 30,056.60 $ 27,524.50 $ 28,465.70 $ 101 102 103 Comparing the Net Prest Value Percentage NPV 104 Base Estimation 10% base $ 250,037.15 105 Best Estimation 20% more $ 347,023.90 106 Worst Estimation 20% less $ 155,871.32 7 NPV 1,670,000.00 11% 804,369.55 $ 155,871.32