Arun Management Report April 061209

  • Uploaded by: arun
  • 0
  • 0
  • May 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Arun Management Report April 061209 as PDF for free.

More details

  • Words: 4,813
  • Pages: 96
ABC FINANCE, INC. Initial Investment :

November 158,844.00

Cash collected from contracts

(329,691.60)

$ received above investment

170,849.00

Late fees Collected: Total cash collected above investment:

34,317.00 205,166.00

Remaining Principal Balance: Delinquency (65%) Potential principal collection Potential revenue (discount 35%) forecasted collectable income forecasted UGA fees

Less: Past Due Balance (laptops)

60,609.36

Chargebacks:

15,600.00

Total Forecasted collectable income

Profit as of 11/30/2008 Remaining Reserve Less UGA Fees

128,956.64 115.48 7,476.75

2008 2,670.13 (1,221.42) 1,448.71 507.05 1,955.76 (100.00)

1,855.76

ABC PURCHASE DATE: Varied # OF CONTRACTS 84 RESERVE 4% DISCOUNT 35%

Month Expected Actual Fees May-05 0 128 Jun-05 2941 464 40 Jul-05 5546 4643 139 Aug-05 7438 5706 161 Sep-05 8650 8284 170 Oct-05 10841 10731 180 Nov-05 11899 11309 190 Dec-05 12827 9842 148 Jan-06 13601 10461 9.24 Feb-06 13601 11963 166 Mar-06 13601 12435 184 Apr-06 13601 12613 192 May-06 13601 12663 200 Jun-06 13601 14888 200 Jul-06 13317 13039 208 Aug-06 13317 13118 216 Sep-06 13032 14902 232.49 Oct-06 13032 11857 240 Nov-06 12484 12550 282.5 Dec-06 12484 11925 301.08 Jan-07 12484 13148 335.08 Feb-07 12484 11199 308.54 Mar-07 12295 12302 291.04 Apr-07 12097 9861 253.54 May-07 12097 9117 264.54 Jun-07 10369 10154 296.87 Jul-07 8048 8620 261 Aug-07 4952 7556 264 Sep-07 4024 7179 248

Reserve Delq $$* Interest income discount earned Outstanding Investment 2604 0 158,844 0 4588 0 198 143.23 158,380 6820 0 2664 1046.16 153,737 8804 0 3032 1047.87 148,031 9300 6129.8 4931 1766.55 139,747 10292 12269.22 5138 2927.77 129,016 10416 3052 5749 2978.13 117,707 10419 3052 2257.28 2669.57 107,865 6163 3052.34 2880.28 3286.28 97,404 6535 2744.54 3056.96 2285.66 85,441 2527 2879.75 2543.78 3461.95 73,006 3023 8269.01 2610.29 3745.84 60,393 3999 1523.57 2856.17 3747.36 47,730 3999 12100.36 3099.78 4438.9 32,841 4467 14170.41 2496.3 4060.11 19,802 5490 19920 2255.47 3960.3 6,684 $6,200 ELIGIBLE FOR CHARGEBACK 5851 16960.89 3026.04 4438.06 -8,218 COLLECTED ABOVE INITIAL INVESTMENT 6686.33 24960.69 2023.46 3441.6 -20,074 6686.33 16399.65 2857.4 3392.24 -32,624 553133 19788.35 1931.73 3497.58 -44,548 4921.21 25063.35 1629.92 4031.17 -57,696 4921.21 19632.19 241.37 3780.74 -68,895 *no interest applied UGA error 4921.21 21980.58 2784.78 2653.11 -81,197 23884.12 eligible for chargeback 4921.21 49017.6 1197.69 3194.61 -91,058 4921.21 58186.65 1143 2790.98 -100,175 4948.63 61029.75 886.25 3243.61 -110,329 4948.63 61029.75 888.52 2706 -118,949 115.48 64784.64 668.45 2410 -126,505 115.48 63423.24 371.88 2382 -133,683

Oct-07 Nov-07 Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 Aug-08 Sep-08 Oct-08 Nov

2476 1702 774 0 0 0 0 0 0 0 0 0 0 0

4481 2871 3318.34 3418 3427 2803 2879 2728 2817 2012 2094 1683 2634 0

230.59 187.53 175.03 146.53 152.28 47.8 55.7 41.8 45.77 222.95 18.95 26.95 14.95 8.95

115.48 115.48 115.48 115.48 115.48 115.48 115.48 115.48 115.48 115.48 115.48 115.48 115.48 115.48

313216 329691.55

7485.7

115

61193.93 64186.81 36217.81 36,217.81 3,598.56 3,598.56 3,598.56 9,820.83 2,991.04 2,991.04 0.00 0.00 0.00 0.00

281.7 331.54 302.72 222.48 267.85 106.99 120.05 100.83 63.54 35.65 30.4 21.3 17.14 0

1390.84 1238.85 1229.76 1118.55 1152.77 943.25 965.81 850.13 963.71 674.5 728.74 581.7 910.77 0

67,321

88,505

total revenue ->>

155,826

-138,164 -141,035 -144,354 -147,772 -151,199 -154,001 -156,880 -159,609 -162,426 -164,438 -166,531 -168,215 -170,849 -170,849

LIGIBLE FOR CHARGEBACK TED ABOVE INITIAL INVESTMENT

st applied UGA error eligible for chargeback

FURNITURE EXCHANGE PURCHASE DATE: 9/19/05 # OF CONTRACTS 61 RESERVE 20% DISCOUNT 15% EXPECTED YIELD 45%

TOP 89,065

Investment 57,892

Month Expected Actual Fees Aug-05 123 0 Sep-05 3815 0 Oct-05 6128 7069 Nov-05 6128 3196 Dec-05 6010 3691 Jan-06 5905 4815 Feb-06 5531 3073 Mar-06 5201 3059 Apr-06 5062 2808 May-06 4925 3501 Jun-06 4649 2400 Jul-06 4069 1397 Aug-06 3609 1813 Sep-06 3308 1348 Oct-06 3256 1374 Nov-06 3151 1002 Dec-06 2998 1153 Jan-07 2434 892 Feb-07 2055 825 Mar-07 1642 377 Apr-07 1642 996 May-07 1357 400 Jun-07 1038 405 Jul-07 780 260 Aug-07 679 331 Sep-07 389 315

214 351 210 216 216 211 196 185 186 167 142 140 124 123 79 82 82 33 23 23 19 19 19 18 28

Reserve Delq $$* Revenue Outstanding Investment 17813 57,892 17813 2244 57,892 17813 13286 791 50,824 17813 24955 365 47,628 17813 18899 439 43,937 17810 23907 520 39,121 17810 17247 343 36,048 17810 22661 360 32,989 17810 24674 406 30,181 7665 19560 594 26,680 Bad debt w/o of $11935 7665 18271 523 24,280 6642 18271 119 22,884 6642 18706 365 21,071 6642 18706 263 19,723 4517 9305 308 18,349 4517 9305 287 17,347 0 9250 159 16,194 Bad debt w/o of $9018.0 0 4535 100 15,302 0 122 122 14,477 0 2260 51 14,101 0 2138 145 13,105 0 2138 40 12,705 0 2138 38 12,301 0 2138 14.42 12,041 0 4578 33.25 11,710 0 0 42 11,395

DELQ 39%

Oct-07 Nov-07 Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08 Jun-08

389 389 389 389 272 272 272 272 272

157 159 159 0 151 150 150 0 0

4 4 4 4 4 4 4 4 4

88800

47423

3139

*Over 15 days past due

0 0 0 0 0 0 0 0 0

0

0 0 0 0 0 0 0 531 0

25 21 23.1 0 25 0 0 0 0

11,238 11,079 10,920 10,920 10,769 10619 10,469 10469 LOSS ALL RECEIVABLES PD OR W/O. 0

DLSI PURCHASE DATE: 10/31/05 # OF CONTRACTS 66 RESERVE 15% DISCOUNT 14%

Investment 149,539

Month Expected Actual Fees Nov-05 7245 6779 210 Dec-05 7245 6571 251.36 Jan-06 5951 5193.97 221.77 Feb-06 5951 4417.09 227 Mar-06 5951 8160.91 221.16 Apr-06 5951 5913.9 192.86 May-06 5951 4441.45 193.98 Jun-06 5951 3942.5 202.47 Jul-06 5951 4181.73 190.09 Aug-06 5951 3434.11 174.17 Sep-06 5951 3745.44 181.42 Oct-06 5951 3136.85 183.79 Nov-06 5951 3572 161.79 Dec-06 5951 2747.55 143.29 Jan-07 5951 3839.54 129.79 Feb-07 5951 2904.66 132.35 Mar-07 5951 3107.18 124.83 Apr-07 5725 3038.53 122.83 May-07 5522 2340.78 100.33 Jun-07 5091 4598.62 173.96 Jul-07 5091 2221.71 94.33 Aug-07 4990 2679.41 84.49 Sep-07 4882 1731.56 103.2 Oct-07 4017 2149.13 127.8 Nov-07 4017 1690.66 103.34 Dec-07 4017 2568.62 95.84 Jan-08 4017 1552.99 56.83

Reserve Delq $$* Revenue Outstanding Investment $28,679 0 1852 $149,539 $28,679 0 730.08 $142,759 $23,961 0 532.19 $137,565 $23,961 8001.55 482.3 $133,148 $23,961 8001.55 1297.19 $124,987 $23,961 14509 1430.68 $119,073 $7,198 1699.28 1197.58 $114,632 $19955 bad debt w/o's $7,198 1953.2 1084.35 $110,689 $7,198 1953.2 1003.04 $106,507 $7,198 3694.38 728.75 $103,073 $7,198 3694.38 740.78 $99,328 $3,689 11236.68 626.35 $96,191 $3,689 14274.24 854.34 $92,619 $3,689 15805.02 448.01 $89,871 $2,158 25106.47 644.31 $86,032 $2,158 22887.29 580.97 $83,127 $2,158 22887.29 941.9 $80,020 $2,158 20743.04 461.67 $76,981 $- 17705.48 319.53 $74,640 $9990 367.54 $70,042 $9990 294.16 $67,820 $9990 347.08 $65,141 $7709.54 245.12 $63,409 $7708.47 355.9 $61,260 $7708.47 202.28 $59,569 $0 330.73 $57,001 $0 234.94 $55,448

Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 Aug-08 Sep-08 Oct-08 Nov-08 Dec-08 Jan-09 Feb-09 Mar-09 Apr-09 May-09 Jun-09 Jul-09 Aug-09 Sep-09

4017 4017 3914 3704 3581 3340 2944 2833 2738 2738 2738 2738 2626 2505 2054 1626 1281 820 820 246 122453 324857

1747.06 1531.83 1326.48 1314.53 964.44 844.12 627.47 639.51 330.75 797.93 452.02 426.11 416.7 333.77 224.1

67.6 56.44 47.08 49.26 45.7 43.1 35.65 39.45 33.65 33.65 13.9 9.95 9.95 7.95 5.95

0.7

85717.1

$$$$$$$$$$$$0 0 0

0 0 645.58 2921.3 2921.3 2921.3 3448.99 3448.99 4827.25 982.04 0 0 0 0 0

186.97 114.59 114.93 193.34 117.21 135.05 100.39 102.32 19.8 120.63 67.08 67.18 63.52 51.1 41.56

$53,701 $52,169 $50,842 $49,528 $48,563 $47,719 $47,092 $46,452 $46,121 $45,324 $44,872 $44,445 $44,029 $43,695 $43,471 $43,471

MilitaryTechSource.com

Sales:

Jan. This Month

Applications: Approval Rate: Completion Rate: AVG SALE PRICE

117 49% 34% 2,077

total laptops:

15

Accounts paid off:

$31,149

16

1358 48% 28% 2,222 $30,294

163 $362,264

2

0

3

23 1 24

3

Current $3,000

Delinquency: Outstanding Receivables: Delinquent $ total write offs

Total

141 48% 27% 1,893

1

iPOD Sales: 2GB 4GB total iPODs

Inventory:

Dec. Last Month

$280,039 $12,269 $5,019

Dated

Total

$7,596

$15,241

4% *1797.28 for CCC is included. 1%

Jan-07

MilitaryTechSource.com

Sales:

Feb This Month

Applications: Approval Rate: Completion Rate: AVG SALE

113 54% 37% 2,333

total laptops:

16

Accounts paid off:

$37,330

16

1471 48% 35% 2,008 $30,294

199 $399,583

2

0

2

25 1 26

2

Current $3,000

Delinquency: Outstanding Receivables: Delinquent $ total write offs

Total

141 48% 27% 1,893

0

iPOD Sales: 2GB 4GB total iPODs

Inventory:

Jan Last Month

$284,126 $11,726 $6,905

4% 2%

Dated

Total

$5,148

$8,148

FEB

MilitaryTechSource.com

Sales:

March This Month

Applications: Approval Rate: Completion Rate: AVG SALE

37 54% 46% 2,191

total laptops:

12

Accounts paid off:

1

iPOD Sales: 2GB 4GB total iPODs

3 1 2

Inventory:

Feb Last Month 113 54% 37% 1,893

$26,293

2,018 $30,294

211 $425,876 3

28 2 30

Current

$284,126 $11,726 $13,571

16

1508 48% 35%

2

$2,547

Delinquency: Outstanding Receivables: Delinquent $ total write offs

Total

4% 3%

Dated

Total

$5,148

$7,695

MARCH

MilitaryTechSource.com

Sales:

April This Month

Applications: Approval Rate: Completion Rate: AVG SALE

69 51% 40% 2,469

total laptops:

14

March Last Month

Total

37 54% 46% 2,191 $34,569

12

1577 48% 35% 2,046 $26,293

225 $460,445

Accounts paid off:

2

iPOD Sales: 2GB 4GB total iPODs

1 2 2

29 4 30

Gaming Systems: Playstation 3 Nintendo Wii

2 1

2 1

Inventory:

1

Current $3,340

Delinquency: Outstanding Receivables: Delinquent $ total write offs

$317,597 $6,484 $15,206

2% 3%

5

Dated

Total

$5,148

$8,488

APRIL

MilitaryTechSource.com

Sales:

May This Month

Applications: Approval Rate: Completion Rate: avg sale

97 49% 43% 2,483

total laptops:

20

APRIL Last Month 69 51% 40% 2,469

$49,657

14

Total 1674 48% 35% 2,082

$34,569

245 $510,103

Accounts paid off:

2

iPOD Sales: 2GB 4GB total iPODs

1 6 2

30 10 30

Gaming Systems: Playstation 3 Nintendo Wii

8 4

10 5

Inventory:

2

Current $-

Delinquency: Outstanding Receivables: Delinquent $ total write offs

$349,951 $6,125 $15,206

2% 3%

7

Dated

Total

$3,099

$3,099

MAY

MilitaryTechSource.com

Sales: Applications: Approval Rate: Completion Rate: avg sale amt total laptops:

June June This Month

May Last Month

104 53% 55% 2404 30

Total

97 49% 43% 2482 $72,145

20

1778 48% 35% $2,117 $49,657

275 $582,248

Accounts paid off:

2

iPOD Sales: 2GB 4GB total iPODs

4 6

34 16 50

7 3 1

17 8 1

Gaming Systems: Playstation 3 Nintendo Wii XBOX Inventory:

2

Current $-

Delinquency: Outstanding Receivables: Delinquent $ total write offs

$393,874 $8,906 $18,517

2% 3%

9

Dated

Total

$1,700

$1,700

MilitaryTechSource.com

Sales:

July

July This Month

June Last Month

163 56% 27% $2,642

104 53% 55% $2,404

Applications: Approval Rate: Completion Rate: avg. sale amount total laptops:

25

Accounts paid off:

30

1

iPOD Sales: 2GB 4GB total iPODs Gaming Systems: Playstation 3 Nintendo Wii XBOX Inventory:

$66,068

Total 1941 48% 35% $2,146 $72,145

305 $654,393

2

11

2 11

36 27 50

7 0 1

24 8 2

Current

Dated

$-

Delinquency: Outstanding Receivables: $439,426 Delinquent $ $14,849 total write offs $18,517

$1,700

3% 3%

Total $1,700

MilitaryTechSource.com

Sales: Applications: Approval Rate: Completion Rate: avg. sale amount total laptops:

August August This Month

July Last Month

73 33% 83% $2,314 20

Total

163 56% 27% $2,642 $46,281

25

2014 48% 35% $2,156 $66,068

325 $700,674

Accounts paid off:

3

iPOD Sales: 2GB 4GB total iPODs

0 3

36 30 50

9 0 1

33 8 3

Gaming Systems: Playstation 3 Nintendo Wii XBOX Inventory:

1

Current $-

Delinquency: Outstanding Receivables: Delinquent $ total write offs

$450,959 $22,485 $19,266

5% 3%

14

Dated

Total

$-

$-

MilitaryTechSource.com

Sales: Applications: Approval Rate: Completion Rate: avg. sale amount total laptops:

SEPTEMBER September This Month

August Last Month

73 44% 34% $2,408 11

Total

73 33% 83% $2,314 $26,492

20

2087 48% 35% $2,237 $46,281

325 $727,166

Accounts paid off:

5

3

19

Golden Nugget Sales

2

$-

2

Inventory: 5920

Current 1808.15

Delinquency: Outstanding Receivables: Delinquent $ total write offs

$451,961 $30,865 $20,928

Dated

6% 3%

Total 1808.15

current month w/o

$1,662.00

SEPTEMBER

MilitaryTechSource.com

Sales: Applications: Approval Rate: Completion Rate: avg. sale amount total laptops:

OCTOBER October This Month

September Last Month

87 54% 23%

23

Total

73 44% 34% $2,408 $61,053

20

2174 48% 35% $2,265 $46,281

348 $788,219

Accounts paid off:

2

5

21

Golden Nugget Sales

0

2

2

Inventory: 5920 5920

Current 1808.15 $1,808

Delinquency: Outstanding Receivables: Delinquent $ total write offs

$488,510 $30,865 $20,928

WRITE OFFS BY DEALER: ABC 2,020 DLSI 1,880 F/E MTS 4,858 8,759

Dated

6% 3%

Total 1808.15 $3,616

current month w/o

$1,662.00

OCTOBER

MilitaryTechSource.com

NOVEMBER November This Month

Sales: Applications: Approval Rate: Completion Rate: avg. sale amount

October Last Month

176 53% 16% $2,398

total laptops:

28

Total

87 54% 23% $2,654 $67,130

23

2350 48% 35% $2,293 $61,053

373 $855,349

Accounts paid off:

4

5

25

Golden Nugget Sales

0

2

2

Secondary Financing Approvals Sales Delquency

2 0 0

Inventory: Durabooks

Current

Dated 2967

3 $-

November Delinquency: Outstanding Receivables: Delinquent $ Total Portfolio write-off

$511,837 $45,396 $20,928

9% 2%

November Write-offs: ABC 9,942 MTS 9,942

Bad Debt Allwnce. ABC Delinquency

$83,890.74 $(41,722) discounted w/o amt

Remaining Allwnce.

$42,169.19

Total 2967 $5,934

current month w/o

$0.00

MilitaryTechSource.com

DECEMBER December This Month

Sales: Applications: Approval Rate: Completion Rate: avg. sale amount

November Last Month

76 45% 28% $2,587

total laptops:

22

Total

176 53% 16% $2,398 $56,912

28

2426 48% 35% $2,294 $67,130

398 $913,051

Accounts paid off:

4

5

25

Golden Nugget Sales

0

0

2

Secondary Financing Approvals Sales Delquency

6 0 0

2 0 0

8 0 0

Inventory: Durabooks

Current

Dated 2967

3 $-

December Delinquency Outstanding Receivables: Delinquent $ Total Portfolio write-off

$562,185 $50,597 $23,323

9% 3%

December write -offs ABC 27,180 MTS 2,395 DLSI 6534.64 F/E 2423.05 (unearned interest portion) 29,576

Bad Debt Allwnce. ABC Delinquency

$92,407.60 $-

Remaining Allwnce.

$92,407.60

Total 2967 $5,934

current month w/o

$2,395.00 (MTS)

MilitaryTechSource.com

JANUARY

Sales:

January This Month

Applications: Approval Rate: Completion Rate: avg. sale amount

132 45% 27% $2,584

total laptops:

16

December Last Month

Total

76 45% 28% $2,587 $41,346

22

$56,912

2558 48% 35% $2,305 414 $954,397

Accounts paid off:

6

4

31

Golden Nugget Sales

0

0

2

Secondary Financing Approvals Sales Delquency

5 0 0

6 0 0

8 0 0

Inventory: Durabooks

Current

Dated 985

1 $-

January Delinquency Outstanding Receivables: Delinquent $ Total Portfolio write-off

$572,816 $59,675 $27,524

9% 3%

Total 985 $985

current month w/o

$2,395.00

January write -offs ABC 3,440 MTS 2,395 DLSI 0 F/E 0 (unearned interest portion) 5,835

Bad Debt Allwnce. ABC Delinquency ABC past due balance: Remaining Allwnce.

$95,870.00 $23,541 65% of actual 36218.00 60609.34 $11,719.49

Prev. balance: 92407.6

(MTS)

MilitaryTechSource.com

FEBRUARY

Sales:

February This Month

Applications: Approval Rate: Completion Rate: avg. sale amount

95 28% 85% $2,607

total laptops:

23

January Last Month

Total

76 45% 28% $2,587 $59,963

16

2653 48% 35% $2,227 $41,346

437

Accounts paid off:

0

6

31

Golden Nugget Sales

0

0

2

Secondary Financing Approvals Sales Delquency

0 0 0

5 0 0

8 0 0

Inventory: Durabooks

Current

Dated 985

1

Total 985 $985

$-

February Delinquency Outstanding Receivables: Delinquent $ Total Portfolio write-off

$596,612 $49,681 $29,183

7% 3%

current month w/o

February write -offs ABC MTS 6,532 DLSI 0 F/E 0 (unearned interest portion) 6,532

Bad Debt Allwnce. ABC Delinquency ABC Past due balance Remaining Allwnce.

$98,137.48 $60,609 $37,528.14

$973,014

Previous balance:

$95,870.00

$6,532.48

FEBRUARY

(MTS)

MilitaryTechSource.com

MARCH March This Month

Sales: Applications: Approval Rate: Completion Rate: avg. sale amount

February Last Month

71 57% 18% $2,894

total laptops:

10

Total

95 28% 85% $2,584 $28,944

23

2724 48% 35% $2,457 $59,963

447 $1,001,958

Accounts paid off:

2

6

33

Golden Nugget Sales

0

0

2

Secondary Financing Approvals Sales Delquency

44 10 0

5 0 0

8 0 0

Inventory:

Current

Dated

Total

0 $-

March Delinquency Outstanding Receivables: Delinquent $ Total Portfolio write-off

MARCH W/O'S ABC MTS DLSI F/E

$580,284 $39,339 $46,829

6% 4%

current month w/o

14,579 0 0 (unearned interest portion) 14,579

Bad Debt Allwnce. ABC Delinquency ABC Past Due Remaining Allwnce.

$83,560.19 0 $60,609 $22,950.83

prev. bal.

98137.48

$11,946.49

(MTS)

3 first pmt. Defaults

7819

MilitaryTechSource.com

APRIL April This Month

Sales: Applications: Approval Rate: Completion Rate: avg. sale amount

March Last Month

72 68% 51% $2,570

total laptops:

25

Total

71 57% 18% $2,894 $64,257

23

2796 48% 35% $2,457 $59,963

472

Accounts paid off:

2

6

33

Golden Nugget Sales

0

0

2

Secondary Financing Approvals Sales Delquency

3 2 0

5 0 0

11 0 0

Inventory: 5920

Current

Dated

1

1900

April Delinquency Outstanding Receivables: Delinquent $ Total Portfolio write-off

$542,507 $43,808 $53,070

APRIL W/O'S ABC MTS DLSI F/E

Bad Debt Allwnce. ABC Delinquency ABC Past Due Remaining Allwnce.

Total 1900

8% 4%

current month w/o

6,241 0 0 (unearned interest portion) 6,241

$99,897.44 0 $60,609 $39,288.08

$1,066,215

prev. bal.

90435.27

$6,241.33

(MTS)

MilitaryTechSource.com

May-08 MAY This Month

Sales: Applications: Approval Rate: Completion Rate: avg. sale amount

APRIL Last Month

61 34% 95% $2,827

total laptops:

20

Accounts paid off:

72 68% 51% $2,570 $58,541

25

9

Golden Nugget Sales Secondary Financing Approvals Sales Delquency Inventory: 5920

2 0 0 Current 1900

May Delinquency: Outstanding Receivables: Delinquent $ Total Portfolio write-off

$609,523 $68,072 $57,818

Bad Debt Allwnce. ABC Delinquency ABC Past Due Remaining Allwnce.

2857 48% 35% $1,069,042 $64,257

42

0

2

3 2 0

11 2 0

$1,124,756

Total 1900

11% 9%

current month w/o

4,748 0 0 (unearned interest portion) 4,748

$108,678.21 0 $60,609 $48,068.85

472

2

Dated

1

May Write-offs ABC MTS DLSI F/E

Total

prev. bal.

99897.44

$4,748.00

(MTS)

MilitaryTechSource.com

Jun-08 JUNE This Month

Sales: Applications: Approval Rate: Completion Rate: avg. sale amount

MAY Last Month

25 52% 77% $2,427

total laptops:

10

Total

61 34% 95% $2,827 $24,273

20

2882 48% 35% $2,457 $58,541

472 $1,149,029

Accounts paid off:

8

9

50

Golden Nugget Sales

0

0

2

Secondary Financing Approvals Sales Delquency

0 0 0

2 0 0

11 2 0

Inventory:

Current 5920

1

May Delinquency: Outstanding Receivables: Delinquent $ Total Portfolio write-off

May Write-offs ABC MTS DLSI F/E

Bad Debt Allwnce. ABC Delinquency ABC Past Due Remaining Allwnce.

Dated

Total

1900

$596,800 $69,780 $57,818

1900

12% 9%

(MTS) current month w/o $4,578.40 David Fair BK $2,579.26

4,578 0 0 (unearned interest portion) 4,578

$85,887.78 0 $60,609 $25,278.42

prev. bal. 108678.21

19 approved 15 declined

MilitaryTechSource.com

July July This Month

Sales: Applications: Approval Rate: Completion Rate: avg. sale amount

JUNE Last Month

63 52% 30% $2,896

Total

25 52% 77% $2,427

9

Accounts paid off:

4

8

54

Golden Nugget Sales

0

0

2

Secondary Financing Approvals Sales Delquency

0 0 0

2 0 0

11 2 0

Current 5920

1

May Delinquency: Outstanding Receivables: Delinquent $ Total Portfolio write-off

June Write-offs ABC MTS DLSI F/E

Bad Debt Allwnce. ABC Delinquency ABC Past Due Remaining Allwnce.

10

$2,457

total laptops:

Inventory:

$26,060

2945 48% 35%

$24,273

Dated

Total

1900

$609,133 $96,378 $66,774

1900

16% 6%

(MTS) current month w/o $8,955.58 straight wj/o due to default on payments.

8,956 0 0 (unearned interest portion) 8,956

$83,995.93 2,991.04 60,609.36 $20,395.53

472 $1,175,089

prev. bal.

85887.78

ault on payments.

MilitaryTechSource.com

Aug-08 August This Month

Sales: Applications: Approval Rate: Completion Rate: avg. sale amount

July Last Month

56 66% 51% $2,568

total laptops:

19

Total

63 52% 30% $2,896 $48,792

9

3001 48% 35% $2,457 $26,060

491 $1,223,881

Accounts paid off:

8

4

62

Golden Nugget Sales

0

0

2

Secondary Financing Approvals Sales Delquency

0 0 0

0 0 0

11 2 0

Inventory:

Current

May Delinquency: Outstanding Receivables: Delinquent $ Total Portfolio write-off

June Write-offs ABC MTS DLSI

$604,047 $90,311 $74,660

Dated

15% 6%

Total

(MTS) current month w/o $7,886.80 straight w/o due to default on payments.

7,887 7,887

Bad Debt Allwnce. ABC Delinquency ABC Past Due Remaining Allwnce.

$77,548.40 60,609.36 $16,939.04

prev. bal.

$83,995.93

on payments.

MilitaryTechSource.com

Sales:

Sep-08 September This Month

Applications: Approval Rate: Completion Rate: avg. sale amount

August Last Month

65 35% 60% $2,980

total laptops:

14

Total

56 66% 51% $2,568 $41,718

19

3001 48% 35% $2,457 $48,792

505 $1,265,599

Accounts paid off:

2

8

Golden Nugget Sales

0

0

64 68479 2

Secondary Financing Approvals Sales Delquency

0 0 0

0 0 0

11 2 0

Inventory:

September Delinquency: Outstanding Receivables: Delinquent $ Total Portfolio write-off

Current

$602,663 $90,311 $83,624

Dated

15% 7%

Total

(MTS) current month w/o $8,963.74 straight w/o due to default on payments.

September Write offs] ABC MTS 8,964 DLSI -

Bad Debt Allwnce. ABC Delinquency ABC Past Due Remaining Allwnce.

$73,572.90 60,609.36 $12,963.54

prev. bal.

$77,548.40

on payments.

MilitaryTechSource.com October This Month

Sales: Applications: Approval Rate: Completion Rate: avg. sale amount total laptops:

21

September Last Month

77 66% 41% $2,779

65 35% 60% $2,980

58348.52

14

Accounts paid off:

2

Golden Nugget Sales

14

0

Secondary Financing Approvals Sales Delquency

0 0 0

0 0 0

Inventory: xbox 360

Current

Bad Debt Allwnce. ABC Delinquency ABC Past Due Remaining Allwnce.

Dated 399

October Delinquency: Outstanding Receivables: Delinquent $ Total Portfolio write-off

October Write offs ABC MTS DLSI

$41,718

$598,596 $90,387 $91,208

15% 7%

(MTS) current month w/o straight w/o due to default on payments.

7,584 -

$68,728.97 60,609.36 $8,119.61

prev. bal.

$73,572.90

Oct-08

Total 3078 48% 35% $2,457 526

$1,323,948

64 16

11 2 0 Total 399

ent month w/o $7,584.14 ght w/o due to default on payments.

MilitaryTechSource.com

Nov-08 November This Month

Sales: Applications: Approval Rate: Completion Rate: avg. sale amount

October Last Month

85 54% 50% $2,062

Total

77 66% 41% $2,779

25

Accounts paid off:

21

2

85

Golden Nugget Sales

13

14

29

Secondary Financing Approvals Sales Delquency

0 0 0

0 0 0

11 2 0

Current

21

$2,457

total laptops:

Inventory:

$51,539

3163 48% 35%

$58,349

Dated

551 $1,375,487

Total

0

November Delinquency: Outstanding Receivables: Delinquent $ Total Portfolio write-off

November Write offs ABC MTS DLSI

Bad Debt Allwnce. ABC Delinquency ABC Past Due Remaining Allwnce.

$616,435 $101,168 $98,570

16% 7%

(MTS) current month w/o $7,361.94 straight w/o due to default on payments.

7,362 -

$61,322.62 60,609.36 $713.26

prev. bal.

$68,728.97

MilitaryTechSource.com

Dec-09 December This Month

Sales: Applications: Approval Rate: Completion Rate: avg. sale amount

November Last Month

36 55% 80% $2,623

total laptops:

16

Total

85 54% 50% $2,062 $41,964

25

3199 48% 35% $2,457 $51,539

567 $1,417,451

Accounts paid off:

0

21

85

Golden Nugget Sales

0

13

29

Secondary Financing Approvals Sales Delquency

0 0 0

0 0 0

11 2 0

Inventory:

Current 4620

2

December Delinquency: Outstanding Receivables: Delinquent $ Total Portfolio write-off

December Write offs ABC MTS DLSI

Bad Debt Allwnce. ABC Delinquency ABC Past Due Remaining Allwnce.

Dated

Total

1250

$619,345 $114,441 $98,570

1250

17% 7%

(MTS) current month w/o $2,657.00 straight w/o due to default on payments.

2,657 -

$67,278.37 60,609.36 $6,669.01

prev. bal.

$61,322.62

MilitaryTechSource.com January This Month

Sales: Applications: Approval Rate: Completion Rate: avg. sale amount

December Last Month

53 34% 61% $2,391

total laptops:

11

36 55% 80% $2,623 $26,300

16

Accounts paid off:

8

21

Golden Nugget Sales

0

13

Secondary Financing Approvals Sales Delquency

0 0 0

0 0 0

Inventory:

Current

$41,964

Dated 0

January Delinquency: Outstanding Receivables: Delinquent $ Total Portfolio write-off

January Write offs ABC MTS DLSI

Bad Debt Allwnce. ABC Delinquency ABC Past Due Remaining Allwnce.

$617,787 $114,837 $102,146

18% 7%

(MTS) current month w/o straight w/o due to default on payments.

3,576 -

68,722 60,609 8,113

prev. bal.

$67,278

Jan-09

Total 3252 48% 35% $2,457 578 $1,443,751 93 29

11 2 0 Total

urrent month w/o traight w/o due to default on payments.

0

$3,576

MilitaryTechSource.com February This Month

Sales: Applications: Approval Rate: Completion Rate: avg. sale amount

January Last Month

53 34% 50% $2,543

53 34% 61% $2,391

total laptops:

9

Accounts paid off:

6

21

Golden Nugget Sales

0

13

Secondary Financing Approvals Sales Delquency

0 0 0

0 0 0

February Delinquency: Outstanding Receivables: Delinquent $ Total Portfolio write-off

February Write offs ABC MTS DLSI

Bad Debt Allwnce. ABC Delinquency ABC Past Due Remaining Allwnce.

$632,698 $127,172 $105,917

$22,884

11

18% 7%

$26,300

(MTS) current month w/o straight w/o due to default on payments.

-

67,852 60,609 7,243

prev. bal.

$68,722

Feb-09

Average for 2009

Historical Avg. 122 48% 35% $2,457 587 $1,466,635 99 29

11 2 0

urrent month w/o traight w/o due to default on payments.

$3,771

MilitaryTechSource.com March This Month

Sales: Applications: Approval Rate: Completion Rate: avg. sale amount

February Last Month

15 66% 80% $2,095

53 34% 50% $2,391

total laptops:

8

Accounts paid off:

8

6

Golden Nugget Sales

0

0

March Delinquency: Outstanding Receivables: Delinquent $ 90+ days Total Portfolio write-off March Write offs MTS Global Consulting 800 HighTech Bad Debt Allowance: MTS Bad Debt Allwnce. 800 HighTech ABC Delinquency ABC Past Due Remaining Allwnce.

$579,724 $122,501 $116,048

$16,762

9

$22,884

(MTS) current month w/o straight w/o due to default on payments.

21% 8%

2009 ytd w/o 10,131 -

5%

59,766 1,193 60,609 Principal (843)

prev. bal.

$67,852

Mar-09

average for 2009

Historical Avg.

18 45% 60% $2,292

122 48% 35% $2,457

9

595 $1,483,397

107 29

urrent month w/o traight w/o due to default on payments.

$10,131

$17,478

MilitaryTechSource.com

Sales:

April This Month

March This Month

Applications: Approval Rate: Completion Rate: avg. sale amount

30 12 6 $2,291

40% 50%

Total laptops: Purchased deals: Totals

6 4 10

13,744 12,819 26,563

APRIL

average for 2009

15 66% 80% $2,543

9

$22,884

9

$22,884

March

totals

Accounts paid off:

8

8

115

Golden Nugget Sales

0

0

29

Reserve/NG/Veterans:

1

April Delinquency: Outstanding Receivables: Delinquent $ 90+ days Total Portfolio write-off April Write offs MTS Global Consulting 800 HighTech Bad Debt Allowance: MTS Bad Debt Allwnce. 800 HighTech 5% ABC Delinquency ABC Past Due Remaining Allwnce.

$548,945 $117,986 $126,507

(MTS) current month w/o straight w/o due to default on payments.

21% 8%

2009 ytd w/o 10,459 -

52,083 3,116 60,609 Principal (8,526)

prev. bal.

$59,766

Target allowance for MTS

$82,341.73

Apr-09

average for 2009 39 43% 60% $2,533

9

605

$10,459

o default on payments. $27,937

$1,509,960

Portfolio

April

March

February

Cash

Principal Balance

Cash

Principal Balance

Cash

Principal Balance

82 218

387 80 321

404 165 412

1,542 1,029

37,231

4,476 1,136 7,953 579,724

42,898

632,698

ABC Global Consulting Distance Learning 800 HighTech MilitaryTechSource.com

33,569

4,649 493 20,772 $548,945

LeaseQuest:

1,364

7,118

1,364

8,255

1,364

9,374

Monthly Total:

35,234

581,977

39,384

601,544

45,242

644,643

-

-

January-09 Cash

Dec-08

November

Principal Balance

Cash

Principal Balance

Cash

Principal Balance

-

-

-

-

437

1,361 1,650 1,427

429

1,853

759

3,254

34,443

617,787

34,410

621,204

34,529

616,435

1,364

10,474

1,364

11,556

1,364

12,620

36,244

632,698

36,203

634,613

36,652

632,309

-

October

September

Aug-08

Cash

Principal Balance

Cash

Principal Balance

Cash

781

2,670

1,683

3,739

2,113

297

8,837

590

9,148

668

37,314

598,596

39,361

602,663

40,275

2,047

13,666

2,047

14,696

2,047

40,439

623,769

43,681

630,245

45,103

Aug-08

JULY

JUNE

Principal Balance

Cash

Principal Balance

Cash

Principal Balance

4,035

1,963 -

4,899 -

2,817 -

7,996 -

897

10,341

964

11,153

41,124

609,133

37,788

596,800

2,047

16,705

2,047

20,353

46,031

641,078

43,616

636,302

10,341 604,047 15,709 634,131

MAY

APRIL

Cash

Principal Balance

Cash

Principal Balance

2,728 -

4,245 12,031

2,880 159

10,387 531

1,315

531

1,326

13,245

44,727

609,523

40,668

542,507

2,047

21,961

2,047

23,546

50,817

648,290

47,080

590,217

.

MARCH

FEBRUARY

JANUARY

Cash

Principal Balance

Cash

Principal Balance

Cash

2,803 159

13,146 685

3,259 151

15,842 839

3,418 -

1,532

14,457

1,679

15,869

1,553

36,919

580,284

35,814

590,214

36,465

4,099

27,722

4,025

31,821

7,874

45,512

636,294

44,929

654,586

49,310

JANUARY

December

November

Principal Balance

Cash

Principal Balance

Cash

Principal Balance

65,051 993

3,816 151

65,051 993

3,871 159

88,613 1,147

18,813

2,473

18,813

1,691

28,912

541,229

32,892

541,229

31,756

511,837

8,718

51,442

46,194

681,952

35,847 661,934

39,331

October Cash

September

Principal Balance.

Cash

August

Principal Balance.

Cash

4,481 157

112,803 1,408

7,179 315

112,803 1,408

7,557 331

2,110

34,381

1,732

34,381

2,679

30,682

451,961

27,497

451,961

29,007

8,718

79,081

8,718

79,081

8,718

46,148

679,634

45,440

679,634

48,292

August

July

June

May

Principal Balance.

Cash

Principal Balance.

Cash

Principal Balance.

Cash

109,491 6,304

8,620 260

122,529 6,590

10,154 405

123,462 6,835

9,117 400

41,311

2,222

43,915

4,599

45,838

2,341

450,959

23,096

433,576

25,364

393,999

20,663

79,081

8,718

80,871

8,718

87,878

8,508

687,145

42,916

687,480

49,239

658,012

41,028

May

April

Principal Balance.

Cash

March

Principal Balance.

Cash

February

Principal Balance.

Cash

140,952 7,191

10,032 973

151,807 7,301

12,011 377

166,732 8,269

10,890 825

59,117

2,916

64,152

2,937

71,378

2,728

349,951

24,729

317,597

19,105

299,025

17,076

94,793

8,508

101,413

8,508

107,906

7,850

652,003

47,157

642,270

42,939

653,310

39,369

February Principal Balance.

JANUARY Cash

DECEMBER

NOVEMBER

Principal Balance.

Cash

Principal Balance.

Cash

Principal Balance

190,882 8,609

12,812 892

199,107 11,322

11,624 1,132

226,242 14,857

12,550 878

240,236 24,833

73,975

3,675

78,473

2,849

83,164

2,994

85,709

284,126

15,427

280,039

12,998

256,737

12,132

236,383

114,274

7,354

88,841

7,354

94,350

7,354

99,751

671,866

40,161

657,782

35,956

686,913

35,907

686,913

EMBER

OCTOBER

Principal Balance

Cash

Principal Balance

240,236 24,833

11,857 1,216

260,481 25,503

85,709

2,668

88,373

236,383

9,055

237,599

99,751

7,354

105,047

686,913

32,150

717,004

Related Documents

Arun Report
May 2020 4
Arun
December 2019 52
Arun
June 2020 14
Arun
November 2019 24
Management Report
May 2020 1

More Documents from ""