ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
MonthMonthly Premiums Before Spreads Widen (MPB)Monthly Premiums After Spreads Widen (MPA)Present Value Discount Rate: ( 1 + ( riskFreeRate x ( month / 12) )Present Value of MPB: ( premium before / monthly discount rate )Present Value of MPA: ( premium after / monthly discount rate )VariablesProfit
2
1$27,000,000.00$72,900,000.001.00125$26,966,292.13$72,808,988.76Risk-free rate1.50%Value of CDS Before Spreads Widen$1,561,184,808.41
3
2$27,000,000.00$72,900,000.001.0025$26,932,668.33$72,718,204.49Spreads Before0.50%Value of CDS After Spreads Widen$4,215,198,982.70
4
3$27,000,000.00$72,900,000.001.00375$26,899,128.27$72,627,646.33Spreads After1.35%Total Profit$2,654,014,174.29
5
4$27,000,000.00$72,900,000.001.005$26,865,671.64$72,537,313.43Notional Amount$64,800,000,000.00
6
5$27,000,000.00$72,900,000.001.00625$26,832,298.14$72,447,204.97
7
6$27,000,000.00$72,900,000.001.0075$26,799,007.44$72,357,320.10
8
7$27,000,000.00$72,900,000.001.00875$26,765,799.26$72,267,657.99
9
8$27,000,000.00$72,900,000.001.01$26,732,673.27$72,178,217.82
10
9$27,000,000.00$72,900,000.001.01125$26,699,629.17$72,088,998.76
11
10$27,000,000.00$72,900,000.001.0125$26,666,666.67$72,000,000.00
12
11$27,000,000.00$72,900,000.001.01375$26,633,785.45$71,911,220.72
13
12$27,000,000.00$72,900,000.001.015$26,600,985.22$71,822,660.10
14
13$27,000,000.00$72,900,000.001.01625$26,568,265.68$71,734,317.34
15
14$27,000,000.00$72,900,000.001.0175$26,535,626.54$71,646,191.65
16
15$27,000,000.00$72,900,000.001.01875$26,503,067.48$71,558,282.21
17
16$27,000,000.00$72,900,000.001.02$26,470,588.24$71,470,588.24
18
17$27,000,000.00$72,900,000.001.02125$26,438,188.49$71,383,108.94
19
18$27,000,000.00$72,900,000.001.0225$26,405,867.97$71,295,843.52
20
19$27,000,000.00$72,900,000.001.02375$26,373,626.37$71,208,791.21
21
20$27,000,000.00$72,900,000.001.025$26,341,463.41$71,121,951.22
22
21$27,000,000.00$72,900,000.001.02625$26,309,378.81$71,035,322.78
23
22$27,000,000.00$72,900,000.001.0275$26,277,372.26$70,948,905.11
24
23$27,000,000.00$72,900,000.001.02875$26,245,443.50$70,862,697.45
25
24$27,000,000.00$72,900,000.001.03$26,213,592.23$70,776,699.03
26
25$27,000,000.00$72,900,000.001.03125$26,181,818.18$70,690,909.09
27
26$27,000,000.00$72,900,000.001.0325$26,150,121.07$70,605,326.88
28
27$27,000,000.00$72,900,000.001.03375$26,118,500.60$70,519,951.63
29
28$27,000,000.00$72,900,000.001.035$26,086,956.52$70,434,782.61
30
29$27,000,000.00$72,900,000.001.03625$26,055,488.54$70,349,819.06
31
30$27,000,000.00$72,900,000.001.0375$26,024,096.39$70,265,060.24
32
31$27,000,000.00$72,900,000.001.03875$25,992,779.78$70,180,505.42
33
32$27,000,000.00$72,900,000.001.04$25,961,538.46$70,096,153.85
34
33$27,000,000.00$72,900,000.001.04125$25,930,372.15$70,012,004.80
35
34$27,000,000.00$72,900,000.001.0425$25,899,280.58$69,928,057.55
36
35$27,000,000.00$72,900,000.001.04375$25,868,263.47$69,844,311.38
37
36$27,000,000.00$72,900,000.001.045$25,837,320.57$69,760,765.55
38
37$27,000,000.00$72,900,000.001.04625$25,806,451.61$69,677,419.35
39
38$27,000,000.00$72,900,000.001.0475$25,775,656.32$69,594,272.08
40
39$27,000,000.00$72,900,000.001.04875$25,744,934.45$69,511,323.00
41
40$27,000,000.00$72,900,000.001.05$25,714,285.71$69,428,571.43
42
41$27,000,000.00$72,900,000.001.05125$25,683,709.87$69,346,016.65
43
42$27,000,000.00$72,900,000.001.0525$25,653,206.65$69,263,657.96
44
43$27,000,000.00$72,900,000.001.05375$25,622,775.80$69,181,494.66
45
44$27,000,000.00$72,900,000.001.055$25,592,417.06$69,099,526.07
46
45$27,000,000.00$72,900,000.001.05625$25,562,130.18$69,017,751.48
47
46$27,000,000.00$72,900,000.001.0575$25,531,914.89$68,936,170.21
48
47$27,000,000.00$72,900,000.001.05875$25,501,770.96$68,854,781.58
49
48$27,000,000.00$72,900,000.001.06$25,471,698.11$68,773,584.91
50
49$27,000,000.00$72,900,000.001.06125$25,441,696.11$68,692,579.51
51
50$27,000,000.00$72,900,000.001.0625$25,411,764.71$68,611,764.71
52
51$27,000,000.00$72,900,000.001.06375$25,381,903.64$68,531,139.84
53
52$27,000,000.00$72,900,000.001.065$25,352,112.68$68,450,704.23
54
53$27,000,000.00$72,900,000.001.06625$25,322,391.56$68,370,457.21
55
54$27,000,000.00$72,900,000.001.0675$25,292,740.05$68,290,398.13
56
55$27,000,000.00$72,900,000.001.06875$25,263,157.89$68,210,526.32
57
56$27,000,000.00$72,900,000.001.07$25,233,644.86$68,130,841.12
58
57$27,000,000.00$72,900,000.001.07125$25,204,200.70$68,051,341.89
59
58$27,000,000.00$72,900,000.001.0725$25,174,825.17$67,972,027.97
60
59$27,000,000.00$72,900,000.001.07375$25,145,518.04$67,892,898.72
61
60$27,000,000.00$72,900,000.001.075$25,116,279.07$67,813,953.49