Tabular
TemporalData
DateListPlot

Social Sciences
Time-Related Computation
Finance & Economics
Data Science
Tabular Processing

Compare Rent and Mortgage Payments

Compare the monthly cost of various size apartments to the mortgage for a median priced home

Open in Cloud
Download Notebook

Obtain raw temporal data from multiple built-in data sources:

In[1]:=

rawtemporal=TemporalData

Append[

]

,MetaInformation{"PathNames"{"HomePrice","Studio","1BR","2BR","3BR","4BR","Rate"}}

Out[1]=

TemporalData

Time: 01 Apr 1971 to 01 May 2025
Data points: 941	Paths: 7



Visualize the raw data, which needs to be standardized:

In[2]:=

DateListPlot[QuantityMagnitude@rawtemporal,ScalingFunctions"Log",JoinedFalse,PlotLegendsrawtemporal["PathNames"]]

Out[2]=

Select a subset of the data to study:

In[3]:=

tabular=ToTabular@TimeSeriesResample[TimeSeriesWindow[rawtemporal,{"Jan 1990","Dec 2010"}],"Union",ResamplingMethodNone]

Out[3]=

Define a function to transform the price and mortgage rate into monthly mortgage payments:

In[4]:=

mortgageCalc=With[{body=

First

SolveValues[#1TimeValue[Annuity[p,30,1/12],EffectiveInterest[#2,1/12],0],p]},Function[Quantity[body,1/"Months"]]]

Out[4]=

0.0833333#112.-1.

1/12

(

(12.+#2)

)



1.-

3.200726585467079×

388

360

(12.+#2)

per month

Convert the home price data to mortgage payment data:

In[5]:=

derivedtab=ConstructColumns[Select[tabular,!MissingQ[#HomePrice]&],{"Date","Mortgage"Function[mortgageCalc[#HomePrice,#Rate]],"Studio","1BR","2BR","3BR","4BR"}]

Out[5]=

Interpolate missing values:

In[6]:=

interpolatedtab=TransformMissing[derivedtab,{"Interpolation",InterpolationOrder1}]

Out[6]=

Compare the monthly costs of various housing options. Notice the effects of the 2008 crash in housing prices:

In[7]:=

DateListPlot[interpolatedtabThread[{"Date",{"Mortgage","Studio","1BR","2BR","3BR","4BR"}}],PlotLegends{"Mortgage","Studio","1BR","2BR","3BR","4BR"}]

Out[7]=

External Links

City

Related Symbols

Tabular
TemporalData
DateListPlot

Publisher Information

Contributed by: John McNally