Find Jobs
Hire Freelancers

Real Estate Analysis with Excel

$10-30 USD

V teku
Objavljeno pred približno 5 leti

$10-30 USD

Plačilo ob dostavi
Staple pages. Write your name on the front of the first page AND the back of the last page that you hand in [1pt]. 1. [12pts] Google the St Louis Economics Database (“Fred II”) and download the monthly constant maturity 1-year and 10-year series (excel-format, denoted GS1 and GS10, respectively). Similarly, google the Bureau of Labor Statistics (“BLS”) and create a spreadsheet of the all-urban CPI (“inflation”) index. a. Compute a column that shows the YoY inflation rate, as a monthly series. b. Plot the monthly 1-yr CMT, 10-yr CMT, and inflation rate on a single graph, from (at least) the 1960’s through the present. Make sure that the x-axis matches the available data range. c. Comment on the peak in the early 80’s and on the state of affairs from the late 90’s through the present. 2. [12pts] Recreate the real Case-Shiller index for the Los Angeles by similarly obtaining the necessary data from a web-search (Standard and Poor’s). Note that the index you download will be a nominal index. Show both the nominal and real indexes on one plot, using the earliest available Case-Shiller date as the base period. 3. [11pts] Download the (not seasonally adjusted) monthly shelter component of CPI for LA/Orange/Riverside (or LA-Long Beach Anaheim). Plot the ratio of nominal price (from question 2) to cost of shelter index. Normalize the ratio to be 59.33 on Jan 1, 1987. What does this ratio tell you about rent inflation when compared to the real LXXR? 4. [4pts] How far are we currently from the 2006 peak (in percent), in nominal and real terms? Do you think we are back in a bubble? So so/not, why/not?
ID projekta: 18658605

Več o projektu

6 ponudb
Projekt na daljavo
Aktivno pred 5 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
6 freelancerjev je oddalo ponudbo s povprečno vrednostjo $43 USD za to delo
Avatar uporabnika
I possess exceptional data and statistical analysis experience. I use Excel, STATA, R-Programming and SPSS software’s in qualitative and quantitative research and report writing. I hold MBA (Strategic Management) undergraduate degree (Statistics) & CPA.K (Accounting and statistics.) As a data and research analyst, I have attained utmost discipline in delivering quality, accurate and reliable results. Happy to work with YOU
$100 USD v 1 dnevu
4,5 (51 ocen)
5,6
5,6
Avatar uporabnika
HELLO! As an: - Bachelor of Applied Mathematics - Engineer in Statistics and Applied Economics - Microsoft Office Technician (Microsoft Graduate: MOS Diploma), - I have skills in programming language R, Python, Minitab, SPSS, STATA I am able, available and ready to do this kind of work in the best conditions, ------------------------------------------------------------
$30 USD v 1 dnevu
5,0 (37 ocen)
4,9
4,9
Avatar uporabnika
I believe that my experience and skill in this background will prove to be of great help to you. Contact me to discuss more on the details
$35 USD v 1 dnevu
5,0 (3 ocen)
3,9
3,9
Avatar uporabnika
ადამიანური რესურსების მართვის მენეჯერიადამიანური რესურსების მართვის მენეჯერიადამიანური რესურსების მართვის მენეჯერიადამიანური რესურსების მართვის მენეჯერიადამიანური რესურსების მართვის მენეჯერი
$35 USD v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
Hi ! I Have Seen your Job Description. I have 5 years Experience this work. Can I Help you Work? Please Check My Portfolio. I am waiting for your response.
$25 USD v 3 dneh
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava UNITED STATES
Pomona, United States
5,0
1
Plačilna metoda je verificirana
Član(ica) od feb. 4, 2019

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.