Solved by verified expert :Financial
Ratios
Company
Name: Joyner Lumber Company, Inc.
Amounts In: ($ in Summary)
Period:
Statement Type:
Forecast
Date:
31/12/1987
31/12/1988
31/12/1989
31/12/1990
########
31/12/1991
Financial Summary
Current Assets
871,783
1,043,918
1,174,264
1,022,167
1,096,410
Current Liabilities
345,048
342,363
403,917
270,714
269,763
Total Assets
1,385,633
1,453,842
1,528,072
1,712,919
1,790,348
Total Liabilities
385,737
382,846
433,003
331,264
350,240
Total Net Worth
999,896
1,070,996
1,095,069
1,381,655
1,440,108
Working Capital
526,735
701,555
770,347
751,453
826,647
Working Assets
600,360
602,656
712,751
879,726
940,551
Working Liabilities
219,375
197,856
246,849
259,463
235,201
Working Investment
380,985
404,800
465,902
620,263
705,350
Long Term Debt
40,689
40,483
29,086
60,550
80,477
Tangible Net Worth
999,896
1,070,996
1,095,069
1,381,655
1,440,108
Average Annual Long-term Debt
Maturities
10,000
10,000
10,000
10,000
10,000
Net Sales
2,832,803
3,148,875
3,403,999
3,283,010
1,345,370
Net Income
90,804
79,952
43,810
286,586
67,697
Liquidity/Activity
Ratios
Current Ratio (x)
2.53
3.05
2.91
3.78
4.06
Quick Ratio (x)
1.72
2.21
2.17
2.68
2.88
Cash Flow Liquidity Ratio (x)
1.67
0.07
1.27
0.33
Accounts Receivable (x)
8.83
10.02
8.17
5.62
2.16
Accounts Receivable (Days)
41.32
36.43
44.70
64.91
168.64
Inventory Turnover vs COGS
(x)
7.22
7.83
8.14
7.90
3.08
Inventory Turnover vs Aver
Sales (Days)
36
33
32
33
87
Accounts Payable vs COGS
(Days)
29
24
32
38
76
Accounts Payable vs Aver
Sales (Days)
21
17
23
27
56
Cash Conversion Cycle (Days)
57
53
54
71
199
Leverage Ratios
Debt Ratio (%)
27.8%
26.3%
28.3%
19.3%
19.6%
Long-term Debt to Total
Capitalization (%)
3.9%
3.6%
2.6%
4.2%
5.3%
Debt to Worth (x)
0.39
0.36
0.40
0.24
0.24
Debt to Tangible Net Worth
(x)
0.39
0.36
0.40
0.24
0.24
Times Interest Earned (x)
Fixed Charge Coverage (x)
Cash Flow Adequacy (x)