Butler Lumber Excel Sheet - 37 Days 40 Days 43 Days 43 Days...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Butler Lumber Co.  Sill 1988 1989 1990 1st Quart. 1991 Current Ratio= Current Assets/Current Liabilities Current Asset 468 596 776 932 Current Liabil 260 375 535 690 Current Ratio 1.8 1.6 1.5 1.4 Acid Test Ratio= Current Assets-Inventories/Current Liabilities  Current Asset 468 596 776 932 Inventories  239 326 418 556 Current Liabil 260 375 535 690 Acid Test Ra 0.88 0.72 0.67 0.54 Account Receivable Ratio= Sales/Acct. Receivable Account Rece 171 222 317 345 Sales 1697 2013 2694 718 Account Rec 9.9 9.1 8.5 2.1 Days to Receive Cash=365/A.R. Turnover
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 37 Days 40 Days 43 Days 43 Days Inventory Turnover= CGS/Ave. Inventory CGS 1222 1437 1950 522 211 283 372 487 Inventory Tu 5.8 Times 5.1 Times 5.2 Times 1.1 Times Average Sale Period= 365/Inven. Turnover 63 Days 72 Days 70 Days 83 Days Accounts Payable Ratio= Accounts payable/CGS Accounts Pay 124 192 256 243 CGS 1222 1437 1950 522 Accounts Pa 0.1 0.13 0.13 0.5 Average Inven...
View Full Document

Ask a homework question - tutors are online