Question: Any tips on how I would start on this spreadsheet. How do I find the 10 year T-Bond? Data 2 31JAN2008 3 29FEd2008 4 31

Any tips on how I would start on this spreadsheet. How do I find the 10 year T-Bond?

Data 2 31JAN2008 3 29FEd2008 4 31 MAR2008 6 30APR2008 6 30MAY2008 7 30JUN2008 8 31JUL2008 g 29AUG2008 10 30SEP2008 11 310CT2008 12 28NOV2008 13 31 DEC2008 14 30JAN2009 15 27FEd200g 16 31 MAR2009 17 30APR2009 18 29MAY2009 19 30JUN2009 20 31JUL200g 21 31AUG2009 22 30SEP200g 23 300CT200g 24 30NOV2009 Ticker XRX XRX XRX xzx xzx XRX xzx XRX XRX XRX XRX xzx xzx XRX xzx XRX XRX XRX XRX xzx xzx XRX xzx c Com an XEROX CORP XEROX CORP XEROX CORP XEROX CORP XEROX CORP XEROX CORP XEROX CORP XEROX CORP XEROX CORP XEROX CORP XEROX CORP XEROX CORP XEROX CORP XEROX CORP XEROX CORP XEROX CORP XEROX CORP XEROX CORP XEROX CORP XEROX CORP XEROX CORP XEROX CORP XEROX CORP Stock Return Valua Wei -0.046943 _0_04731 0.021259 -0.0668 -0.027917; 0.001657 0.021261 -0.169239 -0.304423 -m 128429 0.14628 -0.21988 -0.113417 0.342867 0.11293 -0.040809 0_263889 0.066166 -o. 100289t -0.028424 0.023936 htad Market Index -0.062161 -0.021663 -0.01042 0.061106 0_023842 -0.078434 -0.01333 0.010564 -0.098006 -0.184603 -0.0846161 0.0221491 -0.07733 -0.100214! 0.086692 0.109369 0.067789 -0.003098 0.0817191 0.0314691 0_046222 -0.027993 0.067098 Bata 10 Year T-Bond CAPM Required Return "*Calculate using regression analysis. ml_ook this up onlina_ Calculate based on CAPM formula
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
