Need to compute a working capital r atio using an excel spreadsheet with the att

Question

Need to compute a working capital ratio using an excel spreadsheet with the attached balance sheet. Thanks!

TRACTOR SUPPLY COMPANY CONSOLIDATED BALANCE SHEETS (in thousands, except per share amounts) December 26, December 27, 2015 2014 ASSETS Current assets Cash and cash equivalents Inventories Prepaid expenses and other current assets Income taxesreceivable Deferred income taxes S 63,813 S 51,134 1,284,3751,115,450 66,444 87,510 3,763 45,970 1,485,431 40,962 Total curent assets 1,273,990 Property and equipment Land Buildings andimprovements Fumiture, fixtures andequupment Computer software and hardware Construction in progress 86,991 814,802 523,383 180,020 38,720 1,643,916 79,571 698,462 453,692 154,818 30,803 1,417,346 Property and equipment, gross Accumulated depreciation and amortization (796,340 (69 96,340) (696,346) Property and equipment, net Goodwill Deferred income taxes Other assets 721,000 10,258 8,782 20,541 S 2,370,826 $ 2,034,571 847,576 10,258 9,224 18,337 Totalassets

Explanation / Answer

Working Capital Ratio = Current Assets/ Current Liabiliites

Working capital Ratio for 2014 = 1273990 / 603093 = 2.11

Working capital Ratio for 2015 = 1485431 / 671284 = 2.21

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.