Case Study: Jim Foster is the owner of Selwyn Pub in North Carolina. Jim's family was the owner of the pub for over four decades. The distinguishing feature of the Selwyn Pub is the massive oak tree in front of the pub, its branches and leaves cascading over the side walk. The tree became the arbor for outdoor dining and pub services, giving a natural gift of green shade and breeze through the hot summer months and cool sunshine in early Fall and late Spring. The outdoor area was approximately 50 feet by 50 feet. Each table occupies 12 feet by 8 feet, seating 22 tables, after accounting for walk throughs. Over the years, Jim noticed that the tree was not as abundant and despite repeatedly service from expert arborists (tree doctors), the tree was in failing health. The town decided that the tree was danger to property and people and decided on its imminent removal. Foster was convinced that nothing would replace the tree to his business and to its patron. However, will the removal of the tree offer opportunities for his business? Review attached spreadsheet for further inputs for analysis Clearly, each replacement would involve different costs and benefits to his business. These are some of the thoughts Foster considered. A. Do nothing. After all, Foster observed, neighborhood pubs only provided outdoor seating using shade created by adjoining buildings. The loss of shade can potentially reduce both indoor and outdoor revenue. B. Invest in a non-retractable awning for an outdoor space, giving additional protection in clear and rainy days. Foster was concerned that the non-retractable awning would block outdoor sunshine and adversely impact both indoor and outdoor revenue? Could non-retractable awning raise revenue on rainy days and reduce revenue on bright, hot days? C. Invest in a retractable awning to create outdoor space, giving the option of both sunshine and share. Could this option raise both outdoor and indoor revenue streams? Foster estimated explicit costs as follows: 1) Costs of non-retractable awning: $50,000 2) Costs of retractable awning: $100,000 Foster also estimates that financing investment would require additional bank loans. The interest rate on the loan is estimated at 7% annually. Foster intends to apply for a business line, pay interest only for 12 months, and the principal back at the end of 12 months. Questions 1. Using your knowledge of marginal analysis and evaluation of extant decisions (potential investment), evaluate the alternative presented above and recommend to Foster the best rational decision. Hint: Use excel function =NPV to calculate the PV of future cash flows over the 12 months. Use the annual cost of bank funds, adjusted to a monthly rate, as the discount rate. 2. Use your analysis to justify the bank loan application for the recommended alternative. 3. What risks would Foster and the bank consider in evaluating the investment? 4. What cognitive biases should Foster be on the lookout for during the decision making process? Explain your reasoning. 5. What is the Economic profit per month of alternative A? how do i upload the file