I'm working on an Advanced Financial Management Accounting project. I need to create a budgeted income statement, cash flow budget, and budgeted balance sheet, as well as a Memorandum and financial ratios.

Student Instructions Follow these steps in analyzing the case: 1. 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. 2. 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. 3. 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? 4. 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. 5. Is RMV able to meet its financial goals and lending conditions after making the changes to the financial plan? How should the company proceed?\fbelanoe sheets for quarter l, 2, 3 and 4 {hi-2017.15 required in discussion question 1. This should be done in a separate Excel workbook from Part 2. 2. Prepare revised pro Penna income summits. cash budgets. and balance sheets for quarter I. 2, 3 and 4 ofll T as required in discussion question 4. This should be done in a separate Excel workbook from Part 1. 3. Prepare a Ledge memorandum addressing discussion questions 2, 3, and 5. Fro forms. Template The pro Forrna nancial statements should be prepared using the templates: Budgeted Income Statement Quarter I Quarter 1 Quarter 3 Quarter + Year Sales RV Freedom Independence Autonomy Total Service Parts Storage Total sales Expenses Freedom Independence Autonomy Toul Service Parts Supplies Selling Administration and storage Depreciation Total expensesCash Budget Quarter 1 Quarter ] Quarter 3 Quarter & Year Cash balance, beginning Cash receipt Last quarter This quarter Service Parts Storage Interest income Total cash receipts Cash disbursements Purchases Last quarter Service Technician Parts Supplies Selling Administration and storage Interest expense Regular dividends Capul purchase Total cash disbursements Sub-total Financing Repayment Ling-of-credit Term loan - Regular loan paynice Term loan - Extra loan payment Borrowing Ling-of-credit Term loan Special dividends Izusince and repurchase of shares Total financing Temporary investment Cash balance, rodinlyQuarter I Quarter 1 Quarter 3 Quarter 4 Current much Cash Temporary Investments Accounts receivable Income taxes receivable Total current auch Fixed assets, net Current liabilities Accounts payable Line of cmade Income wives payable Current portion of long-term debt Total current babilities Term loan Shareholders' equity Common shares Retained cummings Total liabilities and equities Kry Financial Ratios Quarter 1 Quarter 2 Quarter & Quarter # Current ratio ( 1.50) XX XX XX XX Net profit margin Total asset bumover XX Rectum on assets XX Rcour on equity XX Line of credit / (A R + Inventory) ($ 1.00) Xx XX. imes interest earned () 4.50) XX. Long-term debt / Total capitalization (- 250%] XX Xx xx LOC financing (maximum CAD 5,500,000) XX XX XX Note: Net profit margin, total asset turnover ratio, return on assets, return on equity and times interest earned should be calculated at the end of the year only using yearly data. Memorandum Template The following template should be used in preparing the memorandum:Memorandum To: calculated at the end of the year only using yearly data. Memorandum Template The following template should be used in preparing the memorandum: Memorandum To: From: Subject: Date: (Short introduction) Status Quo (Address the questions asked in Step 2 of the Case Analysis section) Quarter 1 Quarter 2 Quarter 3 Quarter 4 Possible Actions (Address the questions asked in Step 3 of the Case Analysis section using the table below.) Possible Action ReasonablenessRecommendations (Address the questions asked in Step 5 of the Case Analysis section.) Grading Rubric You will be graded using the following criteria. Quality of Spreadsheets: 20% Physical appearance Input page