Three Islands Investments


Click here to see a bilingual (english / french) version of the formulas. The HTML for the bilingual version of the formulas was provided by Professor Cameron Morrill of the University of Manitoba.

Appendix A Formulas

BALANCE SHEET RATIOS

1. Current Ratio

        = CA /CL

Rule of Thumb > 2 and < 5 is good

is a measure of liquidity

2. Acid Test Ratio

        = (CA - I ) /CL

Rule of Thumb > 1 is good

is a strict measure of liquidity

3. Net Tangible Assets per $1000 Debt

        = (TA - ITCAO - DC - IA - CL + STD) / (STD + LTD) X 1000

Rule of Thumb for Industrial > 2000 is good

Rule of Thumb for Utility > 1500 is good

is a measure of debtholders' protection

4. Equity per Preferred Share (in $)

        = (PSC + CSC + CS + RE + FEA) / #PS

Rule of Thumb > 2 times liquidation value in each of last five fiscal years is good

is a measure of preferred shareholders' protection

5. Equity per Common Share (in $)

        = (CSC + +CS + RE + FEA) / #CS

No meaningful Rule of Thumb

is a measure of common shareholders' protection

6. % of Capital Structure Attributable to Debtholders

        = (STD + LTD) / (STD + LTD + PSC + CSC + CS + RE + FEA)

Rule of Thumb for Industrial < 1/3 is good

Rule of Thumb for Utility < 3/5 is good

is a measure of leverage

6.a) % of Capital Structure Attributable to Debtholders*

        = (STD + LTD) / (STD + LTD + PSC + CSC + CS + RE + FEA + DITB + MI)

Rule of Thumb for Industrial < 1/3 is good

Rule of Thumb for Utility < 3/5 is good

is a measure of leverage

7. Debt to Equity Ratio

        = (STD + LTD) / (PSC + CSC + CS + RE + FEA)

Rule of Thumb for Industrial < 0.5 is good

Rule of Thumb for Utility < 1.5 is good

is a measure of leverage


Click here to return to Three Islands Investments' homepage

Appendix A Formulas (cont'd)

EARNINGS AND RETAINED EARNINGS STATEMENT RATIOS

1. Interest Coverage

        = (NEBEI - EI + MIIEOSC + AIT + TIC) / TIC

Rule of Thumb for Industrial > 3 in each of last five fiscal years is good

Rule of Thumb for Utility > 2 in each of last five fiscal years is good

is a measure of debtholders' margin of safety

1. a) Interest Coverage including Capitalized Interest

        = (NEBEI - EI + MIIEOSC + AIT + TIC) / (TIC + CIC)

Rule of Thumb for Industrial > 3 in each of last five fiscal years is good

Rule of Thumb for Utility > 2 in each of last five fiscal years is good

is a measure of debtholders' margin of safety

2. Preferred Dividend Coverage

        = (NEBEI - EI + MIIEOSC + AIT + TIC) / (TIC + PDP*)

        , where PDP* = PDP / (1 - TAXRATE)
        , where TAXRATE = AIT / (NEBEI - EI + MIIEOSC + AIT)

Rule of Thumb for Industrial > 3 in each of last five fiscal years is good

Rule of Thumb for Utility > 2 in each of last five fiscal years is good

is a measure of debtholders' margin of safety

3. Preferred and Common Dividends Payout %

        = (CDP + PDP) / NEBEI

No meaningful Rule of Thumb

is a measure of portion of earnings paid out in all dividends

4. Common Dividends Payout %

        = CDP / (NEBEI - PDP)

No meaningful Rule of Thumb

is a measure of portion of earnings paid out in common dividends

5. Gross Profit Margin

        = (NS - COGS) / NS

No meaningful Rule of Thumb

is a measure of efficiency turning goods over at a profit

6. Operating Profit Margin

        = (NS - COGS - SAGE) / NS

No meaningful Rule of Thumb

is a measure of efficiency turning goods over at a profit

7. Net Profit Margin

        = (NEBEI - EI + MIIEOSC) / NS

No meaningful Rule of Thumb

is a measure of efficiency turning goods over at a profit


Click here to return to Three Islands Investments' homepage

Appendix A Formulas (cont'd)

COMBINED RATIOS

1. Pre-Tax Return on Invested Capital

        = (NEBEI + AIT + TIC) / (STD + LTD + PSC + CSC + RE + CS + FEA)

No meaningful Rule of Thumb

is a measure of how well management employed the capital at its disposal

2. Net Return on Invested Capital

        = (NEBEI + (TIC X (1 - TAXRATE))) / (STD + LTD + PSC + CSC + RE + CS + FEA)

No meaningful Rule of Thumb

is a measure of how well management employed the capital at its disposal

3. Net Return on Common Equity

        = (NEBEI - PDP) / (CSC + RE + CS + FEA)

No meaningful Rule of Thumb

is a measure of how well management employed common shareholders' capital

4. Cash Flow to Total Debt Ratio

        = (NEBEI - EI + MIIEOSC + DITE + D + A) / (STD + LTD)

Rule of Thumb for Industrial > 0.3 in each of last five fiscal years is good

Rule of Thumb for Utility > 0.2 in each of last five fiscal years is good

is a measure of ability to repay borrowed funds

5. Earnings per Common Share (in $)

        = (NEBEI - PDP) / #CS

No meaningful Rule of Thumb

is a measure of earnings, expressed on a per share basis

6. Inventory Turnover (in days)

        = 365 / (COGS / I)

No meaningful Rule of Thumb

is a measure of the number of days to turn over existing inventory


Click here to return to Three Islands Investments' homepage

Appendix A Formulas (cont'd)

VALUE RATIOS

1. Yield on Preferred Shares

        = PDP / #PS / ((MPPH + MPPL) / 2)

No meaningful Rule of Thumb

is a measure of return on investment, in dividends for preferred shareholders

2. Yield on Common Shares

        = CDP / #CS / ((MPCH + MPCL) / 2)

No meaningful Rule of Thumb

is a measure of return on investment, in dividends for common shareholders

3. Price Earnings Ratio

        = ((MPCH + MPCL) / 2) / ((NEBEI - PDP) / #CS)

No meaningful Rule of Thumb

is a measure of price per share over earnings per share


Click here to return to Three Islands Investments' homepage

Appendix A Formulas (cont'd)

LEGEND

CA        Current Assets
I         Inventories
DC        Deferred Charges
IA        Intangible Assets
ITCAO     Investment Tax Credits and Other Assets
TA        Total Assets

CL        Current Liabilities
STD       Short Term Debt
DITB      Deferred Income Taxes from Balance Sheet
MI        Minority Interest
LTD       Long Term Debt

PSC       Preferred Share Capital
CSC       Common Share Capital
CS        Contributed Surplus
RE        Retained Earnings
FEA       Foreign Exchange Adjustment
PDIA      Preferred Dividends in Arrears

NS        Net Sales
COGS      Cost of Goods Sold
SAGE      Selling, Administrative, and General Expenses
D         Depreciation Expense
A         Amortization Expense
CIC       Capitalized Interest Charges
TIC       Total Interest Charges (does not include Capitalized Interest Charges)
DITE      Deferred Income Taxes from Earnings Statement
AIT       All Income Taxes (includes Current and Deferred Income Taxes)
MIIEOSC   Minority Interest in Earnings of Subsidiary Companies
EI        Equity Income
NEBEI     Net Earnings Before Extraordinary Items
PDP       Preferred Dividends Paid
PDP*      Preferred Dividends Paid adjusted for tax
CDP       Common Dividends Paid


MPCH      Market Price of Common High
MPCL      Market Price of Common Low
MPPH      Market Price of Preferred High
MPPL      Market Price of Preferred Low
#CS       Number of Common Shares Outstanding
#PS       Number of Preferred Shares Outstanding


Click here to return to Three Islands Investments' homepage