You need to calculate the 1-year interest rates for 10 years using the yield to maturities for bonds of various terms to maturity (see Columns F to Column O) and liquidity premiums (see Column P to Column Y) provided under the Expectations Theory and Liquidity Premium Theory.

House Price	Rate 1	Years	Rate 2	YTM 1 year	YTM 2 year	YTM 3 year	YTM 4 year	YTM 5 year	YTM 6 year	YTM 7 year	YTM 8 year	YTM 9 year	YTM 10 year	LP 1 year	LP 2 year	LP 3 year	LP 4 year	LP 5 year	LP 6 year	LP 7 year	LP 8 year	LP 9 year	LP 10 year	Start year	End year	observation_date	M1SL	AMBSL
$450,000	16.00%	9	8.00%	5.00%	5.25%	5.75%	6.00%	6.20%	6.40%	6.80%	7.00%	7.30%	7.80%	0.00%	0.10%	0.20%	0.30%	0.40%	0.50%	0.60%	0.70%	0.80%	0.90%	2003	2013	2/1/01	1101.2	619.425