Oracle Comprehensive Learning Package

Don't miss this fantastic opportunity to learn real estate investment analysis and handle financial modeling like a pro. Go from novice to expert with crucial expertise in OracleTM predictive financial modeling and Microsoft ExcelTM for real estate investment. We Have bundled together the key 6 courses you need to get on the pathway to success.

Program Summary

With nearly 60 hours of instruction, this multi-course bundle was designed for the professional who may have a basic, working understanding of real estate investment, but wants a deeper understanding of the financial concepts driving the industry? Do you feel a need to learn Oracle software and take advantage of the expert level performance you can achieve from their tools? We can start you with basic Microsoft Excel training and systematically add on stronger and more powerful functionality until you are confident and capable of detailed and highly accurate calculations that will make your decisions reliable and well grounded in facts.

Included Courses

  • Real Estate Investment Analysis - Frank Gallinelli
  • Real Estate Investment using Options: Oracle's OptQuest and Predictor - Dr. Charles J. Conrick IV
  • Real Estate Pro Forma Modeling - Roger P. Staiger III
  • Statistics - George Morrison

COURSES: 4
COST: $899.00

Program Information

Foundation to Expertise

Are you interested in real estate, but worry about losing your money? Do you have a basic, working understanding of real estate investment, but want a deeper understanding of the financial concepts driving the industry? Do you feel a need to learn Oracle software and Microsoft Excel, but don't know where to begin?

If you answered yes to any, or all, of those questions, we've crafted a package for you. With nearly 60 hours of instruction you'll go from novice to expert with crucial expertise in OracleTM predictive financial modeling and Microsoft ExcelTM for real estate investment.

You'll start with 10 hours in Real Estate Investment Analysis by best-selling author Frank Gallinelli. A professor at Cornell University, Gallinelli's books on real estate investment have sold in the hundreds of thousands of copies. So you can be sure you'll be learning from the best with in-depth instruction on net present value (NPV) and the all-important calculations needed for its internal rate of return (IRR). You'll receive thorough instruction on the standard concepts in real estate investment analysis, along with the investment skills and techniques used by the experts that guarantee a maximum rate of return.

Then, you'll take a hands-on course in Microsoft ExcelTM where you'll learn the essential functions, formulas, and features of the world's most popular spreadsheet software. You will also get 10 hours of basic Statistics instruction, emerging with a solid understanding of the statistical terms used in financial modeling.

Page: 1 2 ()

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

Instructor - Frank Gallinelli

This is a 10 Hour course and costs $95

Our Real Estate Investment Analysis course will help you identify the different facets investment, maximizing the profit-making potential of your investment decisions.

Course Summary

The field of real estate investment can be overwhelming, with many different calculations and variable to choose from. The Real Estate Investment Analysis course will help you cut through the clutter, helping you identify the best investments and potential acquisitions that will maximize your profits while diminishing your risk of loss. Through lectures, case studies and discussions, you'll learn the meaning of finance terminology, income streams, cash-flow analysis, data collection, and measures of investment return. By discovering what all the data means, you'll gain a valuable understanding of the uses and limitations of real estate investment analysis in ways that strengthen and complement your financial knowledge.

How do I take this course?

This course delivers 10 hours of video lecture presentations on key topics in business. 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 the structures and processes of today's business environment 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.

In this introduction, Frank Gallinelli introduces students to essential concepts like interest rates, mortgages, stocks, bonds, and mutual funds. He also examines some of the characteristics and issues of an investment, like commitment of capital, risk, return and liquidity.
What are the elements of appraisal that are of most concern to the investor in real estate and decide if it is a good investment? Follow Frank Gallinelli in the first of this two part presentation to explore valuation from an investment perspective.
Once you understand the essentials of an income-producing property, how do you use that information to make wise investment decisions when presented with an opportunity? In this presentation, Frank Gallinelli provides a number of scenarios to encourage you to think about capitalization rates and other variables as you consider investments.
This presentation examines the all-important Pro-Forma and how investors can use this financial information in their investment decision. Explore the difference between the Operating Pro-Forma and Resale Pro-Forma, and gain the foundations you will need to evaluate the case studies in upcoming sessions.
In this lecture, Frank Gallinelli examines how an investor can think about financing an investment, in relation to the income potential of the real estate.
Building on previous presentations, students will examine the Loan-To-Value Ratio of investment properties using a range of examples. In this session, students examine such concepts as debt coverage, the Net Income Multiplier, and the Equity Dividend Rate.
Introducing the case studies, Frank Gallinelli completes the exposition of concepts and methods by examining the internal rate of return, and capital accumulation comparisons.
Case studies are intended to bring together all of the concepts and models that have been explored to date, and to enable students to bring to bear their accumulated knowledge on a real example.
Case studies are intended to bring together all of the concepts and models that have been explored to date, and to enable students to bring to bear their accumulated knowledge on a real example.
Case studies are intended to bring together all of the concepts and models that have been explored to date, and to enable students to bring to bear their accumulated knowledge on a real example.

Sign Up Now

Page: 1 2 ()