Discussion

profileprajwalbc53
ClassProject2020-20216.xlsx

START HERE

&"-,Bold"AVIA 360&"-,Regular" &"-,Italic"2017 Spring Semester Corporate & Business Aviation

START HERE: Rarely does a company jump into the commitments of a large scale corporate flight department. Costs associated with equipment, operations, and personnel can be breathtaking to the unaccustomed financial controller. Most flight departments grow over a period of time, and many have rich histories that help to justify aircraft upgrades and growth. This file goes slightly against this conventional wisdom. Within the City-Pair Analysis worksheet tab, a ficticious stone and aggregate copany is comparing their airline demand to an on-demand model of transportation. The data contained in the large data table on this worksheet represents the level of travel of one "key traveler," the Chief Operations Officer (COO). The total level of travel for the company is purposely augmented to help with the outcomes of this assignment. In reality, this ficticious company would probably already have an aircraft or be leaning heavily on some other method of on-demand transportation. The blue worksheet tabs below represent worksheets that will be used on course assignments and have input fields. Other tabs contain key course related materials and will also be used for course assignments. You should plan to follow specific assignment instructions that will refer to and guide you through this Excel file with these multiple worksheets. Below is a quick summary of each tab so you may begin to familiarize yourself with content and layout.

Aircraft Feasibility Study

City-Pair Analysis Tab: Read the instructions at the top of the worksheet. The yellow dropdown / input cell is where you would click to select a specific airframe. The output cells will automatically populate. Notice how different aircraft can influence Aircraft Hours.

Aircraft Data Tab: This is the database for the Excel file. Feel free to scroll and compare airframes here; especially when you want to compare a specific data set across the entire database. New aircraft are listed in the top-half of the database with a "n" preceeding the name. Used aircraft are listed in the bottom half, with the year of manufacture preceeding the name.

RV Analysis Tab: This tab provides an output which compares the Value Factor to Purchase Price. This analysis is only done with new aircraft. Value Factor is calculated as follows: (Maximum Speed x Maximum Range x Maximum Cabin Volume) / 10,000 = Value Factor Value Factor is on the vertical axis and purchase price is on the horizonal axis. The main objective of this type of analysis is to help generate questions about the market, value, and resale.

Quick Compare Tab: This tab allows you to select up to six airframes from the database and perform a horizontal analysis on twenty-nine variables that include different specifications and performance parameters.

Product Timeline Tab: This worksheet provides a general idea of turboprop and turbojet aircraft available to a potential buyer. The chart depicts product lines from a variety of manufacturers as well as their respective production years.

Selection Matrix Tab: This worksheet allows you to select five different airframes and score them within a subjective matrix. Matrix categories and subcategory values are derived from key traveler interviews. Select your airframe(s) at the top using the dropdown lists. 1. Values in the yellow cells indicate the weight of importance. Scale of 1 to 4 (4=most important) 2. Airframe totals are automattically calculated by this formula: Weight Factor x Item Score (I.S.) = Factor Value (F.V.)

Cost of Operation Tab: This worksheet helps with the calculation of and the depiction of the cost of operation. More instructions will follow, but you will be able to select an airframe and immediately see its cost of operation compared to multiple airframes and multiple on-demand methods.

Amortization & You Pick Tabs: Both of these worksheets are amortization tables. Amortization is linked to the aircraft database and the You Pick is not. Use the You Pick worksheet to enter anything you want to see an payment schedule for. An amortization schedule is already built into the Cost of Operation worksheet.

City-Pair Analysis

AVIA 360 Corporate &
Business Aviation
City-Pair Analysis City-Pair Analysis
On-Demand Model FLIGHT TO FLIGHT FROM Airline Model FLIGHT TO FLIGHT FROM
Springfield Aircraft Trip Time Time Time Time Total Nashville Time Wait at Flight Layover Time Time Wait at Flight Layover Time Overnights Single Trip Total Total
TN Capacity Miles to Flight to Job to Flight to Trip Trip TN to Airport Time Time to Job to Airport Time Time to Req Cost Cost Cost Trip Trip
M91 Pass >4 Freq X's 2 Airport Time Site Airport Time Office Time Time Airport TSA two legs Site Airport TSA two legs Office Time Time
*Springfield TN M91 0 Nashville TN BNA 0
Cincinatti OH LUK 194.4 3 1 2 777.6 0.1 0.5 0.5 0.5 0.5 0.1 2.2 4.3 Cincinatti OH CVG 199.8 1.0 1.5 4.0 0.6 0.7 0.7 1.5 3.0 0.9 1.0 2 371 1,113 2,226.00 14.9 29.8
*Owensboro KY OWB 73.1 4 1 3 438.6 0.1 0.2 0.3 0.3 0.2 0.1 1.2 3.5 Evansville IN EVV 122 1.0 1.5 3.3 1.3 1.0 1.0 1.5 3.3 1.3 1.0 3 499 1,996 5,988.00 16.2 48.6
Greenwood IN HFY 189.6 4 1 3 1137.6 0.1 0.5 0.5 0.5 0.5 0.1 2.1 6.4 Indianapolis IN IND 216.3 1.0 1.5 2.9 0.7 1.0 1.0 1.5 2.9 0.7 1.0 3 393 1,572 4,716.00 14.2 42.6
Dupage IL DPA 328.1 4 1 1 656.2 0.1 0.8 0.5 0.5 0.8 0.1 2.8 2.8 Chicago IL ORD 355.8 1.0 1.5 1.7 0.0 0.6 0.6 1.5 1.7 0.0 1.0 1 240 960 960.00 9.6 9.6
Leesburg FL LEE 529.8 3 1 3 3178.8 0.1 1.3 0.5 0.5 1.3 0.1 3.8 11.5 Orlando FL MCO 535.8 1.0 1.5 2.6 1.5 1.0 1.0 1.5 2.6 1.5 1.0 3 210 630 1,890.00 15.2 45.6
Lake City FL LCQ 438.9 3 1 3 2633.4 0.1 1.1 0.5 0.5 1.1 0.1 3.4 10.2 Jacksonville FL JAX 420.3 1.0 1.5 2.5 1.0 1.0 1.0 1.5 2.5 1.0 1.0 3 230 690 2,070.00 14.0 42
Witham FL SUA 656.5 3 1 1 1313 0.1 1.6 0.5 0.5 1.6 0.1 4.5 4.5 Palm Beach FL PBI 658.8 1.0 1.5 3.0 1.0 1.0 1.0 1.5 3.0 1.0 1.0 1 310 930 930.00 15.0 15
*Anderson SC AND 239.4 4 1 3 1436.4 0.1 0.6 0.7 0.7 0.6 0.1 2.8 8.4 Spartanburg SC GSP 229.9 1.0 1.5 2.0 1.0 1.0 1.0 1.5 2.0 1.0 1.0 3 250 1,000 3,000.00 13.0 39
*Athens GA AHN 234.8 4 1 3 1408.8 0.1 0.6 0.5 0.5 0.6 0.1 2.4 7.1 Atlanta GA ATL 185.9 1.0 1.5 1.9 0.0 1.0 1.0 1.5 1.9 0.0 1.0 3 309 1,236 3,708.00 10.8 32.4
On-Demand Model n Learjet 70 Input Field Rock Hill SC UZA 300.2 3 1 4 2401.6 0.1 0.8 0.3 0.3 0.8 0.1 2.3 9.2 Charlotte NC CLT 284.5 1.0 1.5 1.8 0.0 1.0 1.0 1.5 1.8 0.0 1.0 4 288 864 3,456.00 10.6 42.4
Block Speed (for 300 nm trip) 400 Ouput Field *Shelby NC EHO 269.7 4 1 3 1618.2 0.1 0.7 0.5 0.5 0.7 0.1 2.5 7.6 Charlotte NC CLT 284.5 1.0 1.5 1.8 0.0 1.0 1.0 1.5 1.8 0.0 1.0 3 288 1,152 3,456.00 10.6 31.8
Expansion into OK *Effingham IL 1H2 170.2 4 1 3 1021.2 0.1 0.4 0.5 0.5 0.4 0.1 2.1 6.2 St Louis MO STL 236 1.0 1.5 2.4 0.0 1.0 1.0 1.5 2.4 0.0 1.0 3 315 1,260 3,780.00 11.8 35.4
*Mitchell IN FRH 118.9 4 1 3 713.4 0.1 0.3 0.5 0.5 0.3 0.1 1.8 5.4 Evansville IN EVV 122 1.0 1.5 3.3 1.3 1.0 1.0 1.5 3.3 1.3 1.0 3 499 1,996 5,988.00 16.2 48.6
Key Employee - COO Elizabethtown KY EKX 83.8 3 1 3 502.8 0.1 0.2 0.3 0.3 0.2 0.1 1.2 3.7 Louisville KY SDF 131 1.0 1.5 3.0 1.3 1.0 1.0 1.5 3.3 1.3 1.0 3 405 1,215 3,645.00 15.9 47.7
Employee Trip Miles 30,867.8 36,893.4 Overnights Latrobe PA LBE 418.2 4 1 4 3345.6 0.1 1.0 0.3 0.3 1.0 0.1 2.9 11.6 Pittsburgh PA PIT 400.7 1.0 1.5 2.6 1.2 0.6 0.6 1.5 2.6 1.2 1.0 4 330 1,320 5,280.00 13.8 55.2
Aircraft Hours 77.2 92.2 7 12 Washington MO FYG 229.4 4 1 4 1835.2 0.1 0.6 0.5 0.5 0.6 0.1 2.3 9.4 St.Louis MO STL 236 1.0 1.5 2.4 0.0 1.0 1.0 1.5 2.4 0.0 1.0 4 330 1,320 5,280.00 11.8 47.2
Employee Hours 142.0 169.8 Lawrence MO LWC 420.3 4 1 4 3362.4 0.1 1.1 0.7 0.7 1.1 0.1 3.7 14.8 Kansas City MO MCI 426.1 1.0 1.5 2.5 1.2 0.6 0.6 1.5 2.5 1.2 1.0 4 399 1,596 6,384.00 13.6 54.4
Time Savings using On-Demand 609.7 706.7 *Sedalia MO DMO 324.4 4 1 3 1946.4 0.1 0.8 0.5 0.5 0.8 0.1 2.8 8.5 Kansas City MO MCI 426.1 1.0 1.5 2.5 1.2 0.6 0.6 1.5 2.5 1.2 1.0 3 399 1,596 4,788.00 13.6 40.8
Combined Non-Duplicated Travel Miles Caruthersville MO M05 135 4 1 2 540 0.1 0.3 0.3 0.3 0.3 0.1 1.5 3.0 Memphis TN MEM 173.5 1.0 1.5 2.3 1.0 0.6 0.6 1.5 2.3 1.0 1.0 2 379 1,516 3,032.00 12.8 25.6
Total Trip Miles 113,977.7 120,003.3 *Union City TN UCY 100.1 4 1 3 600.6 0.1 0.3 0.3 0.3 0.3 0.1 1.3 3.9 drive 3.0 3.0 0 0 0.00 6.0 18
Total Aircraft Hours 284.9 300.0 30867.8 49.7 142.0 55 $70,577.00 259.6 751.7
*Afton OK GMJ 376.6 4 1 8 6025.6 0.1 0.9 0.7 0.7 0.9 0.1 3.5 27.9 Tulsa OK TUL 446 1.0 1.5 3.2 1.0 1.1 1.1 1.5 3.2 1.0 1.0 8 420 1,680 13,440.00 15.6 124.8
* These are cities with aggregate mines 36893.4 53.2 169.8 63 $84,017.00 15.6 124.8
Airline Model for COO Travel
Travel Hours 751.7 876.5 Overnights
Estimated Airline Travel Cost $70,577.00 $84,017.00 55 63

INSTRUCTIONS GIVEN: As you zoom out you will notice three sections to this worksheet: 1) Input and output fields to the left, 2) an on-demand city-pair analysis in the middle, and 3) an airline city-pair analysis on the right. The on-demand and airline tables to right represent the travel frequency and destinations of the Chief Operations Officer of an ficticious aggregate company. Here are some key points to understanding the data and outputs displayed on this worksheet: • In the example, the closest airport that provides airline service? KBNA, Nashville International (cell AE8) • In the example, the closest airport that may be used by a corporate aircraft? M91, Springfield Robertson Co. (cell N8) • The difference in cities (Column N to Column AE) is due to airports available for on-demand that are closer to job site. • To get started, click in the top yellow input field and select an aircraft from the drop down menu. • When you select an aircraft Cell D19 will auto fill and clear the error "X" • Notice the impact of your selected aircraft to the City-Pair data • The top three textboxes are On-Demand model outputs, while the bottom textbox is the output for the Airline model. • Aircraft listed in the drop-down are either new "n", remanufactured "r", or used (year of manufacture) preceeding the make and model.

Aircraft Data

Aircraft Data Source: Permission given by
Business & Commercial Aviation Magazine
https://aviationweek.com/business-aviation Long Range High Speed 300 NM Trip 600 NM Trip 1,000 NM Trip Variable Fixed
Cost Costs
Cabin Sea Long Long Specific Long High High Specific High Max Max Other Total
Volume Wing Max Ramp Maximum Av. Payload Max Fuel Level Range Range Range Range Speed Speed Range Speed Certified Payload Direct Trip Fuel Block DOC/ Direct Trip Fuel Block DOC/ Direct Trip Fuel Block DOC/ Hull + Lib Crew Crew Hangar Services / Fixed 2019
Age Make / Model Price Value Factor Seating cu.ft. Loading Weight Payload w Max Fuel Range Takeoff TAS Fuel Flow NM/lb fuel Altitude TAS Fuel Flow NM/lb fuel Altitude Altitude Range Cost Time Used Altitude Speed Hour Cost Time Used Altitude Speed Hour Cost Time Used Altitude Speed Hour Maint. Insurance Salaries Training Office Support Costs Age
2019 n Daher Kodiak 2,454,725 7,382 1+6 341.3 30.2 7,305 2,073 744 1,236 1,468 164 251 0.653 12000 175 335 0.522 12000 25000 na 961 1:47 587 12000 168 $538.88 1876 3:30 1140 12000 171 $536.00 3096 5:47 1878 12000 173 $535.33 107 20965 110000 12000 17000 30000 189965 2019 0
2019 n Piper M500 2,040,000 4,232 1+4 196.7 27.8 5,134 1,216 340 834 2,438 179 135 1.326 28000 258 242 1.066 28000 30000 na 658 1:22 379 28000 220 $481.46 1185 2:32 660 28000 237 $467.76 1968 4:18 985 28000 233 $457.67 98 18000 110000 12000 17000 30000 187000 2019 0
2019 n Piper M600 2,928,000 7,578 1+4 196.7 28.7 6,050 1,000 458 1,406 2,635 184 155 1.187 28000 274 324 0.846 28000 30000 na 699 1:22 429 28000 220 $511.46 1247 2:31 735 28000 238 $495.50 2097 4:06 1142 28000 244 $511.46 98 19000 110000 12000 17000 30000 188000 2019 0
2019 n Grand Caravan EX 2,527,900 6,013 1+9 398.3 31.3 8,842 2,642 1,086 816 2,160 156 328 0.476 10000 185 437 0.423 10000 25000 na 878 1:41 750 10000 178 $521.58 1717 3:19 1462 10000 181 $517.69 na na na na na na 79 21225 110000 12000 17000 30000 190225 2019 0
2019 n TBM 930 4,194,390 12,291 1+5 246.0 38.2 7,430 1,203 584 1,514 2,380 252 241 1.046 31000 330 412 0.801 26000 31000 1514 596 1:00 440 28000 300 $596.00 1132 1:55 830 28000 313 $590.61 1828 3:10 1320 29000 316 $577.26 82 34150 110000 12000 17000 30000 203150 2019 0
2019 n Pilatus PC12 NG 4,963,400 18,588 1+7 405.6 37.6 10,495 2,257 1,009 1,608 2,600 225 268 0.840 30000 285 497 0.573 20000 30000 1608 797 1:10 549 26000 257 $683.14 1473 2:16 975 27000 265 $649.85 2365 3:46 1520 28000 265 $627.88 156 31230 112300 12000 17000 30000 202530 2019 0
2019 r Nextant G90XT 2,750,000 10,377 1+7 267.8 34.4 10,560 2,450 787 1,369 2,100 213 292 0.729 28000 283 578 0.490 24000 30000 1290 1163 1:06 584 22000 273 $1,057.27 2320 2:12 1162 28000 273 $1,054.55 3858 3:39 1938 28000 274 $1,056.99 379 22700 149000 16000 17000 33000 237700 2019 0
2019 n Vulcanair SpA 3,237,140 4,673 1+7 260.9 33.0 6,669 1,771 1,332 837 2,034 169 261 0.648 10000 214 375 0.571 10000 25000 837 556 1:35 419 10000 189 $351.16 1154 3:18 866 10000 182 $349.70 na na na na na na 116 21050 110000 12000 17000 33000 193050 2019 0
2019 n King AirC90GTx 3,775,000 7,556 1+7 267.8 35.5 10,545 2,113 707 1,045 1,984 208 332 0.627 26000 270 612 0.441 20000 30000 975 1147 1:13 748 21000 247 $942.74 2147 2:22 1353 23000 254 $907.18 3363 3:57 1990 27000 253 $851.39 195 27300 112300 12000 21000 33000 205600 2019 0
2019 n King Air 250 6,295,000 15,878 1+8 360.7 40.3 12,590 2,170 115 1,420 2,111 256 430 0.595 35000 310 750 0.413 26000 35000 1038 1221 1:03 869 25000 286 $1,162.86 2218 2:03 1494 29000 293 $1,081.95 3439 3:28 2147 33000 288 $992.02 195 27220 112300 12000 21000 33000 205520 2019 0
2019 n Piaggio P180 Evo 7,695,000 37,895 1+7 619.2 70.3 12,150 1,425 973 1,530 3,262 318 408 0.779 41000 400 792 0.505 31000 41000 1510 964 0:53 688 31000 340 $1,091.32 1723 1:44 1144 35000 346 $994.04 2687 3:02 1603 39000 330 $885.82 195 47320 115200 24000 21000 33000 240520 2019 0
2019 n King Air 350i 7,345,000 20,501 1+9 421.2 48.4 15,100 2,545 1,534 1,560 3,300 235 362 0.649 33000 312 773 0.404 24000 35000 1533 1222 1:02 881 25000 290 $1,182.58 2187 2:02 1470 29000 295 $1,075.57 3389 3:27 2102 33000 290 $982.32 195 41600 115200 24000 21000 33000 234800 2019 0
2019 n Cirrus SF-50 1,960,000 7,493 1+4 204.9 30.7 6,040 1,128 268 1,219 2,036 256 358 0.715 28000 300 466 0.644 28000 28000 796 626 1:10 568 28000 257 $536.57 1155 2:15 1033 28000 267 $513.33 1840 3:36 1642 28000 278 $511.11 50 15790 115200 24000 17000 33000 204990 2019 0
2019 n Eclipse 550 2,495,000 8,668 1+4 197.4 41.0 6,034 999 431 1,190 2,394 334 321 1.040 41000 369 462 0.799 35000 41000 825 641 0:58 456 35000 310 $663.10 1018 1:46 837 39000 340 $576.23 1780 3:04 1137 41000 326 $580.43 89 15500 110000 24000 17000 35000 201500 2019 0
2019 n Phenom 100EV 4,495,000 13,996 1+5 274.9 53.1 10,748 1,775 647 1,254 3,190 340 543 0.626 41000 406 955 0.425 33000 41000 1092 993 0:53 753 39000 340 $1,124.15 1757 1:45 1236 39000 343 $1,004.00 2806 2:54 1919 41000 345 $967.59 144 27800 135300 24000 21000 35000 243100 2019 0
2019 n Citation M2 4,700,000 14,226 1+7 253.4 44.6 10,800 1,410 514 1,400 3,210 323 516 0.626 41000 401 920 0.436 35000 41000 1183 1076 0:52 804 37000 346 $1,241.54 1902 1:38 1362 39000 367 $1,164.49 2952 2:42 2018 41000 370 $1,093.33 192 27800 135300 24000 21000 35000 243100 2019 0
2019 n Honda HA-420 4,900,000 16,563 1+5 290.4 60.0 10,680 1,350 385 1,358 3,934 360 558 0.645 43000 420 972 0.432 33000 43000 1065 967 0:53 676 43000 340 $1,094.72 1711 1:38 1179 43000 367 $1,047.55 2745 2:40 1863 43000 375 $1,029.38 202 17800 135300 24000 21000 35000 233100 2019 0
2019 r Nextant 400XTi 4,650,000 32,277 2+7 364.5 67.6 16,500 2,050 638 1,981 3,821 406 740 0.549 45000 447 968 0.462 43000 45000 1801 1428 0:48 786 39000 375 $1,785.00 2553 1:30 1323 43000 400 $1,702.00 4174 2:28 2145 45000 405 $1,692.16 661 36300 135300 27000 21000 35000 254600 2019 0
2019 n Citation CJ3+ 8,295,000 28,520 1+8 361.7 47.2 14,070 1,970 820 1,900 3,180 352 624 0.564 45000 415 1197 0.347 35000 45000 1825 1192 0:49 969 37000 367 $1,459.59 2058 1:35 1571 41000 379 $1,299.79 3162 2:36 2315 43000 385 $1,216.15 172 35200 135300 27000 21000 35000 253500 2019 0
2019 n Syberjet SJ30i 8,306,452 33,444 1+5 264.0 73.2 14,050 1,583 283 2,667 3,939 436 684 0.637 45000 475 1188 0.400 36000 49000 2205 1030 0:45 846 41000 400 $1,373.33 1720 1:26 1313 45000 419 $1,200.00 2678 2:21 1980 45000 426 $1,139.57 217 37500 135300 27000 21000 38000 258800 2019 0
2019 n Pilatus PC-24 8,900,000 44,554 1+8 476.9 54.0 18,068 3,019 1,233 2,143 2,810 346 711 0.487 45000 436 1790 0.244 30000 45000 2035 1251 0:49 1010 41000 367 $1,531.84 2179 1:33 1678 45000 387 $1,405.81 3570 2:29 2785 45000 403 $1,437.58 184 38700 168000 27000 22000 38000 293700 2019 0
2019 n Citation CJ4 9,195,000 34,443 1+9 398.6 51.8 17,230 2,220 1,122 1,955 3,140 377 812 0.464 45000 442 1470 0.301 37000 45000 1927 1279 0:46 1087 39000 391 $1,668.26 2263 1:27 1865 41000 414 $1,560.69 3458 2:23 2747 43000 420 $1,450.91 182 38900 135300 27000 22000 38000 261200 2019 0
2019 n Phenom 300 9,450,000 37,880 1+7 429.8 60.0 18,497 2,637 1,561 1,985 3,254 383 757 0.506 45000 444 1312 0.338 35000 45000 1936 1270 0:47 1058 39000 383 $1,621.28 2184 1:29 1735 41000 404 $1,472.36 3274 2:26 2471 45000 411 $1,345.48 171 38900 135300 27000 22000 38000 261200 2019 0
2019 n Learjet 70 11,300,000 42,983 2+6 442.3 69.6 21,750 2,100 1,788 2,150 4,440 437 970 0.451 47000 452 1080 0.419 47000 51000 2045 1408 0:45 1072 47000 400 $1,877.33 2468 1:24 1805 47000 429 $1,762.86 3907 2:18 2787 47000 435 $1,698.70 106 52300 180200 30000 35000 201000 498500 2019 0
2019 n Citation XLS+ 13,050,000 47,638 2+9 579.9 54.6 20,400 2,240 800 1,906 3,560 353 865 0.408 45000 431 1238 0.348 41000 45000 1841 1575 0:46 1239 39000 391 $2,054.35 2775 1:28 2081 41000 409 $1,892.05 4396 2:26 3198 43000 411 $1,806.58 308 53000 180200 30000 35000 199700 497900 2019 0
2019 n Learjet 75 13,800,000 47,510 2+8 494.8 69.6 21,750 1,950 1,638 2,129 4,440 437 977 0.447 47000 451 1079 0.418 47000 51000 2026 1440 0:45 1075 47000 400 $1,920.00 2515 1:23 1810 47000 434 $1,818.07 4003 2:18 2792 47000 435 $1,740.43 106 58800 190000 30000 35000 245600 559400 2019 0
2019 n Citation Latitude 16,650,000 98,760 2+9 837.1 56.8 31,050 2,544 1,000 2,731 3,580 368 1114 0.330 43000 432 1765 0.245 39000 45000 2678 1900 0:46 1610 39000 391 $2,478.26 3232 1:29 2573 43000 404 $2,178.88 5099 2:25 3989 43000 414 $2,109.93 182 52800 190000 30000 35000 270800 578600 2019 0
2019 n Legacy 450 16,570,000 115,445 2+7 840.5 74.0 35,891 2,921 800 2,973 3,907 438 1404 0.312 45000 462 1621 0.285 43000 45000 2904 1820 0:45 1543 45000 400 $2,426.67 3091 1:26 2478 45000 419 $2,156.51 4778 2:21 3710 45000 426 $2,033.19 165 55400 210000 30000 35000 277000 607400 2019 0
2019 n Citation Sovergn+ 17,895,000 111,510 2+9 793.2 56.7 31,025 2,765 1,400 3,138 3,530 368 1059 0.347 45000 448 1756 0.255 39000 47000 3069 1790 0:45 1506 39000 400 $2,386.67 3032 1:26 2404 43000 419 $2,115.35 4814 2:21 3750 43000 426 $2,048.51 171 54700 210000 30000 35000 215000 544700 2019 0
2019 n Legacy 500 19,995,000 144,786 2+8 983.3 79.4 38,537 2,800 1,779 3,153 4,084 440 1441 0.305 45000 467 1741 0.268 43000 45000 3125 1848 0:45 1545 45000 400 $2,464.00 3142 1:26 2478 45000 419 $2,192.09 4895 2:21 3750 45000 426 $2,082.98 168 58700 250000 30000 35000 275000 648700 2019 0
2019 n Citation X+ 23,365,000 142,260 2+9 790.0 69.4 36,900 2,864 1,855 3,463 5,250 470 1470 0.320 47000 520 2453 0.212 41000 51000 3372 2164 0:41 1827 37000 439 $3,166.83 3643 1:16 2937 43000 474 $2,876.05 5820 2:02 4680 43000 492 $2,862.30 273 65200 250000 30000 35000 266100 646300 2019 0
2019 n Gulfstream G280 24,500,000 194,916 2+9 1,085.9 80.0 39,750 4,000 950 3,724 4,750 459 1488 0.308 45000 482 1925 0.250 43000 45000 3646 2016 0:47 1505 45000 383 $2,573.62 3408 1:26 2412 45000 419 $2,377.67 5284 2:18 3645 45000 435 $2,297.39 254 54100 250000 30000 35000 267900 637000 2019 0
2019 n Legacy 650E 25,900,000 320,680 2+13 1,755.4 97.2 53,727 4,939 1,910 3,980 5,741 425 1901 0.224 41000 459 2570 0.179 37000 41000 3919 2206 0:49 1773 41000 367 $2,701.22 4023 1:34 3146 41000 383 $2,567.87 6298 2:33 4815 41000 392 $2,469.80 317 56100 250000 76000 35000 331900 749000 2019 0
2019 n Challenger 350 26,673,000 169,200 2+10 1,088.6 77.6 40,750 3,400 1,905 3,307 4,829 459 1590 0.289 45000 470 1832 0.257 43000 45000 3250 1946 0:47 1583 45000 383 $2,484.26 3298 1:26 2577 45000 419 $2,300.93 5120 2:18 3925 45000 435 $2,226.09 131 58200 250000 76000 35000 271000 690200 2019 0
2019 n Falcon 2000S 29,950,000 217,943 2+10 1,250.8 77.7 41,200 4,950 1,850 3,615 4,325 437 1400 0.312 47000 482 2075 0.232 41000 47000 3540 1940 0:47 1525 47000 383 $2,476.60 3297 1:27 2465 47000 414 $2,273.79 5131 2:20 3755 47000 429 $2,199.00 339 60800 250000 76000 35000 331900 753700 2019 0
2006 2006 Piper Meridian 875,000 4,575 1+4 196.7 27.8 5,134 1,173 318 905 2,438 178 135 1.319 28000 257 242 1.062 28000 30000 470 1580.46 1:20 379 28000 225 $1,185.35 3160.93 2:40 662 28000 225 $1,185.35 4592 4:04 1028 28000 246 $1,129.18 603 15900 78930 91250 11464 30000 227544 2006 13
1983 1983 King Air B100 520,000 13,747 1+7 360.7 42.2 11,875 1,886 1,012 1,422 2,951 261 540 0.483 21000 268 710 0.377 12000 31000 1153 1103.04 1:15 798 21000 240 $882.43 2282.07 2:35 1368 21000 232 $883.38 3680.97 4:10 2129 30000 240 $883.43 334 8200 105000 12000 15610 35000 175810 1983 36
1983 1983 Piper Cheyenne II 505,000 5,920 1+6 151.7 39.3 9,050 1,434 725 1,379 1,980 253 392 0.645 29000 283 688 0.411 12000 31000 1072 1158.82 1:28 710 21000 205 $790.10 2095.87 2:39 1175 21000 226 $790.89 3346.25 4:14 1795 30000 236 $790.45 354 11200 105000 12000 17000 35000 180200 1983 36
1981 1981 King Air E90 550,000 9,214 1+7 274.3 34.5 10,160 2,460 352 1,349 2,010 241 478 0.504 24000 249 672 0.371 14000 27600 820 938.36 1:06 430 24000 273 $853.05 2126.81 2:25 1134 24000 248 $880.06 4122.35 4:29 2126 24000 223 $919.48 337 8950 105000 12000 17000 35000 177950 1981 38
1981 1981 Merlin IIIC 700,000 18,529 1+8 264.5 47.7 12,600 4,287 45 2,312 2,400 271 437 0.620 28000 303 710 0.427 15000 31000 1839 898.19 1:06 617 25000 273 $816.54 1809.71 2:13 1078 25000 271 $816.41 3010.77 3:41 1693 30000 271 $817.40 617 14900 105000 12000 17000 35000 183900 1981 38
1981 1981 King Air 200 600,000 17,505 1+8 360.7 41.3 12,590 2,258 803 1,691 3,300 263 474 0.555 31000 287 876 0.328 14000 32800 430 967.3 1:07 604 31000 269 $866.24 1920.05 2:12 1144 31000 273 $872.75 3161.73 4:06 2045 31000 244 $771.15 275 8800 105000 12000 17000 35000 177800 1981 38
1985 1985 Mitsubishi MU2 600,000 11,654 1+8 248.6 65.0 11,625 1,965 940 1,527 2,700 276 449 0.615 29000 307 700 0.439 16000 31000 997 939.63 1:07 647 25000 269 $841.46 1781.07 2:08 1145 29000 281 $834.88 2964.37 3:31 1850 29000 284 $842.95 352 19100 105000 12000 17000 35000 188100 1985 34
1992 1992 King Air C90B 800,000 7,408 1+7 267.8 34.4 10,160 2,562 760 1,120 2,577 194 316 0.614 23000 247 592 0.417 16000 30000 219 954.88 1:20 712 20000 225 $716.16 1863.84 2:36 1298 22000 231 $716.86 3094.9 4:19 2050 23000 232 $716.97 244 10200 105000 12000 17000 35000 179200 1992 27
1991 1991 Piper Cheyenne IIIA 975,000 15,718 1+8 332.9 38.2 11,285 2,122 305 1,548 2,380 223 345 0.646 28000 305 746 0.409 22000 35000 592 1071.94 1:08 749 28000 265 $945.83 2035.82 2:09 1350 28000 279 $946.89 3329.73 3:31 2158 28000 284 $946.84 381 18700 105000 12000 17000 35000 187700 1991 28
1986 1986 Cessna Conquest I 900,000 7,431 1+6 209.6 38.2 8,675 1,636 859 1,343 2,490 258 406 0.635 26000 264 536 0.493 18000 30000 833 865.57 1:16 641 26000 237 $683.34 1655.02 2:27 1120 26000 245 $675.52 2685.33 4:02 1767 26000 248 $665.78 259 10900 105000 12000 17000 35000 179900 1986 33
2008 2008 Eclipse 500 1,100,000 7,109 1+4 148.1 39.0 5,680 1,050 550 1,280 2,155 331 284 1.165 41000 375 472 0.794 31000 41000 637 625.23 0:54 622 18000 333 $694.70 1108.97 1:43 899 29000 350 $646.00 1667.41 2:55 1144 37000 343 $571.68 175 7400 78930 91250 11464 35000 224044 2008 11
1995 1995 King Air B200SE 1,225,000 17,907 1+7 360.7 41.3 12,590 2,950 895 1,706 2,579 226 368 0.614 29000 291 700 0.416 22000 35000 408 982.61 1:07 797 24000 269 $879.95 1937.97 2:12 1311 29000 273 $880.90 3200.97 3:37 2084 29000 276 $885.06 281 9800 105000 12000 17000 35000 178800 1995 24
2002 2002 TBM 700B 1,250,000 11,033 1+5 246.0 34.9 6,614 1,501 227 1,495 2,136 237 236 1.004 28000 300 364 0.824 26000 31000 967 571.89 1:07 309 28000 269 $512.14 1102.53 2:09 648 28000 279 $512.80 1820.1 3:33 1103 28000 282 $512.70 163 14000 105000 12000 17000 30000 178000 2002 17
1985 1985 Twin Commander 1000 1,250,000 14,961 1+7 244.0 40.1 11,250 1,401 475 2,037 2,131 281 385 0.730 35000 301 646 0.466 20000 35000 1305 1026.13 1:12 603 28000 250 $855.11 1810.27 2:16 1015 28000 265 $798.65 2890.78 3:42 1569 35000 270 $781.29 389 22700 105000 12000 17000 35000 191700 1985 34
1994 1994 King Air 300LW 1,400,000 19,135 1+7 360.7 41.3 12,600 2,770 259 1,684 1,992 231 382 0.605 29000 315 750 0.420 26000 35000 114 1061.04 1:01 854 26000 295 $1,043.65 1934.45 2:00 1471 29000 300 $967.23 3127.39 3:18 2339 29000 303 $947.69 347 10600 105000 12000 17000 35000 179600 1994 25
1986 1986 Cessna Conquest II 1,400,000 15,500 1+8 251.2 38.8 9,925 2,400 642 2,106 2,465 287 372 0.772 33000 293 510 0.575 24000 35000 1357 894.91 1:12 599 27000 250 $745.76 1689.11 2:15 987 27000 267 $750.72 2751.91 3:39 1510 33000 274 $753.95 314 14400 105000 12000 17000 35000 183400 1986 33
2008 2008 Grand Caravan 1,425,000 6,044 1+9 398.2 31.3 8,785 2,959 1,303 834 2,420 154 291 0.529 10000 182 379 0.480 10000 25000 678 1280 1:43 667 10000 175 $745.63 2708.72 3:22 1295 10000 178 $804.57 415 14400 78930 91250 11464 35000 231044 2008 11
2002 2002 Piaggio P180 1,900,000 30,796 1+7 498.8 67.0 11,600 1,830 1,128 1,575 2,850 311 387 0.804 39000 392 781 0.502 28000 41000 960 863.12 0:53 658 31000 340 $977.12 1548.01 1:44 1092 35000 346 $893.08 2420.25 3:01 1526 39000 331 $802.29 351 27500 105000 12000 17000 35000 196500 2002 17
2005 2005 Pilatus PC12/45 2,300,000 20,074 1+7 405.6 35.7 9,965 2,745 966 1,833 2,300 202 226 0.894 30000 270 453 0.596 22000 30000 1416 816.39 1:15 487 30000 240 $653.11 1578.68 2:25 876 30000 248 $653.25 2612.1 4:00 1398 30000 250 $653.03 286 19900 105000 12000 17000 35000 188900 2005 14
2013 2013 TBM 850 2,400,000 11,414 1+5 246.0 38.2 3,500 1,252 633 1,450 2,840 255 260 0.981 31000 320 436 0.734 26000 31000 1150 958.77 1:01 480 26000 295 $943.05 1704.83 1:59 900 28000 303 $859.58 2739.67 3:15 1430 28000 308 $842.98 286 15500 78930 91250 11464 30000 227144 2013 6
2008 2008 Pilatus PC12/47 2,600,000 17,535 1+7 405.6 37.6 10,495 2,257 1,009 1,544 2,650 208 248 0.839 30000 280 491 0.570 20000 30000 1402 743.38 1:10 598 22000 257 $637.18 1385.69 2:15 1103 22000 267 $615.86 2249.26 3:43 1775 22000 269 $605.18 191 11800 105000 12000 17000 35000 180800 2008 11
1985 1985 Mitsubishi MU300 200,000 24,680 2+7 366.9 60.6 14,700 1,710 800 1,594 4,280 375 870 0.431 39000 422 1156 0.365 35000 41000 1220 1249.67 0:51 1101 35000 353 $1,470.20 2238.1 1:36 1841 39000 375 $1,398.81 3652 2:39 2876 39000 377 $1,378.11 449 16200 135300 27000 21000 35000 234500 1985 34
1984 1984 Learjet 25D 340,000 18,643 2+7 254.9 64.7 15,500 2,980 982 1,651 3,937 424 1411 0.300 43000 443 1565 0.283 41000 51000 1261 1642.38 0:44 1501 41000 409 $2,239.61 2903.05 1:26 2511 43000 419 $2,025.38 4204.3 2:22 3885 43000 423 $1,776.46 582 29800 135300 27000 21000 35000 248100 1984 35
1982 1982 Cessna Citation I 440,000 13,481 2+6 267.5 42.5 12,000 2,097 817 1,444 2,930 316 697 0.453 41000 349 865 0.403 37000 41000 1153 1189.65 1:01 1154 37000 295 $1,170.15 2082.1 1:56 1848 39000 310 $1,076.95 3501.91 3:13 3141 39000 311 $1,088.68 289 17400 135300 27000 21000 35000 235700 1982 37
1992 1992 Beechjet 400A 600,000 24,381 2+7 366.9 66.7 16,300 2,607 995 1,480 4,290 419 898 0.467 45000 449 1159 0.387 41000 45000 728 1092.85 0:49 971 35000 367 $1,338.18 1983.81 1:31 1740 39000 396 $1,308.01 3103.12 2:26 2775 41000 411 $1,275.25 333 17900 135300 27000 21000 35000 236200 1992 27
1987 1987 Cessna Citation II 725,000 27,316 2+7 381.0 41.2 13,500 2,965 493 1,917 2,990 327 690 0.474 43000 374 1081 0.346 35000 43000 1481 1219.51 0:56 1179 37000 321 $1,306.62 2157.29 1:48 1884 40000 333 $1,198.49 3595.28 2:58 3130 43000 337 $1,211.89 309 18300 135300 27000 21000 35000 236600 1987 32
1994 1994 Cessna Citation V 975,000 30,690 2+7 418.6 46.4 16,100 2,700 829 1,717 3,160 350 740 0.473 45000 427 1526 0.280 33000 45000 863 1468.61 0:50 1208 37000 360 $1,762.33 2552.38 1:36 1955 41000 375 $1,595.24 4147.84 2:40 2894 43000 375 $1,555.44 589 19200 135300 27000 21000 35000 237500 1994 25
1992 1992 Learjet 35A 1,150,000 23,585 2+7 271.8 72.2 18,500 2,981 1,783 1,924 4,972 424 990 0.428 43000 451 1210 0.373 41000 45000 1330 1187.4 0:45 992 43000 400 $1,583.20 2158.73 1:27 1661 43000 414 $1,488.78 3597.88 2:23 2597 43000 420 $1,509.60 460 19700 135300 27000 21000 35000 238000 1992 27
2003 2003 Learjet 31A 1,450,000 19,380 2+6 368.6 64.3 17,200 2,286 1,862 1,153 3,490 420 850 0.494 47000 456 1119 0.408 43000 51000 900 1150.13 0:44 1031 43000 409 $1,568.36 1998.22 1:25 1685 45000 424 $1,410.51 3291.47 2:20 2583 47000 429 $1,410.63 426 20700 135300 27000 21000 35000 239000 2003 16
1999 1999 Cessna Citation Ultra 1,500,000 24,033 2+7 361.5 45.8 15,000 1,950 826 1,662 3,600 342 604 0.566 45000 400 1136 0.352 35000 45000 903 1330.25 0:53 1058 37000 340 $1,505.94 2301.61 1:42 1683 41000 353 $1,353.89 3827.4 2:49 2462 43000 355 $1,358.84 430 20900 135300 27000 21000 35000 239200 1999 20
2005 2005 Cessna CJ1 1,900,000 11,922 1+6 253.4 44.2 10,700 1,540 620 1,248 3,280 327 581 0.563 41000 377 825 0.457 35000 41000 686 1241.48 0:54 836 35000 333 $1,379.42 1699.83 1:47 1384 39000 336 $953.18 2859.32 3:00 2112 41000 333 $953.11 271 22200 135300 27000 21000 35000 240500 2005 14
2010 2010 Beechjet 400XP 2,450,000 23,505 2+7 364.5 67.6 16,500 2,015 603 1,433 3,906 414 938 0.441 43000 450 1255 0.359 39000 45000 750 1197.9 0:46 1099 37000 391 $1,562.48 1934.22 1:27 1860 41000 414 $1,333.94 2975.01 2:24 2769 43000 417 $1,239.59 281 22100 135300 27000 21000 35000 240400 2010 9
2006 2006 Cessna Citation Bravo 2,500,000 23,441 2+7 364.0 45.8 15,000 1,800 676 1,614 3,600 342 607 0.563 45000 399 1135 0.352 35000 45000 907 1353.89 0:53 1086 37000 340 $1,532.71 2136.26 1:42 1713 41000 353 $1,256.62 3289.71 2:49 2495 43000 355 $1,167.94 405 24200 135300 27000 21000 35000 242500 2006 13
2012 2012 Premier IA 2,600,000 24,590 1+6 400.9 50.6 12,590 1,400 320 1,360 3,792 369 662 0.557 41000 451 1203 0.375 33000 41000 787 914.46 0:48 898 37000 375 $1,143.08 1547.34 1:33 1433 41000 387 $998.28 2436.99 2:30 2231 41000 400 $974.80 207 23000 135300 27000 21000 35000 241300 2012 7
2005 2005 Cessna CJ2 2,800,000 19,765 1+7 313.3 46.9 12,500 1,500 770 1,550 3,420 351 589 0.596 45000 407 1068 0.381 35000 45000 1092 1278.16 0:51 920 37000 353 $1,503.72 1825.34 1:37 1498 41000 371 $1,129.08 3010.94 2:40 2215 43000 375 $1,129.10 337 25200 135300 27000 21000 35000 243500 2005 14
1977 1977 Corellian YT-1300 100,000,000 1.80E+21 2+6 18,000.0 75.7 250,000 200,000 200,000 1.76E+18 0 567 5 113.400 80000 567 5 113.400 80000 300000 1.76E+18 10500 0:32 2 80000 510 $19,687.50 21000 1:00 10 80000 600 $21,000.00 40000 1:30 13 80000 667 $26,666.67 1977 100000 250000 100000 45000 75000 570000 1977 42
2006 2006 Cessna Citation Encore 3,500,000 28,045 2+7 398.5 52.2 17,030 2,100 1,130 1,652 3,590 376 804 0.468 45000 426 1335 0.319 37000 45000 1152 1383.49 0:49 1076 39000 367 $1,694.07 2248.76 1:31 1830 41000 396 $1,482.70 3756.39 2:31 2715 43000 397 $1,492.61 484 37500 135300 27000 21000 35000 255800 2006 13
2009 2009 King Air 350 3,500,000 19,568 1+9 421.2 48.4 15,100 2,615 1,604 1,489 3,300 235 362 0.649 33000 312 773 0.404 24000 35000 899 1293.49 1:02 881 25000 290 $1,251.76 1852.4 2:01 1468 29000 298 $918.55 2860.96 3:26 2099 33000 291 $833.29 271 29000 115200 24000 21000 33000 222200 2009 10
2014 2014 Cessna CJ3 5,990,000 28,055 1+8 361.7 47.2 14,070 1,930 780 1,869 3,180 352 624 0.564 45000 415 1197 0.347 35000 45000 1172 937.76 0:49 972 37000 367 $1,148.28 1588.24 1:35 1576 41000 379 $1,003.10 2521.21 2:37 2324 43000 382 $963.52 225 30200 135300 27000 21000 35000 248500 2014 5
1981 1981 Sabreliner 65 400,000 68,740 2+8 543.4 63.2 24,000 1,905 1,410 2,750 5,150 401 1085 0.370 43000 460 1890 0.243 31000 45000 2745 1647.81 0:34 1058 41000 529 $2,907.90 2688.93 1:22 1951 43000 439 $1,967.51 4344.89 3:41 4597 43000 271 $1,179.61 395 51000 135300 27000 21000 35000 269300 1981 38
1990 1990 Astra 850,000 58,984 2+6 471.9 74.2 23,650 3,130 1,415 2,688 5,250 406 986 0.412 41000 465 1642 0.283 35000 45000 1983 1302.02 0:41 1107 43000 439 $1,905.40 2382.59 1:27 1829 43000 414 $1,643.17 3842.91 2:28 2824 43000 405 $1,557.94 517 30600 180200 30000 35000 55000 330800 1990 29
1991 1991 Cessna Citation III 950,000 53,668 2+7 618.2 70.5 22,200 2,000 971 1,855 5,030 422 1053 0.401 45000 468 1506 0.311 39000 51000 1446 1697.83 0:44 1421 37000 409 $2,315.22 2943.48 1:24 2272 41000 429 $2,102.49 4923.36 2:19 3331 43000 432 $2,125.19 693 30700 190100 50000 35000 55000 360800 1991 28
1986 1986 Learjet 55 990,000 53,573 2+7 460.7 77.5 21,250 2,400 1,943 2,539 5,820 419 1027 0.408 43000 458 1362 0.336 41000 51000 2342 1464.1 0:45 1086 41000 400 $1,952.13 2642.16 1:26 1798 41000 419 $1,843.37 4358.61 2:23 2733 43000 420 $1,828.79 676 30900 190100 50000 35000 55000 361000 1986 33
1995 1995 Astra SP 1,400,000 59,582 2+6 471.9 74.2 23,650 2,775 1,060 2,727 5,250 412 977 0.422 45000 463 1641 0.282 35000 45000 2010 1399.83 0:41 1185 35000 439 $2,048.53 2362.16 1:21 2126 37000 444 $1,749.75 3984.42 2:19 3053 43000 432 $1,719.89 451 32300 190100 50000 35000 55000 362400 1995 24
1995 1995 Hawker 800A 1,450,000 78,809 2+8 741.2 74.9 28,120 2,350 2,020 2,384 5,510 402 1212 0.332 41000 446 1811 0.246 37000 41000 2242 1789.36 0:46 1120 35000 391 $2,333.95 3256 1:28 1748 43000 409 $2,220.00 5296.32 2:24 2742 43000 417 $2,206.80 701 30900 190100 50000 35000 55000 361000 1995 24
2003 2003 Learjet 60 2,400,000 61,717 2+6 595.2 88.8 23,750 2,254 1,094 2,289 5,450 422 1113 0.379 43000 453 1362 0.333 41000 51000 1742 1371.24 0:44 1141 41000 409 $1,869.87 2379.08 1:24 2000 41000 429 $1,699.34 3890.44 2:17 3192 41000 438 $1,703.84 484 33900 190100 50000 35000 55000 364000 2003 16
2001 2001 Astra SPX 2,400,000 59,562 2+7 459.6 77.9 24,800 2,900 1,335 2,781 5,395 429 1117 0.384 45000 466 1429 0.326 45000 45000 2140 1340.17 0:48 1126 43000 375 $1,675.21 2329.57 1:31 1846 45000 396 $1,535.98 3788.57 2:28 2845 45000 405 $1,535.91 443 35400 210000 50000 35000 55000 385400 2001 18
2007 2007 Learjet 40 2,550,000 31,391 2+6 442.3 65.3 20,600 2,282 1,507 1,553 4,326 428 936 0.457 47000 457 1230 0.372 41000 51000 1115 1155.43 0:44 1189 39000 409 $1,575.59 1914.1 1:24 1871 43000 429 $1,367.21 3144.81 2:18 2894 43000 435 $1,367.31 187 35400 210000 50000 35000 55000 385400 2007 12
2000 2000 Cessna Citation VII 2,550,000 45,696 2+8 576.8 73.7 23,200 2,275 1,645 1,726 4,850 417 1142 0.365 43000 459 1425 0.322 41000 51000 1403 1627.7 0:44 1434 39000 409 $2,219.59 2817.86 1:24 2348 41000 429 $2,012.76 4662.94 2:19 3424 43000 432 $2,012.78 579 34300 190100 50000 35000 55000 364400 2000 19
2004 2004 Hawker 800XP 2,600,000 78,371 2+8 728.4 74.9 28,120 2,205 1,875 2,407 5,032 402 1214 0.331 39000 447 1824 0.245 37000 41000 2285 1737.18 0:49 1465 37000 367 $2,127.16 3093.29 1:31 2539 39000 396 $2,039.53 4931.27 2:25 4049 39000 414 $2,040.53 612 34000 210000 50000 35000 55000 384000 2004 15
2007 2007 Learjet 45 3,300,000 39,277 2+8 494.8 69.0 21,750 2,110 1,798 1,764 4,680 436 982 0.444 47000 450 1074 0.419 47000 51000 1557 1434.91 0:44 1206 39000 409 $1,956.70 2458.48 1:23 1977 43000 434 $1,777.21 3991.63 2:15 3123 43000 444 $1,774.06 564 36500 210000 50000 35000 55000 386500 2007 12
2004 2004 Cessna Citation Excel 3,400,000 43,024 2+8 596.9 54.1 20,200 2,260 720 1,704 3,590 366 905 0.404 45000 423 1351 0.313 39000 45000 1050 1468.83 0:47 1342 39000 383 $1,875.10 2568.19 1:31 2213 41000 396 $1,693.31 4233.5 2:30 3277 43000 400 $1,693.40 429 36100 210000 50000 35000 55000 386100 2004 15
2006 2006 Gulfstream G100 3,500,000 80,807 2+7 584.2 82.3 26,250 2,400 850 2,943 5,012 430 1187 0.362 43000 470 1735 0.271 37000 45000 2276 1223.42 0:49 1227 45000 367 $1,498.07 2113.9 1:30 1977 45000 400 $1,409.27 3437.78 2:27 3014 45000 408 $1,403.18 282 38800 281000 75000 40000 60000 494800 2006 13
2009 2009 Hawker 850XP 4,200,000 80,932 2+8 716.3 74.9 28,120 2,120 1,790 2,522 5,032 402 1168 0.344 41000 448 1826 0.245 37000 41000 2394 1335.64 0:49 1365 41000 367 $1,635.48 2372.68 1:30 2397 41000 400 $1,581.79 3789.57 2:24 3826 41000 417 $1,578.99 231 38300 281000 75000 40000 60000 494300 2009 10
2012 2012 Learjet 40XR 4,600,000 34,992 2+6 442.3 67.4 21,250 2,051 1,239 1,762 4,680 436 986 0.442 47000 449 1073 0.418 47000 51000 1367 1173.73 0:43 1250 37000 419 $1,637.76 1914.87 1:24 1925 45000 429 $1,367.76 3017.14 2:16 3003 45000 441 $1,331.09 159 36500 281000 75000 40000 60000 492500 2012 7
2008 2008 Cessna Citation XLS 5,200,000 43,089 2+9 579.9 54.6 20,400 2,300 860 1,724 3,560 354 862 0.411 45000 431 1235 0.349 41000 45000 1130 1379.43 0:46 1245 39000 391 $1,799.26 2438.67 1:29 2094 41000 404 $1,644.05 3835.89 2:26 3210 43000 411 $1,576.39 408 37900 281000 75000 40000 60000 493900 2008 11
2012 2012 Hawker 900XP 7,000,000 87,183 2+9 716.3 74.9 28,120 1,950 1,620 2,729 4,965 402 1123 0.358 41000 446 1745 0.256 37000 41000 2600 1326.03 0:47 1288 41000 383 $1,692.80 2394.72 1:29 2280 41000 404 $1,614.42 3806.47 2:23 3607 41000 420 $1,597.12 286 42100 281000 75000 40000 60000 498100 2012 7
1983 1983 Challenger 600 800,000 187,493 2+9 1,415.5 91.3 41,250 7,830 3,180 2,990 5,700 402 1675 0.240 43000 443 2010 0.220 41000 45000 2910 2762.76 0:58 1852 41000 310 $2,858.03 4568.03 1:40 2926 43000 360 $2,740.82 7341.28 2:40 4337 45000 375 $2,752.98 1090 29000 281000 75000 40000 60000 485000 1983 36
1996 1996 Falcon 50 2,300,000 121,546 2+9 845.7 77.0 38,800 3,636 1,346 3,071 4,700 410 1474 0.278 43000 468 2298 0.204 37000 49000 2422 2188.16 0:46 1864 45000 391 $2,854.12 4234.72 1:28 2956 45000 409 $2,887.31 6992.38 2:24 4461 45000 417 $2,913.49 878 32200 281000 75000 40000 60000 488200 1996 23
2012 2012 Hawker 4000 5,600,000 169,501 2+8 1,150.0 74.4 39,700 2,300 1,400 3,136 5,068 447 1653 0.270 45000 470 1852 0.254 43000 45000 2855 1760.2 0:47 1730 45000 383 $2,247.06 2955.66 1:26 2803 45000 419 $2,062.09 4584.21 2:18 4281 45000 435 $1,993.13 265 33100 281000 75000 40000 60000 489100 2012 7
2007 2007 Falcon 50EX 6,400,000 157,480 2+9 1,007.7 79.8 39,900 3,320 2,130 3,249 4,935 417 1586 0.263 43000 481 2533 0.190 39000 49000 2868 2198.1 0:47 1607 45000 383 $2,806.09 4068.2 1:27 2705 45000 414 $2,805.66 6594.3 2:21 4232 45000 426 $2,806.09 922 41700 281000 75000 40000 60000 497700 2007 12
2011 2011 Gulfstream G200 8,500,000 179,139 2+10 1,106.7 96.1 39,700 3,800 400 3,444 6,083 430 1555 0.277 41000 470 2065 0.228 37000 45000 2371 1519.57 0:48 1361 43000 375 $1,899.46 2694.26 1:30 2340 43000 400 $1,796.17 4296.84 2:26 3695 43000 411 $1,765.82 289 38300 281000 75000 40000 60000 494300 2011 8
2006 2006 Falcon 2000 8,800,000 234,750 2+8 1,489.4 78.3 41,200 5,700 2,600 3,270 5,300 418 1441 0.290 43000 482 2306 0.209 39000 47000 2311 1937.67 0:48 1527 45000 375 $2,422.09 3599.27 1:27 2498 45000 414 $2,482.26 5792.58 2:21 3836 45000 426 $2,464.93 727 47200 305000 75000 40000 60000 527200 2006 13
2013 2013 Cessna Citation Sovereign 11,500,000 99,032 2+9 793.1 58.7 30,550 2,650 1,177 2,806 3,640 397 1209 0.328 45000 445 1737 0.256 39000 47000 2276 1574.7 0:45 1489 39000 400 $2,099.60 2694.98 1:27 2399 43000 414 $1,858.61 4277.59 2:23 3751 43000 420 $1,794.79 282 46000 305000 75000 40000 60000 526000 2013 6
2014 2014 Challenger 300 17,000,000 190,630 2+9 1,256.1 74.4 39,000 3,350 1,107 3,229 4,810 459 1584 0.290 45000 470 1809 0.260 43000 45000 2522 1703.17 0:47 1578 45000 383 $2,174.26 2882.85 1:26 2568 45000 419 $2,011.29 4471.87 2:18 3910 45000 435 $1,944.29 334 45100 305000 75000 40000 60000 525100 2014 5
1987 1987 Gulfstream III 1,050,000 210,552 2+14 1,037.6 73.0 70,200 6,200 4,100 4,210 5,950 442 2325 0.190 45000 482 3050 0.158 45000 45000 3972 3588.06 0:45 3171 45000 400 $4,784.08 6347.68 1:26 4760 45000 419 $4,428.61 10407.44 2:22 6123 45000 423 $4,397.51 1181 31900 305000 75000 40000 60000 511900 1987 32
1993 1993 Challenger 601-3A 1,600,000 213,366 2+10 1,415.5 95.8 43,250 4,815 2,143 3,284 5,400 424 1670 0.254 41000 459 1890 0.243 41000 41000 2522 2440.95 0:47 1678 41000 383 $3,116.11 4182.6 1:26 2896 41000 419 $2,918.09 6651.2 2:27 4276 41000 408 $2,714.78 965 29700 305000 75000 40000 60000 509700 1993 26
1992 1992 Gulfstream GIV 3,500,000 399,186 2+14 2,008.3 77.0 73,600 3,660 1,480 4,141 5,280 459 2713 0.169 45000 480 3429 0.140 41000 45000 3685 3100.04 0:50 2800 45000 360 $3,720.05 5282.75 1:31 4336 45000 396 $3,483.13 8515.05 2:25 6416 45000 414 $3,523.47 918 32200 320000 85000 45000 65000 547200 1992 27
1990 1990 Falcon 900 3,700,000 336,196 2+12 1,861.8 86.3 45,500 3,537 1,652 3,762 5,300 428 1707 0.251 43000 480 2628 0.183 37000 51000 3263 2507.58 0:45 1869 45000 400 $3,343.44 4383.26 1:24 3082 43000 429 $3,130.90 6765.74 2:15 4752 45000 444 $3,007.00 1057 33500 320000 85000 45000 65000 548500 1990 29
2002 2002 Gulfstream GIV-SP 7,400,000 386,313 2+14 2,041.2 78.5 75,000 5,700 2,419 3,976 5,450 459 2757 0.166 45000 476 3282 0.145 41000 45000 3328 2850.72 0:45 2614 45000 400 $3,800.96 4838.69 1:25 4191 45000 424 $3,415.55 7504.93 2:17 6353 45000 438 $3,286.83 789 36100 320000 85000 45000 65000 551100 2002 17
2007 2007 Challenger 604 9,000,000 265,385 2+9 1,420.5 97.9 48,300 5,015 1,465 3,975 5,684 437 1891 0.231 41000 470 2437 0.193 37000 41000 3010 2190.34 0:47 1589 41000 383 $2,796.18 3928.24 1:27 2823 41000 414 $2,709.13 6350.22 2:19 4510 41000 432 $2,741.10 817 38500 320000 85000 45000 65000 553500 2007 12
2004 2004 Gulfstream G450 9,000,000 417,210 2+14 2,041.2 77.8 74,300 6,000 2,019 4,294 5,450 459 2585 0.178 45000 476 3060 0.156 41000 45000 3459 2534.15 0:47 2537 45000 383 $3,235.09 4239.99 1:27 4014 45000 414 $2,924.13 6537.57 2:19 6037 45000 432 $2,821.97 349 34300 320000 85000 45000 65000 549300 2004 15
2004 2004 Falcon 900C 10,000,000 341,437 2+12 1,861.8 86.3 45,700 2,945 1,260 3,869 4,932 426 1783 0.239 43000 474 2384 0.199 39000 51000 3370 2375.75 0:48 1712 45000 375 $2,969.69 4306.46 1:27 2828 45000 414 $2,969.97 6970.78 2:21 4390 45000 426 $2,966.29 778 37000 320000 85000 45000 65000 552000 2004 15
2012 2012 Challnger 850 13,000,000 343,248 2+15 2,420.9 101.8 53,250 9,382 358 3,089 6,305 424 2061 0.206 39000 459 2393 0.192 37000 41000 1116 2162.32 0:48 2143 39000 375 $2,702.90 3725.96 1:28 3603 39000 409 $2,540.43 5878.63 2:21 5648 39000 426 $2,501.54 281 38900 320000 85000 45000 65000 553900 2012 7
2009 2009 Falcon 2000EX 15,500,000 288,951 2+8 1,489.4 80.0 42,400 5,425 1,465 4,025 5,585 437 1495 0.292 43000 482 2300 0.210 39000 47000 2750 1723.64 0:48 1515 45000 375 $2,154.55 2930.98 1:28 2440 47000 409 $1,998.40 4591.71 2:21 3710 47000 426 $1,953.92 297 41800 320000 85000 45000 65000 556800 2009 10
2010 2010 Falcon 900DX 18,000,000 343,290 2+12 1,861.8 88.5 46,900 5,065 2,270 3,890 4,890 435 1740 0.250 43000 474 2200 0.215 39000 51000 3090 1812.79 0:47 1605 45000 383 $2,314.20 3139.14 1:27 2675 45000 414 $2,164.92 4938.43 2:20 4150 45000 429 $2,116.47 352 45400 320000 85000 45000 65000 560400 2010 9
2002 2002 Gulfstream GV 14,500,000 713,386 2+16 2,267.5 79.6 90,900 6,100 1,506 6,447 6,110 459 2599 0.177 45000 488 3160 0.154 43000 51000 5416 7081.31 2:19 5769 51000 432 $3,056.68 722 40600 320000 85000 45000 65000 555600 2002 17
2005 2005 Global Express 16,500,000 742,601 2+13 2,500.3 93.0 95,250 5,700 1,723 5,952 5,820 488 3154 0.155 43000 499 3675 0.136 41000 51000 5201 7842.95 2:13 6622 51000 451 $3,538.17 840 42900 320000 85000 45000 65000 557900 2005 14
2011 2011 Global Express XRS 29,500,000 762,439 2+16 2,500.3 97.4 99,750 3,770 2,804 6,111 6,476 470 3043 0.154 45000 499 3789 0.132 41000 51000 5876 6872.23 2:13 6838 49000 451 $3,100.25 331 57900 320000 85000 45000 65000 572900 2011 8
https://aviationweek.com/business-aviation

RV Analysis

Make / Model Price Value Factor
My Choice $15,000,000 100000
n Daher Kodiak $2,454,725 7,382
n Piper M500 $2,040,000 4,232
n Piper M600 $2,928,000 7,578
n Grand Caravan EX $2,527,900 6,013
n TBM 930 $4,194,390 12,291
n Pilatus PC12 NG $4,963,400 18,588
r Nextant G90XT $2,750,000 10,377
n Vulcanair SpA $3,237,140 4,673
n King AirC90GTx $3,775,000 7,556
n King Air 250 $6,295,000 15,878
n Piaggio P180 Evo $7,695,000 37,895
n King Air 350i $7,345,000 20,501
n Cirrus SF-50 $1,960,000 7,493
n Eclipse 550 $2,495,000 8,668
n Phenom 100EV $4,495,000 13,996
n Citation M2 $4,700,000 14,226
n Honda HA-420 $4,900,000 16,563
r Nextant 400XTi $4,650,000 32,277
n Citation CJ3+ $8,295,000 28,520
n Syberjet SJ30i $8,306,452 33,444
n Pilatus PC-24 $8,900,000 44,554
n Citation CJ4 $9,195,000 34,443
n Phenom 300 $9,450,000 37,880
n Learjet 70 $11,300,000 42,983
n Citation XLS+ $13,050,000 47,638
n Learjet 75 $13,800,000 47,510
n Citation Latitude $16,650,000 98,760
n Legacy 450 $16,570,000 115,445
n Citation Sovergn+ $17,895,000 111,510
n Legacy 500 $19,995,000 144,786
n Citation X+ $23,365,000 142,260
n Gulfstream G280 $24,500,000 194,916
n Legacy 650E $25,900,000 320,680
n Challenger 350 $26,673,000 169,200
n Falcon 2000S $29,950,000 217,943

[CELLRANGE]

[CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] [CELLRANGE] 15000000 2454725 2040000 2928000 2527900 4194390 4963400 2750000 3237140 3775000 6295000 7695000 7345000 1960000 2495000 4495000 4700000 4900000 4650000 8295000 8306452 8900000 9195000 9450000 11300000 13050000 13800000 16650000 16570000 17895000 19995000 23365000 24500000 25900000 26673000 29950000 100000 7382.3190000000004 4232.4332400000003 7577.7494799999995 6012.7367999999997 12290.652 18587.836800000001 10376.844767999999 4673.1886199999999 7555.9769999999999 15878.013999999999 37895.040000000008 20500.646400000001 7493.1930000000002 8668.0313999999998 13995.81876 14225.876 16563.254399999998 32276.730149999999 28520.044999999998 33444.18 44554.384380000003 34443.424599999998 37879.993199999997 42982.714 47637.973139999995 47509.656920000001 98760.388319999998 115444.8603 111509.95968 144786.10683 142260.04 194915.57512000002 320679.9828 169200.00939999998 217943.14439999999 My Choice n Daher Kodiak n Piper M500 n Piper M600 n Grand Caravan EX n TBM 930 n Pilatus PC12 NG r Nextant G90XT n Vulcanair SpA n King AirC90GTx n King Air 250 n Piaggio P180 Evo n King Air 350i n Cirrus SF-50 n Eclipse 550 n Phenom 100EV n Citation M2 n Honda HA-420 r Nextant 400XTi n Citation CJ3+ n Syberjet SJ30i n Pilatus PC-24 n Citation CJ4 n Phenom 300 n Learjet 70 n Citation XLS+ n Learjet 75 n Citation Latitude n Legacy 450 n Citation Sovergn+ n Legacy 500 n Citation X+ n Gulfstream G280 n Legacy 650E n Challenger 350 n Falcon 2000S

In-Production Aircraft Only "n" = new airframe "r" = remanufactured airframe

Relative Value Analysis

Quick Compare

Make / Model Make / Model Make / Model Make / Model Make / Model Make / Model
Price $ Price Price Price Price Price Price
Value Factor/10,000 Value Factor Value Factor Value Factor Value Factor Value Factor Value Factor
Cabin Volume cu./ft cu.ft. cu.ft. cu.ft. cu.ft. cu.ft. cu.ft.
Maximum Range, NM Range Range Range Range Range Range
Maximum Cruise Speed, kts TAS TAS TAS TAS TAS TAS
Maximum Certificated Altitude, ft. Altitude Altitude Altitude Altitude Altitude Altitude
Wing Loading lb./sqft Loading Loading Loading Loading Loading Loading
Available Payload with Max Fuel, lbs. w Max Fuel w Max Fuel w Max Fuel w Max Fuel w Max Fuel w Max Fuel
Max Payload Range, NM Range Range Range Range Range Range
Long Range
TAS TAS TAS TAS TAS TAS TAS
Fuel Flow, lbs./hr Fuel Flow Fuel Flow Fuel Flow Fuel Flow Fuel Flow Fuel Flow
Specific Range, NM/lb NM/lb fuel NM/lb fuel NM/lb fuel NM/lb fuel NM/lb fuel NM/lb fuel
Altitude Altitude Altitude Altitude Altitude Altitude Altitude
High Speed
TAS TAS TAS TAS TAS TAS TAS
Fuel Flow, lbs./hr Fuel Flow Fuel Flow Fuel Flow Fuel Flow Fuel Flow Fuel Flow
Specific Range, NM/lb NM/lb fuel NM/lb fuel NM/lb fuel NM/lb fuel NM/lb fuel NM/lb fuel
Altitude Altitude Altitude Altitude Altitude Altitude Altitude
300nm Trip
Trip Time Time Time Time Time Time Time
Block Speed Speed Speed Speed Speed Speed Speed
Cruise Altitude Altitude Altitude Altitude Altitude Altitude Altitude
Direct Costs Cost Cost Cost Cost Cost Cost
600nm Trip
Trip Time Time Time Time Time Time Time
Block Speed Speed Speed Speed Speed Speed Speed
Cruise Altitude Altitude Altitude Altitude Altitude Altitude Altitude
Direct Costs Cost Cost Cost Cost Cost Cost
1000nm Trip
Trip Time Time Time Time Time Time Time
Block Speed Speed Speed Speed Speed Speed Speed
Cruise Altitude Altitude Altitude Altitude Altitude Altitude Altitude
Direct Costs Cost Cost Cost Cost Cost Cost

Product Timeline

** Bar colors represent model product lines and body styles
1950s 1960s 1970s 1980s 1990s 2000s 2010s 2020s
0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0
Textron / Cessna Aircraft Conquest I / II
Caravan 208,208B,EX à Cessna SkyCourier
510 Mustang Cessna Denali
500 Citation I 525 Citation Jet/CJ1 CJ1+ M2 à
525 CJ2 CJ2+
525 CJ3 CJ3+ à
550 Citation II Bravo 525 CJ4 à
560 Citation V Ultra Encore Encore+
560XL Excel XLS XLS+ à
650 Citation III VI / VII 680 Sovereign Sovereign+ à
680A Latitude à
700 Longitude à
750 Citation X X+ Hemisphere à on hold
2014 Textron bought Beechcraft
Beechcraft / Textron â
Model 90 A90,B90,C90,E90,F90,C90A,C90B,C90GT,C90GTI,C90GTx à
Model 99
Model 100 A100, B100
Model 200 200,200C,B200,B200CT,B200T,B200GT,250,250EP à
Model 300/350 300,350,350ER,350i à
Model 1900 1900,1900C,1900D
Model 2000 Model 390 Premier I,IA
From Mitsubishi Diamond II à Model 400 Beechjet 400,400A,400XP,400XPr
Model 750
Began as British Aerospace à Model 125 1,2,3,400,600,700,800 Model 800 Hawker 800,800XP,800XPi,850,800XPr
Model 1000 Model 900XP
Model 4000
Bombardier
Challenger 300 300,350 à
Challenger 600 CL600,CL601,CL604,CL605,650 à
Challenger 800 800,850,870
Global Express 5000,5500 à
Global Express XRS,6000,6500 à
Global 7500 à
1990 Bombardier bought Learjet
Learjet Aircraft â
Learjet 23 Learjet 24 higher MTOW
Learjet 25 24 stretch
Learjet 28/29 new wing Learjet 31 28/29 +35/36 fuselage and engines
Learjet 35/36 25+ TFE731 turbofans
Learjet 40 shorter 46 Learjet 70 à
Learjet 45 new design Learjet 75 à
Learjet 55 A, B, C Learjet 60 longer 55 + PW300
85
Embraer
Phenom 100 à
Phenom 300 à
Legacy 450,500 à
Legacy 600,650E à
Lineage 1000,100E à
Dassault Falcon
Falcon 20 **
Falcon 10 ** Falcon 100
Falcon 50*** 50,50EX
Falcon 900 *** 900,900EX,900DX,900LX à
Falcon 2000 ** 2000,200EX,2000DX,2000LX,2000LXS à
Falcon 7X *** 7X,8X à
5X** à
6X planned for 2021
Israeli Aerospace Industries
Westwind I / II
Astra Astra SP Astra SPX
Galaxy
Gulfstream and IAI
Gulfstream G100 G100,G150
Gulfstream G200 G200,G280 à
Gulfstream GI I,I-C
Gulfstream GII II,IIER
Gulfstream GIII III,IV,G300,G400,G450
Gulfstream GV GV,GV-SP,G500 à
Gulfstream G500/G600 à
Gulfstream G650 G650,G650ER à
G700 expected for 2023
Jetstream - British Aerospace
Jetstream 31
Jetstream 41
Sabreliner
Sabreliner 40 40,40A
Sabreliner 60
65
Sabreliner 75
Sabreliner 80 75A
Cirrus
SF50 à
Piper
Cheyenne I/II M 500 à
Cheyenne III/IIIA M 600 à
Cheyenne IV/400
Eclipse
Eclipse 500 Eclipse 550
Daher
TBM 700 TBM 850
TBM 900 910,930 à
à Daher purchased Quest Aircraft in 2019
Pilatus
Pilatus PC12 45,47,NG à
PC 24 à
Piaggio
Piaggio P180 Avanti, Avanti II, Evo Bankrupt
Honda
HondaJet à
Swearingen Merlin
Merlin IIA Merlin IIB
Merlin III Merlin IIIA IIIC
Merlin IV IV,IVA,IVC
Aero Commander
JetProp 840
900
980
1000
JetProp 1000B
Mitsubishi
MU-2 B,D,F,G,J,K,L,M,N,P
MU-2 Solitaire, Marquise
Diamond I,IA,II

Selection Matrix

Make / Model Make / Model Make / Model Make / Model Make / Model
Possible Total 0 Total 0 Total 0 Total 0 Total 0
Item Weight Value Value Value Value Value
Categories Scores Factor I.S. F.V. wt I.S. F.V. wt I.S. F.V. wt I.S. F.V. wt I.S. F.V. wt
Purchase Price X X X X X
Subcategories 2 0 0 X 0 0 X 0 0 X 0 0 X 0 0 X
$1 $249,999 12
$250,000 $499,999 11
$500,000 $999,999 10
$1,000,000 $1,999,999 9
$2,000,000 $2,999,999 8
$3,000,000 $3,999,999 7
$4,000,000 $4,999,999 6
$5,000,000 $5,999,999 5
$6,000,000 $7,999,999 4
$8,000,000 $9,999,999 3
$10,000,000 $12,999,999 2
$13,000,000 $100,000,000 1
Age X X X X X
0 = New Aircraft 1 0 0 X 0 0 X 0 0 X 0 0 X 0 0 X
0.0 0.9 8
1.0 2.9 7
3.0 4.9 6
5.0 6.9 5
7.0 7.9 4
9.0 10.9 3
11.0 15.9 2
16.0 20.9 1
21.0 50.0 0
Value Factor/10,000 X X X X X
1 0 0 X 0 0 X 0 0 X 0 0 X 0 0 X
46,000 1,000,000 14
43,000 45,999 13
40,000 42,999 12
37,000 39,999 11
34,000 36,999 10
31,000 33,999 9
28,000 30,999 8
25,000 27,999 7
21,000 24,999 6
17,000 20,999 5
13,000 16,999 4
9,000 12,999 3
5,000 8,999 2
500 4,999 1
Cabin Volume X X X X X
1 0 0 X 0 0 X 0 0 X 0 0 X 0 0 X
700 3,000 8
650 699 7
600 649 6
550 599 5
500 549 4
400 499 3
300 399 2
1 299 1
Wing Loading X X X X X
1 0 0 X 0 0 X 0 0 X 0 0 X 0 0 X
75.0 200.0 9
70.0 74.9 8
66.0 69.9 7
60.0 65.9 6
50.0 59.9 5
40.0 49.9 4
35.0 39.9 3
30.0 34.9 2
10.0 29.9 1
Payload with Max Fuel X X X X X
1 0 0 X 0 0 X 0 0 X 0 0 X 0 0 X
3,500 5,500 12
2,500 3,499 11
1,700 2,499 10
1,500 1,699 9
1,300 1,499 8
1,100 1,299 7
900 1,099 6
700 899 5
600 699 4
400 599 3
200 399 2
50 199 1
Range with Max Payload X X X X X
1 0 0 X 0 0 X 0 0 X 0 0 X 0 0 X
2,300 6,000 10
2,100 2,299 9
1,900 2,099 8
1,700 1,899 7
1,500 1,699 6
1,300 1,499 5
1,100 1,299 4
900 1,099 3
700 899 2
400 699 1
100 399 0
DOC/hr for 300NM Mission X X X X X
1 0 0 X 0 0 X 0 0 X 0 0 X 0 0 X
899 300 21
949 900 20
999 950 19
1,099 1,000 18
1,199 1,100 17
1,299 1,200 16
1,399 1,300 15
1,499 1,400 14
1,599 1,500 13
1,699 1,600 12
1,799 1,700 11
1,899 1,800 10
1,999 1,900 9
2,099 2,000 8
2,199 2,100 7
2,299 2,200 6
2,399 2,300 5
2,499 2,400 4
2,999 2,500 3
4,999 3,000 2
10,000 5,000 1
Maintenance Cost per Hour X X X X X
1 0 0 X 0 0 X 0 0 X 0 0 X 0 0 X
99 1 20
149 100 19
199 150 18
249 200 17
299 250 16
499 300 15
599 500 14
899 600 13
1,099 900 12
1,199 1,100 11
1,299 1,200 10
1,399 1,300 9
1,499 1,400 8
1,599 1,500 7
1,699 1,600 6
1,799 1,700 5
1,899 1,800 4
1,999 1,900 3
2,999 2,000 2
5,000 3,000 1
Totals 0 0 0 0 0

&18A&16VIA&18 360 &"Arial,Italic"Corporate & Business Aviation &12Aircraft Selection Matrix

Cost of Operation

AVIA 360
INSTRUCTIONS Enter your aircraft
Fractional Read NOTES choice in this column
1/16 50hrs Charter ˅
Em-300 Lear 60 Step 1: Select Airframe > n Pilatus PC12 NG n King Air 350i n Honda HA-420 n Phenom 300 Make / Model
Purchase Price 495,000 n/a 4,963,400 7,345,000 4,900,000 9,450,000 Price 0
Yearly Fixed Costs n/a n/a 202,530 234,800 233,100 261,200 Costs 0
Down Payment % Step 2: Input Down Payment > 20% 20% 20% 20% 20% 0%
Original Principal 3,970,720 5,876,000 3,920,000 7,560,000 X 0
Loan Term (Years) Step 3: Input Loan Term > 20 20 20 20 13 0
Annual Interest Rate Step 4: Input Rate > 7.00% 7.00% 7.00% 7.00% 7.00% 0.00%
Payments per Year Step 5: Input # of Payments/yr > 12 12 12 12 12 0
Debt Service (1 Yr) 35,354 n/a 369,419.40 546,678.79 364,700.62 703,351.19 X X
Monthly Mgmt Fee 10,729 n/a n/a n/a n/a n/a n/a
Hourly Costs (300nm) 3,500 5,000 683 1,183 1,095 1,621 Hour 0
0 164,102 0 571,949 781,479 597,801 964,551 X X
50 339,102 250,000 606,107 840,608 652,536 1,045,615 X X
100 500,000 640,264 899,737 707,272 1,126,679 X X
150 750,000 674,421 958,866 762,008 1,207,743 X X
200 1,000,000 708,578 1,017,995 816,744 1,288,807 X X
250 1,250,000 742,735 1,077,124 871,480 1,369,870 X X
300 1,500,000 776,892 1,136,253 926,216 1,450,934 X X
350 1,750,000 811,049 1,195,382 980,952 1,531,998 X X
400 2,000,000 845,207 1,254,511 1,035,687 1,613,062 X X
450 2,250,000 879,364 1,313,640 1,090,423 1,694,126 X X
500 2,500,000 913,521 1,372,769 1,145,159 1,775,189 X X
550 2,750,000 947,678 1,431,898 1,199,895 1,856,253 X X
600 3,000,000 981,835 1,491,027 1,254,631 1,937,317 X X
Data from City-Pair Analysis, includes OK expansion
120,003.3 Total Company Travel Miles < Step 6: Verify Travel Miles
120,003.3 Block Speed (300nm Trip) 257 290 340 383 X 0
Estimated Hours Step 7: Note yearly utilization > 467 413 353 313 X X
Estimated Yrly Cost Step 8: Note yearly cost > $890,758 $1,270,292 $984,611 $1,472,565 X X
Estimated Cost/Hr $1,909 $3,073 $2,787 $4,700 X X

Cost to Utilization Comparison

Fractional 0 50 100 150 200 250 300 350 400 450 500 550 600 164102 339102 Charter 0 50 100 150 200 250 300 350 400 450 50 0 550 600 0 250000 500000 750000 1000000 1250000 1500000 1750000 2000000 2250000 2500000 2750000 3000000 n Pilatus PC12 NG 0 50 100 150 200 250 300 350 400 450 500 550 600 571949.39875686937 606106.54161401221 640263.68447115505 674420.82732829789 708577.97018544073 742735.11304258369 776892.25589972653 811049.39875686937 845206.54161401221 879363.68447115505 913520.82732829801 947677.97018544073 981835.11304258369 n King Air 350i 0 50 100 150 200 250 300 350 400 450 500 550 600 781478.7854835809 840607.81774164538 899736.84999970999 958865.88225777447 1017994.914515839 1077123.9467739034 1136252.9790319679 1195382.0112900324 1254511.0435480969 1313640.0758061614 1372769.1080642259 1431898.1403222904 1491027.1725803551 n Honda HA-420 0 50 100 150 200 250 300 350 400 450 500 550 600 597800.61931511853 652536.46837172227 707272.31742832612 762008.16648492985 816744.01554153359 871479.86459813733 926215.71365474118 980951.56271134503 1035687.4117679487 1090423.2608245525 1145159.1098811561 1199894.95893776 1254630.8079943638 n Phenom 300 0 50 100 150 200 250 300 350 400 450 500 550 600 964551.19439344306 1045615.0241806771 1126678.8539679111 1207742.6837551452 1288806.5135423793 1369870.3433296133 1450934.1731168474 1531998.0029040813 1613061.8326913156 1694125.6624785494 1775189.4922657835 1856253.3220530176 1937317.1518402516 Make / Model 0 50 100 150 200 250 300 350 400 450 500 550 600 0 0 0 0 0 0 0 0 0 0 0 0 0 0 50 100 150 200 250 300 350 400 450 500 550 600 0 0 0 0 0 0 0 0 0 0 0 0 0

NOTE: Down Payment entry of 100% is equivalent to a full cash payment with no financing.

Amortization

Amortization Schedule
Given the following: Make / Model
Aircraft Price Price
Downpayment % 20% ERROR:#VALUE!
Loan Amount ERROR:#VALUE!
Term in Years 20 240
Annual Interest Rate 7.00% (.50%/month or .005/month)
Payment ERROR:#VALUE! PMT(C6/12,C5*12,-C4,0,0)
Total Total Yr End Yr End
Year Month Balance Payment Principal Interest Equity Interest Payments Principal Interest
1 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
2 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
3 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
4 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
5 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
6 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
7 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
8 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
9 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
10 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
11 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
1 12 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
13 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
14 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
15 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
16 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
17 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
18 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
19 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
20 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
21 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
22 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
23 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
2 24 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
25 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
26 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
27 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
28 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
29 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
30 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
31 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
32 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
33 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
34 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
35 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
3 36 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
37 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
38 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
39 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
40 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
41 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
42 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
43 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
44 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
45 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
46 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
47 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
4 48 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
49 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
50 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
51 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
52 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
53 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
54 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
55 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
56 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
57 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
58 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
59 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
5 60 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
61 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
62 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
63 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
64 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
65 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
66 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
67 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
68 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
69 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
70 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
71 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
6 72 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
73 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
74 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
75 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
76 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
77 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
78 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
79 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
80 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
81 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
82 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
83 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
7 84 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
85 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
86 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
87 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
88 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
89 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
90 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
91 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
92 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
93 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
94 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
95 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
8 96 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
97 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
98 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
99 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
100 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
101 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
102 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
103 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
104 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
105 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
106 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
107 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
9 108 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
109 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
110 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
111 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
112 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
113 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
114 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
115 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
116 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
117 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
118 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
119 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
10 120 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
121 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
122 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
123 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
124 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
125 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
126 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
127 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
128 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
129 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
130 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
131 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
11 132 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
133 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
134 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
135 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
136 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
137 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
138 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
139 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
140 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
141 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
142 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
143 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
12 144 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
145 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
146 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
147 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
148 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
149 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
150 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
151 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
152 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
153 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
154 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
155 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
13 156 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
157 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
158 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
159 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
160 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
161 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
162 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
163 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
164 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
165 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
166 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
167 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
14 168 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
169 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
170 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
171 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
172 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
173 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
174 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
175 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
176 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
177 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
178 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
179 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
15 180 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
181 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
182 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
183 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
184 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
185 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
186 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
187 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
188 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
189 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
190 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
191 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
16 192 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
193 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
194 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
195 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
196 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
197 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
198 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
199 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
200 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
201 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
202 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
203 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
17 204 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
205 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
206 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
207 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
208 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
209 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
210 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
211 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
212 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
213 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
214 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
215 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
18 216 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
217 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
218 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
219 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
220 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
221 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
222 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
223 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
224 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
225 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
226 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
227 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
19 228 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
229 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
230 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
231 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
232 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
233 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
234 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
235 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
236 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
237 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
238 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
239 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
20 240 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
241 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
242 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
243 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
244 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
245 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
246 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
247 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
248 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
249 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
250 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
251 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
21 252 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
253 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
254 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
255 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
256 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
257 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
258 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
259 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
260 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
261 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
262 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
263 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
22 264 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
265 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
266 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
267 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
268 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
269 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
270 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
271 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
272 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
273 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
274 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
275 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
23 276 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
277 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
278 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
279 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
280 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
281 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
282 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
283 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
284 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
285 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
286 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
287 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
24 288 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
289 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
290 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
291 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
292 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
293 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
294 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
295 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
296 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
297 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
298 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
299 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
25 300 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
301 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
302 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
303 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
304 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
305 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
306 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
307 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
308 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
309 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
310 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
311 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
26 312 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
313 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
314 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
315 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
316 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
317 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
318 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
319 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
320 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
321 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
322 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
323 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
27 324 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
325 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
326 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
327 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
328 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
329 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
330 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
331 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
332 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
333 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
334 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
335 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
28 336 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
337 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
338 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
339 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
340 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
341 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
342 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
343 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
344 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
345 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
346 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
347 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
29 348 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
349 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
350 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
351 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
352 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
353 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
354 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
355 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
356 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
357 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
358 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
359 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
30 360 ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!

You Pick

Amortization Schedule
Given the following:
Aircraft Price $300,000
Downpayment % 20% $60,000
Loan Amount $240,000
Term in Years 30 360
Annual Interest Rate 7.00% (.50%/month or .005/month)
Payment $1,596.73 PMT(C6/12,C5*12,-C4,0,0)
Total Total Yr End Yr End
Year Month Balance Payment Principal Interest Equity Interest Payments Principal Interest
1 $240,000.00 $1,596.73 $196.73 $1,400.00 $196.73 $1,400.00 $1,596.73
2 $239,803.27 $1,596.73 $197.87 $1,398.85 $394.60 $2,798.85 $3,193.45
3 $239,605.40 $1,596.73 $199.03 $1,397.70 $593.63 $4,196.55 $4,790.18
4 $239,406.37 $1,596.73 $200.19 $1,396.54 $793.82 $5,593.09 $6,386.90
5 $239,206.18 $1,596.73 $201.36 $1,395.37 $995.17 $6,988.46 $7,983.63
6 $239,004.83 $1,596.73 $202.53 $1,394.19 $1,197.70 $8,382.65 $9,580.36
7 $238,802.30 $1,596.73 $203.71 $1,393.01 $1,401.42 $9,775.67 $11,177.08
8 $238,598.58 $1,596.73 $204.90 $1,391.83 $1,606.32 $11,167.49 $12,773.81
9 $238,393.68 $1,596.73 $206.10 $1,390.63 $1,812.41 $12,558.12 $14,370.53
10 $238,187.59 $1,596.73 $207.30 $1,389.43 $2,019.71 $13,947.55 $15,967.26
11 $237,980.29 $1,596.73 $208.51 $1,388.22 $2,228.22 $15,335.77 $17,563.99
1 12 $237,771.78 $1,596.73 $209.72 $1,387.00 $2,437.94 $16,722.77 $19,160.71 $2,437.94 $16,722.77
13 $237,562.06 $1,596.73 $210.95 $1,385.78 $2,648.89 $18,108.55 $20,757.44
14 $237,351.11 $1,596.73 $212.18 $1,384.55 $2,861.07 $19,493.10 $22,354.16
15 $237,138.93 $1,596.73 $213.42 $1,383.31 $3,074.48 $20,876.41 $23,950.89
16 $236,925.52 $1,596.73 $214.66 $1,382.07 $3,289.14 $22,258.47 $25,547.62
17 $236,710.86 $1,596.73 $215.91 $1,380.81 $3,505.06 $23,639.28 $27,144.34
18 $236,494.94 $1,596.73 $217.17 $1,379.55 $3,722.23 $25,018.84 $28,741.07
19 $236,277.77 $1,596.73 $218.44 $1,378.29 $3,940.67 $26,397.13 $30,337.79
20 $236,059.33 $1,596.73 $219.71 $1,377.01 $4,160.38 $27,774.14 $31,934.52
21 $235,839.62 $1,596.73 $220.99 $1,375.73 $4,381.38 $29,149.87 $33,531.25
22 $235,618.62 $1,596.73 $222.28 $1,374.44 $4,603.66 $30,524.31 $35,127.97
23 $235,396.34 $1,596.73 $223.58 $1,373.15 $4,827.24 $31,897.46 $36,724.70
2 24 $235,172.76 $1,596.73 $224.88 $1,371.84 $5,052.13 $33,269.30 $38,321.42 $2,614.18 $16,546.53
25 $234,947.87 $1,596.73 $226.20 $1,370.53 $5,278.32 $34,639.83 $39,918.15
26 $234,721.68 $1,596.73 $227.52 $1,369.21 $5,505.84 $36,009.04 $41,514.88
27 $234,494.16 $1,596.73 $228.84 $1,367.88 $5,734.68 $37,376.92 $43,111.60
28 $234,265.32 $1,596.73 $230.18 $1,366.55 $5,964.86 $38,743.47 $44,708.33
29 $234,035.14 $1,596.73 $231.52 $1,365.20 $6,196.38 $40,108.67 $46,305.05
30 $233,803.62 $1,596.73 $232.87 $1,363.85 $6,429.25 $41,472.53 $47,901.78
31 $233,570.75 $1,596.73 $234.23 $1,362.50 $6,663.48 $42,835.02 $49,498.51
32 $233,336.52 $1,596.73 $235.60 $1,361.13 $6,899.08 $44,196.15 $51,095.23
33 $233,100.92 $1,596.73 $236.97 $1,359.76 $7,136.05 $45,555.91 $52,691.96
34 $232,863.95 $1,596.73 $238.35 $1,358.37 $7,374.40 $46,914.28 $54,288.68
35 $232,625.60 $1,596.73 $239.74 $1,356.98 $7,614.15 $48,271.26 $55,885.41
3 36 $232,385.85 $1,596.73 $241.14 $1,355.58 $7,855.29 $49,626.85 $57,482.14 $2,803.16 $16,357.55
37 $232,144.71 $1,596.73 $242.55 $1,354.18 $8,097.84 $50,981.02 $59,078.86
38 $231,902.16 $1,596.73 $243.96 $1,352.76 $8,341.80 $52,333.79 $60,675.59
39 $231,658.20 $1,596.73 $245.39 $1,351.34 $8,587.19 $53,685.13 $62,272.31
40 $231,412.81 $1,596.73 $246.82 $1,349.91 $8,834.00 $55,035.03 $63,869.04
41 $231,166.00 $1,596.73 $248.26 $1,348.47 $9,082.26 $56,383.50 $65,465.77
42 $230,917.74 $1,596.73 $249.71 $1,347.02 $9,331.97 $57,730.52 $67,062.49
43 $230,668.03 $1,596.73 $251.16 $1,345.56 $9,583.13 $59,076.09 $68,659.22
44 $230,416.87 $1,596.73 $252.63 $1,344.10 $9,835.76 $60,420.19 $70,255.94
45 $230,164.24 $1,596.73 $254.10 $1,342.62 $10,089.86 $61,762.81 $71,852.67
46 $229,910.14 $1,596.73 $255.58 $1,341.14 $10,345.44 $63,103.95 $73,449.40
47 $229,654.56 $1,596.73 $257.07 $1,339.65 $10,602.52 $64,443.60 $75,046.12
4 48 $229,397.48 $1,596.73 $258.57 $1,338.15 $10,861.09 $65,781.76 $76,642.85 $3,005.80 $16,154.91
49 $229,138.91 $1,596.73 $260.08 $1,336.64 $11,121.17 $67,118.40 $78,239.57
50 $228,878.83 $1,596.73 $261.60 $1,335.13 $11,382.77 $68,453.53 $79,836.30
51 $228,617.23 $1,596.73 $263.13 $1,333.60 $11,645.90 $69,787.13 $81,433.03
52 $228,354.10 $1,596.73 $264.66 $1,332.07 $11,910.56 $71,119.19 $83,029.75
53 $228,089.44 $1,596.73 $266.20 $1,330.52 $12,176.76 $72,449.71 $84,626.48
54 $227,823.24 $1,596.73 $267.76 $1,328.97 $12,444.52 $73,778.68 $86,223.20
55 $227,555.48 $1,596.73 $269.32 $1,327.41 $12,713.84 $75,106.09 $87,819.93
56 $227,286.16 $1,596.73 $270.89 $1,325.84 $12,984.73 $76,431.93 $89,416.66
57 $227,015.27 $1,596.73 $272.47 $1,324.26 $13,257.20 $77,756.18 $91,013.38
58 $226,742.80 $1,596.73 $274.06 $1,322.67 $13,531.26 $79,078.85 $92,610.11
59 $226,468.74 $1,596.73 $275.66 $1,321.07 $13,806.92 $80,399.92 $94,206.83
5 60 $226,193.08 $1,596.73 $277.27 $1,319.46 $14,084.18 $81,719.37 $95,803.56 $3,223.09 $15,937.62
61 $225,915.82 $1,596.73 $278.88 $1,317.84 $14,363.07 $83,037.22 $97,400.29
62 $225,636.93 $1,596.73 $280.51 $1,316.22 $14,643.58 $84,353.43 $98,997.01
63 $225,356.42 $1,596.73 $282.15 $1,314.58 $14,925.73 $85,668.01 $100,593.74
64 $225,074.27 $1,596.73 $283.79 $1,312.93 $15,209.52 $86,980.95 $102,190.46
65 $224,790.48 $1,596.73 $285.45 $1,311.28 $15,494.97 $88,292.22 $103,787.19
66 $224,505.03 $1,596.73 $287.11 $1,309.61 $15,782.08 $89,601.84 $105,383.92
67 $224,217.92 $1,596.73 $288.79 $1,307.94 $16,070.87 $90,909.77 $106,980.64
68 $223,929.13 $1,596.73 $290.47 $1,306.25 $16,361.34 $92,216.03 $108,577.37
69 $223,638.66 $1,596.73 $292.17 $1,304.56 $16,653.51 $93,520.59 $110,174.09
70 $223,346.49 $1,596.73 $293.87 $1,302.85 $16,947.38 $94,823.44 $111,770.82
71 $223,052.62 $1,596.73 $295.59 $1,301.14 $17,242.96 $96,124.58 $113,367.55
6 72 $222,757.04 $1,596.73 $297.31 $1,299.42 $17,540.27 $97,424.00 $114,964.27 $3,456.09 $15,704.62
73 $222,459.73 $1,596.73 $299.04 $1,297.68 $17,839.32 $98,721.68 $116,561.00
74 $222,160.68 $1,596.73 $300.79 $1,295.94 $18,140.11 $100,017.62 $118,157.72
75 $221,859.89 $1,596.73 $302.54 $1,294.18 $18,442.65 $101,311.80 $119,754.45
76 $221,557.35 $1,596.73 $304.31 $1,292.42 $18,746.96 $102,604.22 $121,351.18
77 $221,253.04 $1,596.73 $306.08 $1,290.64 $19,053.04 $103,894.86 $122,947.90
78 $220,946.96 $1,596.73 $307.87 $1,288.86 $19,360.91 $105,183.72 $124,544.63
79 $220,639.09 $1,596.73 $309.66 $1,287.06 $19,670.58 $106,470.78 $126,141.35
80 $220,329.42 $1,596.73 $311.47 $1,285.25 $19,982.05 $107,756.03 $127,738.08
81 $220,017.95 $1,596.73 $313.29 $1,283.44 $20,295.33 $109,039.47 $129,334.81
82 $219,704.67 $1,596.73 $315.12 $1,281.61 $20,610.45 $110,321.08 $130,931.53
83 $219,389.55 $1,596.73 $316.95 $1,279.77 $20,927.40 $111,600.85 $132,528.26
7 84 $219,072.60 $1,596.73 $318.80 $1,277.92 $21,246.21 $112,878.78 $134,124.98 $3,705.93 $15,454.78
85 $218,753.79 $1,596.73 $320.66 $1,276.06 $21,566.87 $114,154.84 $135,721.71
86 $218,433.13 $1,596.73 $322.53 $1,274.19 $21,889.40 $115,429.03 $137,318.44
87 $218,110.60 $1,596.73 $324.41 $1,272.31 $22,213.82 $116,701.35 $138,915.16
88 $217,786.18 $1,596.73 $326.31 $1,270.42 $22,540.12 $117,971.77 $140,511.89
89 $217,459.88 $1,596.73 $328.21 $1,268.52 $22,868.33 $119,240.28 $142,108.61
90 $217,131.67 $1,596.73 $330.12 $1,266.60 $23,198.46 $120,506.88 $143,705.34
91 $216,801.54 $1,596.73 $332.05 $1,264.68 $23,530.51 $121,771.56 $145,302.06
92 $216,469.49 $1,596.73 $333.99 $1,262.74 $23,864.49 $123,034.30 $146,898.79
93 $216,135.51 $1,596.73 $335.94 $1,260.79 $24,200.43 $124,295.09 $148,495.52
94 $215,799.57 $1,596.73 $337.90 $1,258.83 $24,538.32 $125,553.92 $150,092.24
95 $215,461.68 $1,596.73 $339.87 $1,256.86 $24,878.19 $126,810.78 $151,688.97
8 96 $215,121.81 $1,596.73 $341.85 $1,254.88 $25,220.04 $128,065.66 $153,285.69 $3,973.83 $15,186.88
97 $214,779.96 $1,596.73 $343.84 $1,252.88 $25,563.88 $129,318.54 $154,882.42
98 $214,436.12 $1,596.73 $345.85 $1,250.88 $25,909.73 $130,569.42 $156,479.15
99 $214,090.27 $1,596.73 $347.87 $1,248.86 $26,257.60 $131,818.28 $158,075.87
100 $213,742.40 $1,596.73 $349.90 $1,246.83 $26,607.49 $133,065.11 $159,672.60
101 $213,392.51 $1,596.73 $351.94 $1,244.79 $26,959.43 $134,309.90 $161,269.32
102 $213,040.57 $1,596.73 $353.99 $1,242.74 $27,313.42 $135,552.63 $162,866.05
103 $212,686.58 $1,596.73 $356.05 $1,240.67 $27,669.47 $136,793.30 $164,462.78
104 $212,330.53 $1,596.73 $358.13 $1,238.59 $28,027.60 $138,031.90 $166,059.50
105 $211,972.40 $1,596.73 $360.22 $1,236.51 $28,387.82 $139,268.40 $167,656.23
106 $211,612.18 $1,596.73 $362.32 $1,234.40 $28,750.15 $140,502.81 $169,252.95
107 $211,249.85 $1,596.73 $364.44 $1,232.29 $29,114.58 $141,735.10 $170,849.68
9 108 $210,885.42 $1,596.73 $366.56 $1,230.16 $29,481.14 $142,965.26 $172,446.41 $4,261.10 $14,899.61
109 $210,518.86 $1,596.73 $368.70 $1,228.03 $29,849.84 $144,193.29 $174,043.13
110 $210,150.16 $1,596.73 $370.85 $1,225.88 $30,220.69 $145,419.17 $175,639.86
111 $209,779.31 $1,596.73 $373.01 $1,223.71 $30,593.70 $146,642.88 $177,236.58
112 $209,406.30 $1,596.73 $375.19 $1,221.54 $30,968.89 $147,864.42 $178,833.31
113 $209,031.11 $1,596.73 $377.38 $1,219.35 $31,346.27 $149,083.76 $180,430.04
114 $208,653.73 $1,596.73 $379.58 $1,217.15 $31,725.85 $150,300.91 $182,026.76
115 $208,274.15 $1,596.73 $381.79 $1,214.93 $32,107.64 $151,515.84 $183,623.49
116 $207,892.36 $1,596.73 $384.02 $1,212.71 $32,491.67 $152,728.55 $185,220.21
117 $207,508.33 $1,596.73 $386.26 $1,210.47 $32,877.93 $153,939.01 $186,816.94
118 $207,122.07 $1,596.73 $388.51 $1,208.21 $33,266.44 $155,147.23 $188,413.67
119 $206,733.56 $1,596.73 $390.78 $1,205.95 $33,657.22 $156,353.17 $190,010.39
10 120 $206,342.78 $1,596.73 $393.06 $1,203.67 $34,050.28 $157,556.84 $191,607.12 $4,569.14 $14,591.57
121 $205,949.72 $1,596.73 $395.35 $1,201.37 $34,445.63 $158,758.21 $193,203.84
122 $205,554.37 $1,596.73 $397.66 $1,199.07 $34,843.29 $159,957.28 $194,800.57
123 $205,156.71 $1,596.73 $399.98 $1,196.75 $35,243.27 $161,154.03 $196,397.30
124 $204,756.73 $1,596.73 $402.31 $1,194.41 $35,645.58 $162,348.44 $197,994.02
125 $204,354.42 $1,596.73 $404.66 $1,192.07 $36,050.24 $163,540.51 $199,590.75
126 $203,949.76 $1,596.73 $407.02 $1,189.71 $36,457.26 $164,730.22 $201,187.47
127 $203,542.74 $1,596.73 $409.39 $1,187.33 $36,866.65 $165,917.55 $202,784.20
128 $203,133.35 $1,596.73 $411.78 $1,184.94 $37,278.43 $167,102.49 $204,380.93
129 $202,721.57 $1,596.73 $414.18 $1,182.54 $37,692.62 $168,285.04 $205,977.65
130 $202,307.38 $1,596.73 $416.60 $1,180.13 $38,109.22 $169,465.16 $207,574.38
131 $201,890.78 $1,596.73 $419.03 $1,177.70 $38,528.25 $170,642.86 $209,171.10
11 132 $201,471.75 $1,596.73 $421.47 $1,175.25 $38,949.72 $171,818.11 $210,767.83 $4,899.44 $14,261.27
133 $201,050.28 $1,596.73 $423.93 $1,172.79 $39,373.65 $172,990.90 $212,364.56
134 $200,626.35 $1,596.73 $426.41 $1,170.32 $39,800.06 $174,161.22 $213,961.28
135 $200,199.94 $1,596.73 $428.89 $1,167.83 $40,228.95 $175,329.06 $215,558.01
136 $199,771.05 $1,596.73 $431.39 $1,165.33 $40,660.35 $176,494.39 $217,154.73
137 $199,339.65 $1,596.73 $433.91 $1,162.81 $41,094.26 $177,657.20 $218,751.46
138 $198,905.74 $1,596.73 $436.44 $1,160.28 $41,530.70 $178,817.49 $220,348.19
139 $198,469.30 $1,596.73 $438.99 $1,157.74 $41,969.69 $179,975.22 $221,944.91
140 $198,030.31 $1,596.73 $441.55 $1,155.18 $42,411.24 $181,130.40 $223,541.64
141 $197,588.76 $1,596.73 $444.12 $1,152.60 $42,855.36 $182,283.00 $225,138.36
142 $197,144.64 $1,596.73 $446.72 $1,150.01 $43,302.08 $183,433.01 $226,735.09
143 $196,697.92 $1,596.73 $449.32 $1,147.40 $43,751.40 $184,580.42 $228,331.82
12 144 $196,248.60 $1,596.73 $451.94 $1,144.78 $44,203.34 $185,725.20 $229,928.54 $5,253.62 $13,907.09
145 $195,796.66 $1,596.73 $454.58 $1,142.15 $44,657.92 $186,867.35 $231,525.27
146 $195,342.08 $1,596.73 $457.23 $1,139.50 $45,115.15 $188,006.84 $233,121.99
147 $194,884.85 $1,596.73 $459.90 $1,136.83 $45,575.05 $189,143.67 $234,718.72
148 $194,424.95 $1,596.73 $462.58 $1,134.15 $46,037.63 $190,277.82 $236,315.45
149 $193,962.37 $1,596.73 $465.28 $1,131.45 $46,502.91 $191,409.26 $237,912.17
150 $193,497.09 $1,596.73 $467.99 $1,128.73 $46,970.90 $192,538.00 $239,508.90
151 $193,029.10 $1,596.73 $470.72 $1,126.00 $47,441.63 $193,664.00 $241,105.62
152 $192,558.37 $1,596.73 $473.47 $1,123.26 $47,915.09 $194,787.26 $242,702.35
153 $192,084.91 $1,596.73 $476.23 $1,120.50 $48,391.32 $195,907.75 $244,299.08
154 $191,608.68 $1,596.73 $479.01 $1,117.72 $48,870.33 $197,025.47 $245,895.80
155 $191,129.67 $1,596.73 $481.80 $1,114.92 $49,352.14 $198,140.39 $247,492.53
13 156 $190,647.86 $1,596.73 $484.61 $1,112.11 $49,836.75 $199,252.50 $249,089.25 $5,633.41 $13,527.31
157 $190,163.25 $1,596.73 $487.44 $1,109.29 $50,324.19 $200,361.79 $250,685.98
158 $189,675.81 $1,596.73 $490.28 $1,106.44 $50,814.47 $201,468.23 $252,282.71
159 $189,185.53 $1,596.73 $493.14 $1,103.58 $51,307.62 $202,571.81 $253,879.43
160 $188,692.38 $1,596.73 $496.02 $1,100.71 $51,803.64 $203,672.52 $255,476.16
161 $188,196.36 $1,596.73 $498.91 $1,097.81 $52,302.55 $204,770.33 $257,072.88
162 $187,697.45 $1,596.73 $501.82 $1,094.90 $52,804.38 $205,865.23 $258,669.61
163 $187,195.62 $1,596.73 $504.75 $1,091.97 $53,309.13 $206,957.21 $260,266.34
164 $186,690.87 $1,596.73 $507.70 $1,089.03 $53,816.82 $208,046.24 $261,863.06
165 $186,183.18 $1,596.73 $510.66 $1,086.07 $54,327.48 $209,132.31 $263,459.79
166 $185,672.52 $1,596.73 $513.64 $1,083.09 $54,841.12 $210,215.40 $265,056.51
167 $185,158.88 $1,596.73 $516.63 $1,080.09 $55,357.75 $211,295.49 $266,653.24
14 168 $184,642.25 $1,596.73 $519.65 $1,077.08 $55,877.40 $212,372.57 $268,249.97 $6,040.65 $13,120.07
169 $184,122.60 $1,596.73 $522.68 $1,074.05 $56,400.07 $213,446.62 $269,846.69
170 $183,599.93 $1,596.73 $525.73 $1,071.00 $56,925.80 $214,517.62 $271,443.42
171 $183,074.20 $1,596.73 $528.79 $1,067.93 $57,454.59 $215,585.55 $273,040.14
172 $182,545.41 $1,596.73 $531.88 $1,064.85 $57,986.47 $216,650.40 $274,636.87
173 $182,013.53 $1,596.73 $534.98 $1,061.75 $58,521.45 $217,712.14 $276,233.60
174 $181,478.55 $1,596.73 $538.10 $1,058.62 $59,059.55 $218,770.77 $277,830.32
175 $180,940.45 $1,596.73 $541.24 $1,055.49 $59,600.79 $219,826.26 $279,427.05
176 $180,399.21 $1,596.73 $544.40 $1,052.33 $60,145.19 $220,878.58 $281,023.77
177 $179,854.81 $1,596.73 $547.57 $1,049.15 $60,692.76 $221,927.74 $282,620.50
178 $179,307.24 $1,596.73 $550.77 $1,045.96 $61,243.53 $222,973.70 $284,217.23
179 $178,756.47 $1,596.73 $553.98 $1,042.75 $61,797.51 $224,016.44 $285,813.95
15 180 $178,202.49 $1,596.73 $557.21 $1,039.51 $62,354.72 $225,055.96 $287,410.68 $6,477.33 $12,683.39
181 $177,645.28 $1,596.73 $560.46 $1,036.26 $62,915.18 $226,092.22 $289,007.40
182 $177,084.82 $1,596.73 $563.73 $1,032.99 $63,478.91 $227,125.22 $290,604.13
183 $176,521.09 $1,596.73 $567.02 $1,029.71 $64,045.93 $228,154.92 $292,200.86
184 $175,954.07 $1,596.73 $570.33 $1,026.40 $64,616.26 $229,181.32 $293,797.58
185 $175,383.74 $1,596.73 $573.65 $1,023.07 $65,189.92 $230,204.39 $295,394.31
186 $174,810.08 $1,596.73 $577.00 $1,019.73 $65,766.92 $231,224.12 $296,991.03
187 $174,233.08 $1,596.73 $580.37 $1,016.36 $66,347.28 $232,240.48 $298,587.76
188 $173,652.72 $1,596.73 $583.75 $1,012.97 $66,931.03 $233,253.45 $300,184.49
189 $173,068.97 $1,596.73 $587.16 $1,009.57 $67,518.19 $234,263.02 $301,781.21
190 $172,481.81 $1,596.73 $590.58 $1,006.14 $68,108.77 $235,269.16 $303,377.94
191 $171,891.23 $1,596.73 $594.03 $1,002.70 $68,702.80 $236,271.86 $304,974.66
16 192 $171,297.20 $1,596.73 $597.49 $999.23 $69,300.29 $237,271.10 $306,571.39 $6,945.57 $12,215.14
193 $170,699.71 $1,596.73 $600.98 $995.75 $69,901.27 $238,266.85 $308,168.12
194 $170,098.73 $1,596.73 $604.48 $992.24 $70,505.75 $239,259.09 $309,764.84
195 $169,494.25 $1,596.73 $608.01 $988.72 $71,113.76 $240,247.80 $311,361.57
196 $168,886.24 $1,596.73 $611.56 $985.17 $71,725.32 $241,232.97 $312,958.29
197 $168,274.68 $1,596.73 $615.12 $981.60 $72,340.44 $242,214.58 $314,555.02
198 $167,659.56 $1,596.73 $618.71 $978.01 $72,959.16 $243,192.59 $316,151.75
199 $167,040.84 $1,596.73 $622.32 $974.40 $73,581.48 $244,167.00 $317,748.47
200 $166,418.52 $1,596.73 $625.95 $970.77 $74,207.43 $245,137.77 $319,345.20
201 $165,792.57 $1,596.73 $629.60 $967.12 $74,837.03 $246,104.89 $320,941.92
202 $165,162.97 $1,596.73 $633.28 $963.45 $75,470.31 $247,068.34 $322,538.65
203 $164,529.69 $1,596.73 $636.97 $959.76 $76,107.27 $248,028.10 $324,135.38
17 204 $163,892.73 $1,596.73 $640.69 $956.04 $76,747.96 $248,984.14 $325,732.10 $7,447.67 $11,713.04
205 $163,252.04 $1,596.73 $644.42 $952.30 $77,392.38 $249,936.45 $327,328.83
206 $162,607.62 $1,596.73 $648.18 $948.54 $78,040.56 $250,884.99 $328,925.55
207 $161,959.44 $1,596.73 $651.96 $944.76 $78,692.53 $251,829.75 $330,522.28
208 $161,307.47 $1,596.73 $655.77 $940.96 $79,348.29 $252,770.71 $332,119.01
209 $160,651.71 $1,596.73 $659.59 $937.13 $80,007.88 $253,707.85 $333,715.73
210 $159,992.12 $1,596.73 $663.44 $933.29 $80,671.32 $254,641.14 $335,312.46
211 $159,328.68 $1,596.73 $667.31 $929.42 $81,338.63 $255,570.55 $336,909.18
212 $158,661.37 $1,596.73 $671.20 $925.52 $82,009.83 $256,496.08 $338,505.91
213 $157,990.17 $1,596.73 $675.12 $921.61 $82,684.95 $257,417.69 $340,102.64
214 $157,315.05 $1,596.73 $679.05 $917.67 $83,364.00 $258,335.36 $341,699.36
215 $156,636.00 $1,596.73 $683.02 $913.71 $84,047.02 $259,249.07 $343,296.09
18 216 $155,952.98 $1,596.73 $687.00 $909.73 $84,734.02 $260,158.79 $344,892.81 $7,986.06 $11,174.65
217 $155,265.98 $1,596.73 $691.01 $905.72 $85,425.03 $261,064.51 $346,489.54
218 $154,574.97 $1,596.73 $695.04 $901.69 $86,120.07 $261,966.20 $348,086.27
219 $153,879.93 $1,596.73 $699.09 $897.63 $86,819.16 $262,863.83 $349,682.99
220 $153,180.84 $1,596.73 $703.17 $893.55 $87,522.33 $263,757.39 $351,279.72
221 $152,477.67 $1,596.73 $707.27 $889.45 $88,229.60 $264,646.84 $352,876.44
222 $151,770.40 $1,596.73 $711.40 $885.33 $88,941.00 $265,532.17 $354,473.17
223 $151,059.00 $1,596.73 $715.55 $881.18 $89,656.55 $266,413.35 $356,069.90
224 $150,343.45 $1,596.73 $719.72 $877.00 $90,376.27 $267,290.35 $357,666.62
225 $149,623.73 $1,596.73 $723.92 $872.81 $91,100.19 $268,163.15 $359,263.35
226 $148,899.81 $1,596.73 $728.14 $868.58 $91,828.34 $269,031.74 $360,860.07
227 $148,171.66 $1,596.73 $732.39 $864.33 $92,560.73 $269,896.07 $362,456.80
19 228 $147,439.27 $1,596.73 $736.66 $860.06 $93,297.39 $270,756.13 $364,053.53 $8,563.37 $10,597.34
229 $146,702.61 $1,596.73 $740.96 $855.77 $94,038.35 $271,611.90 $365,650.25
230 $145,961.65 $1,596.73 $745.28 $851.44 $94,783.64 $272,463.34 $367,246.98
231 $145,216.36 $1,596.73 $749.63 $847.10 $95,533.27 $273,310.44 $368,843.70
232 $144,466.73 $1,596.73 $754.00 $842.72 $96,287.27 $274,153.16 $370,440.43
233 $143,712.73 $1,596.73 $758.40 $838.32 $97,045.67 $274,991.48 $372,037.16
234 $142,954.33 $1,596.73 $762.83 $833.90 $97,808.50 $275,825.38 $373,633.88
235 $142,191.50 $1,596.73 $767.28 $829.45 $98,575.77 $276,654.83 $375,230.61
236 $141,424.23 $1,596.73 $771.75 $824.97 $99,347.52 $277,479.81 $376,827.33
237 $140,652.48 $1,596.73 $776.25 $820.47 $100,123.78 $278,300.28 $378,424.06
238 $139,876.22 $1,596.73 $780.78 $815.94 $100,904.56 $279,116.23 $380,020.79
239 $139,095.44 $1,596.73 $785.34 $811.39 $101,689.90 $279,927.62 $381,617.51
20 240 $138,310.10 $1,596.73 $789.92 $806.81 $102,479.81 $280,734.43 $383,214.24 $9,182.42 $9,978.29
241 $137,520.19 $1,596.73 $794.52 $802.20 $103,274.34 $281,536.63 $384,810.96
242 $136,725.66 $1,596.73 $799.16 $797.57 $104,073.50 $282,334.19 $386,407.69
243 $135,926.50 $1,596.73 $803.82 $792.90 $104,877.32 $283,127.10 $388,004.42
244 $135,122.68 $1,596.73 $808.51 $788.22 $105,685.83 $283,915.31 $389,601.14
245 $134,314.17 $1,596.73 $813.23 $783.50 $106,499.05 $284,698.81 $391,197.87
246 $133,500.95 $1,596.73 $817.97 $778.76 $107,317.03 $285,477.57 $392,794.59
247 $132,682.97 $1,596.73 $822.74 $773.98 $108,139.77 $286,251.55 $394,391.32
248 $131,860.23 $1,596.73 $827.54 $769.18 $108,967.31 $287,020.74 $395,988.05
249 $131,032.69 $1,596.73 $832.37 $764.36 $109,799.68 $287,785.09 $397,584.77
250 $130,200.32 $1,596.73 $837.22 $759.50 $110,636.90 $288,544.60 $399,181.50
251 $129,363.10 $1,596.73 $842.11 $754.62 $111,479.01 $289,299.21 $400,778.22
21 252 $128,520.99 $1,596.73 $847.02 $749.71 $112,326.03 $290,048.92 $402,374.95 $9,846.22 $9,314.49
253 $127,673.97 $1,596.73 $851.96 $744.76 $113,177.99 $290,793.68 $403,971.68
254 $126,822.01 $1,596.73 $856.93 $739.80 $114,034.92 $291,533.48 $405,568.40
255 $125,965.08 $1,596.73 $861.93 $734.80 $114,896.85 $292,268.28 $407,165.13
256 $125,103.15 $1,596.73 $866.96 $729.77 $115,763.81 $292,998.04 $408,761.85
257 $124,236.19 $1,596.73 $872.01 $724.71 $116,635.82 $293,722.76 $410,358.58
258 $123,364.18 $1,596.73 $877.10 $719.62 $117,512.93 $294,442.38 $411,955.31
259 $122,487.07 $1,596.73 $882.22 $714.51 $118,395.14 $295,156.89 $413,552.03
260 $121,604.86 $1,596.73 $887.36 $709.36 $119,282.51 $295,866.25 $415,148.76
261 $120,717.49 $1,596.73 $892.54 $704.19 $120,175.05 $296,570.43 $416,745.48
262 $119,824.95 $1,596.73 $897.75 $698.98 $121,072.80 $297,269.41 $418,342.21
263 $118,927.20 $1,596.73 $902.98 $693.74 $121,975.78 $297,963.16 $419,938.93
22 264 $118,024.22 $1,596.73 $908.25 $688.47 $122,884.03 $298,651.63 $421,535.66 $10,558.00 $8,602.71
265 $117,115.97 $1,596.73 $913.55 $683.18 $123,797.58 $299,334.81 $423,132.39
266 $116,202.42 $1,596.73 $918.88 $677.85 $124,716.46 $300,012.65 $424,729.11
267 $115,283.54 $1,596.73 $924.24 $672.49 $125,640.70 $300,685.14 $426,325.84
268 $114,359.30 $1,596.73 $929.63 $667.10 $126,570.33 $301,352.24 $427,922.56
269 $113,429.67 $1,596.73 $935.05 $661.67 $127,505.38 $302,013.91 $429,519.29
270 $112,494.62 $1,596.73 $940.51 $656.22 $128,445.89 $302,670.13 $431,116.02
271 $111,554.11 $1,596.73 $945.99 $650.73 $129,391.88 $303,320.86 $432,712.74
272 $110,608.12 $1,596.73 $951.51 $645.21 $130,343.39 $303,966.08 $434,309.47
273 $109,656.61 $1,596.73 $957.06 $639.66 $131,300.46 $304,605.74 $435,906.19
274 $108,699.54 $1,596.73 $962.65 $634.08 $132,263.10 $305,239.82 $437,502.92
275 $107,736.90 $1,596.73 $968.26 $628.47 $133,231.36 $305,868.28 $439,099.65
23 276 $106,768.64 $1,596.73 $973.91 $622.82 $134,205.27 $306,491.10 $440,696.37 $11,321.24 $7,839.47
277 $105,794.73 $1,596.73 $979.59 $617.14 $135,184.86 $307,108.24 $442,293.10
278 $104,815.14 $1,596.73 $985.30 $611.42 $136,170.17 $307,719.66 $443,889.82
279 $103,829.83 $1,596.73 $991.05 $605.67 $137,161.22 $308,325.33 $445,486.55
280 $102,838.78 $1,596.73 $996.83 $599.89 $138,158.05 $308,925.23 $447,083.28
281 $101,841.95 $1,596.73 $1,002.65 $594.08 $139,160.70 $309,519.30 $448,680.00
282 $100,839.30 $1,596.73 $1,008.50 $588.23 $140,169.20 $310,107.53 $450,276.73
283 $99,830.80 $1,596.73 $1,014.38 $582.35 $141,183.57 $310,689.88 $451,873.45
284 $98,816.43 $1,596.73 $1,020.30 $576.43 $142,203.87 $311,266.31 $453,470.18
285 $97,796.13 $1,596.73 $1,026.25 $570.48 $143,230.12 $311,836.79 $455,066.91
286 $96,769.88 $1,596.73 $1,032.24 $564.49 $144,262.36 $312,401.28 $456,663.63
287 $95,737.64 $1,596.73 $1,038.26 $558.47 $145,300.61 $312,959.75 $458,260.36
24 288 $94,699.39 $1,596.73 $1,044.31 $552.41 $146,344.92 $313,512.16 $459,857.08 $12,139.65 $7,021.06
289 $93,655.08 $1,596.73 $1,050.40 $546.32 $147,395.33 $314,058.48 $461,453.81
290 $92,604.67 $1,596.73 $1,056.53 $540.19 $148,451.86 $314,598.68 $463,050.54
291 $91,548.14 $1,596.73 $1,062.70 $534.03 $149,514.56 $315,132.71 $464,647.26
292 $90,485.44 $1,596.73 $1,068.89 $527.83 $150,583.45 $315,660.54 $466,243.99
293 $89,416.55 $1,596.73 $1,075.13 $521.60 $151,658.58 $316,182.13 $467,840.71
294 $88,341.42 $1,596.73 $1,081.40 $515.32 $152,739.98 $316,697.46 $469,437.44
295 $87,260.02 $1,596.73 $1,087.71 $509.02 $153,827.69 $317,206.48 $471,034.17
296 $86,172.31 $1,596.73 $1,094.05 $502.67 $154,921.74 $317,709.15 $472,630.89
297 $85,078.26 $1,596.73 $1,100.44 $496.29 $156,022.18 $318,205.44 $474,227.62
298 $83,977.82 $1,596.73 $1,106.86 $489.87 $157,129.04 $318,695.31 $475,824.34
299 $82,870.96 $1,596.73 $1,113.31 $483.41 $158,242.35 $319,178.72 $477,421.07
25 300 $81,757.65 $1,596.73 $1,119.81 $476.92 $159,362.15 $319,655.64 $479,017.80 $13,017.23 $6,143.48
301 $80,637.85 $1,596.73 $1,126.34 $470.39 $160,488.49 $320,126.03 $480,614.52
302 $79,511.51 $1,596.73 $1,132.91 $463.82 $161,621.40 $320,589.85 $482,211.25
303 $78,378.60 $1,596.73 $1,139.52 $457.21 $162,760.92 $321,047.06 $483,807.97
304 $77,239.08 $1,596.73 $1,146.16 $450.56 $163,907.08 $321,497.62 $485,404.70
305 $76,092.92 $1,596.73 $1,152.85 $443.88 $165,059.93 $321,941.49 $487,001.43
306 $74,940.07 $1,596.73 $1,159.58 $437.15 $166,219.51 $322,378.64 $488,598.15
307 $73,780.49 $1,596.73 $1,166.34 $430.39 $167,385.85 $322,809.03 $490,194.88
308 $72,614.15 $1,596.73 $1,173.14 $423.58 $168,558.99 $323,232.61 $491,791.60
309 $71,441.01 $1,596.73 $1,179.99 $416.74 $169,738.98 $323,649.35 $493,388.33
310 $70,261.02 $1,596.73 $1,186.87 $409.86 $170,925.85 $324,059.21 $494,985.06
311 $69,074.15 $1,596.73 $1,193.79 $402.93 $172,119.64 $324,462.14 $496,581.78
26 312 $67,880.36 $1,596.73 $1,200.76 $395.97 $173,320.40 $324,858.11 $498,178.51 $13,958.25 $5,202.47
313 $66,679.60 $1,596.73 $1,207.76 $388.96 $174,528.16 $325,247.07 $499,775.23
314 $65,471.84 $1,596.73 $1,214.81 $381.92 $175,742.97 $325,628.99 $501,371.96
315 $64,257.03 $1,596.73 $1,221.89 $374.83 $176,964.86 $326,003.82 $502,968.69
316 $63,035.14 $1,596.73 $1,229.02 $367.70 $178,193.88 $326,371.53 $504,565.41
317 $61,806.12 $1,596.73 $1,236.19 $360.54 $179,430.07 $326,732.06 $506,162.14
318 $60,569.93 $1,596.73 $1,243.40 $353.32 $180,673.48 $327,085.39 $507,758.86
319 $59,326.52 $1,596.73 $1,250.65 $346.07 $181,924.13 $327,431.46 $509,355.59
320 $58,075.87 $1,596.73 $1,257.95 $338.78 $183,182.08 $327,770.24 $510,952.32
321 $56,817.92 $1,596.73 $1,265.29 $331.44 $184,447.37 $328,101.67 $512,549.04
322 $55,552.63 $1,596.73 $1,272.67 $324.06 $185,720.04 $328,425.73 $514,145.77
323 $54,279.96 $1,596.73 $1,280.09 $316.63 $187,000.13 $328,742.36 $515,742.49
27 324 $52,999.87 $1,596.73 $1,287.56 $309.17 $188,287.69 $329,051.53 $517,339.22 $14,967.29 $4,193.42
325 $51,712.31 $1,596.73 $1,295.07 $301.66 $189,582.76 $329,353.18 $518,935.95
326 $50,417.24 $1,596.73 $1,302.63 $294.10 $190,885.39 $329,647.29 $520,532.67
327 $49,114.61 $1,596.73 $1,310.22 $286.50 $192,195.61 $329,933.79 $522,129.40
328 $47,804.39 $1,596.73 $1,317.87 $278.86 $193,513.48 $330,212.65 $523,726.12
329 $46,486.52 $1,596.73 $1,325.55 $271.17 $194,839.03 $330,483.82 $525,322.85
330 $45,160.97 $1,596.73 $1,333.29 $263.44 $196,172.32 $330,747.26 $526,919.58
331 $43,827.68 $1,596.73 $1,341.06 $255.66 $197,513.38 $331,002.92 $528,516.30
332 $42,486.62 $1,596.73 $1,348.89 $247.84 $198,862.27 $331,250.76 $530,113.03
333 $41,137.73 $1,596.73 $1,356.76 $239.97 $200,219.03 $331,490.73 $531,709.75
334 $39,780.97 $1,596.73 $1,364.67 $232.06 $201,583.70 $331,722.78 $533,306.48
335 $38,416.30 $1,596.73 $1,372.63 $224.10 $202,956.33 $331,946.88 $534,903.21
28 336 $37,043.67 $1,596.73 $1,380.64 $216.09 $204,336.97 $332,162.97 $536,499.93 $16,049.28 $3,111.44
337 $35,663.03 $1,596.73 $1,388.69 $208.03 $205,725.66 $332,371.00 $538,096.66
338 $34,274.34 $1,596.73 $1,396.79 $199.93 $207,122.45 $332,570.93 $539,693.38
339 $32,877.55 $1,596.73 $1,404.94 $191.79 $208,527.39 $332,762.72 $541,290.11
340 $31,472.61 $1,596.73 $1,413.14 $183.59 $209,940.53 $332,946.31 $542,886.84
341 $30,059.47 $1,596.73 $1,421.38 $175.35 $211,361.91 $333,121.66 $544,483.56
342 $28,638.09 $1,596.73 $1,429.67 $167.06 $212,791.58 $333,288.71 $546,080.29
343 $27,208.42 $1,596.73 $1,438.01 $158.72 $214,229.59 $333,447.43 $547,677.01
344 $25,770.41 $1,596.73 $1,446.40 $150.33 $215,675.98 $333,597.76 $549,273.74
345 $24,324.02 $1,596.73 $1,454.84 $141.89 $217,130.82 $333,739.65 $550,870.47
346 $22,869.18 $1,596.73 $1,463.32 $133.40 $218,594.14 $333,873.05 $552,467.19
347 $21,405.86 $1,596.73 $1,471.86 $124.87 $220,066.00 $333,997.92 $554,063.92
29 348 $19,934.00 $1,596.73 $1,480.44 $116.28 $221,546.45 $334,114.20 $555,660.64 $17,209.48 $1,951.23
349 $18,453.55 $1,596.73 $1,489.08 $107.65 $223,035.53 $334,221.84 $557,257.37
350 $16,964.47 $1,596.73 $1,497.77 $98.96 $224,533.29 $334,320.80 $558,854.10
351 $15,466.71 $1,596.73 $1,506.50 $90.22 $226,039.80 $334,411.03 $560,450.82
352 $13,960.20 $1,596.73 $1,515.29 $81.43 $227,555.09 $334,492.46 $562,047.55
353 $12,444.91 $1,596.73 $1,524.13 $72.60 $229,079.22 $334,565.06 $563,644.27
354 $10,920.78 $1,596.73 $1,533.02 $63.70 $230,612.24 $334,628.76 $565,241.00
355 $9,387.76 $1,596.73 $1,541.96 $54.76 $232,154.20 $334,683.52 $566,837.73
356 $7,845.80 $1,596.73 $1,550.96 $45.77 $233,705.16 $334,729.29 $568,434.45
357 $6,294.84 $1,596.73 $1,560.01 $36.72 $235,265.17 $334,766.01 $570,031.18
358 $4,734.83 $1,596.73 $1,569.11 $27.62 $236,834.27 $334,793.63 $571,627.90
359 $3,165.73 $1,596.73 $1,578.26 $18.47 $238,412.53 $334,812.10 $573,224.63
30 360 $1,587.47 $1,596.73 $1,587.47 $9.26 $240,000.00 $334,821.36 $574,821.36 $18,453.55 $707.16