800 words and excel calculations and work. Please see the attachments.
FIN 325 Course Project
Guthrie’s Golden Fried Chicken Fingers Franchise*
Instructions: You will draft a written report of approximately 800 to 1000 words plus tables. The report should explain your analysis, address the prompts, make a recommendation, and justify the recommendation. You may choose to address the case presented below or a real-world case of your own choosing that I approve in advance.
You may work individually or in groups of up to three people. You will decide on group members after the first exam. If you decide to work in a group, however, any disputes between group members must be resolved within the group and you will not have the option of working independently if you commit to working in a group. In general, all group members will earn the same grade on their assignment. However, group members will be asked to evaluate each other and I may use these evaluations to adjust the grades assigned to individual group members.
THE CASE: Guthrie’s 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 Guthrie’s in Auburn, Alabama. Originally, Guthrie’s 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 Guthrie’s Signature Sauce. During the 1980s, The Guthrie family opened Guthrie’s 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, Guthrie’s was a household name throughout much of the Southeast.
Now, more than 50 years since first opening, Guthrie’s 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 Guthrie’s 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 Guthrie’s Franchise? Prepare a report responding to the following prompts:
1. Prepare pro forma income statements and operating cash flow projections. Explain your pro forma statements in your report.
2. Estimate the total cash flows for this opportunity. Explain your estimates in your report.
3. Estimate the opportunity’s NPV. Explain how you arrived at your NPV estimates in the report.
4. 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.
5. What is your recommendation? Should you and your partners pursue this opportunity? Explain your recommendation and provide your rationale.
*Some of this information is drawn from Guthrie’s web page (guthrieschicken.com), but all the financial figures are fictional.
Instructions: You will draft a written report of approximately 800 to 1000 words plus tables. The report should explain your analysis, address the prompts, make a recommendation, and justify the recommendation. You may choose to address the case described on Blackboard (in the Course Information folder) or a real-world case of your own choosing that I approve in advance.
You may work individually or in groups of up to three people. If you decide to work in a group, however, any disputes between group members must be resolved within the group and you will not have the option of working independently if you commit to working in a group. In general, all group members will earn the same grade on their assignment. However, group members will be asked to evaluate each other and I may use these evaluations to adjust the grades assigned to individual group members.
1. If you plan to work in a group, please send your section instructor an email by November 1 indicating who will be working together. Please be sure to cc all group members.
2. You (or your group) will turn in your final report, including tables and text, in a Word or PDF format. You will also submit your excel spreadsheet. You will submit all of this to your section instructor via email by Wednesday, December 9, 5pm. You will lose 10% every day it is late.
3. You (if doing the project individually) or your group must work independently. You must do the calculations and writing independent of other groups or individuals. Any evidence of collaboration between groups or individuals will result in a zero score for the groups/individuals involved. Conversation and discussion is fine, but any evidence of sharing excel files or the written report will be treated as evidence of a violation of academic integrity, and everyone involved (regardless of their role) will receive a zero score.
4. 50% of your grade on the project will be based on the accuracy of your calculations. We will grade individual portions of the calculations separately with the goal of not penalizing you twice for one mistake. That is, if you make a mistake in calculating OCF (as an example), but then use that incorrect number correctly from that point forward, you will receive credit for correctly using the incorrect number.
5. 30% of your grade will be based on the content of your written report. We will focus on how clearly and accurately you explained your analysis and responded to the prompts. We will also be concerned about whether the written report aligns with the calculations and tables. Do not make the mistake of glossing over important details or assuming we understand what you are intending with your writeup. Our advice is to write your report as though you were explaining your analysis to another student who is smart but does not understand project analysis as well as you. Such an approach will usually yield the right level of detail in your explanations.
6. 20% of your grade will be based on polish. Is it well written? Are there typos? Are there grammar mistakes? Is it well formatted? Does it look nice? Do the tables make sense? The answers to these questions will directly influence 20% of your grade (and indirectly influence the rest of your grade).
7. If you work in a group, you will be asked to evaluate your group members based on their teamwork. Were they actively engaged in the project? Did they put in the same effort as others? Did they do what they said they would do? Were they helpful and supportive of other group members? Would you work with that person again? Note that this will focus on attitude and engagement more than the quality of their contributions. The results of these evaluations MAY cause me to adjust an individual group member’s grade by up to 20%.
Please read this details carefully and let me know if you have any questions.