Instructor - Roger P. Staiger III
This course will introduce students to the knowledge and skills of Pro Forma modeling using MS Excel and Oracle's Crystal Ball. Learn to build and use reusable financial models. watch, up-close, how it is done, and follow along with your own spreadsheet. Just like in a classroom, you see how a seasoned instructor, real estate consultant and practitioner guides, mentors, illustrates, and shows you how to use the tools yourself.
Course Summary
Introduction to Real Estate Pro Forma modeling using MS Excel and Oracle's Crystal Ball. This introductory session takes participants from a blank spreadsheet to a completed real estate pro forma model. This model is scalable and modular and can be used as a base for much larger models of varying asset types. An introduction to risk quantification using scenario analysis is featured to allow for back-of-the-envelope risk quantification.
How do I take this course?
This course delivers 7 hours of video lecture presentations on key topics in the use of Oracle software products to perform financial modeling. You can download and print a copy of the presentation slides, and make notes as you follow along. To make it easier to absorb the material, each hour is divided into short segments, of about 15 minutes each. You can watch the segments at your own pace, in your own time. Each segment is followed by a short quiz to help you review, and test yourself about what you have learned.
Lecture reviews the basics of descriptive statistics. This is the base knowledge for risk quantification.
Instructor - Roger P. Staiger III
This is a 4 hour course and costs $95
Advanced pro forma financial modeling. Take the guesswork out of your business planning, develop financial models and Pro Forma you can use with the incredible features Oracles Crystal Ball predictive software adds. Manage Risk intelligently and make decisions confidently.
Course Summary
Advanced multifamily pro forma modeling for "n" units with construction draw page. Various components are added to complete the scalable and modular pro forma model to include advanced financing structures and construction financing.
How do I take this course?
This course delivers 4 hours of video lecture presentations on key topics in the use of Oracle software products to perform financial modeling. You can download and print a copy of the presentation slides, and make notes as you follow along. To make it easier to absorb the material, each hour is divided into short segments, of about 15 minutes each. You can watch the segments at your own pace, in your own time. Each segment is followed by a short quiz to help you review, and test yourself about what you have learned.
Do I get a Certificate of Completion?
Yes. On completion of this course, you will be able to print a Certificate of Completion showing the overall average that you achieved in all of the quizzes. You may be able to take this to your university or college to ask for transfer credits, or to your professional association to see if you can be awarded continuing education credits.
Review & Advanced Amortization table to include various structures.
Instructor - Dr. Charles J. Conrick IV
This is a N/A hour course and costs $95
This course will build on and expand the learner’s experience using Oracle’s Crystal Ball by demonstrating and experimenting with optimization of models under varying conditions of uncertainty using OptQuest and Predictor features of Crystal Ball. It also will enable learners to use various option trade positions using real estate ETF’s to manage risk as well as maximize returns.
Course Summary
This course will permit the learner to understand how, when and where to use Options: Oracle's Optquest and Predictor" with Crystal Ball software modelling to complete various Real Estate computations and will allow the learner to generate simulations involving rent, risk and return on real estate investment, analysis of options using RWR(SPDR Dow jones REIT), VNQ(Vanguard REIT Index0 contrasted with SPY(S&P500). An advanced look at a hypothetical model will allow higher levels of application of modelling tools in a Real Estate context. This course will provide the necessary information and practice to understand and produce modelling using a variety of software tools.
Instructor - Dr Tom Geurts
This is a 10 Hour course and costs $95
Explore the world of real estate as assets in portfolio investment, and the ways to understand, quantify, and manage risk.
Course Summary
This course will help you, as a manager of portfolio investments - or as a person who hires one - to understand the role of real estate in a diversified portfolio. You will learn to describe and quantify that multi-faceted companion to reward: Risk. This course will outline principles of portfolio investment strategy, and compare the concepts and processes of sourcing and underwriting. It will describe the nature of real estate in diversified portfolios, and show you how to identify real estate correlations. You will understand the concepts and methods for due diligence, and compare the operation of internal risk rating systems. By the end of the course, you will be able to describe portfolio management techniques and instruments, including risk and return, and diversification, securitization, hedging, and derivatives. You will also be better able to understand and explain the interaction between the property market and the investment market;
How do I take this course?
This course delivers 10 hours of video lecture presentations on key topics about real estate assets, and portfolio management. You can download and print a copy of the presentation slides, and make notes as you follow along. To make it easier to absorb the material, each hour is divided into short segments, of about 15 minutes each. You can watch as many, or as few segments each day, or each week, in your own time. Each segment is followed by a short quiz to help you review, and test yourself about what you have learned. There is also a dedicated chat room for this course, so you can talk, get help, and just be social as you journey through this exciting topic with others online.
Do I get a Certificate of Completion?
Yes. On completion of this course, you will be able to print a Certificate of Completion showing the overall average that you achieved in all of the quizzes. You may be able to take this to your university or college to ask for transfer credits, or to your professional association to see if you can be awarded continuing education credits.
Set the groundwork with an understanding of the differences between real estate and other types of investments (stocks, bonds), and the peculiar features of real estate that investors need to be aware of.