Conditional Statements Training Video Tutorial

by Bruce Kirsch on September 14, 2011

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)

Posted in:

Previous post:

Next post: