Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prepare a prediction for sales tax collections for the next three months (March, April and May 2008). Discuss the rationale used for each prediction. Hint:

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

  1. Prepare a prediction for sales tax collections for the next three months (March, April and May 2008). Discuss the rationale used for each prediction.

Hint: Evaluate the data and decide on a percentage increase or decrease that you feel is a defensible assumption. Increase actual revenue (column B) by that percentage. Remember than increases compound.

A G H I MA B C D Sale Tax Consumer Read Dollar Collects Price Index E F Percentage Change Moving Average 1 2 Month 4 Oct-87 $2,084,739 5 Nov-87 $1,998,102 6 Dec-87 54,824,303 7 Jan-88 $1,908,865 8 Feb-88 $2,089,515 9 Mar-88 $3,935,470 10 Apr-88 $2,446,361 11 May-88 $2,229,028 12 Jun-88 $4,176,458 13 Jul-88 $2,564,566 14 Aug-88 $2,618,381 15 Sep-88 $4,405,333 16 Oct-88 $2,353,696 17 Nov-88 $2,383,552 18 Dec-88 $5,194,605 19 Jan-89 $2,248,300 20 Feb-89 $2,028,999 21 Mar-89 $4,263,265 22 Apr-89 $2,276,123 23 May-89 $2,586,093 24 Jun-89 $4,473,599 25 Jul-89 $2,823,938 26 Aug-89 $2,426,540 27 Sep-89 54,569,066 28 Oct-89 $2,560,714 29 Nov-89 $2.461,201 30 Dec-89 $5,347,895 31 Jan-90 $2,459,131 32 Feb-90 $2,561,790 33 Mar-90 $4,531,373 34 Apr-90 $2,573,505 35 May-90 $2,731,364 36 Jun-90 $4,720,815 37 Jul-90 $2,517,316 38 Aug-90 $2,747,416 115.3 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 123.1 123.8 124.1 124.4 124.6 125 125.6 125.9 126.1 127.4 128 128.7 128.9 129.2 129.9 130.4 131.6 $3,827,621 $3,665,374 $8,849,837 $3,492,595 $3,813,239 $7,151,171 $4,422,524 $4,015,911 $7,492,601 $4,581,440 $4,657,925 $7,784,459 $4,145,266 $4,194,358 $9,125,822 $3,930,218 $3,532,277 $7,379,422 $3,914,210 $4,422,115 $7,631,182 $4,805,530 $4,122,644 $7,737,914 $4,315,965 $4,138,357 $8,977,890 $4,086,192 $4,236,820 $7,453,457 $4,226,477 $4,475,315 $7,693,330 $4,086,643 $4,419,519 830% 1443% 312% 1253% -737% 319% - 1149% 1011% 185% 489% - 1149% -60% 412% -134% -162% 397% 1995% 100% 798% 120% 81% -1496% 720% 2.29 $ $ $ $ $ $ 1.94 0.63 0.23 (0.48) 1.80 1.61 3.24 2.49 2.41 0.75 2.31 $ $ $ $ $ G H I MA 070 0.75 2.31 1.69 1.14 4 A B 37 Jul-90 $2,517,316 38 Aug-90 $2,747,416 39 Sep-90 $4,461,696 40 Oct-90 $2,652,219 41 Nov-90 $2,742,380 42 Dec-90 $5,428,077 43 Jan-91 $2,271,963 44 Feb-91 $2,727,079 45 Mar-91 $4,134,727 46 Apr-91 $2,981,945 47 May-91 $2,714,662 48 Jun-91 $4,352,087 49 Jul-91 $2,661,851 50 Aug-91 $2,684,178 51 Sep-91 $4,262,460 52 Oct-91 $2,436,702 53 Nov-91 $2,621,585 54 Dec-91 $5,230,374 55 Jan-92 $2,504,325 56 Feb-92 $2,659,121 57 Mar-92 $4,675,595 58 Apr-92 $2,903,401 59 May-92 $2,632,649 60 Jun-92 $4,489,632 61 Jul-92 $3,051,370 62 Aug-92 $2,528,146 63 Sep-92 $4.778,897 64 Oct-92 $2,752,297 65 Nov-92 $2,402,082 66 Dec-92 $5,867,568 67 Jan-93 $2,554,318 68 Feb-93 $2,695,978 69 Mar-93 $5,270,587 70 Apr-93 $2,667,975 71 May-93 $3,038,608 72 Jun-93 $5,492,295 73 Jul-93 $2,852,423 74 Aug-93 $3,028,444 C D 130.4 $4,086,643 131.6 $4,419,519 132.7 $7,117,632 133.5 $4,205,665 133.8 $4,338,883 133.8 $8,588,087 134.6 $3,573,244 134.8 $4,282,667 135 $6,483,651 135.2 $4,669,060 135.6 $4,238,016 136 $6,774,311 136.2 $4,137,262 136.6 $4,159,749 137.2 $6,576,771 137.4 $3,754,241 137.8 $4,027,367 137.9 $8,029,250 138.1 $3,838,871 138.6 $4,061,452 139.3 $7,105,460 139.5 $4,405,948 139.7 $3,989,358 140.2 $6,779,056 140.5 $4,597,535 140.9 $3,798,373 141.3 $7,159,654 141.8 $4,108,900 142 $3,581,014 141.9 $8,753,510 142.6 $3,791,944 143.1 $3,988,258 143.6 $7,769,821 144 $3,922,165 144.2 $4,460,832 144.4 $8,051,803 144.4 $4,181,704 144.8 $4,427,490 -1496% 720% -802% -256% 485% -434% - 1255% 108% -1301% 1047% -530% -1195% 124% -588% -760% -1073% -718% -651% 743% -517% 959% -564% -587% 7% 1113% -869% 886% 945% -1108% 902% -122% -180% 935% -1098% 1182% 1877% -904% 1656% $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1.65 1.42 0.05 (1.52) (2.69) (2.49) (3.03) (4.09) (2.74) (3.83) (3.80) (4.48) (5.48) (5.66) (3.99) (4.51) (2.63) (3.97) (4.02) (3.02) (2.20) (2.43) (1.06) 0.62 0.30 1.59 0.87 1.15 1.13 0.69 2.16 3.72 2.04 4.14 G H I MA 2.04 4.14 4.66 3.58 6.48 6.22 7.20 7.84 2 A B 73 Jul-93 $2,852,423 74 Aug-93 $3,028,444 75 Sep-93 $5,647,904 76 Oct-93 $2,729,995 77 Nov-93 $3,051,157 78 Dec-93 56,380,292 79 Jan-94 $2,896,075 80 Feb-94 $2,925,727 81 Mar-94 $5,613,494 82 Apr-94 $3,034,533 83 May-94 $3,233,590 84 Jun-94 $5,635,848 85 Jul-94 $3,460,453 86 Aug-94 $3,420,717 87 Sep-94 $5,797,977 88 Oct-94 $3,406,741 89 Nov-94 $3,236,003 90 Dec-94 $6,612,467 91 Jan-95 $3,075,555 92 Feb-95 $3,097,101 93 Mar-95 $5,963,784 94 Apr-95 $3,090,566 95 May-95 $3,252,747 96 Jun-95 $6,298,776 97 Jul-95 $3,572,851 98 Aug-95 $3,716,442 99 Sep-95 $6,014,843 100 Oct-95 $3,378,795 101 Nov-95 $3,385,977 102 Dec-95 $6,960,712 103 Jan-96 $3,599,462 104 Feb-96 $3,841,966 105 Mar-96 $5,682,910 106 Apr-96 $4.080.443 107 May-96 $3,428,768 108 Jun-96 $5,623,598 109 Jul-96 $4,311,187 110 Aug-96 $3,666,345 C 144.4 144.8 145.1 145.7 145.8 145.8 146.2 146.7 147.2 147.4 147.5 148 148.4 149 149.4 149.5 149.7 149.7 150.3 150.9 151.4 151.9 152.2 152.5 152.5 152.9 153.2 153.7 153.6 153.5 154.4 154.9 155.7 156.3 156.6 156.7 157 157.3 D $4,181,704 $4,427,490 $8,239,985 $3,966,512 $4,430,100 $9,263,808 $4,193,425 $4,221,922 $8,072,944 $4,358,137 $4,640,870 $8,061,281 $4,936,346 $4,860,012 $8,215,470 $4,823,968 $4,576,080 $9,350,788 $4,331,826 $4,344,829 $8,338,781 $4,307,118 $4,524,204 $8,743,650 $4,959,656 $5,145,486 $8,311,358 $4,653,658 $4,666,586 $9,599,570 $4,935,110 $5,250,596 $7,726,604 $5,526,559 $4,635,033 $7,597,169 $5,813,045 $4,934,136 -904% $ 1656% $ 1509% $ -347% $ 2371% $ 583% $ 1059% $ 586% $ 390% $ 1112% $ 404% $ 12% $ 1805% $ 977% $ -30% $ 2162% $ 330% $ 94% $ 330% $ 291% $ 329% $ - 117% $ -251% $ 846% $ 47% $ 587% $ 117% $ -353% $ 198% $ 266% $ 1393% $ 2085% $ -734% $ 2831% $ 245% $ -1311% $ 1721% $ -411% $ 7.39 9.23 8.58 7.02 9.28 8.72 7.43 9.52 7.82 7.42 6.81 6.56 6.51 5.49 4.94 5.64 4.17 3.85 3.97 1.88 1.77 1.91 2.79 4.29 3.40 5.86 6.27 4.48 5.87 5.04 G H I MA 5.87 5.04 4.60 6.59 6.78 6.70 5.58 3.06 4.01 2.07 2.61 4.43 A B 109 Jul-96 $4,311,187 110 Aug-96 $3,666,345 111 Sep-96 $5,945,119 112 Oct-96 $4,187,527 113 Nov-96 $3,643,635 114 Dec-96 $7,312,434 115 Jan-97 $3,728,383 116 Feb-97 $3,586,061 117 Mar-97 $6,078,859 118 Apr-97 $4,394,196 119 May-97 $3,818,563 120 Jun-97 56,250,759 121 Jul-97 $4,526,304 122 Aug-97 $3,984,745 123 Sep-97 $6,317,565 124 Oct-97 $4,120,172 125 Nov-97 $4,040,249 126 Dec-97 $7,829,449 127 Jan-98 $4,120,065 128 Feb-98 $3,938,427 129 Mar-98 $6,669,579 130 Apr-98 $4,797,830 131 May-98 $4,639,488 132 Jun-98 $7,146,932 133 Jul-98 $4,758,698 134 Aug-98 $4,495,121 135 Sep-98 $7,081,527 136 Oct-98 $4,599,545 137 Nov-98 $4,049,608 138 Dec-98 $8,492,304 139 Jan-99 $4,483,443 140 Feb-99 $4,370,129 141 Mar-99 57,228,658 142 Apr-99 $4,733,275 143 May-99 54.713,108 144 Jun-99 $7,684,351 145 Jul-99 $4,851,289 146 Aug-99 $4,591,840 C D 157 $5,813,045 157.3 $4,934,136 157.8 $7,975,539 158.3 $5,599,938 158.6 $4,863,380 158.6 $9,760,347 159.1 $4,960,858 159.6 $4,756,541 160 $8,042,824 160.2 $5,806,620 160.1 $5,049,113 160.3 $8,254,784 160.5 $5,970,012 160.8 $5,245,912 161.2 $8,296,429 161.6 $5,397,349 161.5 $5,295,928 161.3 $10,275,509 161.6 $5,397,209 161.9 $5,149,706 162.2 $8,704,705 162.5 $6,250,259 162.8 $6,032,845 163 $9,281,935 163.2 $6,172,690 163.4 $5,823,658 163.6 $9,163,262 164 $5,937,143 164 $5,227,279 163.9 $10,968,647 1643 $5,776,710 164.5 $5,623,865 165 $9,274,281 166.2 $6,028,888 166.2 $6,003,201 166.2 $9,787,746 166.7 $6,160,671 167.1 $5,817,238 1721% -411% -404% 2033% 422% 167% 52% -941% 409% 507% 893% 866% 270% 632% 402% -362% 889% 528% 880% 827% 823% 764% 1948% 1244% 339% 1101% 1045% 1000% -130% 675% 703% 921% 654% -354% -49% 545% -19% -11% $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 3.22 4.09 4.76 2.76 3.15 3.45 4.14 5.62 5.96 6.18 7.06 7.37 7.43 7.82 8.36 9.49 8.64 8.76 8.62 8.70 8.55 7.62 5.96 5.38 5.08 4.15 $ $ $ $ $ $ $ $ $ $ $ $ H | M - 5.08 4.15 3.13 4.22 6.16 5.54 5.56 5.39 4.94 4.75 5.43 4.23 A B 145 IM-99 54.851.289 146 Aug-99 4.591.840 147 Sep-99 57,158.249 148 Oct-99 55.806.170 149 Nov-99 $5.067.675 150 Dec-99 58.665.979 151 Jan-00 $4.938.264 152 Feb-00 54.835.197 153 Mar-00 $7.583.598 154 Apr-00 4.597.792 155 Mar-00 55.236.719 156 Jiun-00 $7.256.520 157 Jul-00 $5.535.777 158 Aug-00 $5.166.064 159 Sep-00 $7,484.590 160 Oct-00 $5.176.017 161 Nov-00 $4.768.897 162 Dec-00 $8.471.908 163 Jan-01 55.034.022 164 Feb-01 55.108.794 165 Mar-01 $7.938.112 166 Apr-01 55.487.725 167 May-01 55.492.037 168 Jun-01 57.550.675 169 Jul-01 55.343.765 170 Aug-01 55.124.688 171 Sep-01 $7.553.747 172 Oct-01 55.101.051 173 Nov-01 33.301.680 174 Dec-01 58.734.068 175 Jan-02 54.951.484 176 Feb-02 54.851.047 17 Mar-02 57.605.114 178 Apr-02 55.609 256 179 May-02 $5.319.727 180 Jun-02 S316.825 181 Jul-02 55.186.212 182 Aug-02 $5.200.134 C D 166.7 56.160,671 | 167.1 $5.817.238 1679 $9,000,104 | 1682 $7,307,524 | 1683 $6,374,280 | 1683 $10,900,339 | 168.8 $6.193.104 169.8 $6,028.135 171.2 9.377,058 171.3 $5,681,964 171.5 $6,464,004 172.4 $8,910,409 172.8 6,781,743 | 172.8 $6,328,816 173.7 9,121,677 174 $6,297,279 174.1 $5,798,634 174 $10,307,147 | 175.1 $6,086,049 175.8 6.151,854 | 176.2 9,537.132 | 176.9 $6,567,060 | 177.7 6,542,632 | 178 $8,979,916 177.5 $6,373,170 177.5 $6.111,890 178.3 $8,968,454 177.7 6.076,853 177.4 6.326,543 176.7 $10,463,730 | 177.1 $5,918,659 177.8 5.775.774 178.8 59,004,191 | 179.8 $6,604,228 | 179.8 6,263,342 1799 $8,609,898 180.1 $6,095,973 | 180.7 $6,092,042 -19% s -11% s -178% s 2308% s 2194% -62% s 721% s 719% s 111% s -575% s 768% 5 -896% 5 1008% s 879% 5 135% 5 -1382% s -903% s -544% s -173% $ 205% s 171% s 1558% 5 122% 5 78% s -602% s -343% s -168% s -350% s 910% s 152% 5 -275% s -611% s -559% s 57% s -427% s -412% 5 -435% s -32% s 5.09 5.83 6.09 3.02 0.43 0.03 (0.71) (1.14) (1.09) 0.69 10.15 0.96 (0.38] (1.40] (1.65) (0.79] 10.72 1.30 1.21 0.53 (0.07] [1.32] (1.78] (2.19) (2.05) (1.79] G H I MA 2A B 181 Jul-02 $5,186,212 182 Aug-02 $5,200,134 183 Sep-02 $7,476,404 184 Oct-02 $5,080,534 185 Nov 02 $5,102,666 186 Dec-02 $8,437,654 187 Jan-03 $4,908,461 188 Feb-03 $4,695,674 189 Mar-03 $7,508,526 190 Apr-03 $5,462,354 191 May-03 $5,314,409 192 Jun-03 $7,465,179 193 Jul-03 $5,422,650 194 Aug-03 $5,309,039 195 Sep-03 $7,763,414 196 Oct-03 $5,382,939 197 Nov-03 $5,101,129 198 Dec-03 $9,004,672 199 Jan-04 $5,041,097 200 Feb-04 $4,783,362 201 Mar-04 $7,678,234 202 Apr-04 $5,709,448 203 May-04 $5,554,502 204 Jun-04 $7,799,978 205 Jul-04 $5,873,844 206 Aug-04 $5,623,609 207 Sep-04 $8,278,942 208 Oct-04 $5,753,712 209 Nov-04 $5,799,628 210 Dec-04 $9,554,181 211 Jan-05 $5,678,499 212 Feb-05 $5.292,117 213 Mar-05 $8,361,414 214 Apr-05 56,214,086 215 May-05 56,100,562 216 Jun-05 $9,091,612 217 Jul-05 56,234,894 218 Aug-05 56.464.899 C D 180.1 $6,095,973 180.7 $6,092,042 181 $8,744,212 181.3 $5,932,231 181.3 $5,958,073 180.9 $9,873,921 181.7 $5,718,695 183.1 $5,428,953 184.2 $8,629,220 183.8 $6,291,306 183.3 $6,130,917 183.7 $8,602,755 183.9 $6,242,180 184.6 $6,088,225 185.2 $8,873,976 185 $6,159,625 184.5 $5,852,972 184.3 $10,343,061 185.2 $5,762,230 186.2 $5,438,262 187.4 $8,673,578 188 $6,428,990 189.1 $6,218,134 189.7 $8,704,274 189.4 $6,565,215 189.5 $6,282,209 189.9 $9,229,036 190.9 $6,380,411 191 $6,427,961 190.3 $10,628,236 190.7 $6,303,611 191.8 $5,841,001 193.3 $9,157,024 194.6 $6,759,910 194.4 $6,643,242 194.5 $9,895,273 195.4 $6,754,777 196.4 $6,968,299 -435% $ -32% $ -250% $ -238% $ -582% $ -564% $ -338% $ -600% $ -416% $ -474% $ -211% $ -8% $ 240% $ -6% $ 148% $ 383% $ -176% $ 475% $ 76% $ 17% $ 51% $ 219% $ 142% $ 118% $ 518% $ 319% $ 400% $ 358% $ 982% $ 276% $ 940% $ 741% $ 557% $ 515% $ 684% $ 1368% $ 289% $ 1092% $ (2.05) (1.79) (1.86) (1.77) (3.01) (3.61) (3.66) (3.65) (3.53) (3.97) (3.79) (3.46) (2.90) (2.87) (2.54) (2.02) (1.69) (0.82) (0.48) 0.04 0.43 1.01 1.30 1.41 1.64 1.91 2.12 2.10 3.06 2.90 3.62 4.22 4.64 4.89 5.34 6.38 6.19 6.83 H MA 05 3.62 4,22 4,64 4.89 2 A B C D 211 Jan-05 $5,678,499 190.7 $6,303,611 212 Feb-05 $5,292,117 191.8 $5,841,001 213 Mar-05 $8,361,414 1 93.3 $9,157,024 214 Apr-05 $6,214,086 194.6 $6,759,910 215 May-05 $6,100,562 14.4 36,643,242 216 Jun-05 $9,091,612 194.5 S9,895,273 217 Jul-05 56,234,894 195.4 $6,754,777 218 Aug-05 $6,464,899 196.4 36,968,299 219 Sep-05 $8,536,692 198.8 3,030,331 220 Oct-05 $6,426,177 1 992 $6,829,200 221 Nov-05 $7,288,497 197.5 $7,808,319 222 Dec-05 $10,649,306 196.8 $11,455,201 223 Jan-06 $6,560,170 198.3 $7,003,238 224 Feb-06 $6,302,897 198.7 $6,715,044 225 Mar-06 $9,379,679 199.8 $3,937,999 226 Apr-06 $7,069,242 201.5 $7,426,844 227 May-06 $7,065,689 202.5 $7,386,454 228 Jun-06 $8,656,821 202.9 $3,031,979 229 Jul-06 $6,040,327 203.5 $6,283,513 230 Aug-06 $7,086,800 203.9 $7,357,655 231 Sep-06 $9,525,313 202.9 $3,938,108 232 Oct-06 $7,114,879 201.8 $7,463,678 233 Nov-06 $7,238,152 201.5 $7,604,238 234 Dec-06 $11.193,635 201.8 $11,742,390 235 Jan-07 $6,782.352 202.416 $7,033,137 236 Feb-07 $6,963,010 2 03.499 $7,243,380 237 Mar-07 $9,846,218205.352 $10,150,256 238 Apr-07 $7,515,351 206.686 $7,637,412 239 May-07 $7,223,830207.949 $7,353,890 240 Jun-07 $9,751,666 208.352 $3,908,038 241 Jul-07 $7,613,600 2 08.299 7,737,655 242 Aug-07 $7,816,825 2 07.917 7,958,787 243 Sep-07 $9,187,563 2 08.49 $9,328,711 244 Oct-07 $7,731,338 2 08.936 7,833,357 245 Nov-07 $7,790,423210.177 7,846,615 246 Dec-07 $11,624,365 2 10 $11,718,080 247 Jan-08 $7,548,736 2 11.08 $7,570,658 24 Feb-08 $7,209,726 2 11.693 $7,209,726 940% $ 741% $ 557% $ 515% $ 684% $ 1368% $ 289% 1032% $ -150% 703%; 2147%; 778 1110% 1496% $ 853% $ 987% $ 1119% $ -872% $ -698% $ 559% $ 333% $ 329% $ -261% $ 251% $ 128% $ 787% $ 214% $ 364% $ -444% $ 970% $ 2314% $ 817% $ -613 495% $ 319% $ -21%; 673% $ -46% 5.34 6.38 6.19 6.83 6.38 6.56 7.63 8.05 8.19 8.82 9.07 9.46 9.83 7.96 7.14 6,69 7.60 7,78 5,78 5,34 4.52 3.93 3.39 2.88 1.91 3.44 5.35 5,17 4,88 4,52 5.00 4,78 5,23 4,53 A G H I MA B C D Sale Tax Consumer Read Dollar Collects Price Index E F Percentage Change Moving Average 1 2 Month 4 Oct-87 $2,084,739 5 Nov-87 $1,998,102 6 Dec-87 54,824,303 7 Jan-88 $1,908,865 8 Feb-88 $2,089,515 9 Mar-88 $3,935,470 10 Apr-88 $2,446,361 11 May-88 $2,229,028 12 Jun-88 $4,176,458 13 Jul-88 $2,564,566 14 Aug-88 $2,618,381 15 Sep-88 $4,405,333 16 Oct-88 $2,353,696 17 Nov-88 $2,383,552 18 Dec-88 $5,194,605 19 Jan-89 $2,248,300 20 Feb-89 $2,028,999 21 Mar-89 $4,263,265 22 Apr-89 $2,276,123 23 May-89 $2,586,093 24 Jun-89 $4,473,599 25 Jul-89 $2,823,938 26 Aug-89 $2,426,540 27 Sep-89 54,569,066 28 Oct-89 $2,560,714 29 Nov-89 $2.461,201 30 Dec-89 $5,347,895 31 Jan-90 $2,459,131 32 Feb-90 $2,561,790 33 Mar-90 $4,531,373 34 Apr-90 $2,573,505 35 May-90 $2,731,364 36 Jun-90 $4,720,815 37 Jul-90 $2,517,316 38 Aug-90 $2,747,416 115.3 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 123.1 123.8 124.1 124.4 124.6 125 125.6 125.9 126.1 127.4 128 128.7 128.9 129.2 129.9 130.4 131.6 $3,827,621 $3,665,374 $8,849,837 $3,492,595 $3,813,239 $7,151,171 $4,422,524 $4,015,911 $7,492,601 $4,581,440 $4,657,925 $7,784,459 $4,145,266 $4,194,358 $9,125,822 $3,930,218 $3,532,277 $7,379,422 $3,914,210 $4,422,115 $7,631,182 $4,805,530 $4,122,644 $7,737,914 $4,315,965 $4,138,357 $8,977,890 $4,086,192 $4,236,820 $7,453,457 $4,226,477 $4,475,315 $7,693,330 $4,086,643 $4,419,519 830% 1443% 312% 1253% -737% 319% - 1149% 1011% 185% 489% - 1149% -60% 412% -134% -162% 397% 1995% 100% 798% 120% 81% -1496% 720% 2.29 $ $ $ $ $ $ 1.94 0.63 0.23 (0.48) 1.80 1.61 3.24 2.49 2.41 0.75 2.31 $ $ $ $ $ G H I MA 070 0.75 2.31 1.69 1.14 4 A B 37 Jul-90 $2,517,316 38 Aug-90 $2,747,416 39 Sep-90 $4,461,696 40 Oct-90 $2,652,219 41 Nov-90 $2,742,380 42 Dec-90 $5,428,077 43 Jan-91 $2,271,963 44 Feb-91 $2,727,079 45 Mar-91 $4,134,727 46 Apr-91 $2,981,945 47 May-91 $2,714,662 48 Jun-91 $4,352,087 49 Jul-91 $2,661,851 50 Aug-91 $2,684,178 51 Sep-91 $4,262,460 52 Oct-91 $2,436,702 53 Nov-91 $2,621,585 54 Dec-91 $5,230,374 55 Jan-92 $2,504,325 56 Feb-92 $2,659,121 57 Mar-92 $4,675,595 58 Apr-92 $2,903,401 59 May-92 $2,632,649 60 Jun-92 $4,489,632 61 Jul-92 $3,051,370 62 Aug-92 $2,528,146 63 Sep-92 $4.778,897 64 Oct-92 $2,752,297 65 Nov-92 $2,402,082 66 Dec-92 $5,867,568 67 Jan-93 $2,554,318 68 Feb-93 $2,695,978 69 Mar-93 $5,270,587 70 Apr-93 $2,667,975 71 May-93 $3,038,608 72 Jun-93 $5,492,295 73 Jul-93 $2,852,423 74 Aug-93 $3,028,444 C D 130.4 $4,086,643 131.6 $4,419,519 132.7 $7,117,632 133.5 $4,205,665 133.8 $4,338,883 133.8 $8,588,087 134.6 $3,573,244 134.8 $4,282,667 135 $6,483,651 135.2 $4,669,060 135.6 $4,238,016 136 $6,774,311 136.2 $4,137,262 136.6 $4,159,749 137.2 $6,576,771 137.4 $3,754,241 137.8 $4,027,367 137.9 $8,029,250 138.1 $3,838,871 138.6 $4,061,452 139.3 $7,105,460 139.5 $4,405,948 139.7 $3,989,358 140.2 $6,779,056 140.5 $4,597,535 140.9 $3,798,373 141.3 $7,159,654 141.8 $4,108,900 142 $3,581,014 141.9 $8,753,510 142.6 $3,791,944 143.1 $3,988,258 143.6 $7,769,821 144 $3,922,165 144.2 $4,460,832 144.4 $8,051,803 144.4 $4,181,704 144.8 $4,427,490 -1496% 720% -802% -256% 485% -434% - 1255% 108% -1301% 1047% -530% -1195% 124% -588% -760% -1073% -718% -651% 743% -517% 959% -564% -587% 7% 1113% -869% 886% 945% -1108% 902% -122% -180% 935% -1098% 1182% 1877% -904% 1656% $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1.65 1.42 0.05 (1.52) (2.69) (2.49) (3.03) (4.09) (2.74) (3.83) (3.80) (4.48) (5.48) (5.66) (3.99) (4.51) (2.63) (3.97) (4.02) (3.02) (2.20) (2.43) (1.06) 0.62 0.30 1.59 0.87 1.15 1.13 0.69 2.16 3.72 2.04 4.14 G H I MA 2.04 4.14 4.66 3.58 6.48 6.22 7.20 7.84 2 A B 73 Jul-93 $2,852,423 74 Aug-93 $3,028,444 75 Sep-93 $5,647,904 76 Oct-93 $2,729,995 77 Nov-93 $3,051,157 78 Dec-93 56,380,292 79 Jan-94 $2,896,075 80 Feb-94 $2,925,727 81 Mar-94 $5,613,494 82 Apr-94 $3,034,533 83 May-94 $3,233,590 84 Jun-94 $5,635,848 85 Jul-94 $3,460,453 86 Aug-94 $3,420,717 87 Sep-94 $5,797,977 88 Oct-94 $3,406,741 89 Nov-94 $3,236,003 90 Dec-94 $6,612,467 91 Jan-95 $3,075,555 92 Feb-95 $3,097,101 93 Mar-95 $5,963,784 94 Apr-95 $3,090,566 95 May-95 $3,252,747 96 Jun-95 $6,298,776 97 Jul-95 $3,572,851 98 Aug-95 $3,716,442 99 Sep-95 $6,014,843 100 Oct-95 $3,378,795 101 Nov-95 $3,385,977 102 Dec-95 $6,960,712 103 Jan-96 $3,599,462 104 Feb-96 $3,841,966 105 Mar-96 $5,682,910 106 Apr-96 $4.080.443 107 May-96 $3,428,768 108 Jun-96 $5,623,598 109 Jul-96 $4,311,187 110 Aug-96 $3,666,345 C 144.4 144.8 145.1 145.7 145.8 145.8 146.2 146.7 147.2 147.4 147.5 148 148.4 149 149.4 149.5 149.7 149.7 150.3 150.9 151.4 151.9 152.2 152.5 152.5 152.9 153.2 153.7 153.6 153.5 154.4 154.9 155.7 156.3 156.6 156.7 157 157.3 D $4,181,704 $4,427,490 $8,239,985 $3,966,512 $4,430,100 $9,263,808 $4,193,425 $4,221,922 $8,072,944 $4,358,137 $4,640,870 $8,061,281 $4,936,346 $4,860,012 $8,215,470 $4,823,968 $4,576,080 $9,350,788 $4,331,826 $4,344,829 $8,338,781 $4,307,118 $4,524,204 $8,743,650 $4,959,656 $5,145,486 $8,311,358 $4,653,658 $4,666,586 $9,599,570 $4,935,110 $5,250,596 $7,726,604 $5,526,559 $4,635,033 $7,597,169 $5,813,045 $4,934,136 -904% $ 1656% $ 1509% $ -347% $ 2371% $ 583% $ 1059% $ 586% $ 390% $ 1112% $ 404% $ 12% $ 1805% $ 977% $ -30% $ 2162% $ 330% $ 94% $ 330% $ 291% $ 329% $ - 117% $ -251% $ 846% $ 47% $ 587% $ 117% $ -353% $ 198% $ 266% $ 1393% $ 2085% $ -734% $ 2831% $ 245% $ -1311% $ 1721% $ -411% $ 7.39 9.23 8.58 7.02 9.28 8.72 7.43 9.52 7.82 7.42 6.81 6.56 6.51 5.49 4.94 5.64 4.17 3.85 3.97 1.88 1.77 1.91 2.79 4.29 3.40 5.86 6.27 4.48 5.87 5.04 G H I MA 5.87 5.04 4.60 6.59 6.78 6.70 5.58 3.06 4.01 2.07 2.61 4.43 A B 109 Jul-96 $4,311,187 110 Aug-96 $3,666,345 111 Sep-96 $5,945,119 112 Oct-96 $4,187,527 113 Nov-96 $3,643,635 114 Dec-96 $7,312,434 115 Jan-97 $3,728,383 116 Feb-97 $3,586,061 117 Mar-97 $6,078,859 118 Apr-97 $4,394,196 119 May-97 $3,818,563 120 Jun-97 56,250,759 121 Jul-97 $4,526,304 122 Aug-97 $3,984,745 123 Sep-97 $6,317,565 124 Oct-97 $4,120,172 125 Nov-97 $4,040,249 126 Dec-97 $7,829,449 127 Jan-98 $4,120,065 128 Feb-98 $3,938,427 129 Mar-98 $6,669,579 130 Apr-98 $4,797,830 131 May-98 $4,639,488 132 Jun-98 $7,146,932 133 Jul-98 $4,758,698 134 Aug-98 $4,495,121 135 Sep-98 $7,081,527 136 Oct-98 $4,599,545 137 Nov-98 $4,049,608 138 Dec-98 $8,492,304 139 Jan-99 $4,483,443 140 Feb-99 $4,370,129 141 Mar-99 57,228,658 142 Apr-99 $4,733,275 143 May-99 54.713,108 144 Jun-99 $7,684,351 145 Jul-99 $4,851,289 146 Aug-99 $4,591,840 C D 157 $5,813,045 157.3 $4,934,136 157.8 $7,975,539 158.3 $5,599,938 158.6 $4,863,380 158.6 $9,760,347 159.1 $4,960,858 159.6 $4,756,541 160 $8,042,824 160.2 $5,806,620 160.1 $5,049,113 160.3 $8,254,784 160.5 $5,970,012 160.8 $5,245,912 161.2 $8,296,429 161.6 $5,397,349 161.5 $5,295,928 161.3 $10,275,509 161.6 $5,397,209 161.9 $5,149,706 162.2 $8,704,705 162.5 $6,250,259 162.8 $6,032,845 163 $9,281,935 163.2 $6,172,690 163.4 $5,823,658 163.6 $9,163,262 164 $5,937,143 164 $5,227,279 163.9 $10,968,647 1643 $5,776,710 164.5 $5,623,865 165 $9,274,281 166.2 $6,028,888 166.2 $6,003,201 166.2 $9,787,746 166.7 $6,160,671 167.1 $5,817,238 1721% -411% -404% 2033% 422% 167% 52% -941% 409% 507% 893% 866% 270% 632% 402% -362% 889% 528% 880% 827% 823% 764% 1948% 1244% 339% 1101% 1045% 1000% -130% 675% 703% 921% 654% -354% -49% 545% -19% -11% $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 3.22 4.09 4.76 2.76 3.15 3.45 4.14 5.62 5.96 6.18 7.06 7.37 7.43 7.82 8.36 9.49 8.64 8.76 8.62 8.70 8.55 7.62 5.96 5.38 5.08 4.15 $ $ $ $ $ $ $ $ $ $ $ $ H | M - 5.08 4.15 3.13 4.22 6.16 5.54 5.56 5.39 4.94 4.75 5.43 4.23 A B 145 IM-99 54.851.289 146 Aug-99 4.591.840 147 Sep-99 57,158.249 148 Oct-99 55.806.170 149 Nov-99 $5.067.675 150 Dec-99 58.665.979 151 Jan-00 $4.938.264 152 Feb-00 54.835.197 153 Mar-00 $7.583.598 154 Apr-00 4.597.792 155 Mar-00 55.236.719 156 Jiun-00 $7.256.520 157 Jul-00 $5.535.777 158 Aug-00 $5.166.064 159 Sep-00 $7,484.590 160 Oct-00 $5.176.017 161 Nov-00 $4.768.897 162 Dec-00 $8.471.908 163 Jan-01 55.034.022 164 Feb-01 55.108.794 165 Mar-01 $7.938.112 166 Apr-01 55.487.725 167 May-01 55.492.037 168 Jun-01 57.550.675 169 Jul-01 55.343.765 170 Aug-01 55.124.688 171 Sep-01 $7.553.747 172 Oct-01 55.101.051 173 Nov-01 33.301.680 174 Dec-01 58.734.068 175 Jan-02 54.951.484 176 Feb-02 54.851.047 17 Mar-02 57.605.114 178 Apr-02 55.609 256 179 May-02 $5.319.727 180 Jun-02 S316.825 181 Jul-02 55.186.212 182 Aug-02 $5.200.134 C D 166.7 56.160,671 | 167.1 $5.817.238 1679 $9,000,104 | 1682 $7,307,524 | 1683 $6,374,280 | 1683 $10,900,339 | 168.8 $6.193.104 169.8 $6,028.135 171.2 9.377,058 171.3 $5,681,964 171.5 $6,464,004 172.4 $8,910,409 172.8 6,781,743 | 172.8 $6,328,816 173.7 9,121,677 174 $6,297,279 174.1 $5,798,634 174 $10,307,147 | 175.1 $6,086,049 175.8 6.151,854 | 176.2 9,537.132 | 176.9 $6,567,060 | 177.7 6,542,632 | 178 $8,979,916 177.5 $6,373,170 177.5 $6.111,890 178.3 $8,968,454 177.7 6.076,853 177.4 6.326,543 176.7 $10,463,730 | 177.1 $5,918,659 177.8 5.775.774 178.8 59,004,191 | 179.8 $6,604,228 | 179.8 6,263,342 1799 $8,609,898 180.1 $6,095,973 | 180.7 $6,092,042 -19% s -11% s -178% s 2308% s 2194% -62% s 721% s 719% s 111% s -575% s 768% 5 -896% 5 1008% s 879% 5 135% 5 -1382% s -903% s -544% s -173% $ 205% s 171% s 1558% 5 122% 5 78% s -602% s -343% s -168% s -350% s 910% s 152% 5 -275% s -611% s -559% s 57% s -427% s -412% 5 -435% s -32% s 5.09 5.83 6.09 3.02 0.43 0.03 (0.71) (1.14) (1.09) 0.69 10.15 0.96 (0.38] (1.40] (1.65) (0.79] 10.72 1.30 1.21 0.53 (0.07] [1.32] (1.78] (2.19) (2.05) (1.79] G H I MA 2A B 181 Jul-02 $5,186,212 182 Aug-02 $5,200,134 183 Sep-02 $7,476,404 184 Oct-02 $5,080,534 185 Nov 02 $5,102,666 186 Dec-02 $8,437,654 187 Jan-03 $4,908,461 188 Feb-03 $4,695,674 189 Mar-03 $7,508,526 190 Apr-03 $5,462,354 191 May-03 $5,314,409 192 Jun-03 $7,465,179 193 Jul-03 $5,422,650 194 Aug-03 $5,309,039 195 Sep-03 $7,763,414 196 Oct-03 $5,382,939 197 Nov-03 $5,101,129 198 Dec-03 $9,004,672 199 Jan-04 $5,041,097 200 Feb-04 $4,783,362 201 Mar-04 $7,678,234 202 Apr-04 $5,709,448 203 May-04 $5,554,502 204 Jun-04 $7,799,978 205 Jul-04 $5,873,844 206 Aug-04 $5,623,609 207 Sep-04 $8,278,942 208 Oct-04 $5,753,712 209 Nov-04 $5,799,628 210 Dec-04 $9,554,181 211 Jan-05 $5,678,499 212 Feb-05 $5.292,117 213 Mar-05 $8,361,414 214 Apr-05 56,214,086 215 May-05 56,100,562 216 Jun-05 $9,091,612 217 Jul-05 56,234,894 218 Aug-05 56.464.899 C D 180.1 $6,095,973 180.7 $6,092,042 181 $8,744,212 181.3 $5,932,231 181.3 $5,958,073 180.9 $9,873,921 181.7 $5,718,695 183.1 $5,428,953 184.2 $8,629,220 183.8 $6,291,306 183.3 $6,130,917 183.7 $8,602,755 183.9 $6,242,180 184.6 $6,088,225 185.2 $8,873,976 185 $6,159,625 184.5 $5,852,972 184.3 $10,343,061 185.2 $5,762,230 186.2 $5,438,262 187.4 $8,673,578 188 $6,428,990 189.1 $6,218,134 189.7 $8,704,274 189.4 $6,565,215 189.5 $6,282,209 189.9 $9,229,036 190.9 $6,380,411 191 $6,427,961 190.3 $10,628,236 190.7 $6,303,611 191.8 $5,841,001 193.3 $9,157,024 194.6 $6,759,910 194.4 $6,643,242 194.5 $9,895,273 195.4 $6,754,777 196.4 $6,968,299 -435% $ -32% $ -250% $ -238% $ -582% $ -564% $ -338% $ -600% $ -416% $ -474% $ -211% $ -8% $ 240% $ -6% $ 148% $ 383% $ -176% $ 475% $ 76% $ 17% $ 51% $ 219% $ 142% $ 118% $ 518% $ 319% $ 400% $ 358% $ 982% $ 276% $ 940% $ 741% $ 557% $ 515% $ 684% $ 1368% $ 289% $ 1092% $ (2.05) (1.79) (1.86) (1.77) (3.01) (3.61) (3.66) (3.65) (3.53) (3.97) (3.79) (3.46) (2.90) (2.87) (2.54) (2.02) (1.69) (0.82) (0.48) 0.04 0.43 1.01 1.30 1.41 1.64 1.91 2.12 2.10 3.06 2.90 3.62 4.22 4.64 4.89 5.34 6.38 6.19 6.83 H MA 05 3.62 4,22 4,64 4.89 2 A B C D 211 Jan-05 $5,678,499 190.7 $6,303,611 212 Feb-05 $5,292,117 191.8 $5,841,001 213 Mar-05 $8,361,414 1 93.3 $9,157,024 214 Apr-05 $6,214,086 194.6 $6,759,910 215 May-05 $6,100,562 14.4 36,643,242 216 Jun-05 $9,091,612 194.5 S9,895,273 217 Jul-05 56,234,894 195.4 $6,754,777 218 Aug-05 $6,464,899 196.4 36,968,299 219 Sep-05 $8,536,692 198.8 3,030,331 220 Oct-05 $6,426,177 1 992 $6,829,200 221 Nov-05 $7,288,497 197.5 $7,808,319 222 Dec-05 $10,649,306 196.8 $11,455,201 223 Jan-06 $6,560,170 198.3 $7,003,238 224 Feb-06 $6,302,897 198.7 $6,715,044 225 Mar-06 $9,379,679 199.8 $3,937,999 226 Apr-06 $7,069,242 201.5 $7,426,844 227 May-06 $7,065,689 202.5 $7,386,454 228 Jun-06 $8,656,821 202.9 $3,031,979 229 Jul-06 $6,040,327 203.5 $6,283,513 230 Aug-06 $7,086,800 203.9 $7,357,655 231 Sep-06 $9,525,313 202.9 $3,938,108 232 Oct-06 $7,114,879 201.8 $7,463,678 233 Nov-06 $7,238,152 201.5 $7,604,238 234 Dec-06 $11.193,635 201.8 $11,742,390 235 Jan-07 $6,782.352 202.416 $7,033,137 236 Feb-07 $6,963,010 2 03.499 $7,243,380 237 Mar-07 $9,846,218205.352 $10,150,256 238 Apr-07 $7,515,351 206.686 $7,637,412 239 May-07 $7,223,830207.949 $7,353,890 240 Jun-07 $9,751,666 208.352 $3,908,038 241 Jul-07 $7,613,600 2 08.299 7,737,655 242 Aug-07 $7,816,825 2 07.917 7,958,787 243 Sep-07 $9,187,563 2 08.49 $9,328,711 244 Oct-07 $7,731,338 2 08.936 7,833,357 245 Nov-07 $7,790,423210.177 7,846,615 246 Dec-07 $11,624,365 2 10 $11,718,080 247 Jan-08 $7,548,736 2 11.08 $7,570,658 24 Feb-08 $7,209,726 2 11.693 $7,209,726 940% $ 741% $ 557% $ 515% $ 684% $ 1368% $ 289% 1032% $ -150% 703%; 2147%; 778 1110% 1496% $ 853% $ 987% $ 1119% $ -872% $ -698% $ 559% $ 333% $ 329% $ -261% $ 251% $ 128% $ 787% $ 214% $ 364% $ -444% $ 970% $ 2314% $ 817% $ -613 495% $ 319% $ -21%; 673% $ -46% 5.34 6.38 6.19 6.83 6.38 6.56 7.63 8.05 8.19 8.82 9.07 9.46 9.83 7.96 7.14 6,69 7.60 7,78 5,78 5,34 4.52 3.93 3.39 2.88 1.91 3.44 5.35 5,17 4,88 4,52 5.00 4,78 5,23 4,53

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

Step: 3

blur-text-image

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

Managerial Accounting

Authors: Peter Clarke

2nd Edition

9781907214240

More Books

Students also viewed these Accounting questions

Question

4. Record one of your lessons to check yourself for clarity.

Answered: 1 week ago