Fix Everthing Button - Part Two


Transcript

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.