Financial Statement Preparation |
| OPERATING ANALYSIS |
| Click on the highlighted areas and a description will appear in a new window. |
Frozen Capital - Used Vehicle InventoryPage 4, Lines 4+9+12+13+14+15 MTD Sales minus Page 4, Lines 4+9+12+13+14+15 MTD Gross. Multiply result by 1.5. Then Subtract result from Page 1, lines 22+23+24+25+26+27. Frozen Capital - Parts InventoryPage 5 line 41 minus line 42 times 2, then subtract results from page 1 line 28 Frozen Capital - PSB ReceivablesPage 5 line 41 of P, S, B Sales minus page 5 line 9+12+14+29+31 of P, S, b times .5, then subtract results from page 1 line 9 Total SalesLine 36 of New & used Vehicle Department Section plus line 41 of Parts, Service and Body Shop Department Section Total GrossLine 37 New & Used Vehicle Department Section plus line 44 of Parts, Service, and Body Shop Department Section Total ExpenseLine 45 and 61 on New & Used Vehicle Department Section plus line 59 of Parts, Service, Body Shop Department Section plus line 23 and 24 of Fixed Expense Section Operating ProfitOperating Profit = Line 55 minus line 56. Should agree with line 14 of Operating Summary % TOTAL SALESCalculate percentages by dividing the amounts posted (Month and YTD) for Total Gross, Total Expense and Operating Profit. Additions & Deductions to Income-Bonuses and Profit by Total Sales (line 54). Carry % to one place beyond decimal |