Time Interval: 00:00:01 - 00:08:50
Summary
Customization Features:
- Add company-specific logos and customize details (e.g., company name) to reflect in all sheets and reports.
- Adjust unit measurements, currency symbols, and tax settings (e.g., GST or VAT).
Cost Management:
- Manage tax calculations using separate reports for liability and refunds.
- Stage-based cash flow reporting allows tracking of expenses by phases such as land acquisition, construction, and settlement.
Color-Coded Cells:
- Blue: Editable inputs for scenarios.
- Orange: Linked but editable formulas for dynamic customization.
- Red: Pre-defined, non-editable cells to ensure data integrity.
Stages and Cash Flow:
- Stages can be customized (e.g., land acquisition, construction, settlement).
- High-level stage assignments help track ongoing costs like land tax or bookkeeping from project start to finish.
Link Master:
- Simplifies repetitive tasks like unit changes and syncing across multiple feasibility scenarios.
Key Takeaways
Customizable sheets save time and ensure consistent project documentation.
Dynamic formulas enable real-time updates and scenario testing.
Phased cost tracking ensures financial clarity across project lifecycles.