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.

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

Instructor - George Morrison

This is a 10 Hour course and costs $75

Statistics helps to understand data, interpret results, and summarize information. This course helps you to understand and use statistical techniques to your best advantage.

Course Summary

Statistics may be intimidating to the beginner. George Morrison has been a patient teacher over many years to thousands of people, like you, who want to learn statistics in a way that makes the topic approachable, understandable, and relevant. Students and academics use statistics to make sense of a vast amount of data. Business people use statistics to support business decisions. While some examples in this course are about real estate, some are just about generally interesting things. Homburg Academy's more advanced finance classes relate quantitative analysis to a range of problems in real estate. This course eases you into the concepts, tools, methods, and approaches of statistical analysis. You will come away with knowledge that will give you an edge when you undertake research, or make your business decisions. You will learn how to pull vital information out of raw data by sampling, analyzing, organizing, and displaying your information in ways that best support your findings.

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.

This introductory session introduces the various techniques in descriptive statistics. Start with the basics, and understand what variables are, what qualitative and quantitative techniques do, and the different ways to present statistical information graphically.
In this session, you will learn some fundamental concepts in statistics, like means, mode, range, variance, and standard deviations.
How likely is something to happen? How can we tell? A lot about life is trying to anticipate the future. Statistical methods cannot predict the future, but they can tell us how likely an event is to take place, given a set of well-defined circumstances.
In this presentation, George Morrison presents the ins and outs of discrete probability distributions, and how they are represented.
Learn how to recognize a probability distribution curve.
What is a sample, and what can it tell you about the entire population? This session examines the proper ways to select sample data, and to interpret information from that sample.
Information obtained from samples can be used to estimate values in an entire population. In this session, you will understand how that can be done correctly, as well as understand the confidence level and margin of error.
George Morrison spends this entire session bringing everything that you have learned so far to some real world concrete examples. This helps to show the relevance of the information, and helps you to build knowledge about how to apply and use your newly gained skills (there is no quiz associated with this session).
Whenever we approach data, we ask questions about what might be true (an hypothesis) and we can then use statistics to help us answer the question (test the hypothesis). In this session, George Morrison shows how we know when a hypothesis can be said to be true.
In this final session, George Morrison shows how to test hypotheses using two populations.

Sign Up Now