This powerful model allows investors to underwrite a complex real estate portfolio within 10 minutes!
ARGUS Excel Model Playlist: • 1 - ARGUS Portfolio Mo...
ARGUS Portfolio Model Playlist: • 1 - ARGUS Portfolio Mo...
Learn more at: www.financiale...
ARGUS Multi-family Model Playlist: • 1 - ARGUS Multifamily ...
If you are interested, please reach out to info@financialexcelmodeling.com
0:20 Check the close date
0:52 Check the total reserve cell
1:32 Check the sources and uses
Script:
Welcome to this video. In this video, I will cover the rest of the features of the Fix Everything button in the ARGUS Portfolio Model. Let’s get into it.
The button will check if the close date is empty. Let’s delete the close date. Click on the FIX EVERYTHING button. The error message is saying that the close date cell is empty. Click on Input Close Date. Type October 1st, 2021. Click Ok. Now the error message goes away. Click Okay to close the window.
Let’s scroll down to the total reserve cell. I sum up the 2 reserve items in the uses in this cell. I am going to delete it. Click on the FIX EVERYTHING button. The error message is saying that the total reserve cell is empty. Click the Go To Total Reserve Cell button. It takes me to the empty total reserve cell. If I do not have the reserve items in the uses, I would type in 0 as a placeholder. In this case, I will sum up the 2 reserve items. Click the FIX EVERYTHING button again. Everything looks good now.
Let’s go through the last type of error. The FIX EVERYTHING button checks if the uses equal the sources in the ARGUS Portfolio model. Let’s add 100 dollars to the Investors’ equity. Then click the FIX EVERYTHING button. The error message is saying that the total uses and the total sources do not match. Click the Go To Uses and Sources button. The whole Sources and Uses section is highlighted. I will delete the 100 dollars to fix this problem. I finish going through all the features of the FIX EVERYTHING button.
Thanks for watching this video. I will see you at the next one.
Негізгі бет 11 - ARGUS Portfolio Model | Fix Everything Button Part Two | Real Estate Financial Modeling
Пікірлер