Overview

ScenarioAnalysis
PortfolioReturn
PriceYieldRelationship
Immunization
ScenarioAnalysis_SU
ScenarioAnalysis_MT
ScenarioAnalysis_ALLY
ScenarioAnalysis_ET


Sheet 1: ScenarioAnalysis

Name MPC






Price $957.51






Coupon 5.85%






Maturity 21






YTM 6.22%






Investment Horizon 20
















Yield at the End of Investment Horizon

5.00% 6.00% 7.00% 8.00% 9.00% 10.00% 11.00% 12.00%










Horizon Price

$1,008.19 $998.56 $989.08 $979.72 $970.51 $961.42 $952.46 $943.62









Reinvestment Rate Total Future Dollars
3.00% $2,595.53 $2,585.90 $2,576.41 $2,567.06 $2,557.84 $2,548.75 $2,539.79 $2,530.96
3.50% $2,682.29 $2,672.66 $2,663.18 $2,653.82 $2,644.60 $2,635.52 $2,626.56 $2,617.72
4.00% $2,774.95 $2,765.32 $2,755.83 $2,746.48 $2,737.26 $2,728.18 $2,719.22 $2,710.38
4.50% $2,873.94 $2,864.31 $2,854.82 $2,845.47 $2,836.25 $2,827.16 $2,818.20 $2,809.37
5.00% $2,979.72 $2,970.09 $2,960.60 $2,951.25 $2,942.03 $2,932.94 $2,923.98 $2,915.15
5.50% $3,092.78 $3,083.16 $3,073.67 $3,064.32 $3,055.10 $3,046.01 $3,037.05 $3,028.22
6.00% $3,213.68 $3,204.05 $3,194.56 $3,185.21 $3,175.99 $3,166.90 $3,157.94 $3,149.11
6.50% $3,342.97 $3,333.35 $3,323.86 $3,314.51 $3,305.29 $3,296.20 $3,287.24 $3,278.40
7.00% $3,481.29 $3,471.66 $3,462.17 $3,452.82 $3,443.60 $3,434.51 $3,425.55 $3,416.72









Reinvestment Rate Total Return
3.00% 5.11% 5.09% 5.07% 5.05% 5.04% 5.02% 5.00% 4.98%
3.50% 5.29% 5.27% 5.25% 5.23% 5.21% 5.19% 5.17% 5.16%
4.00% 5.46% 5.45% 5.43% 5.41% 5.39% 5.37% 5.36% 5.34%
4.50% 5.65% 5.63% 5.61% 5.60% 5.58% 5.56% 5.55% 5.53%
5.00% 5.84% 5.82% 5.81% 5.79% 5.77% 5.76% 5.74% 5.72%
5.50% 6.04% 6.02% 6.00% 5.99% 5.97% 5.96% 5.94% 5.93%
6.00% 6.24% 6.23% 6.21% 6.19% 6.18% 6.16% 6.15% 6.13%
6.50% 6.45% 6.44% 6.42% 6.41% 6.39% 6.38% 6.36% 6.35%
7.00% 6.67% 6.65% 6.64% 6.62% 6.61% 6.59% 6.58% 6.57%









Rate Change to: Expected Current Value % Change in Current Value




3.00% $1,426.30 48.96%




3.50% $1,335.98 39.53%




4.00% $1,253.04 30.86%




4.50% $1,176.81 22.90%




5.00% $1,106.69 15.58%




5.50% $1,042.14 8.84%




6.00% $982.66 2.63%




6.50% $927.82 -3.10%




7.00% $877.21 -8.39%





Sheet 2: PortfolioReturn

Bond Coupon Maturity Quantity Par Value Current Value YTM
Portfolio Return (IRR)
A 7.00% 5 10,000 $10,000,000 -$9,208,728.18 9.00%
4.77%
B 10.50% 7 20,000 $20,000,000 -$20,000,000.00 10.50%

C 6.00% 3 30,000 $30,000,000 -$28,050,097.50 8.50%

Total



-$57,258,825.68











Period Bond A Bond B Bond C Portfolio



0 $0.00 $0.00 $0.00 -$57,258,825.68



1 $350,000.00 $1,050,000.00 $900,000.00 $2,300,000.00



2 $350,000.00 $1,050,000.00 $900,000.00 $2,300,000.00



3 $350,000.00 $1,050,000.00 $900,000.00 $2,300,000.00



4 $350,000.00 $1,050,000.00 $900,000.00 $2,300,000.00



5 $350,000.00 $1,050,000.00 $900,000.00 $2,300,000.00



6 $350,000.00 $1,050,000.00 $30,900,000.00 $32,300,000.00



7 $350,000.00 $1,050,000.00 $0.00 $1,400,000.00



8 $350,000.00 $1,050,000.00 $0.00 $1,400,000.00



9 $350,000.00 $1,050,000.00 $0.00 $1,400,000.00



10 $10,350,000.00 $1,050,000.00 $0.00 $11,400,000.00



11 $0.00 $1,050,000.00 $0.00 $1,050,000.00



12 $0.00 $1,050,000.00 $0.00 $1,050,000.00



13 $0.00 $1,050,000.00 $0.00 $1,050,000.00



14 $0.00 $21,050,000.00 $0.00 $21,050,000.00




Sheet 3: PriceYieldRelationship

Name Bond A
Name Bond B




Market Value $89.8641
Market Value $92.89




Coupon 4.95%
Coupon 5.25%




Maturity 23
Maturity 30




YTM 5.750%
YTM 5.75%


Price for y- $102.7803
Change in Yield 1.00%





Price for y+ $79.1257
Duration 13.16 Change Using Duration 13.16%





Convexity 121.16 Convexity Adjustment 1.21%





Estimated % Price Change(-) 14.37%







Estimated % Price Change(+) -11.95%







PVBP $0.1183

















YTM Market Value Percentage Price Change YTM Market Value Percentage Price Change



-0.25% $223.18 148.36% -0.25% $271.46 192.23%



0.75% $188.58 109.84% 0.75% $220.69 137.58%



1.75% $160.38 78.47% 1.75% $181.42 95.30%



2.75% $137.32 52.80% 2.75% $150.85 62.39%



3.75% $118.38 31.74% 3.75% $126.88 36.59%



4.75% $102.78 14.37% 4.75% $107.95 16.21%



5.75% $89.86 0.00% 5.75% $92.89 0.00%



6.75% $79.13 -11.95% 6.75% $80.81 -13.01%



7.75% $70.16 -21.93% 7.75% $71.04 -23.53%



8.75% $62.63 -30.31% 8.75% $63.06 -32.11%



9.75% $56.28 -37.37% 9.75% $56.50 -39.18%



10.75% $50.90 -43.36% 10.75% $51.05 -45.04%



11.75% $46.32 -48.46% 11.75% $46.48 -49.96%




Sheet 4: Immunization


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Coupon Income $58.500 $117.000 $175.500 $234.000 $292.500 $351.000 $409.500 $468.000 $526.500 $585.000 $643.500 $702.000 $760.500 $819.000 $877.500 $936.000 $994.500 $1,053.000 $1,111.500 $1,170.000 $1,228.500








Interest on Interest $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000








Gain/Loss $25 $26 $26 $27 $27 $28 $28 $29 $30 $31 $31 $32 $33 $34 $35 $36 $37 $38 $40 $41 $42








Total Gain/Loss $84 $143 $202 $261 $320 $379 $438 $497 $556 $616 $675 $734 $794 $853 $913 $972 $1,032 $1,091 $1,151 $1,211 $1,271








Current Rate 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00%








Holding Period Return 8.74% 7.19% 6.58% 6.20% 5.93% 5.71% 5.53% 5.37% 5.22% 5.09% 4.97% 4.86% 4.75% 4.66% 4.56% 4.48% 4.39% 4.32% 4.24% 4.17% 4.10%





























































































































































































































































































































































Constants




























Maturity 21




























Coupon 5.85%




























FV $1,000.00




























N 42




























Current Rate 6.000%




























Purchase Price $957.51




























Purchase YTM 6.215%




























Reinvest 0





























Sheet 5: ScenarioAnalysis_SU

Parameters
















Name SU
Start Yield 4.50%
10Y High 5.00% Spread 1.50%
















Price $979.96
Increment 0.25%
10Y Low 1.00% Spread 2.00%
















Coupon 6.85%
Purchased Year 2023
Suggested High
6.50%
















Maturity 16
Maturity Year 2039
Suggested Low
3.00%
















YTM 7.061% YTM (no) 4.81% Current Yield 6.990%




















Investment Horizon 15
























~MacDuration 10 y- $1,080.10 y+ $892.19




















Reinvestment Rate 0.00%




















































a) Return Based on YTM (and therefore all coupon payments are reinvested)
b) Return Based on YTM and No Coupon Payment Reinvestment
c) Return Based on YTM(no) and No Coupon Payment Reinvestment

Yield at the End of Investment Horizon
Yield at the End of Investment Horizon
Yield at the End of Investment Horizon

4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25%
4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25%
4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25%



























Investment Horizon Investment Horizon Price
Investment Horizon Price
Investment Horizon Price
1 $1,254.33 $1,223.48 $1,193.61 $1,164.69 $1,136.68 $1,109.57 $1,083.30 $1,057.86
$1,254.33 $1,223.48 $1,193.61 $1,164.69 $1,136.68 $1,109.57 $1,083.30 $1,057.86
$1,254.33 $1,223.48 $1,193.61 $1,164.69 $1,136.68 $1,109.57 $1,083.30 $1,057.86
2 $1,242.14 $1,212.97 $1,184.68 $1,157.23 $1,130.62 $1,104.80 $1,079.75 $1,055.44
$1,242.14 $1,212.97 $1,184.68 $1,157.23 $1,130.62 $1,104.80 $1,079.75 $1,055.44
$1,242.14 $1,212.97 $1,184.68 $1,157.23 $1,130.62 $1,104.80 $1,079.75 $1,055.44
3 $1,229.40 $1,201.95 $1,175.29 $1,149.39 $1,124.22 $1,099.75 $1,075.98 $1,052.87
$1,229.40 $1,201.95 $1,175.29 $1,149.39 $1,124.22 $1,099.75 $1,075.98 $1,052.87
$1,229.40 $1,201.95 $1,175.29 $1,149.39 $1,124.22 $1,099.75 $1,075.98 $1,052.87
4 $1,216.07 $1,190.41 $1,165.44 $1,141.12 $1,117.46 $1,094.41 $1,071.98 $1,050.13
$1,216.07 $1,190.41 $1,165.44 $1,141.12 $1,117.46 $1,094.41 $1,071.98 $1,050.13
$1,216.07 $1,190.41 $1,165.44 $1,141.12 $1,117.46 $1,094.41 $1,071.98 $1,050.13
5 $1,202.14 $1,178.31 $1,155.08 $1,132.42 $1,110.32 $1,088.76 $1,067.73 $1,047.22
$1,202.14 $1,178.31 $1,155.08 $1,132.42 $1,110.32 $1,088.76 $1,067.73 $1,047.22
$1,202.14 $1,178.31 $1,155.08 $1,132.42 $1,110.32 $1,088.76 $1,067.73 $1,047.22
6 $1,187.57 $1,165.64 $1,144.20 $1,123.25 $1,102.78 $1,082.78 $1,063.23 $1,044.12
$1,187.57 $1,165.64 $1,144.20 $1,123.25 $1,102.78 $1,082.78 $1,063.23 $1,044.12
$1,187.57 $1,165.64 $1,144.20 $1,123.25 $1,102.78 $1,082.78 $1,063.23 $1,044.12
7 $1,172.35 $1,152.35 $1,132.77 $1,113.60 $1,094.83 $1,076.45 $1,058.45 $1,040.83
$1,172.35 $1,152.35 $1,132.77 $1,113.60 $1,094.83 $1,076.45 $1,058.45 $1,040.83
$1,172.35 $1,152.35 $1,132.77 $1,113.60 $1,094.83 $1,076.45 $1,058.45 $1,040.83
8 $1,156.42 $1,138.42 $1,120.76 $1,103.43 $1,086.43 $1,069.75 $1,053.38 $1,037.33
$1,156.42 $1,138.42 $1,120.76 $1,103.43 $1,086.43 $1,069.75 $1,053.38 $1,037.33
$1,156.42 $1,138.42 $1,120.76 $1,103.43 $1,086.43 $1,069.75 $1,053.38 $1,037.33
9 $1,139.78 $1,123.82 $1,108.14 $1,092.72 $1,077.56 $1,062.66 $1,048.01 $1,033.60
$1,139.78 $1,123.82 $1,108.14 $1,092.72 $1,077.56 $1,062.66 $1,048.01 $1,033.60
$1,139.78 $1,123.82 $1,108.14 $1,092.72 $1,077.56 $1,062.66 $1,048.01 $1,033.60
10 $1,122.37 $1,108.53 $1,094.88 $1,081.44 $1,068.20 $1,055.16 $1,042.30 $1,029.64
$1,122.37 $1,108.53 $1,094.88 $1,081.44 $1,068.20 $1,055.16 $1,042.30 $1,029.64
$1,122.37 $1,108.53 $1,094.88 $1,081.44 $1,068.20 $1,055.16 $1,042.30 $1,029.64
11 $1,104.18 $1,092.49 $1,080.96 $1,069.57 $1,058.32 $1,047.22 $1,036.25 $1,025.43
$1,104.18 $1,092.49 $1,080.96 $1,069.57 $1,058.32 $1,047.22 $1,036.25 $1,025.43
$1,104.18 $1,092.49 $1,080.96 $1,069.57 $1,058.32 $1,047.22 $1,036.25 $1,025.43
12 $1,085.15 $1,075.69 $1,066.32 $1,057.06 $1,047.89 $1,038.81 $1,029.83 $1,020.95
$1,085.15 $1,075.69 $1,066.32 $1,057.06 $1,047.89 $1,038.81 $1,029.83 $1,020.95
$1,085.15 $1,075.69 $1,066.32 $1,057.06 $1,047.89 $1,038.81 $1,029.83 $1,020.95
13 $1,065.27 $1,058.08 $1,050.95 $1,043.88 $1,036.87 $1,029.92 $1,023.02 $1,016.18
$1,065.27 $1,058.08 $1,050.95 $1,043.88 $1,036.87 $1,029.92 $1,023.02 $1,016.18
$1,065.27 $1,058.08 $1,050.95 $1,043.88 $1,036.87 $1,029.92 $1,023.02 $1,016.18
14 $1,044.47 $1,039.62 $1,034.80 $1,030.01 $1,025.24 $1,020.51 $1,015.80 $1,011.12
$1,044.47 $1,039.62 $1,034.80 $1,030.01 $1,025.24 $1,020.51 $1,015.80 $1,011.12
$1,044.47 $1,039.62 $1,034.80 $1,030.01 $1,025.24 $1,020.51 $1,015.80 $1,011.12
15 $1,022.73 $1,020.27 $1,017.83 $1,015.39 $1,012.96 $1,010.54 $1,008.13 $1,005.73
$1,022.73 $1,020.27 $1,017.83 $1,015.39 $1,012.96 $1,010.54 $1,008.13 $1,005.73
$1,022.73 $1,020.27 $1,017.83 $1,015.39 $1,012.96 $1,010.54 $1,008.13 $1,005.73



























Investment Horizon Total Future Dollars
Total Future Dollars
Total Future Dollars
1 $1,323.60 $1,292.79 $1,262.96 $1,234.08 $1,206.12 $1,179.05 $1,152.83 $1,127.43
$1,322.83 $1,291.98 $1,262.11 $1,233.19 $1,205.18 $1,178.07 $1,151.80 $1,126.36
$1,322.83 $1,291.98 $1,262.11 $1,233.19 $1,205.18 $1,178.07 $1,151.80 $1,126.36
2 $1,383.84 $1,354.93 $1,326.90 $1,299.72 $1,273.37 $1,247.82 $1,223.04 $1,199.00
$1,379.14 $1,349.97 $1,321.68 $1,294.23 $1,267.62 $1,241.80 $1,216.75 $1,192.44
$1,379.14 $1,349.97 $1,321.68 $1,294.23 $1,267.62 $1,241.80 $1,216.75 $1,192.44
3 $1,446.81 $1,420.05 $1,394.07 $1,368.86 $1,344.37 $1,320.60 $1,297.52 $1,275.11
$1,434.90 $1,407.45 $1,380.79 $1,354.89 $1,329.72 $1,305.25 $1,281.48 $1,258.37
$1,434.90 $1,407.45 $1,380.79 $1,354.89 $1,329.72 $1,305.25 $1,281.48 $1,258.37
4 $1,512.65 $1,488.30 $1,464.65 $1,441.66 $1,419.33 $1,397.63 $1,376.54 $1,356.05
$1,490.07 $1,464.41 $1,439.44 $1,415.12 $1,391.46 $1,368.41 $1,345.98 $1,324.13
$1,490.07 $1,464.41 $1,439.44 $1,415.12 $1,391.46 $1,368.41 $1,345.98 $1,324.13
5 $1,581.48 $1,559.84 $1,538.80 $1,518.34 $1,498.47 $1,479.15 $1,460.37 $1,442.12
$1,544.64 $1,520.81 $1,497.58 $1,474.92 $1,452.82 $1,431.26 $1,410.23 $1,389.72
$1,544.64 $1,520.81 $1,497.58 $1,474.92 $1,452.82 $1,431.26 $1,410.23 $1,389.72
6 $1,653.45 $1,634.81 $1,616.70 $1,599.10 $1,582.01 $1,565.42 $1,549.31 $1,533.66
$1,598.57 $1,576.64 $1,555.20 $1,534.25 $1,513.78 $1,493.78 $1,474.23 $1,455.12
$1,598.57 $1,576.64 $1,555.20 $1,534.25 $1,513.78 $1,493.78 $1,474.23 $1,455.12
7 $1,728.69 $1,713.38 $1,698.54 $1,684.16 $1,670.22 $1,656.72 $1,643.66 $1,631.02
$1,651.85 $1,631.85 $1,612.27 $1,593.10 $1,574.33 $1,555.95 $1,537.95 $1,520.33
$1,651.85 $1,631.85 $1,612.27 $1,593.10 $1,574.33 $1,555.95 $1,537.95 $1,520.33
8 $1,807.36 $1,795.74 $1,784.53 $1,773.74 $1,763.35 $1,753.36 $1,743.76 $1,734.55
$1,704.42 $1,686.42 $1,668.76 $1,651.43 $1,634.43 $1,617.75 $1,601.38 $1,585.33
$1,704.42 $1,686.42 $1,668.76 $1,651.43 $1,634.43 $1,617.75 $1,601.38 $1,585.33
9 $1,889.60 $1,882.05 $1,874.87 $1,868.08 $1,861.66 $1,855.62 $1,849.95 $1,844.65
$1,756.28 $1,740.32 $1,724.64 $1,709.22 $1,694.06 $1,679.16 $1,664.51 $1,650.10
$1,756.28 $1,740.32 $1,724.64 $1,709.22 $1,694.06 $1,679.16 $1,664.51 $1,650.10
10 $1,975.59 $1,972.51 $1,969.79 $1,967.44 $1,965.46 $1,963.86 $1,962.61 $1,961.74
$1,807.37 $1,793.53 $1,779.88 $1,766.44 $1,753.20 $1,740.16 $1,727.30 $1,714.64
$1,807.37 $1,793.53 $1,779.88 $1,766.44 $1,753.20 $1,740.16 $1,727.30 $1,714.64
11 $2,065.50 $2,067.31 $2,069.51 $2,072.09 $2,075.05 $2,078.40 $2,082.14 $2,086.27
$1,857.68 $1,845.99 $1,834.46 $1,823.07 $1,811.82 $1,800.72 $1,789.75 $1,778.93
$1,857.68 $1,845.99 $1,834.46 $1,823.07 $1,811.82 $1,800.72 $1,789.75 $1,778.93
12 $2,159.49 $2,166.68 $2,174.28 $2,182.30 $2,190.75 $2,199.63 $2,208.94 $2,218.70
$1,907.15 $1,897.69 $1,888.32 $1,879.06 $1,869.89 $1,860.81 $1,851.83 $1,842.95
$1,907.15 $1,897.69 $1,888.32 $1,879.06 $1,869.89 $1,860.81 $1,851.83 $1,842.95
13 $2,257.76 $2,270.82 $2,284.35 $2,298.38 $2,312.90 $2,327.92 $2,343.46 $2,359.53
$1,955.77 $1,948.58 $1,941.45 $1,934.38 $1,927.37 $1,920.42 $1,913.52 $1,906.68
$1,955.77 $1,948.58 $1,941.45 $1,934.38 $1,927.37 $1,920.42 $1,913.52 $1,906.68
14 $2,360.50 $2,379.96 $2,400.00 $2,420.62 $2,441.85 $2,463.70 $2,486.18 $2,509.31
$2,003.47 $1,998.62 $1,993.80 $1,989.01 $1,984.24 $1,979.51 $1,974.80 $1,970.12
$2,003.47 $1,998.62 $1,993.80 $1,989.01 $1,984.24 $1,979.51 $1,974.80 $1,970.12
15 $2,467.92 $2,494.35 $2,521.50 $2,549.37 $2,578.00 $2,607.40 $2,637.59 $2,668.59
$2,050.23 $2,047.77 $2,045.33 $2,042.89 $2,040.46 $2,038.04 $2,035.63 $2,033.23
$2,050.23 $2,047.77 $2,045.33 $2,042.89 $2,040.46 $2,038.04 $2,035.63 $2,033.23



























Investment Horizon Total Return
Total Return
Total Return
1 35.07% 31.92% 28.88% 25.93% 23.08% 20.32% 17.64% 15.05%
34.99% 31.84% 28.79% 25.84% 22.98% 20.22% 17.54% 14.94%
34.99% 31.84% 28.79% 25.84% 22.98% 20.22% 17.54% 14.94%
2 18.83% 17.59% 16.36% 15.17% 13.99% 12.84% 11.72% 10.61%
18.63% 17.37% 16.13% 14.92% 13.73% 12.57% 11.43% 10.31%
18.63% 17.37% 16.13% 14.92% 13.73% 12.57% 11.43% 10.31%
3 13.87% 13.16% 12.47% 11.78% 11.11% 10.46% 9.81% 9.17%
13.55% 12.83% 12.11% 11.40% 10.71% 10.03% 9.35% 8.69%
13.55% 12.83% 12.11% 11.40% 10.71% 10.03% 9.35% 8.69%
4 11.46% 11.01% 10.57% 10.13% 9.70% 9.28% 8.87% 8.46%
11.05% 10.56% 10.09% 9.62% 9.16% 8.71% 8.26% 7.82%
11.05% 10.56% 10.09% 9.62% 9.16% 8.71% 8.26% 7.82%
5 10.05% 9.74% 9.44% 9.15% 8.86% 8.58% 8.31% 8.03%
9.53% 9.19% 8.85% 8.52% 8.19% 7.87% 7.55% 7.24%
9.53% 9.19% 8.85% 8.52% 8.19% 7.87% 7.55% 7.24%
6 9.11% 8.90% 8.70% 8.50% 8.31% 8.12% 7.93% 7.75%
8.50% 8.25% 8.00% 7.76% 7.52% 7.28% 7.04% 6.81%
8.50% 8.25% 8.00% 7.76% 7.52% 7.28% 7.04% 6.81%
7 8.45% 8.31% 8.17% 8.04% 7.91% 7.79% 7.67% 7.55%
7.74% 7.56% 7.37% 7.19% 7.01% 6.83% 6.65% 6.47%
7.74% 7.56% 7.37% 7.19% 7.01% 6.83% 6.65% 6.47%
8 7.95% 7.86% 7.78% 7.70% 7.62% 7.54% 7.47% 7.40%
7.16% 7.02% 6.88% 6.74% 6.60% 6.47% 6.33% 6.20%
7.16% 7.02% 6.88% 6.74% 6.60% 6.47% 6.33% 6.20%
9 7.57% 7.52% 7.47% 7.43% 7.39% 7.35% 7.32% 7.28%
6.70% 6.59% 6.48% 6.38% 6.27% 6.17% 6.06% 5.96%
6.70% 6.59% 6.48% 6.38% 6.27% 6.17% 6.06% 5.96%
10 7.26% 7.25% 7.23% 7.22% 7.21% 7.20% 7.19% 7.19%
6.31% 6.23% 6.15% 6.07% 5.99% 5.91% 5.83% 5.75%
6.31% 6.23% 6.15% 6.07% 5.99% 5.91% 5.83% 5.75%
11 7.01% 7.02% 7.03% 7.04% 7.06% 7.07% 7.09% 7.11%
5.99% 5.93% 5.87% 5.81% 5.75% 5.69% 5.63% 5.57%
5.99% 5.93% 5.87% 5.81% 5.75% 5.69% 5.63% 5.57%
12 6.81% 6.84% 6.87% 6.90% 6.93% 6.97% 7.01% 7.05%
5.71% 5.66% 5.62% 5.57% 5.53% 5.49% 5.45% 5.40%
5.71% 5.66% 5.62% 5.57% 5.53% 5.49% 5.45% 5.40%
13 6.63% 6.68% 6.73% 6.78% 6.83% 6.88% 6.94% 6.99%
5.46% 5.43% 5.40% 5.37% 5.34% 5.31% 5.28% 5.25%
5.46% 5.43% 5.40% 5.37% 5.34% 5.31% 5.28% 5.25%
14 6.48% 6.54% 6.61% 6.67% 6.74% 6.81% 6.88% 6.95%
5.24% 5.22% 5.20% 5.19% 5.17% 5.15% 5.13% 5.11%
5.24% 5.22% 5.20% 5.19% 5.17% 5.15% 5.13% 5.11%
15 6.35% 6.43% 6.50% 6.58% 6.66% 6.74% 6.82% 6.91%
5.04% 5.04% 5.03% 5.02% 5.01% 5.00% 4.99% 4.99%
5.04% 5.04% 5.03% 5.02% 5.01% 5.00% 4.99% 4.99%

Sheet 6: ScenarioAnalysis_MT

Parameters
















Name MT
Start Yield 4.50%
10Y High 5.00% Spread 1.50%
















Price $988.50
Increment 0.25%
10Y Low 1.00% Spread 2.00%
















Coupon 6.35%
Purchased Year 2024
Suggested High
6.50%
















Maturity 30
Maturity Year 2054
Suggested Low
3.00%
















YTM 6.437% YTM (no) 3.63% Current Yield 6.424%




















Investment Horizon 15
























~MacDuration 14 y- $1,134.33 y+ $870.19




















Reinvestment Rate 0.00%




















































a) Return Based on YTM (and therefore all coupon payments are reinvested)
b) Return Based on YTM and No Coupon Payment Reinvestment
c) Return Based on YTM(no) and No Coupon Payment Reinvestment

Yield at the End of Investment Horizon
Yield at the End of Investment Horizon
Yield at the End of Investment Horizon

4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25%
4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25%
4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25%



























Investment Horizon Investment Horizon Price
Investment Horizon Price
Investment Horizon Price
1 $1,298.00 $1,250.51 $1,205.53 $1,162.91 $1,122.50 $1,084.19 $1,047.83 $1,013.31
$1,298.00 $1,250.51 $1,205.53 $1,162.91 $1,122.50 $1,084.19 $1,047.83 $1,013.31
$1,298.00 $1,250.51 $1,205.53 $1,162.91 $1,122.50 $1,084.19 $1,047.83 $1,013.31
2 $1,292.86 $1,246.36 $1,202.26 $1,160.43 $1,120.72 $1,083.01 $1,047.19 $1,013.14
$1,292.86 $1,246.36 $1,202.26 $1,160.43 $1,120.72 $1,083.01 $1,047.19 $1,013.14
$1,292.86 $1,246.36 $1,202.26 $1,160.43 $1,120.72 $1,083.01 $1,047.19 $1,013.14
3 $1,287.48 $1,242.01 $1,198.83 $1,157.82 $1,118.83 $1,081.77 $1,046.51 $1,012.96
$1,287.48 $1,242.01 $1,198.83 $1,157.82 $1,118.83 $1,081.77 $1,046.51 $1,012.96
$1,287.48 $1,242.01 $1,198.83 $1,157.82 $1,118.83 $1,081.77 $1,046.51 $1,012.96
4 $1,281.85 $1,237.45 $1,195.23 $1,155.06 $1,116.84 $1,080.45 $1,045.79 $1,012.77
$1,281.85 $1,237.45 $1,195.23 $1,155.06 $1,116.84 $1,080.45 $1,045.79 $1,012.77
$1,281.85 $1,237.45 $1,195.23 $1,155.06 $1,116.84 $1,080.45 $1,045.79 $1,012.77
5 $1,275.97 $1,232.67 $1,191.45 $1,152.17 $1,114.74 $1,079.06 $1,045.03 $1,012.57
$1,275.97 $1,232.67 $1,191.45 $1,152.17 $1,114.74 $1,079.06 $1,045.03 $1,012.57
$1,275.97 $1,232.67 $1,191.45 $1,152.17 $1,114.74 $1,079.06 $1,045.03 $1,012.57
6 $1,269.82 $1,227.67 $1,187.47 $1,149.12 $1,112.52 $1,077.58 $1,044.22 $1,012.35
$1,269.82 $1,227.67 $1,187.47 $1,149.12 $1,112.52 $1,077.58 $1,044.22 $1,012.35
$1,269.82 $1,227.67 $1,187.47 $1,149.12 $1,112.52 $1,077.58 $1,044.22 $1,012.35
7 $1,263.39 $1,222.42 $1,183.29 $1,145.90 $1,110.18 $1,076.02 $1,043.36 $1,012.12
$1,263.39 $1,222.42 $1,183.29 $1,145.90 $1,110.18 $1,076.02 $1,043.36 $1,012.12
$1,263.39 $1,222.42 $1,183.29 $1,145.90 $1,110.18 $1,076.02 $1,043.36 $1,012.12
8 $1,256.67 $1,216.92 $1,178.90 $1,142.52 $1,107.70 $1,074.37 $1,042.44 $1,011.87
$1,256.67 $1,216.92 $1,178.90 $1,142.52 $1,107.70 $1,074.37 $1,042.44 $1,011.87
$1,256.67 $1,216.92 $1,178.90 $1,142.52 $1,107.70 $1,074.37 $1,042.44 $1,011.87
9 $1,249.64 $1,211.16 $1,174.29 $1,138.96 $1,105.09 $1,072.62 $1,041.48 $1,011.61
$1,249.64 $1,211.16 $1,174.29 $1,138.96 $1,105.09 $1,072.62 $1,041.48 $1,011.61
$1,249.64 $1,211.16 $1,174.29 $1,138.96 $1,105.09 $1,072.62 $1,041.48 $1,011.61
10 $1,242.29 $1,205.12 $1,169.44 $1,135.20 $1,102.33 $1,070.77 $1,040.45 $1,011.33
$1,242.29 $1,205.12 $1,169.44 $1,135.20 $1,102.33 $1,070.77 $1,040.45 $1,011.33
$1,242.29 $1,205.12 $1,169.44 $1,135.20 $1,102.33 $1,070.77 $1,040.45 $1,011.33
11 $1,234.61 $1,198.79 $1,164.35 $1,131.25 $1,099.42 $1,068.81 $1,039.36 $1,011.03
$1,234.61 $1,198.79 $1,164.35 $1,131.25 $1,099.42 $1,068.81 $1,039.36 $1,011.03
$1,234.61 $1,198.79 $1,164.35 $1,131.25 $1,099.42 $1,068.81 $1,039.36 $1,011.03
12 $1,226.58 $1,192.15 $1,159.00 $1,127.09 $1,096.35 $1,066.74 $1,038.21 $1,010.72
$1,226.58 $1,192.15 $1,159.00 $1,127.09 $1,096.35 $1,066.74 $1,038.21 $1,010.72
$1,226.58 $1,192.15 $1,159.00 $1,127.09 $1,096.35 $1,066.74 $1,038.21 $1,010.72
13 $1,218.18 $1,185.20 $1,153.39 $1,122.70 $1,093.10 $1,064.54 $1,036.98 $1,010.38
$1,218.18 $1,185.20 $1,153.39 $1,122.70 $1,093.10 $1,064.54 $1,036.98 $1,010.38
$1,218.18 $1,185.20 $1,153.39 $1,122.70 $1,093.10 $1,064.54 $1,036.98 $1,010.38
14 $1,209.40 $1,177.91 $1,147.48 $1,118.08 $1,089.68 $1,062.22 $1,035.68 $1,010.02
$1,209.40 $1,177.91 $1,147.48 $1,118.08 $1,089.68 $1,062.22 $1,035.68 $1,010.02
$1,209.40 $1,177.91 $1,147.48 $1,118.08 $1,089.68 $1,062.22 $1,035.68 $1,010.02
15 $1,200.22 $1,170.27 $1,141.28 $1,113.22 $1,086.06 $1,059.76 $1,034.30 $1,009.64
$1,200.22 $1,170.27 $1,141.28 $1,113.22 $1,086.06 $1,059.76 $1,034.30 $1,009.64
$1,200.22 $1,170.27 $1,141.28 $1,113.22 $1,086.06 $1,059.76 $1,034.30 $1,009.64
16 $1,190.62 $1,162.26 $1,134.76 $1,108.10 $1,082.24 $1,057.16 $1,032.84 $1,009.24
$1,190.62 $1,162.26 $1,134.76 $1,108.10 $1,082.24 $1,057.16 $1,032.84 $1,009.24
$1,190.62 $1,162.26 $1,134.76 $1,108.10 $1,082.24 $1,057.16 $1,032.84 $1,009.24
17 $1,180.59 $1,153.87 $1,127.92 $1,102.70 $1,078.21 $1,054.41 $1,031.28 $1,008.81
$1,180.59 $1,153.87 $1,127.92 $1,102.70 $1,078.21 $1,054.41 $1,031.28 $1,008.81
$1,180.59 $1,153.87 $1,127.92 $1,102.70 $1,078.21 $1,054.41 $1,031.28 $1,008.81
18 $1,170.10 $1,145.08 $1,120.72 $1,097.02 $1,073.95 $1,051.50 $1,029.64 $1,008.35
$1,170.10 $1,145.08 $1,120.72 $1,097.02 $1,073.95 $1,051.50 $1,029.64 $1,008.35
$1,170.10 $1,145.08 $1,120.72 $1,097.02 $1,073.95 $1,051.50 $1,029.64 $1,008.35
19 $1,159.13 $1,135.86 $1,113.17 $1,091.04 $1,069.46 $1,048.42 $1,027.89 $1,007.87
$1,159.13 $1,135.86 $1,113.17 $1,091.04 $1,069.46 $1,048.42 $1,027.89 $1,007.87
$1,159.13 $1,135.86 $1,113.17 $1,091.04 $1,069.46 $1,048.42 $1,027.89 $1,007.87
20 $1,147.66 $1,126.20 $1,105.23 $1,084.74 $1,064.72 $1,045.15 $1,026.04 $1,007.35
$1,147.66 $1,126.20 $1,105.23 $1,084.74 $1,064.72 $1,045.15 $1,026.04 $1,007.35
$1,147.66 $1,126.20 $1,105.23 $1,084.74 $1,064.72 $1,045.15 $1,026.04 $1,007.35
21 $1,135.68 $1,116.07 $1,096.89 $1,078.10 $1,059.71 $1,041.70 $1,024.07 $1,006.80
$1,135.68 $1,116.07 $1,096.89 $1,078.10 $1,059.71 $1,041.70 $1,024.07 $1,006.80
$1,135.68 $1,116.07 $1,096.89 $1,078.10 $1,059.71 $1,041.70 $1,024.07 $1,006.80
22 $1,123.14 $1,105.46 $1,088.12 $1,071.11 $1,054.42 $1,038.05 $1,021.98 $1,006.22
$1,123.14 $1,105.46 $1,088.12 $1,071.11 $1,054.42 $1,038.05 $1,021.98 $1,006.22
$1,123.14 $1,105.46 $1,088.12 $1,071.11 $1,054.42 $1,038.05 $1,021.98 $1,006.22
23 $1,110.04 $1,094.34 $1,078.91 $1,063.75 $1,048.84 $1,034.18 $1,019.77 $1,005.60
$1,110.04 $1,094.34 $1,078.91 $1,063.75 $1,048.84 $1,034.18 $1,019.77 $1,005.60
$1,110.04 $1,094.34 $1,078.91 $1,063.75 $1,048.84 $1,034.18 $1,019.77 $1,005.60
24 $1,096.34 $1,082.69 $1,069.24 $1,055.99 $1,042.94 $1,030.09 $1,017.42 $1,004.94
$1,096.34 $1,082.69 $1,069.24 $1,055.99 $1,042.94 $1,030.09 $1,017.42 $1,004.94
$1,096.34 $1,082.69 $1,069.24 $1,055.99 $1,042.94 $1,030.09 $1,017.42 $1,004.94
25 $1,082.01 $1,070.47 $1,059.08 $1,047.83 $1,036.72 $1,025.75 $1,014.93 $1,004.24
$1,082.01 $1,070.47 $1,059.08 $1,047.83 $1,036.72 $1,025.75 $1,014.93 $1,004.24
$1,082.01 $1,070.47 $1,059.08 $1,047.83 $1,036.72 $1,025.75 $1,014.93 $1,004.24
26 $1,067.04 $1,057.67 $1,048.40 $1,039.23 $1,030.15 $1,021.17 $1,012.28 $1,003.49
$1,067.04 $1,057.67 $1,048.40 $1,039.23 $1,030.15 $1,021.17 $1,012.28 $1,003.49
$1,067.04 $1,057.67 $1,048.40 $1,039.23 $1,030.15 $1,021.17 $1,012.28 $1,003.49
27 $1,051.38 $1,044.25 $1,037.18 $1,030.17 $1,023.22 $1,016.32 $1,009.48 $1,002.70
$1,051.38 $1,044.25 $1,037.18 $1,030.17 $1,023.22 $1,016.32 $1,009.48 $1,002.70
$1,051.38 $1,044.25 $1,037.18 $1,030.17 $1,023.22 $1,016.32 $1,009.48 $1,002.70
28 $1,035.01 $1,030.19 $1,025.39 $1,020.63 $1,015.89 $1,011.18 $1,006.50 $1,001.85
$1,035.01 $1,030.19 $1,025.39 $1,020.63 $1,015.89 $1,011.18 $1,006.50 $1,001.85
$1,035.01 $1,030.19 $1,025.39 $1,020.63 $1,015.89 $1,011.18 $1,006.50 $1,001.85
29 $1,017.89 $1,015.45 $1,013.01 $1,010.58 $1,008.16 $1,005.75 $1,003.35 $1,000.96
$1,017.89 $1,015.45 $1,013.01 $1,010.58 $1,008.16 $1,005.75 $1,003.35 $1,000.96
$1,017.89 $1,015.45 $1,013.01 $1,010.58 $1,008.16 $1,005.75 $1,003.35 $1,000.96
30 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00
$1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00
$1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00



























Investment Horizon Total Future Dollars
Total Future Dollars
Total Future Dollars
1 $1,362.22 $1,314.76 $1,269.82 $1,227.24 $1,186.88 $1,148.60 $1,112.28 $1,077.81
$1,361.50 $1,314.01 $1,269.03 $1,226.41 $1,186.00 $1,147.69 $1,111.33 $1,076.81
$1,361.50 $1,314.01 $1,269.03 $1,226.41 $1,186.00 $1,147.69 $1,111.33 $1,076.81
2 $1,424.21 $1,377.96 $1,334.11 $1,292.52 $1,253.05 $1,215.59 $1,180.02 $1,146.22
$1,419.86 $1,373.36 $1,329.26 $1,287.43 $1,247.72 $1,210.01 $1,174.19 $1,140.14
$1,419.86 $1,373.36 $1,329.26 $1,287.43 $1,247.72 $1,210.01 $1,174.19 $1,140.14
3 $1,489.02 $1,444.19 $1,401.64 $1,361.26 $1,322.92 $1,286.49 $1,251.88 $1,218.98
$1,477.98 $1,432.51 $1,389.33 $1,348.32 $1,309.33 $1,272.27 $1,237.01 $1,203.46
$1,477.98 $1,432.51 $1,389.33 $1,348.32 $1,309.33 $1,272.27 $1,237.01 $1,203.46
4 $1,556.78 $1,513.60 $1,472.60 $1,433.67 $1,396.68 $1,361.53 $1,328.12 $1,296.36
$1,535.85 $1,491.45 $1,449.23 $1,409.06 $1,370.84 $1,334.45 $1,299.79 $1,266.77
$1,535.85 $1,491.45 $1,449.23 $1,409.06 $1,370.84 $1,334.45 $1,299.79 $1,266.77
5 $1,627.62 $1,586.35 $1,547.15 $1,509.92 $1,474.55 $1,440.95 $1,409.01 $1,378.65
$1,593.47 $1,550.17 $1,508.95 $1,469.67 $1,432.24 $1,396.56 $1,362.53 $1,330.07
$1,593.47 $1,550.17 $1,508.95 $1,469.67 $1,432.24 $1,396.56 $1,362.53 $1,330.07
6 $1,701.69 $1,662.60 $1,625.48 $1,590.23 $1,556.77 $1,524.99 $1,494.81 $1,466.16
$1,650.82 $1,608.67 $1,568.47 $1,530.12 $1,493.52 $1,458.58 $1,425.22 $1,393.35
$1,650.82 $1,608.67 $1,568.47 $1,530.12 $1,493.52 $1,458.58 $1,425.22 $1,393.35
7 $1,779.13 $1,742.51 $1,707.77 $1,674.82 $1,643.57 $1,613.94 $1,585.85 $1,559.22
$1,707.89 $1,666.92 $1,627.79 $1,590.40 $1,554.68 $1,520.52 $1,487.86 $1,456.62
$1,707.89 $1,666.92 $1,627.79 $1,590.40 $1,554.68 $1,520.52 $1,487.86 $1,456.62
8 $1,860.09 $1,826.26 $1,794.22 $1,763.90 $1,735.21 $1,708.07 $1,682.43 $1,658.20
$1,764.67 $1,724.92 $1,686.90 $1,650.52 $1,615.70 $1,582.37 $1,550.44 $1,519.87
$1,764.67 $1,724.92 $1,686.90 $1,650.52 $1,615.70 $1,582.37 $1,550.44 $1,519.87
9 $1,944.73 $1,914.04 $1,885.06 $1,857.72 $1,831.96 $1,807.70 $1,784.89 $1,763.45
$1,821.14 $1,782.66 $1,745.79 $1,710.46 $1,676.59 $1,644.12 $1,612.98 $1,583.11
$1,821.14 $1,782.66 $1,745.79 $1,710.46 $1,676.59 $1,644.12 $1,612.98 $1,583.11
10 $2,033.23 $2,006.03 $1,980.49 $1,956.53 $1,934.10 $1,913.14 $1,893.59 $1,875.39
$1,877.29 $1,840.12 $1,804.44 $1,770.20 $1,737.33 $1,705.77 $1,675.45 $1,646.33
$1,877.29 $1,840.12 $1,804.44 $1,770.20 $1,737.33 $1,705.77 $1,675.45 $1,646.33
11 $2,125.76 $2,102.45 $2,080.75 $2,060.60 $2,041.94 $2,024.72 $2,008.90 $1,994.44
$1,933.11 $1,897.29 $1,862.85 $1,829.75 $1,797.92 $1,767.31 $1,737.86 $1,709.53
$1,933.11 $1,897.29 $1,862.85 $1,829.75 $1,797.92 $1,767.31 $1,737.86 $1,709.53
12 $2,222.49 $2,203.50 $2,186.09 $2,170.20 $2,155.79 $2,142.82 $2,131.25 $2,121.04
$1,988.58 $1,954.15 $1,921.00 $1,889.09 $1,858.35 $1,828.74 $1,800.21 $1,772.72
$1,988.58 $1,954.15 $1,921.00 $1,889.09 $1,858.35 $1,828.74 $1,800.21 $1,772.72
13 $2,323.63 $2,309.41 $2,296.76 $2,285.63 $2,275.99 $2,267.80 $2,261.04 $2,255.67
$2,043.68 $2,010.70 $1,978.89 $1,948.20 $1,918.60 $1,890.04 $1,862.48 $1,835.88
$2,043.68 $2,010.70 $1,978.89 $1,948.20 $1,918.60 $1,890.04 $1,862.48 $1,835.88
14 $2,429.37 $2,420.41 $2,413.03 $2,407.20 $2,402.89 $2,400.07 $2,398.74 $2,398.85
$2,098.40 $2,066.91 $2,036.48 $2,007.08 $1,978.68 $1,951.22 $1,924.68 $1,899.02
$2,098.40 $2,066.91 $2,036.48 $2,007.08 $1,978.68 $1,951.22 $1,924.68 $1,899.02
15 $2,539.92 $2,536.75 $2,535.19 $2,535.23 $2,536.86 $2,540.06 $2,544.82 $2,551.13
$2,152.72 $2,122.77 $2,093.78 $2,065.72 $2,038.56 $2,012.26 $1,986.80 $1,962.14
$2,152.72 $2,122.77 $2,093.78 $2,065.72 $2,038.56 $2,012.26 $1,986.80 $1,962.14
16 $2,655.50 $2,658.67 $2,663.53 $2,670.08 $2,678.31 $2,688.22 $2,699.80 $2,713.06
$2,206.62 $2,178.26 $2,150.76 $2,124.10 $2,098.24 $2,073.16 $2,048.84 $2,025.24
$2,206.62 $2,178.26 $2,150.76 $2,124.10 $2,098.24 $2,073.16 $2,048.84 $2,025.24
17 $2,776.34 $2,786.46 $2,798.38 $2,812.10 $2,827.64 $2,845.01 $2,864.22 $2,885.28
$2,260.09 $2,233.37 $2,207.42 $2,182.20 $2,157.71 $2,133.91 $2,110.78 $2,088.31
$2,260.09 $2,233.37 $2,207.42 $2,182.20 $2,157.71 $2,133.91 $2,110.78 $2,088.31
18 $2,902.68 $2,920.39 $2,940.04 $2,961.67 $2,985.30 $3,010.95 $3,038.65 $3,068.43
$2,313.10 $2,288.08 $2,263.72 $2,240.02 $2,216.95 $2,194.50 $2,172.64 $2,151.35
$2,313.10 $2,288.08 $2,263.72 $2,240.02 $2,216.95 $2,194.50 $2,172.64 $2,151.35
19 $3,034.77 $3,060.75 $3,088.88 $3,119.20 $3,151.75 $3,186.57 $3,223.70 $3,263.20
$2,365.63 $2,342.36 $2,319.67 $2,297.54 $2,275.96 $2,254.92 $2,234.39 $2,214.37
$2,365.63 $2,342.36 $2,319.67 $2,297.54 $2,275.96 $2,254.92 $2,234.39 $2,214.37
20 $3,172.88 $3,207.87 $3,245.26 $3,285.11 $3,327.48 $3,372.43 $3,420.03 $3,470.34
$2,417.66 $2,396.20 $2,375.23 $2,354.74 $2,334.72 $2,315.15 $2,296.04 $2,277.35
$2,417.66 $2,396.20 $2,375.23 $2,354.74 $2,334.72 $2,315.15 $2,296.04 $2,277.35
21 $3,317.26 $3,362.05 $3,409.55 $3,459.84 $3,513.01 $3,569.13 $3,628.31 $3,690.62
$2,469.18 $2,449.57 $2,430.39 $2,411.60 $2,393.21 $2,375.20 $2,357.57 $2,340.30
$2,469.18 $2,449.57 $2,430.39 $2,411.60 $2,393.21 $2,375.20 $2,357.57 $2,340.30
22 $3,468.22 $3,523.64 $3,582.16 $3,643.87 $3,708.88 $3,777.31 $3,849.27 $3,924.89
$2,520.14 $2,502.46 $2,485.12 $2,468.11 $2,451.42 $2,435.05 $2,418.98 $2,403.22
$2,520.14 $2,502.46 $2,485.12 $2,468.11 $2,451.42 $2,435.05 $2,418.98 $2,403.22
23 $3,626.04 $3,693.00 $3,763.50 $3,837.68 $3,915.67 $3,997.62 $4,083.69 $4,174.03
$2,570.54 $2,554.84 $2,539.41 $2,524.25 $2,509.34 $2,494.68 $2,480.27 $2,466.10
$2,570.54 $2,554.84 $2,539.41 $2,524.25 $2,509.34 $2,494.68 $2,480.27 $2,466.10
24 $3,791.05 $3,870.50 $3,954.03 $4,041.80 $4,134.00 $4,230.79 $4,332.39 $4,438.98
$2,620.34 $2,606.69 $2,593.24 $2,579.99 $2,566.94 $2,554.09 $2,541.42 $2,528.94
$2,620.34 $2,606.69 $2,593.24 $2,579.99 $2,566.94 $2,554.09 $2,541.42 $2,528.94
25 $3,963.57 $4,056.54 $4,154.20 $4,256.78 $4,364.49 $4,477.56 $4,596.23 $4,720.75
$2,669.51 $2,657.97 $2,646.58 $2,635.33 $2,624.22 $2,613.25 $2,602.43 $2,591.74
$2,669.51 $2,657.97 $2,646.58 $2,635.33 $2,624.22 $2,613.25 $2,602.43 $2,591.74
26 $4,143.93 $4,251.51 $4,364.51 $4,483.20 $4,607.84 $4,738.72 $4,876.14 $5,020.41
$2,718.04 $2,708.67 $2,699.40 $2,690.23 $2,681.15 $2,672.17 $2,663.28 $2,654.49
$2,718.04 $2,708.67 $2,699.40 $2,690.23 $2,681.15 $2,672.17 $2,663.28 $2,654.49
27 $4,332.51 $4,455.85 $4,585.46 $4,721.65 $4,864.76 $5,015.11 $5,173.10 $5,339.09
$2,765.88 $2,758.75 $2,751.68 $2,744.67 $2,737.72 $2,730.82 $2,723.98 $2,717.20
$2,765.88 $2,758.75 $2,751.68 $2,744.67 $2,737.72 $2,730.82 $2,723.98 $2,717.20
28 $4,529.67 $4,670.02 $4,817.60 $4,972.80 $5,136.00 $5,307.63 $5,488.14 $5,677.99
$2,813.01 $2,808.19 $2,803.39 $2,798.63 $2,793.89 $2,789.18 $2,784.50 $2,779.85
$2,813.01 $2,808.19 $2,803.39 $2,798.63 $2,793.89 $2,789.18 $2,784.50 $2,779.85
29 $4,735.79 $4,894.48 $5,061.49 $5,237.29 $5,422.36 $5,617.20 $5,822.36 $6,038.41
$2,859.39 $2,856.95 $2,854.51 $2,852.08 $2,849.66 $2,847.25 $2,844.85 $2,842.46
$2,859.39 $2,856.95 $2,854.51 $2,852.08 $2,849.66 $2,847.25 $2,844.85 $2,842.46
30 $4,951.30 $5,129.73 $5,317.73 $5,515.86 $5,724.69 $5,944.84 $6,176.95 $6,421.71
$2,905.00 $2,905.00 $2,905.00 $2,905.00 $2,905.00 $2,905.00 $2,905.00 $2,905.00
$2,905.00 $2,905.00 $2,905.00 $2,905.00 $2,905.00 $2,905.00 $2,905.00 $2,905.00



























Investment Horizon Total Return
Total Return
Total Return
1 37.81% 33.01% 28.46% 24.15% 20.07% 16.20% 12.52% 9.03%
37.73% 32.93% 28.38% 24.07% 19.98% 16.10% 12.43% 8.93%
37.73% 32.93% 28.38% 24.07% 19.98% 16.10% 12.43% 8.93%
2 20.03% 18.07% 16.17% 14.35% 12.59% 10.89% 9.26% 7.68%
19.85% 17.87% 15.96% 14.12% 12.35% 10.64% 8.99% 7.40%
19.85% 17.87% 15.96% 14.12% 12.35% 10.64% 8.99% 7.40%
3 14.63% 13.47% 12.34% 11.26% 10.20% 9.18% 8.19% 7.24%
14.35% 13.16% 12.01% 10.90% 9.82% 8.78% 7.76% 6.78%
14.35% 13.16% 12.01% 10.90% 9.82% 8.78% 7.76% 6.78%
4 12.02% 11.24% 10.48% 9.74% 9.03% 8.33% 7.66% 7.01%
11.65% 10.83% 10.04% 9.27% 8.52% 7.79% 7.08% 6.40%
11.65% 10.83% 10.04% 9.27% 8.52% 7.79% 7.08% 6.40%
5 10.49% 9.92% 9.37% 8.84% 8.33% 7.83% 7.35% 6.88%
10.02% 9.42% 8.83% 8.26% 7.70% 7.16% 6.63% 6.12%
10.02% 9.42% 8.83% 8.26% 7.70% 7.16% 6.63% 6.12%
6 9.48% 9.05% 8.64% 8.25% 7.86% 7.49% 7.14% 6.79%
8.92% 8.45% 8.00% 7.55% 7.12% 6.70% 6.29% 5.89%
8.92% 8.45% 8.00% 7.55% 7.12% 6.70% 6.29% 5.89%
7 8.76% 8.44% 8.12% 7.82% 7.53% 7.25% 6.99% 6.73%
8.12% 7.75% 7.39% 7.03% 6.68% 6.34% 6.02% 5.69%
8.12% 7.75% 7.39% 7.03% 6.68% 6.34% 6.02% 5.69%
8 8.22% 7.97% 7.74% 7.51% 7.29% 7.08% 6.87% 6.68%
7.51% 7.21% 6.91% 6.62% 6.33% 6.06% 5.79% 5.52%
7.51% 7.21% 6.91% 6.62% 6.33% 6.06% 5.79% 5.52%
9 7.81% 7.62% 7.44% 7.26% 7.10% 6.94% 6.79% 6.64%
7.02% 6.77% 6.52% 6.28% 6.05% 5.82% 5.59% 5.37%
7.02% 6.77% 6.52% 6.28% 6.05% 5.82% 5.59% 5.37%
10 7.48% 7.33% 7.20% 7.07% 6.94% 6.83% 6.72% 6.61%
6.62% 6.41% 6.20% 6.00% 5.80% 5.61% 5.42% 5.23%
6.62% 6.41% 6.20% 6.00% 5.80% 5.61% 5.42% 5.23%
11 7.21% 7.10% 7.00% 6.91% 6.82% 6.74% 6.66% 6.59%
6.29% 6.11% 5.93% 5.76% 5.59% 5.42% 5.26% 5.11%
6.29% 6.11% 5.93% 5.76% 5.59% 5.42% 5.26% 5.11%
12 6.98% 6.91% 6.84% 6.77% 6.71% 6.66% 6.61% 6.57%
6.00% 5.84% 5.69% 5.55% 5.40% 5.26% 5.12% 4.99%
6.00% 5.84% 5.69% 5.55% 5.40% 5.26% 5.12% 4.99%
13 6.80% 6.75% 6.70% 6.66% 6.63% 6.60% 6.57% 6.55%
5.75% 5.61% 5.48% 5.36% 5.23% 5.11% 4.99% 4.88%
5.75% 5.61% 5.48% 5.36% 5.23% 5.11% 4.99% 4.88%
14 6.63% 6.61% 6.58% 6.56% 6.55% 6.54% 6.54% 6.54%
5.52% 5.41% 5.30% 5.19% 5.08% 4.98% 4.87% 4.77%
5.52% 5.41% 5.30% 5.19% 5.08% 4.98% 4.87% 4.77%
15 6.49% 6.48% 6.48% 6.48% 6.48% 6.49% 6.51% 6.52%
5.33% 5.23% 5.13% 5.04% 4.94% 4.85% 4.76% 4.68%
5.33% 5.23% 5.13% 5.04% 4.94% 4.85% 4.76% 4.68%
16 6.37% 6.38% 6.39% 6.41% 6.43% 6.45% 6.48% 6.51%
5.15% 5.06% 4.98% 4.90% 4.82% 4.74% 4.66% 4.58%
5.15% 5.06% 4.98% 4.90% 4.82% 4.74% 4.66% 4.58%
17 6.26% 6.29% 6.31% 6.34% 6.38% 6.42% 6.46% 6.50%
4.98% 4.91% 4.84% 4.77% 4.70% 4.63% 4.56% 4.50%
4.98% 4.91% 4.84% 4.77% 4.70% 4.63% 4.56% 4.50%
18 6.17% 6.20% 6.24% 6.29% 6.33% 6.38% 6.44% 6.50%
4.84% 4.77% 4.71% 4.65% 4.59% 4.53% 4.47% 4.42%
4.84% 4.77% 4.71% 4.65% 4.59% 4.53% 4.47% 4.42%
19 6.08% 6.13% 6.18% 6.23% 6.29% 6.35% 6.42% 6.49%
4.70% 4.65% 4.59% 4.54% 4.49% 4.44% 4.39% 4.34%
4.70% 4.65% 4.59% 4.54% 4.49% 4.44% 4.39% 4.34%
20 6.00% 6.06% 6.12% 6.19% 6.26% 6.33% 6.40% 6.48%
4.57% 4.53% 4.48% 4.44% 4.39% 4.35% 4.30% 4.26%
4.57% 4.53% 4.48% 4.44% 4.39% 4.35% 4.30% 4.26%
21 5.93% 6.00% 6.07% 6.15% 6.22% 6.30% 6.39% 6.47%
4.46% 4.42% 4.38% 4.34% 4.30% 4.26% 4.23% 4.19%
4.46% 4.42% 4.38% 4.34% 4.30% 4.26% 4.23% 4.19%
22 5.87% 5.95% 6.03% 6.11% 6.19% 6.28% 6.37% 6.47%
4.35% 4.31% 4.28% 4.25% 4.21% 4.18% 4.15% 4.12%
4.35% 4.31% 4.28% 4.25% 4.21% 4.18% 4.15% 4.12%
23 5.81% 5.90% 5.98% 6.07% 6.17% 6.26% 6.36% 6.46%
4.24% 4.21% 4.19% 4.16% 4.13% 4.11% 4.08% 4.05%
4.24% 4.21% 4.19% 4.16% 4.13% 4.11% 4.08% 4.05%
24 5.76% 5.85% 5.95% 6.04% 6.14% 6.25% 6.35% 6.46%
4.15% 4.12% 4.10% 4.08% 4.06% 4.03% 4.01% 3.99%
4.15% 4.12% 4.10% 4.08% 4.06% 4.03% 4.01% 3.99%
25 5.71% 5.81% 5.91% 6.01% 6.12% 6.23% 6.34% 6.45%
4.05% 4.04% 4.02% 4.00% 3.98% 3.97% 3.95% 3.93%
4.05% 4.04% 4.02% 4.00% 3.98% 3.97% 3.95% 3.93%
26 5.67% 5.77% 5.88% 5.99% 6.10% 6.21% 6.33% 6.45%
3.97% 3.95% 3.94% 3.93% 3.91% 3.90% 3.89% 3.87%
3.97% 3.95% 3.94% 3.93% 3.91% 3.90% 3.89% 3.87%
27 5.63% 5.74% 5.85% 5.96% 6.08% 6.20% 6.32% 6.45%
3.88% 3.87% 3.86% 3.85% 3.84% 3.84% 3.83% 3.82%
3.88% 3.87% 3.86% 3.85% 3.84% 3.84% 3.83% 3.82%
28 5.59% 5.70% 5.82% 5.94% 6.06% 6.19% 6.31% 6.44%
3.81% 3.80% 3.79% 3.79% 3.78% 3.77% 3.77% 3.76%
3.81% 3.80% 3.79% 3.79% 3.78% 3.77% 3.77% 3.76%
29 5.55% 5.67% 5.79% 5.92% 6.04% 6.17% 6.31% 6.44%
3.73% 3.73% 3.72% 3.72% 3.72% 3.72% 3.71% 3.71%
3.73% 3.73% 3.72% 3.72% 3.72% 3.72% 3.71% 3.71%
30 5.52% 5.64% 5.77% 5.90% 6.03% 6.16% 6.30% 6.44%
3.66% 3.66% 3.66% 3.66% 3.66% 3.66% 3.66% 3.66%
3.66% 3.66% 3.66% 3.66% 3.66% 3.66% 3.66% 3.66%

Sheet 7: ScenarioAnalysis_ALLY

Parameters
















Name ALLY
Start Yield 4.50%
10Y High 5.00% Spread 1.50%
















Price $1,022.00
Increment 0.25%
10Y Low 1.00% Spread 2.00%
















Coupon 6.70%
Purchased Year 2024
Suggested High
6.50%
















Maturity 8
Maturity Year 2032
Suggested Low
3.00%
















YTM 6.345% YTM (no) 5.16% Current Yield 6.556%




















Investment Horizon 15
























~MacDuration 7 y- $1,087.27 y+ $961.50




















Reinvestment Rate 0.00%




















































a) Return Based on YTM (and therefore all coupon payments are reinvested)
b) Return Based on YTM and No Coupon Payment Reinvestment
c) Return Based on YTM(no) and No Coupon Payment Reinvestment

Yield at the End of Investment Horizon
Yield at the End of Investment Horizon
Yield at the End of Investment Horizon

4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25%
4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25%
4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25%



























Investment Horizon Investment Horizon Price
Investment Horizon Price
Investment Horizon Price
1 $1,130.86 $1,114.98 $1,099.37 $1,084.03 $1,068.95 $1,054.12 $1,039.54 $1,025.20
$1,130.86 $1,114.98 $1,099.37 $1,084.03 $1,068.95 $1,054.12 $1,039.54 $1,025.20
$1,130.86 $1,114.98 $1,099.37 $1,084.03 $1,068.95 $1,054.12 $1,039.54 $1,025.20
2 $1,114.56 $1,100.77 $1,087.19 $1,073.81 $1,060.63 $1,047.64 $1,034.84 $1,022.23
$1,114.56 $1,100.77 $1,087.19 $1,073.81 $1,060.63 $1,047.64 $1,034.84 $1,022.23
$1,114.56 $1,100.77 $1,087.19 $1,073.81 $1,060.63 $1,047.64 $1,034.84 $1,022.23
3 $1,097.53 $1,085.89 $1,074.39 $1,063.04 $1,051.84 $1,040.78 $1,029.86 $1,019.07
$1,097.53 $1,085.89 $1,074.39 $1,063.04 $1,051.84 $1,040.78 $1,029.86 $1,019.07
$1,097.53 $1,085.89 $1,074.39 $1,063.04 $1,051.84 $1,040.78 $1,029.86 $1,019.07
4 $1,079.72 $1,070.28 $1,060.95 $1,051.71 $1,042.57 $1,033.52 $1,024.57 $1,015.71
$1,079.72 $1,070.28 $1,060.95 $1,051.71 $1,042.57 $1,033.52 $1,024.57 $1,015.71
$1,079.72 $1,070.28 $1,060.95 $1,051.71 $1,042.57 $1,033.52 $1,024.57 $1,015.71
5 $1,061.10 $1,053.93 $1,046.82 $1,039.77 $1,032.77 $1,025.84 $1,018.96 $1,012.14
$1,061.10 $1,053.93 $1,046.82 $1,039.77 $1,032.77 $1,025.84 $1,018.96 $1,012.14
$1,061.10 $1,053.93 $1,046.82 $1,039.77 $1,032.77 $1,025.84 $1,018.96 $1,012.14
6 $1,041.63 $1,036.79 $1,031.98 $1,027.19 $1,022.44 $1,017.71 $1,013.01 $1,008.34
$1,041.63 $1,036.79 $1,031.98 $1,027.19 $1,022.44 $1,017.71 $1,013.01 $1,008.34
$1,041.63 $1,036.79 $1,031.98 $1,027.19 $1,022.44 $1,017.71 $1,013.01 $1,008.34
7 $1,021.28 $1,018.83 $1,016.38 $1,013.95 $1,011.52 $1,009.11 $1,006.70 $1,004.30
$1,021.28 $1,018.83 $1,016.38 $1,013.95 $1,011.52 $1,009.11 $1,006.70 $1,004.30
$1,021.28 $1,018.83 $1,016.38 $1,013.95 $1,011.52 $1,009.11 $1,006.70 $1,004.30
8 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00
$1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00
$1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00



























Investment Horizon Total Future Dollars
Total Future Dollars
Total Future Dollars
1 $1,198.61 $1,182.78 $1,167.21 $1,151.91 $1,136.87 $1,122.08 $1,107.54 $1,093.25
$1,197.86 $1,181.98 $1,166.37 $1,151.03 $1,135.95 $1,121.12 $1,106.54 $1,092.20
$1,197.86 $1,181.98 $1,166.37 $1,151.03 $1,135.95 $1,121.12 $1,106.54 $1,092.20
2 $1,253.15 $1,239.62 $1,226.30 $1,213.18 $1,200.25 $1,187.53 $1,174.99 $1,162.64
$1,248.56 $1,234.77 $1,221.19 $1,207.81 $1,194.63 $1,181.64 $1,168.84 $1,156.23
$1,248.56 $1,234.77 $1,221.19 $1,207.81 $1,194.63 $1,181.64 $1,168.84 $1,156.23
3 $1,310.18 $1,299.21 $1,288.38 $1,277.71 $1,267.18 $1,256.79 $1,246.55 $1,236.44
$1,298.53 $1,286.89 $1,275.39 $1,264.04 $1,252.84 $1,241.78 $1,230.86 $1,220.07
$1,298.53 $1,286.89 $1,275.39 $1,264.04 $1,252.84 $1,241.78 $1,230.86 $1,220.07
4 $1,369.80 $1,361.65 $1,353.61 $1,345.67 $1,337.83 $1,330.10 $1,322.46 $1,314.93
$1,347.72 $1,338.28 $1,328.95 $1,319.71 $1,310.57 $1,301.52 $1,292.57 $1,283.71
$1,347.72 $1,338.28 $1,328.95 $1,319.71 $1,310.57 $1,301.52 $1,292.57 $1,283.71
5 $1,432.14 $1,427.10 $1,422.13 $1,417.24 $1,412.42 $1,407.68 $1,403.00 $1,398.40
$1,396.10 $1,388.93 $1,381.82 $1,374.77 $1,367.77 $1,360.84 $1,353.96 $1,347.14
$1,396.10 $1,388.93 $1,381.82 $1,374.77 $1,367.77 $1,360.84 $1,353.96 $1,347.14
6 $1,497.31 $1,495.69 $1,494.13 $1,492.62 $1,491.17 $1,489.78 $1,488.44 $1,487.16
$1,443.63 $1,438.79 $1,433.98 $1,429.19 $1,424.44 $1,419.71 $1,415.01 $1,410.34
$1,443.63 $1,438.79 $1,433.98 $1,429.19 $1,424.44 $1,419.71 $1,415.01 $1,410.34
7 $1,565.44 $1,567.58 $1,569.77 $1,572.01 $1,574.32 $1,576.67 $1,579.09 $1,581.56
$1,490.28 $1,487.83 $1,485.38 $1,482.95 $1,480.52 $1,478.11 $1,475.70 $1,473.30
$1,490.28 $1,487.83 $1,485.38 $1,482.95 $1,480.52 $1,478.11 $1,475.70 $1,473.30
8 $1,636.68 $1,642.92 $1,649.24 $1,655.63 $1,662.09 $1,668.64 $1,675.26 $1,681.95
$1,536.00 $1,536.00 $1,536.00 $1,536.00 $1,536.00 $1,536.00 $1,536.00 $1,536.00
$1,536.00 $1,536.00 $1,536.00 $1,536.00 $1,536.00 $1,536.00 $1,536.00 $1,536.00



























Investment Horizon Total Return
Total Return
Total Return
1 17.28% 15.73% 14.21% 12.71% 11.24% 9.79% 8.37% 6.97%
17.21% 15.65% 14.13% 12.62% 11.15% 9.70% 8.27% 6.87%
17.21% 15.65% 14.13% 12.62% 11.15% 9.70% 8.27% 6.87%
2 10.73% 10.13% 9.54% 8.95% 8.37% 7.79% 7.22% 6.66%
10.53% 9.92% 9.31% 8.71% 8.12% 7.53% 6.94% 6.36%
10.53% 9.92% 9.31% 8.71% 8.12% 7.53% 6.94% 6.36%
3 8.63% 8.33% 8.03% 7.73% 7.43% 7.14% 6.84% 6.56%
8.31% 7.98% 7.66% 7.34% 7.02% 6.71% 6.39% 6.08%
8.31% 7.98% 7.66% 7.34% 7.02% 6.71% 6.39% 6.08%
4 7.60% 7.44% 7.28% 7.12% 6.96% 6.81% 6.66% 6.50%
7.16% 6.97% 6.79% 6.60% 6.41% 6.23% 6.05% 5.87%
7.16% 6.97% 6.79% 6.60% 6.41% 6.23% 6.05% 5.87%
5 6.98% 6.91% 6.83% 6.76% 6.68% 6.61% 6.54% 6.47%
6.44% 6.33% 6.22% 6.11% 6.00% 5.89% 5.79% 5.68%
6.44% 6.33% 6.22% 6.11% 6.00% 5.89% 5.79% 5.68%
6 6.57% 6.55% 6.53% 6.52% 6.50% 6.48% 6.47% 6.45%
5.93% 5.87% 5.81% 5.75% 5.69% 5.63% 5.57% 5.51%
5.93% 5.87% 5.81% 5.75% 5.69% 5.63% 5.57% 5.51%
7 6.28% 6.30% 6.32% 6.34% 6.37% 6.39% 6.41% 6.44%
5.54% 5.51% 5.49% 5.46% 5.44% 5.41% 5.39% 5.36%
5.54% 5.51% 5.49% 5.46% 5.44% 5.41% 5.39% 5.36%
8 6.06% 6.11% 6.16% 6.22% 6.27% 6.32% 6.37% 6.43%
5.22% 5.22% 5.22% 5.22% 5.22% 5.22% 5.22% 5.22%
5.22% 5.22% 5.22% 5.22% 5.22% 5.22% 5.22% 5.22%

Sheet 8: ScenarioAnalysis_ET

Parameters
















Name ET
Start Yield 4.50%
10Y High 5.00% Spread 1.50%
















Price $911.53
Increment 0.25%
10Y Low 1.00% Spread 2.00%
















Coupon 5.40%
Purchased Year 2024
Suggested High
6.50%
















Maturity 23
Maturity Year 2047
Suggested Low
3.00%
















YTM 6.122% YTM (no) 3.95% Current Yield 5.924%




















Investment Horizon 15
























~MacDuration 13 y- $1,037.32 y+ $806.56




















Reinvestment Rate 0.00%




















































a) Return Based on YTM (and therefore all coupon payments are reinvested)
b) Return Based on YTM and No Coupon Payment Reinvestment
c) Return Based on YTM(no) and No Coupon Payment Reinvestment

Yield at the End of Investment Horizon
Yield at the End of Investment Horizon
Yield at the End of Investment Horizon

4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25%
4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25%
4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25%



























Investment Horizon Investment Horizon Price
Investment Horizon Price
Investment Horizon Price
1 $1,124.86 $1,088.12 $1,053.01 $1,019.43 $987.33 $956.62 $927.24 $899.12
$1,124.86 $1,088.12 $1,053.01 $1,019.43 $987.33 $956.62 $927.24 $899.12
$1,124.86 $1,088.12 $1,053.01 $1,019.43 $987.33 $956.62 $927.24 $899.12
2 $1,121.45 $1,085.78 $1,051.64 $1,018.95 $987.64 $957.64 $928.90 $901.35
$1,121.45 $1,085.78 $1,051.64 $1,018.95 $987.64 $957.64 $928.90 $901.35
$1,121.45 $1,085.78 $1,051.64 $1,018.95 $987.64 $957.64 $928.90 $901.35
3 $1,117.87 $1,083.33 $1,050.21 $1,018.44 $987.96 $958.72 $930.66 $903.72
$1,117.87 $1,083.33 $1,050.21 $1,018.44 $987.96 $958.72 $930.66 $903.72
$1,117.87 $1,083.33 $1,050.21 $1,018.44 $987.96 $958.72 $930.66 $903.72
4 $1,114.13 $1,080.76 $1,048.70 $1,017.90 $988.30 $959.86 $932.52 $906.24
$1,114.13 $1,080.76 $1,048.70 $1,017.90 $988.30 $959.86 $932.52 $906.24
$1,114.13 $1,080.76 $1,048.70 $1,017.90 $988.30 $959.86 $932.52 $906.24
5 $1,110.23 $1,078.06 $1,047.11 $1,017.33 $988.67 $961.07 $934.50 $908.92
$1,110.23 $1,078.06 $1,047.11 $1,017.33 $988.67 $961.07 $934.50 $908.92
$1,110.23 $1,078.06 $1,047.11 $1,017.33 $988.67 $961.07 $934.50 $908.92
6 $1,106.14 $1,075.24 $1,045.45 $1,016.73 $989.05 $962.35 $936.60 $911.77
$1,106.14 $1,075.24 $1,045.45 $1,016.73 $989.05 $962.35 $936.60 $911.77
$1,106.14 $1,075.24 $1,045.45 $1,016.73 $989.05 $962.35 $936.60 $911.77
7 $1,101.87 $1,072.27 $1,043.70 $1,016.10 $989.45 $963.70 $938.83 $914.80
$1,101.87 $1,072.27 $1,043.70 $1,016.10 $989.45 $963.70 $938.83 $914.80
$1,101.87 $1,072.27 $1,043.70 $1,016.10 $989.45 $963.70 $938.83 $914.80
8 $1,097.40 $1,069.17 $1,041.86 $1,015.44 $989.88 $965.14 $941.20 $918.03
$1,097.40 $1,069.17 $1,041.86 $1,015.44 $989.88 $965.14 $941.20 $918.03
$1,097.40 $1,069.17 $1,041.86 $1,015.44 $989.88 $965.14 $941.20 $918.03
9 $1,092.74 $1,065.92 $1,039.93 $1,014.74 $990.32 $966.66 $943.71 $921.46
$1,092.74 $1,065.92 $1,039.93 $1,014.74 $990.32 $966.66 $943.71 $921.46
$1,092.74 $1,065.92 $1,039.93 $1,014.74 $990.32 $966.66 $943.71 $921.46
10 $1,087.85 $1,062.51 $1,037.90 $1,014.01 $990.80 $968.26 $946.37 $925.10
$1,087.85 $1,062.51 $1,037.90 $1,014.01 $990.80 $968.26 $946.37 $925.10
$1,087.85 $1,062.51 $1,037.90 $1,014.01 $990.80 $968.26 $946.37 $925.10
11 $1,082.75 $1,058.94 $1,035.77 $1,013.23 $991.30 $969.96 $949.19 $928.98
$1,082.75 $1,058.94 $1,035.77 $1,013.23 $991.30 $969.96 $949.19 $928.98
$1,082.75 $1,058.94 $1,035.77 $1,013.23 $991.30 $969.96 $949.19 $928.98
12 $1,077.42 $1,055.19 $1,033.53 $1,012.41 $991.83 $971.76 $952.19 $933.11
$1,077.42 $1,055.19 $1,033.53 $1,012.41 $991.83 $971.76 $952.19 $933.11
$1,077.42 $1,055.19 $1,033.53 $1,012.41 $991.83 $971.76 $952.19 $933.11
13 $1,071.84 $1,051.27 $1,031.18 $1,011.55 $992.39 $973.66 $955.37 $937.50
$1,071.84 $1,051.27 $1,031.18 $1,011.55 $992.39 $973.66 $955.37 $937.50
$1,071.84 $1,051.27 $1,031.18 $1,011.55 $992.39 $973.66 $955.37 $937.50
14 $1,066.00 $1,047.16 $1,028.71 $1,010.65 $992.98 $975.68 $958.74 $942.16
$1,066.00 $1,047.16 $1,028.71 $1,010.65 $992.98 $975.68 $958.74 $942.16
$1,066.00 $1,047.16 $1,028.71 $1,010.65 $992.98 $975.68 $958.74 $942.16
15 $1,059.91 $1,042.84 $1,026.11 $1,009.70 $993.60 $977.81 $962.32 $947.12
$1,059.91 $1,042.84 $1,026.11 $1,009.70 $993.60 $977.81 $962.32 $947.12
$1,059.91 $1,042.84 $1,026.11 $1,009.70 $993.60 $977.81 $962.32 $947.12
16 $1,053.53 $1,038.33 $1,023.38 $1,008.69 $994.25 $980.06 $966.11 $952.40
$1,053.53 $1,038.33 $1,023.38 $1,008.69 $994.25 $980.06 $966.11 $952.40
$1,053.53 $1,038.33 $1,023.38 $1,008.69 $994.25 $980.06 $966.11 $952.40
17 $1,046.87 $1,033.59 $1,020.52 $1,007.64 $994.95 $982.45 $970.14 $958.01
$1,046.87 $1,033.59 $1,020.52 $1,007.64 $994.95 $982.45 $970.14 $958.01
$1,046.87 $1,033.59 $1,020.52 $1,007.64 $994.95 $982.45 $970.14 $958.01
18 $1,039.90 $1,028.63 $1,017.50 $1,006.52 $995.68 $984.98 $974.41 $963.98
$1,039.90 $1,028.63 $1,017.50 $1,006.52 $995.68 $984.98 $974.41 $963.98
$1,039.90 $1,028.63 $1,017.50 $1,006.52 $995.68 $984.98 $974.41 $963.98
19 $1,032.61 $1,023.43 $1,014.34 $1,005.35 $996.45 $987.65 $978.94 $970.32
$1,032.61 $1,023.43 $1,014.34 $1,005.35 $996.45 $987.65 $978.94 $970.32
$1,032.61 $1,023.43 $1,014.34 $1,005.35 $996.45 $987.65 $978.94 $970.32
20 $1,025.00 $1,017.98 $1,011.02 $1,004.11 $997.27 $990.48 $983.75 $977.07
$1,025.00 $1,017.98 $1,011.02 $1,004.11 $997.27 $990.48 $983.75 $977.07
$1,025.00 $1,017.98 $1,011.02 $1,004.11 $997.27 $990.48 $983.75 $977.07
21 $1,017.03 $1,012.26 $1,007.52 $1,002.81 $998.13 $993.48 $988.85 $984.25
$1,017.03 $1,012.26 $1,007.52 $1,002.81 $998.13 $993.48 $988.85 $984.25
$1,017.03 $1,012.26 $1,007.52 $1,002.81 $998.13 $993.48 $988.85 $984.25
22 $1,008.71 $1,006.28 $1,003.85 $1,001.44 $999.04 $996.65 $994.26 $991.88
$1,008.71 $1,006.28 $1,003.85 $1,001.44 $999.04 $996.65 $994.26 $991.88
$1,008.71 $1,006.28 $1,003.85 $1,001.44 $999.04 $996.65 $994.26 $991.88
23 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00
$1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00
$1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00



























Investment Horizon Total Future Dollars
Total Future Dollars
Total Future Dollars
1 $1,179.47 $1,142.77 $1,107.68 $1,074.14 $1,042.07 $1,011.40 $982.05 $953.96
$1,178.86 $1,142.12 $1,107.01 $1,073.43 $1,041.33 $1,010.62 $981.24 $953.12
$1,178.86 $1,142.12 $1,107.01 $1,073.43 $1,041.33 $1,010.62 $981.24 $953.12
2 $1,233.15 $1,197.69 $1,163.76 $1,131.28 $1,100.17 $1,070.39 $1,041.85 $1,014.52
$1,229.45 $1,193.78 $1,159.64 $1,126.95 $1,095.64 $1,065.64 $1,036.90 $1,009.35
$1,229.45 $1,193.78 $1,159.64 $1,126.95 $1,095.64 $1,065.64 $1,036.90 $1,009.35
3 $1,289.26 $1,255.26 $1,222.67 $1,191.45 $1,161.52 $1,132.82 $1,105.30 $1,078.91
$1,279.87 $1,245.33 $1,212.21 $1,180.44 $1,149.96 $1,120.72 $1,092.66 $1,065.72
$1,279.87 $1,245.33 $1,212.21 $1,180.44 $1,149.96 $1,120.72 $1,092.66 $1,065.72
4 $1,347.93 $1,315.59 $1,284.57 $1,254.82 $1,226.28 $1,198.89 $1,172.62 $1,147.40
$1,330.13 $1,296.76 $1,264.70 $1,233.90 $1,204.30 $1,175.86 $1,148.52 $1,122.24
$1,330.13 $1,296.76 $1,264.70 $1,233.90 $1,204.30 $1,175.86 $1,148.52 $1,122.24
5 $1,409.27 $1,378.82 $1,349.60 $1,321.56 $1,294.65 $1,268.82 $1,244.03 $1,220.23
$1,380.23 $1,348.06 $1,317.11 $1,287.33 $1,258.67 $1,231.07 $1,204.50 $1,178.92
$1,380.23 $1,348.06 $1,317.11 $1,287.33 $1,258.67 $1,231.07 $1,204.50 $1,178.92
6 $1,473.40 $1,445.09 $1,417.93 $1,391.85 $1,366.83 $1,342.83 $1,319.79 $1,297.69
$1,430.14 $1,399.24 $1,369.45 $1,340.73 $1,313.05 $1,286.35 $1,260.60 $1,235.77
$1,430.14 $1,399.24 $1,369.45 $1,340.73 $1,313.05 $1,286.35 $1,260.60 $1,235.77
7 $1,540.45 $1,514.55 $1,489.71 $1,465.89 $1,443.04 $1,421.15 $1,400.16 $1,380.06
$1,479.87 $1,450.27 $1,421.70 $1,394.10 $1,367.45 $1,341.70 $1,316.83 $1,292.80
$1,479.87 $1,450.27 $1,421.70 $1,394.10 $1,367.45 $1,341.70 $1,316.83 $1,292.80
8 $1,610.55 $1,587.35 $1,565.13 $1,543.86 $1,523.50 $1,504.04 $1,485.43 $1,467.66
$1,529.40 $1,501.17 $1,473.86 $1,447.44 $1,421.88 $1,397.14 $1,373.20 $1,350.03
$1,529.40 $1,501.17 $1,473.86 $1,447.44 $1,421.88 $1,397.14 $1,373.20 $1,350.03
9 $1,683.84 $1,663.64 $1,644.36 $1,625.97 $1,608.45 $1,591.76 $1,575.90 $1,560.82
$1,578.74 $1,551.92 $1,525.93 $1,500.74 $1,476.32 $1,452.66 $1,429.71 $1,407.46
$1,578.74 $1,551.92 $1,525.93 $1,500.74 $1,476.32 $1,452.66 $1,429.71 $1,407.46
10 $1,760.47 $1,743.60 $1,727.61 $1,712.46 $1,698.13 $1,684.61 $1,671.87 $1,659.90
$1,627.85 $1,602.51 $1,577.90 $1,554.01 $1,530.80 $1,508.26 $1,486.37 $1,465.10
$1,627.85 $1,602.51 $1,577.90 $1,554.01 $1,530.80 $1,508.26 $1,486.37 $1,465.10
11 $1,840.58 $1,827.41 $1,815.07 $1,803.54 $1,792.81 $1,782.86 $1,773.69 $1,765.27
$1,676.75 $1,652.94 $1,629.77 $1,607.23 $1,585.30 $1,563.96 $1,543.19 $1,522.98
$1,676.75 $1,652.94 $1,629.77 $1,607.23 $1,585.30 $1,563.96 $1,543.19 $1,522.98
12 $1,924.33 $1,915.24 $1,906.95 $1,899.47 $1,892.77 $1,886.85 $1,881.70 $1,877.32
$1,725.42 $1,703.19 $1,681.53 $1,660.41 $1,639.83 $1,619.76 $1,600.19 $1,581.11
$1,725.42 $1,703.19 $1,681.53 $1,660.41 $1,639.83 $1,619.76 $1,600.19 $1,581.11
13 $2,011.90 $2,007.29 $2,003.49 $2,000.50 $1,998.30 $1,996.91 $1,996.30 $1,996.48
$1,773.84 $1,753.27 $1,733.18 $1,713.55 $1,694.39 $1,675.66 $1,657.37 $1,639.50
$1,773.84 $1,753.27 $1,733.18 $1,713.55 $1,694.39 $1,675.66 $1,657.37 $1,639.50
14 $2,103.46 $2,103.77 $2,104.92 $2,106.90 $2,109.72 $2,113.38 $2,117.87 $2,123.21
$1,822.00 $1,803.16 $1,784.71 $1,766.65 $1,748.98 $1,731.68 $1,714.74 $1,698.16
$1,822.00 $1,803.16 $1,784.71 $1,766.65 $1,748.98 $1,731.68 $1,714.74 $1,698.16
15 $2,199.18 $2,204.89 $2,211.48 $2,218.97 $2,227.35 $2,236.64 $2,246.85 $2,257.99
$1,869.91 $1,852.84 $1,836.11 $1,819.70 $1,803.60 $1,787.81 $1,772.32 $1,757.12
$1,869.91 $1,852.84 $1,836.11 $1,819.70 $1,803.60 $1,787.81 $1,772.32 $1,757.12
16 $2,299.26 $2,310.87 $2,323.44 $2,336.99 $2,351.54 $2,367.10 $2,383.69 $2,401.32
$1,917.53 $1,902.33 $1,887.38 $1,872.69 $1,858.25 $1,844.06 $1,830.11 $1,816.40
$1,917.53 $1,902.33 $1,887.38 $1,872.69 $1,858.25 $1,844.06 $1,830.11 $1,816.40
17 $2,403.89 $2,421.93 $2,441.06 $2,461.30 $2,482.65 $2,505.16 $2,528.85 $2,553.75
$1,964.87 $1,951.59 $1,938.52 $1,925.64 $1,912.95 $1,900.45 $1,888.14 $1,876.01
$1,964.87 $1,951.59 $1,938.52 $1,925.64 $1,912.95 $1,900.45 $1,888.14 $1,876.01
18 $2,513.28 $2,538.34 $2,564.64 $2,592.21 $2,621.08 $2,651.28 $2,682.86 $2,715.85
$2,011.90 $2,000.63 $1,989.50 $1,978.52 $1,967.68 $1,956.98 $1,946.41 $1,935.98
$2,011.90 $2,000.63 $1,989.50 $1,978.52 $1,967.68 $1,956.98 $1,946.41 $1,935.98
19 $2,627.65 $2,660.35 $2,694.48 $2,730.09 $2,767.22 $2,805.92 $2,846.25 $2,888.24
$2,058.61 $2,049.43 $2,040.34 $2,031.35 $2,022.45 $2,013.65 $2,004.94 $1,996.32
$2,058.61 $2,049.43 $2,040.34 $2,031.35 $2,022.45 $2,013.65 $2,004.94 $1,996.32
20 $2,747.22 $2,788.21 $2,830.89 $2,875.30 $2,921.51 $2,969.58 $3,019.58 $3,071.58
$2,105.00 $2,097.98 $2,091.02 $2,084.11 $2,077.27 $2,070.48 $2,063.75 $2,057.07
$2,105.00 $2,097.98 $2,091.02 $2,084.11 $2,077.27 $2,070.48 $2,063.75 $2,057.07
21 $2,872.24 $2,922.23 $2,974.20 $3,028.23 $3,084.40 $3,142.79 $3,203.48 $3,266.55
$2,151.03 $2,146.26 $2,141.52 $2,136.81 $2,132.13 $2,127.48 $2,122.85 $2,118.25
$2,151.03 $2,146.26 $2,141.52 $2,136.81 $2,132.13 $2,127.48 $2,122.85 $2,118.25
22 $3,002.94 $3,062.68 $3,124.77 $3,189.30 $3,256.38 $3,326.10 $3,398.57 $3,473.90
$2,196.71 $2,194.28 $2,191.85 $2,189.44 $2,187.04 $2,184.65 $2,182.26 $2,179.88
$2,196.71 $2,194.28 $2,191.85 $2,189.44 $2,187.04 $2,184.65 $2,182.26 $2,179.88
23 $3,139.60 $3,209.88 $3,282.96 $3,358.94 $3,437.94 $3,520.10 $3,605.54 $3,694.41
$2,242.00 $2,242.00 $2,242.00 $2,242.00 $2,242.00 $2,242.00 $2,242.00 $2,242.00
$2,242.00 $2,242.00 $2,242.00 $2,242.00 $2,242.00 $2,242.00 $2,242.00 $2,242.00



























Investment Horizon Total Return
Total Return
Total Return
1 29.39% 25.37% 21.52% 17.84% 14.32% 10.96% 7.74% 4.66%
29.33% 25.30% 21.45% 17.76% 14.24% 10.87% 7.65% 4.56%
29.33% 25.30% 21.45% 17.76% 14.24% 10.87% 7.65% 4.56%
2 16.31% 14.63% 12.99% 11.40% 9.86% 8.36% 6.91% 5.50%
16.14% 14.44% 12.79% 11.19% 9.63% 8.12% 6.66% 5.23%
16.14% 14.44% 12.79% 11.19% 9.63% 8.12% 6.66% 5.23%
3 12.25% 11.26% 10.28% 9.34% 8.41% 7.51% 6.64% 5.78%
11.98% 10.96% 9.97% 9.00% 8.05% 7.13% 6.23% 5.35%
11.98% 10.96% 9.97% 9.00% 8.05% 7.13% 6.23% 5.35%
4 10.27% 9.61% 8.95% 8.32% 7.70% 7.09% 6.50% 5.92%
9.91% 9.21% 8.53% 7.86% 7.21% 6.57% 5.95% 5.34%
9.91% 9.21% 8.53% 7.86% 7.21% 6.57% 5.95% 5.34%
5 9.11% 8.63% 8.17% 7.71% 7.27% 6.84% 6.42% 6.01%
8.65% 8.14% 7.64% 7.15% 6.67% 6.19% 5.73% 5.28%
8.65% 8.14% 7.64% 7.15% 6.67% 6.19% 5.73% 5.28%
6 8.33% 7.98% 7.64% 7.31% 6.99% 6.67% 6.36% 6.06%
7.80% 7.40% 7.02% 6.64% 6.27% 5.91% 5.55% 5.20%
7.80% 7.40% 7.02% 6.64% 6.27% 5.91% 5.55% 5.20%
7 7.78% 7.52% 7.27% 7.02% 6.78% 6.55% 6.32% 6.10%
7.17% 6.86% 6.56% 6.26% 5.97% 5.68% 5.40% 5.12%
7.17% 6.86% 6.56% 6.26% 5.97% 5.68% 5.40% 5.12%
8 7.37% 7.18% 6.99% 6.81% 6.63% 6.46% 6.29% 6.13%
6.68% 6.43% 6.19% 5.95% 5.71% 5.48% 5.26% 5.03%
6.68% 6.43% 6.19% 5.95% 5.71% 5.48% 5.26% 5.03%
9 7.06% 6.91% 6.78% 6.64% 6.51% 6.39% 6.27% 6.16%
6.29% 6.09% 5.89% 5.70% 5.50% 5.31% 5.13% 4.95%
6.29% 6.09% 5.89% 5.70% 5.50% 5.31% 5.13% 4.95%
10 6.80% 6.70% 6.60% 6.51% 6.42% 6.33% 6.25% 6.18%
5.97% 5.80% 5.64% 5.48% 5.32% 5.16% 5.01% 4.86%
5.97% 5.80% 5.64% 5.48% 5.32% 5.16% 5.01% 4.86%
11 6.60% 6.53% 6.46% 6.40% 6.34% 6.29% 6.24% 6.19%
5.70% 5.56% 5.42% 5.29% 5.16% 5.03% 4.90% 4.78%
5.70% 5.56% 5.42% 5.29% 5.16% 5.03% 4.90% 4.78%
12 6.42% 6.38% 6.34% 6.31% 6.28% 6.25% 6.23% 6.21%
5.46% 5.35% 5.24% 5.12% 5.02% 4.91% 4.80% 4.70%
5.46% 5.35% 5.24% 5.12% 5.02% 4.91% 4.80% 4.70%
13 6.28% 6.26% 6.25% 6.23% 6.22% 6.22% 6.22% 6.22%
5.25% 5.16% 5.07% 4.98% 4.88% 4.79% 4.71% 4.62%
5.25% 5.16% 5.07% 4.98% 4.88% 4.79% 4.71% 4.62%
14 6.15% 6.16% 6.16% 6.17% 6.18% 6.19% 6.21% 6.23%
5.07% 4.99% 4.92% 4.84% 4.76% 4.69% 4.62% 4.54%
5.07% 4.99% 4.92% 4.84% 4.76% 4.69% 4.62% 4.54%
15 6.05% 6.07% 6.09% 6.11% 6.14% 6.17% 6.20% 6.23%
4.91% 4.84% 4.78% 4.72% 4.65% 4.59% 4.53% 4.47%
4.91% 4.84% 4.78% 4.72% 4.65% 4.59% 4.53% 4.47%
16 5.95% 5.99% 6.02% 6.06% 6.10% 6.15% 6.19% 6.24%
4.76% 4.71% 4.65% 4.60% 4.55% 4.50% 4.45% 4.40%
4.76% 4.71% 4.65% 4.60% 4.55% 4.50% 4.45% 4.40%
17 5.87% 5.92% 5.97% 6.02% 6.07% 6.13% 6.19% 6.25%
4.62% 4.58% 4.54% 4.50% 4.46% 4.42% 4.38% 4.34%
4.62% 4.58% 4.54% 4.50% 4.46% 4.42% 4.38% 4.34%
18 5.80% 5.85% 5.92% 5.98% 6.04% 6.11% 6.18% 6.25%
4.50% 4.46% 4.43% 4.40% 4.37% 4.34% 4.30% 4.27%
4.50% 4.46% 4.43% 4.40% 4.37% 4.34% 4.30% 4.27%
19 5.73% 5.80% 5.87% 5.94% 6.02% 6.10% 6.18% 6.26%
4.38% 4.36% 4.33% 4.31% 4.28% 4.26% 4.24% 4.21%
4.38% 4.36% 4.33% 4.31% 4.28% 4.26% 4.24% 4.21%
20 5.67% 5.75% 5.83% 5.91% 6.00% 6.08% 6.17% 6.26%
4.27% 4.26% 4.24% 4.22% 4.20% 4.19% 4.17% 4.15%
4.27% 4.26% 4.24% 4.22% 4.20% 4.19% 4.17% 4.15%
21 5.62% 5.70% 5.79% 5.88% 5.98% 6.07% 6.17% 6.27%
4.17% 4.16% 4.15% 4.14% 4.13% 4.12% 4.11% 4.10%
4.17% 4.16% 4.15% 4.14% 4.13% 4.12% 4.11% 4.10%
22 5.57% 5.66% 5.76% 5.86% 5.96% 6.06% 6.16% 6.27%
4.08% 4.07% 4.07% 4.06% 4.06% 4.05% 4.05% 4.04%
4.08% 4.07% 4.07% 4.06% 4.06% 4.05% 4.05% 4.04%
23 5.52% 5.63% 5.73% 5.83% 5.94% 6.05% 6.16% 6.27%
3.99% 3.99% 3.99% 3.99% 3.99% 3.99% 3.99% 3.99%
3.99% 3.99% 3.99% 3.99% 3.99% 3.99% 3.99% 3.99%