Spreadsheet: 184520d1349285838-hlookup-issue-sample
Sheet: Sheet1

 |  |  |  |  | 0.0025 | 0.005 | 0.0075 | 0.01 | 0.0125 | 0.015 | 0.0175 | 0.02 | 0.0225 | 0.025 | 0.0275 | 0.03 | 0.03249999999999999 | 0.035 | 0.0375 | 0.04 | 0.0425 | 0.04500000000000001 | 0.04750000000000001 | 0.05000000000000001 | 0.05250000000000001 | 0.05500000000000001 | 0.05750000000000002 | 0.06000000000000002 | 0.06250000000000001 | 0.06500000000000002 | 0.06750000000000002 | 0.07000000000000002 | 0.07250000000000002 | 0.07500000000000002 | 0.07750000000000003 | 0.08000000000000003 | 0.08250000000000003 | 0.08500000000000003 | 0.08750000000000004 | 0.09000000000000004 | 0.09250000000000004 | 0.09500000000000004 | 0.09750000000000004 | 0.1
Current Rate | 0.08 |  |  | NOI | 31.23532767654372 | 35.15045316729508 | 39.06557865804645 | 42.98070414879781 | 46.89582963954918 | 50.81095513030056 | 54.72608062105192 | 58.64120611180329 | 62.55633160255465 | 66.47145709330601 | 70.38658258405738 | 74.30170807480873 | 78.21683356556011 | 82.13195905631147 | 86.04708454706285 | 89.96221003781422 | 93.8773355285656 | 97.79246101931696 | 101.7075865100683 | 105.6227120008197 | 109.5378374915711 | 113.4529629823224 | 117.3680884730738 | 121.2832139638252 | 125.1983394545765 | 129.1134649453279 | 133.0285904360792 | 136.9437159268306 | 140.858841417582 | 144.7739669083334 | 148.6890923990847 | 152.6042178898361 | 156.5193433805875 | 160.4344688713389 | 164.3495943620902 | 168.2647198528416 | 172.1798453435929 | 176.0949708343443 | 180.0100963250957 | 183.9252218158471
Delta  bps | 50 |  |  | Income | 31.32132767654372 | 35.23645316729508 | 39.15157865804645 | 43.06670414879781 | 46.98182963954918 | 50.89695513030055 | 54.81208062105192 | 58.72720611180328 | 62.64233160255465 | 66.55745709330601 | 70.47258258405738 | 74.38770807480873 | 78.3028335655601 | 82.21795905631147 | 86.13308454706285 | 90.04821003781421 | 93.9633355285656 | 97.87846101931696 | 101.7935865100683 | 105.7087120008197 | 109.6238374915711 | 113.5389629823224 | 117.4540884730738 | 121.3692139638252 | 125.2843394545765 | 129.1994649453279 | 133.1145904360793 | 137.0297159268306 | 140.944841417582 | 144.8599669083334 | 148.7750923990847 | 152.6902178898361 | 156.6053433805875 | 160.5204688713389 | 164.4355943620902 | 168.3507198528416 | 172.265845343593 | 176.1809708343443 | 180.0960963250957 | 184.0112218158471
 |  |  |  | State1 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235 | 27.40620218579235
 |  |  |  | State2 | 3.915125490751366 | 7.830250981502733 | 11.7453764722541 | 15.66050196300547 | 19.57562745375683 | 23.4907529445082 | 27.40587843525957 | 31.32100392601093 | 35.2361294167623 | 39.15125490751366 | 43.06638039826503 | 46.98150588901638 | 50.89663137976775 | 54.81175687051912 | 58.7268823612705 | 62.64200785202186 | 66.55713334277324 | 70.4722588335246 | 74.38738432427597 | 78.30250981502734 | 82.2176353057787 | 86.13276079653008 | 90.04788628728146 | 93.96301177803282 | 97.87813726878419 | 101.7932627595356 | 105.7083882502869 | 109.6235137410383 | 113.5386392317896 | 117.453764722541 | 121.3688902132924 | 125.2840157040438 | 129.1991411947951 | 133.1142666855465 | 137.0293921762979 | 140.9445176670492 | 144.8596431578006 | 148.774768648552 | 152.6898941393034 | 156.6050196300547
Interest Income |  |  |  | Expense | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002 | -0.08600000000000002
 |  |  |  | Average Balance | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866 | 27004.495866
 |  |  |  | State1 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515 | 8515
 |  |  |  | State2 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866 | 18489.495866
 |  |  |  | Interest Income | 0.01369378423133566 | 0.0154054895671571 | 0.01711719490297853 | 0.01882890023879996 | 0.0205406055746214 | 0.02225231091044283 | 0.02396401624626426 | 0.02567572158208569 | 0.02738742691790712 | 0.02909913225372855 | 0.03081083758954998 | 0.03252254292537141 | 0.03423424826119285 | 0.03594595359701428 | 0.03765765893283572 | 0.03936936426865715 | 0.04108106960447858 | 0.04279277494030002 | 0.04450448027612144 | 0.04621618561194288 | 0.04792789094776431 | 0.04963959628358575 | 0.05135130161940718 | 0.05306300695522862 | 0.05477471229105004 | 0.05648641762687148 | 0.0581981229626929 | 0.05990982829851434 | 0.06162153363433576 | 0.06333323897015722 | 0.06504494430597864 | 0.06675664964180007 | 0.0684683549776215 | 0.07018006031344294 | 0.07189176564926437 | 0.07360347098508581 | 0.07531517632090724 | 0.07702688165672868 | 0.07873858699255011 | 0.08045029232837156
 |  |  |  | State1 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038
 |  |  |  | State2 | 0.0025 | 0.005 | 0.0075 | 0.01 | 0.0125 | 0.015 | 0.0175 | 0.02 | 0.0225 | 0.025 | 0.0275 | 0.03 | 0.03249999999999999 | 0.035 | 0.0375 | 0.04 | 0.0425 | 0.04500000000000001 | 0.04750000000000001 | 0.05000000000000001 | 0.05250000000000001 | 0.05500000000000001 | 0.05750000000000002 | 0.06000000000000002 | 0.06250000000000001 | 0.06500000000000002 | 0.06750000000000002 | 0.07000000000000002 | 0.07250000000000002 | 0.07500000000000002 | 0.07750000000000003 | 0.08000000000000003 | 0.08250000000000003 | 0.08500000000000003 | 0.08750000000000004 | 0.09000000000000004 | 0.09250000000000004 | 0.09500000000000004 | 0.09750000000000004 | 0.1
 |  |  |  | ECR | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05 | -3.75994739449315e-05
 |  |  |  | Spread | 0.01365618475739073 | 0.01536789009321217 | 0.0170795954290336 | 0.01879130076485503 | 0.02050300610067646 | 0.0222147114364979 | 0.02392641677231933 | 0.02563812210814076 | 0.02734982744396219 | 0.02906153277978362 | 0.03077323811560505 | 0.03248494345142648 | 0.03419664878724792 | 0.03590835412306934 | 0.03762005945889078 | 0.03933176479471222 | 0.04104347013053365 | 0.04275517546635509 | 0.04446688080217651 | 0.04617858613799795 | 0.04789029147381937 | 0.04960199680964082 | 0.05131370214546225 | 0.05302540748128369 | 0.05473711281710511 | 0.05644881815292653 | 0.05816052348874796 | 0.0598722288245694 | 0.06158393416039083 | 0.06329563949621227 | 0.0650073448320337 | 0.06671905016785513 | 0.06843075550367657 | 0.070142460839498 | 0.07185416617531944 | 0.07356587151114087 | 0.0752775768469623 | 0.07698928218278372 | 0.07870098751860517 | 0.0804126928544266
 |  |  |  | ECR Impact | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025 | -0.0025
 |  |  |  | Fee Impact | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799 | -40.506743799