Finance - Spreading CAT Financials

profilecattlejock87
CopyofCATFinancialsSpreadingTemplate.xlsx
Home>Business & Finance homework help>Finance - Spreading CAT Financials

Balance Sheet

Caterpillar Inc (CAT US)
In Millions of USD except Per Share FY 2012 FY 2013 FY 2014
12 Months Ending 2012-12-31 2013-12-31 2014-12-31
Total Assets
+ Cash, Cash Equivalents & STI C&CE_AND_STI_DETAILED 5,490.0
+ Accounts Receivable, Net BS_ACCTS_REC_EXCL_NOTES_REC 9,706.0
+ Notes Receivable, Net NOTES_RECEIVABLE 8,860.0
+ Inventories BS_INVENTORIES 15,547.0
+ Prepaid Expenses BS_PREPAY 988.0
+ Deferred Tax Assets BS_DEFERRED_TAX_ASSETS_ST 1,547.0
+ Misc ST Assets BS_OTHER_CUR_ASSET_LESS_PREPAY 0.0
Total Current Assets BS_CUR_ASSET_REPORT 42,138.0
+ Property, Plant & Equip, Net BS_NET_FIX_ASSET 16,461.0
+ LT Investments & Receivables BS_LT_INVEST 15,617.0
+ Noncurrent deferred and refundabel income taxes 2,011.0
+ Intangible Assets BS_DISCLOSED_INTANGIBLES 4,016.0
+ Goodwill BS_GOODWILL 6,942.0
+ Other Assets OTHER_INTANGIBLE_ASSETS_DETAILED 1,785.0
Total Assets BS_TOT_ASSET 88,970.0
Liabilities & Shareholders' Equity
+ Accounts Payable BS_ACCT_PAYABLE 6,753.0
+ Notes payable BS_TAXES_PAYABLE 4,651.0
+ Accruals BS_INTEREST_&_DIVIDENDS_PAYABLE 5,578.0
+ LT debt due within one year 7,104.0
+ Other ST liabilities 5,329.0
Total Current Liabilities BS_CUR_LIAB 29,415.0
+ LT Borrowings LONG_TERM_BORROWINGS_DETAILED 19,086.0
+ LT Capital Leases LT_CAPITAL_LEASE_OBLIGATIONS 8,666.0
+ Pension Liabilities PENSION_LIABILITIES 11,085.0
+ Other LT Liabilities OTHER_NONCURRENT_LIABS_DETAILED 3,136.0
Total Liabilities BS_TOT_LIAB2 71,388.0
+ Share Capital & APIC BS_SH_CAP_AND_APIC 4,481.0
- Treasury Stock BS_AMT_OF_TSY_STOCK -10,074.0
+ Profit employed in the business BS_PURE_RETAINED_EARNINGS 29,558.0
+ Accumulated other comprehensive income (loss) OTHER_INS_RES_TO_SHRHLDR_EQY -6,433.00
+ Minority Interest MINORITY_NONCONTROLLING_INTEREST 50.0
Total Equity TOTAL_EQUITY 17,582.0
Total Liabilities & Equity TOT_LIAB_AND_EQY 88,970.0
Right click to show data transparency (not supported for all values)

Income Statement

Caterpillar Inc (CAT US)
In Millions of USD except Per Share FY 2012 FY 2013 FY 2014
12 Months Ending 2012-12-31 2013-12-31 2014-12-31
Sales and revenues: SALES_REV_TURN
+ Sales & Services Revenue IS_S&SR_GAAP 63,068.0
+ Financing Revenue IS_ADJUSTED_FIN_SUBSIDIARY_REV 2,807.0
Total slaes and revenues 65,875.0
Operating costs: IS_COGS_TO_FE_AND_PP_AND_G
+ Cost of Goods Sold IS_COG&SS_GAAP 47,055.0
+ Cost of Financing Revenue IS_COST_OF_FINANCING_REV_GAAP 797.0
+ Selling, General & Admin IS_SG&A_EXPENSE 5,919.0
+ Research & Development IS_OPEX_R&D 2,466.0
+ Other Operating Expense IS_OTHER_OPERATING_EXPENSES_GAAP 1,065.0
Total operating costs 57,302.0
Operating profit (EBIT) IS_OPER_INC 8,573.0
- Interest Expense IS_INT_EXPENSE 467.0
+ Other Income IS_INT_INC 130.0
Consolidated profit before taxes (EBT) PRETAX_INC 8,236.0
- Taxes IS_SH_PRO_EQY_MT_INV_NET_OF_TAX 2,528.0
Profit of unconsolidated affiliated companies 5,708.0
Equity in profit (loss) of unconsolidate companies IS_INC_BEF_XO_ITEM 14.0
Profit of consolidated and affilicated companies 5,722.0
- Profit (loss) attributable to noncontroling interests XO_GL_NET_OF_TAX 41.0
Net Income NI_INCLUDING_MINORITY_INT_RATIO 5,681.0
Basic Weighted Avg Shares 652.6
Diluted Weighted Avg Shares IS_SH_FOR_DILUTED_EPS 669.6
Basic EPS 8.71
Diluted EPS IS_DILUTED_EPS 8.48
Depreciation and Amortization 2,813.0