Oracle Complete Package

This Oracle Complete Package is what you need to go further with extensive skills and strategic knowledge to guide your decision making and manage risk. Confidently trust and apply proven processes and reliable predictive analysis methods. Enhance your Learning goals beyond the Oracle Core Package and instead start with the next level of course bundle with more. Added in this package comes learning involving Oracle's world-famous financial prediction tools; OptquestTM and PredictorTM. You'll go beyond real estate investment analysis with an exclusive course in risk and portfolio management for real estate that will supplement your knowledge and give you a range of skills in both project and portfolio real estate.

Program Summary

You need some background education and want to develop further than the Oracle Core Program bundle can take you? Well look no further. This Oracle Complete Package is what you need. Develop to the next level with Oracle's world-famous financial prediction tools, OptquestTM and PredictorTM. You'll be able to confidently go beyond real estate investment analysis with an exclusive course in Risk and Portfolio Management for Real Estate that will supplement your knowledge and give you a range of skills in both project and portfolio real estate.

Included Courses

  • Real Estate Investment using Options: Oracle's OptQuest and Predictor - Dr. Charles J. Conrick IV
  • Real Estate Pro Forma Modeling - Roger P. Staiger III
  • Risk and Portfolio Management - Dr Tom Geurts
  • Risk Quantification using Crystal Ball Roger - P. Staiger III

COURSES: 4
HOURS: 32
COST: $699.00

Program Information

Enhanced Learning Suite

If you are currently working in a real estate company, bank, pension fund, real estate investment trust (REIT) or investment firm you can boost your career with hard skills that propel you beyond your peers. If you're a recent graduate, get the skills employers demand that will set your resume apart from the competition. If you're a private real estate investor using your own money, wouldn't you like to learn to control risk today and see the future? Those skills are yours to be had, right now, with the Oracle Complete Package.

You'll get a total of 32 hours of online instruction. Starting with 11 hours on project financial modeling with Georgetown University's, Roger Staiger. You'll receive a further 10 hours of instruction on risk analysis and portfolio investment in real estate with the head of George Washington University's real estate program, Dr Tom Geurts. You'll move on to Predictive Analytics using options for real estate investment with Dr Charles Conrick IV, an acknowledged expert in options finance at Dickinson State University.

With Dr Geurts, you'll learn to describe and quantify risk while learning the essential principles of portfolio investment strategy. You'll understand the fundamentals of real estate in diversified portfolios and how to identify real estate correlations. With Dr Charles J. Conrick, you will gain hands-on practical instruction, learning by doing as you explore concepts in financial modeling on risk/return in real estate. By the end of this course, you'll know how to correlate real estate with systemic market risk, and how best to use Oracle PredictorTM and OptquestTM to formulate targeted positions and revise your portfolio investments.

Best of all, all of these talented instructors are brought to you using our advanced online learning system.

Oracle Crystal BallTM helps you plan, and see, the future potentials of a project. Oracle's OptquestTM and PredictorTM modules take you even further, introducing you to the art and science of Predictive Analytics. With predictive analytics, you'll develop profiles and discover the factors that lead to likely outcomes, ensuring confident, accurate predictions.

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.

Crystal Ball basics with a discussion of distribution shapes and there uses. Normal, Uniform and LogNormal distributions are some of the distributions reviewed.
Basic pro forma structure is discussed and a review of the theory for real estate pro forma construction. The scalable and modular structure for a pro forma is reviewed. Part 1 of the pro forma is completed, i.e. summary/input.
The income section of a real estate pro forma is developed. This is part II of the four part construction. The entire pro forma is completed in this section.
A demonstration of how to analyze a real estate pro forma model is completed. Oracle Crystal Ball is first introduced.
Oracle Crystal Ball is used in conjunction with the completed real estate pro forma model. Risk is quantified using crystal ball's monte carlo simulation.
Scenario analysis is demonstrated as a simpler, and less accurate, risk quantification. The alternative method is introduced to provide individuals an appreciation for Oracle Crystal Ball and to provide a quick back-of-the-envelope approach to risk quantification.

Sign Up Now

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.

Rent Roll construction for "n" unit multifamily pro forma model.
Construction Draw page added to multifamily pro forma model.
Completion of Construction Draw page and summary review of advanced multifamily pro forma model.

Sign Up Now

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.

Portfolios are a way to manage risk through diversification. On average the risk for an average stock is about 35%. Learn how to measure the risk of a real estate investment.
Beta measures an investment’s market risk. It shows an investment’s volatility relative to the market. Learn why real estate is one of the few investments with a (potentially) negative beta.
Learn how to diversify an investment portfolio, as well as the pros and cons of each.
Learn about Modern Portfolio Theory, and why real estate is an excellent choice of investment for large institutional investors, like pension funds.
Real Estate Investment Trusts are in effect mutual funds owning real estate. Learn how to operate and why it makes sense to own units in REITS as a part of a well-diversified portfolio.
International diversification is a good thing, but different laws, regulations, and customs in different countries need to be understood. Different attitudes to property rights, to transaction costs, and the cost of finance mean you need to do your homework for a portfolio of international real estate investments.
See why Russia has the highest transaction costs, and why China might not be the best place to invest.
Thankfully there are services like the Investment Property Databank that provides worldwide critical business intelligence, including analytical services, indices and market information, to the real estate industry. Learn how to use critical market information.
Typically financial decision models are based on the Efficient Market Hypothesis and Rational Behavior. Unfortunately, the market is rarely efficient and people are seldom rational. How should you make your way through an analysis of real estate portfolio investment?

Sign Up Now