Read the case study entitled Rocky Mountain Vacations. Follow these steps in analyzing the case: Assuming the status quo (no change to existing practices), prepare pro forma income statements, cash budgets, balance sheets, and ratio tables for quarter 1, 2, 3 and 4 of 2017. Note The status quo includes the decision to reduce the dividends to CAD 200,000 and to delay the purchase of new service bay equipment to beyond 2017 due to the low utilization of existing facilities. For each quarter, discuss the changes in cash flows, the financial decisions made, and whether the company is meeting its financial goals and lending conditions in each quarter based on Step 1. What possible actions can RMV take to achieve its financial goals (higher profitability, reduced borrowing, and capital accumulation for the new dealership) and lending conditions? Are they reasonable? Implement all reasonable actions identified in Step 3, and prepare revised pro forma income statements, cash budgets, balance sheets and ratio tables for quarter 1, 2, 3 and 4 of 2017. Is RMV able to meet its financial goals and lending conditions after making the changes to the financial plan? How should the company proceed? Submission Requirements Prepare pro forma income statements, cash budgets, and balance sheets for quarter 1, 2, 3 and 4 of 2017 as required in discussion question 1. This should be done in a unique Excel workbook (separate from that required by question 4 as outlined below). Prepare revised pro forma income statements, cash budgets, and balance sheets for quarter 1, 2, 3 and 4 of 2017 as outlined in question 4. This should be done in a separate Excel workbook from Part 1 (above). Prepare a 2-page memorandum addressing discussion questions 2, 3, and 5.