Operating profit margin shows the ratio of operating profit to sales revenue. To calculate operating profit margin open your income statement and divide operating profit with revenue

Continue reading# Category Archives: Financials

# Calculating Debt Ratio in Excel

Debt ratio shows how much the company relies on external resources to finance its assets. To calculate debt ratio open your balance sheet and divide liabilities with assets

Continue reading# Calculating Cash Flow Coverage Ratio in Excel

Cash flow coverage ratio shows how many times the financial liabilities of a company are covered by its operational cash flows. To calculate cash flow coverage ratio open your statement of cash flows and balance sheet. Divide net cash generated from operating activities from statement of cash flows with borrowings from balance sheet

Continue reading# Calculating Debt-to-Equity Ratio in Excel

Debt-to-equity ratio shows much of assets are financed with shareholders equity and how much with external financing. To calculate debt-to-equity ratio open your balance sheet and divide liabilities with shareholder’s equity

Continue reading# Calculating Quick Ratio in Excel

Quick ratio shows company’s ability to meet its short-term obligations using its most liquid assets. To calculate quick ratio open your balance sheet, subtract inventory from total current assets and divide the result with the total of current liabilities.

Continue reading# Calculating Current Ratio in Excel

Current ratio measures the resources currently in the possession of the company and their sufficiency in relation to the debt of the company. To calculate current ratio open your balance sheet and divide total of current assets with the total of current liabilities

Continue reading# Calculating Working Capital in Excel

Working capital shows how much the current assets exceed current liabilities. To calculate working capital open your balance sheet, subtract total current liabilities from the total current assets

Continue reading