SRA-Standard Ratio Analysis
 Copyright 2013 BusinessAllstars.com - All Rights Reserved
XL    Name          Date             
Account
Yr new
Calculations
Ratios
Net Sales (Rev) $ Inv / (COGS / 365) d
Cost of Goods Sold (COGS) $ A/R / (Rev / 365) d
E.B.I.T. (EBIT) $ A/P / (COGS / 365) d
Income Tax Expense (Tax) $ Inv days + A/R days - A/P days d
Net Income (NI) $ Rev / TA X
Net Accounts Recievable (A/R) $ C/A / C/L X
Inventory (Inv) $ (C/A - Inv) / C/L X
Current Assets (CA) $ (Rev - COGS) / Rev %
Total Assets (TA) $ EBIT / Rev %
Accounts Payable (A/P) $ NI / Rev %
Current Liabilities (CL) $ NI / TA %
Long-Term Debt (LTD) $ NI / Com Equity %
Common Equity (Com Equity) $ LTD / (LTD + CE) %
Market Capitalization (Mkt) $ Mkt / NI X
Number of Shares Outsanding (Shrs) $ NI / Shrs $
Dividends Paid (Div) $ Div / NI %
Calculations
Mkt / CE X
Tax / (Tax + NI) % Mkt / Sales X
EBIT / (EBIT - Tax - NI) X Div / Mkt %


Enter Inputs in the YELLOW boxes