For more details - please download the full agenda or email us and ask for a tailor-made solution...
Commercial Real Estate Markets look set for strong growth worldwide in 2018 and beyond under Trump & other new regimes taking office.
Decisions you make in your deals always have major long-term impacts. If you get the numbers wrong, you risk leaving millions of dollars on the table.
So it pays to get it right.
Introducing: 'The Masters in Real Estate Modelling'
Your valuable guide to getting the most out of real estate investments, worldwide.
'How to Model Your Real Estate Deals to get Maximum Value'
For well over 25 years, we have helped people just like you throughout the world sharpen their skills in analysing Real Estate deals.
While best known for our Real Estate Advisory expertise, we have also taught Argus, real estate negotiation and project feasibility modelling workshops.
Here's one recent client experience:
“Ever since my Analyst took your program he's become a powerhouse. We now make dramatically better decisions as a direct result of the tools we applied from The Masters in Real Estate Modelling"
– Jeff G, Property Acquisitions Director at an International REIT
Making Cash Flows Compound, better...
ARGUS is the industry standard tool for cash flow projections for commercial real estate. It draws on case studies and discussions in a live-deal, interactive environment.
We combine both financial theory and practical real-world examples so everyone benefits from the simulation regardless of their individual backgrounds.
By the end of the Workshop, you’ll have a firm understanding of how to use the software and be well prepared to analyse real estate for the real world, using live deal data.
Within 3 intensive days, you'll be able to do some really cool stuff...
- 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 plus leverage based on desired rates of return and risk tolerances
- 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, taxes, and depreciation
- Model complex partnerships and determine the returns to each investor
- Develop detailed construction budgets for development projects
- Build advanced mortgages such as construction and participating mortgages
- Understand how to use ARGUS to model all property types and mixed-uses (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 Excell
- It will all work for you seamlessly - no risk at all
PROFILE OF THE REAL ESTATE MODELLING TEAM
The Masters in Real Estate Modelling was designed and refined by our international Property Advisers based in New York City. You benefit from decades of R&D, at no extra cost.
They are genuine expert in real estate financial modelling using both Argus and Excel.
For over 15 years they have delivered powerful ARGUS training for leading institutions including commercial banks, investment banks, private real estate investment firms, REITs (Real Estate Investment Trusts), business schools, developers, and government agencies.
Training is available on both legacy products (Argus version 15) and the newer version of Argus, “Argus Enterprise”. We can easily customize a class to fit your organization specific needs.
You will also receive a handy bonus: the definitive guide on "How to Use Argus Effectively".
Financial Concepts you will explore:
- Building effective cash flow assumptions
- Cash flow statements - tips and tricks
- Valuation of an asset using discounted cash flow analysis
- Amortization schedules for mortgages
- Impact of leverage
- Depreciation schedules
- Impact of all types of taxes (income, capital gains, and accumulated depreciation)
- Partitioning the IRR - what this means in practice...
- Partnership Deals (preferred returns, waterfalls, and IRR look backs)
- Sensitivity tables and graphs for presentation and analysis
- How to use Excel and Argus together for effective analysis
Excel Tools and Concepts you will master include...
- Absolute and Relative References
- Keyboard Shortcuts
- Data Validation
- Conditional Formatting
- Goal Seek
- Data Tables
- Solver
- Scenario Manager
And Excel Functions - all part of the package...
- SUM
- ROUND
- IF, AND, OR
- PV, FV, RATE, NPER
- PMT, IPMT, PPMT
- IRR, NPV
- XIRR, XNPV
- EDATE, EOMONTH, DATEDIF
- OFFSET
- TRANSPOSE
- ISERROR
- VLOOKUP, HLOOKUP
- INDEX, MATCH
- SUMIF
HERE'S YOUR AGENDA IN BRIEF:
On Day One, we will cover the mechanics of financial modelling for real estate investment.
We will explore key concepts such as leverage and the impact of taxation.
On Day Two & Three, we will work with higher level concepts such as partnership modelling and construction and development modelling.
DAY ONE:
REAL ESTATE MODELLING - LATEST CONCEPTS
9:00am Intensive Insights
- Intro and Terminology used in global markets today & tomorrow
- Core Excel Functions for Real Estate
- Unleveraged Before Tax Cash Flow
- Amortization Schedule
- Leveraged Before Tax Cash Flow
12:30 Networking Lunch
1:30pm Intensive Briefings
- Depreciation Schedule
- Leveraged After Tax Cash Flow
- Partitioning the IRR and Advanced Analysis
- Sensitivity Tables
- Partnership Primer
- Argus and Excel Integration
4:30 Review of Your Existing Models - no questions are too silly.
Privacy 100% assured.
5:00 End of day
DAY TWO & THREE: REAL ESTATE MODELS IN PRACTICE
9:00am Insights, some of the jargon de-constructed...
- Partnership I – “Country Club” – Preferred Return plus Split of Cash Flow
- Partnership II – “Wall Street” – IRR Lookbacks
- More on Partnership II – Advanced IRR Lookbacks
- Partnership III – “Catch-up”
- Partnership IV – “Clawback”
12:30 Networking Lunch
1:30pm Workshops
- Basic Construction Concepts
- Construction and Unit Sales Schedules
- Construction Lending and Developer’s Cash Flow
- Construction I: Build and Hold – Construction and Permanent Financing
- Advanced Scheduling
- Construction II: Single Family Suburban and Condominium Developments
- Secrets and Best-Practices from hard-won lessons worldwide
4:30 Review of Your New & Existing Models
5:00 End of day
Class Sizes Limited - Get In Early, On the Ground Floor...
All open enrolment courses are restricted to the first 20 delegates in order to maximise interaction and intense value-creation. You will also receive a complete set of spreadsheets for all examples and case studies that are discussed in class. You will get back the cost of enrolment by 100 X.
Let's create a Private, Tailor-Made Experience.. if that suits you...
We can come to you
Over the past two decades, we have delivered in over 30 cities in the United States and globally including in Hong Kong, Tokyo, Singapore, London, Mexico City, Dubai and a few more...
We can customize the format for your needs
Have a room full of junior analysts? We can get them up to speed.
What about a couple of highly trained former big name PE Associates? We can fine tune them.
We have taught up and down the spectrum of skills and experiences.
We can vary the amount of material that we can cover and when we cover it
The standard class is two days. We can shorten it to one day or extend it to three days. While we normally do weekdays, weekends are also possible.
Want to discuss your options and preferences?
The odds are that we can probably do it, and since we’ve probably done it before, we can deliver a quality product for a cost-effective price.
“I had no idea how tight & robust my models could be until I started this program.”
– Real Estate Specialist at Goldman Sachs
We draw participants and alumni from across the world. We deliver what many say they never learned in business school. You learn how to model complex real estate transaction, while using Excel's tools in the most relevant (and efficient) way.
The class is challenging and practical in nature.
You’ll get real value from it!
Everyone who comes along will develop an understanding of how to use the power of Excel to analyse cash flow, leverage, partnerships and joint ventures, and construction projects.
Let me know your feedback and ideas...
Kind regards,
Amanda Gardner - Associate Director
Global Masters
I welcome your thoughts and questions always.
Write to me directly at: help@global-masters.org
For more details - please download the full agenda or email us for a tailor-made solution...
DAY TWO & THREE: REAL ESTATE MODELS IN PRACTICE
9:00am Insights, some of the jargon de-constructed...
- Partnership I – “Country Club” – Preferred Return plus Split of Cash Flow
- Partnership II – “Wall Street” – IRR Lookbacks
- More on Partnership II – Advanced IRR Lookbacks
- Partnership III – “Catch-up”
- Partnership IV – “Clawback”
12:30 Networking Lunch
1:30pm Workshops
- Basic Construction Concepts
- Construction and Unit Sales Schedules
- Construction Lending and Developer’s Cash Flow
- Construction I: Build and Hold – Construction and Permanent Financing
- Advanced Scheduling
- Construction II: Single Family Suburban and Condominium Developments
- Secrets and Best-Practices from hard-won lessons worldwide
4:30 Review of Your New & Existing Models
5:00 End of day
Class Sizes Limited - Get In Early, On the Ground Floor...
All open enrolment courses are restricted to the first 20 delegates in order to maximise interaction and intense value-creation. You will also receive a complete set of spreadsheets for all examples and case studies that are discussed in class. You will get back the cost of enrolment by 100 X.
For more details - please download the full agenda or email us for a tailor-made solution...
DAY TWO & THREE: REAL ESTATE MODELS IN PRACTICE
9:00am Insights, some of the jargon de-constructed...
- Partnership I – “Country Club” – Preferred Return plus Split of Cash
Flow
- Partnership II – “Wall Street” – IRR Lookbacks
- More on Partnership II – Advanced IRR Lookbacks
- Partnership III – “Catch-up”
- Partnership IV – “Clawback”
12:30 Networking Lunch
1:30pm Workshops
- Basic Construction Concepts
- Construction and Unit Sales Schedules
- Construction Lending and Developer’s Cash Flow
- Construction I: Build and Hold – Construction and Permanent Financing
- Advanced Scheduling
- Construction II: Single Family Suburban and Condominium Developments
- Secrets and Best-Practices from hard-won lessons worldwide
4:30 Review of Your New & Existing Models
5:00 End of day
Class Sizes Limited - Get In Early, On the Ground Floor...
All open enrolment courses are restricted to the first 20 delegates in order to maximise interaction and intense value-creation. You will also receive a complete set of spreadsheets for all examples and case studies that are discussed in class. You will get back the cost of enrolment by 100 X.
By Industry
By Job Title
