|
|
|
|
|
|
|
|
|
|
|
POLICY VARIABLES |
1984 |
1985 |
1986 |
1987 |
1988 |
1989 |
1990 |
|
|
Capital Investment |
|
|
|
|
|
|
|
|
|
Computer/Systems |
xxxxx |
400,000 |
400,000 |
0 |
0 |
0 |
0 |
|
|
Warehouse Expansion |
xxxxx |
600,000 |
600,000 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
Sales Growth (dec., annual) |
xxxxx |
0.05 |
0.05 |
0.05 |
0.05 |
0.05 |
0.05 |
|
|
Inventory Turnover (times) |
xxxxx |
5 |
5 |
5 |
5 |
5 |
5 |
|
|
Issue New Equity ($) |
|
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
FINANCING REQUIREMENTS |
1984 |
1985 |
1986 |
1987 |
1988 |
1989 |
1990 |
|
|
Financial Gap (+borrow, -repay) |
428,364 |
849,370 |
-167,476 |
-193,031 |
-232,932 |
-258,952 |
-281,444 |
|
|
Long-Term Debt |
428,364 |
1,277,734 |
1,110,258 |
917,227 |
684,294 |
425,342 |
143,898 |
|
|
Free Cash |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
Equity |
1,191,748 |
1,216,872 |
1,089,770 |
978,326 |
1,000,135 |
1,089,067 |
1,232,507 |
|
|
|
|
|
|
|
|
|
|
|
|
FINANCIAL IMPACT |
|
Risky |
Danger |
Risky++ |
Risky++ |
Risky |
Safe |
|
|
Cost of Borrowing |
0.10 |
0.16 |
0.16 |
0.13 |
0.11 |
0.10 |
0.10 |
|
|
LTD / (LTD+EQUITY) |
0.26 |
0.51 |
0.50 |
0.42 |
0.31 |
0.19 |
0.07 |
|
|
|
|
|
|
|
|
|
|
|
|
Cashflow from Ops |
222,293 |
155,285 |
172,363 |
198,163 |
238,320 |
264,610 |
287,385 |
|
|
Oper cashflow/Interest |
|
3.63 |
0.84 |
1.12 |
2.00 |
3.52 |
6.76 |
|
|
|
|
|
|
|
|
|
|
|
|
Operating Profit Margin |
0.04 |
0.03 |
0.00 |
0.00 |
0.04 |
0.05 |
0.06 |
|
|
Net Profit Margin |
0.02 |
0.01 |
-0.04 |
-0.03 |
0.01 |
0.02 |
0.03 |
|
|
Return on Assets |
0.04 |
0.01 |
-0.05 |
-0.05 |
0.01 |
0.04 |
0.08 |
|
|
Return on Equity |
0.06 |
0.02 |
-0.12 |
-0.11 |
0.02 |
0.08 |
0.12 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|