A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | General Parameters | Financing | Leasing Old | Leasing New | ||||||||||||
2 | ||||||||||||||||
3 | Aircraft Value | 100,000,000 | Down Payment % | 10% | Deposit % | 5% | Deposit % | 5% | ||||||||
4 | Depreciation to Zero | 24 | a | Down Payment | 10,000,000 | Deposit | 5,000,000 | Deposit | 5,000,000 | |||||||
5 | Depreciation per week | 79,909 | Loan Amount | 90,000,000 | Leasing Rate % | 0.50% | Retail Value | 100,000,000 | ||||||||
6 | Leasing Rate | 500,000 | Depreciation | 384,615 | ||||||||||||
7 | Weeks/year | 52.14 | Aircraft Trader Buy-back | Equipment Value | 100,000,000 | |||||||||||
8 | ||||||||||||||||
9 | Lowest annual interest | 1.00% | Residual book value | 79,223,744 | Residual Value | 39,611,872 | ||||||||||
10 | Interest step | 0.50% | Base price factor | 20% | Interest base | 139,611,872 | ||||||||||
11 | Global Interest Factor | 200% | Base price | 79,223,744 | Lessor Margin | 50% | ||||||||||
12 | Periods | 260 | weeks | Min. Sale Price Factor | 50% | |||||||||||
13 | Auto-purchase price | 39,611,872 | ||||||||||||||
14 | ||||||||||||||||
15 | ||||||||||||||||
16 | ||||||||||||||||
17 | Rating | D | CI | C | CC | CCC | B | BB | BBB | AA | AAA | |||||
18 | ||||||||||||||||
19 | Annual Prime Rate | Weekly Annuities | ||||||||||||||
20 | 1.00% | 420,820 | 410,631 | 401,887 | 394,371 | 387,901 | 382,323 | 377,509 | 373,351 | 366,642 | 363,946 | |||||
21 | 1.50% | 462,236 | 446,032 | 432,207 | 420,386 | 410,259 | 401,568 | 394,096 | 387,664 | 377,333 | 373,198 | |||||
22 | 2.00% | 506,405 | 483,575 | 464,194 | 447,700 | 433,631 | 421,605 | 411,305 | 402,466 | 388,329 | 382,693 | |||||
23 | 2.50% | 553,324 | 523,271 | 497,863 | 476,329 | 458,032 | 442,448 | 429,145 | 417,765 | 399,636 | 392,434 | |||||
24 | 3.00% | 602,970 | 565,118 | 533,225 | 506,286 | 483,474 | 464,108 | 447,627 | 433,569 | 411,259 | 402,426 | |||||
25 | 3.50% | 655,302 | 609,103 | 570,278 | 537,577 | 509,966 | 486,594 | 466,759 | 449,886 | 423,202 | 412,673 | |||||
26 | 4.00% | 710,260 | 655,201 | 609,018 | 570,207 | 537,517 | 509,915 | 486,551 | 466,723 | 435,471 | 423,179 | |||||
27 | 4.50% | 767,768 | 703,376 | 649,431 | 604,173 | 566,130 | 534,079 | 507,008 | 484,086 | 448,070 | 433,948 | |||||
28 | 5.00% | 827,737 | 753,582 | 691,497 | 639,471 | 595,808 | 559,089 | 528,137 | 501,982 | 461,004 | 444,982 | |||||
29 | 5.50% | 890,067 | 805,766 | 735,190 | 676,090 | 626,549 | 584,949 | 549,943 | 520,416 | 474,278 | 456,287 | |||||
30 | 6.00% | 954,651 | 859,864 | 780,477 | 714,018 | 658,351 | 611,662 | 572,431 | 539,393 | 487,895 | 467,865 | |||||
31 | ||||||||||||||||
32 | Annual Prime Rate | Annuities compared to old leasing rate | ||||||||||||||
33 | 1.00% | -15.84% | -17.87% | -19.62% | -21.13% | -22.42% | -23.54% | -24.50% | -25.33% | -26.67% | -27.21% | |||||
34 | 1.50% | -7.55% | -10.79% | -13.56% | -15.92% | -17.95% | -19.69% | -21.18% | -22.47% | -24.53% | -25.36% | |||||
35 | 2.00% | 1.28% | -3.29% | -7.16% | -10.46% | -13.27% | -15.68% | -17.74% | -19.51% | -22.33% | -23.46% | |||||
36 | 2.50% | 10.66% | 4.65% | -0.43% | -4.73% | -8.39% | -11.51% | -14.17% | -16.45% | -20.07% | -21.51% | |||||
37 | 3.00% | 20.59% | 13.02% | 6.64% | 1.26% | -3.31% | -7.18% | -10.47% | -13.29% | -17.75% | -19.51% | |||||
38 | 3.50% | 31.06% | 21.82% | 14.06% | 7.52% | 1.99% | -2.68% | -6.65% | -10.02% | -15.36% | -17.47% | |||||
39 | 4.00% | 42.05% | 31.04% | 21.80% | 14.04% | 7.50% | 1.98% | -2.69% | -6.66% | -12.91% | -15.36% | |||||
40 | 4.50% | 53.55% | 40.68% | 29.89% | 20.83% | 13.23% | 6.82% | 1.40% | -3.18% | -10.39% | -13.21% | |||||
41 | 5.00% | 65.55% | 50.72% | 38.30% | 27.89% | 19.16% | 11.82% | 5.63% | 0.40% | -7.80% | -11.00% | |||||
42 | 5.50% | 78.01% | 61.15% | 47.04% | 35.22% | 25.31% | 16.99% | 9.99% | 4.08% | -5.14% | -8.74% | |||||
43 | 6.00% | 90.93% | 71.97% | 56.10% | 42.80% | 31.67% | 22.33% | 14.49% | 7.88% | -2.42% | -6.43% | |||||
44 | ||||||||||||||||
45 | Annual Prime Rate | Weekly Leasing Rate | ||||||||||||||
46 | 1.00% | 414,513 | 414,513 | 414,513 | 414,513 | 414,513 | 414,513 | 414,513 | 414,513 | 414,513 | 414,513 | |||||
47 | 1.50% | 430,242 | 430,242 | 430,242 | 430,242 | 430,242 | 430,242 | 430,242 | 430,242 | 430,242 | 430,242 | |||||
48 | 2.00% | 446,504 | 446,504 | 446,504 | 446,504 | 446,504 | 446,504 | 446,504 | 446,504 | 446,504 | 446,504 | |||||
49 | 2.50% | 463,309 | 463,309 | 463,309 | 463,309 | 463,309 | 463,309 | 463,309 | 463,309 | 463,309 | 463,309 | |||||
50 | 3.00% | 480,665 | 480,665 | 480,665 | 480,665 | 480,665 | 480,665 | 480,665 | 480,665 | 480,665 | 480,665 | |||||
51 | 3.50% | 498,581 | 498,581 | 498,581 | 498,581 | 498,581 | 498,581 | 498,581 | 498,581 | 498,581 | 498,581 | |||||
52 | 4.00% | 517,064 | 517,064 | 517,064 | 517,064 | 517,064 | 517,064 | 517,064 | 517,064 | 517,064 | 517,064 | |||||
53 | 4.50% | 536,123 | 536,123 | 536,123 | 536,123 | 536,123 | 536,123 | 536,123 | 536,123 | 536,123 | 536,123 | |||||
54 | 5.00% | 555,762 | 555,762 | 555,762 | 555,762 | 555,762 | 555,762 | 555,762 | 555,762 | 555,762 | 555,762 | |||||
55 | 5.50% | 575,989 | 575,989 | 575,989 | 575,989 | 575,989 | 575,989 | 575,989 | 575,989 | 575,989 | 575,989 | |||||
56 | 6.00% | 596,809 | 596,809 | 596,809 | 596,809 | 596,809 | 596,809 | 596,809 | 596,809 | 596,809 | 596,809 | |||||
57 | ||||||||||||||||
58 | Annual Prime Rate | New Leasing Rates compared to Old Leasing Rate | ||||||||||||||
59 | 1.00% | -17.10% | -17.10% | -17.10% | -17.10% | -17.10% | -17.10% | -17.10% | -17.10% | -17.10% | -17.10% | |||||
60 | 1.50% | -13.95% | -13.95% | -13.95% | -13.95% | -13.95% | -13.95% | -13.95% | -13.95% | -13.95% | -13.95% | |||||
61 | 2.00% | -10.70% | -10.70% | -10.70% | -10.70% | -10.70% | -10.70% | -10.70% | -10.70% | -10.70% | -10.70% | |||||
62 | 2.50% | -7.34% | -7.34% | -7.34% | -7.34% | -7.34% | -7.34% | -7.34% | -7.34% | -7.34% | -7.34% | |||||
63 | 3.00% | -3.87% | -3.87% | -3.87% | -3.87% | -3.87% | -3.87% | -3.87% | -3.87% | -3.87% | -3.87% | |||||
64 | 3.50% | -0.28% | -0.28% | -0.28% | -0.28% | -0.28% | -0.28% | -0.28% | -0.28% | -0.28% | -0.28% | |||||
65 | 4.00% | 3.41% | 3.41% | 3.41% | 3.41% | 3.41% | 3.41% | 3.41% | 3.41% | 3.41% | 3.41% | |||||
66 | 4.50% | 7.22% | 7.22% | 7.22% | 7.22% | 7.22% | 7.22% | 7.22% | 7.22% | 7.22% | 7.22% | |||||
67 | 5.00% | 11.15% | 11.15% | 11.15% | 11.15% | 11.15% | 11.15% | 11.15% | 11.15% | 11.15% | 11.15% | |||||
68 | 5.50% | 15.20% | 15.20% | 15.20% | 15.20% | 15.20% | 15.20% | 15.20% | 15.20% | 15.20% | 15.20% | |||||
69 | 6.00% | 19.36% | 19.36% | 19.36% | 19.36% | 19.36% | 19.36% | 19.36% | 19.36% | 19.36% | 19.36% | |||||
70 | ||||||||||||||||
71 | Annual Prime Rate | New Leasing Rates compared to Annuities | ||||||||||||||
72 | 1.00% | -1.50% | 0.95% | 3.14% | 5.11% | 6.86% | 8.42% | 9.80% | 11.03% | 13.06% | 13.89% | |||||
73 | 1.50% | -6.92% | -3.54% | -0.45% | 2.34% | 4.87% | 7.14% | 9.17% | 10.98% | 14.02% | 15.29% | |||||
74 | 2.00% | -11.83% | -7.67% | -3.81% | -0.27% | 2.97% | 5.91% | 8.56% | 10.94% | 14.98% | 16.67% | |||||
75 | 2.50% | -16.27% | -11.46% | -6.94% | -2.73% | 1.15% | 4.71% | 7.96% | 10.90% | 15.93% | 18.06% | |||||
76 | 3.00% | -20.28% | -14.94% | -9.86% | -5.06% | -0.58% | 3.57% | 7.38% | 10.86% | 16.88% | 19.44% | |||||
77 | 3.50% | -23.92% | -18.15% | -12.57% | -7.25% | -2.23% | 2.46% | 6.82% | 10.82% | 17.81% | 20.82% | |||||
78 | 4.00% | -27.20% | -21.08% | -15.10% | -9.32% | -3.80% | 1.40% | 6.27% | 10.79% | 18.74% | 22.19% | |||||
79 | 4.50% | -30.17% | -23.78% | -17.45% | -11.26% | -5.30% | 0.38% | 5.74% | 10.75% | 19.65% | 23.55% | |||||
80 | 5.00% | -32.86% | -26.25% | -19.63% | -13.09% | -6.72% | -0.59% | 5.23% | 10.71% | 20.55% | 24.90% | |||||
81 | 5.50% | -35.29% | -28.52% | -21.65% | -14.81% | -8.07% | -1.53% | 4.74% | 10.68% | 21.45% | 26.23% | |||||
82 | 6.00% | -37.48% | -30.59% | -23.53% | -16.42% | -9.35% | -2.43% | 4.26% | 10.64% | 22.32% | 27.56% | |||||
83 | ||||||||||||||||
84 | Rating Interest Factor | 4.0000 | 3.4822 | 3.0314 | 2.6390 | 2.2974 | 2.0000 | 1.7411 | 1.5157 | 1.1487 | 1.0000 | |||||
85 | Annual Prime Rate | Weekly interest rates by rating | ||||||||||||||
86 | 1.00% | 0.15% | 0.13% | 0.12% | 0.10% | 0.09% | 0.08% | 0.07% | 0.06% | 0.04% | 0.04% | |||||
87 | 1.50% | 0.23% | 0.20% | 0.17% | 0.15% | 0.13% | 0.12% | 0.10% | 0.09% | 0.07% | 0.06% | |||||
88 | 2.00% | 0.31% | 0.27% | 0.23% | 0.20% | 0.18% | 0.15% | 0.13% | 0.12% | 0.09% | 0.08% | |||||
89 | 2.50% | 0.38% | 0.33% | 0.29% | 0.25% | 0.22% | 0.19% | 0.17% | 0.15% | 0.11% | 0.10% | |||||
90 | 3.00% | 0.46% | 0.40% | 0.35% | 0.30% | 0.26% | 0.23% | 0.20% | 0.17% | 0.13% | 0.12% | |||||
91 | 3.50% | 0.54% | 0.47% | 0.41% | 0.35% | 0.31% | 0.27% | 0.23% | 0.20% | 0.15% | 0.13% | |||||
92 | 4.00% | 0.61% | 0.53% | 0.47% | 0.40% | 0.35% | 0.31% | 0.27% | 0.23% | 0.18% | 0.15% | |||||
93 | 4.50% | 0.69% | 0.60% | 0.52% | 0.46% | 0.40% | 0.35% | 0.30% | 0.26% | 0.20% | 0.17% | |||||
94 | 5.00% | 0.77% | 0.67% | 0.58% | 0.51% | 0.44% | 0.38% | 0.33% | 0.29% | 0.22% | 0.19% | |||||
95 | 5.50% | 0.84% | 0.73% | 0.64% | 0.56% | 0.48% | 0.42% | 0.37% | 0.32% | 0.24% | 0.21% | |||||
96 | 6.00% | 0.92% | 0.80% | 0.70% | 0.61% | 0.53% | 0.46% | 0.40% | 0.35% | 0.26% | 0.23% | |||||
97 | ||||||||||||||||
98 | Annual LOAN Rate | Weekly interest rates by rating | ||||||||||||||
99 | 1.01% | 0.15% | 0.13% | 0.12% | 0.10% | 0.09% | 0.08% | 0.07% | 0.06% | 0.04% | 0.04% | |||||
100 | 1.52% | 0.23% | 0.20% | 0.18% | 0.15% | 0.13% | 0.12% | 0.10% | 0.09% | 0.07% | 0.06% |