Calculator template
Check working capital, current ratio, and sales coverage from assets, inventory, and liabilities.
Review the inputs and formulas below, then open this template in the calculator builder to customize the field names, values, result styles, and notes.
Inputs
Uses current_assets in formulas, starts as a currency field, and begins at 40000.
Uses inventory in formulas, starts as a currency field, and begins at 12000.
Uses current_liabilities in formulas, starts as a currency field, and begins at 22000.
Uses monthly_sales in formulas, starts as a currency field, and begins at 18000.
Outputs
Format currency
Result style primary
Formula current_assets - current_liabilities
Difference between current assets and current liabilities.
Format number
Result style metric
Formula current_assets / current_liabilities
Current assets divided by current liabilities.
Format number
Result style breakdown
Formula (current_assets + inventory - current_liabilities) / (monthly_sales / 30)
Rough number of sales days covered by working capital.
Use cases
Category
This template belongs to the Finance and Forecast Calculator Templates category, so you can compare it with closely related templates before choosing your best starting point.
Related
Browse more calculator templates in the finance and forecast calculator templates section.
Use the standard page for a quick working-capital check.
Move from liquidity to a fuller cash flow view.
FAQ
Short answers for the questions that usually come up first.
Yes. Open the template in the builder, then change the labels, values, formulas, notes, or output display styles to fit your workflow.
Yes. Save it on this device, export JSON, or copy a share link after you make changes.
Yes. Templates are meant to be edited. Remove fields, add new ones, or swap formulas if you want a different custom calculator.