|
|||||||||||||||
| Bean Counter | |||||||||||||||
| https://www.dwmbeancounter.com | |||||||||||||||
| Financial Analysis By Year | |||||||||||||||
| Financial Statements | |||||||||||||||
| RATIO ANALYSIS | Description | CY | PY | PY-1 | |||||||||||
| Profitability Ratios | CY | PY | Activity Ratios | CY | PY | Amount | Pctg | Amount | Pctg | Amount | Pctg | ||||
| Return on Total Assets | 0.0% | 0.0% | Accounts Receivable Turnover | 0.00 | 0.00 | % | % | % | |||||||
| Return on Fixed Assets | 0.0% | 0.0% | Accounts Receivable Collection Days | 0.00 | 0.00 | Income Statement | |||||||||
| Return on Equity | 0.0% | 0.0% | Inventory Turnover | 0.00 | 0.00 | Net Sales (Revenue) | 0.0% | 0.0% | 0.0% | ||||||
| Gross Margin % | 0.0% | 0.0% | Days of Inventory | 0.00 | 0.00 | Cost of Goods Sold | 0.0% | 0.0% | 0.0% | ||||||
| Return On Sales | 0.0% | 0.0% | Accounts Payable Turnover | 0.00 | 0.00 | Gross Profit | - | 0.0% | - | 0.0% | - | 0.0% | |||
| (Net Profit Margin) | Accounts Payable Payment Days | 0.00 | 0.00 | Operating Expenses | 0.0% | 0.0% | 0.0% | ||||||||
| Liquidity Ratios | CY | PY | Solvency Ratios | CY | PY | Earnings Before Interest & Taxes | - | 0.0% | - | 0.0% | - | 0.0% | |||
| Cash Ratio | 0.00 | 0.00 | Times Interest Earned | 0.00 | 0.00 | Interest Expense | 0.0% | 0.0% | 0.0% | ||||||
| Quick Ratio | 0.00 | 0.00 | Debt To Total Assets | 0.00% | 0.00% | Tax Expense | 0.0% | 0.0% | 0.0% | ||||||
| Current Ratio | 0.00 | 0.00 | Debt To Equity | 0.00% | 0.00% | Net Income | - | 0.0% | - | 0.0% | - | 0.0% | |||
| Working Capital | $ - | $ - | |||||||||||||
| Balance Sheet | |||||||||||||||
| Cash | 0.0% | 0.0% | 0.0% | ||||||||||||
| Calculation Formulas | Short Term Investments | 0.0% | 0.0% | 0.0% | |||||||||||
| Accounts Receivable | 0.0% | 0.0% | 0.0% | ||||||||||||
| 1. Liquidity Ratios and Metrics | Prepaid Expenses | 0.0% | 0.0% | 0.0% | |||||||||||
| Liquidity ratios measure a company's ability to pay off short-term debts as they become due, using the company's current or quick assets. | Inventory | 0.0% | 0.0% | 0.0% | |||||||||||
| Current Assets | - | 0.0% | - | 0.0% | - | 0.0% | |||||||||
| Cash Ratio = Cash / Current Liabilities | Net Fixed Assets | 0.0% | 0.0% | 0.0% | |||||||||||
| Quick Ratio = (Cash + Marketable Securities + Net-Accounts Receivable) / Current Liabilities | Other Assets | 0.0% | 0.0% | 0.0% | |||||||||||
| Current ratio = Currents Assets / Current Liabilities | Total Assets | - | 0.0% | - | 0.0% | - | 0.0% | ||||||||
| Working Capital = Currents Assets - Current Liabilities | Accounts Payable | 0.0% | 0.0% | 0.0% | |||||||||||
| Other Liabilties | 0.0% | 0.0% | 0.0% | ||||||||||||
| 2. Solvency Ratios | Current Liabilities | - | 0.0% | - | 0.0% | - | 0.0% | ||||||||
| Also called financial leverage ratios, solvency ratios compare a company's debt levels with its assets, equity, and earnings . | Long Term Liabilities | 0.0% | 0.0% | 0.0% | |||||||||||
| These are used to evaluate the likelihood of a company staying afloat over the long haul by paying off both long-term debt | Total Liabilities | - | 0.0% | - | 0.0% | - | 0.0% | ||||||||
| and the interest on that debt. | |||||||||||||||
| Total Equity | 0.0% | 0.0% | 0.0% | ||||||||||||
| Times Interest Earned = Earnings Before Interest and Taxes / Interest | Total Liabilities & Equity | - | 0.0% | - | 0.0% | - | 0.0% | ||||||||
| Debt To Total Assets = Total Debt / Total Assets | |||||||||||||||
| Debt To Equity = Total Equity / Total Assets | |||||||||||||||
| 3. Profitability Ratios | |||||||||||||||
| These ratios convey how well a company can generate profits from its operations. | |||||||||||||||
| Return on Total Assets = Net Income / Average Total Assets | |||||||||||||||
| Return on Fixed Assets = Net Income / Average Fixed Assets | |||||||||||||||
| Return on Equity = Net Income / Average Equity | |||||||||||||||
| Gross Margin % = Gross Profit / Net Sales | |||||||||||||||
| Return On Sales = Net Income / Net Sales | |||||||||||||||
| (Net Profit Margin) | |||||||||||||||
| 4. Activity Ratios | |||||||||||||||
| Also called efficiency ratios evaluate how efficiently a company uses its assets and liabilities to generate sales and maximize profits. | |||||||||||||||
| Accounts Receivable Turnover = Net Sales / Average Net Accounts Receivable | |||||||||||||||
| Accounts Receivable Collection Days = Average Accounts Receivable / Net Credit Sales X 35 | |||||||||||||||
| Inventory Turnover = Cost Of Goods Sold / Average Inventory | |||||||||||||||
| Days of Inventory = Average Inventory / Cost Of Goods Sold X Number of Days In Period | |||||||||||||||
| Accounts Payable Turnover = Cost Of Goods Sold / Average Accounts Payable | |||||||||||||||
| or Net Credit Purchases / Average Accounts Payable (Preferred Method) | |||||||||||||||
| Accounts Payable Payment Days = Average Inventory / Cost Of Goods Sold X Number of Days In Period | |||||||||||||||