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)