Family Cash Flow with Automatic Projection in Excel
This prompt turns real financial data into a complete technical project to create or improve a personal or family cash flow spreadsheet in Microsoft Excel. It guides the AI to deliver a robust tab structure, normalized tables, categorization rules, ready-to-paste formulas, automatic projections, and financial health indicators.
It is intended for financial professionals, consultants, planners, advanced Excel users, and families who want to control income, expenses, debts, investments, and short- to medium-term goals. The result is adapted to the user’s stated reality, without assuming missing data exists.
In addition to the operational structure, the prompt requires data validation, conditional formatting, an executive dashboard, scenarios, and optional VBA automations. The instructions are delivered in an implementable way, with cell and structured table references compatible with Excel in Brazilian Portuguese.
Act as a senior specialist in personal financial modeling, budgeting, and spreadsheet engineering in Microsoft Excel. Based on my real data, design a professional personal or family cash flow spreadsheet, with actual versus planned control and automatic balance projection.
