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.

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

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.

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.

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

With the Excel function, we can know more about FV, A, FVIF, and FVIFA, as the relationship between future 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.

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!

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

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.

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.

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?

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

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.

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

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.

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!

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

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.

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

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

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

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.

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