M
Hi,
I'm trying to add Bizminer's Industry Financial sample data (bizminer.com/reports/samples/industry-financial.pdf) to this Peer Company Comparison sheet I'm doing:
However, many of Bizminer's terms are different from mine. Could somebody perhaps help me figure out which is which?
1. Are any of the values marked "?" to be found in the report?
2. For the EBIT, I subtracted the report's "Amort-Deprec-Depl" from its "EBITDA" -- is that valid?
3. Could the report's "Return on Net Worth" or "Return on Business Revenue" be used for my "Return on equity" or "Return on capital"?
4. Could anything in my sheet be restructured, renamed, added or removed?
Mikkel
I'm trying to add Bizminer's Industry Financial sample data (bizminer.com/reports/samples/industry-financial.pdf) to this Peer Company Comparison sheet I'm doing:

However, many of Bizminer's terms are different from mine. Could somebody perhaps help me figure out which is which?
Code:
Ratios 2006
------------------------------------
Accounts receivable $930 057
Inventory $128 913
Accounts payable $447 526
Working capital $13 201
Net fixed assets $375 383
Current ratio 1,73%
Debt to capital ?
Profitability
------------------------------------
Gross profit $2 045 427
Sales & marketing $25 018
Research & development ?
General & administration ?
Operating expenses $1 828 375
Earnings from operations ?
EBIT $217 052
Depreciation ?
EBITDA $337 411
Net earnings $154 514
Returns
------------------------------------
Return on assets 7,39%
Return on equity ?
Return on capital ?
Growth
------------------------------------
Revenue growth rate ?
Net earnings growth rate ?
2. For the EBIT, I subtracted the report's "Amort-Deprec-Depl" from its "EBITDA" -- is that valid?
3. Could the report's "Return on Net Worth" or "Return on Business Revenue" be used for my "Return on equity" or "Return on capital"?
4. Could anything in my sheet be restructured, renamed, added or removed?
Mikkel