need help finishing this assignment
LLRR17
mba501_excel_template-6-2_tw5.xlsREAD ME
| If you need assistance using Excel, you can access a tutorial that is appropriate for your experience level and your version of Excel. | |||||||||
| Access these tutorials at Atomic Learning using your SNHU login at: | Excel 2016 | ||||||||
| The Data Analysis ToolPak is an add-in program for Microsoft Excel. It must be added in to the software before it can be used. | |||||||||
| If you have "DATA" already on the upper main menu, then simply click on it and you will open up a tool bar of assorted new Excel tools, including: | |||||||||
| Get External Data, Connections, Sort & Filter, Data Tools, Outline, and Analysis. | |||||||||
| If you do not see "DATA" on the upper main menu, then you must add this program into Excel by doing the following: | |||||||||
| Click FILE in the upper tool bar, followed by OPTIONS, then select ADD-INS. | |||||||||
| Next, on the bottom near Manage, select EXCEL ADD-INS and GO. Ensure the ANALYSIS TOOLPAK is checkmarked and click OK. | |||||||||
| This ToolPak will provide additional data analysis tools for statistics. | |||||||||
| NOTE: If you are unable to load this ToolPak into your version of Excel, you may have to consult your installation CD and reinstall the Excel set-up | |||||||||
| The DATA ANALYSIS TOOLPAK provides 18 additional statistical tools in the areas of: | |||||||||
| Descriptive Statistics; Sampling; Hypothesis Testing; Analysis of Variance; Regression and Correlation; and Time Series Forecasting | |||||||||
| The ToolPak is valuable to business analysts and leaders who desire additional capability from the Excel software. |
Introduction
| Company North-East-West-South (NEWS) | |
| NEWS is struggling in the ultra-competitive high-tech market. They have called upon you and your analysis team to help them analyze their data in order | |
| to make some key business decisions using the methods and tools recently learned throughout MBA 501. | |
| Save this file for each homework assignment as follows: Last Name_First Name_Homework #.xls For example, Smith_John_Homework 2_1.xls | |
| 2-1 Excel Homework I: Scatterplots | |
| This homework assignment will help you begin to familiarize yourself with the Excel software, creating graphs, and using the Data Analysis add-in feature. | |
| Create a scatterplot from a given set of data and then create a regression fitted line and determine the correlation coefficient. | |
| Provide a practical interpretation of the results. | |
| 3-2 Excel Homework II: Descriptive Statistics | |
| This homework assignment will continue to familiarize you with the Excel software, creating graphs, and using the Data Analysis add-in feature. | |
| In this assignment, you will create a histogram plot from a given set of data and then determine the mean, median, and standard deviation. | |
| Provide a practical interpretation of the results. | |
| 6-2 Excel Homework III: Amortization Table | |
| This homework assignment will continue to familiarize you with the Excel software. | |
| In this assignment, you will create an amortization table based on a given principal, interest rate, and payment longevity. | |
| Analyze alternative criteria to determine the optimal conditions. | |
| 7-2 Excel Homework IV: Probability | |
| This homework assignment will continue to familiarize you with the Excel software. | |
| In this assignment, you will analyze a given business problem based on probability. | |
| Provide a practical interpretation of the results. |
Template - Amortization
| NEWS has decided to purchase a new parcel of land in order to expand operations into a brand-new facility and retake the competitive advantage. | |||||||||||
| The Amortization Schedule below has been generated for your use in this assignment and in future professional/personal endeavors. | |||||||||||
| NOTE: Payment is calculated by using the PMT function in Excel, based on a given interest rate, total periods, present value borrowed (-), and future value | |||||||||||
| Question 1: NEWS would like to compare two different parcels, each of which is tied to a specific lender and the lender's terms. | |||||||||||
| Parcel GREEN has the following conditions: Cost = $ 10,000,000; Annual Interest Rate = 11%; Loan Term = 25 Years | |||||||||||
| Parcel BLUE has the following conditions: Cost = $ 7,500,000; Annual Interest Rate = 20%; Loan Term = 15 Years | |||||||||||
| Provide your recommendation on which option is the best option and why. | |||||||||||
| ANSWER: | |||||||||||
| Question 2: How does your answer change if NEWS is concerned with short-term profit margins? | |||||||||||
| How does your answer change if NEWS is concerned with long-term debt, due to a poor book value rating from the most recent stock analysis? | |||||||||||
| ANSWER: | |||||||||||
| Amount Borrowed (Present Value) | $ 10,000,000.00 | Amount Borrowed (Present Value) | $ 7,500,000.00 | ||||||||
| Future Value | $ - 0 | Future Value | $ - 0 | ||||||||
| Years | 25 | Years | 15 | ||||||||
| Payments per Year | 12 | Payments per Year | 12 | ||||||||
| Total Periods | 300 | Total Periods | 180 | ||||||||
| Annual Interest Rate | 11.00% | Annual Interest Rate | 20.00% | ||||||||
| Compound Rate | 0.92% | Compound Rate | 1.67% | ||||||||
| Payment Amount | $98,011.31 | Payment Amount | $131,722.24 | ||||||||
| Payment Number | Payment | Interest | Principal | Balance | Payment Number | Payment | Interest | Principal | Balance | ||
| 1 | $98,011.31 | $ 91,666.67 | $ 6,344.64 | $ 9,993,655.36 | 1 | $131,722.24 | $ 125,000.00 | $6,722.24 | $ 7,493,277.76 | ||
| 2 | $98,011.31 | $ 91,608.51 | $ 6,402.80 | $ 9,987,252.56 | 2 | $131,722.24 | $ 124,887.96 | $6,834.28 | $ 7,486,443.49 | ||
| 3 | $98,011.31 | $ 91,549.82 | $ 6,461.49 | $ 9,980,791.07 | 3 | $131,722.24 | $ 124,774.06 | $6,948.18 | $ 7,479,495.31 | ||
| 4 | $98,011.31 | $ 91,490.58 | $ 6,520.72 | $ 9,974,270.34 | 4 | $131,722.24 | $ 124,658.26 | $7,063.98 | $ 7,472,431.33 | ||
| 5 | $98,011.31 | $ 91,430.81 | $ 6,580.50 | $ 9,967,689.85 | 5 | $131,722.24 | $ 124,540.52 | $7,181.72 | $ 7,465,249.61 | ||
| 6 | $98,011.31 | $ 91,370.49 | $ 6,640.82 | $ 9,961,049.03 | 6 | $131,722.24 | $ 124,420.83 | $7,301.41 | $ 7,457,948.20 | ||
| 7 | $98,011.31 | $ 91,309.62 | $ 6,701.69 | $ 9,954,347.34 | 7 | $131,722.24 | $ 124,299.14 | $7,423.10 | $ 7,450,525.10 | ||
| 8 | $98,011.31 | $ 91,248.18 | $ 6,763.12 | $ 9,947,584.21 | 8 | $131,722.24 | $ 124,175.42 | $7,546.82 | $ 7,442,978.28 | ||
| 9 | $98,011.31 | $ 91,186.19 | $ 6,825.12 | $ 9,940,759.10 | 9 | $131,722.24 | $ 124,049.64 | $7,672.60 | $ 7,435,305.68 | ||
| 10 | $98,011.31 | $ 91,123.63 | $ 6,887.68 | $ 9,933,871.41 | 10 | $131,722.24 | $ 123,921.76 | $7,800.48 | $ 7,427,505.20 | ||
| 11 | $98,011.31 | $ 91,060.49 | $ 6,950.82 | $ 9,926,920.59 | 11 | $131,722.24 | $ 123,791.75 | $7,930.48 | $ 7,419,574.72 | ||
| 12 | $98,011.31 | $ 90,996.77 | $ 7,014.54 | $ 9,919,906.06 | 12 | $131,722.24 | $ 123,659.58 | $8,062.66 | $ 7,411,512.06 | ||
| 13 | $98,011.31 | $ 90,932.47 | $ 7,078.84 | $ 9,912,827.22 | 13 | $131,722.24 | $ 123,525.20 | $8,197.04 | $ 7,403,315.02 | ||
| 14 | $98,011.31 | $ 90,867.58 | $ 7,143.72 | $ 9,905,683.50 | 14 | $131,722.24 | $ 123,388.58 | $8,333.65 | $ 7,394,981.37 | ||
| 15 | $98,011.31 | $ 90,802.10 | $ 7,209.21 | $ 9,898,474.29 | 15 | $131,722.24 | $ 123,249.69 | $8,472.55 | $ 7,386,508.82 | ||
| 16 | $98,011.31 | $ 90,736.01 | $ 7,275.29 | $ 9,891,198.99 | 16 | $131,722.24 | $ 123,108.48 | $8,613.76 | $ 7,377,895.06 | ||
| 17 | $98,011.31 | $ 90,669.32 | $ 7,341.98 | $ 9,883,857.01 | 17 | $131,722.24 | $ 122,964.92 | $8,757.32 | $ 7,369,137.74 | ||
| 18 | $98,011.31 | $ 90,602.02 | $ 7,409.29 | $ 9,876,447.73 | 18 | $131,722.24 | $ 122,818.96 | $8,903.28 | $ 7,360,234.47 | ||
| 19 | $98,011.31 | $ 90,534.10 | $ 7,477.20 | $ 9,868,970.52 | 19 | $131,722.24 | $ 122,670.57 | $9,051.66 | $ 7,351,182.80 | ||
| 20 | $98,011.31 | $ 90,465.56 | $ 7,545.74 | $ 9,861,424.78 | 20 | $131,722.24 | $ 122,519.71 | $9,202.52 | $ 7,341,980.28 | ||
| 21 | $98,011.31 | $ 90,396.39 | $ 7,614.91 | $ 9,853,809.86 | 21 | $131,722.24 | $ 122,366.34 | $9,355.90 | $ 7,332,624.38 | ||
| 22 | $98,011.31 | $ 90,326.59 | $ 7,684.72 | $ 9,846,125.15 | 22 | $131,722.24 | $ 122,210.41 | $9,511.83 | $ 7,323,112.55 | ||
| 23 | $98,011.31 | $ 90,256.15 | $ 7,755.16 | $ 9,838,369.99 | 23 | $131,722.24 | $ 122,051.88 | $9,670.36 | $ 7,313,442.19 | ||
| 24 | $98,011.31 | $ 90,185.06 | $ 7,826.25 | $ 9,830,543.74 | 24 | $131,722.24 | $ 121,890.70 | $9,831.53 | $ 7,303,610.65 | ||
| 25 | $98,011.31 | $ 90,113.32 | $ 7,897.99 | $ 9,822,645.75 | 25 | $131,722.24 | $ 121,726.84 | $9,995.39 | $ 7,293,615.26 | ||
| 26 | $98,011.31 | $ 90,040.92 | $ 7,970.39 | $ 9,814,675.36 | 26 | $131,722.24 | $ 121,560.25 | $10,161.98 | $ 7,283,453.27 | ||
| 27 | $98,011.31 | $ 89,967.86 | $ 8,043.45 | $ 9,806,631.91 | 27 | $131,722.24 | $ 121,390.89 | $10,331.35 | $ 7,273,121.92 | ||
| 28 | $98,011.31 | $ 89,894.13 | $ 8,117.18 | $ 9,798,514.73 | 28 | $131,722.24 | $ 121,218.70 | $10,503.54 | $ 7,262,618.39 | ||
| 29 | $98,011.31 | $ 89,819.72 | $ 8,191.59 | $ 9,790,323.14 | 29 | $131,722.24 | $ 121,043.64 | $10,678.60 | $ 7,251,939.79 | ||
| 30 | $98,011.31 | $ 89,744.63 | $ 8,266.68 | $ 9,782,056.46 | 30 | $131,722.24 | $ 120,865.66 | $10,856.57 | $ 7,241,083.21 | ||
| 31 | $98,011.31 | $ 89,668.85 | $ 8,342.46 | $ 9,773,714.00 | 31 | $131,722.24 | $ 120,684.72 | $11,037.52 | $ 7,230,045.70 | ||
| 32 | $98,011.31 | $ 89,592.38 | $ 8,418.93 | $ 9,765,295.07 | 32 | $131,722.24 | $ 120,500.76 | $11,221.48 | $ 7,218,824.22 | ||
| 33 | $98,011.31 | $ 89,515.20 | $ 8,496.10 | $ 9,756,798.97 | 33 | $131,722.24 | $ 120,313.74 | $11,408.50 | $ 7,207,415.72 | ||
| 34 | $98,011.31 | $ 89,437.32 | $ 8,573.98 | $ 9,748,224.98 | 34 | $131,722.24 | $ 120,123.60 | $11,598.64 | $ 7,195,817.08 | ||
| 35 | $98,011.31 | $ 89,358.73 | $ 8,652.58 | $ 9,739,572.41 | 35 | $131,722.24 | $ 119,930.28 | $11,791.95 | $ 7,184,025.12 | ||
| 36 | $98,011.31 | $ 89,279.41 | $ 8,731.89 | $ 9,730,840.51 | 36 | $131,722.24 | $ 119,733.75 | $11,988.49 | $ 7,172,036.64 | ||
| 37 | $98,011.31 | $ 89,199.37 | $ 8,811.94 | $ 9,722,028.58 | 37 | $131,722.24 | $ 119,533.94 | $12,188.29 | $ 7,159,848.34 | ||
| 38 | $98,011.31 | $ 89,118.60 | $ 8,892.71 | $ 9,713,135.86 | 38 | $131,722.24 | $ 119,330.81 | $12,391.43 | $ 7,147,456.91 | ||
| 39 | $98,011.31 | $ 89,037.08 | $ 8,974.23 | $ 9,704,161.63 | 39 | $131,722.24 | $ 119,124.28 | $12,597.96 | $ 7,134,858.96 | ||
| 40 | $98,011.31 | $ 88,954.81 | $ 9,056.49 | $ 9,695,105.14 | 40 | $131,722.24 | $ 118,914.32 | $12,807.92 | $ 7,122,051.03 | ||
| 41 | $98,011.31 | $ 88,871.80 | $ 9,139.51 | $ 9,685,965.63 | 41 | $131,722.24 | $ 118,700.85 | $13,021.39 | $ 7,109,029.65 | ||
| 42 | $98,011.31 | $ 88,788.02 | $ 9,223.29 | $ 9,676,742.34 | 42 | $131,722.24 | $ 118,483.83 | $13,238.41 | $ 7,095,791.24 | ||
| 43 | $98,011.31 | $ 88,703.47 | $ 9,307.84 | $ 9,667,434.51 | 43 | $131,722.24 | $ 118,263.19 | $13,459.05 | $ 7,082,332.19 | ||
| 44 | $98,011.31 | $ 88,618.15 | $ 9,393.16 | $ 9,658,041.35 | 44 | $131,722.24 | $ 118,038.87 | $13,683.37 | $ 7,068,648.82 | ||
| 45 | $98,011.31 | $ 88,532.05 | $ 9,479.26 | $ 9,648,562.09 | 45 | $131,722.24 | $ 117,810.81 | $13,911.42 | $ 7,054,737.39 | ||
| 46 | $98,011.31 | $ 88,445.15 | $ 9,566.16 | $ 9,638,995.93 | 46 | $131,722.24 | $ 117,578.96 | $14,143.28 | $ 7,040,594.11 | ||
| 47 | $98,011.31 | $ 88,357.46 | $ 9,653.84 | $ 9,629,342.09 | 47 | $131,722.24 | $ 117,343.24 | $14,379.00 | $ 7,026,215.11 | ||
| 48 | $98,011.31 | $ 88,268.97 | $ 9,742.34 | $ 9,619,599.75 | 48 | $131,722.24 | $ 117,103.59 | $14,618.65 | $ 7,011,596.46 | ||
| 49 | $98,011.31 | $ 88,179.66 | $ 9,831.64 | $ 9,609,768.10 | 49 | $131,722.24 | $ 116,859.94 | $14,862.30 | $ 6,996,734.16 | ||
| 50 | $98,011.31 | $ 88,089.54 | $ 9,921.77 | $ 9,599,846.34 | 50 | $131,722.24 | $ 116,612.24 | $15,110.00 | $ 6,981,624.16 | ||
| 51 | $98,011.31 | $ 87,998.59 | $ 10,012.72 | $ 9,589,833.62 | 51 | $131,722.24 | $ 116,360.40 | $15,361.84 | $ 6,966,262.32 | ||
| 52 | $98,011.31 | $ 87,906.81 | $ 10,104.50 | $ 9,579,729.12 | 52 | $131,722.24 | $ 116,104.37 | $15,617.87 | $ 6,950,644.46 | ||
| 53 | $98,011.31 | $ 87,814.18 | $ 10,197.12 | $ 9,569,532.00 | 53 | $131,722.24 | $ 115,844.07 | $15,878.16 | $ 6,934,766.29 | ||
| 54 | $98,011.31 | $ 87,720.71 | $ 10,290.60 | $ 9,559,241.40 | 54 | $131,722.24 | $ 115,579.44 | $16,142.80 | $ 6,918,623.50 | ||
| 55 | $98,011.31 | $ 87,626.38 | $ 10,384.93 | $ 9,548,856.47 | 55 | $131,722.24 | $ 115,310.39 | $16,411.85 | $ 6,902,211.65 | ||
| 56 | $98,011.31 | $ 87,531.18 | $ 10,480.12 | $ 9,538,376.35 | 56 | $131,722.24 | $ 115,036.86 | $16,685.38 | $ 6,885,526.27 | ||
| 57 | $98,011.31 | $ 87,435.12 | $ 10,576.19 | $ 9,527,800.16 | 57 | $131,722.24 | $ 114,758.77 | $16,963.47 | $ 6,868,562.81 | ||
| 58 | $98,011.31 | $ 87,338.17 | $ 10,673.14 | $ 9,517,127.02 | 58 | $131,722.24 | $ 114,476.05 | $17,246.19 | $ 6,851,316.61 | ||
| 59 | $98,011.31 | $ 87,240.33 | $ 10,770.98 | $ 9,506,356.04 | 59 | $131,722.24 | $ 114,188.61 | $17,533.63 | $ 6,833,782.99 | ||
| 60 | $98,011.31 | $ 87,141.60 | $ 10,869.71 | $ 9,495,486.33 | 60 | $131,722.24 | $ 113,896.38 | $17,825.85 | $ 6,815,957.13 | ||
| 61 | $98,011.31 | $ 87,041.96 | $ 10,969.35 | $ 9,484,516.98 | 61 | $131,722.24 | $ 113,599.29 | $18,122.95 | $ 6,797,834.18 | ||
| 62 | $98,011.31 | $ 86,941.41 | $ 11,069.90 | $ 9,473,447.08 | 62 | $131,722.24 | $ 113,297.24 | $18,425.00 | $ 6,779,409.18 | ||
| 63 | $98,011.31 | $ 86,839.93 | $ 11,171.38 | $ 9,462,275.70 | 63 | $131,722.24 | $ 112,990.15 | $18,732.08 | $ 6,760,677.09 | ||
| 64 | $98,011.31 | $ 86,737.53 | $ 11,273.78 | $ 9,451,001.92 | 64 | $131,722.24 | $ 112,677.95 | $19,044.29 | $ 6,741,632.81 | ||
| 65 | $98,011.31 | $ 86,634.18 | $ 11,377.12 | $ 9,439,624.80 | 65 | $131,722.24 | $ 112,360.55 | $19,361.69 | $ 6,722,271.12 | ||
| 66 | $98,011.31 | $ 86,529.89 | $ 11,481.41 | $ 9,428,143.38 | 66 | $131,722.24 | $ 112,037.85 | $19,684.39 | $ 6,702,586.73 | ||
| 67 | $98,011.31 | $ 86,424.65 | $ 11,586.66 | $ 9,416,556.72 | 67 | $131,722.24 | $ 111,709.78 | $20,012.46 | $ 6,682,574.27 | ||
| 68 | $98,011.31 | $ 86,318.44 | $ 11,692.87 | $ 9,404,863.85 | 68 | $131,722.24 | $ 111,376.24 | $20,346.00 | $ 6,662,228.27 | ||
| 69 | $98,011.31 | $ 86,211.25 | $ 11,800.06 | $ 9,393,063.80 | 69 | $131,722.24 | $ 111,037.14 | $20,685.10 | $ 6,641,543.17 | ||
| 70 | $98,011.31 | $ 86,103.08 | $ 11,908.22 | $ 9,381,155.57 | 70 | $131,722.24 | $ 110,692.39 | $21,029.85 | $ 6,620,513.32 | ||
| 71 | $98,011.31 | $ 85,993.93 | $ 12,017.38 | $ 9,369,138.19 | 71 | $131,722.24 | $ 110,341.89 | $21,380.35 | $ 6,599,132.97 | ||
| 72 | $98,011.31 | $ 85,883.77 | $ 12,127.54 | $ 9,357,010.65 | 72 | $131,722.24 | $ 109,985.55 | $21,736.69 | $ 6,577,396.28 | ||
| 73 | $98,011.31 | $ 85,772.60 | $ 12,238.71 | $ 9,344,771.94 | 73 | $131,722.24 | $ 109,623.27 | $22,098.97 | $ 6,555,297.32 | ||
| 74 | $98,011.31 | $ 85,660.41 | $ 12,350.90 | $ 9,332,421.04 | 74 | $131,722.24 | $ 109,254.96 | $22,467.28 | $ 6,532,830.04 | ||
| 75 | $98,011.31 | $ 85,547.19 | $ 12,464.11 | $ 9,319,956.93 | 75 | $131,722.24 | $ 108,880.50 | $22,841.74 | $ 6,509,988.30 | ||
| 76 | $98,011.31 | $ 85,432.94 | $ 12,578.37 | $ 9,307,378.56 | 76 | $131,722.24 | $ 108,499.80 | $23,222.43 | $ 6,486,765.87 | ||
| 77 | $98,011.31 | $ 85,317.64 | $ 12,693.67 | $ 9,294,684.89 | 77 | $131,722.24 | $ 108,112.76 | $23,609.47 | $ 6,463,156.39 | ||
| 78 | $98,011.31 | $ 85,201.28 | $ 12,810.03 | $ 9,281,874.86 | 78 | $131,722.24 | $ 107,719.27 | $24,002.96 | $ 6,439,153.43 | ||
| 79 | $98,011.31 | $ 85,083.85 | $ 12,927.45 | $ 9,268,947.40 | 79 | $131,722.24 | $ 107,319.22 | $24,403.01 | $ 6,414,750.41 | ||
| 80 | $98,011.31 | $ 84,965.35 | $ 13,045.96 | $ 9,255,901.45 | 80 | $131,722.24 | $ 106,912.51 | $24,809.73 | $ 6,389,940.68 | ||
| 81 | $98,011.31 | $ 84,845.76 | $ 13,165.54 | $ 9,242,735.90 | 81 | $131,722.24 | $ 106,499.01 | $25,223.23 | $ 6,364,717.46 | ||
| 82 | $98,011.31 | $ 84,725.08 | $ 13,286.23 | $ 9,229,449.67 | 82 | $131,722.24 | $ 106,078.62 | $25,643.61 | $ 6,339,073.84 | ||
| 83 | $98,011.31 | $ 84,603.29 | $ 13,408.02 | $ 9,216,041.66 | 83 | $131,722.24 | $ 105,651.23 | $26,071.01 | $ 6,313,002.84 | ||
| 84 | $98,011.31 | $ 84,480.38 | $ 13,530.93 | $ 9,202,510.73 | 84 | $131,722.24 | $ 105,216.71 | $26,505.52 | $ 6,286,497.31 | ||
| 85 | $98,011.31 | $ 84,356.35 | $ 13,654.96 | $ 9,188,855.77 | 85 | $131,722.24 | $ 104,774.96 | $26,947.28 | $ 6,259,550.03 | ||
| 86 | $98,011.31 | $ 84,231.18 | $ 13,780.13 | $ 9,175,075.64 | 86 | $131,722.24 | $ 104,325.83 | $27,396.40 | $ 6,232,153.63 | ||
| 87 | $98,011.31 | $ 84,104.86 | $ 13,906.45 | $ 9,161,169.19 | 87 | $131,722.24 | $ 103,869.23 | $27,853.01 | $ 6,204,300.61 | ||
| 88 | $98,011.31 | $ 83,977.38 | $ 14,033.92 | $ 9,147,135.27 | 88 | $131,722.24 | $ 103,405.01 | $28,317.23 | $ 6,175,983.39 | ||
| 89 | $98,011.31 | $ 83,848.74 | $ 14,162.57 | $ 9,132,972.70 | 89 | $131,722.24 | $ 102,933.06 | $28,789.18 | $ 6,147,194.21 | ||
| 90 | $98,011.31 | $ 83,718.92 | $ 14,292.39 | $ 9,118,680.31 | 90 | $131,722.24 | $ 102,453.24 | $29,269.00 | $ 6,117,925.21 | ||
| 91 | $98,011.31 | $ 83,587.90 | $ 14,423.40 | $ 9,104,256.91 | 91 | $131,722.24 | $ 101,965.42 | $29,756.82 | $ 6,088,168.39 | ||
| 92 | $98,011.31 | $ 83,455.69 | $ 14,555.62 | $ 9,089,701.29 | 92 | $131,722.24 | $ 101,469.47 | $30,252.76 | $ 6,057,915.62 | ||
| 93 | $98,011.31 | $ 83,322.26 | $ 14,689.05 | $ 9,075,012.24 | 93 | $131,722.24 | $ 100,965.26 | $30,756.98 | $ 6,027,158.65 | ||
| 94 | $98,011.31 | $ 83,187.61 | $ 14,823.70 | $ 9,060,188.55 | 94 | $131,722.24 | $ 100,452.64 | $31,269.59 | $ 5,995,889.05 | ||
| 95 | $98,011.31 | $ 83,051.73 | $ 14,959.58 | $ 9,045,228.97 | 95 | $131,722.24 | $ 99,931.48 | $31,790.75 | $ 5,964,098.30 | ||
| 96 | $98,011.31 | $ 82,914.60 | $ 15,096.71 | $ 9,030,132.26 | 96 | $131,722.24 | $ 99,401.64 | $32,320.60 | $ 5,931,777.70 | ||
| 97 | $98,011.31 | $ 82,776.21 | $ 15,235.10 | $ 9,014,897.16 | 97 | $131,722.24 | $ 98,862.96 | $32,859.28 | $ 5,898,918.42 | ||
| 98 | $98,011.31 | $ 82,636.56 | $ 15,374.75 | $ 8,999,522.41 | 98 | $131,722.24 | $ 98,315.31 | $33,406.93 | $ 5,865,511.49 | ||
| 99 | $98,011.31 | $ 82,495.62 | $ 15,515.69 | $ 8,984,006.73 | 99 | $131,722.24 | $ 97,758.52 | $33,963.71 | $ 5,831,547.78 | ||
| 100 | $98,011.31 | $ 82,353.39 | $ 15,657.91 | $ 8,968,348.81 | 100 | $131,722.24 | $ 97,192.46 | $34,529.77 | $ 5,797,018.00 | ||
| 101 | $98,011.31 | $ 82,209.86 | $ 15,801.44 | $ 8,952,547.37 | 101 | $131,722.24 | $ 96,616.97 | $35,105.27 | $ 5,761,912.73 | ||
| 102 | $98,011.31 | $ 82,065.02 | $ 15,946.29 | $ 8,936,601.08 | 102 | $131,722.24 | $ 96,031.88 | $35,690.36 | $ 5,726,222.37 | ||
| 103 | $98,011.31 | $ 81,918.84 | $ 16,092.46 | $ 8,920,508.61 | 103 | $131,722.24 | $ 95,437.04 | $36,285.20 | $ 5,689,937.18 | ||
| 104 | $98,011.31 | $ 81,771.33 | $ 16,239.98 | $ 8,904,268.64 | 104 | $131,722.24 | $ 94,832.29 | $36,889.95 | $ 5,653,047.23 | ||
| 105 | $98,011.31 | $ 81,622.46 | $ 16,388.85 | $ 8,887,879.79 | 105 | $131,722.24 | $ 94,217.45 | $37,504.78 | $ 5,615,542.44 | ||
| 106 | $98,011.31 | $ 81,472.23 | $ 16,539.08 | $ 8,871,340.71 | 106 | $131,722.24 | $ 93,592.37 | $38,129.86 | $ 5,577,412.58 | ||
| 107 | $98,011.31 | $ 81,320.62 | $ 16,690.68 | $ 8,854,650.03 | 107 | $131,722.24 | $ 92,956.88 | $38,765.36 | $ 5,538,647.22 | ||
| 108 | $98,011.31 | $ 81,167.63 | $ 16,843.68 | $ 8,837,806.35 | 108 | $131,722.24 | $ 92,310.79 | $39,411.45 | $ 5,499,235.77 | ||
| 109 | $98,011.31 | $ 81,013.22 | $ 16,998.08 | $ 8,820,808.26 | 109 | $131,722.24 | $ 91,653.93 | $40,068.31 | $ 5,459,167.46 | ||
| 110 | $98,011.31 | $ 80,857.41 | $ 17,153.90 | $ 8,803,654.37 | 110 | $131,722.24 | $ 90,986.12 | $40,736.11 | $ 5,418,431.34 | ||
| 111 | $98,011.31 | $ 80,700.17 | $ 17,311.14 | $ 8,786,343.22 | 111 | $131,722.24 | $ 90,307.19 | $41,415.05 | $ 5,377,016.29 | ||
| 112 | $98,011.31 | $ 80,541.48 | $ 17,469.83 | $ 8,768,873.40 | 112 | $131,722.24 | $ 89,616.94 | $42,105.30 | $ 5,334,911.00 | ||
| 113 | $98,011.31 | $ 80,381.34 | $ 17,629.97 | $ 8,751,243.43 | 113 | $131,722.24 | $ 88,915.18 | $42,807.05 | $ 5,292,103.94 | ||
| 114 | $98,011.31 | $ 80,219.73 | $ 17,791.58 | $ 8,733,451.85 | 114 | $131,722.24 | $ 88,201.73 | $43,520.51 | $ 5,248,583.44 | ||
| 115 | $98,011.31 | $ 80,056.64 | $ 17,954.67 | $ 8,715,497.19 | 115 | $131,722.24 | $ 87,476.39 | $44,245.85 | $ 5,204,337.59 | ||
| 116 | $98,011.31 | $ 79,892.06 | $ 18,119.25 | $ 8,697,377.94 | 116 | $131,722.24 | $ 86,738.96 | $44,983.28 | $ 5,159,354.31 | ||
| 117 | $98,011.31 | $ 79,725.96 | $ 18,285.34 | $ 8,679,092.59 | 117 | $131,722.24 | $ 85,989.24 | $45,733.00 | $ 5,113,621.31 | ||
| 118 | $98,011.31 | $ 79,558.35 | $ 18,452.96 | $ 8,660,639.63 | 118 | $131,722.24 | $ 85,227.02 | $46,495.22 | $ 5,067,126.10 | ||
| 119 | $98,011.31 | $ 79,389.20 | $ 18,622.11 | $ 8,642,017.52 | 119 | $131,722.24 | $ 84,452.10 | $47,270.14 | $ 5,019,855.96 | ||
| 120 | $98,011.31 | $ 79,218.49 | $ 18,792.81 | $ 8,623,224.71 | 120 | $131,722.24 | $ 83,664.27 | $48,057.97 | $ 4,971,797.99 |
