assume a tax margin of 35%

AutoSave ON A File Home Homework 1 Operating and Financing Insert Draw Page Layout Formulas Search Data Review A X Cut View Log Copy Help Arial - 10 - A A as Wrap Text B TU- Number Format Painter Clipboard cs A- Merge & Center - Bad Normal Conditional Formatas Calculation Formatting Table Goud Neutral Font Alignment Check Cell Exploratory HB Input Number fi Styles A M 1 2 3 4 5 N O P 7 B 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 B Required: For the years 2010 and 2011, separte the balance sheet accounts into operating (NOA) and financing (NFL). 0 E F. For the Income Statement, separete the accounts into operating (NOPAT) and financing (FEAT) Fiscal Year Ended (in millions) Consolidated Stmt of Operations 2010 2009 Sales 2011 2010 2011 Operating Financing Operating Financing Other come net $82,494 $93,627 S104859 918 1,122 Total revenues (Total Sales) 1,287 83,412 94,749 106,146 Cast of sales 65,586 74 564 83,663 Operating Selling General & Administrative Expenses 12,858 14951 16,788 Total operating expenses 78444 89.515 100,451 Operating income 4,968 5.234 5.605 Interest costs Debt 520 692 019 Capital leases 186 196 216 Total Interest Costs 888 345 Income before taxes 4.262 4,346 4,850 Income tax expense Current 1572 1.530 1,974 Deferred 76 -180 1581 Total Income tax expense 1.606 1.79 S2,681 $2,740 Net income $3,056 31 32 33 34 35 36 37 38 39 40 NOPAT & FEAT Operating vs Financin NOA NEL Ready O HF Type here to search REDESIGNED RELIABLE READY FOR YOU AutoSave OH Homework 1 Operating and Financing Search File Home Insert Drew Page Layout Formulas Data Review View Help X Cut Copy . Arial 10 AA== a. A General DB Det 3 Format Painter Clipboard B TV Wrap Text Merge Center CH Normal Conditional Formatasaran Formatting ble Bar Good Check cell Explanatory $ - % * Font Alignment 15 Number 5 Stres 111 SA M N N A 1 2 3 3 4 4 5 6 7 B 9 9 10 111 12 13 14 C D E G H K For the income Statement, separete the accounts into operating INOPAT) and financing (FEAT) Fiscal Year Ended millions) 2010 2012 Consolidated Stunt of Operations 2000 2010 2011 Operating Floorleg Operating Financing Sales S62,491 591 027 $104859 $627 $ Odhe income net 918 1.122 1.287 Total revenues (Total Sales) 83,412 94,749 106,146 Cost of sales 65,586 14,564 83,653 Operating Seling General & Administrative Expenses 1758 14.951 16.788 Total operating expenses 73.444 89515 100,451 Operating income 4,068 5,234 5,605 tale est costs Debt 520 692 629 Capital leases 186 195 216 Total Interest Costs 706 88 843 Income before uses 4,346 4,850 Income tax expense Curs 1572 1.510 1974 Deserted 9 75 -180 Tetail Income tax expense 1,981 LOD 1.794 Nette 52.681 $2.740 56 16 12 18 19 20 21 22 23 24 2 20 25 33 311 37 315 Opening van NOAR NOPATTLAT 19 o LED type here to search RE DESIGN RELIABLE READY FOR YOU cipta F12 FB PO FE F4 PI Num Cars Scroll Pue Nur + SC Puan 7 3 P IL 4 5 7 7 77 JT LT X x w Homework #1 My MyUW: Home (93) General (R X (278) Trending X G g suite - Google X (278) YNW Me! X Office Editing for Docs, Sheets & Slides chrome extension://bpmcpldpdmajfigpchkicefoigmkfalc/views/app.html K X Homework 1 Operating and Financing.xlsx File Edit Insert Format Help 30 Arial 10 - 8 I USA - f separete the accounts into operating (NOPAT) and financing (FEAT). D F B E 1 H G J Required: For the years 2010 and 2011, 2 separete the accounts into operating (NOPAT) and financing (FEAT).brating (NOPAT) and financing (FEAT). 3 4 Fiscal Year Ended (in millions) 2010 2011 5 Consolidated Stmt of Operations 2009 2010 2011 Operating Financing Operating Financing 6 Sales $82,494 $93,627 $104,859 7 Other income.net 918 1,122 1,287 8 Total revenues (Total Sales) 83,412 94,749 106,146 9 Cost of sales 65,586 74,564 83,663 10 Operating, Selling. General & Administrative Expenses 12,858 14,951 16,788 Total operating expenses 78,444 89,515 100,451 12 Operating income 4,968 5,234 5,695 13 Interest costs 14 Debt 520 692 629 15 Capital leases 186 196 216 16 Total Interest Costs 706 888 845 17 Income before taxes 4,262 4,346 4,850 18 Income tax expense 19 Current 1,572 1,530 1,974 20 Deferred 9 76 -180 21 Total Income tax expense 1,581 1,606 1,794 22 Net Income $2,681||$2,740 23 $3,056 24 Consolidated Balance Sheets Amounts in millions) 25 2010 2011 Assets Operating vs Financing AutoSave On A. Homework 1 Operating and Financing Search File Home insert Draw Page Layout Formulas Data Review View Help Arial A X out Cogry Pasti 3 Format Painter 10 - AA =23 Wrap Text A Mega Center General Bad Good BIU $ % 992 Norma Conditional Formats calculation Formatting - Table Check Cell Emble Clipboard Font Alignment Number Styles 025 M N A 1 2 3 4 4 5 5 7 8 9 9 10 11 12 13 14 15 16 11 18 19 20 21 22 23 24 25 26 O 27 O 280 2010 30 35 320 33 0 340 350 B Required: For the years 2010 and 2011, separte the balance sheet accounts into operating (NOA) and financing (NFL). CDE F G H J K For the income Statement, separete the accounts into operating (NOPAT) and financing IFEAT). Fiscal Year Ended (in millions) 2010 Consolidated Stut of Operations 2011 2000 2010 2011 Operating Financing Operating Financing Sales $82,494 $93,627 S101,859 Other income bet 918 1,122 1.287 Total revenues (Total Sales) 83,412' 94,749 106,146 Cost of sales 65.586 74,364 83663 Operating Selling General & Achistrative Expenses 12.858 14.951 16,783 Total operating expenses 78.444 89.515 100451 Operating income 4,968 5234 5095 Interest COSES Debt 520 692 629 Capital leases 186 196 216 700 888 Total Interest Costs 845 Income before takes 4262 4346 4,850 Income tax expense 1.572 Current 1,94 1,530 9 70 -180 Deferred 1581 1606 1791 Total Income tax experise $2,691 $2.700 $1,056 Net income 2010 2011 $33 953 15.959 40 17,331 583 345 15393 los 17.991 Consolidated Balance Sheetsmounts in millions) Asses Current assets Cash and cash equivalents Receivables Leveres at LIFO Prepaid expenses and other Total current assets Property plant and equipment tot Land Building and provements Fixtures and equipment Tranpattaranceurner Les accumulated depreciation Operating Financin NOA NIL NOPATTA 3.55 11.200 5s 156 20,150 3.09 12.124 090 21.12 119 97 30 N 6 o Type here to search en Homework Operating and Financing e Search Draw Page Layout Formulas Data Review View Help A XC Copy I Format Painter - 10-AA = 25 Wrap Text BTU - E-OA- Merge & Center - General $ % 9 Conditional Format Formatting - Table - Clipbo Font 5 Alignment 5 Number fo C D E 2010 G H F 2011 Consolidated Balance Sheets (Amounts in millions Assets Current assets Cash and cash equivalents Receivables Inventories at LIFO Prepaid expenses and other Total current assets Property, plant and equipment, at cost Land Building and improvements Fixtures and equipment Transportation equipment $83 853 15,989 406 17331 $883 845 15897 368 17.993 24 25 26 O | 27 0 28 0 29 O | 300 31 32 0 3310 34 O 35 0 35 0 137 38 0 390 MOWO 40 42 0 43 0 44 45 5 MG 47 480 490 500 1 F 52 53 54 55 560 57 58 59 60 61 3.559 3.689 11.290 12,724 5,665 6,390 336 379 20,850 23,182 3.252 4,849 17,098 18.333 2.476 2,782 680 791 1,296 1.991 1316 687 $32.541 $39.004 Less accumulated depreciation Net property, plant and equipment Property under capital leases Less accumulated amortization Net property under capital leases Other assets and deferred charges Total assets Liabilities and Shareholders' Equity Current liabilities Commercial paper (interst bearing) Accounts payable Accrued abilities Accued income taxes Long term debt due within one year (interest bearing) Obligations under capital leases due within one year (interest Total current liabilities Long-temu debt Long-term obligations under capital leases Deferred income taxes and other Total Liabilities Net -7.628 (S2:58 -6,442 -2,091 -123 -221 -09 -11,454 -8,508 2,092 -400 -22.454 $15.087 -298 -523 -95 10.957 -7,709 2.307 -403 -21,436 S12.568 CO Operating vs Financin NOA & NFL NOPAT & FEAT Type here to search n a AutoSave ON A File Home Homework 1 Operating and Financing Insert Draw Page Layout Formulas Search Data Review A X Cut View Log Copy Help Arial - 10 - A A as Wrap Text B TU- Number Format Painter Clipboard cs A- Merge & Center - Bad Normal Conditional Formatas Calculation Formatting Table Goud Neutral Font Alignment Check Cell Exploratory HB Input Number fi Styles A M 1 2 3 4 5 N O P 7 B 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 B Required: For the years 2010 and 2011, separte the balance sheet accounts into operating (NOA) and financing (NFL). 0 E F. For the Income Statement, separete the accounts into operating (NOPAT) and financing (FEAT) Fiscal Year Ended (in millions) Consolidated Stmt of Operations 2010 2009 Sales 2011 2010 2011 Operating Financing Operating Financing Other come net $82,494 $93,627 S104859 918 1,122 Total revenues (Total Sales) 1,287 83,412 94,749 106,146 Cast of sales 65,586 74 564 83,663 Operating Selling General & Administrative Expenses 12,858 14951 16,788 Total operating expenses 78444 89.515 100,451 Operating income 4,968 5.234 5.605 Interest costs Debt 520 692 019 Capital leases 186 196 216 Total Interest Costs 888 345 Income before taxes 4.262 4,346 4,850 Income tax expense Current 1572 1.530 1,974 Deferred 76 -180 1581 Total Income tax expense 1.606 1.79 S2,681 $2,740 Net income $3,056 31 32 33 34 35 36 37 38 39 40 NOPAT & FEAT Operating vs Financin NOA NEL Ready O HF Type here to search REDESIGNED RELIABLE READY FOR YOU AutoSave OH Homework 1 Operating and Financing Search File Home Insert Drew Page Layout Formulas Data Review View Help X Cut Copy . Arial 10 AA== a. A General DB Det 3 Format Painter Clipboard B TV Wrap Text Merge Center CH Normal Conditional Formatasaran Formatting ble Bar Good Check cell Explanatory $ - % * Font Alignment 15 Number 5 Stres 111 SA M N N A 1 2 3 3 4 4 5 6 7 B 9 9 10 111 12 13 14 C D E G H K For the income Statement, separete the accounts into operating INOPAT) and financing (FEAT) Fiscal Year Ended millions) 2010 2012 Consolidated Stunt of Operations 2000 2010 2011 Operating Floorleg Operating Financing Sales S62,491 591 027 $104859 $627 $ Odhe income net 918 1.122 1.287 Total revenues (Total Sales) 83,412 94,749 106,146 Cost of sales 65,586 14,564 83,653 Operating Seling General & Administrative Expenses 1758 14.951 16.788 Total operating expenses 73.444 89515 100,451 Operating income 4,068 5,234 5,605 tale est costs Debt 520 692 629 Capital leases 186 195 216 Total Interest Costs 706 88 843 Income before uses 4,346 4,850 Income tax expense Curs 1572 1.510 1974 Deserted 9 75 -180 Tetail Income tax expense 1,981 LOD 1.794 Nette 52.681 $2.740 56 16 12 18 19 20 21 22 23 24 2 20 25 33 311 37 315 Opening van NOAR NOPATTLAT 19 o LED type here to search RE DESIGN RELIABLE READY FOR YOU cipta F12 FB PO FE F4 PI Num Cars Scroll Pue Nur + SC Puan 7 3 P IL 4 5 7 7 77 JT LT X x w Homework #1 My MyUW: Home (93) General (R X (278) Trending X G g suite - Google X (278) YNW Me! X Office Editing for Docs, Sheets & Slides chrome extension://bpmcpldpdmajfigpchkicefoigmkfalc/views/app.html K X Homework 1 Operating and Financing.xlsx File Edit Insert Format Help 30 Arial 10 - 8 I USA - f separete the accounts into operating (NOPAT) and financing (FEAT). D F B E 1 H G J Required: For the years 2010 and 2011, 2 separete the accounts into operating (NOPAT) and financing (FEAT).brating (NOPAT) and financing (FEAT). 3 4 Fiscal Year Ended (in millions) 2010 2011 5 Consolidated Stmt of Operations 2009 2010 2011 Operating Financing Operating Financing 6 Sales $82,494 $93,627 $104,859 7 Other income.net 918 1,122 1,287 8 Total revenues (Total Sales) 83,412 94,749 106,146 9 Cost of sales 65,586 74,564 83,663 10 Operating, Selling. General & Administrative Expenses 12,858 14,951 16,788 Total operating expenses 78,444 89,515 100,451 12 Operating income 4,968 5,234 5,695 13 Interest costs 14 Debt 520 692 629 15 Capital leases 186 196 216 16 Total Interest Costs 706 888 845 17 Income before taxes 4,262 4,346 4,850 18 Income tax expense 19 Current 1,572 1,530 1,974 20 Deferred 9 76 -180 21 Total Income tax expense 1,581 1,606 1,794 22 Net Income $2,681||$2,740 23 $3,056 24 Consolidated Balance Sheets Amounts in millions) 25 2010 2011 Assets Operating vs Financing AutoSave On A. Homework 1 Operating and Financing Search File Home insert Draw Page Layout Formulas Data Review View Help Arial A X out Cogry Pasti 3 Format Painter 10 - AA =23 Wrap Text A Mega Center General Bad Good BIU $ % 992 Norma Conditional Formats calculation Formatting - Table Check Cell Emble Clipboard Font Alignment Number Styles 025 M N A 1 2 3 4 4 5 5 7 8 9 9 10 11 12 13 14 15 16 11 18 19 20 21 22 23 24 25 26 O 27 O 280 2010 30 35 320 33 0 340 350 B Required: For the years 2010 and 2011, separte the balance sheet accounts into operating (NOA) and financing (NFL). CDE F G H J K For the income Statement, separete the accounts into operating (NOPAT) and financing IFEAT). Fiscal Year Ended (in millions) 2010 Consolidated Stut of Operations 2011 2000 2010 2011 Operating Financing Operating Financing Sales $82,494 $93,627 S101,859 Other income bet 918 1,122 1.287 Total revenues (Total Sales) 83,412' 94,749 106,146 Cost of sales 65.586 74,364 83663 Operating Selling General & Achistrative Expenses 12.858 14.951 16,783 Total operating expenses 78.444 89.515 100451 Operating income 4,968 5234 5095 Interest COSES Debt 520 692 629 Capital leases 186 196 216 700 888 Total Interest Costs 845 Income before takes 4262 4346 4,850 Income tax expense 1.572 Current 1,94 1,530 9 70 -180 Deferred 1581 1606 1791 Total Income tax experise $2,691 $2.700 $1,056 Net income 2010 2011 $33 953 15.959 40 17,331 583 345 15393 los 17.991 Consolidated Balance Sheetsmounts in millions) Asses Current assets Cash and cash equivalents Receivables Leveres at LIFO Prepaid expenses and other Total current assets Property plant and equipment tot Land Building and provements Fixtures and equipment Tranpattaranceurner Les accumulated depreciation Operating Financin NOA NIL NOPATTA 3.55 11.200 5s 156 20,150 3.09 12.124 090 21.12 119 97 30 N 6 o Type here to search en Homework Operating and Financing e Search Draw Page Layout Formulas Data Review View Help A XC Copy I Format Painter - 10-AA = 25 Wrap Text BTU - E-OA- Merge & Center - General $ % 9 Conditional Format Formatting - Table - Clipbo Font 5 Alignment 5 Number fo C D E 2010 G H F 2011 Consolidated Balance Sheets (Amounts in millions Assets Current assets Cash and cash equivalents Receivables Inventories at LIFO Prepaid expenses and other Total current assets Property, plant and equipment, at cost Land Building and improvements Fixtures and equipment Transportation equipment $83 853 15,989 406 17331 $883 845 15897 368 17.993 24 25 26 O | 27 0 28 0 29 O | 300 31 32 0 3310 34 O 35 0 35 0 137 38 0 390 MOWO 40 42 0 43 0 44 45 5 MG 47 480 490 500 1 F 52 53 54 55 560 57 58 59 60 61 3.559 3.689 11.290 12,724 5,665 6,390 336 379 20,850 23,182 3.252 4,849 17,098 18.333 2.476 2,782 680 791 1,296 1.991 1316 687 $32.541 $39.004 Less accumulated depreciation Net property, plant and equipment Property under capital leases Less accumulated amortization Net property under capital leases Other assets and deferred charges Total assets Liabilities and Shareholders' Equity Current liabilities Commercial paper (interst bearing) Accounts payable Accrued abilities Accued income taxes Long term debt due within one year (interest bearing) Obligations under capital leases due within one year (interest Total current liabilities Long-temu debt Long-term obligations under capital leases Deferred income taxes and other Total Liabilities Net -7.628 (S2:58 -6,442 -2,091 -123 -221 -09 -11,454 -8,508 2,092 -400 -22.454 $15.087 -298 -523 -95 10.957 -7,709 2.307 -403 -21,436 S12.568 CO Operating vs Financin NOA & NFL NOPAT & FEAT Type here to search n a