Syllabus

• Week 1

  The Outline of "AI" on Real Estate

  • Course Introduction

    Welcome to our course, AI Application on Real Estate Finance and Investment! What is artificial intelligence? What is real estate? What is finance and investment? You can learn in this course.

  • Real Estate, Housing Price

    In this activity, we will briefly introduce real estate categories and housing price trends.

  • Rent or Buy?

    There are 3 major appraisal approaches to the value of real estate, we can compare the cost and make the decision via a very interesting and practical case on real estate appraisal.

• Week 2

  Basics of Finance and the Application of Excel

  • Efficient, Precise, Quick, Concise

    Real estate is an important part of investment. Using Excel software to calculate basic finance factors, including the present value, the future value, and the interest.

  • Know Present Value or Find Future Value?

    We will continue the time value calculation, like from present value to future value, or from future value to present value.

  • Future Value and Annuity

    With the Excel function, we can know more about FV, A, FVIF, and FVIFA, as the relationship between future value and annuity.

  • Present value and Annuity

    With the Excel function, we can know more about PV, A, PVIF, and PVIFA, as the relationship between present value and annuity.

  • Case Study

    There are some examples of time value in real estate, and we believe you have the capability to solve it in Excel. You will become a real estate mortgage analyst!

• Week 3

  Factors Affecting Real Estate Prices and the Leading Indicators

  • Leading Indicators

    To make some forecasts, factors on the supply or demand side, and leading indicators of financial crisis or recession are important.

  • Price Surge, Supply Slow

    With both supply-side and demand-side factors affecting real estate, we will have some clean and precise clues on the prediction of the real estate market.

  • Inverted Yield Curve

    Search for the yield curve in different countries in different historical periods, and then you can relate the inverted yield curve to a financial crisis or event.

  • Who Can Be the Buyer of the House?

    Discussion for some realistic cases in the real estate market. The purpose is to live or to invest? Whether we can control the house prices?

• Week 4

  Approaches of Real Estate Appraisal

  • What Is Low and What Is High?

    Why do we need real estate appraisal? Why is the real estate appraisal so important? What are the principles of real estate appraisal?

  • Cost Approach

    In this activity, we talked about the characteristics, merits, and drawbacks of the cost approach. Additionally, we introduce how the land development analysis is applied through the cost approach.

  • Market Approach

    In this activity, we talked about the characteristics, merits, and drawbacks of the market approach. Additionally, we briefly introduced the mass appraisal.

  • Income Approach

    In this activity, we talked about the characteristics, merits, and drawbacks of the income approach. Additionally, we learn how to find the net operating income, and recap cash flow analysis through a simple example.

  • Take A Chance or Take No Chances?

    We are going to compare these 3 approaches' characteristics and their differences, then you can apply them to the real estate market in reality. You can claim yourself as a real estate appraiser now!

• Week 5

  Artificial Intelligence (AI) on Real Estate Finance and Investment

  • What Is Big Data? Google Trend

    Apply Google and Google Trend to use, to take advantage, to analyze the markets through big data.

  • AI on Real Estate Mortgage Calculation

    Using the app on the NCCU Real Estate Research Center, you will find there are several functions like amortization, the price suitable for you to pay, and so on.

  • Make Predictions for Housing Price

    We basically introduce the real estate mass appraisal through multiple regression, and it's also called the computer-assisted mass appraisal.

  • Can We Get the Appraised Value?

    How much is a new building? We are going to use Excel software to conduct the mass appraisal.

• Week 6

  Real Estate Financial Feasibility Analysis

  • Investment Decision Making

    Accept or reject? The cash flow analysis, debt coverage ratio, NPV, and IRR can assist us in making a good decision.

  • Real Estate Development Feasibility Analysis

    There is a hotel development example, similar to other income-producing properties. Elements of the feasibility are income, expenses, capital structure, capital repayment tax rate, and future reversion value.

  • Investor Requirements

    Finish this financial feasibility analysis, you can really claim yourself a real estate expert!

Who will you learn with?