Stress Analysis (beta) for Barrons Roundtable Picks (5/7/11) (+550 Basis Points) What is this?

Many financial advisors routinely suggest basic planning techniques to squeeze more out of a municipal bond portfolio. These include:

  1. Stress Testing For Losses
  2. Harvesting Gains
  3. Harvesting Losses

Consider selling longer dated, low coupon bonds which could suffer losses in an upward interest as modeled in a stress test. The bonds below that are highlighted in yellow represent bonds that could suffer losses in an upward interest rate movement.

Stress Analysis for Barrons Roundtable Picks (5/7/11)
CUSIP Maturity Date Coupon Quantity Purchase Price Market Value Gain/Loss Gain/Loss %
798147V76 08/01/2036 4.250 100 $100.00 $96,417.00 $-36,740.00 -38.11%
97710BSU7 11/15/2033 5.000 100 $100.00 $108,200.00 $-36,478.00 -33.71%
414004RG8 08/15/2030 5.000 100 $100.00 $115,130.66 $-36,436.00 -31.65%
545413CN4 09/01/2036 4.500 100 $100.00 $98,824.67 $-36,367.00 -36.80%
072024JJ2 04/01/2034 5.000 100 $100.00 $114,331.00 $-36,280.00 -31.73%
13033LEH6 08/15/2034 5.000 100 $100.00 $107,720.50 $-36,280.00 -33.68%
57586ENJ6 07/01/2034 5.000 100 $100.00 $111,498.00 $-36,280.00 -32.54%
79765A3H7 05/01/2032 5.250 100 $100.00 $117,533.00 $-36,142.00 -30.75%
57586ETL5 10/01/2035 5.000 100 $100.00 $108,896.00 $-35,994.00 -33.05%
649905UZ7 07/01/2034 5.250 100 $100.00 $116,594.00 $-35,870.00 -30.76%
427101EY2 08/01/2026 4.500 100 $100.00 $97,019.20 $-35,253.00 -36.34%
91412F5Z6 05/15/2034 5.750 100 $100.00 $123,017.66 $-35,066.00 -28.50%
74526QZS4 07/01/2032 6.050 100 $100.00 $99,750.00 $-34,801.00 -34.89%
66285WFY7 01/01/2034 6.000 100 $100.00 $120,938.33 $-34,673.00 -28.67%
64972FXS0 06/15/2040 5.750 100 $100.00 $119,676.50 $-32,827.00 -27.43%
882667AC2 06/30/2032 7.500 100 $100.00 $119,217.00 $-32,547.00 -27.30%
45200BH50 12/01/2042 5.000 100 $100.00 $108,206.00 $-32,167.00 -29.73%
45200FTZ2 11/01/2038 7.250 100 $100.00 $118,852.00 $-31,933.00 -26.87%
167593GF3 01/01/2041 6.500 100 $100.00 $121,000.00 $-31,667.00 -26.17%
13063BBU5 11/01/2039 7.350 100 $100.00 $145,140.00 $-31,523.00 -21.72%
27627LQH5 09/01/2023 5.400 100 $100.00 $117,882.30 $-30,540.00 -25.91%
13063AKV5 11/01/2020 5.000 100 $100.00 $117,250.00 $-25,382.00 -21.65%
287272DB1 09/01/2020 5.000 100 $100.00 $96,500.00 $-25,382.00 -26.30%
64972FU61 06/15/2019 5.000 100 $100.00 $121,500.00 $-22,906.00 -18.85%
849476LL8 02/01/2018 5.000 100 $100.00 $118,264.00 $-20,092.00 -16.99%
57429RBP7 03/01/2017 5.250 100 $100.00 $116,532.00 $-16,821.00 -14.43%
940157PY0 06/01/2015 5.000 100 $100.00 $109,080.50 $-9,330.00 -8.55%
544435YW4 05/15/2038 5.375 100 $100.00 $110,298.00 $100.00 0.09%

Consider selling bonds that have gains equivalent to more than 3 years of interest. The highlighted bonds below are the bonds that meet this criteria.

Stress Analysis for Barrons Roundtable Picks (5/7/11)
CUSIP Maturity Date Coupon Quantity Purchase Price Market Value Gain/Loss Gain/Loss %
798147V76 08/01/2036 4.250 100 $100.00 $96,417.00 $-36,740.00 -38.11%
97710BSU7 11/15/2033 5.000 100 $100.00 $108,200.00 $-36,478.00 -33.71%
414004RG8 08/15/2030 5.000 100 $100.00 $115,130.66 $-36,436.00 -31.65%
545413CN4 09/01/2036 4.500 100 $100.00 $98,824.67 $-36,367.00 -36.80%
072024JJ2 04/01/2034 5.000 100 $100.00 $114,331.00 $-36,280.00 -31.73%
13033LEH6 08/15/2034 5.000 100 $100.00 $107,720.50 $-36,280.00 -33.68%
57586ENJ6 07/01/2034 5.000 100 $100.00 $111,498.00 $-36,280.00 -32.54%
79765A3H7 05/01/2032 5.250 100 $100.00 $117,533.00 $-36,142.00 -30.75%
57586ETL5 10/01/2035 5.000 100 $100.00 $108,896.00 $-35,994.00 -33.05%
649905UZ7 07/01/2034 5.250 100 $100.00 $116,594.00 $-35,870.00 -30.76%
427101EY2 08/01/2026 4.500 100 $100.00 $97,019.20 $-35,253.00 -36.34%
91412F5Z6 05/15/2034 5.750 100 $100.00 $123,017.66 $-35,066.00 -28.50%
74526QZS4 07/01/2032 6.050 100 $100.00 $99,750.00 $-34,801.00 -34.89%
66285WFY7 01/01/2034 6.000 100 $100.00 $120,938.33 $-34,673.00 -28.67%
64972FXS0 06/15/2040 5.750 100 $100.00 $119,676.50 $-32,827.00 -27.43%
882667AC2 06/30/2032 7.500 100 $100.00 $119,217.00 $-32,547.00 -27.30%
45200BH50 12/01/2042 5.000 100 $100.00 $108,206.00 $-32,167.00 -29.73%
45200FTZ2 11/01/2038 7.250 100 $100.00 $118,852.00 $-31,933.00 -26.87%
167593GF3 01/01/2041 6.500 100 $100.00 $121,000.00 $-31,667.00 -26.17%
13063BBU5 11/01/2039 7.350 100 $100.00 $145,140.00 $-31,523.00 -21.72%
27627LQH5 09/01/2023 5.400 100 $100.00 $117,882.30 $-30,540.00 -25.91%
13063AKV5 11/01/2020 5.000 100 $100.00 $117,250.00 $-25,382.00 -21.65%
287272DB1 09/01/2020 5.000 100 $100.00 $96,500.00 $-25,382.00 -26.30%
64972FU61 06/15/2019 5.000 100 $100.00 $121,500.00 $-22,906.00 -18.85%
849476LL8 02/01/2018 5.000 100 $100.00 $118,264.00 $-20,092.00 -16.99%
57429RBP7 03/01/2017 5.250 100 $100.00 $116,532.00 $-16,821.00 -14.43%
940157PY0 06/01/2015 5.000 100 $100.00 $109,080.50 $-9,330.00 -8.55%
544435YW4 05/15/2038 5.375 100 $100.00 $110,298.00 $100.00 0.09%

Consider selling bonds that have losses that can offset gains either in your bond portfolio or within other assets classes. Below are the bonds that have the most losses in descending order.

Stress Analysis for Barrons Roundtable Picks (5/7/11)
CUSIP Maturity Date Coupon Quantity Purchase Price Market Value Gain/Loss Gain/Loss %
798147V76 08/01/2036 4.250 100 $100.00 $96,417.00 $-36,740.00 -38.11%
97710BSU7 11/15/2033 5.000 100 $100.00 $108,200.00 $-36,478.00 -33.71%
414004RG8 08/15/2030 5.000 100 $100.00 $115,130.66 $-36,436.00 -31.65%
545413CN4 09/01/2036 4.500 100 $100.00 $98,824.67 $-36,367.00 -36.80%
072024JJ2 04/01/2034 5.000 100 $100.00 $114,331.00 $-36,280.00 -31.73%
13033LEH6 08/15/2034 5.000 100 $100.00 $107,720.50 $-36,280.00 -33.68%
57586ENJ6 07/01/2034 5.000 100 $100.00 $111,498.00 $-36,280.00 -32.54%
79765A3H7 05/01/2032 5.250 100 $100.00 $117,533.00 $-36,142.00 -30.75%
57586ETL5 10/01/2035 5.000 100 $100.00 $108,896.00 $-35,994.00 -33.05%
649905UZ7 07/01/2034 5.250 100 $100.00 $116,594.00 $-35,870.00 -30.76%
427101EY2 08/01/2026 4.500 100 $100.00 $97,019.20 $-35,253.00 -36.34%
91412F5Z6 05/15/2034 5.750 100 $100.00 $123,017.66 $-35,066.00 -28.50%
74526QZS4 07/01/2032 6.050 100 $100.00 $99,750.00 $-34,801.00 -34.89%
66285WFY7 01/01/2034 6.000 100 $100.00 $120,938.33 $-34,673.00 -28.67%
64972FXS0 06/15/2040 5.750 100 $100.00 $119,676.50 $-32,827.00 -27.43%
882667AC2 06/30/2032 7.500 100 $100.00 $119,217.00 $-32,547.00 -27.30%
45200BH50 12/01/2042 5.000 100 $100.00 $108,206.00 $-32,167.00 -29.73%
45200FTZ2 11/01/2038 7.250 100 $100.00 $118,852.00 $-31,933.00 -26.87%
167593GF3 01/01/2041 6.500 100 $100.00 $121,000.00 $-31,667.00 -26.17%
13063BBU5 11/01/2039 7.350 100 $100.00 $145,140.00 $-31,523.00 -21.72%
27627LQH5 09/01/2023 5.400 100 $100.00 $117,882.30 $-30,540.00 -25.91%
13063AKV5 11/01/2020 5.000 100 $100.00 $117,250.00 $-25,382.00 -21.65%
287272DB1 09/01/2020 5.000 100 $100.00 $96,500.00 $-25,382.00 -26.30%
64972FU61 06/15/2019 5.000 100 $100.00 $121,500.00 $-22,906.00 -18.85%
849476LL8 02/01/2018 5.000 100 $100.00 $118,264.00 $-20,092.00 -16.99%
57429RBP7 03/01/2017 5.250 100 $100.00 $116,532.00 $-16,821.00 -14.43%
940157PY0 06/01/2015 5.000 100 $100.00 $109,080.50 $-9,330.00 -8.55%
544435YW4 05/15/2038 5.375 100 $100.00 $110,298.00 $100.00 0.09%
Powered by BondView.com
© 2012 BondView.com
Nag
  • More Advanced Price Data
  • Portfolio Report Cards
  • Bond Trend Early Warning System
  • High Net Worth Reports
  • Bond Ratings
* indicates a required field
* I agree to the site's Terms & Conditions

No Thanks