Servidor MCP

13-Week Cash Flow Plan

it.chiriba/cashflow13

Qué hace este MCP

Builds a 13-week cash-flow forecast with weekly liquidity, negative-cash timing, funding needs, and an Excel workbook.

build_cashflow_plan
13-Week Cash Flow Plan
Build a 13-week cash flow forecast and return a live Excel workbook. Use this when someone asks when they will run out of cash, how long their runway is, how much funding they need to bridge a gap, or wants a short-term liquidity or treasury forecast. Takes opening cash balance, expected receipts (or revenue and DSO), supplier payments (or purchases and DPO), payroll, loan instalments and taxes due. Returns the week-by-week grid, the first week cash goes negative, the peak funding need, and levers such as collecting earlier or paying later. Ask the user for the figures one at a time; call the tool once you have the opening balance plus receipts and supplier payments — payroll, loans and taxes default to zero if not given.
Esquema de entrada
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'taxes': {'anyOf': [{'type': 'number'}, {'type': 'array', 'items': {'type': 'number'}, 'maxItems': 13, 'minItems': 13}], 'description': 'VAT and taxes falling due. One number for every week, or 13 weekly values.'}, 'locale': {'enum': ['en', 'it'], 'type': 'string'}, 'dpoDays': {'type': 'number', 'description': 'Days payable outstanding, used with purchases.'}, 'dsoDays': {'type': 'number', 'description': 'Days sales outstanding, used with revenue.'}, 'payroll': {'anyOf': [{'type': 'number'}, {'type': 'array', 'items': {'type': 'number'}, 'maxItems': 13, 'minItems': 13}], 'description': 'Wages and salaries. One number for every week, or 13 weekly values.'}, 'revenue': {'anyOf': [{'type': 'number'}, {'type': 'array', 'items': {'type': 'number'}, 'maxItems': 13, 'minItems': 13}], 'description': 'Revenue, if receipts are not known directly (needs dsoDays). One number for every week, or 13 weekly values.'}, 'currency': {'type': 'string', 'description': 'Currency label, e.g. EUR. Label only.'}, 'receipts': {'anyOf': [{'type': 'number'}, {'type': 'array', 'items': {'type': 'number'}, 'maxItems': 13, 'minItems': 13}], 'description': 'Cash expected in from customers. One number for every week, or 13 weekly values.'}, 'purchases': {'anyOf': [{'type': 'number'}, {'type': 'array', 'items': {'type': 'number'}, 'maxItems': 13, 'minItems': 13}], 'description': 'Purchases, if payments are not known directly (needs dpoDays). One number for every week, or 13 weekly values.'}, 'startDate': {'type': 'string', 'description': 'First day of the plan, YYYY-MM-DD. Defaults to today.'}, 'weekEndsOn': {'type': 'integer', 'maximum': 6, 'minimum': 0, 'description': 'Day weeks close on: 0=Sunday … 5=Friday (default), 6=Saturday.'}, 'loanRepayments': {'anyOf': [{'type': 'number'}, {'type': 'array', 'items': {'type': 'number'}, 'maxItems': 13, 'minItems': 13}], 'description': 'Loan and lease instalments. One number for every week, or 13 weekly values.'}, 'openingBalance': {'type': 'number', 'description': 'Cash in the bank on day one. Required.'}, 'openingPayables': {'type': 'number', 'description': 'Payables open on day one. Optional.'}, 'supplierPayments': {'anyOf': [{'type': 'number'}, {'type': 'array', 'items': {'type': 'number'}, 'maxItems': 13, 'minItems': 13}], 'description': 'Cash out to suppliers. One number for every week, or 13 weekly values.'}, 'openingReceivables': {'type': 'number', 'description': 'Receivables open on day one. Optional; sharpens the DSO conversion.'}}}
health
Health
Report server status, version and supported languages.
Esquema de entrada
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'locale': {'enum': ['en', 'it'], 'type': 'string', 'description': 'Language for human-readable labels. Defaults to English.'}}}
Añadido
build_cashflow_plan
17 de September de 2026 a las 12:53
Añadido
health
17 de September de 2026 a las 12:53