Description Teaches you how to harness the power of Conditional ("If/Then") Statements in Excel to make your pro-formas more flexible to changing variables. An apartment building development scenario is used (14 minutes).
Video Contents (counter reading)
- Conditional Statements Introduction Overview (00:00)
- Control Panel (00:26)
- Timeline Compression Discussion (01:05)
- Pre-Construction Period (01:34)
- Construction Start Month and Duration (02:05)
- First C of O (02:33)
- Construction End Month/Final C of O (03:39)
- Post-Construction Leasing Duration (03:57)
- Retail Tenant TI Payment (05:44)
- Retail Tenant Rent Commencement (06:05)
- Time Coding Overview (06:33)
- Calendar Month (06:47)
- Counting Numbers (07:31)
- Construction Month # (07:52)
- Construction Status (09:45)
- Cell Reference Locking (10:34)
- Calendar Year (12:19)
- Development Fee Example (13:10)
