Spreadsheet: 103051d1300896145-copy-but-cant-paste-xl-2003-copy-of-939-2011-03-latin-america-test
Sheet: Trial Balance

Infinium Company Number | 939 |  | RUI | 9139
Infinium Company Name
For the Period Ending | 2011-02-28 00:00:00
 |  |  | January | February | February
ACCOUNT | DESCRIPTIONS |  | YTD | CURRENT MONTH | YTD
 |  |  | BALANCE | ACTIVITY | BALANCE
 |  |  | --------------- | --------------- | ---------------
939-780-82-000-000-11000-000001 | CASH | A | 15076446.69 | -641380.02 | 14435066.67 | A | 9391100082000001
939-780-01-000-000-13110-000001 | ACCOUNTS RECEIVABLE | A | 14086398.96999994 | -1158281.62 | 12928117.34999994 | A | 9391311001000001
939-780-01-000-000-13590-000001 | MISC EMPLOYEE RECEIVABLES | A | -36600.07000000007 | 35.89 | -36564.18000000007 | A | 9391359001000001
939-780-56-000-000-13590-000001 | MISC EMPLOYEE RECEIVABLES | A | -4990.920000000006 | 4.89 | -4986.030000000005 | A | 9391359056000001
939-780-01-000-000-13710-000001 | MISC ACCOUNTS RECEIVABLE | A | -2539372.44 | 780010.65 | -1759361.79 | A | 9391371001000001
939-000-01-000-000-13710-000001 | MISC ACCOUNTS RECEIVABLE | A | -346278.06 | 106365.08 | -239912.98 | A | 9391371001000001
939-780-01-000-000-13810-000001 | SEL DOUBTFUL ACCOUNTS - CUSTS | A | -4528656.9 | 0 | -4528656.9 | A | 9391381001000001
939-780-82-000-000-13940-001211 | BAROID EXPORT | A | -187366.35 | 2139.25 | -185227.1 | A | 9391394082001211
939-780-82-000-000-13940-002237 | [NAME] | A | -2.076849341808851e-09 | 0 | -2.076849341808851e-09 | A | 9391394082002237
939-780-82-000-000-13940-004022 | BAROID OF NIGERIA | A | 0 | 0 | 0 | A | 9391394082004022
939-780-82-000-000-13940-004047 | BAROID LTD (INTL DIV) | A | 0 | 0 | 0 | A | 9391394082004047
939-780-01-000-000-14100-000001 | RAW MATERIAL | A | 86906.71 | -37585.5 | 49321.21000000001 | A | 9391410001000001
939-780-01-000-000-14300-000001 | FINISHED GOODS | A | 52437102.24999998 | -3732640.83 | 48704461.41999998 | A | 9391430001000001
939-780-56-000-000-14300-000001 | FINISHED GOODS | A | 7150513.939999999 | -508996.47 | 6641517.47 | A | 9391430056000001
939-780-01-000-000-15300-000001 | PREPAID INSURANCE | A | -217975.13 | -109357.01 | -327332.14 | A | 9391530001000001
939-780-56-000-000-15300-000001 | PREPAID INSURANCE | A | -29723.88 | -14912.32 | -44636.2 | A | 9391530056000001
939-780-01-000-000-15900-000001 | MISC PREPAID EXPENSES | A | 3839519.53 | 499731.59 | 4339251.12 | A | 9391590001000001 |  |  |  | 59674522.89999998 | Inventory
939-780-56-000-000-15900-000001 | MISC PREPAID EXPENSES | A | 523570.84 | 68145.22 | 591716.06 | A | 9391590056000001 |  |  |  | -4471471.75 | Sold
939-780-01-000-000-17000-000001 | PROPERTY, PLANT AND EQUIPMENT | A | 46268513.14999998 | 11800 | 46280313.14999998 | A | 9391700001000001 |  |  |  | 192248.950000003 | Purchases
939-780-56-000-000-17000-000001 | PROPERTY, PLANT AND EQUIPMENT | A | 824157.52 | 0 | 824157.52 | A | 9391700056000001 |  |  |  | 55395300.09999998
939-780-01-000-000-18000-000001 | DEPREC AND DEPLETION RESERVE | A | -40601768.05000003 | -98726.14 | -40700494.19000003 | A | 9391800001000001
939-780-56-000-000-18000-000001 | DEPREC. AND DEPLETION RESERVE | A | -512493 | 0 | -512493 | A | 9391800056000001
939-780-01-000-000-22100-000001 | TRADE PAYABLES-ACCRUED | L | -8093709.01 | 5844585.75 | -2249123.26 | L | 9392210001000001
939-780-56-000-000-22100-000001 | TRADE PAYABLES-ACCRUED | L | -1103687.59 | 796988.98 | -306698.6100000001 | L | 9392210056000001 |  |  |  | 5334645.26 | [NAME]
939-780-01-000-000-22610-000001 | PAYROLL TAXES WITHHELD | L | -305590.88 | 11809.25 | -293781.63 | L | 9392261001000001 |  |  |  | 4471471.75 | Sales
939-780-56-000-000-22610-000001 | PAYROLL TAXES WITHHELD | L | -41671.48 | 1610.35 | -40061.13 | L | 9392261056000001 |  |  |  | 0 | Buyback
939-780-01-000-000-22690-000001 | OTHER PAYROLL DEDUCTIONS | L | -98943.35 | 34280.94 | -64662.41 | L | 9392269001000001 |  |  |  | 9806117.01
939-780-56-000-000-22690-000001 | OTHER PAYROLL DEDUCTIONS | L | -13492.28 | 4674.68 | -8817.6 | L | 9392269056000001
939-780-01-000-000-22710-000001 | SALES, ADDED VALUE & USE TAXES | L | -1305411.47 | -854178.81 | -2159590.28 | L | 9392271001000001
939-780-56-000-000-22710-000001 | SALES, ADDED VALUE & USE TAXES | L | -178010.65 | -116478.93 | -294489.58 | L | 9392271056000001
939-780-82-000-000-22950-009142 | BAROID CARIBBEAN | L | -16965542.83000008 | -590307.86 | -17555850.69000008 | L | 9392295082009142
939-780-01-000-000-23110-000001 | SALARIES AND WAGES | L | 13352.20000000019 | 0 | 13352.20000000019 | L | 9392311001000001
939-780-56-000-000-23110-000001 | SALARIES AND WAGES | L | 1820.75 | 0 | 1820.75 | L | 9392311056000001
939-780-01-000-000-23150-000001 | OTHER EMPLOYEE BENEFITS | L | -1936619.37 | -13859.89 | -1950479.26 | L | 9392315001000001
939-780-56-000-000-23150-000001 | OTHER EMPLOYEE BENEFITS | L | -264084.46 | -1889.98 | -265974.44 | L | 9392315056000001
939-780-01-000-000-23190-000001 | MISC PAYROLL ACCRUALS | L | 296.8000000000466 | 0 | 296.8000000000466 | L | 9392319001000001
939-780-56-000-000-23190-000001 | MISC PAYROLL ACCRUALS | L | 40.47000000000116 | 0 | 40.47000000000116 | L | 9392319056000001
939-780-01-000-000-23930-000001 | UTILITY EXPENSES | L | -2212.569999999982 | 0 | -2212.569999999982 | L | 9392393001000001
939-780-82-000-000-23950-000001 | ROYALTIES | L | -23630855.64000002 | -467973.14 | -24098828.78000002 | L | 9392395082000001
939-780-01-000-000-23970-000001 | PROFESSIONAL FEES | L | -242880 | -10560 | -253440 | L | 9392397001000001 |  |  |  | -6603056.25 | Misc Expense Accruals
939-780-56-000-000-23970-000001 | PROFESSIONAL FEES | L | -33120 | -1440 | -34560 | L | 9392397056000001 |  |  |  |  | Buyback
939-780-01-000-000-23990-000001 | MISC EXPENSE ACCRUALS | L | -5810689.5 | 283232.84 | -5527456.66 | L | 9392399001000001 |  |  |  | 321855.5 | Other Accruals
939-780-56-000-000-23990-000001 | MISC EXPENSE ACCRUALS | L | -792366.75 | 38622.66 | -753744.09 | L | 9392399056000001 |  |  |  | -6281200.75
939-780-82-000-000-24200-000003 | FEDERAL INCOME TAXES - NON US | L | 512316.43 | -24071.96 | 488244.47 | L | 9392420082000003
939-780-82-000-000-26300-000000 | OTHER THAN U.S. INCOME TAXES | L | -3292809 | 0 | -3292809 | L | 9392630082000000
939-780-82-000-000-29220-000000 | COMMON STOCK | L | -686400 | 0 | -686400 | ER | 9392922082000000
939-780-82-000-000-29510-000000 | DISTRIBUTED EARNINGS | L | -26880998.03 | 0 | -26880998.03 | ER | 9392951082000000
939-780-82-000-000-29520-000001 | [NAME] | L | -136636.59 | -101397.54 | -238034.13 | CYE | 9392952082000001
939-780-01-000-000-30010-000000 | SALES TO OUTSIDE CUSTOMERS | I | -7449853.94 | -4133689.52 | -11583543.46 | I | 9393001001000000
939-780-56-000-000-30010-000000 | SALES TO OUTSIDE CUSTOMERS | I | -712014.08 | -2054273.44 | -2766287.52 | I | 9393001056000000
939-780-01-000-000-30020-000000 | TECHNICAL SERVICE INCOME | I | -418050 | -693995 | -1112045 | I | 9393002001000000
939-780-01-000-000-41010-000000 | COST OF GOOD SOLD CUSTOMER | E | 4741143.02 | 3032385.55 | 7773528.569999999 | E | 9394101001000000
939-780-56-000-000-41010-000000 | COST OF GOOD SOLD CUSTOMER | E | 593502.24 | 1439086.2 | 2032588.44 | E | 9394101056000000
939-780-01-000-000-41020-000000 | TECHNICAL SERVICE COST | E | 910938.75 | 1014152.02 | 1925090.77 | E | 9394102001000000
939-780-01-500-000-61000-000000 | DISTRIBUTION COSTS | E | 661737.88 | 583594.75 | 1245332.63 | E | 9396100001000000
939-780-56-500-000-61000-000000 | DISTRIBUTION COSTS | E | 68569.49 | 61438.37 | 130007.86 | E | 9396100056000000
939-780-01-500-000-71000-000000 | SALES & MKTG EXP (EXCEPT 84O2) | E | 130052.71 | 60139.86 | 190192.57 | E | 9397100001000000
939-780-56-500-000-71000-000000 | SALES & MRKTING EXP(EXCEPT8402 | E | 12429.69 | 29887.04 | 42316.73 | E | 9397100056000000
939-780-01-500-000-76000-000000 | ADMINISTRATIVE EXPENSE | E | 543554.17 | 441639.95 | 985194.1200000001 | E | 9397600001000000
939-780-56-500-000-76000-000000 | ADMINISTRATIVE EXPENSE | E | 50802.88 | 219476.87 | 270279.75 | E | 9397600056000000
939-000-00-000-000-81800-000000 | EXCHANGE GAIN OR LOSS | E | 0 | 0 | 0 | INT | 9398180000000000
939-780-82-500-000-81800-000000 | G/L ON FOREIGN EXCHANGE | E | 28549.86 | -9788.79 | 18761.07 | INT | 9398180082000000
939-780-82-500-000-81850-000000 | BAD DEBT EXPENSE | E | 0 |  | 0 | INT | 9398185082000000
939-780-01-500-000-84020-000000 | COMMISSION EXPENSE | E | 629432.31 | 386214.77 | 1015647.08 | INT | 9398402001000000
939-780-56-500-000-84020-000000 | COMMISSION EXPENSE | E | 56961.13 | 164341.87 | 221303 | INT | 9398402056000000
939-780-82-500-000-91200-000000 | FEDERAL INCOME TAX PROVISION | E | 15607.3 | 24072.06 | 39679.36 | TAX | 9399120082000000
939-780-82-000-000-81290-000000 | OTHER INCOME | E | 0 | -666080.1 | -666080.1 | INT | 9398129082000000
Total………………………… |  |  | -136636.5900002495 | -101397.5400000007 | -238034.13000023 |  |  | 1 | January
 |  |  |  |  |  |  |  | 2 | February
 |  |  |  |  |  |  |  | 3 | March
Balance Sheet | Assets |  | 91287904.79999986 | -4833647.340000001 | 86454257.45999986 |  |  | 4 | April
 |  |  |  |  |  |  |  | 5 | May
 | Liabilities |  | -63583870.1800001 | 4935044.880000001 | -58648825.3000001 |  |  | 6 | June
 | Equity |  | -27704034.62 | -101397.54 | -27805432.16 |  |  | 7 | July
 |  |  |  |  |  |  |  | 8 | August
 | Total Liabilities & Equity |  | -91287904.8000001 | 4833647.340000001 | -86454257.4600001 |  |  | 9 | September
 |  |  |  |  |  |  |  | 10 | October
 | Total Balance Sheet |  | -1.788139343261719e-07 | 0 | -1.788139343261719e-07 |  |  | 11 | November
Must Be Zero ---> |  |  |  |  |  |  |  | 12 | December
 | Balance Sheet Current Earnings .vs. Income Statement Earnings |  | -0.009999999310821295 | -4.802132025361061e-10 | -0.009999999791034497
Income Statement | Income |  | -8579918.02 | -6881957.96 | -15461875.98
 | Expenses |  | 7712730.83 | 6881800.61 | 14594531.44
 | Earning Before Interest Income |  | -867187.1899999995 | -157.3499999996275 | -867344.5399999991
 | Other Income & Deductions |  | 714943.3 | -125312.2499999999 | 589631.0500000002
 | Earnings Before Taxes |  | -152243.8899999994 | -125469.5999999995 | -277713.4899999989
 | Taxes |  | 15607.3 | 24072.06 | 39679.36
 | Net Income |  | -136636.5899999994 | -101397.5399999995 | -238034.129999999