Spreadsheet: 2ae5c6a0-684c-47dc-9bf2-751c1a3073bc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | 0.01 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | INTEREST RATE = 1.0%
n | (P/F) | (P/A) | (P/G) | (F/P) | (F/A) | (A/P) | (A/F) | n
1 | 0.9900990099009901 | 0.990099009900991 | 8.526512829121202e-14 | 1.01 | 1.000000000000001 | 1.009999999999999 | 0.9999999999999991 | 1
2 | 0.9802960494069208 | 1.970395059307913 | 0.980296049407059 | 1.0201 | 2.010000000000002 | 0.5075124378109448 | 0.4975124378109448 | 2
3 | 0.9705901479276444 | 2.940985207235558 | 2.921476345262477 | 1.030301 | 3.030100000000003 | 0.340022111481469 | 0.330022111481469 | 3
4 | 0.9609803444828162 | 3.901965551718375 | 5.804417378711037 | 1.04060401 | 4.060401000000003 | 0.2562810939116603 | 0.2462810939116602 | 4
5 | 0.9514656876067488 | 4.853431239325125 | 9.610280129138062 | 1.0510100501 | 5.101005010000004 | 0.2060397996158798 | 0.1960397996158798 | 5
6 | 0.9420452352542067 | 5.795476474579332 | 14.32050630540914 | 1.061520150601 | 6.152015060100005 | 0.1725483667108813 | 0.1625483667108813 | 6
7 | 0.9327180547071353 | 6.728194529286468 | 19.91681463365217 | 1.07213535210701 | 7.213535210701006 | 0.1486282829141165 | 0.1386282829141165 | 7
8 | 0.9234832224823122 | 7.651677751768781 | 26.38119719102838 | 1.08285670562808 | 8.285670562808017 | 0.1306902920433153 | 0.1206902920433153 | 8
9 | 0.914339824239913 | 8.566017576008695 | 33.69591578494772 | 1.093685272684361 | 9.368527268436099 | 0.116740362849681 | 0.106740362849681 | 9
10 | 0.9052869546929833 | 9.47130453070168 | 41.84349837718469 | 1.104622125411205 | 10.46221254112046 | 0.1055820765511713 | 0.09558207655117128 | 10
11 | 0.8963237175178052 | 10.36762824821949 | 50.80673555236274 | 1.115668346665317 | 11.56683466653167 | 0.09645407571126384 | 0.08645407571126384 | 11
12 | 0.8874492252651536 | 11.25507747348464 | 60.56867703027956 | 1.12682503013197 | 12.68250301319698 | 0.08884878867834164 | 0.07884878867834164 | 12
13 | 0.8786625992724293 | 12.13374007275707 | 71.1126282215489 | 1.13809328043329 | 13.80932804332896 | 0.08241481966844016 | 0.07241481966844017 | 13
14 | 0.8699629695766626 | 13.00370304233373 | 82.42214682604549 | 1.149474213237623 | 14.94742132376224 | 0.07690117166967643 | 0.06690117166967643 | 14
15 | 0.8613494748283789 | 13.86505251716211 | 94.4810394736428 | 1.160968955369999 | 16.09689553699987 | 0.07212378018490759 | 0.0621237801849076 | 15
16 | 0.8528212622063157 | 14.71787377936843 | 107.2733584067378 | 1.172578644923699 | 17.25786449236987 | 0.06794459682089432 | 0.05794459682089432 | 16
17 | 0.8443774873329858 | 15.56225126670141 | 120.7833982040656 | 1.184304431372936 | 18.43044313729357 | 0.06425805514011346 | 0.05425805514011346 | 17
18 | 0.8360173141910751 | 16.39826858089249 | 134.9956925453139 | 1.196147475686665 | 19.61474756866651 | 0.06098204789530128 | 0.05098204789530128 | 18
19 | 0.8277399150406684 | 17.22600849593316 | 149.8950110160463 | 1.208108950443532 | 20.81089504435317 | 0.05805175355835261 | 0.0480517535583526 | 19
20 | 0.8195444703372954 | 18.04555296627046 | 165.4663559524549 | 1.220190039947967 | 22.01900399479671 | 0.05541531489055133 | 0.04541531489055133 | 20
21 | 0.8114301686507875 | 18.85698313492124 | 181.6949593254708 | 1.232391940347447 | 23.23919403474467 | 0.05303075220702193 | 0.04303075220702192 | 21
22 | 0.8033962065849382 | 19.66037934150618 | 198.5662796637546 | 1.244715859750921 | 24.47158597509212 | 0.05086371847814967 | 0.04086371847814967 | 22
23 | 0.7954417886979586 | 20.45582113020414 | 216.0659990151098 | 1.25716301834843 | 25.71630183484304 | 0.04888584005671839 | 0.03888584005671838 | 23
24 | 0.7875661274237213 | 21.24338725762787 | 234.1800199458553 | 1.269734648531915 | 26.97346485319148 | 0.04707347222326467 | 0.03707347222326467 | 24
25 | 0.7797684429937835 | 22.02315570062165 | 252.8944625777058 | 1.282431995017234 | 28.24319950172339 | 0.045406753400548 | 0.035406753400548 | 25
26 | 0.7720479633601817 | 22.79520366398183 | 272.1956616617106 | 1.295256314967406 | 29.52563149674062 | 0.04386887762622085 | 0.03386887762622084 | 26
27 | 0.7644039241189917 | 23.55960758810082 | 292.0701636888043 | 1.30820887811708 | 30.82088781170803 | 0.04244552869823973 | 0.03244552869823973 | 27
28 | 0.7568355684346453 | 24.31644315653547 | 312.5047240365402 | 1.321290966898251 | 32.12909668982511 | 0.0411244355748317 | 0.0311244355748317 | 28
29 | 0.7493421469649953 | 25.06578530350047 | 333.4863041515605 | 1.334503876567234 | 33.45038765672336 | 0.03989501976067547 | 0.02989501976067547 | 29
30 | 0.741922917787124 | 25.80770822128759 | 355.0020687673873 | 1.347848915332906 | 34.7848915332906 | 0.03874811321584712 | 0.02874811321584712 | 30
31 | 0.7345771463238853 | 26.54228536761147 | 377.0393831571037 | 1.361327404486235 | 36.13274044862351 | 0.03767573086303493 | 0.02767573086303493 | 31
32 | 0.7273041052711735 | 27.26958947288265 | 399.5858104205095 | 1.374940678531097 | 37.49406785310974 | 0.03667088574965227 | 0.02667088574965227 | 32
33 | 0.7201030745259144 | 27.98969254740856 | 422.629108805339 | 1.388690085316408 | 38.86900853164084 | 0.03572743781683967 | 0.02572743781683966 | 33
34 | 0.7129733411147666 | 28.70266588852333 | 446.1572290621266 | 1.402576986169572 | 40.25769861695726 | 0.03483996935629059 | 0.02483996935629058 | 34
35 | 0.7059141991235314 | 29.40858008764687 | 470.1583118323274 | 1.416602756031268 | 41.66027560312683 | 0.03400368181733643 | 0.02400368181733643 | 35
36 | 0.6989249496272587 | 30.10750503727412 | 494.6206850692806 | 1.430768783591581 | 43.07687835915809 | 0.03321430981285117 | 0.02321430981285117 | 36
37 | 0.6920049006210482 | 30.79950993789517 | 519.5328614916384 | 1.445076471427497 | 44.50764714274968 | 0.03246804907014503 | 0.02246804907014503 | 37
38 | 0.685153366951533 | 31.48466330484671 | 544.8835360688458 | 1.459527236141772 | 45.95272361417717 | 0.03176149575803345 | 0.02176149575803345 | 38
39 | 0.6783696702490425 | 32.16303297509575 | 570.6615835383091 | 1.474122508503189 | 47.41225085031895 | 0.03109159514820362 | 0.02109159514820362 | 39
40 | 0.6716531388604381 | 32.83468611395619 | 596.856055953866 | 1.488863733588221 | 48.88637335882214 | 0.03045559797737661 | 0.02045559797737661 | 40
41 | 0.665003107782612 | 33.49968922173881 | 623.456180265171 | 1.503752370924104 | 50.37523709241036 | 0.02985102319549503 | 0.01985102319549504 | 41
42 | 0.6584189185966455 | 34.15810814033545 | 650.4513559276338 | 1.518789894633345 | 51.87898946333447 | 0.02927562603559869 | 0.01927562603559869 | 42
43 | 0.6518999194026194 | 34.81000805973807 | 677.8311525425429 | 1.533977793579678 | 53.39777935796781 | 0.02872737053906688 | 0.01872737053906688 | 43
44 | 0.6454454647550686 | 35.45545352449314 | 705.5853075270106 | 1.549317571515475 | 54.93175715154749 | 0.02820440582741906 | 0.01820440582741906 | 44
45 | 0.6390549155990779 | 36.09450844009222 | 733.7037238133712 | 1.56481074723063 | 56.48107472306297 | 0.02770504553787587 | 0.01770504553787587 | 45
46 | 0.6327276392070078 | 36.72723607929922 | 762.1764675776867 | 1.580458854702936 | 58.0458854702936 | 0.02722774994123872 | 0.01722774994123872 | 46
47 | 0.6264630091158493 | 37.35369908841508 | 790.9937659970155 | 1.596263443249965 | 59.62634432499654 | 0.02677111034259365 | 0.01677111034259366 | 47
48 | 0.6202604050651973 | 37.97395949348027 | 820.1460050350797 | 1.612226077682465 | 61.2226077682465 | 0.02633383543192775 | 0.01633383543192775 | 48
49 | 0.6141192129358389 | 38.58807870641611 | 849.6237272560002 | 1.62834833845929 | 62.83483384592897 | 0.02591473930609891 | 0.01591473930609891 | 49
50 | 0.6080388246889494 | 39.19611753110505 | 879.4176296657588 | 1.644631821843883 | 64.46318218438826 | 0.02551273092816974 | 0.01551273092816974 | 50
51 | 0.6020186383058905 | 39.79813616941095 | 909.5185615810537 | 1.661078140062322 | 66.10781400623215 | 0.02512680482682014 | 0.01512680482682013 | 51
52 | 0.5960580577286044 | 40.39419422713956 | 939.9175225252125 | 1.677688921462945 | 67.76889214629446 | 0.02475603286890501 | 0.01475603286890501 | 52
53 | 0.5901564928005985 | 40.98435071994015 | 970.605660150844 | 1.694465810677574 | 69.44658106775742 | 0.0243995569634209 | 0.01439955696342089 | 53
54 | 0.5843133592085133 | 41.56866407914867 | 1001.574268188895 | 1.71141046878435 | 71.14104687843499 | 0.02405658257614326 | 0.01405658257614326 | 54
55 | 0.5785280784242706 | 42.14719215757295 | 1032.814784423806 | 1.728524573472193 | 72.85245734721934 | 0.02372637295175834 | 0.01372637295175834 | 55
56 | 0.5728000776477926 | 42.71999223522073 | 1064.318788694435 | 1.745809819206915 | 74.58098192069153 | 0.02340824395505261 | 0.01340824395505261 | 56
57 | 0.5671287897502898 | 43.28712102497103 | 1096.07800092045 | 1.763267917398984 | 76.32679173989845 | 0.02310155945513517 | 0.01310155945513517 | 57
58 | 0.5615136532181086 | 43.84863467818913 | 1128.084279153883 | 1.780900596572975 | 78.09005965729743 | 0.02280572718715488 | 0.01280572718715488 | 58
59 | 0.5559541120971373 | 44.40458879028628 | 1160.329617655517 | 1.798709602538704 | 79.87096025387041 | 0.02252019503485989 | 0.01252019503485989 | 59
60 | 0.5504496159377597 | 44.95503840622403 | 1192.806144995845 | 1.816696698564091 | 81.66966985640912 | 0.02224444768490176 | 0.01224444768490176 | 60
65 | 0.5237339223210913 | 47.62660776789087 | 1358.390281701993 | 1.90936648817435 | 90.93664881743501 | 0.02099666650359643 | 0.01099666650359644 | 65
70 | 0.4983148565242166 | 50.16851434757833 | 1528.647439088316 | 2.006763368395385 | 100.6763368395385 | 0.01993282067457257 | 0.00993282067457257 | 70
75 | 0.4741294876074721 | 52.58705123925279 | 1702.733966869238 | 2.109128468356078 | 110.9128468356079 | 0.01901608811359945 | 0.009016088113599448 | 75
80 | 0.4511179389410789 | 54.8882061058921 | 1879.877099060579 | 2.216715217194258 | 121.6715217194258 | 0.01821885011273219 | 0.00821885011273219 | 80
85 | 0.429223239966313 | 57.0776760033687 | 2059.370060623209 | 2.32978997148077 | 132.978997148077 | 0.01751998451970925 | 0.007519984519709254 | 85
90 | 0.4083911851513445 | 59.16088148486555 | 2240.567482124454 | 2.448632674648481 | 144.8632674648481 | 0.01690306119349859 | 0.006903061193498588 | 90
95 | 0.388570199792559 | 61.14298002074409 | 2422.881104045098 | 2.573537550058798 | 157.3537550058798 | 0.01635510731830094 | 0.006355107318300942 | 95
100 | 0.3697112123291189 | 63.0288787670881 | 2605.775753417622 | 2.704813829421528 | 170.4813829421528 | 0.01586574312539051 | 0.00586574312539051 | 100