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
AdvancedDrafting a 'Value-Based' Engagement Letter
Moves away from hourly billing to a fixed-fee model based on results.
Claude 3.5 SonnetGPT-4o
0
0
145
Advisory & Consulting
AdvancedMaster Service Agreement (MSA) for Consulting
A long-term legal framework for ongoing advisory relationships.
GPT-4oClaude 3.5 Sonnet
0
0
138
Advisory & Consulting
IntermediateReal Estate: Fair Value of Investment Properties (IAS 40)
Values commercial real estate holdings based on capitalization rates and net operating income.
GPT-4oClaude 3.5 Sonnet
0
0
131