Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help with ? please Jim Foster is the owner of Selwyn Pub in North Carolina. Jim's family was the owner of the pub for

please help with ? please
image text in transcribed
image text in transcribed
image text in transcribed
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 broene 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 through Over the years, I noticed that the tree was not as abundant and despite repeatedly service from expert arborists (tree doctors), the tree was in falling 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? 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 to Create an outdoor space, giving additional protection in dear 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 rate revenue on rainy days and reduce revenue on bright, hot days? 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 owning: $100,000 Foster also estimates that financing investment would require additional bank loan. 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. Review attached spreadsheet for further inputs for analysis Reference: Review attached spreadsheet for further inputs for analysis. Reference: Modified based on Cox, 5, Foster, 1. Burson, T. & Repede, . (2018). A Tree Dies and a Pub Suffers. Journal of Case Studies, 36(2), 19+ 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 Rows 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 connessh. Foster be on the lockor 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? 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 to create 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 loan. 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. Review attached spreadsheet for further inputs for analysis. Reference: 9:58 LTE Done MBA6620 MID Assessment... 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 to create 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 loan. 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. Review attached spreadsheet for further inputs for analysis. Reference: Modified based on Cox, S., Foster, J., Burson, T., & Repede, J. (2018). A Tree Dies and a Pub Suffers. Journal of Case Studies, 36(2), 19+. 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? 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 broene 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 through Over the years, I noticed that the tree was not as abundant and despite repeatedly service from expert arborists (tree doctors), the tree was in falling 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? 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 to Create an outdoor space, giving additional protection in dear 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 rate revenue on rainy days and reduce revenue on bright, hot days? 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 owning: $100,000 Foster also estimates that financing investment would require additional bank loan. 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. Review attached spreadsheet for further inputs for analysis Reference: Review attached spreadsheet for further inputs for analysis. Reference: Modified based on Cox, 5, Foster, 1. Burson, T. & Repede, . (2018). A Tree Dies and a Pub Suffers. Journal of Case Studies, 36(2), 19+ 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 Rows 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 connessh. Foster be on the lockor 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? 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 to create 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 loan. 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. Review attached spreadsheet for further inputs for analysis. Reference: 9:58 LTE Done MBA6620 MID Assessment... 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 to create 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 loan. 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. Review attached spreadsheet for further inputs for analysis. Reference: Modified based on Cox, S., Foster, J., Burson, T., & Repede, J. (2018). A Tree Dies and a Pub Suffers. Journal of Case Studies, 36(2), 19+. 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Financial Markets Prices, Yields, And Risk Analysis

Authors: Mark Griffiths, Drew Winters, David W Blackwell

1st Edition

0470000104, 9780470000106

More Books

Students also viewed these Finance questions

Question

How may the maturity date of a promissory note be stated?

Answered: 1 week ago

Question

What are the outcomes the client wants?

Answered: 1 week ago

Question

What has been done before?

Answered: 1 week ago