a) Compute a comprehensive set of financial ratios for High Country from Exhibits 4 and 5. Put these calculations in the Exhibit 4 tab under the Income Statements.

b) The case provides a set of forecast assumptions for High Country. Append these hard-coded assumptions for 2012-2015 to the right of the historical ratios computed in part a) in the Exhibit 4 tab. You will add four columns, one for each forecast year.

c) Forecast Free Cash Flow for High Country for 2012-2015. Put these forecasts in Exhibit 5 below the balance sheets. You will need to forecast several balance sheet accounts (but not all of them) in order to forecast FCF. Append these balance sheet forecasts in Exhibit 5.