Hampton Machine Tool Company
Exhibit 1
Shipments at Selling Price (thousands of dollars)
1979
January
February
March
April
May
June
July
August
Eight months total
September
October
November
December
As Forecast
Dec. 1978
$1,302
$1,872
$1,635
$1,053
$1,293
$1,479
$1,488
$1,797
$11,919
$1,299
$1,347
$1,311
$2,298
$6,255
Actual
$861
$672
$1,866
$1,566
$873
$1,620
$723
$507
$8,688
As Forecast
Sept. 1979
$441
$1,200
($231)
($513)
$420
($141)
$765
$1,290
$3,231
$2,000
$1,000
$500
$0
0.73
$2,163
$1,505
$1,604
$2,265
$7,537.00 ############
############
$2,500
$1,500
27%
Forecast
Actual
$864
$158
$293
($33)
$1,282
Hampton Machine Tool Company
Exhibit 2
Balance Sheets, 1978--1979 (thousands of dollars)
1978
Nov. % / activo
Efectivo
$2,520
34%
Cuentas por cobrar
$1,245
17%
Inventarios
$2,601
35%
TOTAL activo circulante
$6,366
86%
1979
Dec. % / activo Mar. % / activo
$491
8%
$505
7%
$1,863
32% $1,971
28%
$2,478
42% $3,474
50%
$4,832
82% $5,950
86%
June % / activo
$1,152
16%
$1,893
26%
$3,276
45%
$6,321
87%
July % / activo
$1,678
22%
$1,269
17%
$3,624
48%
$6,571
87%
Aug.
$1,559
$684
$4,764
$7,007
Activos fijos brutos
Depreciacion acomulada
Activos fijos netos
Gastos pagadados x adelantado
ACTIVOS TOTALES
$4,010
$2,998
$1,012
54%
40%
14%
$4,010
$3,010
$1,000
68%
51%
17%
$4,010
$3,040
$970
58%
44%
14%
$4,010
$3,070
$940
55%
42%
13%
$4,010
$3,080
$930
53%
41%
12%
$4,010
$3,090
$920
$62
1%
$40
1%
$39
1%
$24
0%
$24
0%
$42
$7,440
Documentos x pagar a bancos
$0
cuentas por pagar
$348
Pasivos acomulado(devengados)
$561
Impuestos por pagar
$150
Anticipos de clientes
$840
TOTAL PASIVOS CIRCULANTES $1,899
Capital social comun ( acciones $10)
$1,178
Supervit
$4,363
Capital contable
$5,541
$5,872
$1
$6,959
$7,285
$7,525
$7,969
% / pasivo
% / pasivo
% / pasivo
% / pasivo
% / pasivo
0% $1,000
17% $1,000
14% $1,000
14% $1,000
13% $1,000
5%
$371
6%
$681
10%
$399
5%
$621
8%
$948
8%
$777
13%
$849
12%
$678
9%
$585
8%
$552
2%
$74
1%
$373
5%
$354
5%
$407
5%
$479
11% $1,040
18% $1,040
15% $1,566
21% $1,566
21% $1,566
26% $3,262
56% $3,943
57% $3,997
55% $4,179
56% $4,545
16%
59%
74%
TOTAL PASIVO Y CAPITAL CONTABLE
$7,440
$428
$2,182
$2,610
7%
37%
44%
$428
$2,588
$3,016
$5,872
$1
$6,959
*Tax payments in 1979 include $75,000 due March 15 on underpayment of 1978 taxes and four equal
payments of $181,000 due on the 15th of April, June, September, and December for estimated 1979 tax
liability with any underpayment of 1979 taxes due March 15, 1980.
6%
37%
43%
$428
$2,860
$3,288
$7,285
6%
39%
45%
$428
$2,918
$3,346
$7,525
6%
39%
44%
$428
$2,996
$3,424
$7,969
Hampton Machine Tool Company
% / activo
20%
9%
60%
88%
50%
39%
12%
1%
% / pasivo
13%
12%
7%
6%
20%
57%
5%
38%
43%
Hampton Machine Tool Company
Exhibit 3
Income Statements, 1978--1979 (thousands of dollars)
Fiscal
Year
Ending
Dec.
1979
31/12/78
1978
Jan.
Ventas netas
$7,854
$1,551
$861
Costo de ventas
$5,052
$1,122
$474
UTILIDAD BRUTA
$2,802
$429
$387
Gastos de venta y admn
$1,296
gastos por interes
$0
Utilidad neta antes de impuestos
$1,506
Feb.
$672
$369
$303
Mar.
$1,866
$1,362
$504
Apr.
$1,566
$1,137
$429
May
$873
$567
$306
June
$1,620
$1,197
$423
July
$723
$510
$213
Aug.
$507
$276
$231
$248
$0
$181
$103
$15
$269
$61
$15
$227
$205
$15
$284
$172
$15
$242
$96
$15
$195
$130
$15
$278
$87
$15
$111
$66
$15
$150
Impuestos sobre la renta
$723
$87
$129
$109
$136
$116
$94
$133
$53
$72
UTILIDAD NETA
$783
$94
$140
$118
$148
$126
$101
$145
$58
$78
$50
$25
$0
$0
$0
$0
$0
$100
$0
$0
Dividendos
* Includes depreciation charges of $150,000 in 1978, $12,000 in December 1987, and $10,000 per month in 1979.
Hampton Machine Tool Company
Eight
Months
Ending
31/8/79
$8,688
$5,892
$2,796
$920
$120
$1,756
$842
$914
$0
$100
SEPT
$2,163
OCT
$1,505
NOV
$1,604
DIC
$2,265
Hampton Machine Tool Company
Hampton Machine Tool
Pro Forma Statements
(thousands of dollars)
Historical
July
$723
Aug.
$507
$597
$126
$15
$111
$53
$58
$342
$165
$15
$150
$72
$78
$100
$45
$0
$58
$0
$78
Cash (plug)
cuentas por xobrar
Inventories
Current assets
activos fijos brutos
Accumulated depreciation
Net fixed assets
Prepaid expenses
Total assets
$1,152
$1,893
$3,276
$6,321
$4,010
$3,070
$940
$24
$7,285
$1,678
$1,269
$3,624
$6,571
$4,010
$3,080
$930
$24
$7,525
$1,559
$684
$4,764
$7,007
$4,010
$3,090
$920
$42
$7,969
$699
$1,323
$3,339
$5,361
$4,010
$3,100
$910
$42
$6,313
Notes payable, bank
Accounts payable
Accruals
Taxes payable*
pago anticipado clientes
Current liabilities
Common stock ($10 par value)
Surplus
Net worth
Total liabilities and net worth
$1,000
$399
$678
$354
$1,566
$3,997
$428
$2,860
$3,288
$7,285
$1,000
$621
$585
$407
$1,566
$4,179
$428
$2,918
$3,346
$7,525
$1,000
$948
$552
$479
$1,566
$4,545
$428
$2,996
$3,424
$7,969
$1,000
$600
$552
$160
$726
$3,038
$428
$2,847
$3,275
$6,313
June
$1,620
ventas netas
compras
WIP inventory reduction
Raw materials reduction
Cost of goods sold
Depreciation
Other expenses
Cost of sales and other expenses$1,327
earnings before interes & taxes
$293
Interest expense
$15
Net income before taxes
$278
Income taxes
$133
Net income
$145
Dividends
utilidades retenidas
Change in cash
$526
($119)
Sept.
$2,163
$600
$1,320
$105
$2,025
$10
$400
$2,435
($272)
$15
($287)
($138)
($149)
Pro Forma
Oct.
ventas netas
$1,505
comprasC
$600
7maquinasC
$0
420/4mesesC
$105
2+3+4
$705
tabla 2 acuumu**
$10
otrosgastosC
$400
5+6+7
$1,115
..1-8
$390
1.5% pretamo
$15
..9-10
$375
48%de11 C**
$145
..11-12
$230
Nov.
$1,604
$600
$0
$105
$705
$14
$400
$1,119
$486
$20
$466
$223
$242
Dec.
$2,265
$600
$0
$105
$705
$14
$400
$1,119
$1,147
$20
$1,127
$541
$586
$0
$230
$0
$242
$150
$436
..34-17-18-22-23
..1-39
..18+2-5 ***
..16+17+18
..20+36***
..21+6**
..20-21
tabla2 prepaid
..19+22+23
$1,007
$779
$3,234
$5,020
$4,360
$3,110
$1,250
$42
$6,312
$766
$1,604
$3,129
$5,499
$4,360
$3,124
$1,237
$42
$6,778
($331)
$2,265
$3,024
$4,958
$4,360
$3,137
$1,223
$42
$6,223
25+37
comprafija carta
tabla2
..28+12-38**
..29-39**
..25+26+27+28+29
tabla2
32+15**
..31+32
..30+33
$1,350
$600
$552
$305
$0
$2,807
$428
$3,077
$3,505
$6,312
$1,350
$600
$552
$529
$0
$3,031
$428
$3,319
$3,747
$6,778
$0
$600
$552
$888
$0
$2,040
$428
$3,755
$4,183
$6,223
$0
($149) ..13-14
($860) ..16pasado-16
$308
($241)
($1,097)
Hampton Machine Tool
Projected Cash Budget
(thousands of dollars)
September
October
November
December
January
Cash Inflows:
Collections of Receivables:
Bank Loan:
Total cash inflows:
$
Cash Outflows:
Payments of Accounts Payable:
Other Operating Outflows:
Purchase New Equipment:
Tax Payments:
Interest Payments to Bank:
Principal Repayments to Bank:
Dividends:
Total cash outflows:
$
Reconciliation:
Begining cash balance:
Net cash flow:
Ending cash balance:
