Intermediate
Model audit checklist: errors, consistency, and presentation
Creates a model audit checklist to catch formula errors, circularity issues, and presentation problems. Useful for final review before sharing with clients/investors.
Audit the financial model described below.
Inputs:
- Model summary and key outputs: {model_summary_outputs}
- Known issues or concerns: {known_issues}
- Audience (internal, lender, investor): {audience}
Output:
1) Technical checks (balance, sign conventions, time series integrity, hardcodes).
2) Logic checks (drivers, margins, WC timing, capex/debt consistency).
3) Scenario and sensitivity checks.
4) Presentation improvements (labels, units, formatting, navigation).
5) βTop 10β highest-risk cells/areas to inspect manually.
Provide as a checklist with explanations.Related Prompts
Advisory & Consulting
AdvancedBusiness Combination: Purchase Price Allocation (PPA)
Drafts the technical logic for allocating a purchase price to identifiable assets.
Claude 3.5 SonnetGPT-4o
0
0
73
Advisory & Consulting
IntermediateAudit Strategy & Materiality Planner
Calculates overall and performance materiality based on financial benchmarks and sets the scope for the engagement.
GPT-4oClaude 3.5 Sonnet
0
0
70
Advisory & Consulting
IntermediateD&O Insurance Adequacy Review
Advises clients on whether their Directors and Officers insurance is sufficient.
GPT-4oClaude 3.5 Sonnet
0
0
107