Use the two statement of cash flows, one for CVS and one for Profire Energy, shown in the Excel worksheet to create a common-size statement of cash flow. The companies use different methods so you'll use the common-size technique depending on whether the company uses. (one direct and one indirect)

Note: Both statement of cash flows are in the Excel document. There are two tabs at the bottom of the spreadsheet.

CVS:

PROFIRE:

A B D 1 C 12 Months Ended Dec. 31, 2018 Dec. 31, 2019 Dec. 31, 2017 5 $248,393,000,000 (149,655,000,000) (52,242,000,000) (28,932,000,000) 955,000,000 (2,954,000,000) (2,717,000,000) 12,848,000,000 po sebi $ 186,519,000,000 (148,981,000,000) (6,897,000,000) (17,234,000,000) 644,000,000 (2,803,000,000) (2,383,000,000) 8,865,000,000 $ 176,594,000,000 (146,469,000,000) (2,810,000,000) (15,348,000,000) 21,000,000 (1,072,000,000) (2,909,000,000) 8,007,000,000 8 7,049,000,000 (7,534,000,000) (2,457,000,000) 5,000,000 817,000,000 (692,000,000) (2,037,000,000) 61,000,000 (137,000,000) (1,918,000,000) Consolidated Statements of Cash Flors - USD ($) 2 3 Cash flows from operating activities: 4 Cash receipts from customers Cash paid for inventory and prescriptions dispensed by retail network pharmacies 6 Insurance benefits paid 7 Cash paid to other suppliers and employees Interest and investment income received 9 Interest paid 10 Income taxes paid 11 Net cash provided by operating activities 12 Cash flows from investing activities: 13 Proceeds from sales and maturities of investments 14 Purchases of investments 15 Purchases of property and equipment 16 Proceeds from sale-leaseback transactions 17 Proceeds from sale-leasebaok transactions 18 Acquisitions (net of cash acquired) 19 Proceeds from sale of subsidiary and other assets 20 Other 21 Net cash used in investing activities 22 Cash flows from financing activities: 23 Net repayments of short-term debt 24 Proceeds from issuance of long-term debt 25 Repayments of long-term debt 26 Derivative settlements 27 Repurchase of common stock 28 Dividends paid 29 Proceeds from exercise of stock options 30 Payments for taxes related to net share settlement of equity awards 31 Other 32 Net cash provided by (used in) financing activities (444,000,000) 0 42,000,000 (3,339,000,000) 0 (42,226,000,000) 832,000,000 21,000,000 (43,285,000,000) 265,000,000 (1,181,000,000) 0 33,000,000 (2,877,000,000) (720,000,000) 3,736,000,000 (8,336,000,000) (25,000,000) 0 (2,603,000,000) 210,000,000 (112,000,000) 0 (7,850,000,000) (556,000,000) 44,343,000,000 (5,522,000,000) 446,000,000 0 (2,038,000,000) 242,000,000 (97,000,000) 1,000,000 36,819,000,000 (598,000,000) 0 0 0 (4,361,000,000) (2,049,000,000) 329,000,000 (71,000,000) (1,000,000) (6,751,000,000) 0 1,659,000,000 4,295,000,000 5,954,000,000 (4,000,000) 2,395,000,000 1,900,000,000 4,295,000,000 1,000,000 (1,620,000,000) 3,520,000,000 1,900,000,000 6,631,000,000 (596,000,000) 6,623,000,000 33 Effect of exchange rate changes on cash, cash equivalents and restricted cash 34 Net increase (decrease) in cash.cash equivalents and restricted cash 35 Cash, cash equivalents and restricted cash at the beginning of the period 36 Cash, cash equivalents and restricted cash at the end of the period 37 Reconciliation of net income (loss) to net cash provided by operating 38 Net income (loss) Adjustments required to reconcile net income (loss) to net cash 39 provided by operating activities: 40 Depreciation and amortization 41 Goodwill impairments 42 Loss on settlement of defined benefit pension plans 43 Stook-based compensation 44 Loss on sale of subsidiary 45 Loss on early extinguishment of debt 46 Deferred income taxes 47 Other noncash items 48 Change in operating assets and liabilities, net of effects from 49 Accounts receivable, net 50 Inventories Other assets 52 Accounts payable and pharmacy claims and discounts payable 53 Health care costs payable and other insurance liabilities 54 Other liabilities 4,371,000,000 0 0 453,000,000 205,000,000 79,000,000 (654,000,000) 264,000,000 2,718,000,000 6,149,000,000 0 280,000,000 86,000,000 0 87,000,000 253,000,000 2,479,000,000 181,000,000 187,000,000 234,000,000 0 0 (1,334,000,000) 53,000,000 51 (2,158,000,000) (1,075,000,000) (614,000,000) 3,550,000,000 320,000,000 $1,476,000,000 (1,139,000,000) (1,153,000,000) (3,000,000) 2,329,000,000 (311,000,000) $ 165,000,000 (941,000,000) (514,000,000) (338,000,000) 1,710,000,000 0 $(333,000,000) 1 B C 12 Months Ended Dec. 31, 2019 Dec. 31, 2018 $2,021,492 $6,080,762 1,467,007 (114,641) 315,256 390,826 896,681 (117,693) 186,882 1,059,000 1,965,207 (665,649) 1,630,632 (1,184,385) 524,367 1,363,090 7,713,202 911,981 71,397 (3,417,671) (14,301) (12,275) (92,207) 5,552,556 16 19 CONSOLIDATED STATEMENTS OF CASH FLOYS - USD ($) 2 3 OPERATING ACTIVITIES 4 Net income 5 Adjustments to reconcile net income to net cash provided by 6 Depreciation and amortization expense 7 Gain on sale of fixed assets 8 Bad debt expense 9 Stock awards issued for services 10 Changes in operating assets and liabilities: 11 Accounts receivable 12 Income taxes receivable/payable 13 Inventories 14 Prepaid expenses 15 Deferred tax asset/liability Accounts payable and accrued liabilities 17 Net Cash Provided by Operating Activities 18 INVESTING ACTIVITIES Proceeds from sale of equipment 20 Sale of investments 21 Purchase of fixed assets 22 Payments for acquisitions, net of cash acquired 23 Net Cash Used in Investing Activities 24 FINANCING ACTIVITIES 25 Value of equity awards surrendered by employees for tax liability 26 Cash received in exercise of stock options 27 Purchase of treasury stock 28 Principal paid towards lease liability 29 Net Cash Used in Financing Activities 30 Effect of exchange rate changes on cash 31 NET DECREASE IN CASH 32 CASH AT BEGINNING OF PERIOD 33 CASH AT END OF PERIOD 34 CASH PAID FOR: 35 Interest 36 Income taxes 37 NON-CASH FINANCING AND INVESTING ACTIVITIES: 38 Issuance of common stock - Midflow acquisition 116,785 1,494,568 (4,664,619) (4,384,175) (7.437.441) 219,063 140,356 (1.927,906) 0 (1.568,487) (242,497) 9,356 (2.743,534) (73,628) (3,050,303) 31,466 (2.743,076) 10,101,932 7,358,856 a (737,024) 174,002 (4.670,134) 0 (5,233,156) (94,780) (1.343,867) 11,445,799 10,101,932 6,497 1,793,281 0 2,163,826 $1,020,000 $0 A B D 1 C 12 Months Ended Dec. 31, 2018 Dec. 31, 2019 Dec. 31, 2017 5 $248,393,000,000 (149,655,000,000) (52,242,000,000) (28,932,000,000) 955,000,000 (2,954,000,000) (2,717,000,000) 12,848,000,000 po sebi $ 186,519,000,000 (148,981,000,000) (6,897,000,000) (17,234,000,000) 644,000,000 (2,803,000,000) (2,383,000,000) 8,865,000,000 $ 176,594,000,000 (146,469,000,000) (2,810,000,000) (15,348,000,000) 21,000,000 (1,072,000,000) (2,909,000,000) 8,007,000,000 8 7,049,000,000 (7,534,000,000) (2,457,000,000) 5,000,000 817,000,000 (692,000,000) (2,037,000,000) 61,000,000 (137,000,000) (1,918,000,000) Consolidated Statements of Cash Flors - USD ($) 2 3 Cash flows from operating activities: 4 Cash receipts from customers Cash paid for inventory and prescriptions dispensed by retail network pharmacies 6 Insurance benefits paid 7 Cash paid to other suppliers and employees Interest and investment income received 9 Interest paid 10 Income taxes paid 11 Net cash provided by operating activities 12 Cash flows from investing activities: 13 Proceeds from sales and maturities of investments 14 Purchases of investments 15 Purchases of property and equipment 16 Proceeds from sale-leaseback transactions 17 Proceeds from sale-leasebaok transactions 18 Acquisitions (net of cash acquired) 19 Proceeds from sale of subsidiary and other assets 20 Other 21 Net cash used in investing activities 22 Cash flows from financing activities: 23 Net repayments of short-term debt 24 Proceeds from issuance of long-term debt 25 Repayments of long-term debt 26 Derivative settlements 27 Repurchase of common stock 28 Dividends paid 29 Proceeds from exercise of stock options 30 Payments for taxes related to net share settlement of equity awards 31 Other 32 Net cash provided by (used in) financing activities (444,000,000) 0 42,000,000 (3,339,000,000) 0 (42,226,000,000) 832,000,000 21,000,000 (43,285,000,000) 265,000,000 (1,181,000,000) 0 33,000,000 (2,877,000,000) (720,000,000) 3,736,000,000 (8,336,000,000) (25,000,000) 0 (2,603,000,000) 210,000,000 (112,000,000) 0 (7,850,000,000) (556,000,000) 44,343,000,000 (5,522,000,000) 446,000,000 0 (2,038,000,000) 242,000,000 (97,000,000) 1,000,000 36,819,000,000 (598,000,000) 0 0 0 (4,361,000,000) (2,049,000,000) 329,000,000 (71,000,000) (1,000,000) (6,751,000,000) 0 1,659,000,000 4,295,000,000 5,954,000,000 (4,000,000) 2,395,000,000 1,900,000,000 4,295,000,000 1,000,000 (1,620,000,000) 3,520,000,000 1,900,000,000 6,631,000,000 (596,000,000) 6,623,000,000 33 Effect of exchange rate changes on cash, cash equivalents and restricted cash 34 Net increase (decrease) in cash.cash equivalents and restricted cash 35 Cash, cash equivalents and restricted cash at the beginning of the period 36 Cash, cash equivalents and restricted cash at the end of the period 37 Reconciliation of net income (loss) to net cash provided by operating 38 Net income (loss) Adjustments required to reconcile net income (loss) to net cash 39 provided by operating activities: 40 Depreciation and amortization 41 Goodwill impairments 42 Loss on settlement of defined benefit pension plans 43 Stook-based compensation 44 Loss on sale of subsidiary 45 Loss on early extinguishment of debt 46 Deferred income taxes 47 Other noncash items 48 Change in operating assets and liabilities, net of effects from 49 Accounts receivable, net 50 Inventories Other assets 52 Accounts payable and pharmacy claims and discounts payable 53 Health care costs payable and other insurance liabilities 54 Other liabilities 4,371,000,000 0 0 453,000,000 205,000,000 79,000,000 (654,000,000) 264,000,000 2,718,000,000 6,149,000,000 0 280,000,000 86,000,000 0 87,000,000 253,000,000 2,479,000,000 181,000,000 187,000,000 234,000,000 0 0 (1,334,000,000) 53,000,000 51 (2,158,000,000) (1,075,000,000) (614,000,000) 3,550,000,000 320,000,000 $1,476,000,000 (1,139,000,000) (1,153,000,000) (3,000,000) 2,329,000,000 (311,000,000) $ 165,000,000 (941,000,000) (514,000,000) (338,000,000) 1,710,000,000 0 $(333,000,000) 1 B C 12 Months Ended Dec. 31, 2019 Dec. 31, 2018 $2,021,492 $6,080,762 1,467,007 (114,641) 315,256 390,826 896,681 (117,693) 186,882 1,059,000 1,965,207 (665,649) 1,630,632 (1,184,385) 524,367 1,363,090 7,713,202 911,981 71,397 (3,417,671) (14,301) (12,275) (92,207) 5,552,556 16 19 CONSOLIDATED STATEMENTS OF CASH FLOYS - USD ($) 2 3 OPERATING ACTIVITIES 4 Net income 5 Adjustments to reconcile net income to net cash provided by 6 Depreciation and amortization expense 7 Gain on sale of fixed assets 8 Bad debt expense 9 Stock awards issued for services 10 Changes in operating assets and liabilities: 11 Accounts receivable 12 Income taxes receivable/payable 13 Inventories 14 Prepaid expenses 15 Deferred tax asset/liability Accounts payable and accrued liabilities 17 Net Cash Provided by Operating Activities 18 INVESTING ACTIVITIES Proceeds from sale of equipment 20 Sale of investments 21 Purchase of fixed assets 22 Payments for acquisitions, net of cash acquired 23 Net Cash Used in Investing Activities 24 FINANCING ACTIVITIES 25 Value of equity awards surrendered by employees for tax liability 26 Cash received in exercise of stock options 27 Purchase of treasury stock 28 Principal paid towards lease liability 29 Net Cash Used in Financing Activities 30 Effect of exchange rate changes on cash 31 NET DECREASE IN CASH 32 CASH AT BEGINNING OF PERIOD 33 CASH AT END OF PERIOD 34 CASH PAID FOR: 35 Interest 36 Income taxes 37 NON-CASH FINANCING AND INVESTING ACTIVITIES: 38 Issuance of common stock - Midflow acquisition 116,785 1,494,568 (4,664,619) (4,384,175) (7.437.441) 219,063 140,356 (1.927,906) 0 (1.568,487) (242,497) 9,356 (2.743,534) (73,628) (3,050,303) 31,466 (2.743,076) 10,101,932 7,358,856 a (737,024) 174,002 (4.670,134) 0 (5,233,156) (94,780) (1.343,867) 11,445,799 10,101,932 6,497 1,793,281 0 2,163,826 $1,020,000 $0