What is the current ratio?, What is the Quick ratio (Acid Test) for the dealership?, What is the Debt to Equity ratio?, What is the gross profit margin for New Vehicles.
What is the gross profit margin?, What is the pre-tax profit margin for the dealership?, What is the return on equity?, What is the inventory turnover for New vehicles?
What is the days supply of new vehicles?, What is the ROA?
2,325,318 . . . 2015 59,855 . 279,200 T 62,647 (42,216) 2200 2205 2,075 22 2011 6,713 30,038 2,723,630 304,186 PORO NET CASH 25 METEO 866,550 79) ASSETS BALANCE SHEET LIABILITIES 1 CASH ON HAND IN BANK 75.260 1010 P NEW VEHICLES & DEMOS . 2 MONEY MARKET / DEPOSIT 448,200 N USED VEHICLES 3 FINANCE CONTRACTS NEW o Y REMARKETED VEHICLES 4 USED T A RECREATION VEHICLES 5 MARKETABLE SECURITIES OTHER - SHORT TERM 2000 6 6 NOTES RECEIVABLE P SL LONG TERM - CURRENT PORTION 2040 7 Discounted Notes Receivable (NON US) A D E INSTALLMENT SALE BALANCE 8 ACCOUNTS VEHICLE S U 76,480 BANK LOANS (AUTHORIZED LIMIT) (NON US) RECEIVABLE PARTS SERVICE BODY 2100 E 18,633 52,310 ACCOUNTS PAYABLE 10 OTHER INCOME TAXES 11 W & P CLAIMS 5,057 CUSTOMER DEPOSITS 2300 VEHICLE HOLDBACK 14,910 ACCOMODATIONS-SVC. CONTRACTSIREPO REFUND 1929 13 INCENTIVES / CARRYOVER ALLOWANCE 1135 TAXES 14 FBO 117 JAG CSI 1172 JAG FAC 117 PAYROLL & BONUSES 15. LIMG 1114 LCSI MER ACCRUED PROFIT SHARING (NON US) 140 16 JOBBER INCENTIVES / FLOOR PLAN ASSISTANCE / OTHER 7,511 OTHER 17 DEFERRED INTEREST LEASING INCOME (CURR PORT-NON US) / ) 18 FINANCE RECEIVABLES - CURRENT TOTAL CURRENT LIABILITIES 19 ALLOWANCE - DOUBTFUL RECEIVABLE 20 N CARS FORD 30 - OTHER . 1300 789,801 NEW 96,962 VEHICLE EQUITY USED 21 E TRUCKS FORD 58 - OTHER 1,632,479 NET CASH 720,216 22 W DEMO OTHER AVERAGE MONTH TOTAL EXPENSES 107,749 23 u CARS 8 30 5 RN 102,708 NET CASH OVER (UNDER) 612,467 24 s TRUCKS 11 DAY 4 178,164 MORTGAGES PAYABLE 2500 CARS 3 30 3 40,069 LONG OFFICERS & OWNERS 2010 26 VEHICLES TRUCKS 3 DAY 3 43,100 TERM FORD 27 PARTS INV POMOC 124,94040 MON POMOCO 6,5760 131,516 LIABILITIES NOTES OTHER 28 ALLOWANCE - PARTS INVENTORY ADJUSTMENT PAYABLE LEASED VEHICLES SGD 29 OTHER INVENTORIES MEMO WORK IN PROC 121 RENTAL VEHICLES 30 LIFO INVENTORY INEW 14 JUSED JESTIMATED LIABILITY - REPOSESSION PURCHASE LOSS 31 RESERVE PARTS OTHER LIABILITIES 1500 32 PREPAID EXPENSES 31,944 TOTAL LIABILITIES 33 TOTAL CURRENT ASSETS 3,629,551 5610 34 LEASED VEHICLES - NET UNITS CAR TRUCK - SED CAPITAL STOCK 35 RENTAL VEHICLES - NET RETAINED EARNINGS 2510 36 LAND AND IMPROVEMENTS - NET CORPORATION LEGAL RESERVE (NON US) 260 37 BUILDINGS COST 459,593 OTHER CAPITAL RESERVE (NON US) 38 DEPRECIATION ITS 277,128 FIXED ASSET REVALUATION (NON US) 39 1720 EQUIPMENT COST 38,425 SUB "S" DIVIDENDS DECLARED 2001 40 DEPRECIATION 38,425 ) PARTNERS" OR INVESTMENT 41 LEASEHOLDS COST 1750 1,000 PROPRIETOR'S DRAWING 240 42 AMORTIZED 1735 NET INVESTMENT 43 FINANCE RECEIVABLES DEFERRED NET NET PROFIT - AFTER INCOME TAX - YTD 44 RECEIVABLES - OFFICERS & EMPLOYEES NET WORTH 45 CASH VALUE. LIFE INSURANCE TOTAL LIABILITIES & NET WORTH 46 OTHER ASSETS - NET 47 TOTAL ASSETS 3,813,016 48 USED VEHICLE INVENTORY ACTUAL 905,921 49 FROZEN PARTS INVENTORY RECOMMENDED MINIMUM OR GUIDE 673.251 50 CAPITAL PSB RECEIVABLES ACTUAL OVER (UNDER) 232,670 51 TOTAL ACCOUNTS RECENABLE AGING 52 OPERATING ANALYSIS CURRENT 31-60 61 - 90 53 MONTH YTD YTD VEH. ACCOUNTS 76,480 54 SALES 643,516 11,334,782 % TOTAL SALES PARTS ACCOUNTS 55 TOTAL GROSS 97,658 1,486,582 15.2 13.1 SERVICE ACCOUNTS 33,677 14,561 3,982 56 EXPENSE 150,262 1,292,986 23.4 11.4 BODY ACCOUNTS 57 OPERATING PROFIT (52,604) 193,596 (8.2 1.7 WARR. RECEIVABLES 5.057 58 ADD / DED. TO INCOME - BONUSES (12,156) 2,128 (1.9) 0.0 FORD INCENTIVES 59 PROFIT BEFORE INCOME TAX (64,760) 195,724 (10.1) 1.7 NOTES. RECEIV. 2000 1,000 3,591,180 NET WORTH 9,840 16,272 ROD RO 1728 NO 26,112 195,724 221,836 3,813,016 WORKING CAPITAL 91 + MONTH OPERATING SUMMARY DOLLARS DEPARTMENTAL OPERATING SUMMARY PARTS SERVICE MONTH YTD NEW USED BODY IN OPERATING SUMMARY 1 TOTAL SALES 2 3 TOTAL GROSS 4 643,516 11,334,782 lu UNITS YTD CAR TRK 59 142 97 113M % TOTAL GROSS M MONTH YTD 97,658 1,486,582 M 95,925 741,557 98.2% 49.9% 5 TOTAL SELLING 6 EXPENSE 7 TOTAL SELLING 8 ADJUSTED SELLING GROSS 8 9 TOTAL FIXED 130,088 2,521,375 11,383 195,979 23,776 160,275 (12,393) 35,254 11,642 115,961 1,226 10,562 (25,261) (91,269) 106,346 1,213,770 32,132 368,111 14,006 111,661 18,126 256,450 11,863 121,903 1,226 10,562 5,037 123,985 1,733 745.025 338,473 6,745,676 24,530 412,950 29,157 242,717 (4,267) 170,233 11,847 124,702 1,226 10,562 1,770 34,969 ADDITIONS 1.8% 50.1% 68,809 853,961 29,613 509,542 29,986 226,454 627 283,088 14,081 146,616 1,226 10,561 (14,680) 125,911 MONTH (48) 39 49,433 509,182 50.6% 34.3% M 4,904 42,247 5.0% 2.8% 10 EXPENSE 11 DEALER SALARY 12 13 OPERATING PROFIT 14 15 LEASED VEHICLE 16 RENTAL VEHICLE 17 RECREATIONAL VEHICLE (52,604) 193,596 -53.9% 13.0% 5300 YTD 5200 CASH DISC. EARNED 9100 1,706 422 2000 INTEREST INCOME 18 DIVIDED INCOME 8200 19 TRACTOR / OTHER 9050 SALES FIXED ASSETS 9250 20 ADJ. TO INCOME 9100 9800 2,128 0.1% OTHER 9300 350 (7) (12,149) 0.0% -12.4% 21 CUSTOMER SATISFACTION ADJ 2420 DEDUCTIONS 9060 CASH DISCOUNT 0400 9500 OTHER 450 9000 (2) (7) 9550 TOTAL 2,128 22 INDEMNITIES NON US 23 DEALER BONUS 24 EMPLOYEE 25 PROFIT BEFORE 26 INCOME TAX 27 EST. INCOME TAX (64,760) 195,724 -66.3% (7,196) 13.2% 974 1171 FORD BLUE OVAL (12,149) 1174 9900 % TOTAL SALES LIMG 28 PROFIT SHARING NON US 1170 9910 LCSI SIMER 9920 1171 29 COMBINED CAPITAL RESERVE 30 NET PROFIT AFTER TAX 1172 (64,760) 195,724 - 10.1% 1.7% MJAG CIS NJAG FAC 31 PNVS M 1179 E N JAG TDB 5,249 4.366 R (12,149) 32 TOTAL OVERHEAD EXP 33 TOTAL P.S. BS GROSS 34 NET OPERATING COST 35 VEHICLE GROSS 36 TOTAL VAR. SALES EXP TOTAL CUST SATISFACTION NON-US DEALER ADJUSTMENTS (MEMO) 120,956 61,745 59,211 35,913 29,306 6,607 1,055,129 877,653 177,476 608,929 237,857 371,072 13,440 6,861 6,579 3,990 3,256 734 883 3,029 1,183 1,846 EXCHANGE RATE ADJUSTMENT MONETARY ADJUSTMENT 37 VARIABLE GROSS YTD MONTH 124,251 38 BREAKEVEN UNITS MONTH YTD 1,016,018 TOTAL PAYROLL 157 Service Absorption: The Sum of Total Parts, Service & Body 39 N.O.C. /VAR. GROSS PNUVR 125 NEW VEHICLE DEPARTMENT YEAR TO DATE MONTH GROSS SALES UNITS GR PVS UNITS GR PVS SALES GROSS 3000 001 3000 CROWN VICTORIA TAURUS T-BIRD 3 1.539 70.319 4,618 1 2 3 4 5 B 7 CONTOUR 4 126,330 605,549 1,823 1 18 2,029 1,943 1,484 39.009 22.871 8,117 34,973 45,990 1,670 1 31 654,221 8 9 10 11 61,880 3,493 2 56 1,673 2,156 1,456,419 110,927 93,698 6,469 12 3 13 14 15 16 3001 17 301 18 3 2,156 110,927 6,469 19 20 21 22 61,880 3,493 2 59 1,698 1,567,346 100,167 23 300 24 - 3975 - 25 26 27 2 61,880 30,171 3,493 1,895 59 17 28 1 151 3490 11 14 45,681 MUSTANG 1,823 500 1,670 FOCUS R2X2 E FIESTA (MEXICO ONLY) 310 2010 TTBD (MEXICO ONLY) 2003 1,747 A TOTAL FORD RETAIL CARS 1 GRAND MARQUIS 2200 3201 L COUGAR H SABLE LS 23 TOWN CAR CONTINENTAL TOTAL LIM RETAIL CARS JAGUAR CARS VOLVO CARS NON FOMOCO CARS 3941 1,747 TOTAL RETAIL CARS FORD MOTOR CO.FLEET CARS NON FOMOCO FLEET CARS TOTAL FLEET CARS CAR INCENTIVES 1,747 TOTAL NEW CARS 1,895 ESCAPE EXPLORER Se 1,949 R EXPEDITION 30 E EXCURSION 3,400 T FREESTAR A ECONOLINE / CLUB WAGON 1 RANGER 2,604 LF150 (UNDER 85008 GVW) 31 390 F-SUPER DUTY (F-250-350 OVER 8500 G 800 FREESTYLE 2,523 TOTAL FORD LIGHT TRUCKS RETAIL VILLAGER MOUNTAINEER 250 360 NAVIGATOR BLACKWOOD wo TOTAL LM LIGHT TRUCKS RETAIL 04 OTHER PAG TRUCKS NON FOMOCO LIGHT TRUCK 2,523 TOTAL LIGHT TRUCK RETAIL FLEET LIGHT TRUCKS 2,523 TOTAL LIGHT TRUCK RF-SUPER DUTY (F450-550 OVER 8500F GWW) TF-SUPER DUTY (F650-750) F TOTAL FORD COMMERCIAL TRUCKS T NON FoMoCo Class 4-7-8 TOTAL COMMERCIAL / OTHER TRUCKS UNIVEVO FLEET COMUNIC 1,949 11 29 30 31 32 33 1 353 2531 1 27 31,199 3,400 11 3431 1,698 1,719 1,774 1,949 3,081 1,520 ce 949 1,373 were 1.926 2,015 1,802 1,779 1,587,346 517,796 526,139 45,681 60.261 798,171 34,604 176,595 wee 1,743,864 736,184 473,931 5,113,226 100,167 C 29,225 L 24,839 E 1.949 2,081 41,047 949 9,614 84,743 D 30,226 E 23,423 249,096 1 34 7 44 169,542 10.415 4 15 35 36 37 38 39 13 140 276.593 17,659 7 40 41 42 43 - 44 45 46 276.593 17,659 7 249,096 47 140 2 142 1,779 881 1,787 5,113,226 65,104 5,178,330 1,762 250,858 48 276,593 17,659 7 49 3500 50 51 - 52 53 - 54 55 32,542 250,858 276,593 7 142 1,767 5,178,330 56 57 17,659 168 21,320 TRUCK INCENTIVES 2,523 DIA TOTAL NEW TRUCK DEALER YTD 2,369 TOTAL NEW VEHICLES - : MEMO INTERNET SALES 82 58 338.473 9 9 201 1,766 6,745,676 355,024 59 vo 60 CARL TOTA GRPM - NEW RETAIL LFARE ACTIVITY MONTH Y-T-D 61 62 UNTS 2 19 3,494 41.390 GRPMUNITS 1,747 4 2.178 67 5 8,289 124.498 2,072 1.858 LINITS 6 86 11,783 1,964 165.888 1.929 IN DEALER P&A CODE SALES CODE 1 MONTH December 20xx PG 4 SALES GROSS UNITS GR PVS USED VEHICLE DEPARTMENT UNITS GR PVS SALES GROSS 1 USED CARS RETAIL . 37 915 402,733 33,861 2 MEMO USED CAR RTL (FRANCHISE ONLY 3700 3 35,541 2,892 2 1,446 REMARKETED CARS RETAIL 15 1,478 260,130 22,166 4 M 65,647 5,922 3 1,974 USED LIGHT TRUCKS RETAIL 30 67 1,348 1,211,219 90,287 5 0 USED MED./HVY. TRK - RETAIL . - 6 REMARKETED TRUCKS RETAIL 11 1.349 229,140 14,844 7 USED CAR / TRK INCENTIVES 8 101,188 8,814 5 1,763 TOTAL USED RETAIL 130 1,240 2,103,222 161,158 9 12.100 280 1 280 USED CARS WHOLESALE 45 98 168,643 4,429 10 - REMARKETED CARS WHOLESALE 3805 11 16,800 500 2 250 USED TRUCKS WHOLESALE 35 178 249,510 6,219 12 REMARKETED TRUCKS WHOLESALE - 13 USED VEHINVENTORY ADJUSTMENT 14 28,900 780 3 260 TOTAL USED WHOLESALE 80 133 418,153 10,648 15 130,088 9,594 8 1,199 TOTAL USED VEHICLES 210 818 2,521,375 171,80 16 USED RETAIL CM NELLA UNITS LEASE ACTIVITY TOTAL GROSS GRPVL UNITS GROSS | OR PL UNITS CROSS GR PL UNITS CROSS GRP 17 MONTH - - 18 Y-TD LINK CR PRSLUN 19 MONTH YID MONTH YTD IR CRT CREPELLENT MONTH YTO -A RECONDITIONING MONTH YID MONTH YTD MONTH YTD 20 R 2 20 624 19,704 312 394 ANALYSIS 3 64 3,077 30,588 1,026 478 22 INCOME UNITS % PEN PVR F&I UNITS PEN INCOME 23 MONTH YTD MONTH YTD YTD MONTH YTD DEPARTMENT MONTH YTD YTD MONTH YTD MONTH YTD 24 1,157 22.107 14 170 85.4 129 111 2 43 33.1 158 91 789 11,828 25 - - - 26 168 3,405 1 13 6.5 19 17 4 3.1 10 1,296 EN 27 PVR 26 250 11,805 1 30 15.1 28 59 2 30 23.1 200 82 1.000 10,655 29 * - 30 1,635 20,609 182 104 3 394 31 - 186 - 1,789 32 3.210 357 57.926 291 F&INET INCOME 358 24,713 PUB 33 MONTH YTD PNVR MON 2,369 YTD MONTH YTD YTD 1.784 MON 1,919 34 1,322 35 ( 36 20,320 355,024 DIC 3,210 57,926 338,470 6,745,676 24,530 412,950 NEW VEHICLE SALES EXPENSE 9,980 104,376 CAR/TRUCK GROSS COST OF SALES ADJ.LIFO F&INET INCOME (LINE 31) TOTAL TOTAL - 357 291 NEW GROSS % SALES S 7.2 6.1 G 37 S 9,594 171.806 DC 1,789 24,173 130,088 2,521,375 11,383 195,979 USED VEHICLE SALES EXPENSE 8,592 71,724 38 VEHICLE 358 186 USED GROSS SALES 8.81 7.8 % TOTAL USED GROSS 75.5 36.6 G 39 % TOTAL NEW GROSS 40.7 25.3 40 2010 SALESPERSON SALES MANAGERS 41 U 42 871 0.8 5.2 1.0 588 1,913 3.6 3.0 9.3 43 4.9 44 9.6 4.6 4.8 45 46 3.362 20,070 19,123 ) 19.648 19,648 128,333 284.617 11.899 11.899 26,330 2,282 2,360 40 5,184 GEOER 15,957 8,573 720 729 2.477 36.6 117.3 (17.3) 21.1 65.1 34.9 3.0 3.0 10.1 10. 18.3 55.9 44.1 4,169 13,349 (1,966) 35,887 109,524 86,455 47 PO 31.1 68.9 2.0 2.6 6.4 + 2 - FO-Im Em 48 720 49 F&! pe PRE-DELIVERY 7040 PRE-DELIVERY ALLOWANCES FREE SERVICE / MAINT. & POLICY TOTAL VARIABLE EXPENSE VARIABLE GROSS SALESPERSON TO SALES NAGER 7300 OTHER E F&1 ADVERTISING MEMO: INTERNET ADV. . ADVERTISING REBATES PROMOTION TRAINING -2m - mo mrozm
