Question

1 Approved Answer

Posted on Aug 31, 2024

Prepare a Cash Flow Statement for Year 9 using both the Direct AND Indirect Methods. Assume Net Income is $396 for year 9. (Show answer

Prepare a Cash Flow Statement for Year 9 using both the Direct AND Indirect Methods. Assume Net Income is $396 for year 9. (Show answer in Excel file.)

image text in transcribed

AutoSave On Assignment 2 - Excel Jeff Shen JS Ga H2 SEE Y Insert Draw Page Layout File Home Formulas Data Review View Developer Help Fuzzy Lookup Share Comments Search y X LO Arial 10 AA === ab General Insert Delete Format 27 O 4 Paste $ % 78-88 Ideas BIU Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Editing Ideas Sensitivity A1 fx CONSOLIDATED BALANCE SHEETS (USD million $) E H J K L N N O P R S T U v w X Year 9 Yaari Year 7 Operation Investing Financing 545 4035 2178 2171 200 AARR $475 3.2.36 2. 270 7,647 (788) 170) $430 3784 234 110 116 6,640 2 3800 193 10,047 ARGO 4,098 5220 475 12.584 12,804 CONSOLIDATED BALANCE SHEETSIUSU million $1 In Thousands 3 Current assets 4 Cash and cash valenta 5 Account IRS 7 Propaments to fuppliers memories a Total current AAR 9 Non-current AAAA 10 Propert, blant and equipment, net 11 Other assets 12 Total assets 13 Current labies 14 Annum DANIA 15 Notes and other current horrowings 18 MAR Pablo 17 Taces whe 18 Total trans 19 Non current liabilien 20 Long Term Debt 21 letomed tax liabile 22 Total labi 23 Stockholders' equity: 2 Predator Commen auch Additional Paid in Capital Rained samings TotalSarah RA |TotallinsaniANY ARD 1 A5 1 095 119 315 209 231 777 185 2,602 1576 an 11 1076 220 4190 2.RAS 2.084 6.2492 4,092 89 6,783 2351 120 2012 2015 209 0 05 AS 8 4,192 1523 1.25 521 512740 S12.04 $10.17 CONSOLIDATED STATEMENTS OF OPERATKINS (USD $ In Thousands COGS Year $18 500 (12031) 3495 4452 45 1170 TH Year $22,13 ( (18.5101 14,6491 (45 22 COM 3e een were 37 Gain on Sale or 30 income taxe 39 cm 10 Cards on wred Stock 11 to Commen v4 v3 v2 v1 $1,012 4 Select destination and press ENTER or choose Paste Average: 2404.965556 Count: 145 Sum: 2167979 A T 6196 HE Type here to search O 96%A ENG 8:55 PM 9/28/2020 AutoSave On H2 SEE Y Assignment 2 - Excel Jeff Shen JS Ga File Home Insert Draw Page Layout Formulas Data Review View Developer Help Fuzzy Lookup Share Comments Search X [ ab General Arial 10 AA === B 1 Ut OA Insert Delete Format We 28 0 4 Paste $ % 78-88 Ideas Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard E Font Alignment Number Cells Editing Ideas Sensitivity A1 fe CONSOLIDATED BALANCE SHEETS (USD million $) E H 1 J KL N O P 0 R S T U v w X 43 Notes: 44 Depreciation Expande 45 ASEMA NAV ) 46 Patent Other Asset Amortion 47 20 945 225 75 100 25 50 Colad on From Customers 51 Payment suppliers 52 Spare paid Sinest Paid 54 Tax Pala 56 Cash From Operations 57 99 PO 50 50 51 53 54 57 BA 70 72 73 74 75 76 79 79 30 31 83 V4 v3 v2 v1 Average: 2404.965556 Count: 145 Sum: 2167979 A 61% I Type here to search O 96%A ENG 8:56 PM 9/28/2020 AutoSave On Assignment 2 - Excel Jeff Shen JS Ga H2 SEE Y Insert Draw Page Layout File Home Formulas Data Review View Developer Help Fuzzy Lookup Share Comments Search y X LO Arial 10 AA === ab General Insert Delete Format 27 O 4 Paste $ % 78-88 Ideas BIU Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Editing Ideas Sensitivity A1 fx CONSOLIDATED BALANCE SHEETS (USD million $) E H J K L N N O P R S T U v w X Year 9 Yaari Year 7 Operation Investing Financing 545 4035 2178 2171 200 AARR $475 3.2.36 2. 270 7,647 (788) 170) $430 3784 234 110 116 6,640 2 3800 193 10,047 ARGO 4,098 5220 475 12.584 12,804 CONSOLIDATED BALANCE SHEETSIUSU million $1 In Thousands 3 Current assets 4 Cash and cash valenta 5 Account IRS 7 Propaments to fuppliers memories a Total current AAR 9 Non-current AAAA 10 Propert, blant and equipment, net 11 Other assets 12 Total assets 13 Current labies 14 Annum DANIA 15 Notes and other current horrowings 18 MAR Pablo 17 Taces whe 18 Total trans 19 Non current liabilien 20 Long Term Debt 21 letomed tax liabile 22 Total labi 23 Stockholders' equity: 2 Predator Commen auch Additional Paid in Capital Rained samings TotalSarah RA |TotallinsaniANY ARD 1 A5 1 095 119 315 209 231 777 185 2,602 1576 an 11 1076 220 4190 2.RAS 2.084 6.2492 4,092 89 6,783 2351 120 2012 2015 209 0 05 AS 8 4,192 1523 1.25 521 512740 S12.04 $10.17 CONSOLIDATED STATEMENTS OF OPERATKINS (USD $ In Thousands COGS Year $18 500 (12031) 3495 4452 45 1170 TH Year $22,13 ( (18.5101 14,6491 (45 22 COM 3e een were 37 Gain on Sale or 30 income taxe 39 cm 10 Cards on wred Stock 11 to Commen v4 v3 v2 v1 $1,012 4 Select destination and press ENTER or choose Paste Average: 2404.965556 Count: 145 Sum: 2167979 A T 6196 HE Type here to search O 96%A ENG 8:55 PM 9/28/2020 AutoSave On H2 SEE Y Assignment 2 - Excel Jeff Shen JS Ga File Home Insert Draw Page Layout Formulas Data Review View Developer Help Fuzzy Lookup Share Comments Search X [ ab General Arial 10 AA === B 1 Ut OA Insert Delete Format We 28 0 4 Paste $ % 78-88 Ideas Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard E Font Alignment Number Cells Editing Ideas Sensitivity A1 fe CONSOLIDATED BALANCE SHEETS (USD million $) E H 1 J KL N O P 0 R S T U v w X 43 Notes: 44 Depreciation Expande 45 ASEMA NAV ) 46 Patent Other Asset Amortion 47 20 945 225 75 100 25 50 Colad on From Customers 51 Payment suppliers 52 Spare paid Sinest Paid 54 Tax Pala 56 Cash From Operations 57 99 PO 50 50 51 53 54 57 BA 70 72 73 74 75 76 79 79 30 31 83 V4 v3 v2 v1 Average: 2404.965556 Count: 145 Sum: 2167979 A 61% I Type here to search O 96%A ENG 8:56 PM 9/28/2020