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 readingCategory Archives: 4 Reporting
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 readingCalculating 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 readingCalculating 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 readingCalculating 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 readingCalculating 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 readingCalculating 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