Reference no: EM13977461

Need help with assignment:

Please pay attention to the pattern of returns for T-bills as it is all positive, and Stocks and T-bonds positive/negative (you received copy in an earlier e-mail). The average rates (arithmatic or geometric) have been higher in the early years up to 1960, then lower and negative in the 2000-2010. Your take and thought on the subject.

1. What is the average geometric return over 1990-2000?

Geometric return=[(1+r1)(1+r2)...(1+rn)]^1/n  -1

where r1, r2, rn are return on the stock in 1, 2  and nth period.

2. Stocks or bonds, which one is overpriced and why? Support your answer with facts not an assumption, Use historical P/E and yield spread (stock yield that is E/P less yield in T-bond). Correct analysis get you one letter grade bonus

Attachment:- stocksbonds bills (1).xlsx