2021 FORD MOTOR COMPANY DEALER FINANCIAL …

2021

P&A CODE 0129 PERIOD OF0130

FORD MOTOR COMPANY DEALER FINANCIAL STATEMENT

DEALER

ADDRESS

REC'D 0131

2021

SALES CODE

MONTH ENDED

ASSETS

1

ON HAND IN BANK

CASH

2

MONEY MARKET/DEPOSIT

3

NEW

FINANCE CONTRACTS

4

USED

5 MARKETABLE SECURITIES

6 NOTES RECEIVABLE

7 Discounted Notes Receivable (NON US)

8

VEHICLE

9 ACCOUNTS PARTS SERVICE BODY 10 RECEIVABLE OTHER

0050

P A S T

D U E

0051 0052 0053

0054

11

INCOME TAX REFUND

12 F W&P CLAIMS O

13 R VEHICLE HOLDBACK

14 D INCENTIVES

15

R

0063 Lincoln

ES t

0064 Ford Support

0065 CSR(FoC)

16 C JOBBER INCENTIVES/ESP/FLOOR PLAN ASSISTANCE/OTHER

17 FINANCE RECEIVABLE CURRENT

18 ALLOWANCE - DOUBTFUL RECEIVABLE

19 CARS

20 N TRUCKS E

21 W DEMO

0080 FORD 0083 FORD 0086 FORD

22

CARS

NON CPO

23

TRUCKS

U 24 S 25 E

D

CPO CARS (Franchise

Only) TRUCKS

26

REMARKETED CARS

27

VEHICLES TRUCKS

0089 0091 0110 0111 0093 0094

0081 LINC 0084 LINC 0087 LINC

60 DAYS

0082 OTHER 0085 OTHER 0088 OTHER 0090

0092

60 0095 DAYS 0096

28

0097 PARTS INV. FOMOCO

1400 0098 1405 NON FOMOCO

29 ALLOWANCE - PARTS INVENTORY ADJUSTMENT

30 OTHER INVENTORIES

31 LIFO INVENTORY 0100 NEW

32

RESERVE

PARTS

0099

MEMO: WORK IN PROCESS

1470

0101 USED

33 PREPAID EXPENSES

34 TOTAL CURRENT ASSETS

35 LEASED VEHICLES NET

0102 UNITS: CAR

36 RENTAL VEHICLES NET

0103 TRUCK

37 LAND AND IMPROVEMENTS NET

38

BUILDINGS

COST

CITY-STATE/PROVINCE ZIP/POSTAL CODE

0132

BALANCE SHEET

LIABILITIES

1000 0001 -1010 1015 0002

1020 0003

1030 0004

P NA OY TA

NEW VEHICLES & DEMOS USED VEHICLES - NON CPO CPO VEHICLES (FRANCHISE ONLY) REMARKETED VEHICLES

2000 0201 2005 2010 0202

2017 0401

2015 0203

1040 0005 1100 0006

( 1105 0007

E B RECREATION VEHICLES

SL E

OTHER - SHORT TERM

)

LONG TERM - CURRENT PORTION

2020 0204 2030 0205 2040 0206

1110 0008 1125 1120 0009

1130,1131 0010 1132,1135

1139 0015

1140 0011 1150 1160 0012

1170 0013

1174 1176 0014 1177 1180 0017 -1200 1280 0019

( 1290 0020

1291 1300 0021 1305 1310 0022 1315 1340 0023 1345 1330 0024 1350 1360 0025 1370 1380 0301

OVERDRAFT/LINES OF CREDIT (LINE OF CREDIT

208

LIMIT)

ACCOUNTS PAYABLE

ACCOUNTS PAYABLE - CUSTOMER SALES TAX

INCOME TAXES

DEPOSITS

CUSTOMER ACCOMMODATIONS-SVC CONTRACTS/REP REFUND

TAXES

PAYROLL & BONUSES

ACCRUED PROFIT SHARING (NON US)

OTHER

)

DEFERRED INTEREST INCOME (CURR PORTION - NON US)

TOTAL CURRENT LIABILITIES

NEW 0220 $

268,536

VEHICLE EQUITY

NET CASH

AVERAGE MONTH TOTAL EXPENSES

NET CASH OVER (UNDER)

MORTGAGES PAYABLE

2055 0209 2100-2140, 0210 2162,2163

2150 0403 2200 0211 2205 2300 0212 2310 0213 -2320 2400 0214 -2402 2410 0215 -2415 2450 0216 2420 0217 -2423 2460 0218 2465

0219

USED 0221

2500 0225

1385 0302

1355 0026

1365 0027

1406 0028 1410

( 1430-1432 0029 1435 1440 0030 -1460 ( 1480 0031 ( 1490 0032 1500 0033 -1560 0034

1610 0035 -1640 1650 0036 1660 1700 0037 -1705 1710 0038

LONG TERM LIABILITIES

NOTES PAYABLE

OFFICERS & OWNERS

FORD OTHER LEASED VEHICLES

)

RENTAL VEHICLES

ESTIMATED LIABILITY-REPOSSESSION PURCHASE LOSS

) OTHER LIABILITIES

) TOTAL LIABILITIES

CAPITAL STOCK CAPITAL IN EXCESS OF STOCK PAR VALUE CORPORATION RETAINED EARNINGS TREASURY STOCK

FIXED ASSET REVALUATION (NON US)

2510 0226 2515 0227 2520 0228 2530 0229 2540 0230 2600 0231 2700 0232 2710

0233

2800 0234 2802 2805 0236 2810 0235 2803 0237 2870 0238

NET CASH

NET WORTH

39

DEPRECIATION

40

EQUIPMENT

COST

41

DEPRECIATION

42

LEASEHOLDS

COST

( 1715 0039

1720 0040 -1722

( 1725 0041

-1727

1730 0042

)

SUB "S"

DIVIDENDS DECLARED

PARTNERS' OR INVESTMENT

) PROPRIETOR'S DRAWING

NET INVESTMENT

2820 0239

(

)

2830 0240

2840 0241

(

)

0242

43

AMORTIZED

44 FINANCE RECEIVABLES DEFERRED NET

45 RECEIVABLES - OFFICERS & EMPLOYEES

( 1735 0043

1800 0044 1805

1810 0045

) NET PROFIT - AFTER INCOME TAX - YTD

NET WORTH

TOTAL LIABILITIES & NET WORTH

2850 0243 0244 0245

46 CASH VALUE - LIFE INSURANCE

1820 0046

RETURN ON INVESTMENT - ROI

47 OTHER ASSETS - NET 48 TOTAL ASSETS

1830 0047 -1837

0048

WORKING CAPITAL ACTUAL

49

FROZEN

50

CAPITAL

(negative amount = no

51

frozen

52 capital for dealership)

53 OPERATING ANALYSIS

USED VEHICLE INVENTORY PARTS INVENTORY PSB RECEIVABLES

MONTH

YTD

MONTH

RECOMMENDED MINIMUM OR GUIDE

ACTUAL OVER(UNDER)

ACCOUNTS RECEIVABLE AGING

CURRENT

31-60

61-90

YTD

VEHICLE ACCTS 0500

0507

0514

91+ 0521

54

SALES

% TOTAL SALES

PARTS ACCTS

0501

0508

0515

0522

55 TOTAL GROSS

SERVICE ACCTS

0502

0509

0516

0523

56

EXPENSE

BODY ACCTS

0503

0510

0517

0524

57 OPERATING PROFIT ADD & DED TO INCOME -

58 BONUSES 59 PROFIT BEFORE INCOME TAX

WARRANTY RECV FORD INCENT NOTES RECEIV

0504 0505 0506

0511 0512 0513

0518 0519 0520

0525 0526 0527

?Copyright 2015, Ford Motor Company GIS2 Classification: Confidential

L

DEALER

I

N

E

OPERATING

N

O SUMMARY

MONTH

DOLLARS YTD

1 TOTAL SALES

2

3 TOTAL GROSS

4

5 TOTAL SELLING EXPENSE

6 TOTAL SELLING/

7 ADJUSTED 8 SELLING GROSS

9 TOTAL FIXED EXPENSE

10

11 DEALER SALARY

12

13 OPERATING PROFIT

14

15 LEASED VEHICLE 5300

16 RENTAL VEHICLE 5200

RECREATIONAL 17 VEHICLE

9000

18

OTHER INVENTORY 19 INCOME

9050

20 ADJ. TO INCOME

9100 -9600

FORD MOTOR

21 COMPANY PROGRAMS

9430, 9440, 9620

22 INDEMNITIES NON US

( 9060

23 BONUS DEALER

24

EMPLOYEE

9500 9550

25 PROFIT BEFORE INCOME TAX

26

27 EST. INCOME TAX

PROFIT

(NON US)

28 SHARING

COMBINED CAPITAL /LEGAL

29 RESERVE (NON US)

9900

9910 9920 9925

30 NET PROFIT AFTER TAX

1046 1047 1048 1049

1051 1052 1053

) 1054 (

1055 1056 1057

1059 1060 1061 1062

31

32 TOTAL OVERHEAD EXP

33 TOTAL P, S, BS GROSS

34 NET OPERATING COST

35

VEHICLE GROSS

36 TOTAL VAR. SALES EXP.

37

VARIABLE GROSS

38 BREAK-EVEN UNITS = N. O. C. / VAR. GROSS + DOC FEES + FOMOCO PROGRAMS PN/UVR

39

40

41

N U

)

PNVS

P & A CODE

OPERATING SUMMARY

UNITS YTD

CAR

TRUCK

NEW

SALES CODE

MONTH

DEPARTMENTAL OPERATING SUMMARY

USED

PARTS

SERVICE

N

M

U

Y

% TOTAL GROSS

M

MONTH

YTD

Y

M

Y

M

Y

M

Y

M

Y

M

Y

ADDITIONS

A

D CASH DISC. EARNED

J

U S

INTEREST INCOME

T M

DIVIDEND INCOME

E

N SALES FIXED ASSETS

T

S OTHER INCOME

T DOCUMENTATION FEES

O

I DEDUCTIONS

N C

CASH DISCOUNT

O

M OTHER

E

TOTAL (Line 20)

9100 9150 9200 9250 9300 9350 9370

9400 9450 9600

MONTH

1309 1310 1311 1312 1313 1314

1315 1316 1317

%TOTAL SALES PNVS

FORD MOTOR COMPANY PROGRAMS

LINCOLN SUPPORT

9430

9440

FORD SUPPORT

AD STANDARDS

9460

9620 CUSTOMER SATISFACTION RECOGNITION (FoC)

TOTAL FORD MOTOR COMPANY PROGRAMS (LINE 21)

1414 1415 1419 1416 1423

PG 2

BODY

YTD

MONTH

Service Absorption: The Sum of Total Parts, Service & Body Shop

Gross Profits DIVIDED By the Sum of Total Fixed Expense + Dealer Salary + Parts,

Service & Body Shop Sales Expense

MONTH

YTD

(BENCHMARK IS 85% -- 100%)

%

%

NON-US DEALER ADJUSTMENTS (MEMO)

YTD

EXCHANGE RATE ADJUSTMENT

9350

1443

MONETARY ADJUSTMENT

( 9600

) 1444 (

)

TOTAL PAYROLL

MONTH

1445

YTD

42

43

44

45 OPERATING TREND

ANALYSIS 46

JANUARY 47

FEBRUARY 48

MARCH 49

APRIL 50

MAY 51

JUNE 52

JULY 53

AUGUST 54

55 SEPTEMBER OCTOBER

56 NOVEMBER

57 DECEMBER

58 CURRENT

59 YTD PRIOR

60 YTD

NEW UNITS

CAR

TRUCK

USED UNITS

RETAIL

CAR

TRUCK

TOTAL CAR/TRK INCL WHSL

NEW

SELLING/ADJUSTED * SELLING GROSS (000)

USED

PARTS * SERVICE * BODY SHOP *

FIXED EXP. (000)

OPT PFT (000)

PFT BIT (000)

NET PFT PNVS

?Copyright 2015, Ford Motor Company GIS2 Classification: Confidential

DEALER SALES

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61

MONTH GROSS

UNITS

GR PVS

P & A CODE

NEW VEHICLES (GAS & DIESEL) MUSTANG FUSION FORD GT FIGO (MEXICO ONLY) FORD DISCONTINUED CAR

TOTAL FORD RETAIL CARS LINCOLN MKZ LINCOLN CONTINENTAL LINCOLN DISCONTINUED CAR

TOTAL LINCOLN RETAIL CARS NON FOMOCO RETAIL CARS

TOTAL RETAIL CARS FORD MOTOR CO. FLEET CAR

SALES CODE

3040 2034 3041

3027 2154 3028

3037 2114 3038

3114 2524 3115

3045 2124 3046

2204

UNITS

3222 2284 3223

3300 2744 3301

3242 2294 3243

2304

3340 2894 3341

2904

3360 2914

NON FOMOCO FLEET CAR

3370 2924

TOTAL FLEET CARS

2934

CAR INCENTIVES (GAS & DIESEL)

4380

TOTAL NEW CARS

2954

EDGE ESCAPE EXPLORER EXPEDITION BRONCO SPORT BRONCO ECONOLINE/CLUB WAGON RANGER F150 SUPER DUTY F250-350 TRANSIT CONNECT TRANSIT (VAN) ECOSPORT TBD FORD TRUCK # 1 TBD FORD TRUCK # 2 FORD DISCONTINUED TRUCK

TOTAL FORD LIGHT RETAIL TRUCKS

3475 3044 3476

3450 3004 3451

3410 3014 3411

3400 3024 3401

3007 3394 3008

3198 3154 3199

3420 3054 3421

3422 3354 3423

3780 3074 3781

3790 3084 3791

3597 3114 3598

3550 3164 3551

3564 3104 3565

3556 3884 3557

3032 3914 3033

3570 3124 3571

3204

LINCOLN NAVIGATOR LINCOLN NAUTILUS LINCOLN AVIATOR LINCOLN CORSAIR TBD LINCOLN TRUCK # 2 LINCOLN DISCONTINUED TRUCK

TOTAL LINCOLN RETAIL SUV

3590 3234 3591

3566 3444 3567

3582 3254 3583

3592 3304 3593

3594 3324 3595

3586 3264 3587

3274

NON FOMOCO LIGHT TRUCK TOTAL LIGHT RETAIL TRUCKS

3460 3494 3461

3504

SUPER DUTY F450-550 SUPER DUTY F600-750

TOTAL FORD COMMERCIAL RETAIL TRUCKS

3740 3564 3741

3500 3574 3501

3584

NON FOMOCO COMMERCIAL RETAIL TRUCKS

3600 3594 3601

TOTAL COMMERCIAL/OTHER RETAIL TRUCKS 3604

TOTAL RETAIL TRUCKS

3684

FOMOCO FLEET LIGHT TRUCKS

3470 3524

NON FOMOCO FLEET LIGHT TRUCKS

3516 3414

TOTAL FLEET LIGHT TRUCKS SUPER DUTY F450-550 FLEET TRUCK

3674 3606 3694

SUPER DUTY F600-750 FLEET TRUCK

3608 3744

TOTAL FORD COMMERCIAL FLEET TRUCKS

3754

NON FOMOCO COMMERCIAL FLEET TRUCK

3610 3764

TOTAL COMMERCIAL/OTHER FLEET TRUCKS

3774

TOTAL FLEET TRUCKS

3784

TRUCK INCENTIVES (GAS & DIESEL)

4620

TOTAL NEW TRUCK

3624

TOTAL NEW VEHICLES (GAS & DIESEL)

3344

GR PVS

YEAR TO DATE SALES

2036

MONTH 2037

2156

2157

2116

2117

2526

2527

2126

2127

2206

2207

2286

2287

2746

2747

2296

2297

2306

2307

2896

2897

2906

2907

2916

2917

2926

2927

2936

2937

2947

2956

2957

3046

3047

3006

3007

3016

3017

3026

3027

3396

3397

3156

3157

3056

3057

3356

3357

3076

3077

3086

3087

3116

3117

3166

3167

3106

3107

3886

3887

3916

3917

3126

3127

3206

3207

3236

3237

3446

3447

3256

3257

3306

3307

3326

3327

3266

3267

3276

3277

3496

3497

3506

3507

3566

3567

3576

3577

3586

3587

3596

3597

3606

3607

3686

3687

3526

3527

3416

3417

3676

3677

3696

3697

3746

3747

3756

3757

3766

3767

3776

3777

3786

3787

3617

3576

3627

3596

3347

GROSS

PG 3

?Copyright 2015, Ford Motor Company GIS2 Classification: Confidential

DEALER

SALES 1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

N

49

E

50

W

51

A

52

D

53

V

54

E

55

R

56

T

57

I

58

S

59

I

60

N

61

G

62

MONTH GROSS

UNITS

GR PVS

P & A CODE

SALES CODE

NEW ALTERNATIVE ENERGY VEHICLES

FUSION HYBRID

3018 2134 3019

FUSION ENERGI

3134 2494 3135

TBD FORD ALTERNATIVE ENERGY CAR #1

3138 2544 3139

TBD FORD ALTERNATIVE ENERGY CAR #2

3140 2554 3141

FORD DISCONTINUED ALTERNATIVE ENERGY CARS

3142 2564 3143

TOTAL FORD ALTERNATIVE ENERGY RETAIL CARS 2574

UNITS

LINCOLN MKZ HYBRID

3208 2234 3209

TBD LINCOLN ALTERNATIVE ENERGY CAR #1

3144 2584 3145

TBD LINCOLN ALTERNATIVE ENERGY CAR #2

3146 2594 3147

LINCOLN DISCONTINUED ALTERNATIVE ENERGY CARS

3148 2614 3149

TOTAL LINCOLN ALTERNATIVE ENERGY RETAIL CARS 2624

NON FOMOCO ALTERNATIVE ENERGY CARS

3150 2634 3151

TOTAL ALTERNATIVE ENERGY RETAIL CARS

2644

FORD MOTOR CO. ALTERNATIVE ENERGY FLEET CAR 3512 2854

NON FOMOCO ALTERNATIVE ENERGY FLEET CAR

3514 2874

TOTAL ALTERNATIVE ENERGY FLEET CARS

2884

CAR INCENTIVES (ALTERNATIVE ENERGY)

4109

TOTAL NEW ALTERNATIVE ENERGY CARS

2714

ESCAPE (PHEV)

3152 3484 3153

ESCAPE HYBRID

3414 3314 3415

EXPLORER HYBRID

3154 3434 3155

F150 HYBRID

3156 3514 3157

MUSTANG MACH-E

3136 3194 3137

TBD FORD ALTERNATIVE ENERGY TRUCK #1

3158 3534 3159

TBD FORD ALTERNATIVE ENERGY TRUCK #2

3160 3654 3161

FORD DISCONTINUED ALTERNATIVE ENERGY TRUCKS

3162 3894 3163

TOTAL FORD ALTERNATIVE ENERGY RETAIL TRUCKS 3904

LINCOLN CORSAIR (PHEV)

3164 3964 3165

LINCOLN AVIATOR (PHEV)

3166 3544 3167

TBD LINCOLN ALTERNATIVE ENERGY TRUCK #1

3168 3464 3169

TBD LINCOLN ALTERNATIVE ENERGY TRUCK #2

3170 3454 3171

LINCOLN DISCONTINUED ALTERNATIVE ENERGY TRUCKS

3172 3734 3173

TOTAL LINCOLN ALTERNATIVE ENERGY RETAIL TRUCKS 3384

NON FOMOCO ALTERNATIVE ENERGY TRUCKS

3174 3474 3175

TOTAL ALTERNATIVE ENERGY RETAIL TRUCKS 3404

FORD MOTOR CO. ALTERNATIVE ENERGY FLEET TRUC 3520 3134

NON FOMOCO ALTERNATIVE ENERGY FLEET TRUCK 3522 3144

TOTAL ALTERNATIVE ENERGY FLEET TRUCKS 3184

TRUCK INCENTIVES (ALTERNATIVE ENERGY)

4009

TOTAL NEW ALTERNATIVE ENERGY TRUCKS

3334

TOTAL NEW ALTERNATIVE ENERGY VEHICLES 3724

DLR

TRANS UNITS-YTD

4640 3639

TOTAL NEW VEHICLES

3704

MTD MTD

4214 4215 4216 4217 4218 4219 4220 4221

4222 4223 4224 4225 4226 4227

YTD YTD

ADVERTISING

DIGITAL ADVERTISING

7250

SEARCH ENGINE MARKETING (SEM)

7430

7251 DISPLAY ADS/RETARGETING INC. SOCIAL 7431

7252

DIGITAL RETAILING

7432

7253

ONLINE REPUTATION SERVICES

7433

7254

3RD PARTY LEAD PROVIDERS

7434

7255

DATABASE MARKETING

7435

7256

OTHER

7436

TOTAL DIGITAL ADVERTISING

TRADITIONAL ADVERTISING

7257

TV BROADCAST & CABLE

7437

7258

RADIO

7438

7259

DIRECT MAIL

7439

7260

OTHER

7440

TOTAL TRADITIONAL ADVERTISING

TOTAL ADVERTISING (PG 4, LINE 52)

GR PVS

YEAR TO DATE SALES

2136

MONTH 2137

2496

2497

2546

2547

2556

2557

2566

2567

2576

2577

2236

2237

2586

2587

2596

2597

2616

2617

2626

2627

2636

2637

2646

2647

2856

2857

2876

2877

2886

2887

2657

2716

2717

3486

3487

3316

3317

3436

3437

3516

3517

3196

3197

3536

3537

3656

3657

3896

3897

3906

3907

3966

3967

3546

3547

3466

3467

3456

3457

3736

3737

3386

3387

3476

3477

3406

3407

3136

3137

3146

3147

3186

3187

3647

3336

3337

3726

3727

3637

3706

3707

GROSS

PG 3A

MTD

YTD

U

4284

S

4285

E

4286

D

4287

4288

A

4289

D

4290

V

4291

E

MTD

YTD

R

4292

T

4293

I

4294

S

4295

I

4296

N

4297

G

?Copyright 2015, Ford Motor Company GIS2 Classification: Confidential

L

IN

DEALER

NO

E

1

2

3

4

5

6

7

8M O

9N T

10 H

11

12

13

14

SALES

GROSS

UNITS

GR PVS

P & A CODE

USED VEHICLE DEPARTMENT

USED CARS RETAIL (NON CPO) REMARKETED CARS RETAIL USED CPO CARS (FRANCHISE ONLY)

3700 3715

3720 3730

3800 3815

3830 3835

TOTAL USED CARS RETAIL

USED LIGHT TRUCKS RETAIL (NON CPO)

USED MED/HVY TRK - RETAIL

3750 3767

3860 3865

REMARKETED TRUCKS RETAIL

USED CPO TRUCKS (FRANCHISE ONLY)

3765 3770

3870 3875

3950 3965

3970 3975

TOTAL USED TRUCKS RETAIL

USED CAR/TRK INCENTIVES

4890

TOTAL USED RETAIL

USED CARS WHOLESALE

3710

REMARKETED CARS WHOLESALE

3805

USED TRUCKS WHOLESALE

3760

SALES CODE UNITS

4004 4024 4014 4174 4034 4054 4064 4044 4184

4084 4094 4104 4114

GR PVS

4006 4026 4016 4176 4036 4056 4066 4046 4186

4086 4096 4106 4116

SALES

MONTH

4007 4027 4017 4177 4037 4057 4067 4047 4187 4077 4087 4097 4107 4117

01

GROSS

PG 4

Y E A R T O D A T E

15

REMARKETED TRUCKS WHOLESALE

3955 4124

4126

4127

16

17

18

19

UNITS

MONTH

YTD

20

4251

MONTH

COST YTD

4253

USED VEH INVENTORY ADJ

4702 4752

4880

TOTAL USED WHOLESALE

4144

TOTAL USED VEHICLES

4154

COST PER UNIT

MONTH

YTD

C A R

RECONDITIONING ANALYSIS

T R K

MONTH

UNITS YTD

4257

MONTH

4146 4156

COST

4259

YTD

4137

4147

4157

COST PER UNIT

MONTH

YTD

21

INCOME

22

MONTH

YTD

UNITS

MONTH

YTD

%PEN YTD

PVR

MONTH

YTD

F&I DEPARTMENT

UNITS

MONTH

YTD

%PEN YTD

PVR

MONTH

YTD

MONTH

INCOME YTD

23

24 N 25 E

W

26

27 F 28 & 29 I

30

31

32

33

34

4301 4311 4321 4391 4331 4341 4351 4361 4371 4381 MONTH

4303

4323 4393

4343

4501

YTD

PNVS

MONTH

YTD

5000 5010 5020 5090 5030

FINANCE CONTRACTS

FIN INC ADJ

INSUR CONTRACTS

GAP INSURANCE

INSUR ADJ

5100 5110 5120 5190 5130

4401

4421 4491

4406

4416

U

4426

S

E

4496

D

4436

5040

EXT SERVICE CONTR

5140

5050

EXT SERV CONTR REF

5150

5060 6060

6070 6080

OTHER MERCHANDISE

REPO LOSS NET

5160 6160

6170 6180

F&I NET INCOME

4441

4446

F

4456

&

I

4466

4476

4486

CAR/TRUCK GROSS

PUVS

MONTH

YTD

MONTH

4507

YTD

35

(

36

) 4511 (

)

4521

6200

COST OF SALES ADJ: LIFO

6250

F&I NET INCOME (LINE 32)

(

) 4517 (

)

4527

37

38

39 N 40 E

W

41

42 V

43 E

44 H

(

I

45

C

46 L

47 E

48

D

49

E 50 P

51 A

52 R

53 T

(

M

54 E

55 N

56 T

57

58

4531 4541

NEW VEHICLE SALES EXPENSE

4551 4561 4571 4581

) 4591 (

4601 4611 4621 4631 4641 4651 4661 4671

) 4691 (

4701 4711 4721 4731 4741

NEW GROSS % SALES

S

G

TOTAL VEHICLE

S

USED GROSS % SALES

G

% TOTAL NEW GROSS

% TOTAL USED GROSS

7000

COMM

&

7010

INCENT.

7410

SALESPERSON

7200

SALES MANAGERS

7210

F&I

7460

7030

PRE-DELIVERY

)

7040

PRE-DELIVERY ALLOWANCES

7050

FREE SERVICE/MAINT & POLICY

7230

TOTAL VARIABLE EXPENSE

VARIABLE GROSS

S 7070 A

L A

7080

R I

7100

E S

7400

SALESPERSONS

7270

SALES MANAGERS

7280

OTHER

7300

F&I

7450

TOTAL ADVERTISING (PG 3A, LINE 62)

)

7120 7121

ADVERTISING REBATES

7320 7321

(

7130

PROMOTION

7330

7140

TRAINING

7340

7150

DEMO EXPENSE

7350

7160 7170

SERVICE LOANERS

7360 7370

7420

F&I OTHER

7470

4537 4547

USED VEHICLE SALES EXPENSE

4557 4567 4577

4607 4617 4627 4637 4647 4657 4667 4677

) 4697 (

4707 4717 4727 4737 4747

U S E D

V E H I C L E

D E P A R )T M E N T

59

4751

7180

INTEREST-FLOOR PLAN

7380

4757

60

(

61

) 4761 (

)

4771

7190

FLOOR PLAN ASSISTANCE

7390

TOTAL SEMI-FIXED EXPENSES

(

) 4767 (

)

4777

62

4781

SELLING GROSS

4787

?Copyright 2015, Ford Motor Company GIS2 Classification: Confidential

L

I N DEALER

NO

E

MONTH

YTD

5070 1

5071 2

5072 3

5073 4

5074 5

5075 6

5076 7

5077 8

5078 9

5079 10

5080 11

5081 12

5082 13

5083 14

5084 15

16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42

43 (

44 45 46 47 48 49

50 (

51 52 53 54 55 56 57 58 59 60

61 (

62

5086 5087 5088 5089 5090 5091 5092 5093 5094 5095 5096 5097 5098 5099 5100 5101 5102 5103 5104 5105 5106 5107 5108 5109 5110 5111

) 5112 (

5113

76 PARTS EXPENSE

5114 5115 5116 5117

) 5131 (

5119 5120 5121 5122 5123 5124 5125 5126 5127 5128

) 5129 (

5130

PARTS DEPARTMENT

MONTH

YTD

GROSS%SALES

)

%PARTS GRS

)

)

P & A CODE

5400

5401 5402

WHOLESALE*

S

G

6410 WHOLESALE 6411 JOB INCENTIVE

G

TOTAL WHSL

G

5420

5421

COUNTER

S

5422

RETAIL*

G

MONTH

FORD LINC

5430 5435 5436

REPAIR SHOP

5700 S 5705 5706 G

5440 5445

ESP REPAIR SHOP

S 5710 5715

G

SALES CODE

SERVICE DEPARTMENT

YTD

MONTH

YTD

GROSS%SALES

LABOR RATES

REPAIR

BODY

5251

5252

5312

5313

W&P

5253

5314

INTERNAL

5254

5315

5316 5317 5318 5319

6450 JOB INCENTIVE

G

5460 5462

WARRANTY & POLICY CLAIMS

(SERVICE)

S 5720 5722

G

5470 5475 5476

INTERNAL (SERVICE)

UNAPPLIED TIME

5480

SUBLET

5485 REPAIRS

5730 S 5734 5735 G

6740, 6741 G 6845

5750 S 5755 5800 G

5321 5322 5323 5324 5325 5326 5327

5490 5491 5492

OTHER MERCHANDISE

S 5760 5761

G

5328 5329

5431,41,61,71 PARTS SALES

S

SERV - NON FRANCHISE 5701,11,21,31

G

5330 5331

TOTAL PARTS

S

SALES-SERV

G

NON FOMOCO DUALS ONLY MEMO: OTHER FRAN PARTS PURCHASES

5500 5510 5520 5530 5540 5545

BODY SHOP (METAL)

BODY SHOP (PAINT)

WARRANTY & POLICY CLAIMS

(BODY SHOP)

INTERNAL (BODY SHOP)

MATERIALS

5501,11,21,31 PARTS SALES

S

5810 G S

5820 G S

5830 G S

5840 G

5770 S 5780

5781 5850

G

S

BODY - OTH FRANCHISE 5811,21,31,41

G

MONTH

5385

YTD

RO ANALYSIS

TRAFFIC RO COUNT

SERVICE OTH FRAN

5279

SALES PER R O

PARTS

LABOR

BODY RO OTH FRAN

5281 5284 5285

* MEMO: PRODUCTIVITY/ EFFICIENCY

TOTAL PARTS SALES-BODY

S SERVICE TECH. G Available Clocked Hours

MONTH

5456

6560,60,65

DISCOUNTS EARNED

G Actual Retail Hours Worked

5457

6571,80 6585

INVENTORY ADJ.

G Flat Rate Hours Sold

5458

5340 S

TOTAL DEPARTMENT

5341

G

6300 COS LIFO

TOTAL

G

5343

77 SERV SALES EXPENSE

%SERV GRS

7600,05 7700,05

COMP MGRS

7800,05 7900,05

7610 7710

SAL OTHER

7810 7902,10

7620 7720

COMM&INC OTH

7820 7907,20

7630,31 7730,31

ADVERT/ PROMO

7830,31 7930,31

( 7621 ADVERTISING 7721

REBATES

7821

7640 7740

TRAINING

7840 7940

7650 7750

POLICY ADJ

7850 7950

7660,61 7760,61

SERV LOANER

7860,61

7670 7770

TOOLS & SUPP

7870 7970

7671 7871

FREIGHT

7771 7971

7680 7780

EQ & VEH MAINT

7880 7980

7690 7785

INV CNTRL & DP

7885 7985

7695 7790

VAC/TO PAYTECH

7890 7990

TOT SALES EXP

5344

5345

5346

5347

) 5361 (

)

5349

5350

5351

5352

5353

5354

5355

5356

5357

SELLING GROSS

5358

SHOP PARTS GROSS TRANSFER

ADJ SELLING GRS

5359 5360

MONTH

R O ANALYSIS

MONTH

01

BODY SHOP DEPARTMENT

YTD

MONTH

PG 5M

YTD

GROSS%SALES

TRAFFIC R. O. COUNT

SALES PER R O

PARTS

LABOR

REPAIR SHOP

BODY SHOP

W&P CLAIMS SERVICE

W&P CLAIMS BODY

ESP REPAIR

INTERNAL

M 5544

Y

M 5546

Y

M 5548

Y

M 5550

Y

M 5552

Y

M 5554

Y 5555

5556

5557

*MEMO: OTHER FRAN PARTS DEPT.

WHOLESALE

S

COUNTER RETAIL

5401 G S

5421 G

5619 5620 5621 5622

YTD

5564 5565 5566 5567 5568 5569 5570 5571 5572 5573 5574 5575

5580 5581

5583

78 BODY SALES EXPENSE

5584

5585

5586

5587

(

) 5601 (

)

5589

5590

5591

5592

5593

5594

5595

5596

5597

5598

5599

5600

% BDY GRS

?Copyright 2015, Ford Motor Company GIS2 Classification: Confidential

L DEALER

I

N

SELLING/ADJUSTED *

E

SELLING GROSS

MONTH

ALL DEPTS

N

O

FIXED EXPENSE

1 SAL-GEN MGR

8000 8005 8006

2 SALARIES-ADM.

8020

3 EMPLOYEE BENEFIT

4 PAYROLL TAXES 5 PENSIONS

INST'L. ADV 6 & PROMO

RENT & 7 EQUIV. * 8 UTILITIES * 9 TELEPHONE 10 TAXES 11 INSURANCE 12 OFFICE SUPPLIES

PROFESSIONAL & 13 SERVICE FEES

8040 8041 8045

8100 8105 8106

8200 8205 8206 8210

8220 8240 8300,20,40,60,80 & 8400,20

8500 8505 8506

8520 8525 8446

8445 8540 8646

8600 8620

8640 8645 8666

8660 8665 8706

14 DATA PROCESSING

8680

15 BAD DEBTS

16 CONTRIBUTIONS

17 INTEREST

8700 8705 8726

8720 8725 8766

8740

18 DEPREC EQUIP EQ & VEH

19 MAINT GEN'L TRAVEL &

20 ENTERTAINMENT

21 MISC. EXPENSE

8760 8765 8806

8780

8800 8805 8826

8820 8825 8841

22

23

TOTAL FIXED

24 DEALER SALARY

8900

25 OPERATING PROFIT

6030

YTD

MON

YTD

6031 6032 6033 6034 6035 6036 6037 6038 6039 6040 6041 6042 6043 6044 6045 6046 6047 6048 6049 6050 6051

% GROSS

ALLOCATION OF UNAPPLIED EXPENSE 6053 6054 6055

P & A CODE NEW

6120

6121 6122 6123 6124 6125 6126 6127 6128 6129 6130 6131 6132 6133 6134 6135 6136 6137 6138 6139 6140 6141 6142 6143 6144 6145

6150

6151 6152 6153 6154 6155 6156 6157 6158 6159 6160 6161 6162 6163 6164 6165 6166 6167 6168 6169 6170 6171 6172 6173 6174 6175

USED

SALES CODE

PARTS

SERVICE

6180

6210

6240

DEPARTMENTAL FIXED EXPENSE ALLOCATION - YTD

6181

6211

6241

6182

6212

6242

6183

6213

6243

6184

6214

6244

6185

6215

6245

6186

6216

6246

6187

6217

6247

6188

6218

6248

6189

6219

6249

6190

6220

6250

6191

6221

6251

6192

6222

6252

6193

6223

6253

6194

6224

6254

6195

6225

6255

6196

6226

6256

6197

6227

6257

6198

6228

6258

6199

6229

6259

6200

6230

6260

6201

6231

6261

6202

6232

6262

6203

6233

6263

6204

6234

6264

6205

6235

6265

MONTH BODY

26

NEW VEHICLE

F & I SELLING GROSS ANALYSIS

USED VEHICLE

RENTAL DEPARTMENT

MONTH

27

MONTH

YTD

MONTH

YTD

28

GROSS

T

29

C R VAR. SELLING EXP

A&U

30

R C SEMI FIXED SELLING EXP

K

31

SELLING GROSS

INCOME

SALARIES

5210

COMMISSIONS/INCENTIVES

5220

OTHER EXPENSES

5230

TOTAL NET

5200

32

TOTAL F&I NET INCOME

AGREEMENTS

33

F&I SELLING EXPENSES

34

F&I SELLING GROSS

35

TOTAL SELLING GROSS

36

37

NET RENT OR EQUIV.

38

DEPREC & AMORT

39

* RENT & EQUIVALENT

INSURANCE-BUILDING

40

TAX-REAL ESTATE

41

MAINT-BUILDING

42

TOTAL

8300 8305 8306 8320

8340 8360 8345-8365 8346 8366

8380 8385 8386

8400 8405 8406

8420 8425 8426

MONTH

6360 6361 6362 6363 6364 6365

YTD

INVENTORY ANALYSIS

TOT UNITS @ EOM

6420

TOT UNIT DAYS AVAIL/MO

6421

CUST ESP PAID DAYS/MO

6422

SERVICE LOANER-PAID DAYS/MO 6423

DLR PAID DAYS/MO

6424

NON UTILIZED DAYS/MO

6425

% UTILIZATION

6426

% CUSTOMER/EXP PAID

6427

CAR

RENTAL

6430

TRK

6431

6432

6433

6434

6435

6436

6437

RV

6440 6441 6442 6443 6444 6445 6446 6447

43 PERSONNEL SUMMARY

ADMIN

44 DEALERS

6504

45 MANAGEMENT

6505

46 SLSPRNS/SERV ADVSRS

FRAN N&U

F&I

6525 6526

6565 6566

REN/LSE

6585 6586

47

REPAIR

TECHNICIANS

48

INTERNAL

49 CLERICAL

50 OTHER 51 TOTAL 6501

6509 6510 6511

52

< 12 MOS

SALESPERSON

53

12 -36 MOS

TENURE

54

37 - 60 MOS

(IN MONTHS)

55

61+ MOS

56 SALESPERSON HIRED-YTD 57 TURNOVER TERM-YTD

6528 6529 6530 6531 6532 6533 6534 6535 6536 6537

6569 6570 6571

6589 6590 6591

SERVICE

< 12 MOS

ADVISOR

12 - 36 MOS

TENURE

37 - 60 MOS

(IN MONTHS)

61+ MOS

SERVICE ADVISOR HIRED-YTD

TURNOVER

TERM-YTD

FRAN PARTS

FRAN SERV

6605 6606

6609 6610 6611

6645 6646 6647 6648 6649 6650 6651 6612 6613 6614 6615 6616 6617

6685 6686 6687 6688 6689 6690 6691

BODY

*MEMO: UTILITY EXPENSES GAS ELECTRIC WATER SEWAGE SOLAR TOTAL

MONTH

58 SPLT SLS FRC

59 MANAGERS

6709

60 SALESPERSONS 6710

NEW

USED

6719

6720

COMB

6729

6730

6739 6740

TOTAL

REPAIR 6750

STALL COUNT

INTERNAL 6760

6770

BODY

PG 6 UNAPPLIED

6271 6272 6273 6274 6275 6276 6277 6278 6279 6280 6281 6282 6283 6284 6285 6286 6287 6288 6289 6290 6291 6292

TOTAL APPLIED

6410 6411 6412 6413 6414 6415

YTD

SERVICE LOANERS

6450 6451 6452 6453 6454 6455 6456 6457

6485 6487 6489 6491 6493 6495

YTD

?Copyright 2015, Ford Motor Company GIS2 Classification: Confidential

DEALER

P & A CODE

SALES CODE

MTH

YTD

MTH

YTD

MTH

YTD

MTH

YTD

1

2

3

MEMO: QUICK LANE (US & CANADA)

4

5

6

PARTS DEPARTMENT

7096

7

7097

8

7072

9

7073

10

7076

11

7077

12

7078

13

7079

14

7080

15

7081

16

7074

17

7075

18

7082

19

7083

20

7084

21

7085

22

23

7086

24

7087

25

7088

26

7089

27

7090

28

7091

29

7092

30

7093

31

7094

32

7095

33

34

PARTS DEPARTMENT

7098

35

7099

36

7100

37

7101

38

7102

39

7103

40

7104

41

7105

42

7106

43

7107

44

7108

45

7109

46

7110

47

7111

48

GRS%SLS %PARTS GRS

5402

PARTS

S

WHOLESALE

G

5422

PARTS

COUNTER

S

RETAIL

G

5435

5705

RETAIL SHOP

S

SALES

G

5436

TIRE SALES

5706 S

G

5445

ESP / ESC / QFC

5715 S

SALES

G

5462

WARRANTY

5722 S

SALES

G

5475

INTERNAL

5735 S

SALES

G

5476

INTERNAL

5734 S

TIRE SALES

G

UNAPPLIED TIME 6741 G

5485

5755

SUBLET SALES

S

5492 5545

OTHER MERCHANDISE

MATERIALS

G 5761

S

G 5781

S

G

6565 DISC EARNED 6561

G

6585 INVENT ADJ 6571

G

TOTAL

S

DEPARTMENTS G

SALARIES-MGRS 7900

SALARIES-TECH 7902, 7910

COMM&INC-MGRS 7905

COMM&INC-TECH 7907, 7920

ADVERT/PROMO 7930, 7931

TRAINING

7940

POLICY ADJ

7950

TOOLS & SUPP

7970

FREIGHT/HANDLING 7971

EQ. & VEH MAINT 7980

INV CNTRL & DP 7985

VAC/TO PAY-TECH 7990

TOTAL SALES EXP

SELLING GROSS

SERVICE DEPARTMENT

7376 7377 7378 7379 7380 7381 7374 7375 7382 7383 7384 7385 7373 7386 7387 7388 7389 7390 7391

7394 7395

SERV SALES EXPENSE

7397 7398 7399 7400 7401 7402 7403 7404 7405 7406 7407 7408 7409 7410

GRS%SLS %SERV GRS

49

50

51

52

QUICK LANE MEMO PROFIT

53

54 QL Parts & Serv Gross 55 QL Parts & Serv Sales Exp

QL P&S Selling Gross

56

57 QL Parts & Serv Fixed Exp 58 QL "Memo" Profit

Sales Per Stall

59

MTH

7606 7607 7608 7609 7610 7611

YTD

MANAGERS SERVICE WRITERS Lead/Repair Techs Maintenance Techs TOTAL STALL COUNT

PERSONNEL

7501 7502 7503 7504 7505 7510

60

61

62

MONTH

MTH

PG 7

YTD

RO ANALYSIS

TRAFFIC RO COUNT

RETAIL SHOP M SALES Y 7684

ESP/ESC/ M QFC SALES Y 7686

INTERNAL M SALES Y 7688

OTHER MERCH.

M Y 7690

WARRANTY M SALES Y 7692

SALES PER R O

PARTS

LABOR

PARTS ALLOCATION FIXED EXPENSES

SALARIES

MTH

YTD

8006

7951

BENEFITS

8041

7952

PAYROLL TAXES

8106

7953

PENSIONS

8206

7954

RENT & LEASE

8306

7955

DEP BLDG & IMP

8346

7956

AMORT of IMPR

8366

7957

INS BLDGS

8386

7958

TAXES REAL ESTATE

8406

7959

MAIN BLDGS

8426

7960

UTILITIES

8506

7961

TELEPHONE

8446

7962

TXS EX. INC/REAL EST

8646

7963

OFFICE SUPPLIES

8666

7964

PROF & SERV FEES

8706

7965

BAD DEBT

8725

7966

CONTRIBUTIONS

8766

7967

DEPREC EQUIP

8806

7968

TRAVEL & ENTERT

8826

7969

MISC EXPENSE

8841

7970

TOTAL FIXED EXP

7975

SERVICE ALLOCATION FIXED EXPENSES

MTH

SALARIES

8005

7861

YTD

BENEFITS

8045

7862

PAYROLL TAXES 8105

7863

PENSIONS

8205

7864

RENT & LEASE 8305

7865

DEP BLDG & IMP 8345

7866

AMORT of IMPR

8365

7867

INS BLDGS

8385

7868

TAXES REAL ESTATE 8405

7869

MAIN BLDGS

8425

7870

UTILITIES

8505

7871

TELEPHONE

8525

7872

TXS EX. INC/REAL EST 8445

7873

OFFICE SUPPLIES 8645

7874

PROF & SERV FEES 8665

7875

BAD DEBT

8705

7876

CONTRIBUTIONS 8725

7877

DEPREC EQUIP 8765

7878

TRAVEL & ENTERT

8805

7879

MISC EXPENSE 8825

7880

TOTAL FIXED EXP

7881

?Copyright 2015, Ford Motor Company GIS2 Classification: Confidential

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download