Excel Sheet for Dynashears

Excel Sheet for Dynashears - Dynashears 1990-1991 Sill...

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

View Full Document Right Arrow Icon
Dynashears 1990-1991 Sill *Thousands of Dollars 1990 1991 Column1 June  July  Aug. Sept.  Oct. Nov.  Dec. Jan. Feb. Mar. Column2 Current Ratio= Current Assets / Current Liabilities Current Assests 10,705 10584.00 10886.00 11355.00 11762.00 11357.00 11057.00 10448.00 9925.00 9504.00 Current Liabilities 983 2087.00 3524.00 4121.00 3939.00 3078.00 3012.00 2280.00 1722.00 1586.00 Current Ratio 10.9 5.10 3.10 2.80 3.00 3.70 3.70 4.60 5.80 6.00    Inventory  7,049 7285.00 7220.00 6924.00 6242.00 5829.00 5652.00 6020.00 6233.00 6410.00 Debt to Equity= (Current Liabilities+Mortgage)/(Common Stock and Earned Surplus) Current Liabilities  983 2087.00 3524.00 4121.00 3939.00 3078.00 3012.00 2280.00 1722.00 1586.00 Mortgage 10400 10400.00 10400.00 10400.00 10400.00 10400.00 10140.00 10140.00 10140.00 10140.00 Common Stock 10000 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 Earned Surplus 10682 10795.00 11025.00 11050.00 11647.00 12090.00
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/26/2008 for the course AEM 2220 taught by Professor Perez,p.d. during the Spring '06 term at Cornell.

Ask a homework question - tutors are online