Need help with formulas for the Decimals and the bottom picture. Thanks!
File Home Insert Page Layout Formulas Data Review View Developer Help Power Pivot Search sh AutoSum Times New Roman 11 A == Wrap Text Number Bad Good Neutral S. 28 O X Cut LG Copy Format Painter Fill aste Normal Conditional Format as Calculation Formatting Table BIU MA $ %, 8 Merge & Center Check Cell Explanatory... Input Insert Delete Format Clear Sort & Find & Filter Select Clipboard Font Alignment Number Styles Cells Editing 80 =(D80/D79) *12 A B D E F G H I J K L M N O 1 Finance 410 Managerial Finance Problem 2 Risk and Return with Equi-likely Probabilities 2 3 1 5 5 7 1 ATT 19.15 2 3 4. 5 Date 5yr T-Note Decimal 12/1/2004 3.61 1/3/2005 3.69 2/1/2005 3.99 3/1/2005 4.17 4/1/2005 3.9 5/2/2005 3.75 6/1/2005 3.72 7/1/2005 4.12 8/1/2005 3.87 9/1/2005 4.2 10/3/2005 4.45 11/1/2005 4.43 Monthly Annualized %Chg %Chg 12.3895 1.0325 11.6965 0.9747 12.2268 1.0189 11.7706 0.9809 11.7587 0.9799 12.3594 1.0300 11.9983 0.9999 12.4316 1.0360 11.8653 0.9888 12.0834 1.0069 11.7871 0.9823 12.4222 1.0352 S&P 500 1211.92 1181.27 1203.6 1180.59 1156.85 1191.5 1191.33 1234.18 1220.33 1228.81 1207.01 1249.48 17.89 18.11 17.83 18.16 17.84 18.12 18.91 18.62 Monthly Annualized %Chg %Chg 12.2822 1.0235 11.2104 0.9342 12.1476 1.0123 11.8145 0.9845 12.2221 1.0185 11.7885 0.9824 12.1883 1.0157 12.5232 1.0436) 11.8160 0.9847 11.9484 0.9957 12.1036 1.0086 12.5326 1.0444 6 Monthly Annualized %Chg %Chg 12.7821 1.0652 11.0135 0.9178 12.8000 1.0667 11.5454 0.9621 11.6087 0.9674 12.8245 1.0687 12.1543 1.0129 13.6383 1.1365 12.3515 1.0293 12.7052 1.0588 10.7909 0.8992 13.1845 1.0987 CAT 42.33 38.85 41.44 39.87 38.57 41.22 41.75 47.45 48.84 51.71 46.5 51.09 7 8 9 0 18.54 18.7 1 2 19.53 30 X =(D80/D79) *12 A . C D E F G H I J K L M N Finance 410 Managerial Finance Problem 2 Risk and Return with Equi-likely Probabilities - Date 5yr T-Note Decimal 9/1/2010 1.49 ATT Monthly Annualized %Chg %Chg 12.6310 1.0526 S&P 500 1104.51 Monthly Annualized %Chg %Chg 12.1820 1.0152 CAT 70.08 Monthly Annualized %Chg %Chg 12.9061 1.0755 27.44 1 2 3 4. COUNT fn AVERAGE fn VARP fn STDEVP fn Coef Varn RANK fn 3 3 7 3 3 COVAR fn Use Annualized Returns. 1 File Home Insert Page Layout Formulas Data Review View Developer Help Power Pivot Search sh AutoSum Times New Roman 11 A == Wrap Text Number Bad Good Neutral S. 28 O X Cut LG Copy Format Painter Fill aste Normal Conditional Format as Calculation Formatting Table BIU MA $ %, 8 Merge & Center Check Cell Explanatory... Input Insert Delete Format Clear Sort & Find & Filter Select Clipboard Font Alignment Number Styles Cells Editing 80 =(D80/D79) *12 A B D E F G H I J K L M N O 1 Finance 410 Managerial Finance Problem 2 Risk and Return with Equi-likely Probabilities 2 3 1 5 5 7 1 ATT 19.15 2 3 4. 5 Date 5yr T-Note Decimal 12/1/2004 3.61 1/3/2005 3.69 2/1/2005 3.99 3/1/2005 4.17 4/1/2005 3.9 5/2/2005 3.75 6/1/2005 3.72 7/1/2005 4.12 8/1/2005 3.87 9/1/2005 4.2 10/3/2005 4.45 11/1/2005 4.43 Monthly Annualized %Chg %Chg 12.3895 1.0325 11.6965 0.9747 12.2268 1.0189 11.7706 0.9809 11.7587 0.9799 12.3594 1.0300 11.9983 0.9999 12.4316 1.0360 11.8653 0.9888 12.0834 1.0069 11.7871 0.9823 12.4222 1.0352 S&P 500 1211.92 1181.27 1203.6 1180.59 1156.85 1191.5 1191.33 1234.18 1220.33 1228.81 1207.01 1249.48 17.89 18.11 17.83 18.16 17.84 18.12 18.91 18.62 Monthly Annualized %Chg %Chg 12.2822 1.0235 11.2104 0.9342 12.1476 1.0123 11.8145 0.9845 12.2221 1.0185 11.7885 0.9824 12.1883 1.0157 12.5232 1.0436) 11.8160 0.9847 11.9484 0.9957 12.1036 1.0086 12.5326 1.0444 6 Monthly Annualized %Chg %Chg 12.7821 1.0652 11.0135 0.9178 12.8000 1.0667 11.5454 0.9621 11.6087 0.9674 12.8245 1.0687 12.1543 1.0129 13.6383 1.1365 12.3515 1.0293 12.7052 1.0588 10.7909 0.8992 13.1845 1.0987 CAT 42.33 38.85 41.44 39.87 38.57 41.22 41.75 47.45 48.84 51.71 46.5 51.09 7 8 9 0 18.54 18.7 1 2 19.53 30 X =(D80/D79) *12 A . C D E F G H I J K L M N Finance 410 Managerial Finance Problem 2 Risk and Return with Equi-likely Probabilities - Date 5yr T-Note Decimal 9/1/2010 1.49 ATT Monthly Annualized %Chg %Chg 12.6310 1.0526 S&P 500 1104.51 Monthly Annualized %Chg %Chg 12.1820 1.0152 CAT 70.08 Monthly Annualized %Chg %Chg 12.9061 1.0755 27.44 1 2 3 4. COUNT fn AVERAGE fn VARP fn STDEVP fn Coef Varn RANK fn 3 3 7 3 3 COVAR fn Use Annualized Returns. 1
