xlsx

1# Requirements for Outputs
2 
3## All Excel files
4 
5### Professional Font
6- Use a consistent, professional font (e.g., Arial, Times New Roman) for all deliverables unless otherwise instructed by the user
7 
8### Zero Formula Errors
9- Every Excel model MUST be delivered with ZERO formula errors (#REF!, #DIV/0!, #VALUE!, #N/A, #NAME?)
10 
11### Preserve Existing Templates (when updating templates)
12- Study and EXACTLY match existing format, style, and conventions when modifying files
13- Never impose standardized formatting on files with established patterns
14- Existing template conventions ALWAYS override these guidelines
15 
16## Financial models
17 
18### Color Coding Standards
19Unless otherwise stated by the user or existing template
20 
21#### Industry-Standard Color Conventions
22- **Blue text (RGB: 0,0,255)**: Hardcoded inputs, and numbers users will change for scenarios
23- **Black text (RGB: 0,0,0)**: ALL formulas and calculations
24- **Green text (RGB: 0,128,0)**: Links pulling from other worksheets within same workbook
25- **Red text (RGB: 255,0,0)**: External links to other files
26- **Yellow background (RGB: 255,255,0)**: Key assumptions needing attention or cells that need to be updated
27 
28### Number Formatting Standards
29 
30#### Required Format Rules
31- **Years**: Format as text strings (e.g., "2024" not "2,024")
32- **Currency**: Use $#,##0 format; ALWAYS specify units in headers ("Revenue ($mm)")
33- **Zeros**: Use number formatting to make all zeros "-", including percentages (e.g., "$#,##0;($#,##0);-")
34…