Need to compute a Working Capital Ratio using an Excel Sheet with the following

Question

Need to compute a Working Capital Ratio using an Excel Sheetwith the following balance sheet for the previous 2 years. I cannot submit a response that is not in excel format like this here:

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

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

Answer:

TRACTOR SUPPLY COMPANY CONSOLIDATED BALANCE SHEETS December 26, 2015 December 27, 2014 ASSETS Current assets: Cash and cash equivalents $                   63,813.00 $                    51,134.00 Inventories $             12,84,375.00 $              11,15,450.00 Prepaid expenses and other current assets $                   87,510.00 $                    66,444.00 Income tax receivables $                     3,763.00 $                                   -   Deferred income taxes $                   45,970.00 $                    40,962.00 Total current assets $             14,85,431.00 $              12,73,990.00 Property and equipment: Land $                   86,991.00 $                    79,571.00 Buildings and improvements $               8,14,802.00 $                6,98,462.00 Furnitures, fixtures and equipment $               5,23,383.00 $                4,53,692.00 Comp. hardware and software $               1,80,020.00 $                1,54,818.00 Construction in progress $                   38,720.00 $                    30,803.00 Property and equipment, gross $             16,43,916.00 $              14,17,346.00 Accumulated depreciation and amortization $               7,96,340.00 $                6,96,346.00 Property and equipment, net $               8,47,576.00 $                7,21,000.00 Goodwill $                   10,258.00 $                    10,258.00 Deferred income taxes $                     9,224.00 $                      8,782.00 Other assets $                   18,337.00 $                    20,541.00 Total assets $             23,70,826.00 $              20,34,571.00 Liabilities and stockholders' equity Current liabilities: Accounts payable $               4,27,249.00 $                3,70,823.00 Accrued employee compensation $                   42,684.00 $                    37,056.00 Other accrued expenses $               1,95,024.00 $                1,82,565.00 Current portion of capitallease obligations $                         878.00 $                          213.00 Income taxes payable $                     5,449.00 $                    12,436.00 Total current laibilities $               6,71,284.00 $                6,03,093.00 Revolving credit loan $               1,50,000.00 $                                   -   Capitallease obligation, less current maturities $                   16,992.00 $                      4,957.00 Deferred rent $                   84,793.00 $                    79,807.00 Other long term liabilities $                   54,463.00 $                    53,153.00 Total laibilities $               9,77,532.00 $                7,41,010.00 Stockholders' equity: Preferred stock, $1 par value; 40 shares authorized;no shares issued $                                  -   $                                   -   Common stock, $0.008 par value;400000 shares authorized at december 26, 2015 and december 27, 2014; 168974 shares issued and 134224 shares outstanding at december 26, 2015 and 167716 shares issued and 136382 shares outstanding at december 27, 2014 $                     1,352.00 $                      1,342.00 Additional paid in capital $               5,96,131.00 $                5,10,997.00 Treasury stock at cost, 34750 shares at december 26, 2015 and 31334 shares at december 27, 2014 $           -14,29,790.00 $            -11,37,085.00 Retained earnings $             22,25,601.00 $              19,18,307.00 Total stockholders' equity $             13,93,294.00 $              12,93,561.00 Total laibiltities and stockholders' equity $             23,70,826.00 $              20,34,571.00 Working capital ratio 2.21 2.11

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

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