Spreadsheet: 59150d1259617169-if-formula-displaying-false-sample-workbook2
Sheet: Sheet1

 |  | Term |  |  | 36000 | Equipment cost/Lease amount
 | 1750 | Payment Amount |  |  | 36000
 | Points | Term
 | 0 | 2
Buy Rates  2 Advances/Security Deposits |  |  |  |  |  |  |  |  | Buy Rates   1 Advance/Secuity Deposit
 | 0.1375 | 0.1175 | 0.115 |  | 0.1375 | 0.1175 | 0.115 |  |  | 0.1375 | 0.1175 | 0.115 |  | 0.1375 | 0.1175 | 0.115
$ End of Lease option |  |  |  | FMV or 10% option |  |  |  |  | $ End of Lease option |  |  |  | FMV or 10% option |  |  |  |  | 1
 | $5,000-$14,999 | $15,000-$49,999 | $50,000 and over |  | $5,000-$14,999 | $15,000-$49,999 | $50,000 and over |  |  | $5,000-$14,999 | $15,000-$49,999 | $50,000 and over |  | $5,000-$14,999 | $15,000-$49,999 | $50,000 and over |  | 2
24 | 0.04684 | 0.04607 | 0.04598 | 24 | 0.04328 | 0.04242 | 0.04232 |  | 24 | 0.04735 | 0.0465 | 0.0464 | 24 | 0.04375 | 0.04282 | 0.04271
36 | 0.0333 | 0.03247 | 0.03236 | 36 | 0.03109 | 0.03018 | 0.03007 |  | 36 | 0.03367 | 0.03277 | 0.03266 | 36 | 0.03144 | 0.03047 | 0.03035
48 | 0.0266 | 0.02571 | 0.0256 | 48 | 0.02506 | 0.0241 | 0.02398 |  | 48 | 0.02689 | 0.02596 | 0.02584 | 48 | 0.02534 | 0.02433 | 0.02421
60 | 0.02262 | 0.0217 | 0.02158 | 60 | 0.02148 | 0.02049 | 0.02036 |  | 60 | 0.02288 | 0.0219 | 0.02178 | 60 | 0.02172 | 0.02068 | 0.02055
SELL Rates  2 Advances/Security Deposits |  |  |  |  |  |  |  |  | SELL Rates   1 Advance/Secuity Deposit
 | $5,000-$14,999 | $15,000-$49,999 | $50,000 and over |  | $5,000-$14,999 | $15,000-$49,999 | $50,000 and over |  |  | $5,000-$14,999 | $15,000-$49,999 | $50,000 and over |  | $5,000-$14,999 | $15,000-$49,999 | $50,000 and over
24 | 0.04684 | 0.04607 | 0.04598 | 24 | 0.04328 | 0.04242 | 0.04232 |  | 24 | 0.04735 | 0.0465 | 0.0464 | 24 | 0.04375 | 0.04282 | 0.04271
36 | 0.0333 | 0.03247 | 0.03236 | 36 | 0.03109 | 0.03018 | 0.03007 |  | 36 | 0.03367 | 0.03277 | 0.03266 | 36 | 0.03144 | 0.03047 | 0.03035
48 | 0.0266 | 0.02571 | 0.0256 | 48 | 0.02506 | 0.0241 | 0.02398 |  | 48 | 0.02689 | 0.02596 | 0.02584 | 48 | 0.02534 | 0.02433 | 0.02421
60 | 0.02262 | 0.0217 | 0.02158 | 60 | 0.02148 | 0.02049 | 0.02036 |  | 60 | 0.02288 | 0.0219 | 0.02178 | 60 | 0.02172 | 0.02068 | 0.02055
 | Equip. Cost | $ - 24 mos/2 SD | $ - 36 mos/2 SD | $ - 48 mos/2 SD | $ - 60 mos/2 SD
 | 5000 | 234.2 | 166.5 | 133 | 113.1
 | 7500 | 351.3 | 249.75 | 199.5 | 169.65
 | 10000 | 468.4 | 333.0000000000001 | 266 | 226.2
 | 15000 | 691.05 | 487.05 | 385.65 | 325.5
 | 18000 | 829.26 | 584.46 | 462.78 | 390.6
 | 20000 | 921.4 | 649.4 | 514.2 | 434
 | 22000 | 1013.54 | 714.3399999999999 | 565.62 | 477.4
 | 24000 | 1105.68 | 779.28 | 617.04 | 520.8000000000001
 | 26000 | 1197.82 | 844.22 | 668.46 | 564.2
 | 28000 | 1289.96 | 909.16 | 719.88 | 607.6
 | 30000 | 1382.1 | 974.0999999999999 | 771.3 | 651
 | 32000 | 1474.24 | 1039.04 | 822.72 | 694.4
 | 34000 | 1566.38 | 1103.98 | 874.14 | 737.8000000000001
 | 36000 | 1658.52 | 1168.92 | 925.5600000000001 | 781.2
 | 38000 | 1750.66 | 1233.86 | 976.98 | 824.6
 | 40000 | 1842.8 | 1298.8 | 1028.4 | 868
 | 42000 | 1934.94 | 1363.74 | 1079.82 | 911.4
 | 44000 | 2027.08 | 1428.68 | 1131.24 | 954.8000000000001
 | 46000 | 2119.22 | 1493.62 | 1182.66 | 998.2
 | 48000 | 2211.36 | 1558.56 | 1234.08 | 1041.6
 | 50000 | 2299 | 1618 | 1280 | 1079
 | 52000 | 2390.96 | 1682.72 | 1331.2 | 1122.16
 | 54000 | 2482.92 | 1747.44 | 1382.4 | 1165.32
 | 56000 | 2574.88 | 1812.16 | 1433.6 | 1208.48
 | 58000 | 2666.84 | 1876.88 | 1484.8 | 1251.64
 | 60000 | 2758.8 | 1941.6 | 1536 | 1294.8
 | 62000 | 2850.76 | 2006.32 | 1587.2 | 1337.96
 | 64000 | 2942.72 | 2071.04 | 1638.4 | 1381.12
 | 66000 | 3034.68 | 2135.76 | 1689.6 | 1424.28
 | 68000 | 3126.64 | 2200.48 | 1740.8 | 1467.44
 | 70000 | 3218.6 | 2265.2 | 1792 | 1510.6
 | 72000 | 3310.56 | 2329.92 | 1843.2 | 1553.76
 | 74000 | 3402.52 | 2394.64 | 1894.4 | 1596.92