Description
FRCashFlowVsTotalDebt returns the ratio between CashFlow and TotalDebt.
Format
FRCashFlowVsTotalDebt(CashFlow, TotalDebt)
Arguments
CashFlow is a Number or formula. In general, CashFlow equals the net profit of the company plus all the expense items not involving cash (such as depreciation, capital losses, and so on) and minus all the profit not involving cash (such as capital gains, and so on). This information can be found in a company's income statement and statement of change in financial position.
TotalDebt is a Number or formula. In general, TotalDebt is the total short term and long term bank borrowings. Some analysts may even include all the short and long term liabilities as part of total debt. All this information can be found in a company's income statement.
Action
FRCashFlowVsTotalDebt returns the ratio between CashFlow and TotalDebt (for example, CashFlowVsTotalDebt = CashFlow / TotalDebt).
Typical uses
This ratio is used to measure the ability of a company to pay off its total debts with cash flows generated from operations. It is usually measured in number of times. The higher the result, the higher the ability for the company to pay off its debts.
Examples
FRCashFlowVsTotalDebt(45, 30)
Returns 1.5.
FRCashFlowVsTotalDebt(74.4, 93)
Returns 0.8.
None of the arguments can be negative; you may have to check for negative values before passing the arguments.
Comments
FRCashFlowVstotalDebt is one of the many financial analysis tools used in interpreting the financial position of a company. As in the case of all ratios, it has to be used with caution. It can just be used as a clue and not solid proof for forming a judgment on the financial status of a company.
Neither one of the ratios can be used alone for doing financial analysis and there are no fixed rules on the results of the ratios. Apart from differences between type of industries, result varies among different companies within the same industry and within different account periods. The results should only be used for relative comparison and trend analysis, rather than treating them as something absolute.