Question: Please help with my historical cash flow statement. Need help with totals and excel formula for those totals. Thank you Adjustments to reconcile net earnings

Please help with my historical cash flow statement. Need help with totals and excel formula for those totals. Thank you

Please help with my historical cash flow
Adjustments to reconcile net earnings to cash provided by operations: Depreciation and amortization $2, 700.00 $2,642 $2,485 Share-based compensation expense $220.00 $228 $200 Deferred income taxes $582.00 $522 $124 Gain on Dermstore sale $0.00 $325 So Loss on debt extinguishment $0.00 SO $512 Noncash losses / (gains) and other, net $172.00 $67 $86 Changes in operating accounts: Inventory $403.00 $3,249 -$1,661 Other assets $22.00 -$78 -$137 Accounts payable $2,237.00 $2,628 $2,925 Accrued and other liabilities -$624.00 -$746 $1,931 Cash provided by operating activities $4,018.00 $8, 625 $10,525 Investing activities Expenditures for property and equipment $5,528.00 $3,544 $2,649 Proceeds from disposal of property and equipment $8.00 $27 $42 Proceeds from Dermstore sale $0.00 $356 SO Other investments $16.00 $7 Cash required for investing activities $16 -$5,504.00 -$3,154 $2,591 Financing activities Additions to long-term debt Reductions of long-term debt $2,625.00 $1,972 $2,480 Dividends paid $163.00 $1,147 $2,415 Repurchase of stock $1,836.00 $1,548 $1,343 Stock option exercises -$2,826.00 $7,356 $745 Cash required for financing activities $4.00 $8 $23 Net (decrease) / increase in cash and cash equivalents $2, 196.00 -$8,071 -$2,000 Cash and cash equivalents at beginning of period $3,682.00 -$2,600 $5,934 Cash and cash equivalents at end of period $5,911.00 $8,511 $2,577 $2,229.00 $5,911 $8,511 Supplemental information Interest paid, net of capitalized interest Income taxes paid $449.00 $414 $939 Leased assets obtained in exchange for new finance lease liabilities $213.00 $2,063 $1,031 Leased assets obtained in exchange for new operating lease liabilities $224.00 $288 $428 $329.00 $580 $262

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!