Sheet1
CASH REPORT
DATE:
CASHIER:
RECEIPTS
Receipt # Payment Method Description Currency
1 USD
2 USD
3 USD
4 USD
5 USD
6 USD
7 USD
8 USD
9 USD
10 USD
TOTAL:
SUMMARY
Total Receipts 0
Cash 0
Check 0
Credit Card 0
Other 0
Last Reported Receipt Number:
I confirm receiving the above amounts and clearing the cashier custody for the day:
NAME: DATE:
SIGNATURE:
Page 1
Sheet1
Amount
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
r custody for the day:
Page 2
Customer 2 0 0 0 0
Customer 3 12,752 14,027 14,027 13,389
Subsidies 0 0 0 0
Additional loan 0 0 0 0
VAT Receivables 38,413 29,718 38,663 36,093
Other payments 0 0 0 0 Debts VWM from week 34 + extra claims to end of 2005
Cash inflow (positive amounts) 503,681 339,888 408,463 404,462
Ending cash balance -174 -17,502 -19,468 -6,896
Credit limit (current bank accounts)
Financial payables (loans)
B.B.V.A. Bancomer usage 22,872 22,872 15,248 15,248
Loan limit 22,872 22,872 15,248 15,248
interest rate
maturity date
HQ usage 0.0 0.0 0.0 0.0
limit 0.0 0.0 0.0 0.0
interest rate
maturity date
GmbH usage 104,943 104,943 104,943 104,943
limit 104,943 104,943 104,943 104,943
interest rate
maturity date
Bank / Outside Financing usage
limit
interest rate
maturity date
Cash account after interest and tax (forecast) -127,989 -145,317 -139,659 -127,086
Cash account after interest and tax (PlanXI/01) -127,989 -145,317 -139,659 -127,086
Automoitve Ending Cash Balance is result of 30 days payment term USD!!
k MXP 5/11/2010
forecast1 forecast2 forecast3 forecast4
cash flow (current bank accounts) 30/04/09 31/05/09 00/01/00 31/07/09
ex. rate to EURO: 13.1144 13.1144 13.1144 13.1144 Comments
ex. rate to USD: 10.8914 10.8914 10.8914 10.8914
ex. rate to JPY: 0.0927 0.0927 0.0927 0.0927
Starting cash balance 40,531 16,210 -5,209 -24,385
Payments to suppliers, 3rd
Supplier 1
Supplier 2
Supplier 3
Payroll / social security / tax -3,986 -4,110 -4,110 -4,115
Investments -50 -50 -50 -50
Interest payments
Loan refund
VAT Payables -50,557 -38,413 -29,718 -38,663
Other payments -8,142 -8,564 -8,728 -8,498 Including consumables and pre-logistics costs
Cash outflow (negative amounts) -62,734 -51,138 -93,932 -51,326
Payments from customer, 3rd
Customer 1
Customer 2
Customer 3
Subsidies
Additional loan
VAT Receivables 38,413 29,718 38,663 36,093
Other payments
Cash inflow (positive amounts) 38,413 29,718 74,756 36,093
Ending cash balance 16,210 -5,209 -24,385 -39,618
Credit limit (current bank accounts)
Financial payables (loans)
B.B.V.A. Bancomer usage
Loan limit
interest rate
maturity date
HQ usage
limit
interest rate
maturity date
GmbH usage
limit
interest rate
maturity date
Bank / Outside Financing usage
limit
interest rate
maturity date
Cash account after interest and tax (forecast) 16,210 -5,209 -24,385 -39,618
Cash account after interest and tax (PlanXI/01) 16,210 -5,209 -24,385 -39,618
Automotive Ending Cash Balance is result of 30 days payment term USD!!
k USD 5/11/2010
forecast1 forecast2 forecast3 forecast4
cash flow (current bank accounts) 30/04/09 31/05/09 30/06/09 31/07/09
ex. rate to EURO: 13.1144 13.1144 13.1144 13.1144 Comments
ex. rate to USD: 10.8914 10.8914 10.8914 10.8914
ex. rate to JPY: 0.0927 0.0927 0.0927 0.0927
Starting cash balance 1,236 1,968 3,216 3,751
Payments to suppliers, 3rd -37,876 -23,094 -26,837 -25,991
Supplier 1
Supplier 2
Supplier 3
Payroll / social security / tax
Investments
Interest payments -40 -40 -53 -53
Loan refund -700 Lum Sum Payback in Jun 06 to BBVA
VAT Payables
Other payments
Cash outflow (negative amounts) -37,916 -23,134 -27,590 -26,044
Payments from customer, 3rd 37,477 23,094 26,837 25,991
Customer 1
Customer 2
Customer 3 1,171 1,288 1,288 1,229
Subsidies
Additional loan
VAT Receivables
Other payments
Cash inflow (positive amounts) 38,648 24,382 28,125 27,221
Ending cash balance 1,968 3,216 3,751 4,927
Credit limit (current bank accounts)
Financial payables (loans)
B.B.V.A. Bancomer usage 2,100 2,100 1,400 1,400
Loan limit 2,100 2,100 1,400 1,400
interest rate 5.00% 5.00% 5.00% 5.00%
maturity date
HQ usage
limit
interest rate
maturity date
GmbH usage 9,635 9,635 9,635 9,635
limit 9,635 9,635 9,635 9,635
interest rate 5.00% 5.00% 5.00% 5.00%
maturity date
Bank / Outside Financing usage
limit
interest rate
maturity date
Cash account after interest and tax (forecast) -9,767 -8,519 -7,284 -6,108
Cash account after interest and tax (PlanXI/01) -9,767 -8,519 -7,284 -6,108
Automotive Ending Cash Balance is result of 30 days payment term USD!!
k EUR 5/11/2010
forecast1 forecast2 forecast3 forecast4
cash flow (current bank accounts) 30/04/09 31/05/09 30/06/09 31/07/09
ex. rate to EURO: 13.1144 13.1144 13.1144 13.1144 Comments
ex. rate to USD: 10.8914 10.8914 10.8914 10.8914
ex. rate to JPY: 0.0927 0.0927 0.0927 0.0927
Starting cash balance 77 -2,884 -3,608 -3,902
Payments to suppliers, 3rd -6,342 -4,126 -5,134 -4,339 Including due payments (15 days stock in EUR)
Supplier 1
Supplier 2
Supplier 3
Payroll / social security / tax
Investments
Interest payments
Loan refund
VAT Payables
Other payments
Cash outflow (negative amounts) -6,342 -4,126 -5,134 -4,339
Payments from customer, 3rd 3,381 3,402 4,840 5,482
Customer 1
Customer 2
Customer 3
Subsidies
Additional loan
VAT Receivables
Other payments
Cash inflow (positive amounts) 3,381 3,402 4,840 5,482
Ending cash balance -2,884 -3,608 -3,902 -2,759
Credit limit (current bank accounts)
Financial payables (loans)
B.B.V.A. Bancomer usage
Loan limit
interest rate
maturity date
HQ usage
limit
interest rate
maturity date
GmbH usage
limit
interest rate
maturity date
Bank / Outside Financing usage
limit
interest rate
maturity date
Cash account after interest and tax (forecast) -2,884 -3,608 -3,902 -2,759
Cash account after interest and tax (PlanXI/01) -2,884 -3,608 -3,902 -2,759
Automotive Mexico Ending Cash Balance is result of 30 days payment term USD!!
k JPY 5/11/2010
forecast1 forecast2 forecast3 forecast4
cash flow (current bank accounts) 30/04/09 31/05/09 30/06/09 31/07/09
ex. rate to EURO: 13.1144 13.1144 13.1144 13.1144 Comments
ex. rate to USD: 10.8914 10.8914 10.8914 10.8914
ex. rate to JPY: 0.0927 0.0927 0.0927 0.0927
Starting cash balance 0 0 0
Payments to suppliers, 3rd
Supplier 1
Supplier 2
Supplier 3
Payroll / social security / tax
Investments
Interest payments
Loan refund
VAT Payables
Other payments
Cash outflow (negative amounts) 0 0 0 0
Payments from customer, 3rd
Customer 1
Customer 2
Customer 3
Subsidies
Additional loan
VAT Receivables
Other payments
Cash inflow (positive amounts) 0 0 0 0
Ending cash balance 0 0 0 0
Credit limit (current bank accounts)
Financial payables (loans)
B.B.V.A. Bancomer usage
Loan limit
interest rate
maturity date
HQ usage
limit
interest rate
maturity date
GmbH usage
limit
interest rate
maturity date
Bank / Outside Financing usage
limit
interest rate
maturity date
Cash account after interest and tax (forecast) 0 0 0 0
Cash account after interest and tax (PlanXI/01) 0 0 0 0
W43
BMBEJK
OVERFLOW VALOR01 BOWACD CASH-OUTFLOWS
Apr09 Mai09 Jun09
200609 698,296.68 EUR 418,978.01
200610 526,165.41 EUR 945,143.42
200611 1,340,151.62 EUR 2,285,295.04
200612 606,136.24 EUR 2,891,431.27
200613 524,990.60 EUR 3,416,421.88
200614 930,951.16 EUR 930,951.16
200615 1,027,576.84 EUR 1,958,528.00
200616 1,160,418.96 EUR 3,118,946.96
200617 1,007,528.47 EUR 4,126,475.43
200618 1,043,770.82 EUR 1,043,770.82
200619 601,084.51 EUR 1,644,855.34
200620 1,435,591.32 EUR 3,080,446.65
200621 1,323,809.46 EUR 4,404,256.11
200622 1,216,160.28 EUR 5,133,952.28
200623 1,506,823.55 EUR
200624 996,503.82 EUR
200625 349,410.87 EUR
200626 1,000,000.00 EUR
0 17,295,370.61 EUR
200609 USD 6,864,215.72
200610 USD 13,473,500.95
200611 731,979.31 USD 16,130,762.52
200612 3,311,255.63 USD 19,442,018.15
200613 4,752,029.65 USD 4,752,029.65
200614 4,008,969.42 USD 8,760,999.07
200615 585,152.49 USD 9,346,151.56
200616 4,747,744.85 USD 14,093,896.41
200617 4,583,349.80 USD 4,583,349.80
200618 2,018,548.04 USD 6,601,897.84
200619 2,598,446.37 USD 9,200,344.21
200620 4,396,627.01 USD 13,596,971.23
200621 4,240,259.61 USD 17,837,230.83
200622 4,169,109.40 USD
200623 4,057,507.36 USD
200624 3,588,085.15 USD
200625 3,676,605.82 USD
0 51,465,669.92 USD
ALCOA estimated 10,500,000.00 9,000,000.00 9,000,000.00
Total EUR 3,416,421.88 4,126,475.43 5,133,952.28
Total USD 19,442,018.15 14,093,896.41 17,837,230.83
Total YEN
VAT EUR ver banco+SBI 507,144.31 510,334.44
Page 6
W43
VAT USD ver banco+SBI 2,916,302.72 2,114,084.46
VAT YEN ver banco+SBI - -
Page 7
W43
SBI CASH-INFLOWS
Jul09 Apr09 Mai09 Jun09 Jul09
2,854,796.68
3,380,962.09
1,340,151.62
1,946,287.86
2,471,278.46
3,402,229.62
1,027,576.84
2,187,995.80
3,195,524.28
4,239,295.10
4,840,379.61
1,435,591.32
2,759,400.77
486,464.11 3,975,561.05
1,993,287.66 5,482,384.60
2,989,791.48
3,339,202.35
4,339,202.35
6,864,215.72
13,473,500.95
16,130,762.52
19,442,018.15
4,752,029.65
8,760,999.07
9,346,151.56
14,093,896.41
4,583,349.80
6,601,897.84
9,200,344.21
13,596,971.23
17,837,230.83
4,169,109.40 4,169,109.40
8,226,616.76 8,226,616.76
11,814,701.92 11,814,701.92
15,491,307.74 15,491,307.74
10,500,000.00 ALCOA estimated 10,500,000.00 9,000,000.00 9,000,000.00 10,500,000.00
4,339,202.35 Total EUR 3,380,962.09 3,402,229.62 4,840,379.61 5,482,384.60
15,491,307.74 Total USD 19,442,018.15 14,093,896.41 17,837,230.83 15,491,307.74
Total YEN
726,056.94 VAT EUR 507,144.31 510,334.44 726,056.94 822,357.69
Page 8
W43
2,675,584.62 VAT USD 2,916,302.72 2,114,084.46 2,675,584.62 2,323,696.16
- VAT YEN - - - -
VAT EUR 3,190.13 215,722.50 96,300.75
VAT USD -802,218.26 561,500.16 -351,888.46
VAT YEN 0.00 0.00 0.00
Page 9
Automotive System
SUMMARY
Date 27.03.2009
Key Date 27.03.2009
User I678R
Log de Materiales: MATNR_XX.TXT
Log de Facturas VW: FACT_XX.TXT
SAP CODE NAME date VW
CURRENCY SUBTOTAL
600001 Panasonic INC USD 30.03.2009 151,982.71
600006 Linde Pullmann de Queretaro USD 30.03.2009 90,381.82
600008 Lunkomex SA USD 30.03.2009 81,817.52
600013 Thyssen Krupp Presta de Mexico USD 30.03.2009 268,504.32
600014 Transnav INC. USD 30.03.2009 5,053.33
600016 Valeo Climat Control USD 30.03.2009 387,390.05
600018 Benteler de Mexico USD 30.03.2009 136,950.61
600021 DELPHI ELECTRONICS & SAFETY USD 30.03.2009 521,862.56
600024 Alcoa Fujikura de Mexico USD 30.03.2009 2,137,758.35
600025 FTE Mexicana S.A. de C.V. USD 30.03.2009 195,098.00
600027 Hella KG Hueck Co. USD 30.03.2009 144,791.21
600028 HUF North America Automotive USD 30.03.2009 130,426.28
600037 Manufacturas GCI, S.A. de C.V. USD 30.03.2009 3,990.08
600048 AKSYS de Mexico USD 30.03.2009 25,525.80
600049 Autoliv Steering Weels Mexico USD 30.03.2009 292,070.36
600050 Autotek Industrial de Mexico USD 30.03.2009 2,525.41
600057 ALPS AUTOMOTIVE, INC. USD 30.03.2009 98,344.58
700000 Faurecia Duroplast Mexico USD 30.03.2009 688,963.06
700001 Siemens VDO S.A. de C.V. USD 30.03.2009 404,551.90
900000 SAS Automotive Systems USD 30.03.2009 304,445.08
900013 PROVEEDOR NP-SAP USD 30.03.2009 -106,179.34
USD 30.03.2009 6,253,142.52
600001 Panasonic INC USD 06.04.2009 157,773.99
600006 Linde Pullmann de Queretaro USD 06.04.2009 89,962.19
600008 Lunkomex SA USD 06.04.2009 87,684.49
600013 Thyssen Krupp Presta de Mexico USD 06.04.2009 260,899.94
600014 Transnav S. A. de C.V. USD 06.04.2009 4,912.68
600016 Valeo Climat Control USD 06.04.2009 785,240.33
600018 Benteler de Mexico USD 06.04.2009 132,825.41
600021 DELPHI ELECTRONICS & SAFETY USD 06.04.2009 559,241.97
600024 Alcoa Fujikura de Mexico USD 06.04.2009 1,799,298.02
600025 FTE Mexicana S.A. de C.V. USD 06.04.2009 189,769.60
600027 Hella KG Hueck Co. USD 06.04.2009 141,286.86
600028 HUF North America Automotive USD 06.04.2009 129,511.58
600037 Manufacturas GCI, S.A. de C.V. USD 06.04.2009 3,869.92
600048 AKSYS de Mexico USD 06.04.2009 24,289.28
600049 Autoliv Steering Weels Mexico USD 06.04.2009 154,794.72
600050 Autotek Industrial de Mexico USD 06.04.2009 2,449.33
600057 ALPS AUTOMOTIVE, INC. USD 06.04.2009 84,866.69
700000 Faurecia Duroplast Mexico USD 06.04.2009 671,485.87
700001 Siemens VDO S.A. de C.V. USD 06.04.2009 385,342.56
900000 SAS Automotive Systems USD 06.04.2009 296,726.90
900013 PROVEEDOR NP-SAP USD 06.04.2009 6,650.28
USD 06.04.2009 5,968,882.61
600001 Panasonic INC USD 13.04.2009 156,674.28
600006 Linde Pullmann de Queretaro USD 13.04.2009 88,783.03
600008 Lunkomex SA USD 13.04.2009 84,460.07
600013 Thyssen Krupp Presta de Mexico USD 13.04.2009 258,352.36
600014 Transnav INC. USD 13.04.2009 4,868.86
600016 Valeo Climat Control USD 13.04.2009 764,633.35
600018 Benteler de Mexico USD 13.04.2009 131,070.01
600021 DELPHI ELECTRONICS & SAFETY USD 13.04.2009 567,837.26
600024 Alcoa Fujikura de Mexico USD 13.04.2009 1,778,791.30
600025 FTE Mexicana S.A. de C.V. USD 13.04.2009 186,634.27
600027 Hella KG Hueck Co. USD 13.04.2009 140,174.60
600028 HUF North America Automotive USD 13.04.2009 127,938.56
600037 Manufacturas GCI, S.A. de C.V. USD 13.04.2009 3,818.76
600048 AKSYS de Mexico USD 13.04.2009 24,004.13
600049 Autoliv Steering Weels Mexico USD 13.04.2009 1,433.84
600050 Autotek Industrial de Mexico USD 13.04.2009 2,416.97
600057 ALPS AUTOMOTIVE, INC. USD 13.04.2009 83,904.07
700000 Faurecia Duroplast Mexico USD 13.04.2009 664,914.33
700001 Siemens VDO S.A. de C.V. USD 13.04.2009 376,106.40
900000 SAS Automotive Systems USD 13.04.2009 293,405.80
900013 PROVEEDOR NP-SAP USD 13.04.2009 6,981.52
USD 13.04.2009 5,747,203.77
600001 Panasonic INC USD 20.04.2009 62,317.80
600006 Linde Pullmann de Queretaro USD 20.04.2009 36,823.67
600008 Lunkomex SA USD 20.04.2009 38,120.35
600013 Thyssen Krupp Presta de Mexico USD 20.04.2009 110,271.14
600014 Transnav S. A. de C.V. USD 20.04.2009 2,083.36
600016 Valeo Climat Control USD 20.04.2009 321,821.79
600018 Benteler de Mexico USD 20.04.2009 55,470.70
600021 DELPHI ELECTRONICS & SAFETY USD 20.04.2009 220,888.32
600024 Alcoa Fujikura de Mexico USD 20.04.2009 727,024.58
600025 FTE Mexicana S.A. de C.V. USD 20.04.2009 79,075.23
600027 Hella KG Hueck Co. USD 20.04.2009 59,622.95
600028 HUF North America Automotive USD 20.04.2009 54,810.02
600037 Manufacturas GCI, S.A. de C.V. USD 20.04.2009 1,616.16
600048 AKSYS de Mexico USD 20.04.2009 10,052.02
600050 Autotek Industrial de Mexico USD 20.04.2009 1,022.89
600057 ALPS AUTOMOTIVE, INC. USD 20.04.2009 39,723.50
700000 Faurecia Duroplast Mexico USD 20.04.2009 283,363.58
700001 Siemens VDO S.A. de C.V. USD 20.04.2009 78,369.56
900000 SAS Automotive Systems USD 20.04.2009 124,795.46
900013 PROVEEDOR NP-SAP USD 20.04.2009 3,388.84
USD 20.04.2009 2,310,661.92
USD 20,283,876.85
USD 20283876.85
VAT TOTAL
22,797.41 174,780.12
13,557.27 103,939.09
12,272.63 94,090.14
40,275.65 308,779.97
758.00 5,811.33
58,108.51 445,498.56
20,542.59 157,493.20
78,279.38 600,141.94
320,663.75 2,458,422.11
29,264.70 224,362.70
21,718.68 166,509.89
19,563.94 149,990.22
598.51 4,588.59
3,828.87 29,354.67
43,810.55 335,880.91
378.81 2,904.22
14,751.69 113,096.27
103,344.46 792,307.52
60,682.79 465,234.69
45,666.76 350,111.84
-15,926.90 -122,106.24
937,972.21 6,861,191.75
23,666.07 181,440.06
13,494.32 103,456.51
13,152.67 100,837.16
39,135.00 300,034.94
736.92 5,649.60
117,786.09 903,026.42
19,923.82 152,749.23
83,886.30 643,128.27
269,895.26 2,069,193.28
28,465.44 218,235.04
21,193.03 162,479.89
19,426.76 148,938.34
580.48 4,450.40
3,643.40 27,932.68
23,219.22 178,013.94
367.40 2,816.73
12,730.00 97,596.69
100,722.96 772208.83
57,801.38 443,143.94
44,509.05 341,235.95
997.54 7,647.82
895,333.11 6,864,215.72
23,501.14 180,175.42
13,317.44 102,100.47
12,669.04 97,129.11
38,752.86 297,105.22
730.35 5,599.21
114,695.03 879,328.38
19,660.49 150,730.50
85,175.60 653,012.86
266,819.39 2,045,610.69
27,995.14 214,629.41
21,026.19 161,200.79
19,190.83 147,129.39
572.84 4,391.60
3,600.62 27,604.75
215.08 1,648.92
362.54 2,779.51
12,585.59 96,489.66
99,737.22 764,651.55
56,415.96 432,522.36
44,010.88 337,416.68
1,047.23 8,028.75
862,081.46 6,609,285.23
9,347.68 71,665.48
5,523.57 42,347.24
5,718.05 43,838.40
16,540.67 126,811.81
312.51 2,395.87
48,273.28 370,095.07
8,320.60 63,791.30
33,133.24 254,021.56
109,054.02 836,078.60
11,861.28 90,936.51
8,943.46 68,566.41
8,221.52 63,031.54
242.42 1,858.58
1,507.80 11,559.82
153.43 1,176.32
5,958.52 45,682.02
42,504.54 325,868.12
11,755.41 90,124.97
18,719.32 143514.78
508.33 3,897.17
346,599.65 2,657,261.57
3,042,584.35 23,326,461.20
3042584.35 23326461.2
Plan payments
Payment estimated date Amount Beneficiary
230,000 usd Flights Alps Kostal 31.03.09 $230,000.00
70,000 usd Flights Novem 20.04.09 $70,000.00
1,053,000 usd Alcoa (PC7) 06.04.09 $1,053,000.00 Supplier
400,000 usd No94 (PC7) 06.04.09 $400,000.00 Supplier
12,000 usd PVS flights 20.04.09 $12,000.00
6,000,000 Alcoa Retroactives To release by 20.04.09 $6,000,000.00 Supplier
$7,765,000.00
94b1bd2b-35ee-450c-a1ea-66c19b469876.xls 16 / 38
CUENTAS PENDIENTES DE PAGO AL 24 DE MARZO
Mon. NOTA Vencimiento Proveedor Total
USD PAGO 31 MZO 06 1/14/2006 AKSYS de Mexico - 984.40
3/4/2006 Hella KG Hueck Co. - 5,099.40
3/5/2006 Hella KG Hueck Co. - 5,340.60
3/12/2006 Hella KG Hueck Co. - 124,721.17
3/18/2006 Hella KG Hueck Co. - 117,400.21
3/21/2006 Benteler de Mexico - 20,219.62
3/24/2006 Benteler de Mexico - 30,329.44
FTE Mexicana S.A. de C.V. - 16,284.35
Lunkomex SA - 21,920.27
Thyssen Krupp Presta - 138,407.36
Total general - 480,706.82
CUENTAS PENDIENTES DE PAGO AL 24 DE MARZO
Mon. NOTA Vencimiento Proveedor
EUR PAGO 31 MZO 06 3/24/2006 A Raymond Loerrach
AB Elektronik Sachsen GmbH
Agrati GmbH
Alcan Automotive
Behr Hella Thermocontrol GmbH
Conti Temic Microelectronic Gm
Eduard Hartmann GmbH Co.KG
Electromecanica Portuguesa Pre
ETM
Fontana GmbH
FTE Automotive GmbH & Co. KG
Gustav Rudolph
Hella Fahrzeugkomponenten GmbH
Hella KG Hueck Co.
Hellerman Tyton, GmbH
Kamax-Werke
KKP Rapid GmbH
Knipping Espanola SA
Kostal
KWD Automotive Group GmbH & Co
Nedschroef Altena GmbH
Northern
Novem Car Interior Design GmbH
Panel Fijaciones S. Coop.
Peiker Acustic Gmbh & Co.
Polytec Thermoplast
Robert Bosch GmbH
Sarnatech Paulmann Cronne GmbH
SAS Autosystemetchnik Gmbh
Scherer & Trier GmbH & Co.
Seeber Systemetechnik
Siemens VDO Automotive
Siemens VDO S.A. de C.V.
Stanztech Treuenbrietzen Blech
STEEB Plastique
TRW Automotive Safety Systems
TRW Fahrzeugelektrik Gmbh & Co
Witte-Velbert GmbH & Co KG
Total general
RZO
Total
- 8,780.90
- 21,775.70
- 13,442.10
- 77,482.78
- 433,597.71
- 223,017.00
- 8,340.00
- 14,246.40
- 5,843.25
- 11,586.85
- 681.64
- 65.87
- 21,085.67
- 173,386.41
- 572.56
- 2,225.48
- 918.00
- 2,712.00
- 77,994.83
- 82,669.95
- 5,355.00
- 2,508.26
- 59,195.37
- 7,953.00
- 5,839.20
- 1,306.26
- 1,484,628.54
- 23,800.62
- 29.23
- 15,783.70
- 1,844.50
- 12,173.12
748.42
- 79,443.17
- 3,609.00
- 966.00
- 13,789.44
- 27,494.16
- 2,925,395.25
Mexico
SAP Code
ICL2004164MX GmbH Automotive Mexico 600,000.00 USD
ICL2004165MX GmbH Automotive Mexico 250,000.00 USD
ICL200514MX GmbH Automotive Mexico 850,000.00 USD
ICL200524MX GmbH Automotive Mexico 500,000.00 USD
ICL200537MX GmbH Automotive Mexico 500,000.00 USD
ICL200542MX GmbH Automotive Mexico 500,000.00 USD
ICL200541MX GmbH Automotive Mexico 500,000.00 USD
ICL200544MX GmbH Automotive Mexico 850,000.00 USD
ICL200548MX GmbH Automotive Mexico 1,200,000.00 USD
ICL200564MX GmbH Automotive Mexico 500,000.00 USD
ICL200565MX GmbH Automotive Mexico 1,850,000.00 USD
ICL200584MX GmbH Automotive Mexico 1,000,000.00 USD
ICL200585MX GmbH Automotive Mexico 1,350,000.00 USD
ICL200586MX GmbH Automotive Mexico 3,500,000.00 USD
ICL200592MX GmbH Automotive Mexico 1,200,000.00 USD
ICL200593MX GmbH Automotive Mexico 3,500,000.00 USD
ICL200599MX GmbH Automotive Mexico 1,000,000.00 USD
ICL2005109MX GmbH Automotive Mexico 7,050,000.00 USD
ICL2005110MX GmbH Automotive Mexico 9,600,000.00 USD
ICL2005111MX GmbH Automotive Mexico 35,395.61 USD
Total 9,635,395.61 USD
12/2/2009 2/25/2009 -280 3.000% -14,000.00 USD
12/2/2009 2/25/2009 -280 3.000% -5,833.33 USD
12/2/2009 2/25/2009 -280 3.000% -19,833.33 USD
12/2/2009 2/25/2009 -280 3.000% -11,666.67 USD
12/2/2009 2/25/2009 -280 3.000% -11,666.67 USD
12/2/2009 2/25/2009 -280 3.250% -12,638.89 USD
12/2/2009 2/25/2009 -280 3.250% -12,638.89 USD
12/2/2009 2/25/2009 -280 3.250% -21,486.11 USD
12/2/2009 2/25/2009 -280 3.250% -30,333.33 USD
12/2/2009 2/25/2009 -280 3.750% -14,583.33 USD
12/2/2009 2/25/2009 -280 3.750% -53,958.33 USD
12/2/2009 2/25/2009 -280 5.000% -38,888.89 USD
12/2/2009 2/25/2009 -280 5.000% -52,500.00 USD
12/2/2009 2/25/2009 -280 5.000% -136,111.11 USD
12/2/2009 2/25/2009 -280 3.750% -35,000.00 USD
12/2/2009 2/25/2009 -280 5.000% -136,111.11 USD
12/2/2009 2/25/2009 -280 5.000% -38,888.89 USD
12/2/2009 2/25/2009 -280 5.000% -274,166.67 USD
12/2/2009 6/30/2006 -1,251 5.000% ###############
12/2/2009 3/30/2006 -1,343 5.000% -6,602.26 USD
Bank Debit Local Banks
Automotive
Date USD Fechas de Pago del Principal
ACREEDORES BANCARIOS 6/30/2009 10/25/2009 12/31/2009 6/30/2009 12/31/2009 6/30/2009
BANCOMER SA DE CV 1,000,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00
BANCOMER SA DE CV 1,000,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00
BANCOMER SA DE CV 700,000.00 140,000.00 140,000.00 140,000.00 140,000.00 140,000.00
BANCOMER SA DE CV 800,000.00 160,000.00 160,000.00 160,000.00 160,000.00 160,000.00
BANCOMER SA DE CV 3,500,000.00 3,500,000.00
700,000.00 3,500,000.00 700,000.00 700,000.00 700,000.00 700,000.00
Other Debits
Automotive Pagados (Alredy Paid)
INTEGRACIÓN DE PRESTAMOS BANCARIOS Estimados (Estimated - to be
Date USD P
ACREEDORES BANCARIOS
30/12/2009 30/06/2010
BANCOMER SA DE CV 1,000,000.00 19,910.72
BANCOMER SA DE CV 800,000.00 32,942.37
BANCOMER SA DE CV 600,000.00
BANCOMER SA DE CV 400,000.00
BANCOMER SA DE CV 200,000.00
BANCOMER SA DE CV -
19,910.72 32,942.37
Date USD P
ACREEDORES BANCARIOS
30/12/2009 30/06/2010
BANCOMER SA DE CV 1,000,000.00 20,313.20
BANCOMER SA DE CV 800,000.00 24,164.20
BANCOMER SA DE CV 600,000.00
BANCOMER SA DE CV 400,000.00
BANCOMER SA DE CV 200,000.00
BANCOMER SA DE CV -
20,313.20 24,164.20
Date USD P
ACREEDORES BANCARIOS
30/12/2009 30/06/2010
BANCOMER SA DE CV 700,000.00 14,850.88
BANCOMER SA DE CV 560,000.00 14,420.76
BANCOMER SA DE CV 420,000.00
BANCOMER SA DE CV 280,000.00
BANCOMER SA DE CV 140,000.00
BANCOMER SA DE CV -
14,850.88 14,420.76
Date USD P
ACREEDORES BANCARIOS
30/12/2009 30/06/2010
BANCOMER SA DE CV 800,000.00 15,646.44
BANCOMER SA DE CV 640,000.00 8,384.00
BANCOMER SA DE CV 480,000.00
BANCOMER SA DE CV 320,000.00
BANCOMER SA DE CV 160,000.00
BANCOMER SA DE CV -
15,646.44 8,384.00
Date USD Payment date
ACREEDORES BANCARIOS
25/04/2009 22/10/2009
BANCOMER SA DE CV 3,500,000.00 70,246.94 74,375.00
BANCOMER SA DE CV -
70,246.94 74,375.00
dos (Alredy Paid)
ados (Estimated - to be paid)
Payment date
30/12/2010 30/06/2011 30/12/2011 30/06/2012
17,000.00
12,750.00
8,500.00
4,250.00
17,000.00 12,750.00 8,500.00 4,250.00
Payment date
30/12/2010 30/06/2011 30/12/2011 30/06/2012
17,000.00
12,750.00
8,500.00
4,250.00
17,000.00 12,750.00 8,500.00 4,250.00
Payment date
30/12/2010 30/06/2011 30/12/2011 30/06/2012
11,900.00
8,925.00
5,950.00
2,975.00
11,900.00 8,925.00 5,950.00 2,975.00
Payment date
30/12/2010 30/06/2011 30/12/2011 30/06/2012
13,600.00
10,200.00
6,800.00
3,400.00
13,600.00 10,200.00 6,800.00 3,400.00
95,353.09
86,977.40
59,021.64
58,030.44
144,621.94
444,004.51
5,536.33
x rates
Used exchange rates at the 11.05.2010
EUR 13.1144
USD 10.8914
JPY 0.0927
Balance Marzo 2010 Balance Marzo 2010
Bancomer 88964 USD 726,856.94
Bancomer 8891 MXN - INVERSION 40,341,376.68
Bancomer 4062 MXN 189,656.05
Bankof America EUR 76,891.13
Bankof America USD 279,449.41
Non register payments
230,000.00
Budgetbook Ver. 1
Automotive Mexico
Plan XI 2010 Plan XI 05: PLAN VII 05 for 2006: Costs Assy / veh (Plan XI 05) Costs Assy / veh (Plan VII 05)
Rem. projecttime (in years) 5.00 credit 2.0% EUR 14.00 k MXP: 5,885 k MXP: 18,150 Vol: 232,000.0 Vol: 264,000.0
Income tax (local) 35.0% debit 3.0% USD 11.00 k EUR: 420 k EUR: 1,210 k MXP: -101,833.8 k MXP: -107,554.4
MXP/veh: -438.94 MXP/veh: -407.4
USD/veh: -39.90 USD/veh: -37.0
B/F PLAN XI 05 PLAN VII 05
Line no. 2005 Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 2006 2006
Price/part for assembly/JIS
1 A5 Jetta 293.26 293.26 293.26 293.26 293.26 293.26 293.26 293.26 293.26 293.26 293.26 293.26 293.26 326.0
2 A5 Bora
3 c
4 d
5 e
Consumption / part industr. costs -26.4
6 A5 Jetta
7 A5 Bora
8 c
9 d
10 e
Price/part for prelogistics
11 A5 Jetta 408.98 408.98 408.98 408.98 408.98 408.98 408.98 408.98 408.98 408.98 408.98 408.98 408.98 338.3
12 A5 Bora
13 c
14 d
15 e
Consumption / part prelogistic -237.94 -237.94 -237.94 -237.94 -237.94 -237.94 -237.94 -237.94 -237.94 -237.94 -237.94 -237.94 -237.94 -188.1
16 A5 Jetta
17 A5 Bora
18 c
19 d
20 e
Price / part for material
21 A5 Jetta 18,005.02 18,005.02 18,005.02 18,005.02 18,005.02 18,005.02 18,005.02 18,005.02 18,005.02 18,005.02 18,005.02 18,005.02 18,005.02 19,953.6
22 A5 Bora
23 c
24 d
25 e
Consumption / part for material -18,005.02 -18,005.02 -18,005.02 -18,005.02 -18,005.02 -18,005.02 -18,005.02 -18,005.02 -18,005.02 -18,005.02 -18,005.02 -18,005.02 -18,005.02 -19,953.6
26 A5 Jetta
27 A5 Bora
28 c
29 d
30 e
Price/part for Systems integration
31 A5 Jetta
32 A5 Bora
33 c
34 d
35 Faurecia Development
Consumption SI (Material)
36 A5 Jetta
37 A5 Bora
38 c
39 d
40 e
Consumption Systems integration
41 A5 Jetta
42 A5 Bora
43 c
44 d
45 e
Cars per day
46 A5 Jetta
47 A5 Bora
48 c
49 d
50 e
51 Sum cars per day
Budgetbook Ver. 1
Automotive Mexico
Plan XI 2010 Plan XI 05: PLAN VII 05 for 2006: Costs Assy / veh (Plan XI 05) Costs Assy / veh (Plan VII 05)
Rem. projecttime (in years) 5.00 credit 2.0% EUR 14.00 k MXP: 5,885 k MXP: 18,150 Vol: 232,000.0 Vol: 264,000.0
Income tax (local) 35.0% debit 3.0% USD 11.00 k EUR: 420 k EUR: 1,210 k MXP: -101,833.8 k MXP: -107,554.4
MXP/veh: -438.94 MXP/veh: -407.4
USD/veh: -39.90 USD/veh: -37.0
B/F PLAN XI 05 PLAN VII 05
Line no. 2005 Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 2006 2006
52 Working days 253.00 22.0 21.0 23.0 20.0 22.0 22.0 21.0 23.0 19.0 22.0 22.0 16.0 253.0 250.0
53 Number of cars 192,033.00 20,174 19,257 21,091 18,340 20,174 20,174 19,257 21,091 17,423 20,174 20,174 14,672 232,000.0 264,000.0
232,000
54 A5 Jetta 5,916.2 5,647.3 6,185.1 5,378.4 5,916.2 5,916.2 5,647.3 6,185.1 5,109.4 5,916.2 5,916.2 4,302.7 68,036.3 60,954.8
55 A5 Bora 25,099.0
56 c
57 d
58 e
59 Sales assembly/JIS 57,763.58 5,916.2 5,647.3 6,185.1 5,378.4 5,916.2 5,916.2 5,647.3 6,185.1 5,109.4 5,916.2 5,916.2 4,302.7 68,036.3 86,053.8
60 Consumpt. Industr. costs -2,655.61 -300.0 -300.0 -300.0 -300.0 -300.0 -300.0 -300.0 -300.0 -300.0 -300.0 -300.0 -300.0 -3,600.0 -4,462.0
61 Consumpt. JIS / ass. other -3,045.05 -168.3 -168.3 -168.3 -168.3 -168.3 -168.3 -168.3 -168.3 -168.3 -168.3 -168.3 -168.3 -2,020.0 -2,508.0
62 Gross Margin assembly/JIS 52,062.9 5,447.9 5,179.0 5,716.8 4,910.0 5,447.9 5,447.9 5,179.0 5,716.8 4,641.1 5,447.9 5,447.9 3,834.4 62,416.3 79,084.1
63 Direct labour assembly/JIS -9,113.39 -859.5 -859.5 -859.5 -859.5 -897.0 -897.0 -897.0 -897.0 -897.0 -897.0 -897.0 -897.0 -10,614.3 -9,659.1
64 Indirect labour assembly/JIS -8,060.07 -763.3 -763.3 -763.3 -763.3 -797.2 -797.2 -797.2 -797.2 -797.2 -797.2 -797.2 -797.2 -9,430.5 -7,302.5
65 Direct Energy assembly/JIS -1,009.88 -86.4 -86.4 -86.4 -86.4 -86.4 -86.4 -86.4 -86.4 -86.4 -86.4 -86.4 -86.4 -1,036.4 -1,250.0
66 Direct Depreciation assembly/JIS -7,828.84 -815.1 -815.1 -815.1 -815.1 -815.1 -815.1 -815.1 -815.1 -815.1 -815.1 -815.1 -815.1 -9,781.6 -8,737.1
67 Contribution before fixed costs 26,050.7 2,923.6 2,654.6 3,192.5 2,385.7 2,852.2 2,852.2 2,583.3 3,121.1 2,045.4 2,852.2 2,852.2 1,238.7 31,553.6 52,135.4
68 A5 Jetta 8,250.7 7,875.7 8,625.8 7,500.7 8,250.7 8,250.7 7,875.7 8,625.8 7,125.6 8,250.7 8,250.7 6,000.5 94,883.4 63,260.2
69 A5 Bora 26,048.3
70 c
71 d
72 e
73 Sales prelogistics 68,204.52 8,250.7 7,875.7 8,625.8 7,500.7 8,250.7 8,250.7 7,875.7 8,625.8 7,125.6 8,250.7 8,250.7 6,000.5 94,883.4 89,308.5
74 Consumption prelogistics -57,059.59 -4,800.1 -4,581.9 -5,018.3 -4,363.7 -4,800.1 -4,800.1 -4,581.9 -5,018.3 -4,145.5 -4,800.1 -4,800.1 -3,491.0 -55,201.2 -49,658.4
75 Gross Margin prelogistics 11,144.9 3,450.6 3,293.8 3,607.5 3,136.9 3,450.6 3,450.6 3,293.8 3,607.5 2,980.1 3,450.6 3,450.6 2,509.5 39,682.2 39,650.1
76 Direct labour prelogistic
77 Indirect labour prelogistics
78 Direct Energy prelogistics
79 Direct Depreciation prelogistics
80 Contribution before fixed costs 11,144.9 3,450.6 3,293.8 3,607.5 3,136.9 3,450.6 3,450.6 3,293.8 3,607.5 2,980.1 3,450.6 3,450.6 2,509.5 39,682.2 39,650.1
81 A5 Jetta 363,231.7 346,721.2 379,742.2 330,210.6 363,231.7 363,231.7 346,721.2 379,742.2 313,700.1 363,231.7 363,231.7 264,168.5 4,177,164.6 3,731,329.8
82 A5 Bora 1,536,429.9
83 c
84 d
85 e
86 Sales material 3,332,309.97 363,231.7 346,721.2 379,742.2 330,210.6 363,231.7 363,231.7 346,721.2 379,742.2 313,700.1 363,231.7 363,231.7 264,168.5 4,177,164.6 5,267,759.7
87 Material consumption -3,337,405.92 -363,231.7 -346,721.2 -379,742.2 -330,210.6 -363,231.7 -363,231.7 -346,721.2 -379,742.2 -313,700.1 -363,231.7 -363,231.7 -264,168.5 -4,177,164.6 -5,267,759.7
88 Loss of material (scrap) -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -960.0 -5,267.8
89 Consumption material -3,337,405.9 -363,311.7 -346,801.2 -379,822.2 -330,290.6 -363,311.7 -363,311.7 -346,801.2 -379,822.2 -313,780.1 -363,311.7 -363,311.7 -264,248.5 -4,178,124.6 -5,273,027.5
90 Gross margin material -5,096.0 -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -960.0 -5,267.8
91 Contribution before fixed costs -5,096.0 -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -80.0 -960.0 -5,267.8
92 A5 Jetta
93 A5 Bora
94 c
95 d
96
97 Sales systems integration
98 Material Cons. (Pre-Series/Prototype)
99 Consumption systems integration
100 Gross Margin systems integration
101 Direct/Indirect labour (pre-series/prototype)
102 Direct Energy systems integration
103 Direct Depreciation systems integration
104 Contribution before fixed costs
105 Sales others 32,876.35
106 Consumption others -17,134.15
107 Gross Margin others 15,742.2
108 Direct labour Others
109 Indirect labour others
109 Direct Energy others
110 Direct Depreciation others
111 Contribution before fixed costs 15,742.2
112 Sales inside Co.-group
113 Consumption inside Co.-group
114 Gross Margin inside Co.-group
Budgetbook Ver. 1
Automotive Mexico
Plan XI 2010 Plan XI 05: PLAN VII 05 for 2006: Costs Assy / veh (Plan XI 05) Costs Assy / veh (Plan VII 05)
Rem. projecttime (in years) 5.00 credit 2.0% EUR 14.00 k MXP: 5,885 k MXP: 18,150 Vol: 232,000.0 Vol: 264,000.0
Income tax (local) 35.0% debit 3.0% USD 11.00 k EUR: 420 k EUR: 1,210 k MXP: -101,833.8 k MXP: -107,554.4
MXP/veh: -438.94 MXP/veh: -407.4
USD/veh: -39.90 USD/veh: -37.0
B/F PLAN XI 05 PLAN VII 05
Line no. 2005 Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 2006 2006
115 Total sales 3,491,154.42 377,398.6 360,244.2 394,553.1 343,089.7 377,398.6 377,398.6 360,244.2 394,553.1 325,935.2 377,398.6 377,398.6 274,471.7 4,340,084.3 5,443,122.1
116 Total consumption -3,419,344.92 -368,580.1 -351,851.4 -385,308.9 -335,122.7 -368,580.1 -368,580.1 -351,851.4 -385,308.9 -318,394.0 -368,580.1 -368,580.1 -268,207.8 -4,238,945.8 -5,329,655.6
117 Thereof material consumption -3,337,405.92 -363,231.7 -346,721.2 -379,742.2 -330,210.6 -363,231.7 -363,231.7 -346,721.2 -379,742.2 -313,700.1 -363,231.7 -363,231.7 -264,168.5 -4,177,164.6 -5,267,759.7
118 Total Gross Margin 71,809.5 8,818.5 8,392.7 9,244.3 7,967.0 8,818.5 8,818.5 8,392.7 9,244.3 7,541.2 8,818.5 8,818.5 6,263.9 101,138.5 113,466.5
119 Total Direct labour -9,113.39 -859.5 -859.5 -859.5 -859.5 -897.0 -897.0 -897.0 -897.0 -897.0 -897.0 -897.0 -897.0 -10,614.3 -9,659.1
120 Total Indirect labour -8,060.07 -763.3 -763.3 -763.3 -763.3 -797.2 -797.2 -797.2 -797.2 -797.2 -797.2 -797.2 -797.2 -9,430.5 -7,302.5
121 Total Direct Energy -1,009.88 -86.4 -86.4 -86.4 -86.4 -86.4 -86.4 -86.4 -86.4 -86.4 -86.4 -86.4 -86.4 -1,036.4 -1,250.0
122 Total Direct Depreciation -7,828.84 -815.1 -815.1 -815.1 -815.1 -815.1 -815.1 -815.1 -815.1 -815.13 -815.1 -815.1 -815.1 -9,781.6 -8,737.1
123 Total Contribution before fixed costs 45,797.3 6,294.2 5,868.4 6,720.0 5,442.7 6,222.8 6,222.8 5,797.0 6,648.6 4,945.5 6,222.8 6,222.8 3,668.2 70,275.7 86,517.7
124 added value 73,287.9 8,818.5 8,392.7 9,244.3 7,967.0 8,818.5 8,818.5 8,392.7 9,244.3 7,541.2 8,818.5 8,818.5 6,263.9 101,138.5 113,466.5
125 Salary-costs -22,510.59 -1,969.9 -2,212.6 -1,876.1 -1,876.1 -1,954.1 -1,954.1 -1,954.1 -2,290.6 -1,954.1 -1,954.1 -1,954.1 -1,954.1 -23,904.4 -27,070.0
126 Leased personnel resources -923.67 -155.9 -155.9 -155.9 -155.9 -155.9 -155.9 -155.9 -155.9 -155.9 -155.9 -155.9 -155.9 -1,870.2
127 Indirect Depreciation Goodwill
128 Other personnel costs -5,413.76 -290.7 -290.7 -710.3 -330.7 -305.7 -305.7 -310.7 -305.7 -290.7 -295.7 -300.7 -535.7 -4,273.2 -4,840.0
129 Maintenance -2,440.10 -269.4 -214.4 -234.3 -253.9 -214.4 -214.4 -257.4 -214.4 -214.4 -253.9 -217.8 -214.4 -2,773.1 -1,320.0
130 Rent -6,892.79 -595.4 -595.4 -595.4 -595.4 -595.4 -595.4 -595.4 -595.4 -595.4 -595.4 -595.4 -595.4 -7,144.5 -7,380.0
131 Leasing -4,162.42 -306.1 -396.1 -306.1 -306.1 -306.1 -306.1 -306.1 -306.1 -306.1 -306.1 -306.1 -306.1 -3,762.8 -4,200.0
132 Telephone-/Communicationcosts -2,822.56 -121.7 -121.7 -121.7 -123.7 -121.7 -121.7 -121.7 -121.7 -121.7 -121.7 -121.7 -121.7 -1,462.7 -2,160.0
133 Travelling expenses -1,859.24 -89.8 -89.8 -89.8 -89.8 -89.8 -89.8 -89.8 -89.8 -89.8 -89.8 -89.8 -89.8 -1,078.0 -1,254.0
134 External audit fees -406.57 -40.8 -40.8 -40.8 -40.8 -40.8 -40.8 -40.8 -40.8 -40.8 -40.8 -40.8 -40.8 -490.0 -500.0
135 External consulting fees -1,120.49 -89.5 -85.5 -85.5 -85.5 -85.5 -155.5 -89.5 -85.5 -85.5 -85.5 -120.5 -85.5 -1,139.3 -2,040.0
136 External services -4,131.32 -305.2 -245.6 -278.6 -272.2 -278.6 -245.6 -305.2 -245.6 -278.6 -272.2 -278.6 -245.6 -3,251.4 -3,960.0
137 Other operationel income
138 Other operationel costs -4,646.03 -325.5 -173.0 -173.0 -173.0 -173.0 -173.0 -173.0 -322.3 -173.0 -173.0 -173.0 -173.0 -2,377.9 -3,000.0
139 Taxes / toll -860.13 -15.0 -15.0 -15.0 -15.0 -15.0 -15.0 -15.0 -15.0 -15.0 -15.0 -15.0 -15.0 -180.0 -100.0
140 Insurance expenses -5,257.75 -40.0 -21.6 -148.3 -100.0 -79.7 -389.6 -995.0
Interest expenses -424.3 -338.4 -335.6 -332.5 -332.5 -332.5 -328.6 -324.7 -322.0 -318.9 -296.2 -118.0 -3,804.4 -4,659.5
141 Interest earnings 227.62 2,063.9
142 Exchange differences -2,500.00
143 Sub-Total I Fixed-Costs before Distrib. -65,719.8 -5,039.3 -4,974.9 -5,018.2 -4,650.7 -4,690.2 -4,853.8 -4,843.3 -5,113.5 -4,643.0 -4,678.1 -4,745.3 -4,651.0 -57,901.3 -61,414.6
144 Distributed income inside Co.-group 119.96 3,641.0 3,886.2 3,970.1 3,546.3 3,697.2 3,697.2 3,697.2 4,037.0 3,697.2 3,697.2 3,697.2 3,697.2 44,960.9
145 Distributed costs inside Co.-group -4,535.86 -3,761.9 -4,007.0 -4,090.9 -3,667.1 -3,818.0 -3,818.0 -3,818.0 -4,157.9 -3,818.0 -3,818.0 -3,818.0 -3,818.0 -46,410.7 -1,553.3
146 Distrib. SI income inside Co.-group
147 Distributed SI costs inside Co.-group
148 Reallocated income inside legal entity
149 Reallocated costs inside legal entity
150 Sub-Total II Fixed-Costs after Distrib. -70,135.7 -5,160.2 -5,095.7 -5,139.0 -4,771.5 -4,811.0 -4,974.6 -4,964.1 -5,234.4 -4,763.8 -4,798.9 -4,866.1 -4,771.8 -59,351.1 -62,967.9
151 Increase of SI-Inventory
152 Increase of Start-up-Inventory 1,478.4
153 Management Result -22,859.9 1,134.0 772.7 1,580.9 671.1 1,411.8 1,248.2 833.0 1,414.2 181.7 1,423.9 1,356.6 -1,103.6 10,924.7 23,549.8
154 Variation exchange-rate-differences-provision
155 Exceptional depreciation
156 Exceptional costs -2,106.1
157 Exceptional income
158 Subventions
159 Gestion expenses -3,973.3 -420.0 -420.0 -420.0 -420.0 -420.0 -420.0 -420.0 -420.0 -420.0 -420.0 -420.0 -420.0 -5,040.0 -5,400.0
160 Distributed expenses for indust-costs inside Co. -3,742.9
161 Increase of ind-costs-stocks non operativ 422.3
162 Reallocated exp. / inc. of HQ
163 Net accounting Result before tax -32,259.9 714.0 352.7 1,160.9 251.1 991.8 828.2 413.0 994.2 -238.3 1,003.9 936.6 -1,523.6 5,884.7 18,149.8
164 tax on income
165 theoretical net acc. Result after tax -32,259.9 714.0 352.7 1,160.9 251.1 991.8 828.2 413.0 994.2 -238.3 1,003.9 936.6 -1,523.6 5,884.7 18,149.8
166 EBIT -26,774.5 754.0 352.7 1,160.9 251.1 1,013.5 976.5 513.0 994.2 -238.3 1,003.9 1,016.3 -1,523.6 6,274.2 20,745.5
167 EBITDA -18,022.0 1,725.0 1,323.7 2,131.9 1,222.1 1,984.4 1,947.4 1,483.9 1,965.2 732.7 1,974.9 1,987.3 -552.6 17,926.0 29,482.6
Budgetbook Ver. 1
Automotive Mexico
Plan XI 2010 Plan XI 05: PLAN VII 05 for 2006: Costs Assy / veh (Plan XI 05) Costs Assy / veh (Plan VII 05)
Rem. projecttime (in years) 5.00 credit 2.0% EUR 14.00 k MXP: 5,885 k MXP: 18,150 Vol: 232,000.0 Vol: 264,000.0
Income tax (local) 35.0% debit 3.0% USD 11.00 k EUR: 420 k EUR: 1,210 k MXP: -101,833.8 k MXP: -107,554.4
MXP/veh: -438.94 MXP/veh: -407.4
USD/veh: -39.90 USD/veh: -37.0
B/F PLAN XI 05 PLAN VII 05
Line no. 2005 Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 2006 2006
Investments
168 New investments Assembly/JIS 15,311.9 1,246.3 1,246.3 4,000.0
169 Low value investments Assembly/JIS 125.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0 600.0
170 New investments Prelogistic
171 Low value investments Prelogistic
172 New investments SI
173 Low value investments SI
174 New investments Other
175 Low value investments Other
176 New investments Headquarter
177 Low value investments Headquarter
178 Total investments 15,436.9 1,296.3 50.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0 50.0 1,846.3
Inventories
179 Inventories of raw material 79,479.30 82,552.7 82,552.7 82,552.7 82,552.7 82,552.7 82,552.7 82,552.7 82,552.7 82,552.7 82,552.7 82,552.7 82,552.7 84,284.2
180 Stock range in days 3.00 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0
181 Inventories of capitalized SI-Costs
182 Inventories of capitalized start up-costs 24,903.11 24,603.1 24,303.1 24,003.1 23,703.1 23,403.1 23,103.1 22,803.1 22,503.1 22,203.1 21,903.1 21,603.1 21,303.1 19,534.9
183 Total inventories of capitalized order-costs 104,387.41 107,155.8 106,855.8 106,555.8 106,255.8 105,955.8 105,655.8 105,355.8 105,055.8 104,755.8 104,455.8 104,155.8 103,855.8 210,643.2
Headcount by function
184 Gross direct worker assembly/JIS 170.0
185 Gross direct worker Prelogistic
186 Gross direct worker Other
187 Full yearly costs per direct employee
188 Gross indirect worker assembly/JIS 82.0
189 Gross indirect worker prelogistics
190 Gross indirect worker others
191 Full yearl costs per indirect employee
192 Structure staff (Fixed Costs) 34.0
193 Structure staff (SI)
194 Full yearly costs per salary earner
195 Manager 1.0
196 Full yearly costs per manager
197 Non active staff
198 staff on loan
199 Sum employees by function
Employees by contract
200 Permanent contract 312.00
201 Fixed term contract
202 Temporary contract
203 Sum employees by contract 312.00
217 Receivables 413,173.84 437,782.4 417,883.2 457,681.6 397,984.0 437,782.4 437,782.4 417,883.2 457,681.6 378,084.8 437,782.4 437,782.4 318,387.2 318,387.2 782,448.8
Factoring
218 Payables 473,623.87 522,644.7 495,255.7 545,685.2 475,747.1 522,587.2 522,215.2 499,004.1 545,897.3 452,032.6 522,686.6 522,361.1 382,068.8 382,068.8 784,896.2
Cash
219 Cash Flow before interest single month 8,388.12 4,158 3,671 4,477 3,564 4,398 4,361 3,893 4,370 3,135 4,374 4,364 1,646 1,646 33,932.3
220 Cashbalance before interest -6,142.41 43,230 -3,869 15,058 -6,727 11,389 3,939 531 11,415 -11,183 15,281 3,989 -19,301 -19,301 6,751.4
221 Cash account before interest
222 Cash account after interest and tax -59,874.27 -76,558 -80,427 -65,369 -72,096 -60,728 -56,938 -56,506 -45,091 -56,274 -40,993 -37,084 -56,385 -56,385 49,575.3
,427 -65,369 -72,096 -60,728 -56,938 -56,506 -45,091 -56,274 -40,993 -37,084 -56,385 -56,385 49,575.3
Budgetbook Ver. 1
Automotive Mexico
Plan XI 2010 Plan XI 05: PLAN VII 05 for 2006: Costs Assy / veh (Plan XI 05) Costs Assy / veh (Plan VII 05)
Rem. projecttime (in years) 5.00 credit 2.0% EUR 14.00 k MXP: 5,885 k MXP: 18,150 Vol: 232,000.0 Vol: 264,000.0
Income tax (local) 35.0% debit 3.0% USD 11.00 k EUR: 420 k EUR: 1,210 k MXP: -101,833.8 k MXP: -107,554.4
MXP/veh: -438.94 MXP/veh: -407.4
USD/veh: -39.90 USD/veh: -37.0
B/F PLAN XI 05 PLAN VII 05
Line no. 2005 Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 2006 2006
Balance sheet
ASSETS
Intangeable and tangeable assets
223 Goodwill (gross)
224 Depriciation on Goodwill
47,229 47,710 46,945 46,180 45,415 44,650 43,884 43,119 42,354 41,589 40,824 40,059 39,294 39,294
225 Gross 56,083.37 57,380 57,430 57,480 57,530 57,580 57,630 57,680 57,730 57,780 57,830 57,880 57,930 57,930
226 Depreciation -8,854.40 -9,670 -10,485 -11,300 -12,115 -12,930 -13,745 -14,560 -15,375 -16,191 -17,006 -17,821 -18,636 -18,636
47,229 47,710 46,945 46,180 45,415 44,650 43,884 43,119 42,354 41,589 40,824 40,059 39,294 39,294
Financial assets
227 Shares in group companies 50 50 50 50 50 50 50 50 50 50 50 50 50
228 Shares in associated companies
50 50 50 50 50 50 50 50 50 50 50 50 50
Current assets
Inventory
229 Material on stock (net) 79,479.30 82,553 82,553 82,553 82,553 82,553 82,553 82,553 82,553 82,553 82,553 82,553 82,553 82,553
230 SI inventories (net)
231 Start-up inventories (net) 24,903.11 24,603 24,303 24,003 23,703 23,403 23,103 22,803 22,503 22,203 21,903 21,603 21,303 21,303
104,382 107,156 106,856 106,556 106,256 105,956 105,656 105,356 105,056 104,756 104,456 104,156 103,856 103,856
Receivables and other assets
Receivables third party 413,174 437,782 417,883 457,682 397,984 437,782 437,782 417,883 457,682 378,085 437,782 437,782 318,387 318,387
232 Gross 413,173.84 437,782 417,883 457,682 397,984 437,782 437,782 417,883 457,682 378,085 437,782 437,782 318,387 318,387
233 Fatoring Selling of AR
234 Receivables inside Co.-group 6,870.28 6,686 7,138 7,266 6,384 6,649 6,612 6,576 7,215 6,499 6,462 6,426 6,389
235 Other assets 91,496.00 96,132 90,090 102,977 94,083 103,211 97,063 95,259 104,443 91,032 104,087 105,794 76,768 76,768
511,540 540,600 515,111 567,925 498,450 547,643 541,457 519,718 569,340 475,616 548,332 550,002 401,545 395,155
236 Cash and cash equivalents
663,202 695,516 668,962 720,711 650,171 698,298 691,048 668,243 716,800 622,011 693,662 694,267 544,744 538,305
LIABILITIES
Equity
237 Share capital 100.00 100 100 100 100 100 100 100 100 100 100 100 100 100
238 Additional paid in capital 7,559.56 7,560 7,560 7,560 7,560 7,560 7,560 7,560 7,560 7,560 7,560 7,560 7,560 7,560
Retained earnings/reserve
239 Legal reserve (out of net result)
240 Balance brought forward -32,104.25 -64,733 -64,733 -64,733 -64,733 -64,733 -64,733 -64,733 -64,733 -64,733 -64,733 -64,733 -64,733 -64,733
241 Net result of the year -32,628.59 714 1,067 2,228 2,479 3,471 4,299 4,712 5,706 5,468 6,472 7,408 5,885 5,885
-57,073 -56,359 -56,007 -54,846 -54,594 -53,603 -52,774 -52,361 -51,367 -51,606 -50,602 -49,665 -51,189 -51,189
Provisions
242 Provision for project risk
243 Provision for warranty risk
244 Other provision 30 60 90 120 150 180 210 240 270 300 330 360
30 60 90 120 150 180 210 240 270 300 330 360
Other Liabilities
245 Loan from banks/financial institutions 25,227.90 23,100 23,100 23,100 23,100 23,100 15,400 15,400 15,400 15,400 15,400 15,400 7,700 7,700
246 Loan from Co. 112,097.78 111,988 112,194 112,239 111,780 111,894 111,858 111,821 112,121 111,745 111,708 111,671 111,635 56,385
247 Payables third party due to deliveries and services 488,761.88 522,645 495,256 545,685 475,747 522,587 522,215 499,004 545,897 452,033 522,687 522,361 382,069 382,069
248 Payables inside Co.-group 3,715.11 3,641 3,886 3,970 3,546 3,697 3,697 3,697 4,037 3,697 3,697 3,697 3,697 3,697
249 Other liabilities 90,000.00 90,000 90,000 90,000 90,000 90,000 90,000 90,000 90,000 90,000 90,000 90,000 90,000
719,803 751,373 724,436 774,994 704,173 751,279 743,170 719,922 767,455 672,874 743,492 743,130 595,101 449,851
662,729 695,044 668,490 720,239 649,699 697,826 690,576 667,771 716,328 621,539 693,190 693,795 544,272 398,663