Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For this exercise, compute the inflation adjusted amount of sales tax collections for each month (column D) using this formula: Sales Tax Collections (adjusted for

For this exercise, compute the inflation adjusted amount of sales tax collections for each month (column D) using this formula:
Sales Tax Collections (adjusted for inflation) = CPI now * $ then
CPI then
(If you know how to apply this formula to an Excel spreadsheet, proceed to the dataset and compute the inflation-adjusted sales tax collections for each month.)
The equation in (D4) should look like: =($C$248/C4)*B4, then copy the equation down the column. The $ symbol instructs Excel to use the absolute cell reference (i.e., not to change that reference).
Label the Column REAL DOLLARS

SAVE the worksheet.

I need to upload the data for this problem but I don't know how it is an excel file... can you help me...

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
1 2 SALES TAX COLLECTIONS CONSUMER PRICE INDEX MONTH 3 115.3 4 Oct-93 $2,084,739 5 Nov-93 $1,998,102 6 Dec-93 $4,824,303 7 Jan-94 $1,908,865 8 Feb-94 $2,089,515 9 Mar-94 $3,935,470 10 Apr-94 $2,446,361 11 May-94 $2,229,028 12 Jun-94 $4,176,458 13 Jul-94 $2,564,566 14 Aug-94 $2,618,381 15 Sep-94 $4,405,333 16 Oct-94 $2,353,696 17 Nov-94 $2,383,552 18 Dec-94 $5,194,605 19 Jan-95 $2,248,300 20 Feb-95 $2,028,999 21 Mar-95 $4,263,265 Instructions Data Select destination and press ENTER or choose Paste Type here to search 115.4 115.4 115.7 116 116.5 117.1 117.5 118 118.5 119 119.8 120.2 120.3 120.5 121.1 121.6 122.3 + O RI 011 Alignment 117.5 D E E A B 22 Apr-95 $2,276,123 23 May-95 $2,586,093 24 Jun-95 $4,473,599 25 Jul-95 $2,823,938 26 Aug-95 $2,426,540 27 Sep-95 $4,569,066 28 Oct-95 $2,560,714 29 Nov-95 $2,461,201 30 Dec-95 $5,347,895 31 Jan-96 $2,459,131 32 Feb-96 $2,561,790 33 Mar-96 $4,531,373 34 Apr-96 $2,573,505 May-96 $2,731,364 36 Jun-96 $4,720,815 37 Jul-96 $2,517,316 38 Aug-96 $2,747,416 39 Sep-96 $4,461,696 40 Oct-96 $2,652,219 41 Nov-96 $2,742,380 42 Dec-96 $5,428,077 Instructions Data + Select destination and press ENTER or choose Paste 123.1 123.8 124.1 124.4 124.6 125 125.6 125.9 126.11 127.4 128 128.7 128.9 129.2 129.9 130.4 131.6 132.7 133.5 133.8 133.8 35 Type here to search o RE 1 - - = Clipboard 21 Font 12 Alignment C11 117.5 D 52 A B 43 Jan-97 $2,271,963 44 Feb-97 $2,727,079 45 Mar-97 $4,134,727 46 Apr-97 $2,981,945 47 May-97 $2,714,662 48 Jun-97 $4,352,087 49 Jul-97 $2,661,851 50 Aug-97 $2,684,178 51 Sep-97 $4,262,460 Oct-97 $2,436,702 53 Nov-97 $2,621,585 54 Dec-97 $5,230,374 55 Jan-98 $2,504,325 56 Feb-98 $2,659,121 57 Mar-98 $4,675,595 58 Apr-98 $2,903,401 59 May-98 $2,632,649 60 Jun-98 $4,489,632 61 Jul-98 $3,051,370 62 Aug-98 $2,528,146 63 Sep-98 $4,778,897 Instructions Data Select destination and press ENTER or choose Paste Type here to search 134.6 134.8 135 135.2 135.6 1361 136.2 136.6 137.2: 137.41 137.8 137.9 138.1 138.6 139.3 139.5 139.7 140.2 140.5 140.9 141.3 o C 141.8 A B 64 Oct-98 $2,752,297 65 Nov-98 $2,402,082 66 Dec-98 $5,867,568 67 Jan-99 $2,554,318 68 Feb-99 $2,695,978 69 Mar-99 $5,270,587 70 Apr-99 $2,667,975 71 May-99 $3,038,608 72 Jun-99 $5,492,295 73 Jul-99 $2,852,423 74 Aug-99 $3,028,444 75 Sep-99 $5,647,904 76 Oct-99 $2,729,995 77 Nov-99 $3,051,157 78 Dec-99 $6,380,292 79 Jan-00 $2,896,075 80 Feb-00 $2,925,727 81 Mar-00 $5,613,494 82 Apr-00 $3,034,533 83 May-00 $3,233,590 84 Jun-00 $5,635,848 Instructions Data 142 141.9 142.6 143.1 143.6 144 144.21 144.4 144.4 144.8 145.11 145.7 145.8) 145.8 146.2 146.71 147.2 147.4 147.5 148 + Select destination and press ENTER or choose Paste Type here to search o C11 117.5 D A B 85 Jul-00 $3,460,453 86 Aug-00 $3,420,717 87 Sep-00 $5,797,977 88 Oct-00 $3,406,741 89 Nov-00 $3,236,003 90 Dec-00 $6,612,467 91 Jan-01 $3,075,555 92 Feb-01 $3,097,101 93 Mar-01 $5,963,784 94 Apr-01 $3,090,566 95 May-01 $3,252,747 96 Jun-01 $6,298,776 97 Jul-01 $3,572,851 98 Aug-01 $3,716,442 99 Sep-01 $6,014,843 100 Oct-01 $3,378,795 101 Nov-01 $3,385,977 102 Dec-01 $6,960,712 103 Jan-02 $3,599,462 104 Feb-02 $3,841,966 105 Mar-02 $5,682,910 Instructions Data C 148.4 149 149.4 149.5! 149.7 149.71 150.31 150.9 151.4 151.9 152.21 152.5 152.5 152.9 153.2 153.7: 153.6 153.5 154.4 154.9 155.7 Select destination and press ENTER or choose Paste Type here to search o 106 Apr-02 $4,080,443 107 May-02 $3,428,768 108 Jun-02 $5,623,598 109 Jul-02 $4,311,187 110 Aug-02 $3,666,345 111 Sep-02 $5,945,119 112 Oct-02 $4,187,527 113 Nov-02 $3,643,635 114 Dec-02 $7,312,434 115 Jan-03 $3,728,383 116 Feb-03 $3,586,061 117 Mar-03 $6,078,859 118 Apr-03 $4,394,196 119 May-03 $3,818,563 120 Jun-03 $6,254759 121 Jul-03 $4,526,304 122 Aug-03 $3,984,745 123 Sep-03 $6,317,565 124 Oct-03 $4,120,172 125 Nov-03 $4,040,249 126 Dec-03 $7,829,449 Instructions Data 156.3 156.6 156.71 1571 157.3 157.8 158.3 158.6 158.6 159.11 159.6 160 160.2 160.1 160.3 160.5 160.81 161.2 161.6 161.5 161.3 Select destination and press ENTER or choose Paste E Type here to search o C11 X fic 117.5 B 127 Jan-04 $4,120,065 128 Feb-04 $3,938,427 129 Mar-04 $6,669,579 130 Apr-04 $4,797,830 131 May-04 $4,639,488 132 Jun-04 $7,146,932 133 Jul-04 $4,758,698 134 Aug-04 $4,495,121 135 Sep-04 $7,081,527 136 Oct-04 $4,599,545 137 Nov-04 $4,049,608 138 Dec-04 $8,492,304 139 Jan-05 $4,483,443 140 Feb-05 $4,370,129 141 Mar-05 $7,228,658 142 Apr-05 $4,5-3,275 143 May-05 $4,713,108 144 Jun-05 $7,684,351 145 Jul-05 $4,851,289 146 Aug-05 $4,591,840 147 Sep-05 $7,138,249 Instructions Data Select destination and press ENTER or choose Paste Type here to search C 161.6 161.9 162.2 162.5 162.8 163 163.2 163.4 163.6 164 164 163.9 164.3 164.5 165 166.21 166.2 166.2 166.7 167.1 167.9 o C11 117.5 A B 148 Oct-05 $5,806,170 149 Nov-05 $5,067,675 150 Dec-05 $8,665,979 151 Jan-06 $4,938,264 152 Feb-06 $4,835,197 153 Mar-06 $7,583,398 154 Apr-06 $4,597,792 155 May-06 $5,236,719 156 Jun-06 $7,256,520 157 Jul-06 $5,535,777 158 Aug-06 $5,166,064 159 Sep-06 $7,484,590 160 Oct-06 $5,176,017 161 Nov-06 $4,768,897 162 Dec-06 $8,471,908 163 Jan-07 $5,44,022 164 Feb-07 $5,108,794 165 Mar-07 $7,938,112 166 Apr-07 $5,487,725 167 May-07 $5,492,037 168 Jun-07 $7,550,675 Instructions 168.2 168.3 168.3 168.8 169.8 171.2 171.3 171.5 172.4 172.8 172.8 173.7 174 174.1 174 175.1 175.8) 176.2 176.9 177.7 178 Data Select destination and press ENTER or choose Paste Type here to search o C11 117.5 D 174 A B 169 Jul-07 $5,343,765 170 Aug-07 $5,124,688 171 Sep-07 $7,553,747 172 Oct-07 $5,101,051 173 Nov-07 $5,301,680 Dec-07 $8,734,068 175 Jan-08 $4,951,484 176 Feb-08 $4,851,047 177 Mar-08 $7,605,114 178 Apr-08 $5,609,256 179 May-08 $5,319,727 180 Jun-08 $7,316,825 181 Jul-08 $5,186,212 182 Aug-08 $5,200,134 183 Sep-08 $7,476,404 184 Oct-08 $5,680,534 185 Nov-08 $5,102,666 186 Dec-08 $8,437,654 187 Jan-09 $4,908,461 188 Feb-09 $4,695,674 189 Mar-09 $7,508,526 Instructions Data Select destination and press ENTER or choose Paste Type here to search 177.5: 177.5 178.3 177.71 177.4 176.7 177.1 177.8 178.8! 179.8 179.8 179.9 180.1 180.7 181 181.3 181.3 180.9: 181.7 183.1 184.2 o D A B 190 Apr-09 $5,462,354 191 May-09 $5,314,409 192 Jun-09 $7,465,179 193 Jul-09 $5,422,650 194 Aug-09 $5,309,039 195 Sep-09 $7,763,414 196 Oct-09 $5,382,939 197 Nov-09 $5,101,129 198 Dec-09 $9,004,672 199 Jan-10 $5,041,097 200 Feb-10 $4,783,362 201 Mar-10 $7,678,234 202 Apr-10 $5,709,448 203 May-10 $5,554,502 204 Jun-10 $7,799,978 205 Jul-10 $5,873,844 206 Aug-10 $5,623,609 207 Sep-10 $8,278,942 208 Oct-10 $5,753,712 209 Nov-10 $5,799,628 210 Dec-10 $9,554,181 Instructions 183.8 183.5 183.7 183.9 184.6 185.2 185 184.5 184.3 185.21 186.21 187.4 188 189.1 189.7 189.4 189.5 189.9 190.9 1911 190.3 Data Select destination and press ENTER or choose Paste Type here to search o C11 fx 117.5 C D B 211) Jan-11 $5,678,499 212 Feb-11 $5,292,117 213 Mar-11 $8,361,414 214 Apr-11 $6,214,086 215 May-11 $6,100,562 216 Jun-11 $9,091,612 217 Jul-11 $6,234,894 218 Aug-11 $6,464,899 219 Sep-11 $8,536,692 220 Oct-11 $6,426,177 221 Nov-11 $7,288,497 222 Dec-11 $10,649,306 223 Jan-12 $6,560,170 224 Feb-12 $6,302,897 225 Mar-12 $9,379,679 226 Apr-12 227 May-12 $7,065,689 228 Jun-12 $8,656,821 229 Jul-12 $6,040,327 230 Aug-12 $7,086,800 231 Sep-12 $9,525,313 Instructions Data Select destination and press ENTER or choose Paste Type here to search 190.7 191.8 193.3 194.6 194.4 194.5) 195.4 196.4 198.8 199.21 197.6 196.8 198.3 $7,069,247 198.7 199.8 201.5 202.5 202.9 203.5 203.9 202.9 O C11 117.5 D 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 A Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13 Jan-14 Feb-14 B $7,114,879 $7,238,152 $11,193,635 $6,782,352 $6,963,010 $9,846,218 $7,515,351 $7,223,830 $9,751,666 $7,613,600 $7,816,825 $9,187,563 $7,731,338 $7,790,423 $11,624,365 $7,548,736 $7,209,726 201.8 201.5 201.8 202.416 203.499 205.352 206.686 207.949 208.352 208.299 207.917 208.49 208.936 210.177 210 211.08 211.693 Instructions Data Select destination and press ENTER or choose Paste Type here to search 1 2 SALES TAX COLLECTIONS CONSUMER PRICE INDEX MONTH 3 115.3 4 Oct-93 $2,084,739 5 Nov-93 $1,998,102 6 Dec-93 $4,824,303 7 Jan-94 $1,908,865 8 Feb-94 $2,089,515 9 Mar-94 $3,935,470 10 Apr-94 $2,446,361 11 May-94 $2,229,028 12 Jun-94 $4,176,458 13 Jul-94 $2,564,566 14 Aug-94 $2,618,381 15 Sep-94 $4,405,333 16 Oct-94 $2,353,696 17 Nov-94 $2,383,552 18 Dec-94 $5,194,605 19 Jan-95 $2,248,300 20 Feb-95 $2,028,999 21 Mar-95 $4,263,265 Instructions Data Select destination and press ENTER or choose Paste Type here to search 115.4 115.4 115.7 116 116.5 117.1 117.5 118 118.5 119 119.8 120.2 120.3 120.5 121.1 121.6 122.3 + O RI 011 Alignment 117.5 D E E A B 22 Apr-95 $2,276,123 23 May-95 $2,586,093 24 Jun-95 $4,473,599 25 Jul-95 $2,823,938 26 Aug-95 $2,426,540 27 Sep-95 $4,569,066 28 Oct-95 $2,560,714 29 Nov-95 $2,461,201 30 Dec-95 $5,347,895 31 Jan-96 $2,459,131 32 Feb-96 $2,561,790 33 Mar-96 $4,531,373 34 Apr-96 $2,573,505 May-96 $2,731,364 36 Jun-96 $4,720,815 37 Jul-96 $2,517,316 38 Aug-96 $2,747,416 39 Sep-96 $4,461,696 40 Oct-96 $2,652,219 41 Nov-96 $2,742,380 42 Dec-96 $5,428,077 Instructions Data + Select destination and press ENTER or choose Paste 123.1 123.8 124.1 124.4 124.6 125 125.6 125.9 126.11 127.4 128 128.7 128.9 129.2 129.9 130.4 131.6 132.7 133.5 133.8 133.8 35 Type here to search o RE 1 - - = Clipboard 21 Font 12 Alignment C11 117.5 D 52 A B 43 Jan-97 $2,271,963 44 Feb-97 $2,727,079 45 Mar-97 $4,134,727 46 Apr-97 $2,981,945 47 May-97 $2,714,662 48 Jun-97 $4,352,087 49 Jul-97 $2,661,851 50 Aug-97 $2,684,178 51 Sep-97 $4,262,460 Oct-97 $2,436,702 53 Nov-97 $2,621,585 54 Dec-97 $5,230,374 55 Jan-98 $2,504,325 56 Feb-98 $2,659,121 57 Mar-98 $4,675,595 58 Apr-98 $2,903,401 59 May-98 $2,632,649 60 Jun-98 $4,489,632 61 Jul-98 $3,051,370 62 Aug-98 $2,528,146 63 Sep-98 $4,778,897 Instructions Data Select destination and press ENTER or choose Paste Type here to search 134.6 134.8 135 135.2 135.6 1361 136.2 136.6 137.2: 137.41 137.8 137.9 138.1 138.6 139.3 139.5 139.7 140.2 140.5 140.9 141.3 o C 141.8 A B 64 Oct-98 $2,752,297 65 Nov-98 $2,402,082 66 Dec-98 $5,867,568 67 Jan-99 $2,554,318 68 Feb-99 $2,695,978 69 Mar-99 $5,270,587 70 Apr-99 $2,667,975 71 May-99 $3,038,608 72 Jun-99 $5,492,295 73 Jul-99 $2,852,423 74 Aug-99 $3,028,444 75 Sep-99 $5,647,904 76 Oct-99 $2,729,995 77 Nov-99 $3,051,157 78 Dec-99 $6,380,292 79 Jan-00 $2,896,075 80 Feb-00 $2,925,727 81 Mar-00 $5,613,494 82 Apr-00 $3,034,533 83 May-00 $3,233,590 84 Jun-00 $5,635,848 Instructions Data 142 141.9 142.6 143.1 143.6 144 144.21 144.4 144.4 144.8 145.11 145.7 145.8) 145.8 146.2 146.71 147.2 147.4 147.5 148 + Select destination and press ENTER or choose Paste Type here to search o C11 117.5 D A B 85 Jul-00 $3,460,453 86 Aug-00 $3,420,717 87 Sep-00 $5,797,977 88 Oct-00 $3,406,741 89 Nov-00 $3,236,003 90 Dec-00 $6,612,467 91 Jan-01 $3,075,555 92 Feb-01 $3,097,101 93 Mar-01 $5,963,784 94 Apr-01 $3,090,566 95 May-01 $3,252,747 96 Jun-01 $6,298,776 97 Jul-01 $3,572,851 98 Aug-01 $3,716,442 99 Sep-01 $6,014,843 100 Oct-01 $3,378,795 101 Nov-01 $3,385,977 102 Dec-01 $6,960,712 103 Jan-02 $3,599,462 104 Feb-02 $3,841,966 105 Mar-02 $5,682,910 Instructions Data C 148.4 149 149.4 149.5! 149.7 149.71 150.31 150.9 151.4 151.9 152.21 152.5 152.5 152.9 153.2 153.7: 153.6 153.5 154.4 154.9 155.7 Select destination and press ENTER or choose Paste Type here to search o 106 Apr-02 $4,080,443 107 May-02 $3,428,768 108 Jun-02 $5,623,598 109 Jul-02 $4,311,187 110 Aug-02 $3,666,345 111 Sep-02 $5,945,119 112 Oct-02 $4,187,527 113 Nov-02 $3,643,635 114 Dec-02 $7,312,434 115 Jan-03 $3,728,383 116 Feb-03 $3,586,061 117 Mar-03 $6,078,859 118 Apr-03 $4,394,196 119 May-03 $3,818,563 120 Jun-03 $6,254759 121 Jul-03 $4,526,304 122 Aug-03 $3,984,745 123 Sep-03 $6,317,565 124 Oct-03 $4,120,172 125 Nov-03 $4,040,249 126 Dec-03 $7,829,449 Instructions Data 156.3 156.6 156.71 1571 157.3 157.8 158.3 158.6 158.6 159.11 159.6 160 160.2 160.1 160.3 160.5 160.81 161.2 161.6 161.5 161.3 Select destination and press ENTER or choose Paste E Type here to search o C11 X fic 117.5 B 127 Jan-04 $4,120,065 128 Feb-04 $3,938,427 129 Mar-04 $6,669,579 130 Apr-04 $4,797,830 131 May-04 $4,639,488 132 Jun-04 $7,146,932 133 Jul-04 $4,758,698 134 Aug-04 $4,495,121 135 Sep-04 $7,081,527 136 Oct-04 $4,599,545 137 Nov-04 $4,049,608 138 Dec-04 $8,492,304 139 Jan-05 $4,483,443 140 Feb-05 $4,370,129 141 Mar-05 $7,228,658 142 Apr-05 $4,5-3,275 143 May-05 $4,713,108 144 Jun-05 $7,684,351 145 Jul-05 $4,851,289 146 Aug-05 $4,591,840 147 Sep-05 $7,138,249 Instructions Data Select destination and press ENTER or choose Paste Type here to search C 161.6 161.9 162.2 162.5 162.8 163 163.2 163.4 163.6 164 164 163.9 164.3 164.5 165 166.21 166.2 166.2 166.7 167.1 167.9 o C11 117.5 A B 148 Oct-05 $5,806,170 149 Nov-05 $5,067,675 150 Dec-05 $8,665,979 151 Jan-06 $4,938,264 152 Feb-06 $4,835,197 153 Mar-06 $7,583,398 154 Apr-06 $4,597,792 155 May-06 $5,236,719 156 Jun-06 $7,256,520 157 Jul-06 $5,535,777 158 Aug-06 $5,166,064 159 Sep-06 $7,484,590 160 Oct-06 $5,176,017 161 Nov-06 $4,768,897 162 Dec-06 $8,471,908 163 Jan-07 $5,44,022 164 Feb-07 $5,108,794 165 Mar-07 $7,938,112 166 Apr-07 $5,487,725 167 May-07 $5,492,037 168 Jun-07 $7,550,675 Instructions 168.2 168.3 168.3 168.8 169.8 171.2 171.3 171.5 172.4 172.8 172.8 173.7 174 174.1 174 175.1 175.8) 176.2 176.9 177.7 178 Data Select destination and press ENTER or choose Paste Type here to search o C11 117.5 D 174 A B 169 Jul-07 $5,343,765 170 Aug-07 $5,124,688 171 Sep-07 $7,553,747 172 Oct-07 $5,101,051 173 Nov-07 $5,301,680 Dec-07 $8,734,068 175 Jan-08 $4,951,484 176 Feb-08 $4,851,047 177 Mar-08 $7,605,114 178 Apr-08 $5,609,256 179 May-08 $5,319,727 180 Jun-08 $7,316,825 181 Jul-08 $5,186,212 182 Aug-08 $5,200,134 183 Sep-08 $7,476,404 184 Oct-08 $5,680,534 185 Nov-08 $5,102,666 186 Dec-08 $8,437,654 187 Jan-09 $4,908,461 188 Feb-09 $4,695,674 189 Mar-09 $7,508,526 Instructions Data Select destination and press ENTER or choose Paste Type here to search 177.5: 177.5 178.3 177.71 177.4 176.7 177.1 177.8 178.8! 179.8 179.8 179.9 180.1 180.7 181 181.3 181.3 180.9: 181.7 183.1 184.2 o D A B 190 Apr-09 $5,462,354 191 May-09 $5,314,409 192 Jun-09 $7,465,179 193 Jul-09 $5,422,650 194 Aug-09 $5,309,039 195 Sep-09 $7,763,414 196 Oct-09 $5,382,939 197 Nov-09 $5,101,129 198 Dec-09 $9,004,672 199 Jan-10 $5,041,097 200 Feb-10 $4,783,362 201 Mar-10 $7,678,234 202 Apr-10 $5,709,448 203 May-10 $5,554,502 204 Jun-10 $7,799,978 205 Jul-10 $5,873,844 206 Aug-10 $5,623,609 207 Sep-10 $8,278,942 208 Oct-10 $5,753,712 209 Nov-10 $5,799,628 210 Dec-10 $9,554,181 Instructions 183.8 183.5 183.7 183.9 184.6 185.2 185 184.5 184.3 185.21 186.21 187.4 188 189.1 189.7 189.4 189.5 189.9 190.9 1911 190.3 Data Select destination and press ENTER or choose Paste Type here to search o C11 fx 117.5 C D B 211) Jan-11 $5,678,499 212 Feb-11 $5,292,117 213 Mar-11 $8,361,414 214 Apr-11 $6,214,086 215 May-11 $6,100,562 216 Jun-11 $9,091,612 217 Jul-11 $6,234,894 218 Aug-11 $6,464,899 219 Sep-11 $8,536,692 220 Oct-11 $6,426,177 221 Nov-11 $7,288,497 222 Dec-11 $10,649,306 223 Jan-12 $6,560,170 224 Feb-12 $6,302,897 225 Mar-12 $9,379,679 226 Apr-12 227 May-12 $7,065,689 228 Jun-12 $8,656,821 229 Jul-12 $6,040,327 230 Aug-12 $7,086,800 231 Sep-12 $9,525,313 Instructions Data Select destination and press ENTER or choose Paste Type here to search 190.7 191.8 193.3 194.6 194.4 194.5) 195.4 196.4 198.8 199.21 197.6 196.8 198.3 $7,069,247 198.7 199.8 201.5 202.5 202.9 203.5 203.9 202.9 O C11 117.5 D 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 A Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13 Jan-14 Feb-14 B $7,114,879 $7,238,152 $11,193,635 $6,782,352 $6,963,010 $9,846,218 $7,515,351 $7,223,830 $9,751,666 $7,613,600 $7,816,825 $9,187,563 $7,731,338 $7,790,423 $11,624,365 $7,548,736 $7,209,726 201.8 201.5 201.8 202.416 203.499 205.352 206.686 207.949 208.352 208.299 207.917 208.49 208.936 210.177 210 211.08 211.693 Instructions Data Select destination and press ENTER or choose Paste Type here to search

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Planning & Analysis And Performance Management

Authors: Jack Alexander

1st Edition

1119491487, 9781119491484

More Books

Students also viewed these Finance questions

Question

=+a. Write two different, but related, headlines.

Answered: 1 week ago