TABLE 20.9 The Interest-Time Factors for i = 8% (Continued) (F/P, i, n) (P/F, i, n) (P/A,i, n) (A/P, i, n) (A/F, i, n) n (F/A, i n) 20 4.66095714 0.21454821 9.81814741 0.10185221 45.76196430 0.02185221 21 5.03383372 0.19865575 10.01680316 0.09983225 50.42292144 0.01983225 22 5.43654041 0.18394051 10.20074366 0.09803207 55.45675516 0.01803207 23 5.87146365 0.17031528 10.37105895 0.09642217 60.89329557 0.01642217 24 6.34118074 0.15769934 10.52875828 0.09497796 66.76475922 0.01497796 25 6.84847520 0.14601790 10.67477619 0.09367878 73.10593995 0.01367878 26 7.39635321 0.13520176 10.80997795 0.09250713 7995441515 0.01250713 27 7.98806147 0.12518682 10.93516477 0.09144810 87.35076836 0.01144810 28 8.62710639 0.11591372 11.05107849 0.09048891 95.33882983 0.01048891 29 9.31727490 0.10732752 11.15840601 0.08961854 103.96593622 0.00961854 30 10.06265689 0.09937733 11.25778334 0.08882743 113.28321111 0.00882743 31 10.86766944 0.09201605 11.34979939 0.08810728 123.34586800 0.00810728 32 11.73708300 0.08520005 11.43499944 0.08745081 134.21353744 0.00745081 33 12.67604964 0.07888893 11.51388837 0.08685163 145.95062044 0.00685163 34 13.69013361 0.07304531 11.58693367 0.08630411 158.62667007 0.00630411 35 14.78534429 0.06763454 11.65456822 0.08580326 172.31680368 0.00580326 36 15.96817184 0.06262458 11.71719279 0.08534467 187.10214797 0.00534467 37 17.24562558 0.05798572 11.77517851 0.08492440 203.07031981 0.00492440 38 18.62527563 0.05369048 11.82886899 0.08453894 220.31594540 0.00453894 39 20.11529768 0.04971341 11.87858240 0.08418513 238.94122103 0.00418513 40 21.72452150 0.04603093 11.92461333 0.08386016 259.05651871 0.00386016 41 23.46248322 0.04262123 11.96723457 0.08356149 280.78104021 0.00356149 42 25.33948187 0.03946411 12.00669867 0.08328684 304.24352342 0.00328684 43 27.36664042 0.03654084 12.04323951 0.08303414 329.58300530 0.00303414 44 29.55597166 0.03383411 12.07707362 0.08280152 356.94964572 0.00280152 45 31.92044939 0.03132788 12.10840150 0.08258728 386.50561738 0.00258728 46 34.47408534 0.02900730 12.13740880 0.08238991 418.42606677 0.00238991 47 37.23201217 0.02685861 12.16426741 0.08220799 452.90015211 0.00220799 48 40.21057314 0.02486908 12.18913649 0.08204027 490.13216428 0.00204027 49 43.42741899 0.02302693 12.21216341 0.08188557 530.34273742 0.00188557 50 46.90161251 0.02132123 12.23348464 0.08174286 573.77015642 0.00174286

Structural Analysis
6th Edition
ISBN:9781337630931
Author:KASSIMALI, Aslam.
Publisher:KASSIMALI, Aslam.
Chapter2: Loads On Structures
Section: Chapter Questions
Problem 1P
icon
Related questions
icon
Concept explainers
Question

Using Excel or a spreadsheet of your choice, create interest–time factor tables, similar to Table 20.9 , for i = 8 5% and i = 9 5%.

TABLE 20.9
The Interest-Time Factors for i = 8% (Continued)
(F/P, i, n)
(P/F, i, n)
(P/A,i, n)
(A/P, i, n)
(A/F, i, n)
n
(F/A, i n)
20
4.66095714
0.21454821
9.81814741
0.10185221
45.76196430
0.02185221
21
5.03383372
0.19865575
10.01680316
0.09983225
50.42292144
0.01983225
22
5.43654041
0.18394051
10.20074366
0.09803207
55.45675516
0.01803207
23
5.87146365
0.17031528
10.37105895
0.09642217
60.89329557
0.01642217
24
6.34118074
0.15769934
10.52875828
0.09497796
66.76475922
0.01497796
25
6.84847520
0.14601790
10.67477619
0.09367878
73.10593995
0.01367878
26
7.39635321
0.13520176
10.80997795
0.09250713
7995441515
0.01250713
27
7.98806147
0.12518682
10.93516477
0.09144810
87.35076836
0.01144810
28
8.62710639
0.11591372
11.05107849
0.09048891
95.33882983
0.01048891
29
9.31727490
0.10732752
11.15840601
0.08961854
103.96593622
0.00961854
30
10.06265689
0.09937733
11.25778334
0.08882743
113.28321111
0.00882743
31
10.86766944
0.09201605
11.34979939
0.08810728
123.34586800
0.00810728
32
11.73708300
0.08520005
11.43499944
0.08745081
134.21353744
0.00745081
33
12.67604964
0.07888893
11.51388837
0.08685163
145.95062044
0.00685163
34
13.69013361
0.07304531
11.58693367
0.08630411
158.62667007
0.00630411
35
14.78534429
0.06763454
11.65456822
0.08580326
172.31680368
0.00580326
36
15.96817184
0.06262458
11.71719279
0.08534467
187.10214797
0.00534467
37
17.24562558
0.05798572
11.77517851
0.08492440
203.07031981
0.00492440
38
18.62527563
0.05369048
11.82886899
0.08453894
220.31594540
0.00453894
39
20.11529768
0.04971341
11.87858240
0.08418513
238.94122103
0.00418513
40
21.72452150
0.04603093
11.92461333
0.08386016
259.05651871
0.00386016
41
23.46248322
0.04262123
11.96723457
0.08356149
280.78104021
0.00356149
42
25.33948187
0.03946411
12.00669867
0.08328684
304.24352342
0.00328684
43
27.36664042
0.03654084
12.04323951
0.08303414
329.58300530
0.00303414
44
29.55597166
0.03383411
12.07707362
0.08280152
356.94964572
0.00280152
45
31.92044939
0.03132788
12.10840150
0.08258728 386.50561738
0.00258728
46
34.47408534
0.02900730
12.13740880
0.08238991
418.42606677
0.00238991
47
37.23201217
0.02685861
12.16426741
0.08220799
452.90015211
0.00220799
48
40.21057314
0.02486908
12.18913649
0.08204027
490.13216428
0.00204027
49
43.42741899
0.02302693
12.21216341
0.08188557
530.34273742
0.00188557
50
46.90161251
0.02132123
12.23348464
0.08174286
573.77015642
0.00174286
Transcribed Image Text:TABLE 20.9 The Interest-Time Factors for i = 8% (Continued) (F/P, i, n) (P/F, i, n) (P/A,i, n) (A/P, i, n) (A/F, i, n) n (F/A, i n) 20 4.66095714 0.21454821 9.81814741 0.10185221 45.76196430 0.02185221 21 5.03383372 0.19865575 10.01680316 0.09983225 50.42292144 0.01983225 22 5.43654041 0.18394051 10.20074366 0.09803207 55.45675516 0.01803207 23 5.87146365 0.17031528 10.37105895 0.09642217 60.89329557 0.01642217 24 6.34118074 0.15769934 10.52875828 0.09497796 66.76475922 0.01497796 25 6.84847520 0.14601790 10.67477619 0.09367878 73.10593995 0.01367878 26 7.39635321 0.13520176 10.80997795 0.09250713 7995441515 0.01250713 27 7.98806147 0.12518682 10.93516477 0.09144810 87.35076836 0.01144810 28 8.62710639 0.11591372 11.05107849 0.09048891 95.33882983 0.01048891 29 9.31727490 0.10732752 11.15840601 0.08961854 103.96593622 0.00961854 30 10.06265689 0.09937733 11.25778334 0.08882743 113.28321111 0.00882743 31 10.86766944 0.09201605 11.34979939 0.08810728 123.34586800 0.00810728 32 11.73708300 0.08520005 11.43499944 0.08745081 134.21353744 0.00745081 33 12.67604964 0.07888893 11.51388837 0.08685163 145.95062044 0.00685163 34 13.69013361 0.07304531 11.58693367 0.08630411 158.62667007 0.00630411 35 14.78534429 0.06763454 11.65456822 0.08580326 172.31680368 0.00580326 36 15.96817184 0.06262458 11.71719279 0.08534467 187.10214797 0.00534467 37 17.24562558 0.05798572 11.77517851 0.08492440 203.07031981 0.00492440 38 18.62527563 0.05369048 11.82886899 0.08453894 220.31594540 0.00453894 39 20.11529768 0.04971341 11.87858240 0.08418513 238.94122103 0.00418513 40 21.72452150 0.04603093 11.92461333 0.08386016 259.05651871 0.00386016 41 23.46248322 0.04262123 11.96723457 0.08356149 280.78104021 0.00356149 42 25.33948187 0.03946411 12.00669867 0.08328684 304.24352342 0.00328684 43 27.36664042 0.03654084 12.04323951 0.08303414 329.58300530 0.00303414 44 29.55597166 0.03383411 12.07707362 0.08280152 356.94964572 0.00280152 45 31.92044939 0.03132788 12.10840150 0.08258728 386.50561738 0.00258728 46 34.47408534 0.02900730 12.13740880 0.08238991 418.42606677 0.00238991 47 37.23201217 0.02685861 12.16426741 0.08220799 452.90015211 0.00220799 48 40.21057314 0.02486908 12.18913649 0.08204027 490.13216428 0.00204027 49 43.42741899 0.02302693 12.21216341 0.08188557 530.34273742 0.00188557 50 46.90161251 0.02132123 12.23348464 0.08174286 573.77015642 0.00174286
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Electronic spreadsheet
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, civil-engineering and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Structural Analysis
Structural Analysis
Civil Engineering
ISBN:
9781337630931
Author:
KASSIMALI, Aslam.
Publisher:
Cengage,
Structural Analysis (10th Edition)
Structural Analysis (10th Edition)
Civil Engineering
ISBN:
9780134610672
Author:
Russell C. Hibbeler
Publisher:
PEARSON
Principles of Foundation Engineering (MindTap Cou…
Principles of Foundation Engineering (MindTap Cou…
Civil Engineering
ISBN:
9781337705028
Author:
Braja M. Das, Nagaratnam Sivakugan
Publisher:
Cengage Learning
Fundamentals of Structural Analysis
Fundamentals of Structural Analysis
Civil Engineering
ISBN:
9780073398006
Author:
Kenneth M. Leet Emeritus, Chia-Ming Uang, Joel Lanning
Publisher:
McGraw-Hill Education
Sustainable Energy
Sustainable Energy
Civil Engineering
ISBN:
9781337551663
Author:
DUNLAP, Richard A.
Publisher:
Cengage,
Traffic and Highway Engineering
Traffic and Highway Engineering
Civil Engineering
ISBN:
9781305156241
Author:
Garber, Nicholas J.
Publisher:
Cengage Learning