|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|