Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need to compute a debt to total assets ratio using an excel spreadsheet using the attached balance sheet for the most recent 2 years. Thanks!!

Need to compute a debt to total assets ratio using an excel spreadsheet using the attached balance sheet for the most recent 2 years. 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

Managerial Accounting

Authors: Peter Brewer, Ray Garrison, Eric Noreen, Suresh Kalagnanam, Ganesh Vaidyanathan

5th Edition

1259256081, 978-1259256080

More Books

Students also viewed these Accounting questions

Question

What are the major global trends your industry faces?

Answered: 1 week ago