Oracle Core Package

Anyone can become an expert in Oracle for Real Estate financial modeling with these unique, affordable online video courses. With Crystal Ball, you can make the right tactical decisions to reach your objectives and gain a competitive edge under even the most uncertain market conditions. Create an accurate Pro Forma model for analyzing the financial performance of real estate investments and developments. Then take it to the next level of expertise with additional capabilities in Risk Quantification using Oracle's Crystal Ball. 

Program Summary

Every real estate investment or development venture needs a plan. Most of all, you need to understand the risks; how to manage them and how to plan for them. You're investing in real estate to make money, and you need to make a return on your investment. Risk can mean losing all, and being taken out of the game early. What if you had a real Crystal Ball that lets you anticipate risks before you dive in? That is exactly what Oracle Crystal Ball Decision OptimizerTM does, and these courses will help you unleash its power. These courses will provide you tools, strategies and processes that are ready to use in your new future as a more qualified and capable professional.

Included Courses

  • Real Estate Pro Forma Modeling - Roger P. Staiger III
  • Risk Quantification using Crystal Ball - Roger P. Staiger III
COURSES: 2
HOURS: 11
COST: $399.00
 

Program Information

Essential Core Program
 

Oracle Crystal Ball™ is the leading spreadsheet-based application for predictive modeling, forecasting, simulation, and optimization. It gives you unparalleled insight into the critical factors affecting risk. With Crystal Ball, you can make the right tactical decisions to reach your objectives and gain a competitive edge under even the most uncertain market conditions.

Are you already familiar with Microsoft Excel, and concepts like internal rate of return (IRR) and net present value (NPV)? With Oracle Crystal Ball you can be an expert capable of intelligently modeling your real estate ventures with an eye toward the future. Crucially, you'll understand the risks and just how to manage them. Even if you are not comfortable with real estate investment or Excel, our Extended Learning Package will give you all the background you need to become an expert in no time.

These 11 hours of online video courses will give you a grasp of Microsoft Excel’s financial analysis capabilities. You'll receive step-by-step instructions on how to create an accurate Pro Forma model for analyzing the financial performance of real estate investments and developments.

You'll learn by doing, expanding your knowledge of Excel's advanced tools for financial analysis functions as you follow along with your mentor and instructor, Roger P Staiger. This is arguably the only online real estate financial modeling class where you can 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.

You'll also keep the spreadsheets and Pro Forma models you developed in class to use and modify for any future project. Anytime you need a refresher you can simply go back, review, re-do, and revisit your knowledge, quickly and efficiently adapting your financial models to suit all of your current and future real estate projects. So, our system provides you with knowledge, and tools.

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