12. Use the worksheet in the file Chapter 05 Excel Outboxes.xls to compute the (30-year/1-year) and (30-year/10-year) ratios of optimal stock allocations when the market is on the trend . a. Using these ratios to approximate the corresponding risk aversion ratios in the horizon-dependent risk aversion model, set the long-run risk aversion to 1.1 and fit the HD RRA model. b. Using the spreadsheet find the optimal portfolios for 1-, 5-, 10-, 15-, 20-, 25-, and 30-year horizons. (Note: The links in this spreadsheet should have pulled in the horizon dependent risk aversions from part (a). Otherwise copy them into the appropriate cells.) c. Using Excel's chart wizard to create an xy graph, plot the HD RRA model's total equity allocation at these horizons versus the corresponding equity allocations from the DP mean reversion model. How well did the HD RRA model capture the horizon implications of the mean reversion?

Horizon Dependent Risk Aversion
Assumptions					Shortfall Constraint
Long-term Risk Aversion			1.25		H	0.00%
Long-term Horizon (N)			30		m	7.50%
Ratio: ST/LT Risk Aversion			5		s	15.00%
Ratio: 1YR/10YR Risk Aversion			3.5		PS(1)	0.3085
Program
Objective	Min		0.0000
f			1.3215
g			-4.00
y			1.250
			f(T)			l
t	T	PS(T)	1/T	f = 1	f = opt	l=y(1-g(1/T))	l=y(1-gX)	l=y(1-gXf)