Financial Modelling in Argus
Course
Inhouse
Discover all the things you never thought Excel could do!
-
Type
Intensive workshop
-
Level
Beginner
-
Methodology
Inhouse
-
Class hours
15h
-
Duration
2 Days
-
Start date
Different dates available
In this two-day course, attendees will learn how to use ARGUS to an intermediate level and will be exposed to its most advanced features. No previous ARGUS knowledge is required and attendees do not need any specific knowledge before taking the class. A limited exposure to commercial real estate or finance is sufficient as all relevant financial concepts are covered in class.
With the introduction of Argus Enterprise, there have been substantial changes from Argus DCF. Even if you’re an experienced user of DCF, you will benefit from this class.
Important information
Documents
- FMIA.pdf
Facilities
Location
Start date
Start date
About this course
Build ARGUS financial models using nothing more than a few assumptions
Edit and audit existing models for errors and unreasonable assumptions
Determine an appropriate purchase price and leverage based on desired rates of return and risk tolerance
Build detailed cash flow projections, sources and uses schedules, and other financial reporting tools such as discounted cash flow analysis (Net Present Value and IRR)
Estimate future sale prices based on cash flow and other approaches
Account for the impact of debt financing
Model complex partnerships and determine the returns to each investor
Develop detailed construction budgets for development projects
Build advanced mortgages
Understand how to use ARGUS to model all major property types (office, industrial, retail, residential, and hotel)
Run advanced scenario and sensitivity analyses on individual properties and portfolios
Export all data and reports to customized reports in Excel
A strong emphasis is placed on how the software is actually used in the business world. All students will receive “hands-on” experience in the class and will also work on a case study at three separate times over the weekend. With each step, the case study’s complexity builds as the attendee’s knowledge increases. Different solutions to the case study are reviewed and discussed at the end of each unit.
Acquisitions and development professionals
Loan officers and mortgage brokers
Appraisers
Real estate brokers
Current and recent graduates of MBA and undergraduate programs
Portfolio manager and asset managers
Anyone that would like to either break into commercial real estate or further their development of real estate financial knowledge
Basic knowledge of Excel/Real Estate
We have been teaching financial modelling in Excel now for almost 20 years, to people working in investment banks, commercial real estate, property developers and many other types of organisations.
We pride ourselves on being the only training company, to teach people what they actually want to know when it comes to financial modelling.
That's building them from scratch all the way through to a fully functional model.
We received your request and will get back to you with a response as soon as possible.
If you have any further questions, please contact us by email: R.Augustiniene@bayfieldtraining.com.
Reviews
Subjects
- Excel
- Finance
- Cash Flow
- Real Estate
- Property
- MS Excel
- Risk
- Date series
- Comparing Value
- Sensitivity Analysis
- ‘Rent Function
- Calculations
- Modelling theory
- IRR analysis
- Yields
- Growth Rates
- Target Returns
- Logic functions
- Date
Teachers and trainers (1)
Bayfield Training
Proviider
Course programme
Day One
MORNING
- Creating and Answering the Basic Four Questions for Any ARGUS Model
- Help! – Three Ways to Get It
- Property Level Revenues, Expenses, and Capital Expenditures
- Operating vs. Non-Operating Expenses
- Introduction to Property Level Reporting
- Entering a Single Tenant
- Market Leasing Assumptions
- Introduction to Vacancy and Credit Loss
- Property Purchase and Investment
- Resale and Valuation
- Debt Financing
- Present Value Discounting
- Case Study: Reed Tower, Part 1
- An Introduction to Auditing
- Multiple Tenants
- Detailed Base Rent
- Retail Sales Rent (“Percentage Rent”)
- Space Absorption
- Parking Revenue
- Tenant Groups
- Advanced Vacancy
- Available Date vs. Start Date
- Tenant Recoveries
- Grossing Up Expenses
- Reference Accounts
- Case Study: Reed Tower, Part 2
There is a short break (15 minutes) each day in the morning and the afternoon.
Day 2
- Introduction to the Details of Leases
- Rent Abatements
- CPI Rent
- Miscellaneous Rent
- Parking
- Introduction to the Market Menu
- Advanced Market Leasing Assumptions
- Intelligent Renewals
- Construction Costs
- Global Categories
- Report Packages
- Case Study: Reed Tower, Part 3
- Escrow Accounts
- Argus and Excel Integration
- Sensitivity Matrix
- Apartment Model
- Hotel Model
- Scenario Analysis
- Portfolio Analysis
- Investment Structures
There is a short break (15 minutes) each day in the morning and the afternoon.
Financial Modelling in Argus