Example Data Table
| Input |
Example Value |
Purpose |
| Cash |
$45,000 |
Current asset balance |
| Accounts receivable |
$38,000 |
Customer amounts due |
| Inventory |
$52,000 |
Stock held for sale |
| Long term debt |
$95,000 |
Main noncurrent liability |
| Revenue |
$420,000 |
Sales for EBITDAH calculation |
| H adjustment |
$6,000 |
Custom add-back for EBITDAH |
Formula Used
Current Assets = Cash + Accounts Receivable + Inventory + Prepaid Expenses + Other Current Assets
Noncurrent Assets = Property and Equipment + Intangible Assets + Long Term Investments + Other Noncurrent Assets
Total Assets = Current Assets + Noncurrent Assets
Current Liabilities = Accounts Payable + Short Term Debt + Accrued Expenses + Deferred Revenue
Noncurrent Liabilities = Long Term Debt + Lease Liabilities + Other Liabilities
Total Liabilities = Current Liabilities + Noncurrent Liabilities
Calculated Equity = Total Assets - Total Liabilities
Balance Gap = Total Assets - Total Liabilities - Entered Equity
Gross Profit = Revenue - Cost of Goods Sold
EBIT = Gross Profit - Operating Expenses - Depreciation - Amortization
Net Income = EBIT - Interest Expense - Taxes
EBITDA = EBIT + Depreciation + Amortization
EBITDAH = EBITDA + H Adjustment
Current Ratio = Current Assets / Current Liabilities
Debt To Equity = Total Liabilities / Entered Equity
EBITDAH Margin = EBITDAH / Revenue × 100
How To Use This Calculator
Enter the company name, period, currency, and decimal places first.
Add current assets, noncurrent assets, liabilities, and equity balances.
Enter revenue, costs, expenses, depreciation, amortization, interest, and taxes.
Name the H adjustment clearly, then enter its amount.
Press Calculate to view the balance sheet and EBITDAH result.
Use Download CSV for spreadsheet work.
Use Download PDF for a printable summary.
Understanding the Balance Sheet and EBITDAH
Assets
A balance sheet shows what a business owns. It also shows what it owes. The difference is equity. This calculator places those items in one view. Assets include cash, receivables, inventory, prepaid costs, and other short term items. Noncurrent assets include equipment, investments, intangibles, and long term resources. These totals show the capital base used by the company.
Liabilities
Liabilities show claims against that capital. Current liabilities are due soon. They include payables, short term debt, accrued expenses, and deferred revenue. Long term debt, lease obligations, and other liabilities are shown separately. The tool then compares assets with liabilities and entered equity.
Equity Checks
Equity can be entered from shares, paid in capital, and retained earnings. The calculated equity is assets minus liabilities. A gap appears when entered equity does not match the accounting equation. That gap helps you spot missing accounts, data entry errors, or unfinished adjustments.
EBITDAH Meaning
EBITDAH adds another layer. It starts from operating performance. Revenue minus cost of goods sold gives gross profit. Operating expenses, depreciation, and amortization reduce profit. Adding back interest, taxes, depreciation, amortization, and the selected H adjustment gives EBITDAH. The H adjustment is flexible. It may represent holding costs, headquarters costs, honorarium costs, or another add back used by your model. Use it only when the item is clearly defined. Consistent labels make reports easier to review.
Helpful Ratios
Ratios make the output useful. Current ratio compares current assets with current liabilities. Working capital measures short term cushion. Debt to equity compares outside claims with owner claims. EBITDAH margin shows operating cash style profit as a share of revenue.
Careful Use
Use the result as a planning aid. It is not a formal audit. Review every source figure. Match totals against accounting records. Keep assumptions documented. Download the CSV for spreadsheets. Download the PDF for meetings. Clear records support better decisions. Strong controls improve the model. Separate normal operations from unusual items. Avoid adding back recurring costs without a reason. Compare several periods when possible. A single period can hide trends. Use the same currency for every entry. Round only after calculations. This keeps margins, ratios, and balance checks more reliable overall each period.
FAQs
What does this calculator show?
It shows a balance sheet summary, equity check, EBITDAH, margins, and important finance ratios. It also highlights any balance gap.
What is EBITDAH?
EBITDAH is EBITDA plus a custom H adjustment. The H item should be clearly defined before you use it in reporting.
Is EBITDAH the same as net income?
No. Net income includes interest, taxes, depreciation, and amortization. EBITDAH adds selected items back to compare operating performance.
Why does the balance gap appear?
The gap appears when assets do not equal liabilities plus entered equity. It can indicate missing accounts or incorrect figures.
Can I use negative values?
Yes. Negative values can be entered for losses, contra accounts, adjustments, or corrections. Review them carefully before relying on results.
What should I enter as the H adjustment?
Enter a clearly named add-back, such as holding costs or headquarters costs. Use the same rule each period for better comparison.
Does the PDF contain all results?
Yes. The PDF includes the main calculated summary. The CSV is better for deeper spreadsheet analysis.
Is this suitable for audited statements?
Use it as a planning and review tool. Formal statements should be checked by qualified finance or accounting professionals.