Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prepare an analysis of cash replicating the example below of the Target Corporation for the years of 2016, 2017 and 2018. For Years Ended April

Prepare an analysis of cash replicating the example below of the Target Corporation for the years of 2016, 2017 and 2018.

image text in transcribedimage text in transcribed

For Years Ended April 29 Year 3 Year 2 $13,859 $ 6,373 (6,497) (10,846) Cash and cash equivalents at year-end Cash flow from operations $ 17,336 (17,174) Year 1 $9,353 (13,915) Based on the preceding data, the monthly cash expenses and ratio of cash to monthly cash expenses are computed as follows: For Years Ended April 29 Year 3 Year 2 Year 1 $541 $904 $1,160 Year 4 Monthly cash expenses:* $17,174 - 12......... ....... $1,431 $ 6,497 - 12..... $10,846 = 12.... $13,915 - 12. Ratio of cash to monthly cash expenses:** $17,336 + $1,431........... ....... 12.1 months $13,859 - $541 ...................... $ 6,373 + $904 .......................... $9,353 + $1,160.................... * Rounded to nearest dollar. **Rounded to one decimal place. 25.6 months 7.0 months 8.1 months Consolidated Statements of Cash Flows 2017 2018 As Adjusted As Adjusted 2937 S 2 914 S 2.734 2.930 2.908 2,668 2.318 2.474 132 322 2.476 112 (188) 123 95 208 293 (900) (299) 1,127 (348) (156) 1,307 58 (166) (394) 5.337 5.970 6.861 107 5.973 6,935 5.444 (millions) Operating activities Net earnings Earnings from discontinued operations net of te Net earnings from continuing operations Adjustments to reconcile net earnings to cash provided by operations: Depreciation and amortization Share-based compensation expense Deferred income taxes Loss on debt extinguishment Noncash losses/gains) and other net Changes in operating accounts: Inventory Other assets Accounts payable Accrued and other liabilities Cash provided by operating activities continuing operations Cash provided by operating activities discontinued operations Cash provided by operations Investing activities Expenditures for property and equipment Proceeds from disposal of property and equipment Cash paid for acquisitions, net of cash assumed Other investments Cash required for investing activities Financing activities Additions to long-term debt Reductions of long-term debt Dividends paid Repurchase of stock Stock option exercises Cash required for financing activities Net (decrease) / increase in cash and cash equivalents Cash and cash equivalents at beginning of period Cash and cash equivalents at end of period Supplemental information Interest paid, net of capitalized interest Income taxes paid Leased assets obtained in exchange for new finance lease liabilities Leased assets obtained in exchange for new operating lease abilities (2.533) (3.516) 85 (1.547) (518) (55) (3 416) (3,075) (1.473) 739 (2,192) (1,338) (1.046) 108 (281) (1,335) (2.124) 98 (3.644) (1,087) 2643 1,556 1.977 (2.649) (1,348) (3.708) 221 (5,505) (1,534) 4 046 2,512 (3.729) 131 2512 2,643 $ 476 $ 5 999 678 934 373 1.514 139 252 130 246 212

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sarbanes Oxley Internal Controls Effective Auditing With AS5 CobiT And ITIL

Authors: Robert R. Moeller

1st Edition

0470170921, 978-0470170922

More Books

Students also viewed these Accounting questions

Question

11. Explain what dreams are, why we have them, and what they mean.

Answered: 1 week ago

Question

find all matrices A (a) A = 13 (b) A + A = 213

Answered: 1 week ago

Question

demonstrate the importance of induction training.

Answered: 1 week ago