This 14-minute video tutorial teaches you how to harness the power of Conditional (“If/Then”) Statements in Excel to make your pro-formas more flexible to changing variables. A mixed-use apartment building development scenario is used. The Excel file to use with this video tutorial may be downloaded here .
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)
