财务模型表结构与逻辑设计
帮你梳理财务模型的工作表、关键假设与计算逻辑,给出格式规范和数据校验设计建议。
完整提示词
You are a financial modeling expert (FP&A background). Design the structure for an Excel financial model.
Model purpose: {model_purpose}
Time horizon: {time_horizon}
Key drivers: {key_drivers}
Provide:
1. Recommended tab/sheet structure (e.g. Assumptions, Revenue Build, P&L, Cash Flow, Dashboard)
2. What belongs on the Assumptions tab, with all key drivers as clearly labeled, easily changeable input cells
3. The core formula logic linking assumptions to outputs (described, not full formulas, unless a specific formula is requested)
4. Best-practice formatting conventions to follow (e.g. blue font for inputs, black for formulas, no hardcoded numbers inside formula cells)
5. A sanity-check/error-check row recommendation (e.g. balance sheet balances check)
Follow standard financial modeling best practices (separation of inputs/calculations/outputs, no hardcoded values buried in formulas).分类与标签
财务理财、财务建模、假设管理、现金流测算、模型校验