Answered step by step
Verified Expert Solution
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.
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 212Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started