Financial history & ratios
Enter your Company Name here
In Thousands Fiscal Year Ends Jun-30
RMA Average % Current: from mm/yyyy to mm/yyyy
%
2000
%
1999
%
1998
%
Assets Cash/ Equivalents Trade Receivables Inventory Value All other current Total Current Assets Fixed Assets (net) Intangibles (net) All other Total Assets Liabilities/ Equity Notes payable (ST) Current L. T. Debt Trade Payables Income Tax Payable All other current Total Current Liabilities Long-term Debt Deferred Taxes All other noncurrent Net Worth Total Liabilities & Net Worth Income Data Net Sales Cost of Sales (COGS) Gross Profit Operating Expenses Operating Profit All other expenses Pre-tax Profit Ratio Analysis Current Ratio Inventory Turnover Debt/ Net Worth % Return on Tang. N/W % Return on Assets
$
-
0.00% %
$
-
0.00%
$
-
0.00%
$
-
0.00%
$
$
$
$
$
-
0.00% % 100.00% -
$
-
0.00%
$
-
0.00%
$
-
0.00%
Notes on Preparation Note: You may want to print later. To delete these instruc and then press the DELETE
The value of a spreadsheet i place to facilitate comparison your past three years' financ date statements, if available, to fit into this format:
1] Compress your chart of ac doubt, have many more lines Combine categories to fit you
$
-
$
-
$
-
$
-
$
-
$
-
100.00% -
$
-
100.00% -
$
-
100.00% -
2] Condense the numbers fo recommend that you expre rounding to the nearest $1 $3.3.
$
$
$
$
0.0 0.0 0.0 0.00% 0.00%
-
-
-
-
3] Fill in the "RMA Avg." colu a. "RMA" refers to the book S by Robert Morris Associates Management Association. Th sorted by type of business an for bankers and financial ana or ask your banker. b. Enter the percentages and of business in the "RMA Avg of our spreadsheet is exactly book. c. Note that for some of the r numbers. These are the med range; i.e.: the "average"), th