Question
IV. Mini Case (spreadsheet tab MiniCase) Crazy Brook Meadow Ski Resort The Crazy Brook Meadow Ski Resort, hereafter CBM, is a small ski resort in
IV.
Mini Case (spreadsheet tab MiniCase)
Crazy Brook Meadow Ski Resort
The Crazy Brook Meadow Ski Resort, hereafter CBM, is a small ski resort in Northern New England. CBM does not have snow making capability and depends, therefore, on Mother Nature to provide the snow for the ski season. The owner is worried that climate change may affect snow fall and the business may suffer under years where snow fall is low. CBM does not have enough cash reserves to go through a truly bad ski season. Average snow fall for the resort is approximately 220 inches a season. The average revenue for a ski season is approximately $30 million. The resort has a breakeven revenue need of $20 million. Your own personal prediction for snowfall for the 2021 ski season (fall/winter 2020 through winter/spring 2021) is 170 inches. The national weather service is predicting 190 inches. An area (Northern New England) snowfall contract is available on a U.S. futures exchange. The contract settles at $500 times the snowfall in inches for the contract area, and trades in points (inches), with the minimum movement being 0.5 inches. The contract is currently at 190. Do a statistical analysis (like a regression) on the data. At 190 inches how much revenue would you predict for CBM? At 170 inches how much revenue would you predict for CBM? Suppose you wanted to hedge against the National Weather Service prediction. How many contracts would you need (in round numbers) to hedge against a drop in snowfall?
| Breakeven Revenue | $ 20,000,000 | |
| Snowfall | Revenue | |
| Average | 220 | $ 30,000,000 |
| Season | ||
| 2004 | 210 | $ 27,515,912.00 |
| 2005 | 296 | $ 48,989,347.00 |
| 2006 | 272 | $ 42,985,009.00 |
| 2007 | 116 | $ 4,004,574.00 |
| 2008 | 321 | $ 55,240,139.00 |
| 2009 | 226 | $ 31,506,324.00 |
| 2010 | 303 | $ 50,749,276.00 |
| 2011 | 242 | $ 35,519,955.00 |
| 2012 | 181 | $ 20,230,138.00 |
| 2013 | 151 | $ 12,755,140.00 |
| 2014 | 346 | $ 61,514,213.00 |
| 2015 | 234 | $ 33,505,697.00 |
| 2016 | 163 | $ 15,759,282.00 |
| 2017 | 122 | $ 5,488,905.00 |
| 2018 | 155 | $ 13,733,320.00 |
| 2019 | 212 | $ 27,986,787.00 |
| 2020 | 198 | $ 24,501,997.00 |
| 2021* | 170 | |
| 2021** | 190 | |
| *predicted by you | ||
| ** National weather service | ||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Analysis For Financial Management
Authors: Robert Higgins, Jennifer Koski, Todd Mitton
13th Edition
1260772365, 978-1260772364
