This 28-minute video teaches the fundamentals of financial modeling for real estate development transactions. The slides are embedded below the Video Contents list.
Video Contents (counter reading)
– Slide 1: Introduction (00:00)
– Slide 2: Goals (00:19)
– Slide 3: What is Financial Modeling? (01:04)
– Slide 4: “Cardinal Rules” of Financial Modeling (01:25)
– Slide 5: Modeling Fundamentals (03:24)
– Slide 6: Modeling Fundamentals | Existing Commercial Building (04:45)
– Slide 7: Revenue Lag Illustration (05:16)
– Slide 8: What Makes Ground-Up Development Different? (05:34)
– Slide 9: So Why Bother Developing? (06:21)
– Slide 10: Development Project Timeline (07:10)
– Slide 11: Building the Development Pro-Forma (14:42)
– Slide 12: Land and Transfer Costs (16:42)
– Slide 13: Land and Transfer Costs Graph (18:57)
– Slide 14: Hard Costs (19:25)
– Slide 15: Hard Costs Graph (21:05)
– Slide 16: Soft Costs (22:04)
– Slide 17: Soft Costs Graph (23:01)
– Slide 18: Hard Costs vs. Soft Costs Graph (23:44)
– Slide 19: Furniture, Fixtures & Equipment (FF&E) (24:09)
– Slide 20: Furniture, Fixtures & Equipment Graph (24:45)
– Slide 21: Financing Costs (25:05)
– Slide 22: Financing Costs Graph (26:31)
– Slide 23: Total Project Costs Graph 1 (Individual lines) (27:16)
– Slide 24: Total Project Costs Graph 2 (Blended) (27:45)
