This cash ratios calculator uses operating cash flow instead of net income to calculate three financial ratios. Unlike net income, cash flow is an objective measure of performance which cannot be manipulated or distorted using accounting assumptions and opinions.
A vertical analysis shows each line of financial statements as a percentage of a base line item so that comparisons can be made. This free Excel calculator produces a vertical analysis of an income statement in relation to total revenue, and of a balance sheet in relation to total assets.
It is quite feasible for a business to show a healthy balance sheet and be profitable, but if it runs out of cash it will fail.
The balance sheet only shows the position at a particular point in time, and the income statement deals in profit not cash. The purpose of the business cash flow analysis is to correct this situation.
Income statement analysis can be carried out using ratios based on information contained within the income statement. Understanding how to read a income statement and regular monitoring of the income statement ratios provides owners and management with a useful tool to help them manage their business more effectively.
By analyzing the income statement a business is able to see how it is performing relative to earlier accounting periods, and how its performance compares to other businesses in the industry.
Balance sheet ratio analysis can be carried out using ratios based on information contained within the balance sheet. Knowing how to analyze a balance sheet gives the reader a better understanding of a business, allows changes over time to be monitored, and allows comparisons of different businesses to be made.
The common size income statement shows each line of a standard income statement as a percentage of the total revenue (sales) of a business.
This free Excel calculator produces a common size income statement from standard information taken from the income statement of a business.
A common size income statement is one that has an additional column showing each monetary amount as a percentage of the total revenue of the business. The common size income statement is not required by Accounting Standards, and is used more as a management tool rather than a formal reporting document.
A common size balance sheet is one that has an additional column showing each monetary amount as a percentage of the total assets of the business. The common size balance sheet is not required by Accounting Standards, and is used more as a management tool rather than a formal reporting document.