Using SUMPRODUCT to Calculate Weighted Average in Real Estate Financial Modeling
One of the most commonly used techniques in real estate financial modeling. In this quick tutorial I show you how to use SUMPRODUCT to quickly calculate weighted average. To download the file used in this video or read the full tutorial: https://www.adventuresincre.com/sumpr...
00:00 - Introduction
00:16 - Common Uses of Sum-Product in Real Estate: Sale/Lease Comp Tables and Rent Roll Tables
00:51 - Example: Sales Comp Table for Apartment Projects
01:09 - Calculating Average Square Feet Using Standard and Weighted Average Methods
02:00 - Detailed Explanation of Weighted Average Calculation: Total Square Footage and Weights
02:41 - Introduction to Sum-Product Function in Excel for Weighted Averages
03:02 - Demonstrating Sum-Product Function with Square Footage and Units as Arrays
03:59 - Finalizing Weighted Average Calculation and Applying the Formula to Price Per Unit
05:15 - Concluding Remarks on Using Sum-Product Function for Weighted Averages in Real Estate Modeling
To learn to model real estate like a deal-seasoned pro, consider joining our real estate financial modeling Accelerator: https://www.adventuresincre.com/accel...
Watch video Using SUMPRODUCT to Calculate Weighted Average in Real Estate Financial Modeling online without registration, duration hours minute second in high quality. This video was added by user Adventures in CRE 08 January 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 7,552 once and liked it 48 people.