Decision Analysis
Decision Strategies
| Decision Analysis: | ||||||||
| Outcome | ||||||||
| Decision | Rates Rise | Rates Stable | Rates Fall | |||||
| 1-year ARM | $ 61,134 | $ 46,443 | $ 40,161 | |||||
| 3-year ARM | $ 56,901 | $ 51,075 | $ 46,721 | |||||
| 30-year ARM | $ 54,658 | $ 54,658 | $ 54,658 | |||||
| Decision making under completely uncertainty | ||||||||
| Payoff Table | Outcome | 1. Aggressive (Optimistic) | 2. Conservative (Pessimistic) | |||||
| Decision | Rates Rise | Rates Stable | Rates Fall | Minimin | MiniMax | |||
| 1-year ARM | $ 61,134 | $ 46,443 | $ 40,161 | $ 40,161 | $ 61,134 | |||
| 3-year ARM | $ 56,901 | $ 51,075 | $ 46,721 | $ 46,721 | $ 56,901 | |||
| 30-year ARM | $ 54,658 | $ 54,658 | $ 54,658 | $ 54,658 | $ 54,658 | |||
| Maximax | Maximin | |||||||
| 3. Opportunity-Loss or Regret Strategy | ||||||||
| Regret Table | Regret or Opportunity-Loss | Optimistic | ||||||
| Decision | Rates Rise | Rates Stable | Rates Fall | Minimax | ||||
| 1-year ARM | $ 6,476 | $ - 0 | $ - 0 | $ 6,476 | ||||
| 3-year ARM | $ 2,243 | $ 4,632 | $ 6,560 | $ 6,560 | ||||
| 30-year ARM | $ - 0 | $ 8,215 | $ 14,497 | $ 14,497 | ||||
| Decision making under probability | ||||||||
| Payoff Table | Outcome | |||||||
| Decision | Rates Rise | Rates Stable | Rates Fall | Expected Value | ||||
| 1-year ARM | $ 61,134 | $ 46,443 | $ 40,161 | $ 54,629 | ||||
| 3-year ARM | $ 56,901 | $ 51,075 | $ 46,721 | $ 54,135 | ||||
| 30-year ARM | $ 54,658 | $ 54,658 | $ 54,658 | $ 54,658 | ||||
| Probability | 60% | 30% | 10% | |||||
| The Expected Value of Perfect Information (EVPI) | ||||||||
| Expected Value of Perfect Information (EVPI) | EVPI: | $ 3,391 | ||||||
| Payoff Table | Outcome | |||||||
| Decision | Rates Rise | Rates Stable | Rates Fall | Expected Value | ||||
| 1-year ARM | $ 46,443 | $ 40,161 | $ 17,949 | |||||
| 3-year ARM | $ - 0 | |||||||
| 30-year ARM | $ 54,658 | $ 32,795 | ||||||
| Probability | 60% | 30% | 10% | $ 50,744 | ||||
Decision analysis is the study of how people make decisions, particularly when faced with imperfect or uncertain information, as well as a collection of techniques to support decision choices. Decision problems involve: 1. decision alternatives 2. uncertain events that may occur after a decision is made along with their possible outcomes (which are often called states of nature), and are defined so that one and only one of them will occur. 3. consequences associated with each decision and outcome, which are usually expressed as payoffs. Payoffs are often summarized in a payoff table, a matrix whose rows correspond to decisions and whose columns correspond to events.
Example: Selecting a Mortgage Instrument: A family is considering purchasing a new home and wants to finance $150,000. Three mortgage options are available and the payoff table for the outcomes is shown below. The payoffs represent total interest paid under three future interest rate situations.
EVSI for Video
| The Expected Value of Sample (not so perfect) Information (EVSI) | |||||||||||
| Payoff Table | Revenue | Project | Demand is high | Demand is low | |||||||
| Decision | Demand High | Demand Low | Expected Value | 1 | Survey said high | Survey said low | |||||
| Model 1 | $ 300,000 | $ (40,000) | $ 198,000.00 | 2 | Survey said high | Survey said low | |||||
| Model 2 | $ 275,000 | $ (15,000) | $ 188,000.00 | 3 | Survey said high | Survey said low | |||||
| Probability | 0.7 | 0.3 | $ 205,500.00 | EVPI= | $ 7,500.00 | 4 | Survey said high | Survey said low | |||
| 5 | Survey said high | Survey said low | |||||||||
| 6 | Survey said high | Survey said low | |||||||||
| 7 | Survey said high | Survey said low | |||||||||
| 8 | Survey said high | Survey said low | |||||||||
| 9 | Survey said high | Survey said low | |||||||||
| 10 | Survey said high | Survey said low | |||||||||
| 11 | Survey said high | Survey said low | |||||||||
| 12 | Survey said high | Survey said low | |||||||||
| 13 | Survey said high | Survey said low | |||||||||
| Track Record | Market Survey | Posterior Probability | 14 | Survey said high | Survey said low | ||||||
| Conditional Probability | High Response | Low Response | Current Case | Joint Probability | High Response | Low Response | 15 | Survey said high | Survey said low | ||
| Demand is High | 0.9 | 0.1 | 0.7 | 0.63 | 0.913 | 0.087 | 16 | Survey said high | Survey said low | ||
| Demand is low | 0.2 | 0.8 | 0.3 | 0.24 | 0.226 | 0.774 | 17 | Survey said high | Survey said high | ||
| What will be the result? | 0.69 | 0.31 | 18 | Survey said high | Survey said high | ||||||
| 19 | Survey said low | Survey said high | |||||||||
| Posterior Probability: If the Survey response is high, what is the probability the actual demand will be high? | 20 | Survey said low | Survey said high | ||||||||
| Remember: Survey is not perfect and it can't be 100% correct, but if the survey response is high, the future demand should be higher than the current 70%; | |||||||||||
| Remember: Survey is not perfect and it can't be 100% correct, but if the survey response is low, the future demand should be lower than the current 30%; | |||||||||||
| Otherwise the Survey is useless | |||||||||||
| If Survey said High | Revenue | ||||||||||
| Decision | Demand High | Demand Low | Expected Value | ||||||||
| Model 1 | $ 300,000 | $ (40,000) | $ 270,434.78 | ||||||||
| Model 2 | $ 275,000 | $ (15,000) | $ 249,782.61 | ||||||||
| Probability | 0.9 | 0.087 | $ 272,608.70 | ||||||||
| If Survey said low | Revenue | ||||||||||
| Decision | Demand High | Demand Low | Expected Value | ||||||||
| Model 1 | $ 300,000 | $ (40,000) | $ 36,774.19 | ||||||||
| Model 2 | $ 275,000 | $ (15,000) | $ 50,483.87 | ||||||||
| Probability | 0.226 | 0.774 | $ 56,129.03 | ||||||||
| If Survey said low | Expected Value | ||||||||||
| Decision | Demand High | Demand Low | Expected Value | ||||||||
| Model 1 | $ 270,435 | $ 186,600.00 | |||||||||
| Model 2 | $ 50,484 | $ 15,650.00 | |||||||||
| Probability | 0.690 | 0.310 | $ 202,250.00 | ||||||||
| Expected value of sample Information (EVSI): | $ 4,250 |
A company is developing a new cell phone and currently has two models under consideration. Historically, 70% of their new phones have had high consumer demand and 30% have had low consumer demand.
A market research study is conducted to obtain sample information about consumer demand. Similar studies have found: 90% of all products that had high consumer demand had previously received high market survey responses. 20% of all products that had low consumer demand had previously received high market survey responses. We should expect that a high survey response would increase the historical probability of high demand, whereas a low survey response would increase the historical probability of a low demand.
Page 628 #3 and #10
| This is about the DoorCo Corporation who is facing a declining market. | |||
| They have two decision alternatives and three states of nature as in the following table | |||
| Slightly Decline | 20% Decline | 40% Decline | |
| Stay in Carmel | 1 | 0.8 | 0.84 |
| Move to Wisconsin | 1.1 | 0.95 | 0.75 |
| 1. What the decision should the DoorCo make with Aggressive strategy? | |||
| 2. What the decision should the DoorCo make with Conservative strategy? | |||
| 3. What the decision should the DoorCo make with opportunity-loss strategy? | |||
| 4. The probability for the three states of nature are in the table above. What is the expected value decision? | |||
| 5. What is the Expected value of Perfect Information? |
Page 631 # 24
| MJ Logistics has decided to build a new warehouse. | |||||||
| They have the options to build either a larger or a small warehouse. The profits under the two states of natures are in the table below: | |||||||
| Payoff Table | Profit (after construction cost) | ||||||
| Decision | Demand High | Demand Low | Expected Value | ||||
| Large Warehouse | $ 28 | $ 12 | |||||
| Small Warehouse | $ 22 | $ 12 | |||||
| Probability | 0.6 | 0.4 | |||||
| 1. Find the highest expected value and the decision (large or small)? | |||||||
| 2. What is the EVPI? | |||||||
| 3. The company engages an economic expert to provide an opinion about the future is high or low in demand. | |||||||
| His track record is in below table and calculate all the probabilities in Highlighted cells: | |||||||
| Track Record | Market Survey | Posterior Probability | |||||
| Conditional Probability | High Response | Low Response | Current Case | Joint Probability | High Response | Low Response | |
| Demand is High | 0.75 | 0.25 | 0.6 | ||||
| Demand is low | 0.1 | 0.9 | 0.4 | ||||
| What will be the result? | |||||||
| 4. Find the EVSI: |
Sheet4
| Mortgage | 54658 | ||||
| Principla | 150000 | ||||
| Interest Rate | 6.0% | ||||
| Year | 30 | ||||
| 5 year | 10 year | 15 year | |||
| Total Interest Payment | $ 43,541.08 | $ 83,447.68 | $ 118,451.91 | ||
| Period | pmt | ipmt | ppmt | Principal | |
| 0 | 0 | 0 | 0 | 150000 | |
| 1 | $899.33 | $ 750.00 | $149.33 | $149,850.67 | |
| 2 | $899.33 | $ 749.25 | $150.07 | $149,700.60 | |
| 3 | $899.33 | $ 748.50 | $150.82 | $149,549.78 | |
| 4 | $899.33 | $ 747.75 | $151.58 | $149,398.20 | |
| 5 | $899.33 | $ 746.99 | $152.33 | $149,245.87 | |
| 6 | $899.33 | $ 746.23 | $153.10 | $149,092.77 | |
| 7 | $899.33 | $ 745.46 | $153.86 | $148,938.91 | |
| 8 | $899.33 | $ 744.69 | $154.63 | $148,784.28 | |
| 9 | $899.33 | $ 743.92 | $155.40 | $148,628.87 | |
| 10 | $899.33 | $ 743.14 | $156.18 | $148,472.69 | |
| 11 | $899.33 | $ 742.36 | $156.96 | $148,315.73 | |
| 12 | $899.33 | $ 741.58 | $157.75 | $148,157.98 | |
| 13 | $899.33 | $ 740.79 | $158.54 | $147,999.45 | |
| 14 | $899.33 | $ 740.00 | $159.33 | $147,840.12 | |
| 15 | $899.33 | $ 739.20 | $160.13 | $147,679.99 | |
| 16 | $899.33 | $ 738.40 | $160.93 | $147,519.07 | |
| 17 | $899.33 | $ 737.60 | $161.73 | $147,357.34 | |
| 18 | $899.33 | $ 736.79 | $162.54 | $147,194.80 | |
| 19 | $899.33 | $ 735.97 | $163.35 | $147,031.45 | |
| 20 | $899.33 | $ 735.16 | $164.17 | $146,867.28 | |
| 21 | $899.33 | $ 734.34 | $164.99 | $146,702.29 | |
| 22 | $899.33 | $ 733.51 | $165.81 | $146,536.47 | |
| 23 | $899.33 | $ 732.68 | $166.64 | $146,369.83 | |
| 24 | $899.33 | $ 731.85 | $167.48 | $146,202.35 | |
| 25 | $899.33 | $ 731.01 | $168.31 | $146,034.04 | |
| 26 | $899.33 | $ 730.17 | $169.16 | $145,864.88 | |
| 27 | $899.33 | $ 729.32 | $170.00 | $145,694.88 | |
| 28 | $899.33 | $ 728.47 | $170.85 | $145,524.03 | |
| 29 | $899.33 | $ 727.62 | $171.71 | $145,352.33 | |
| 30 | $899.33 | $ 726.76 | $172.56 | $145,179.76 | |
| 31 | $899.33 | $ 725.90 | $173.43 | $145,006.33 | |
| 32 | $899.33 | $ 725.03 | $174.29 | $144,832.04 | |
| 33 | $899.33 | $ 724.16 | $175.17 | $144,656.87 | |
| 34 | $899.33 | $ 723.28 | $176.04 | $144,480.83 | |
| 35 | $899.33 | $ 722.40 | $176.92 | $144,303.91 | |
| 36 | $899.33 | $ 721.52 | $177.81 | $144,126.11 | |
| 37 | $899.33 | $ 720.63 | $178.70 | $143,947.41 | |
| 38 | $899.33 | $ 719.74 | $179.59 | $143,767.82 | |
| 39 | $899.33 | $ 718.84 | $180.49 | $143,587.33 | |
| 40 | $899.33 | $ 717.94 | $181.39 | $143,405.95 | |
| 41 | $899.33 | $ 717.03 | $182.30 | $143,223.65 | |
| 42 | $899.33 | $ 716.12 | $183.21 | $143,040.44 | |
| 43 | $899.33 | $ 715.20 | $184.12 | $142,856.32 | |
| 44 | $899.33 | $ 714.28 | $185.04 | $142,671.27 | |
| 45 | $899.33 | $ 713.36 | $185.97 | $142,485.30 | |
| 46 | $899.33 | $ 712.43 | $186.90 | $142,298.41 | |
| 47 | $899.33 | $ 711.49 | $187.83 | $142,110.57 | |
| 48 | $899.33 | $ 710.55 | $188.77 | $141,921.80 | |
| 49 | $899.33 | $ 709.61 | $189.72 | $141,732.08 | |
| 50 | $899.33 | $ 708.66 | $190.67 | $141,541.42 | |
| 51 | $899.33 | $ 707.71 | $191.62 | $141,349.80 | |
| 52 | $899.33 | $ 706.75 | $192.58 | $141,157.22 | |
| 53 | $899.33 | $ 705.79 | $193.54 | $140,963.68 | |
| 54 | $899.33 | $ 704.82 | $194.51 | $140,769.17 | |
| 55 | $899.33 | $ 703.85 | $195.48 | $140,573.69 | |
| 56 | $899.33 | $ 702.87 | $196.46 | $140,377.24 | |
| 57 | $899.33 | $ 701.89 | $197.44 | $140,179.80 | |
| 58 | $899.33 | $ 700.90 | $198.43 | $139,981.37 | |
| 59 | $899.33 | $ 699.91 | $199.42 | $139,781.95 | |
| 60 | $899.33 | $ 698.91 | $200.42 | $139,581.54 | |
| 61 | $899.33 | $ 697.91 | $201.42 | $139,380.12 | |
| 62 | $899.33 | $ 696.90 | $202.43 | $139,177.69 | |
| 63 | $899.33 | $ 695.89 | $203.44 | $138,974.25 | |
| 64 | $899.33 | $ 694.87 | $204.45 | $138,769.80 | |
| 65 | $899.33 | $ 693.85 | $205.48 | $138,564.32 | |
| 66 | $899.33 | $ 692.82 | $206.50 | $138,357.82 | |
| 67 | $899.33 | $ 691.79 | $207.54 | $138,150.28 | |
| 68 | $899.33 | $ 690.75 | $208.57 | $137,941.71 | |
| 69 | $899.33 | $ 689.71 | $209.62 | $137,732.09 | |
| 70 | $899.33 | $ 688.66 | $210.67 | $137,521.43 | |
| 71 | $899.33 | $ 687.61 | $211.72 | $137,309.71 | |
| 72 | $899.33 | $ 686.55 | $212.78 | $137,096.93 | |
| 73 | $899.33 | $ 685.48 | $213.84 | $136,883.09 | |
| 74 | $899.33 | $ 684.42 | $214.91 | $136,668.18 | |
| 75 | $899.33 | $ 683.34 | $215.98 | $136,452.19 | |
| 76 | $899.33 | $ 682.26 | $217.06 | $136,235.13 | |
| 77 | $899.33 | $ 681.18 | $218.15 | $136,016.98 | |
| 78 | $899.33 | $ 680.08 | $219.24 | $135,797.74 | |
| 79 | $899.33 | $ 678.99 | $220.34 | $135,577.40 | |
| 80 | $899.33 | $ 677.89 | $221.44 | $135,355.96 | |
| 81 | $899.33 | $ 676.78 | $222.55 | $135,133.42 | |
| 82 | $899.33 | $ 675.67 | $223.66 | $134,909.76 | |
| 83 | $899.33 | $ 674.55 | $224.78 | $134,684.98 | |
| 84 | $899.33 | $ 673.42 | $225.90 | $134,459.08 | |
| 85 | $899.33 | $ 672.30 | $227.03 | $134,232.05 | |
| 86 | $899.33 | $ 671.16 | $228.17 | $134,003.88 | |
| 87 | $899.33 | $ 670.02 | $229.31 | $133,774.58 | |
| 88 | $899.33 | $ 668.87 | $230.45 | $133,544.12 | |
| 89 | $899.33 | $ 667.72 | $231.61 | $133,312.52 | |
| 90 | $899.33 | $ 666.56 | $232.76 | $133,079.76 | |
| 91 | $899.33 | $ 665.40 | $233.93 | $132,845.83 | |
| 92 | $899.33 | $ 664.23 | $235.10 | $132,610.73 | |
| 93 | $899.33 | $ 663.05 | $236.27 | $132,374.46 | |
| 94 | $899.33 | $ 661.87 | $237.45 | $132,137.01 | |
| 95 | $899.33 | $ 660.69 | $238.64 | $131,898.37 | |
| 96 | $899.33 | $ 659.49 | $239.83 | $131,658.53 | |
| 97 | $899.33 | $ 658.29 | $241.03 | $131,417.50 | |
| 98 | $899.33 | $ 657.09 | $242.24 | $131,175.26 | |
| 99 | $899.33 | $ 655.88 | $243.45 | $130,931.81 | |
| 100 | $899.33 | $ 654.66 | $244.67 | $130,687.14 | |
| 101 | $899.33 | $ 653.44 | $245.89 | $130,441.25 | |
| 102 | $899.33 | $ 652.21 | $247.12 | $130,194.13 | |
| 103 | $899.33 | $ 650.97 | $248.36 | $129,945.78 | |
| 104 | $899.33 | $ 649.73 | $249.60 | $129,696.18 | |
| 105 | $899.33 | $ 648.48 | $250.84 | $129,445.34 | |
| 106 | $899.33 | $ 647.23 | $252.10 | $129,193.24 | |
| 107 | $899.33 | $ 645.97 | $253.36 | $128,939.88 | |
| 108 | $899.33 | $ 644.70 | $254.63 | $128,685.25 | |
| 109 | $899.33 | $ 643.43 | $255.90 | $128,429.35 | |
| 110 | $899.33 | $ 642.15 | $257.18 | $128,172.17 | |
| 111 | $899.33 | $ 640.86 | $258.46 | $127,913.71 | |
| 112 | $899.33 | $ 639.57 | $259.76 | $127,653.95 | |
| 113 | $899.33 | $ 638.27 | $261.06 | $127,392.90 | |
| 114 | $899.33 | $ 636.96 | $262.36 | $127,130.53 | |
| 115 | $899.33 | $ 635.65 | $263.67 | $126,866.86 | |
| 116 | $899.33 | $ 634.33 | $264.99 | $126,601.87 | |
| 117 | $899.33 | $ 633.01 | $266.32 | $126,335.55 | |
| 118 | $899.33 | $ 631.68 | $267.65 | $126,067.90 | |
| 119 | $899.33 | $ 630.34 | $268.99 | $125,798.92 | |
| 120 | $899.33 | $ 628.99 | $270.33 | $125,528.59 | |
| 121 | $899.33 | $ 627.64 | $271.68 | $125,256.90 | |
| 122 | $899.33 | $ 626.28 | $273.04 | $124,983.86 | |
| 123 | $899.33 | $ 624.92 | $274.41 | $124,709.46 | |
| 124 | $899.33 | $ 623.55 | $275.78 | $124,433.68 | |
| 125 | $899.33 | $ 622.17 | $277.16 | $124,156.52 | |
| 126 | $899.33 | $ 620.78 | $278.54 | $123,877.98 | |
| 127 | $899.33 | $ 619.39 | $279.94 | $123,598.04 | |
| 128 | $899.33 | $ 617.99 | $281.34 | $123,316.71 | |
| 129 | $899.33 | $ 616.58 | $282.74 | $123,033.96 | |
| 130 | $899.33 | $ 615.17 | $284.16 | $122,749.81 | |
| 131 | $899.33 | $ 613.75 | $285.58 | $122,464.23 | |
| 132 | $899.33 | $ 612.32 | $287.00 | $122,177.23 | |
| 133 | $899.33 | $ 610.89 | $288.44 | $121,888.79 | |
| 134 | $899.33 | $ 609.44 | $289.88 | $121,598.91 | |
| 135 | $899.33 | $ 607.99 | $291.33 | $121,307.57 | |
| 136 | $899.33 | $ 606.54 | $292.79 | $121,014.79 | |
| 137 | $899.33 | $ 605.07 | $294.25 | $120,720.53 | |
| 138 | $899.33 | $ 603.60 | $295.72 | $120,424.81 | |
| 139 | $899.33 | $ 602.12 | $297.20 | $120,127.61 | |
| 140 | $899.33 | $ 600.64 | $298.69 | $119,828.92 | |
| 141 | $899.33 | $ 599.14 | $300.18 | $119,528.74 | |
| 142 | $899.33 | $ 597.64 | $301.68 | $119,227.06 | |
| 143 | $899.33 | $ 596.14 | $303.19 | $118,923.87 | |
| 144 | $899.33 | $ 594.62 | $304.71 | $118,619.16 | |
| 145 | $899.33 | $ 593.10 | $306.23 | $118,312.93 | |
| 146 | $899.33 | $ 591.56 | $307.76 | $118,005.17 | |
| 147 | $899.33 | $ 590.03 | $309.30 | $117,695.87 | |
| 148 | $899.33 | $ 588.48 | $310.85 | $117,385.02 | |
| 149 | $899.33 | $ 586.93 | $312.40 | $117,072.62 | |
| 150 | $899.33 | $ 585.36 | $313.96 | $116,758.66 | |
| 151 | $899.33 | $ 583.79 | $315.53 | $116,443.13 | |
| 152 | $899.33 | $ 582.22 | $317.11 | $116,126.02 | |
| 153 | $899.33 | $ 580.63 | $318.70 | $115,807.32 | |
| 154 | $899.33 | $ 579.04 | $320.29 | $115,487.03 | |
| 155 | $899.33 | $ 577.44 | $321.89 | $115,165.14 | |
| 156 | $899.33 | $ 575.83 | $323.50 | $114,841.64 | |
| 157 | $899.33 | $ 574.21 | $325.12 | $114,516.52 | |
| 158 | $899.33 | $ 572.58 | $326.74 | $114,189.78 | |
| 159 | $899.33 | $ 570.95 | $328.38 | $113,861.40 | |
| 160 | $899.33 | $ 569.31 | $330.02 | $113,531.39 | |
| 161 | $899.33 | $ 567.66 | $331.67 | $113,199.72 | |
| 162 | $899.33 | $ 566.00 | $333.33 | $112,866.39 | |
| 163 | $899.33 | $ 564.33 | $334.99 | $112,531.40 | |
| 164 | $899.33 | $ 562.66 | $336.67 | $112,194.73 | |
| 165 | $899.33 | $ 560.97 | $338.35 | $111,856.38 | |
| 166 | $899.33 | $ 559.28 | $340.04 | $111,516.33 | |
| 167 | $899.33 | $ 557.58 | $341.74 | $111,174.59 | |
| 168 | $899.33 | $ 555.87 | $343.45 | $110,831.13 | |
| 169 | $899.33 | $ 554.16 | $345.17 | $110,485.96 | |
| 170 | $899.33 | $ 552.43 | $346.90 | $110,139.07 | |
| 171 | $899.33 | $ 550.70 | $348.63 | $109,790.44 | |
| 172 | $899.33 | $ 548.95 | $350.37 | $109,440.06 | |
| 173 | $899.33 | $ 547.20 | $352.13 | $109,087.94 | |
| 174 | $899.33 | $ 545.44 | $353.89 | $108,734.05 | |
| 175 | $899.33 | $ 543.67 | $355.66 | $108,378.40 | |
| 176 | $899.33 | $ 541.89 | $357.43 | $108,020.96 | |
| 177 | $899.33 | $ 540.10 | $359.22 | $107,661.74 | |
| 178 | $899.33 | $ 538.31 | $361.02 | $107,300.73 | |
| 179 | $899.33 | $ 536.50 | $362.82 | $106,937.90 | |
| 180 | $899.33 | $ 534.69 | $364.64 | $106,573.27 | |
| 181 | $899.33 | $ 532.87 | $366.46 | $106,206.81 | |
| 182 | $899.33 | $ 531.03 | $368.29 | $105,838.52 | |
| 183 | $899.33 | $ 529.19 | $370.13 | $105,468.38 | |
| 184 | $899.33 | $ 527.34 | $371.98 | $105,096.40 | |
| 185 | $899.33 | $ 525.48 | $373.84 | $104,722.55 | |
| 186 | $899.33 | $ 523.61 | $375.71 | $104,346.84 | |
| 187 | $899.33 | $ 521.73 | $377.59 | $103,969.25 | |
| 188 | $899.33 | $ 519.85 | $379.48 | $103,589.77 | |
| 189 | $899.33 | $ 517.95 | $381.38 | $103,208.39 | |
| 190 | $899.33 | $ 516.04 | $383.28 | $102,825.11 | |
| 191 | $899.33 | $ 514.13 | $385.20 | $102,439.91 | |
| 192 | $899.33 | $ 512.20 | $387.13 | $102,052.78 | |
| 193 | $899.33 | $ 510.26 | $389.06 | $101,663.72 | |
| 194 | $899.33 | $ 508.32 | $391.01 | $101,272.71 | |
| 195 | $899.33 | $ 506.36 | $392.96 | $100,879.75 | |
| 196 | $899.33 | $ 504.40 | $394.93 | $100,484.82 | |
| 197 | $899.33 | $ 502.42 | $396.90 | $100,087.92 | |
| 198 | $899.33 | $ 500.44 | $398.89 | $99,689.04 | |
| 199 | $899.33 | $ 498.45 | $400.88 | $99,288.16 | |
| 200 | $899.33 | $ 496.44 | $402.89 | $98,885.27 | |
| 201 | $899.33 | $ 494.43 | $404.90 | $98,480.37 | |
| 202 | $899.33 | $ 492.40 | $406.92 | $98,073.45 | |
| 203 | $899.33 | $ 490.37 | $408.96 | $97,664.49 | |
| 204 | $899.33 | $ 488.32 | $411.00 | $97,253.49 | |
| 205 | $899.33 | $ 486.27 | $413.06 | $96,840.43 | |
| 206 | $899.33 | $ 484.20 | $415.12 | $96,425.30 | |
| 207 | $899.33 | $ 482.13 | $417.20 | $96,008.10 | |
| 208 | $899.33 | $ 480.04 | $419.29 | $95,588.82 | |
| 209 | $899.33 | $ 477.94 | $421.38 | $95,167.44 | |
| 210 | $899.33 | $ 475.84 | $423.49 | $94,743.95 | |
| 211 | $899.33 | $ 473.72 | $425.61 | $94,318.34 | |
| 212 | $899.33 | $ 471.59 | $427.73 | $93,890.61 | |
| 213 | $899.33 | $ 469.45 | $429.87 | $93,460.74 | |
| 214 | $899.33 | $ 467.30 | $432.02 | $93,028.71 | |
| 215 | $899.33 | $ 465.14 | $434.18 | $92,594.53 | |
| 216 | $899.33 | $ 462.97 | $436.35 | $92,158.18 | |
| 217 | $899.33 | $ 460.79 | $438.53 | $91,719.64 | |
| 218 | $899.33 | $ 458.60 | $440.73 | $91,278.92 | |
| 219 | $899.33 | $ 456.39 | $442.93 | $90,835.99 | |
| 220 | $899.33 | $ 454.18 | $445.15 | $90,390.84 | |
| 221 | $899.33 | $ 451.95 | $447.37 | $89,943.47 | |
| 222 | $899.33 | $ 449.72 | $449.61 | $89,493.86 | |
| 223 | $899.33 | $ 447.47 | $451.86 | $89,042.00 | |
| 224 | $899.33 | $ 445.21 | $454.12 | $88,587.89 | |
| 225 | $899.33 | $ 442.94 | $456.39 | $88,131.50 | |
| 226 | $899.33 | $ 440.66 | $458.67 | $87,672.83 | |
| 227 | $899.33 | $ 438.36 | $460.96 | $87,211.87 | |
| 228 | $899.33 | $ 436.06 | $463.27 | $86,748.60 | |
| 229 | $899.33 | $ 433.74 | $465.58 | $86,283.02 | |
| 230 | $899.33 | $ 431.42 | $467.91 | $85,815.11 | |
| 231 | $899.33 | $ 429.08 | $470.25 | $85,344.86 | |
| 232 | $899.33 | $ 426.72 | $472.60 | $84,872.26 | |
| 233 | $899.33 | $ 424.36 | $474.96 | $84,397.29 | |
| 234 | $899.33 | $ 421.99 | $477.34 | $83,919.96 | |
| 235 | $899.33 | $ 419.60 | $479.73 | $83,440.23 | |
| 236 | $899.33 | $ 417.20 | $482.12 | $82,958.10 | |
| 237 | $899.33 | $ 414.79 | $484.54 | $82,473.57 | |
| 238 | $899.33 | $ 412.37 | $486.96 | $81,986.61 | |
| 239 | $899.33 | $ 409.93 | $489.39 | $81,497.22 | |
| 240 | $899.33 | $ 407.49 | $491.84 | $81,005.38 | |
| 241 | $899.33 | $ 405.03 | $494.30 | $80,511.08 | |
| 242 | $899.33 | $ 402.56 | $496.77 | $80,014.31 | |
| 243 | $899.33 | $ 400.07 | $499.25 | $79,515.06 | |
| 244 | $899.33 | $ 397.58 | $501.75 | $79,013.31 | |
| 245 | $899.33 | $ 395.07 | $504.26 | $78,509.05 | |
| 246 | $899.33 | $ 392.55 | $506.78 | $78,002.27 | |
| 247 | $899.33 | $ 390.01 | $509.31 | $77,492.95 | |
| 248 | $899.33 | $ 387.46 | $511.86 | $76,981.09 | |
| 249 | $899.33 | $ 384.91 | $514.42 | $76,466.67 | |
| 250 | $899.33 | $ 382.33 | $516.99 | $75,949.68 | |
| 251 | $899.33 | $ 379.75 | $519.58 | $75,430.10 | |
| 252 | $899.33 | $ 377.15 | $522.18 | $74,907.92 | |
| 253 | $899.33 | $ 374.54 | $524.79 | $74,383.14 | |
| 254 | $899.33 | $ 371.92 | $527.41 | $73,855.73 | |
| 255 | $899.33 | $ 369.28 | $530.05 | $73,325.68 | |
| 256 | $899.33 | $ 366.63 | $532.70 | $72,792.98 | |
| 257 | $899.33 | $ 363.96 | $535.36 | $72,257.62 | |
| 258 | $899.33 | $ 361.29 | $538.04 | $71,719.59 | |
| 259 | $899.33 | $ 358.60 | $540.73 | $71,178.86 | |
| 260 | $899.33 | $ 355.89 | $543.43 | $70,635.43 | |
| 261 | $899.33 | $ 353.18 | $546.15 | $70,089.28 | |
| 262 | $899.33 | $ 350.45 | $548.88 | $69,540.40 | |
| 263 | $899.33 | $ 347.70 | $551.62 | $68,988.77 | |
| 264 | $899.33 | $ 344.94 | $554.38 | $68,434.39 | |
| 265 | $899.33 | $ 342.17 | $557.15 | $67,877.24 | |
| 266 | $899.33 | $ 339.39 | $559.94 | $67,317.30 | |
| 267 | $899.33 | $ 336.59 | $562.74 | $66,754.56 | |
| 268 | $899.33 | $ 333.77 | $565.55 | $66,189.01 | |
| 269 | $899.33 | $ 330.95 | $568.38 | $65,620.63 | |
| 270 | $899.33 | $ 328.10 | $571.22 | $65,049.40 | |
| 271 | $899.33 | $ 325.25 | $574.08 | $64,475.32 | |
| 272 | $899.33 | $ 322.38 | $576.95 | $63,898.38 | |
| 273 | $899.33 | $ 319.49 | $579.83 | $63,318.54 | |
| 274 | $899.33 | $ 316.59 | $582.73 | $62,735.81 | |
| 275 | $899.33 | $ 313.68 | $585.65 | $62,150.16 | |
| 276 | $899.33 | $ 310.75 | $588.57 | $61,561.59 | |
| 277 | $899.33 | $ 307.81 | $591.52 | $60,970.07 | |
| 278 | $899.33 | $ 304.85 | $594.48 | $60,375.59 | |
| 279 | $899.33 | $ 301.88 | $597.45 | $59,778.15 | |
| 280 | $899.33 | $ 298.89 | $600.44 | $59,177.71 | |
| 281 | $899.33 | $ 295.89 | $603.44 | $58,574.27 | |
| 282 | $899.33 | $ 292.87 | $606.45 | $57,967.82 | |
| 283 | $899.33 | $ 289.84 | $609.49 | $57,358.33 | |
| 284 | $899.33 | $ 286.79 | $612.53 | $56,745.80 | |
| 285 | $899.33 | $ 283.73 | $615.60 | $56,130.20 | |
| 286 | $899.33 | $ 280.65 | $618.67 | $55,511.53 | |
| 287 | $899.33 | $ 277.56 | $621.77 | $54,889.76 | |
| 288 | $899.33 | $ 274.45 | $624.88 | $54,264.88 | |
| 289 | $899.33 | $ 271.32 | $628.00 | $53,636.88 | |
| 290 | $899.33 | $ 268.18 | $631.14 | $53,005.74 | |
| 291 | $899.33 | $ 265.03 | $634.30 | $52,371.44 | |
| 292 | $899.33 | $ 261.86 | $637.47 | $51,733.97 | |
| 293 | $899.33 | $ 258.67 | $640.66 | $51,093.32 | |
| 294 | $899.33 | $ 255.47 | $643.86 | $50,449.46 | |
| 295 | $899.33 | $ 252.25 | $647.08 | $49,802.38 | |
| 296 | $899.33 | $ 249.01 | $650.31 | $49,152.06 | |
| 297 | $899.33 | $ 245.76 | $653.57 | $48,498.50 | |
| 298 | $899.33 | $ 242.49 | $656.83 | $47,841.67 | |
| 299 | $899.33 | $ 239.21 | $660.12 | $47,181.55 | |
| 300 | $899.33 | $ 235.91 | $663.42 | $46,518.13 | |
| 301 | $899.33 | $ 232.59 | $666.74 | $45,851.40 | |
| 302 | $899.33 | $ 229.26 | $670.07 | $45,181.33 | |
| 303 | $899.33 | $ 225.91 | $673.42 | $44,507.91 | |
| 304 | $899.33 | $ 222.54 | $676.79 | $43,831.12 | |
| 305 | $899.33 | $ 219.16 | $680.17 | $43,150.95 | |
| 306 | $899.33 | $ 215.75 | $683.57 | $42,467.38 | |
| 307 | $899.33 | $ 212.34 | $686.99 | $41,780.39 | |
| 308 | $899.33 | $ 208.90 | $690.42 | $41,089.97 | |
| 309 | $899.33 | $ 205.45 | $693.88 | $40,396.09 | |
| 310 | $899.33 | $ 201.98 | $697.35 | $39,698.75 | |
| 311 | $899.33 | $ 198.49 | $700.83 | $38,997.91 | |
| 312 | $899.33 | $ 194.99 | $704.34 | $38,293.58 | |
| 313 | $899.33 | $ 191.47 | $707.86 | $37,585.72 | |
| 314 | $899.33 | $ 187.93 | $711.40 | $36,874.32 | |
| 315 | $899.33 | $ 184.37 | $714.95 | $36,159.37 | |
| 316 | $899.33 | $ 180.80 | $718.53 | $35,440.84 | |
| 317 | $899.33 | $ 177.20 | $722.12 | $34,718.72 | |
| 318 | $899.33 | $ 173.59 | $725.73 | $33,992.99 | |
| 319 | $899.33 | $ 169.96 | $729.36 | $33,263.62 | |
| 320 | $899.33 | $ 166.32 | $733.01 | $32,530.62 | |
| 321 | $899.33 | $ 162.65 | $736.67 | $31,793.94 | |
| 322 | $899.33 | $ 158.97 | $740.36 | $31,053.59 | |
| 323 | $899.33 | $ 155.27 | $744.06 | $30,309.53 | |
| 324 | $899.33 | $ 151.55 | $747.78 | $29,561.75 | |
| 325 | $899.33 | $ 147.81 | $751.52 | $28,810.24 | |
| 326 | $899.33 | $ 144.05 | $755.27 | $28,054.96 | |
| 327 | $899.33 | $ 140.27 | $759.05 | $27,295.91 | |
| 328 | $899.33 | $ 136.48 | $762.85 | $26,533.06 | |
| 329 | $899.33 | $ 132.67 | $766.66 | $25,766.40 | |
| 330 | $899.33 | $ 128.83 | $770.49 | $24,995.91 | |
| 331 | $899.33 | $ 124.98 | $774.35 | $24,221.56 | |
| 332 | $899.33 | $ 121.11 | $778.22 | $23,443.35 | |
| 333 | $899.33 | $ 117.22 | $782.11 | $22,661.24 | |
| 334 | $899.33 | $ 113.31 | $786.02 | $21,875.22 | |
| 335 | $899.33 | $ 109.38 | $789.95 | $21,085.27 | |
| 336 | $899.33 | $ 105.43 | $793.90 | $20,291.37 | |
| 337 | $899.33 | $ 101.46 | $797.87 | $19,493.50 | |
| 338 | $899.33 | $ 97.47 | $801.86 | $18,691.64 | |
| 339 | $899.33 | $ 93.46 | $805.87 | $17,885.77 | |
| 340 | $899.33 | $ 89.43 | $809.90 | $17,075.88 | |
| 341 | $899.33 | $ 85.38 | $813.95 | $16,261.93 | |
| 342 | $899.33 | $ 81.31 | $818.02 | $15,443.91 | |
| 343 | $899.33 | $ 77.22 | $822.11 | $14,621.81 | |
| 344 | $899.33 | $ 73.11 | $826.22 | $13,795.59 | |
| 345 | $899.33 | $ 68.98 | $830.35 | $12,965.24 | |
| 346 | $899.33 | $ 64.83 | $834.50 | $12,130.74 | |
| 347 | $899.33 | $ 60.65 | $838.67 | $11,292.07 | |
| 348 | $899.33 | $ 56.46 | $842.87 | $10,449.21 | |
| 349 | $899.33 | $ 52.25 | $847.08 | $9,602.13 | |
| 350 | $899.33 | $ 48.01 | $851.32 | $8,750.81 | |
| 351 | $899.33 | $ 43.75 | $855.57 | $7,895.24 | |
| 352 | $899.33 | $ 39.48 | $859.85 | $7,035.39 | |
| 353 | $899.33 | $ 35.18 | $864.15 | $6,171.24 | |
| 354 | $899.33 | $ 30.86 | $868.47 | $5,302.77 | |
| 355 | $899.33 | $ 26.51 | $872.81 | $4,429.96 | |
| 356 | $899.33 | $ 22.15 | $877.18 | $3,552.78 | |
| 357 | $899.33 | $ 17.76 | $881.56 | $2,671.22 | |
| 358 | $899.33 | $ 13.36 | $885.97 | $1,785.25 | |
| 359 | $899.33 | $ 8.93 | $890.40 | $894.85 | |
| 360 | $899.33 | $ 4.47 | $894.85 | $0.00 |