Follow Appendix A starting on page 384 as a guideline to your completing your project. The title of Appendix A is "Approaches to Area Market Forecasting:".
First you need to choose a market. In reading the appendix, you will see examples of markets such as San Francisco. Basically, a market is a city. This Appendix also provides data sources you can use to obtain your data for your market. Use these data sources
www.dol.gov
and
www.census.gov/eos/www/naicsto gather data to model in the formulas provided in the Appendix where you will run regressions to forecast the amount of for office, warehouse, retail and manufacturing housing units. Thus, you will run four separateregressions. There is a regression function in Excel where you will specify your dependent and independent variables. The driver variables, which are in the Appendix, are the independent variables. These variables depend upon the employment base for that market such as Oil industry is a driver for the Houston office market.
In your write-up, you will identify your1.data sources,2.display charts with your data,3. provided descriptive statistics of your data (ie. mean, median, mode, standard deviation, number of observations). Excel computes descriptive statistics, as well.4. provide a table with your regression results5. explain the regression results as discussed in the Appendix6. provide a summary of why the results (information) obtained from Area Market Forecastingis important to lenders as a part of evaluatingwhether or not a bank should lend to a commercialborrower
Write a minimum of 2 double spaced pages for each property type, which includes all six items above. There are four property types (office, warehouse, retail and manufacturing housing units). This will be a total of 8 pages.
Market segments are discussed in the Appendix. Market segments are groups within the market such as senior housing in San Francisco. You do not need to address market segments in your paper.
I can provide the book, which has the appendix.