Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need to compute a Working Capital Ratio using an Excel Sheet with the following balance sheet for the previous 2 years. I cannot submit a

Need to compute a Working Capital Ratio using an Excel Sheet with 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!!!

image text in transcribedimage text in transcribed

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

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

Efficient Auditing Of Private Companies A Guide To Audit Planning Implementation And Control

Authors: The Institute Of Chartered Accountants

1st Edition

1841400432, 978-1841400433

More Books

Students also viewed these Accounting questions