FT Cloud - Leverage Portfolio Worksheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Date
Non Levered Portfolio
Running Total Non Levered Portfolio
Original Borrowed Amount
Borrowed Amount Value
Period Cost
Daily Cost
Net Return on Borrowed Amount
Levered Portfolio Value
Delta Non Levered
Borrowed Amount Value
Net Levered Portfolio
Net Return on Borrowed Amount
Delta Running Total Non Levered Portfolio
Levered Portfolio
Difference
monthdayyear
2
12/31/2012100,000.00100,000.00150,000.00150,000.000.000.000.00100,000.0012312012
3
1/2/2013101,003.10101,003.10150,000.00151,504.60437.5023.031,481.60102,484.701.003%151,504.65151,481.621,481.621,003.10102,484.720.02122,013
4
1/3/2013100,329.50100,329.50150,000.00150,494.20437.5023.03471.18100,800.60-0.667%150,494.20150,471.17471.17-673.60100,800.670.07132,013
5
1/4/2013100,751.00100,751.00150,000.00151,126.60437.5023.031,103.54101,854.600.420%151,126.45151,103.421,103.42421.50101,854.42-0.18142,013
6
1/7/2013100,598.60100,598.60150,000.00150,897.90437.5023.03874.91101,473.50-0.151%150,898.00150,874.97874.97-152.40101,473.570.07172,013
7
1/8/2013100,679.50100,679.50150,000.00151,019.20437.5023.03996.15101,675.600.080%151,019.25150,996.22996.2280.90101,675.720.12182,013
8
1/9/2013100,799.10100,799.10150,000.00151,198.60437.5023.031,175.55101,974.600.119%151,198.60151,175.571,175.57119.60101,974.670.07192,013
9
1/10/2013101,179.10101,179.10150,000.00151,768.60437.5023.031,745.58102,924.700.377%151,768.60151,745.571,745.57380.00102,924.67-0.031102,013
10
1/11/2013101,524.40101,524.40150,000.00152,286.70437.5023.032,263.63103,788.100.341%152,286.55152,263.522,263.52345.30103,787.92-0.181112,013
11
1/14/2013101,373.50101,373.50150,000.00152,060.20437.5023.032,037.16103,410.60-0.149%152,060.35152,037.322,037.32-150.90103,410.820.221142,013
12
1/15/2013101,596.90101,596.90150,000.00152,395.40437.5023.032,372.36103,969.300.220%152,395.30152,372.272,372.27223.40103,969.17-0.131152,013
13
1/16/2013101,671.00101,671.00150,000.00152,506.50437.5023.032,483.49104,154.500.073%152,506.55152,483.522,483.5274.10104,154.520.021162,013
14
1/17/2013101,675.40101,675.40150,000.00152,513.10437.5023.032,490.04104,165.400.004%152,513.10152,490.072,490.074.40104,165.470.071172,013
15
1/18/2013102,118.20102,118.20150,000.00153,177.30437.5023.033,154.22105,272.400.436%153,177.30153,154.273,154.27442.80105,272.470.071182,013
16
1/22/2013102,530.80102,530.80150,000.00153,796.10437.5023.033,773.08106,303.900.404%153,796.20153,773.173,773.17412.60106,303.970.071222,013
17
1/23/2013102,572.40102,572.40150,000.00153,858.50437.5023.033,835.49106,407.900.041%153,858.50153,835.473,835.4741.60106,407.87-0.031232,013
18
1/24/2013102,450.90102,450.90150,000.00153,676.30437.5023.033,653.24106,104.10-0.118%153,676.25153,653.223,653.22-121.50106,104.120.021242,013
19
1/25/2013102,263.40102,263.40150,000.00153,395.00437.5023.033,371.97105,635.30-0.183%153,395.05153,372.023,372.02-187.50105,635.420.121252,013
20
1/28/2013102,045.70102,045.70150,000.00153,068.50437.5023.033,045.43105,091.10-0.213%153,068.45153,045.423,045.42-217.70105,091.120.021282,013
21
1/29/2013102,079.70102,079.70150,000.00153,119.50437.5023.033,096.49105,176.200.033%153,119.50153,096.473,096.4734.00105,176.17-0.031292,013
22
1/30/2013101,765.40101,765.40150,000.00152,648.10437.5023.032,625.07104,390.50-0.308%152,648.05152,625.022,625.02-314.30104,390.42-0.081302,013
23
1/31/2013101,797.20101,797.20150,000.00152,695.80437.5023.032,672.76104,470.000.031%152,695.80152,672.772,672.7731.80104,469.97-0.031312,013
24
2/1/2013101,898.30104,573.70156,705.00156,860.50457.0626.89128.71104,702.400.099%156,860.63156,833.75128.752,776.50104,702.450.05212,013
25
2/4/2013101,719.70104,390.40156,705.00156,585.70457.0626.89-146.18104,244.30-0.175%156,585.57156,558.68-146.32-183.30104,244.08-0.22242,013
26
2/5/2013101,974.00104,651.40156,705.00156,977.00457.0626.89245.18104,896.500.250%156,977.17156,950.28245.28261.00104,896.680.18252,013
27
2/6/2013102,348.90105,036.10156,705.00157,554.20457.0626.89822.33105,858.500.368%157,554.11157,527.23822.23384.70105,858.33-0.17262,013
28
2/7/2013102,177.20104,859.90156,705.00157,289.90457.0626.89558.02105,417.90-0.168%157,289.89157,263.00558.00-176.20105,417.900.00272,013
29
2/8/2013102,676.50105,372.30156,705.00158,058.40457.0626.891,326.60106,698.900.489%158,058.51158,031.631,326.63512.40106,698.930.03282,013
30
2/11/2013102,632.90105,327.50156,705.00157,991.30457.0626.891,259.47106,587.00-0.042%157,991.28157,964.401,259.40-44.80106,586.90-0.102112,013
31
2/12/2013102,633.80105,328.50156,705.00157,992.80457.0626.891,260.91106,589.400.001%157,992.69157,965.801,260.801.00106,589.30-0.102122,013
32
2/13/2013102,356.80105,044.20156,705.00157,566.30457.0626.89834.46105,878.70-0.270%157,566.39157,539.51834.51-284.30105,878.710.012132,013
33
2/14/2013102,779.10105,477.70156,705.00158,216.50457.0626.891,484.66106,962.300.413%158,216.38158,189.501,484.50433.50106,962.20-0.102142,013
34
2/15/2013102,587.20105,280.70156,705.00157,921.00457.0626.891,189.16106,469.80-0.187%157,921.09157,894.211,189.21-197.00106,469.910.112152,013
35
2/19/2013102,850.70105,551.10156,705.00158,326.70457.0626.891,594.82107,145.900.257%158,326.63158,299.741,594.74270.40107,145.84-0.062192,013
36
2/20/2013102,193.10104,876.20156,705.00157,314.30457.0626.89582.50105,458.80-0.639%157,314.40157,287.52582.52-674.90105,458.72-0.082202,013
37
2/21/2013102,054.10104,733.60156,705.00157,100.50457.0626.89368.61105,102.30-0.136%157,100.33157,073.44368.44-142.60105,102.04-0.262212,013
38
2/22/2013102,681.80105,377.80156,705.00158,066.70457.0626.891,334.83106,712.600.615%158,066.77158,039.891,334.89644.20106,712.690.092222,013
39
2/25/2013102,302.80104,988.80156,705.00157,483.20457.0626.89751.38105,740.20-0.369%157,483.27157,456.39751.39-389.00105,740.19-0.012252,013
40
2/26/2013102,479.00105,169.70156,705.00157,754.50457.0626.891,022.71106,192.400.172%157,754.44157,727.551,022.55180.90106,192.25-0.152262,013
41
2/27/2013103,128.40105,836.10156,705.00158,754.20457.0626.892,022.33107,858.500.634%158,754.18158,727.292,022.29666.40107,858.39-0.112272,013
42
2/28/2013103,082.40105,788.90156,705.00158,683.40457.0626.891,951.54107,740.50-0.045%158,683.39158,656.501,951.50-47.20107,740.40-0.102282,013
43
3/1/2013103,510.20108,187.60161,610.70162,281.40471.3626.19644.50108,832.100.415%162,281.40162,255.21644.512,398.70108,832.110.01312,013
44
3/4/2013103,621.10108,303.50161,610.70162,455.20471.3626.19818.33109,121.800.107%162,455.27162,429.08818.38115.90109,121.880.08342,013
45
3/5/2013104,061.50108,763.80161,610.70163,145.70471.3626.191,508.78110,272.500.425%163,145.65163,119.461,508.76460.30110,272.560.06352,013
46
3/6/2013103,774.00108,463.30161,610.70162,695.00471.3626.191,058.11109,521.40-0.276%162,694.96162,668.781,058.08-300.50109,521.38-0.02362,013
47
3/7/2013103,574.70108,255.00161,610.70162,382.50471.3626.19745.61109,000.60-0.192%162,382.54162,356.35745.65-208.30109,000.650.05372,013
48
3/8/2013103,421.50108,094.90161,610.70162,142.30471.3626.19505.47108,600.40-0.148%162,142.32162,116.13505.43-160.10108,600.33-0.07382,013
49
3/11/2013103,700.70108,386.60161,610.70162,580.00471.3626.19943.09109,329.700.270%162,580.02162,553.84943.14291.70109,329.740.043112,013
50
3/12/2013103,847.10108,539.70161,610.70162,809.60471.3626.191,172.72109,712.400.141%162,809.52162,783.341,172.64153.10109,712.34-0.063122,013
51
3/13/2013103,899.40108,594.30161,610.70162,891.50471.3626.191,254.66109,849.000.050%162,891.59162,865.411,254.7154.60109,849.010.013132,013
52
3/14/2013104,111.70108,816.20161,610.70163,224.30471.3626.191,587.42110,403.600.204%163,224.34163,198.151,587.45221.90110,403.650.053142,013
53
3/15/2013104,216.10108,925.40161,610.70163,388.10471.3626.191,751.24110,676.600.100%163,387.98163,361.791,751.09109.20110,676.49-0.113152,013
54
3/18/2013104,170.40108,877.60161,610.70163,316.40471.3626.191,679.55110,557.10-0.044%163,316.45163,290.271,679.57-47.80110,557.170.073182,013
55
3/19/2013104,298.50109,011.50161,610.70163,517.30471.3626.191,880.38110,891.900.123%163,517.23163,491.051,880.35133.90110,891.85-0.053192,013
56
3/20/2013104,284.50108,996.90161,610.70163,495.30471.3626.191,858.42110,855.30-0.013%163,495.35163,469.161,858.46-14.60110,855.360.063202,013
57
3/21/2013104,129.50108,834.80161,610.70163,252.20471.3626.191,615.36110,450.20-0.149%163,252.29163,226.111,615.41-162.10110,450.210.013212,013
58
3/22/2013104,669.00109,398.80161,610.70164,098.20471.3626.192,461.28111,860.000.518%164,098.02164,071.832,461.13564.00111,859.93-0.073222,013
59
3/25/2013104,364.80109,080.70161,610.70163,621.10471.3626.191,984.27111,065.00-0.291%163,621.28163,595.091,984.39-318.10111,065.090.093252,013
60
3/26/2013104,921.80109,662.90161,610.70164,494.40471.3626.192,857.53112,520.500.534%164,494.35164,468.172,857.47582.20112,520.37-0.133262,013
61
3/27/2013105,270.40110,027.30161,610.70165,040.90471.3626.193,404.03113,431.300.332%165,040.93165,014.743,404.04364.40113,431.340.043272,013
62
3/28/2013105,257.60110,013.90161,610.70165,021.00471.3626.193,384.08113,398.00-0.012%165,020.83164,994.653,383.95-13.40113,397.85-0.153282,013
63
4/1/2013105,324.10113,469.60170,097.00170,204.50496.1224.8182.63113,552.300.063%170,204.46170,179.6682.663,455.70113,552.26-0.04412,013
64
4/2/2013105,462.80113,619.10170,097.00170,428.60496.1224.81306.79113,925.900.132%170,428.64170,403.83306.83149.50113,925.930.03422,013
65
4/3/2013105,201.20113,337.20170,097.00170,005.80496.1224.81-116.09113,221.10-0.248%170,005.85169,981.05-115.95-281.90113,221.250.15432,013
66
4/4/2013105,963.80114,158.80170,097.00171,238.30496.1224.811,116.43115,275.300.725%171,238.17171,213.361,116.36821.60115,275.16-0.14442,013
67
4/5/2013106,552.60114,793.10170,097.00172,189.70496.1224.812,067.87116,861.000.556%172,189.81172,165.002,068.00634.30116,861.100.10452,013
68
4/8/2013106,639.30114,886.60170,097.00172,329.80496.1224.812,208.01117,094.600.081%172,329.81172,305.002,208.0093.50117,094.600.00482,013
69
4/9/2013106,749.30115,005.00170,097.00172,507.50496.1224.812,385.71117,390.700.103%172,507.56172,482.752,385.75118.40117,390.750.05492,013
70
4/10/2013106,924.90115,194.30170,097.00172,791.40496.1224.812,669.55117,863.800.164%172,791.27172,766.462,669.46189.30117,863.76-0.044102,013
71
4/11/2013107,217.00115,509.00170,097.00173,263.40496.1224.813,141.59118,650.500.273%173,263.44173,238.633,141.63314.70118,650.630.134112,013
72
4/12/2013107,701.20116,030.50170,097.00174,045.80496.1224.813,923.94119,954.500.452%174,045.87174,021.063,924.06521.50119,954.560.064122,013
73
4/15/2013106,597.50114,841.50170,097.00172,262.20496.1224.812,140.38116,981.90-1.025%172,262.21172,237.412,140.41-1,189.00116,981.910.014152,013
74
4/16/2013107,158.70115,446.10170,097.00173,169.20496.1224.813,047.38118,493.500.526%173,169.10173,144.303,047.30604.60118,493.40-0.104162,013
75
4/17/2013106,521.70114,759.80170,097.00172,139.70496.1224.812,017.90116,777.70-0.594%172,139.80172,115.002,018.00-686.30116,777.800.104172,013
76
4/18/2013106,238.30114,454.50170,097.00171,681.70496.1224.811,559.88116,014.40-0.266%171,681.72171,656.921,559.92-305.30116,014.420.024182,013
77
4/19/2013106,685.20114,936.00170,097.00172,404.00496.1224.812,282.16117,218.200.421%172,403.89172,379.092,282.09481.50117,218.09-0.114192,013
78
4/22/2013106,995.70115,270.50170,097.00172,905.80496.1224.812,783.99118,054.500.291%172,905.77172,880.962,783.96334.50118,054.46-0.044222,013
79
4/23/2013107,490.70115,803.80170,097.00173,705.60496.1224.813,583.80119,387.600.463%173,705.72173,680.923,583.92533.30119,387.720.124232,013
80
4/24/2013107,642.00115,966.70170,097.00173,950.10496.1224.813,828.27119,795.000.141%173,950.10173,925.303,828.30162.90119,795.000.004242,013
81
4/25/2013107,710.00116,040.00170,097.00174,060.00496.1224.813,938.21119,978.200.063%174,059.99174,035.183,938.1873.30119,978.18-0.024252,013
82
4/26/2013107,998.50116,350.80170,097.00174,526.20496.1224.814,404.38120,755.200.268%174,526.22174,501.414,404.41310.80120,755.210.014262,013
83
4/29/2013108,264.80116,637.80170,097.00174,956.70496.1224.814,834.82121,472.600.247%174,956.54174,931.744,834.74287.00121,472.54-0.064292,013
84
4/30/2013108,442.70116,829.40170,097.00175,244.10496.1224.815,122.24121,951.600.164%175,244.19175,219.385,122.38191.60121,951.780.184302,013
85
5/1/2013108,316.80121,810.10182,927.40182,715.10533.5426.68-238.99121,571.10-0.116%182,715.02182,688.35-239.054,980.70121,571.05-0.05512,013
86
5/2/2013108,859.20122,420.10182,927.40183,630.10533.5426.68676.01123,096.100.501%183,630.05183,603.38675.98610.00123,096.08-0.02522,013
87
5/3/2013108,487.60122,002.10182,927.40183,003.20533.5426.6849.04122,051.10-0.341%183,003.26182,976.5949.19-418.00122,051.290.19532,013
88
5/6/2013108,548.60122,070.80182,927.40183,106.20533.5426.68152.09122,222.900.056%183,106.10183,079.42152.0268.70122,222.82-0.08562,013
89
5/7/2013108,716.80122,259.90182,927.40183,389.80533.5426.68435.68122,695.500.155%183,389.93183,363.25435.85189.10122,695.750.25572,013
90
5/8/2013109,085.60122,674.70182,927.40184,012.00533.5426.681,057.92123,732.600.339%184,011.91183,985.241,057.84414.80123,732.54-0.06582,013
91
5/9/2013108,788.40122,340.40182,927.40183,510.70533.5426.68556.56122,897.00-0.272%183,510.67183,483.99556.59-334.30122,896.99-0.01592,013
92
5/10/2013108,548.30122,070.40182,927.40183,105.70533.5426.68151.56122,222.00-0.221%183,105.69183,079.01151.61-270.00122,222.010.015102,013
93
5/13/2013108,279.80121,768.40182,927.40182,652.70533.5426.68-301.46121,467.00-0.247%182,652.78182,626.10-301.30-302.00121,467.100.105132,013
94
5/14/2013108,516.40122,034.60182,927.40183,051.80533.5426.6897.73122,132.300.219%183,051.81183,025.1397.73266.20122,132.330.035142,013
95
5/15/2013109,154.70122,752.30182,927.40184,128.50533.5426.681,174.40123,926.700.588%184,128.52184,101.841,174.44717.70123,926.740.045152,013
96
5/16/2013109,267.80122,879.60182,927.40184,319.40533.5426.681,365.26124,244.800.104%184,319.28184,292.611,365.21127.30124,244.810.015162,013
97
5/17/2013109,389.40123,016.20182,927.40184,524.40533.5426.681,570.26124,586.500.111%184,524.52184,497.851,570.45136.60124,586.650.155172,013
98
5/20/2013109,336.10122,956.40182,927.40184,434.50533.5426.681,480.43124,436.80-0.049%184,434.49184,407.811,480.41-59.80124,436.810.015202,013
99
5/21/2013109,758.90123,431.80182,927.40185,147.70533.5426.682,193.56125,625.300.387%185,147.70185,121.032,193.63475.40125,625.430.135212,013
100
5/22/2013108,635.40122,168.40182,927.40183,252.60533.5426.68298.50122,466.90-1.024%183,252.51183,225.84298.44-1,263.40122,466.84-0.065222,013
Loading...