Category : Lotus and other Spreadsheets
Archive   : FINANCE.ZIP
Filename : RATIO.WK3

Ý


Ó


Ý

­

Á





Ý



Ý




Ý



Ý




Ý
)

 .
 .
 .
 .
 .




HNC NC
  ÿ(!

 €ÿ?øÿ@
V



ðBLB
\015²








qqq'RATIO TREND ANALYSIS^|
\=

\=
\=
\=
\=
\=
\=
\=
\=
\=

\=
\=
\=

\=
\=
^|(' (Input Assumptions in Column T)^|^|'Assumptions^|\-'LIQUIDITY RATIOS -\-\-\-\-\- \-
\-\- \-
\-\-^|^|'Current Assets' Current Ratio^|'Current Liabilities' Acid Test Ratio^|'Inventories# ' Average Collection Period ^| 'Receivables
' Receivables Turnover
^|
'Annual Credit Sales ' Average Payable Period^|'Accounts Payable" ' Inventory Turnover Ratio ^| 'Purchases
^|
'Cost of Goods Sold^|'Total Debt^|'Net Worth'DEBT RATIOS -^|'Total Long Term Debt^|'Total Capitalization!' Debt to Net Worth Ratio^|'Cash Flow(' Long Term Capitalization Ratio^|'Total Liabilities.' Cash Flow to Total Liabilities Ratio^|
'EBIT+' Cash Flow to Long Term Debt Ratio^|'Depreciation^|'Interest Expense^|'Pricipal Payments^|'Tax Rate'COVERAGE RATIOS -^|'Annual Sales^|'Net Profits"' Cash Flow Coverage Ratio^|'Preferred Stock Dividend' Times Interest Earned^|"'Par Value of Preferred Stock!' Finance Charge Coverage^|'Total Tangible Assets' Debt to Equity Ratio^|'Old Number of Shares%' Debt to Total Capital Ratio^|'New Number of Shares ^|!^|"^|#'PROFITABILITY RATIOS -#^|$^|%' Gross Profit Margin%^|&' Net Profit Margin&^| '' Return on Equity (ROE)'^| (' Return on Assets (ROA)(^|)' Turnover Ratio)^|"*' Earnings Per Share (EPS)«'DEBT PERCENTAGES:«
 «
 «

 «
 «
 ¬' --------¬' --------¬
' --------¬ ' --------¬' --------­
'DEBT RETIRE CAPACITY­'REMENT CAPACITY+­Àÿÿ
&

(
.+­Àÿÿ
&

(
.+­
Àÿÿ
&

(
.+­ Àÿÿ
&

(
.+­Àÿÿ
&

(
.'¯
'CURRENT ASSETS TO SHORT TERM DEBT¯'NOTES PAYABLE ¯Àÿÿ

.¯Àÿÿ

.¯
Àÿÿ

.¯ Àÿÿ

.¯Àÿÿ

.%±
'PAYABLES TO CURRENT LIABILITIES±Àÿÿ
+
±Àÿÿ
+
±
Àÿÿ
+
± Àÿÿ
+
±Àÿÿ
+
³
'PAYABLES TO TOTAL DEBT³Àÿÿ
+
³Àÿÿ
+
³
Àÿÿ
+
³ Àÿÿ
+
³Àÿÿ
+
#µ
'SHORT TERM DEBT TO TOTAL DEBTµÀÿÿ

µÀÿÿ

µ
Àÿÿ

µ Àÿÿ

µÀÿÿ

'·
'LONG TERM DEBT TO TANGIBLE ASSETS,·Àÿÿ



,·Àÿÿ



,·
Àÿÿ



,· Àÿÿ



,·Àÿÿ



$¹
'LONG TERM DEBT TO TOTAL ASSETS$¹Àÿÿ


$¹Àÿÿ


$¹
Àÿÿ


$¹ Àÿÿ


$¹Àÿÿ


»
'DEBT/EQUITY»Àÿÿ

»Àÿÿ

»
Àÿÿ

» Àÿÿ

»Àÿÿ

½'NET WORTH PERCENTAGES:-¿
'PROFIT BEFORE TAX TO TANGIBLE NET WORTH<¿Àÿÿ
&
%


-
<¿Àÿÿ
&
%


-
<¿
Àÿÿ
&
%


-
<¿ Àÿÿ
&
%


-
<¿Àÿÿ
&
%


-
"Á
'NET INCOME TO TANGIBLE WORTHÁ'IBLE NET WORTH4ÁÀÿÿ
&


-
4ÁÀÿÿ
&


-
4Á
Àÿÿ
&


-
4Á Àÿÿ
&


-
4ÁÀÿÿ
&


-
(Ã
'FIXED ASSETS TO TANGIBLE NET WORTH4ÃÀÿÿ



-
4ÃÀÿÿ



-
4Ã
Àÿÿ



-
4Ã Àÿÿ



-
4ÃÀÿÿ



-
/Å
'CURRENT LIABILITIES TO TANGIBLE NET WORTH4ÅÀÿÿ



-
4ÅÀÿÿ



-
4Å
Àÿÿ



-
4Å Àÿÿ



-
4ÅÀÿÿ



-
-Ç
'TOTAL LIABILITIES TO TANGIBLE NET WORTH<ÇÀÿÿ




-
<ÇÀÿÿ




-
<Ç
Àÿÿ




-
<Ç Àÿÿ




-
<ÇÀÿÿ




-
É'INTEREST COVERAGE RATIOS:Ë
'INTEREST COVERAGE+ËÀÿÿ
&
%

+ËÀÿÿ
&
%

+Ë
Àÿÿ
&
%

+Ë Àÿÿ
&
%

+ËÀÿÿ
&
%

Í
'CASH FLOW COVERAGE+ÍÀÿÿ
&
(

+ÍÀÿÿ
&
(

+Í
Àÿÿ
&
(

+Í Àÿÿ
&
(

+ÍÀÿÿ
&
(

Ï
'TOTAL COVERAGE8ÏÀÿÿ
&
%

'
8ÏÀÿÿ
&
%

'
8Ï
Àÿÿ
&
%

'
8Ï Àÿÿ
&
%

'
8ÏÀÿÿ
&
%

'
Ñ
'TOTAL CASH COVERAGE8ÑÀÿÿ
&
(

'
8ÑÀÿÿ
&
(

'
8Ñ
Àÿÿ
&
(

'
8Ñ Àÿÿ
&
(

'
8ÑÀÿÿ
&
(

'
"Ó'WORKING CAPITAL PERCENTAGES:Õ
'WORKING CAPITAL TO SALES$ÕÀÿÿ


$ÕÀÿÿ


$Õ
Àÿÿ


$Õ Àÿÿ


$ÕÀÿÿ


#×
'NET INCOME TO WORKING CAPITAL$×Àÿÿ
&

$×Àÿÿ
&

$×
Àÿÿ
&

$× Àÿÿ
&

$×Àÿÿ
&

"Ù
'INVENTORY TO WORKING CAPITAL$ÙÀÿÿ


$ÙÀÿÿ


$Ù
Àÿÿ


$Ù Àÿÿ


$ÙÀÿÿ


(Û
'SHORT TERM DEBT TO WORKING CAPITAL$ÛÀÿÿ


$ÛÀÿÿ


$Û
Àÿÿ


$Û Àÿÿ


$ÛÀÿÿ


'Ý
'LONG TERM DEBT TO WORKING CAPITAL,ÝÀÿÿ



,ÝÀÿÿ



,Ý
Àÿÿ



,Ý Àÿÿ



,ÝÀÿÿ



-