Using Target and Walmart . Ratios should be calculated using the two most recent completed years. Make sure to include a link to the financial statements you are using.

Investors and lenders who read financial statements must determine the age, composition, and productivity of operating assets.

Required

For each company, determine:

(Replicate the five steps in the Ratio Analysis Model to perform the analysis.)

1. Formulate the Question
2. Gather the Information from the Financial Statements
3. Calculate the Ratio
4. Compare the Ratio with Other Ratios
5. Interpret the Ratios

Fiscal years February-January. All values USD Millons. 2020 2019 2018 2017 2016 5-year trend Cach Short Term Investments 9465 7.756 6.756 6.867 8.705 Cash Only 9465 7.756 6.756 6.867 8.705 Cach Short Term Investments Growth 22.03% 14.80 -1.62% Cach ST Investments/Total Assets 4.00% 3.545 3.30 3.45% 4.36% Total Accounts Receivable 6,284 6.283 5.614 5.835 5624 Accounts Receivables, Net 6,284 6.283 5.614 5835 5.624 Accounts Receivables, Groes 6,284 6.283 5.614 5914 5694 Bed Debt/Doubtful Accounts (79) 79) (70) Accounts Receivable Growth 11.925 -3.79% 3.75% Accounts Receivable Turnover 83.38 8187 89.05 83.14 85.73 Inventories 44435 44.269 43.783 43,046 44.469 Finished Good: 44 435 44.269 43.783 43,046 44469 Other Current Assets 1622 3589 3511 1.941 1441 Miscellaneous Current Assets 1622 3589 3511 1.941 1441 Total Current Assets 61,806 61.897 59664 57.689 60.239 Net Property, Plant Equipment 127,049 111395 114.818 114,178 116516 Property, Plant & Equipment- Gross 216.869 198.970 197,857 191.129 188,054 Buildings 105.674 101.006 101155 98.547 96,845 Land 6 Improvement: 24.619 24526 25.298 24,801 25624 Construction in Progress 3.751 3.619 4301 4539 4.417 12.750 12.703 11.637 11,096 Trensportation Equipment 2.316 2.387 2,845 2917 Other Property, Plant & Equipment 58,607 54,488 52.695 48.998 47033 Accumulated Depreciation 89.820 87,175 83039 76.951 71538 Total Investments and Advances 5438 Other Long-Term investments 5438 Intangible Assets 36.273 31,181 18.242 17.037 17.093 Net Goodwill 31.073 31,181 18.242 17.037 16,695 Net Other Intangibles 5.200 398 Other Assets 4015 13,026 9.919 8.356 Tangible Other Assets 4,015 13.026 9.919 8.356 Total Assets 236.495 219.295 204522 198,825 199581 Assets-Total-Growth 7845 Ascet Turnover 2.30 Return On Average Assets 6.53% Llabilities & Shareholders' Equity