Advanced Excel (Maleeha Waheed)

Sales figure for the first quarter
Salesperson Jan Feb March

Moe 200 300 300
Larry 100 400 200
Curly 400 600 600
Joe 500 200 700
Shemp 300 400 400
Total 1500 1900 2200
Lowest Sales 100 200 200
Highest Sales 500 600 700
Second
smallest value
200
Second largest
value 400
Revenue Results for ABC Company
Last Year This year Variance % Variance
North 472,332 487,974 15,642 0.0331165367
North East 561,270 578,171 16,901 0.0301120673
Mid Atlantic 378,259 312,963 -65,296 -0.172622462
South East 388,290 355,365 -32,925 -0.08479487
Gulf States 625,474 672,619 47,145 0.0753748357
Midwest 488,872 465,585 -23,287 -0.047634146
Mountain
351,313 350,201
States -1,112 -0.003165269
Upper Midwest 212,008 231,155
19,147 0.0903126297
South West 489,941 515,658 25,717 0.0524899937
Pacific 549,705 553,640 3,935 0.007158385
Total 4517464 4523331 5,867
Total Average High Low
Last Year 4517464
This Year 4523331
Number of years 30
Number of
months 360
Interest rate
(Year) 4.00%
Interest rate
(Month) 0.33%
Principal 300,000
Payment 1,432.25
Principal
Period Month Balance Interest Pre-payment New Balance
paid
0 $ 300,000.00
1 1/1/2011 $ 300,000.00 $ 999.90 $ 432.35 $ 299,567.65
2 1/2/2011 $ 299,567.65 $ 998.46 $ 433.79 $ 299,133.86
3 1/3/2011 $ 299,133.86 $ 997.01 $ 435.24 $ 298,698.62
4 1/4/2011 $ 298,698.62 $ 995.56 $ 436.69 $ 298,261.93
5 1/5/2011 $ 298,261.93 $ 994.11 $ 438.14 $ 50,000.00 $ 247,823.79
6 1/6/2011 $ 247,823.79 $ 826.00 $ 606.25 $ 247,217.54
7 1/7/2011 $ 247,217.54 $ 823.98 $ 608.27 $ 246,609.26
8 1/8/2011 $ 246,609.26 $ 821.95 $ 610.30 $ 245,998.96
9 1/9/2011 $ 245,998.96 $ 819.91 $ 612.34 $ 245,386.63
10 1/10/2011 $ 245,386.63 $ 817.87 $ 614.38 $ 244,772.25
11 1/11/2011 $ 244,772.25 $ 815.83 $ 616.42 $ 244,155.83
12 1/12/2011 $ 244,155.83 $ 813.77 $ 618.48 $ 243,537.35
13 1/13/2011 $ 243,537.35 $ 811.71 $ 620.54 $ 242,916.81
14 1/14/2011 $ 242,916.81 $ 809.64 $ 622.61 $ 242,294.20
15 1/15/2011 $ 242,294.20 $ 807.57 $ 624.68 $ 241,669.52
16 1/16/2011 $ 241,669.52 $ 805.48 $ 626.77 $ 241,042.75
17 1/17/2011 $ 241,042.75 $ 803.40 $ 628.85 $ 240,413.90
18 1/18/2011 $ 240,413.90 $ 801.30 $ 630.95 $ 239,782.95
19 1/19/2011 $ 239,782.95 $ 799.20 $ 633.05 $ 239,149.89
20 1/20/2011 $ 239,149.89 $ 797.09 $ 635.16 $ 238,514.73
21 1/21/2011 $ 238,514.73 $ 794.97 $ 637.28 $ 237,877.45
22 1/22/2011 $ 237,877.45 $ 792.85 $ 639.40 $ 237,238.04
23 1/23/2011 $ 237,238.04 $ 790.71 $ 641.54 $ 236,596.51
24 1/24/2011 $ 236,596.51 $ 788.58 $ 643.67 $ 235,952.84
25 1/25/2011 $ 235,952.84 $ 786.43 $ 645.82 $ 235,307.02
26 1/26/2011 $ 235,307.02 $ 784.28 $ 647.97 $ 234,659.04
27 1/27/2011 $ 234,659.04 $ 782.12 $ 650.13 $ 234,008.91
28 1/28/2011 $ 234,008.91 $ 779.95 $ 652.30 $ 233,356.61
29 1/29/2011 $ 233,356.61 $ 777.78 $ 654.47 $ 232,702.14
30 1/30/2011 $ 232,702.14 $ 775.60 $ 656.65 $ 232,045.49
31 1/31/2011 $ 232,045.49 $ 773.41 $ 658.84 $ 231,386.65
32 2/1/2011 $ 231,386.65 $ 771.21 $ 661.04 $ 230,725.61
33 2/2/2011 $ 230,725.61 $ 769.01 $ 663.24 $ 230,062.37
34 2/3/2011 $ 230,062.37 $ 766.80 $ 665.45 $ 229,396.91
35 2/4/2011 $ 229,396.91 $ 764.58 $ 667.67 $ 228,729.24
36 2/5/2011 $ 228,729.24 $ 762.35 $ 669.90 $ 228,059.35
37 2/6/2011 $ 228,059.35 $ 760.12 $ 672.13 $ 227,387.22
38 2/7/2011 $ 227,387.22 $ 757.88 $ 674.37 $ 226,712.85
39 2/8/2011 $ 226,712.85 $ 755.63 $ 676.62 $ 226,036.24
40 2/9/2011 $ 226,036.24 $ 753.38 $ 678.87 $ 225,357.36
41 2/10/2011 $ 225,357.36 $ 751.12 $ 681.13 $ 224,676.23
42 2/11/2011 $ 224,676.23 $ 748.85 $ 683.40 $ 223,992.83
43 2/12/2011 $ 223,992.83 $ 746.57 $ 685.68 $ 223,307.14
44 2/13/2011 $ 223,307.14 $ 744.28 $ 687.97 $ 222,619.18
45 2/14/2011 $ 222,619.18 $ 741.99 $ 690.26 $ 221,928.92
46 2/15/2011 $ 221,928.92 $ 739.69 $ 692.56 $ 221,236.36
47 2/16/2011 $ 221,236.36 $ 737.38 $ 694.87 $ 220,541.49
48 2/17/2011 $ 220,541.49 $ 735.06 $ 697.19 $ 219,844.30
49 2/18/2011 $ 219,844.30 $ 732.74 $ 699.51 $ 219,144.79
50 2/19/2011 $ 219,144.79 $ 730.41 $ 701.84 $ 218,442.95
51 2/20/2011 $ 218,442.95 $ 728.07 $ 704.18 $ 217,738.77
52 2/21/2011 $ 217,738.77 $ 725.72 $ 706.53 $ 217,032.25
53 2/22/2011 $ 217,032.25 $ 723.37 $ 708.88 $ 216,323.36
54 2/23/2011 $ 216,323.36 $ 721.01 $ 711.24 $ 215,612.12
55 2/24/2011 $ 215,612.12 $ 718.64 $ 713.61 $ 214,898.51
56 2/25/2011 $ 214,898.51 $ 716.26 $ 715.99 $ 214,182.51
57 2/26/2011 $ 214,182.51 $ 713.87 $ 718.38 $ 213,464.13
58 2/27/2011 $ 213,464.13 $ 711.48 $ 720.77 $ 212,743.36
59 2/28/2011 $ 212,743.36 $ 709.07 $ 723.18 $ 212,020.18
60 3/1/2011 $ 212,020.18 $ 706.66 $ 725.59 $ 211,294.60
61 3/2/2011 $ 211,294.60 $ 704.24 $ 728.01 $ 210,566.59
62 3/3/2011 $ 210,566.59 $ 701.82 $ 730.43 $ 209,836.16
63 3/4/2011 $ 209,836.16 $ 699.38 $ 732.87 $ 209,103.29
64 3/5/2011 $ 209,103.29 $ 696.94 $ 735.31 $ 208,367.98
65 3/6/2011 $ 208,367.98 $ 694.49 $ 737.76 $ 207,630.22
66 3/7/2011 $ 207,630.22 $ 692.03 $ 740.22 $ 206,890.01
67 3/8/2011 $ 206,890.01 $ 689.56 $ 742.69 $ 206,147.32
68 3/9/2011 $ 206,147.32 $ 687.09 $ 745.16 $ 205,402.16
69 3/10/2011 $ 205,402.16 $ 684.61 $ 747.64 $ 204,654.51
70 3/11/2011 $ 204,654.51 $ 682.11 $ 750.14 $ 203,904.38
71 3/12/2011 $ 203,904.38 $ 679.61 $ 752.64 $ 203,151.74
72 3/13/2011 $ 203,151.74 $ 677.10 $ 755.15 $ 202,396.60
73 3/14/2011 $ 202,396.60 $ 674.59 $ 757.66 $ 201,638.93
74 3/15/2011 $ 201,638.93 $ 672.06 $ 760.19 $ 200,878.75
75 3/16/2011 $ 200,878.75 $ 669.53 $ 762.72 $ 200,116.03
76 3/17/2011 $ 200,116.03 $ 666.99 $ 765.26 $ 199,350.76
77 3/18/2011 $ 199,350.76 $ 664.44 $ 767.81 $ 198,582.95
78 3/19/2011 $ 198,582.95 $ 661.88 $ 770.37 $ 197,812.58
79 3/20/2011 $ 197,812.58 $ 659.31 $ 772.94 $ 197,039.63
80 3/21/2011 $ 197,039.63 $ 656.73 $ 775.52 $ 196,264.12
81 3/22/2011 $ 196,264.12 $ 654.15 $ 778.10 $ 195,486.02
82 3/23/2011 $ 195,486.02 $ 651.55 $ 780.70 $ 194,705.32
83 3/24/2011 $ 194,705.32 $ 648.95 $ 783.30 $ 193,922.02
84 3/25/2011 $ 193,922.02 $ 646.34 $ 785.91 $ 193,136.12
85 3/26/2011 $ 193,136.12 $ 643.72 $ 788.53 $ 192,347.59
86 3/27/2011 $ 192,347.59 $ 641.09 $ 791.16 $ 191,556.43
87 3/28/2011 $ 191,556.43 $ 638.46 $ 793.79 $ 190,762.64
88 3/29/2011 $ 190,762.64 $ 635.81 $ 796.44 $ 189,966.20
89 3/30/2011 $ 189,966.20 $ 633.16 $ 799.09 $ 189,167.11
90 3/31/2011 $ 189,167.11 $ 630.49 $ 801.76 $ 188,365.35
91 4/1/2011 $ 188,365.35 $ 627.82 $ 804.43 $ 187,560.93
92 4/2/2011 $ 187,560.93 $ 625.14 $ 807.11 $ 186,753.82
93 4/3/2011 $ 186,753.82 $ 622.45 $ 809.80 $ 185,944.02
94 4/4/2011 $ 185,944.02 $ 619.75 $ 812.50 $ 185,131.52
95 4/5/2011 $ 185,131.52 $ 617.04 $ 815.21 $ 184,316.31
96 4/6/2011 $ 184,316.31 $ 614.33 $ 817.92 $ 183,498.39
97 4/7/2011 $ 183,498.39 $ 611.60 $ 820.65 $ 182,677.74
98 4/8/2011 $ 182,677.74 $ 608.86 $ 823.39 $ 181,854.35
99 4/9/2011 $ 181,854.35 $ 606.12 $ 826.13 $ 181,028.22
100 4/10/2011 $ 181,028.22 $ 603.37 $ 828.88 $ 180,199.34
101 4/11/2011 $ 180,199.34 $ 600.60 $ 831.65 $ 179,367.69
102 4/12/2011 $ 179,367.69 $ 597.83 $ 834.42 $ 178,533.28
103 4/13/2011 $ 178,533.28 $ 595.05 $ 837.20 $ 177,696.08
104 4/14/2011 $ 177,696.08 $ 592.26 $ 839.99 $ 176,856.09
105 4/15/2011 $ 176,856.09 $ 589.46 $ 842.79 $ 176,013.30
106 4/16/2011 $ 176,013.30 $ 586.65 $ 845.60 $ 175,167.70
107 4/17/2011 $ 175,167.70 $ 583.83 $ 848.42 $ 174,319.29
108 4/18/2011 $ 174,319.29 $ 581.01 $ 851.24 $ 173,468.04
109 4/19/2011 $ 173,468.04 $ 578.17 $ 854.08 $ 172,613.96
110 4/20/2011 $ 172,613.96 $ 575.32 $ 856.93 $ 171,757.03
111 4/21/2011 $ 171,757.03 $ 572.47 $ 859.78 $ 170,897.25
112 4/22/2011 $ 170,897.25 $ 569.60 $ 862.65 $ 170,034.60
113 4/23/2011 $ 170,034.60 $ 566.73 $ 865.52 $ 169,169.08
114 4/24/2011 $ 169,169.08 $ 563.84 $ 868.41 $ 168,300.67
115 4/25/2011 $ 168,300.67 $ 560.95 $ 871.30 $ 167,429.36
116 4/26/2011 $ 167,429.36 $ 558.04 $ 874.21 $ 166,555.16
117 4/27/2011 $ 166,555.16 $ 555.13 $ 877.12 $ 165,678.03
118 4/28/2011 $ 165,678.03 $ 552.20 $ 880.05 $ 164,797.99
119 4/29/2011 $ 164,797.99 $ 549.27 $ 882.98 $ 163,915.01
120 4/30/2011 $ 163,915.01 $ 546.33 $ 885.92 $ 163,029.09
121 5/1/2011 $ 163,029.09 $ 543.38 $ 888.87 $ 162,140.22
122 5/2/2011 $ 162,140.22 $ 540.41 $ 891.84 $ 161,248.38
123 5/3/2011 $ 161,248.38 $ 537.44 $ 894.81 $ 160,353.57
124 5/4/2011 $ 160,353.57 $ 534.46 $ 897.79 $ 159,455.78
125 5/5/2011 $ 159,455.78 $ 531.47 $ 900.78 $ 158,554.99
126 5/6/2011 $ 158,554.99 $ 528.46 $ 903.79 $ 157,651.21
127 5/7/2011 $ 157,651.21 $ 525.45 $ 906.80 $ 156,744.41
128 5/8/2011 $ 156,744.41 $ 522.43 $ 909.82 $ 155,834.59
129 5/9/2011 $ 155,834.59 $ 519.40 $ 912.85 $ 154,921.74
130 5/10/2011 $ 154,921.74 $ 516.35 $ 915.90 $ 154,005.84
131 5/11/2011 $ 154,005.84 $ 513.30 $ 918.95 $ 153,086.89
132 5/12/2011 $ 153,086.89 $ 510.24 $ 922.01 $ 152,164.88
133 5/13/2011 $ 152,164.88 $ 507.17 $ 925.08 $ 151,239.79
134 5/14/2011 $ 151,239.79 $ 504.08 $ 928.17 $ 150,311.63
135 5/15/2011 $ 150,311.63 $ 500.99 $ 931.26 $ 149,380.37
136 5/16/2011 $ 149,380.37 $ 497.88 $ 934.37 $ 148,446.00
137 5/17/2011 $ 148,446.00 $ 494.77 $ 937.48 $ 147,508.52
138 5/18/2011 $ 147,508.52 $ 491.65 $ 940.60 $ 146,567.92
139 5/19/2011 $ 146,567.92 $ 488.51 $ 943.74 $ 145,624.18
140 5/20/2011 $ 145,624.18 $ 485.37 $ 946.88 $ 144,677.29
141 5/21/2011 $ 144,677.29 $ 482.21 $ 950.04 $ 143,727.25
142 5/22/2011 $ 143,727.25 $ 479.04 $ 953.21 $ 142,774.05
143 5/23/2011 $ 142,774.05 $ 475.87 $ 956.38 $ 141,817.66
144 5/24/2011 $ 141,817.66 $ 472.68 $ 959.57 $ 140,858.09
145 5/25/2011 $ 140,858.09 $ 469.48 $ 962.77 $ 139,895.32
146 5/26/2011 $ 139,895.32 $ 466.27 $ 965.98 $ 138,929.34
147 5/27/2011 $ 138,929.34 $ 463.05 $ 969.20 $ 137,960.14
148 5/28/2011 $ 137,960.14 $ 459.82 $ 972.43 $ 136,987.71
149 5/29/2011 $ 136,987.71 $ 456.58 $ 975.67 $ 136,012.04
150 5/30/2011 $ 136,012.04 $ 453.33 $ 978.92 $ 135,033.12
151 5/31/2011 $ 135,033.12 $ 450.07 $ 982.18 $ 134,050.94
152 6/1/2011 $ 134,050.94 $ 446.79 $ 985.46 $ 133,065.48
153 6/2/2011 $ 133,065.48 $ 443.51 $ 988.74 $ 132,076.74
154 6/3/2011 $ 132,076.74 $ 440.21 $ 992.04 $ 131,084.70
155 6/4/2011 $ 131,084.70 $ 436.91 $ 995.34 $ 130,089.35
156 6/5/2011 $ 130,089.35 $ 433.59 $ 998.66 $ 129,090.69
157 6/6/2011 $ 129,090.69 $ 430.26 $ 1,001.99 $ 128,088.70
158 6/7/2011 $ 128,088.70 $ 426.92 $ 1,005.33 $ 127,083.37
159 6/8/2011 $ 127,083.37 $ 423.57 $ 1,008.68 $ 126,074.69
160 6/9/2011 $ 126,074.69 $ 420.21 $ 1,012.04 $ 125,062.65
161 6/10/2011 $ 125,062.65 $ 416.83 $ 1,015.42 $ 124,047.23
162 6/11/2011 $ 124,047.23 $ 413.45 $ 1,018.80 $ 123,028.43
163 6/12/2011 $ 123,028.43 $ 410.05 $ 1,022.20 $ 122,006.23
164 6/13/2011 $ 122,006.23 $ 406.65 $ 1,025.60 $ 120,980.63
165 6/14/2011 $ 120,980.63 $ 403.23 $ 1,029.02 $ 119,951.61
166 6/15/2011 $ 119,951.61 $ 399.80 $ 1,032.45 $ 118,919.16
167 6/16/2011 $ 118,919.16 $ 396.36 $ 1,035.89 $ 117,883.26
168 6/17/2011 $ 117,883.26 $ 392.90 $ 1,039.35 $ 116,843.92
169 6/18/2011 $ 116,843.92 $ 389.44 $ 1,042.81 $ 115,801.11
170 6/19/2011 $ 115,801.11 $ 385.97 $ 1,046.28 $ 114,754.82
171 6/20/2011 $ 114,754.82 $ 382.48 $ 1,049.77 $ 113,705.05
172 6/21/2011 $ 113,705.05 $ 378.98 $ 1,053.27 $ 112,651.78
173 6/22/2011 $ 112,651.78 $ 375.47 $ 1,056.78 $ 111,595.00
174 6/23/2011 $ 111,595.00 $ 371.95 $ 1,060.30 $ 110,534.70
175 6/24/2011 $ 110,534.70 $ 368.41 $ 1,063.84 $ 109,470.86
176 6/25/2011 $ 109,470.86 $ 364.87 $ 1,067.38 $ 108,403.47
177 6/26/2011 $ 108,403.47 $ 361.31 $ 1,070.94 $ 107,332.53
178 6/27/2011 $ 107,332.53 $ 357.74 $ 1,074.51 $ 106,258.02
179 6/28/2011 $ 106,258.02 $ 354.16 $ 1,078.09 $ 105,179.93
180 6/29/2011 $ 105,179.93 $ 350.56 $ 1,081.69 $ 104,098.25
181 6/30/2011 $ 104,098.25 $ 346.96 $ 1,085.29 $ 103,012.95
182 7/1/2011 $ 103,012.95 $ 343.34 $ 1,088.91 $ 101,924.05
183 7/2/2011 $ 101,924.05 $ 339.71 $ 1,092.54 $ 100,831.51
184 7/3/2011 $ 100,831.51 $ 336.07 $ 1,096.18 $ 99,735.33
185 7/4/2011 $ 99,735.33 $ 332.42 $ 1,099.83 $ 98,635.50
186 7/5/2011 $ 98,635.50 $ 328.75 $ 1,103.50 $ 97,532.00
187 7/6/2011 $ 97,532.00 $ 325.07 $ 1,107.18 $ 96,424.83
188 7/7/2011 $ 96,424.83 $ 321.38 $ 1,110.87 $ 95,313.96
189 7/8/2011 $ 95,313.96 $ 317.68 $ 1,114.57 $ 94,199.39
190 7/9/2011 $ 94,199.39 $ 313.97 $ 1,118.28 $ 93,081.11
191 7/10/2011 $ 93,081.11 $ 310.24 $ 1,122.01 $ 91,959.10
192 7/11/2011 $ 91,959.10 $ 306.50 $ 1,125.75 $ 90,833.35
193 7/12/2011 $ 90,833.35 $ 302.75 $ 1,129.50 $ 89,703.84
194 7/13/2011 $ 89,703.84 $ 298.98 $ 1,133.27 $ 88,570.58
195 7/14/2011 $ 88,570.58 $ 295.21 $ 1,137.04 $ 87,433.53
196 7/15/2011 $ 87,433.53 $ 291.42 $ 1,140.83 $ 86,292.70
197 7/16/2011 $ 86,292.70 $ 287.61 $ 1,144.64 $ 85,148.06
198 7/17/2011 $ 85,148.06 $ 283.80 $ 1,148.45 $ 83,999.61
199 7/18/2011 $ 83,999.61 $ 279.97 $ 1,152.28 $ 82,847.33
200 7/19/2011 $ 82,847.33 $ 276.13 $ 1,156.12 $ 81,691.21
201 7/20/2011 $ 81,691.21 $ 272.28 $ 1,159.97 $ 80,531.24
202 7/21/2011 $ 80,531.24 $ 268.41 $ 1,163.84 $ 79,367.40
203 7/22/2011 $ 79,367.40 $ 264.53 $ 1,167.72 $ 78,199.68
204 7/23/2011 $ 78,199.68 $ 260.64 $ 1,171.61 $ 77,028.07
205 7/24/2011 $ 77,028.07 $ 256.73 $ 1,175.52 $ 75,852.55
206 7/25/2011 $ 75,852.55 $ 252.82 $ 1,179.43 $ 74,673.12
207 7/26/2011 $ 74,673.12 $ 248.89 $ 1,183.36 $ 73,489.76
208 7/27/2011 $ 73,489.76 $ 244.94 $ 1,187.31 $ 72,302.45
209 7/28/2011 $ 72,302.45 $ 240.98 $ 1,191.27 $ 71,111.18
210 7/29/2011 $ 71,111.18 $ 237.01 $ 1,195.24 $ 69,915.95
211 7/30/2011 $ 69,915.95 $ 233.03 $ 1,199.22 $ 68,716.73
212 7/31/2011 $ 68,716.73 $ 229.03 $ 1,203.22 $ 67,513.51
213 8/1/2011 $ 67,513.51 $ 225.02 $ 1,207.23 $ 66,306.28
214 8/2/2011 $ 66,306.28 $ 221.00 $ 1,211.25 $ 65,095.03
215 8/3/2011 $ 65,095.03 $ 216.96 $ 1,215.29 $ 63,879.74
216 8/4/2011 $ 63,879.74 $ 212.91 $ 1,219.34 $ 62,660.40
217 8/5/2011 $ 62,660.40 $ 208.85 $ 1,223.40 $ 61,437.00
218 8/6/2011 $ 61,437.00 $ 204.77 $ 1,227.48 $ 60,209.52
219 8/7/2011 $ 60,209.52 $ 200.68 $ 1,231.57 $ 58,977.95
220 8/8/2011 $ 58,977.95 $ 196.57 $ 1,235.68 $ 57,742.27
221 8/9/2011 $ 57,742.27 $ 192.45 $ 1,239.80 $ 56,502.48
222 8/10/2011 $ 56,502.48 $ 188.32 $ 1,243.93 $ 55,258.55
223 8/11/2011 $ 55,258.55 $ 184.18 $ 1,248.07 $ 54,010.48
224 8/12/2011 $ 54,010.48 $ 180.02 $ 1,252.23 $ 52,758.24
225 8/13/2011 $ 52,758.24 $ 175.84 $ 1,256.41 $ 51,501.84
226 8/14/2011 $ 51,501.84 $ 171.66 $ 1,260.59 $ 50,241.24
227 8/15/2011 $ 50,241.24 $ 167.45 $ 1,264.80 $ 48,976.45
228 8/16/2011 $ 48,976.45 $ 163.24 $ 1,269.01 $ 47,707.43
229 8/17/2011 $ 47,707.43 $ 159.01 $ 1,273.24 $ 46,434.19
230 8/18/2011 $ 46,434.19 $ 154.77 $ 1,277.48 $ 45,156.71
231 8/19/2011 $ 45,156.71 $ 150.51 $ 1,281.74 $ 43,874.97
232 8/20/2011 $ 43,874.97 $ 146.24 $ 1,286.01 $ 42,588.95
233 8/21/2011 $ 42,588.95 $ 141.95 $ 1,290.30 $ 41,298.65
234 8/22/2011 $ 41,298.65 $ 137.65 $ 1,294.60 $ 40,004.05
235 8/23/2011 $ 40,004.05 $ 133.33 $ 1,298.92 $ 38,705.13
236 8/24/2011 $ 38,705.13 $ 129.00 $ 1,303.25 $ 37,401.89
237 8/25/2011 $ 37,401.89 $ 124.66 $ 1,307.59 $ 36,094.30
238 8/26/2011 $ 36,094.30 $ 120.30 $ 1,311.95 $ 34,782.35
239 8/27/2011 $ 34,782.35 $ 115.93 $ 1,316.32 $ 33,466.03
240 8/28/2011 $ 33,466.03 $ 111.54 $ 1,320.71 $ 32,145.32
241 8/29/2011 $ 32,145.32 $ 107.14 $ 1,325.11 $ 30,820.21
242 8/30/2011 $ 30,820.21 $ 102.72 $ 1,329.53 $ 29,490.68
243 8/31/2011 $ 29,490.68 $ 98.29 $ 1,333.96 $ 28,156.73
244 9/1/2011 $ 28,156.73 $ 93.85 $ 1,338.40 $ 26,818.32
245 9/2/2011 $ 26,818.32 $ 89.39 $ 1,342.86 $ 25,475.46
246 9/3/2011 $ 25,475.46 $ 84.91 $ 1,347.34 $ 24,128.12
247 9/4/2011 $ 24,128.12 $ 80.42 $ 1,351.83 $ 22,776.29
248 9/5/2011 $ 22,776.29 $ 75.91 $ 1,356.34 $ 21,419.95
249 9/6/2011 $ 21,419.95 $ 71.39 $ 1,360.86 $ 20,059.09
250 9/7/2011 $ 20,059.09 $ 66.86 $ 1,365.39 $ 18,693.70
251 9/8/2011 $ 18,693.70 $ 62.31 $ 1,369.94 $ 17,323.76
252 9/9/2011 $ 17,323.76 $ 57.74 $ 1,374.51 $ 15,949.25
253 9/10/2011 $ 15,949.25 $ 53.16 $ 1,379.09 $ 14,570.16
254 9/11/2011 $ 14,570.16 $ 48.56 $ 1,383.69 $ 13,186.47
255 9/12/2011 $ 13,186.47 $ 43.95 $ 1,388.30 $ 11,798.17
256 9/13/2011 $ 11,798.17 $ 39.32 $ 1,392.93 $ 10,405.24
257 9/14/2011 $ 10,405.24 $ 34.68 $ 1,397.57 $ 9,007.67
258 9/15/2011 $ 9,007.67 $ 30.02 $ 1,402.23 $ 7,605.44
259 9/16/2011 $ 7,605.44 $ 25.35 $ 1,406.90 $ 6,198.54
260 9/17/2011 $ 6,198.54 $ 20.66 $ 1,411.59 $ 4,786.95
261 9/18/2011 $ 4,786.95 $ 15.95 $ 1,416.30 $ 3,370.66
262 9/19/2011 $ 3,370.66 $ 11.23 $ 1,421.02 $ 1,949.64
263 9/20/2011 $ 1,949.64 $ 6.50 $ 1,425.75 $ 523.89
264 9/21/2011 $ 523.89 $ 1.75 $ 522.14 $ -
265 9/22/2011 $ - $ - $ - $ -
266 9/23/2011 $ - $ - $ - $ -
267 9/24/2011 $ - $ - $ - $ -
268 9/25/2011 $ - $ - $ - $ -
269 9/26/2011 $ - $ - $ - $ -
270 9/27/2011 $ - $ - $ - $ -
271 9/28/2011 $ - $ - $ - $ -
272 9/29/2011 $ - $ - $ - $ -
273 9/30/2011 $ - $ - $ - $ -
274 10/1/2011 $ - $ - $ - $ -
275 10/2/2011 $ - $ - $ - $ -
276 10/3/2011 $ - $ - $ - $ -
277 10/4/2011 $ - $ - $ - $ -
278 10/5/2011 $ - $ - $ - $ -
279 10/6/2011 $ - $ - $ - $ -
280 10/7/2011 $ - $ - $ - $ -
281 10/8/2011 $ - $ - $ - $ -
282 10/9/2011 $ - $ - $ - $ -
283 10/10/2011 $ - $ - $ - $ -
284 10/11/2011 $ - $ - $ - $ -
285 10/12/2011 $ - $ - $ - $ -
286 10/13/2011 $ - $ - $ - $ -
287 10/14/2011 $ - $ - $ - $ -
288 10/15/2011 $ - $ - $ - $ -
289 10/16/2011 $ - $ - $ - $ -
290 10/17/2011 $ - $ - $ - $ -
291 10/18/2011 $ - $ - $ - $ -
292 10/19/2011 $ - $ - $ - $ -
293 10/20/2011 $ - $ - $ - $ -
294 10/21/2011 $ - $ - $ - $ -
295 10/22/2011 $ - $ - $ - $ -
296 10/23/2011 $ - $ - $ - $ -
297 10/24/2011 $ - $ - $ - $ -
298 10/25/2011 $ - $ - $ - $ -
299 10/26/2011 $ - $ - $ - $ -
300 10/27/2011 $ - $ - $ - $ -
301 10/28/2011 $ - $ - $ - $ -
302 10/29/2011 $ - $ - $ - $ -
303 10/30/2011 $ - $ - $ - $ -
304 10/31/2011 $ - $ - $ - $ -
305 11/1/2011 $ - $ - $ - $ -
306 11/2/2011 $ - $ - $ - $ -
307 11/3/2011 $ - $ - $ - $ -
308 11/4/2011 $ - $ - $ - $ -
309 11/5/2011 $ - $ - $ - $ -
310 11/6/2011 $ - $ - $ - $ -
311 11/7/2011 $ - $ - $ - $ -
312 11/8/2011 $ - $ - $ - $ -
313 11/9/2011 $ - $ - $ - $ -
314 11/10/2011 $ - $ - $ - $ -
315 11/11/2011 $ - $ - $ - $ -
316 11/12/2011 $ - $ - $ - $ -
317 11/13/2011 $ - $ - $ - $ -
318 11/14/2011 $ - $ - $ - $ -
319 11/15/2011 $ - $ - $ - $ -
320 11/16/2011 $ - $ - $ - $ -
321 11/17/2011 $ - $ - $ - $ -
322 11/18/2011 $ - $ - $ - $ -
323 11/19/2011 $ - $ - $ - $ -
324 11/20/2011 $ - $ - $ - $ -
325 11/21/2011 $ - $ - $ - $ -
326 11/22/2011 $ - $ - $ - $ -
327 11/23/2011 $ - $ - $ - $ -
328 11/24/2011 $ - $ - $ - $ -
329 11/25/2011 $ - $ - $ - $ -
330 11/26/2011 $ - $ - $ - $ -
331 11/27/2011 $ - $ - $ - $ -
332 11/28/2011 $ - $ - $ - $ -
333 11/29/2011 $ - $ - $ - $ -
334 11/30/2011 $ - $ - $ - $ -
335 12/1/2011 $ - $ - $ - $ -
336 12/2/2011 $ - $ - $ - $ -
337 12/3/2011 $ - $ - $ - $ -
338 12/4/2011 $ - $ - $ - $ -
339 12/5/2011 $ - $ - $ - $ -
340 12/6/2011 $ - $ - $ - $ -
341 12/7/2011 $ - $ - $ - $ -
342 12/8/2011 $ - $ - $ - $ -
343 12/9/2011 $ - $ - $ - $ -
344 12/10/2011 $ - $ - $ - $ -
345 12/11/2011 $ - $ - $ - $ -
346 12/12/2011 $ - $ - $ - $ -
347 12/13/2011 $ - $ - $ - $ -
348 12/14/2011 $ - $ - $ - $ -
349 12/15/2011 $ - $ - $ - $ -
350 12/16/2011 $ - $ - $ - $ -
351 12/17/2011 $ - $ - $ - $ -
352 12/18/2011 $ - $ - $ - $ -
353 12/19/2011 $ - $ - $ - $ -
354 12/20/2011 $ - $ - $ - $ -
355 12/21/2011 $ - $ - $ - $ -
356 12/22/2011 $ - $ - $ - $ -
357 12/23/2011 $ - $ - $ - $ -
358 12/24/2011 $ - $ - $ - $ -
359 12/25/2011 $ - $ - $ - $ -
360 12/26/2011 $ - $ - $ - $ -
361 12/27/2011 $ - $ - $ - $ -
Principal $0
Interest rate 10%
Years 20
Payment/Year 12
Monthyly Payment 100
Future Value $75,936.88

Final Amount Rs 1,000,000.00
Interest 10%
Years 25
Monthly Payment 500
Present Value ($27,458)

5 10 15 20 25 Years
3% ($860,869.11) ($741,095.62) ($637,986.32) ($549,222.71) ($472,808.87)
4% ($819,003.10) ($670,766.08) ($549,359.50) ($449,927.14) ($368,491.72)
5% ($779,205.39) ($607,161.04) ($473,103.16) ($368,644.53) ($287,249.80)
6% ($741,372.20) ($549,632.73) ($407,482.43) ($302,096.14) ($223,965.68)
7% ($705,405.04) ($497,596.27) ($351,006.91) ($247,602.05) ($174,659.73)
8% ($671,210.44) ($450,523.46) ($302,396.05) ($202,971.39) ($136,236.52)
9% ($638,699.70) ($407,937.30) ($260,549.43) ($166,412.84) ($106,287.83)
10% ($607,788.59) ($369,406.97) ($224,521.34) ($136,461.51) ($82,939.75)
Interest
Principal Rs 10,000.00
Interest 10% CUMPMIT CUMPRINC
Loan term 5 -2748.227 -10000
Payments 60
Payment Total (PMT) Interest (IPMT) Principal (PPMT)

1 ($212.47) ($83.33) ($129.14)
2 ($212.47) ($82.26) ($130.21)
3 ($212.47) ($81.17) ($131.30)
4 ($212.47) ($80.08) ($132.39)
5 ($212.47) ($78.97) ($133.50)
6 ($212.47) ($77.86) ($134.61)
7 ($212.47) ($76.74) ($135.73)
8 ($212.47) ($75.61) ($136.86)
9 ($212.47) ($74.47) ($138.00)
10 ($212.47) ($73.32) ($139.15)
11 ($212.47) ($72.16) ($140.31)
12 ($212.47) ($70.99) ($141.48)
13 ($212.47) ($69.81) ($142.66)
14 ($212.47) ($68.62) ($143.85)
15 ($212.47) ($67.42) ($145.05)
16 ($212.47) ($66.21) ($146.26)
17 ($212.47) ($65.00) ($147.47)
18 ($212.47) ($63.77) ($148.70)
19 ($212.47) ($62.53) ($149.94)
20 ($212.47) ($61.28) ($151.19)
21 ($212.47) ($60.02) ($152.45)
22 ($212.47) ($58.75) ($153.72)
23 ($212.47) ($57.47) ($155.00)
24 ($212.47) ($56.18) ($156.30)
25 ($212.47) ($54.87) ($157.60)
26 ($212.47) ($53.56) ($158.91)
27 ($212.47) ($52.24) ($160.24)
28 ($212.47) ($50.90) ($161.57)
29 ($212.47) ($49.55) ($162.92)
30 ($212.47) ($48.20) ($164.27)
31 ($212.47) ($46.83) ($165.64)
32 ($212.47) ($45.45) ($167.02)
33 ($212.47) ($44.05) ($168.42)
34 ($212.47) ($42.65) ($169.82)
35 ($212.47) ($41.24) ($171.23)
36 ($212.47) ($39.81) ($172.66)
37 ($212.47) ($38.37) ($174.10)
38 ($212.47) ($36.92) ($175.55)
39 ($212.47) ($35.46) ($177.01)
40 ($212.47) ($33.98) ($178.49)
41 ($212.47) ($32.49) ($179.98)
42 ($212.47) ($30.99) ($181.48)
43 ($212.47) ($29.48) ($182.99)
44 ($212.47) ($27.96) ($184.51)
45 ($212.47) ($26.42) ($186.05)
46 ($212.47) ($24.87) ($187.60)
47 ($212.47) ($23.31) ($189.17)
48 ($212.47) ($21.73) ($190.74)
49 ($212.47) ($20.14) ($192.33)
50 ($212.47) ($18.54) ($193.93)
51 ($212.47) ($16.92) ($195.55)
52 ($212.47) ($15.29) ($197.18)
53 ($212.47) ($13.65) ($198.82)
54 ($212.47) ($11.99) ($200.48)
55 ($212.47) ($10.32) ($202.15)
56 ($212.47) ($8.64) ($203.83)
57 ($212.47) ($6.94) ($205.53)
58 ($212.47) ($5.22) ($207.25)
59 ($212.47) ($3.50) ($208.97)
60 ($212.47) ($1.76) ($210.71)
($12,748.23) ($2,748.23) ($10,000.00)
Payment Rs 10.00
Rate 18.00%
Initial balance 0
Final Target Rs 8,000.00
Total months 172.27591614
14.333333333
Start Balance Rs 10,000.00
Monthly Payment Rs 150.00
Final Balance Rs 20,000.00
Time/Duration 4
Rate 4.75%
Duration 5
Initial Balance 2000
Final Balance 7433
RRI 30%
Big Fashion Group Sales Dashboard
This shape represents a slicer.
Slicers are supported in Excel
2010 or later.
If the shape was modified in Sales by Chain

an earlier version of Excel, or
if the workbook was saved in Fashions Direct
Excel 2003 or earlier, the 150
slicershape
This cannot be used. a slicer.
represents 100
Slicers are supported in Excel 50
2010 or later. 0
If the shape was modified in

if the workbook was saved in
Excel 2003 or earlier, the
This shape represents a slicer. #REF!
slicer cannot be used.
Slicers are supported in Excel
2010 or later.
If the shape was modified in

if the workbook was saved in
Excel 2003 or earlier, the
slicer cannot be used.
Sales Total and Trend by State

State All Chains Trend Next Look
NSW
SA
WA
Fashion Direct Next Look
Sales by Category
Fashions Direct
#REF!
0 20 40 60 80 100 120 140 16

Fashions
Direct
$140
100%
Sales by Manager
Fashions Direct
0 20 40 60 80 100 120 140 160

100 120 140 160
100 120 140 160

Sum of Sales Column Labels
Row Labels Fashions Direct Next Look Grand Total
2016
Jan 870 870
Dec 8810 8810
2017
Jul 12422 12422
Grand Total 13292 8810 22102
Row Labels Fashions Direct Grand Total
Womens 140 140
Grand Total 140 140
Row Labels Fashions Direct Next Look Grand Total
Jeremy Garcia 870 870
NSW 870 870
Ray Watson 8810 8810
SA 8810 8810
John Harper 12422 12422
WA 12422 12422
Grand Total 13292 8810 22102
Fashions Direct
$13,292
60%
$8,810
40%
Row Labels Sum of Sales Sales %
Fashions Direct 13292 60.14%
Next Look 8810 39.86%
Grand Total 22102 100.00%
Chain (All)

2016 2017
Row Labels Jan Dec Jul
NSW 870
SA 8810
WA 12422
Chain Next Look

2016
Row Labels Dec
NSW
SA 8810
WA
Chain Fashions Direct

2016 2017
Row Labels Jan Jul
NSW 870
SA
WA 12422
Month Financial Year Chain Suburb State Postcode Country
1/1/2016 2015/16 Fashions Direct Chatswood NSW 2067 Australia
12/1/2016 2016/17 Next Look Marion SA 5043 Australia
7/1/2017 2017/18 Fashions Direct Geraldton WA 6530 Australia
Manager Category Buyer Sales
Jeremy Garcia Home Richard Carr 479.02
Jeremy Garcia Juniors Chester George 149.95
Jeremy Garcia Mens Bruce Curran 14
Jeremy Garcia Juniors Chester George 12
Jeremy Garcia Womens Amy Buchanan 46.94
Jeremy Garcia Juniors Chester George -2.99
Jeremy Garcia Kids Elizabeth Gentry 17.6
Jeremy Garcia Accessories Maggie Mayer 44.2
Jeremy Garcia Kids Elizabeth Gentry 5
Jeremy Garcia Womens Amy Buchanan 87.99
Jeremy Garcia Kids Elizabeth Gentry 4
Jeremy Garcia Womens Amy Buchanan 5
Ray Watson Shoes Howard Wright 1117.76
Ray Watson Juniors Chester George 2004.38
Ray Watson Shoes Howard Wright 2527.75
Ray Watson Mens Bruce Curran 3159.75
John Harper Shoes Howard Wright 3137.22
John Harper Kids Elizabeth Gentry 4282.22
John Harper Home Richard Carr 5002.83

Advanced Excel (Maleeha Waheed)

Transféré par

Droits d'auteur :

Formats disponibles

Advanced Excel (Maleeha Waheed)

Transféré par

Informations du document

Copyright

Formats disponibles

Partager ce document

Partager ou intégrer le document

Options de partage

Avez-vous trouvé ce document utile ?

Ce contenu est-il inapproprié ?

Droits d'auteur :

Formats disponibles

Advanced Excel (Maleeha Waheed)

Transféré par

Droits d'auteur :

Formats disponibles

Sales figure for the first quarter

Salesperson Jan Feb March

Future Value $75,936.88

Present Value ($27,458)

Payment Total (PMT) Interest (IPMT) Principal (PPMT)

Total months 172.27591614

If the shape was modified in Sales by Chain

If the shape was modified in

If the shape was modified in

Sales Total and Trend by State

0 20 40 60 80 100 120 140 16

0 20 40 60 80 100 120 140 160

100 120 140 160

Sum of Sales Column Labels

Chain Next Look

Sum of Sales Column Labels

Chain Fashions Direct

Sum of Sales Column Labels

Vous aimerez peut-être aussi