Access over 20 million homework & study documents

Trial Balance Accounting Notes Worksheets

Content type
User Generated
Subject
Excel
Type
Worksheet
Rating
Showing Page:
1/14

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/14

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/14

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 14 pages?
Access Now
Unformatted Attachment Preview
CURRENT RATIO = CURRENT ASSETS/CURRENT LAIBILTES CA 2005 2004 2003 2002 2001 CL 8.7 7.5 6.3 4.7 4.2 CR 5 4.9 4.2 3.2 2.5 1.74 1.530612245 1.5 1.46875 1.68 DEBT EQUITY RATIO =SHORT TERM DEBTS+LONG TERM DEBTS /SHARE CAPITAL+RESER ST 2005 2004 2003 2002 2001 LT 2.6 2.5 2.1 1.4 1.2 SC 2.8 2.3 2 1.3 1.2 R&S 3.2 3 3 2.4 2.4 2.5 2 1.5 1 0.6 DER 0.947 0.96 0.911 0.794 0.8 TOTAL ASSETS TURNOVER RATIO=SALES/NET ASSETS OR AVG TOTAL ASSETS 2005 2004 2003 2002 2001 SALES NET ASSETS TATR 11.2 13.5 0.82962963 9.1 12.2 0.745901639 7.8 10.7 0.728971963 6.1 7.9 0.772151899 4 6.7 0.597014925 NET PROFIT MARGIN=PROFIT AFTER TAX / NET SALES PAT SALES NPM 2005 0.7 11.2 0.0625 2004 0.5 9.1 0.054945055 2003 0.3 7.8 0.038461538 2002 2001 0.4 0.2 6.1 4 0.06557377 0.05 EARNINGS PER SHARE=EARNINGS OR PROFIT BEFORE TAX/TOTAL ASSETS EBIT 2005 2004 2003 2002 2001 TA 2 1.3 1 1.1 0.5 13.5 12.2 10.7 7.9 6.7 EP 0.148148148 0.106557377 0.093457944 0.139240506 0.074626866 RETURN ON EQUITY=PROFIT AFTER TAX/SHARE CAPITAL+RESERVES & SURPLUS 2005 2004 2003 2002 2001 PAT SE 0.7 0.5 0.3 0.4 0.2 R&S 3.2 3 3 2.4 2.4 2.5 2 1.5 1 0.6 ROE 0.122807018 0.1 0.066666667 0.117647059 0.066666667 RE CAPITAL+RESERVES & SURPLUS 1 Particulars Ram Cash A/C Discount A/C Cash A/C Discount A/C Suresh Cash A/C Land A/C Furniture A/C Stock A/C To Creditors To Bank Overdraft To Capital A/C Dr Cr 1050 1000 50 800 50 850 2000 4000 1000 2000 1000 2000 6000 Journal Entry Dr=Cr Dr 1 Cash A/C To Capital 2 ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Just what I was looking for! Super helpful.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Documents