ARGUS Excel Model

An overview of ARGUS Excel Model. This model can underwrite a real estate investment in 10 minutes with granular assumptions and great accuracy.

We cover the basic information section in the ARGUS Excel Model. Users can input close date, holding period, and deal name in this section. Let's delve in.

We can input detailed items in uses and sources section in the ARGUS Excel Model, including purchase price, debt and equity amount.

We cover the rent roll section in the ARGUS Excel Model. An introduction of the powerful user input form is also in this video.

We talk about the reimbursement in the rent roll section in the ARGUS Excel Model. Three reimbursement methods are covered in this video.

We cover the expense section in the ARGUS Excel Model. The expenses are catogorized as per-square-foot based, percentage-based, and reserve-related.

We talk about the market leasing profile section in the ARGUS Excel Model. The assumptions in this section include market rents, renewal probabilities and downtime.

We cover the debt section in the ARGUS Excel Model. The debt financing and refinance are introduced and discussed in this section.

We discuss the property information section in the ARGUS Excel Model. Three variables are included in this section: GP and LP's names, address, and site size.

We assign market leasing profiles in the rent roll section in the ARGUS Excel Model. The predefined major, medium, or minor leasing profile is assigned to tenants.

We continue to cover the customized profile in the rent roll section in the ARGUS Excel Model. We also introduce the occupancy tab and individual tenants' tabs.

We cover the other assumptions section in the ARGUS Excel Model. The general vacancy, the annual market rent growth and the total reserve are covered.

We talk about the disposition section in the ARGUS Excel Model. The exit cap rate, the transaction cost and the net sale proceeds are covered in this video.

We cover the waterfall section in the ARGUS Excel Model. Waterfall is the profit-splitting structure between the general partner and the limited partner for a deal.

We go through the functions of the Fix Everything button in the ARGUS Excel Model. Fix Everthing button is one of the most powerful features in the model.

We discuss the rest of the functions of the Fix Everything button in the ARGUS Excel Model. The Fix Everything button checks the critical inputs in the model.

We cover the sensitivity table in the ARGUS Excel Model. This specialized sensitivity table is more powerful and robust than the traditional one.

We go through the executive summary in the ARGUS Excel Model. This section summarizes all critical information about the investment and the property.

We cover the other income tab in the ARGUS Excel Model. This section allows users to add other income in the cash flow forecast.