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

Q: Using Excel, create a table that shows the relationship among the units of height of people in…

A: Given Data Starting height value = 150 cm End height value = 2 m = 200 cm Increment = 5 cm

Q: The sum of the digits of a three-digit number is 17. The units digit being 4 times the hundreds…

A: Given data: Sum of three digits =17  units digit being 4 times the hundreds digit.  If 594 is Added…

Q: Example: The two cash flows in Figure 3.38 are equivalent at an interest rate of 12% compounded…

A: Now present worth of first cash flow :

Q: Eckelberger Products Inc. makes high-speed recorders with high-speed scanning. The small company has…

A: Answer  We know that annual growth rate can be converted into effective growth rate monthly using…

Q: Based on the data shown below, calculate the correlation coefficient (to three decimal places) x y…

A: Tabulate the following. x y x2 y2 xy 2 16.75 4 280.5625 33.5 3 15.8 9 249.64 47.4 4 13.55…

Q: Shiela performed a number trick to Bryan. She let Bryan pick a number divisible by two. She then…

A: Asked: To determine the Shiela told Bryan.

Q: Suppose X is a random variable defined as final cost of project X = estimated cost of project which…

A: The random variable X can be expressed as, X=FC Here, the variable is X, F, is the final cost of the…

Q: A man wants to buy five materials for a 5 day work as shown in table 1.1 and for each item, the…

A:

Q: What is the equivalent annual worth of the cash flow given in the accompanying figure? Assume i = 8%…

A: Given:- i=8%To find:-the equivalent annual worth

Q: For the net cash flow series, find the external rate of return (EROR) using the MIRR method with an…

A:

Q: ECONOMICS An item worth P60,000 is payable in 60 days or P57,500 payable in 15 days. Find the…

A: The formula for simple interest helps you find the interest amount if the principal amount, rate of…

Q: Using Excel, create a table that shows the relationship among the units of mass to describe…

A: GIven, Range of mass 20kg-120 kg increment of 5 kg

Q: estimate the accumulated amount in a fund earning 5% interest at the end of 11 years if $270 is…

A: Given: The interest is 5%. The time period is 11 years. The deposited amount each year is $270.

Electronic Spreadsheet

Tabular listing has many advantages ranging from time management to efficient scheduling of tasks. Electronic spreadsheets allow the user to tabulate and analyze data, using its easy-to-use interface. An electronic spreadsheet is a staple application used among accountants, management staff, and IT professionals. It is used in various sectors worldwide for data management. An electronic spreadsheet is a system and computer software that could be used to do numerical computations automatically. Spreadsheet application programs are often organized as a table with rows and columns. Each row and column intersect to form a cell, which may be used to store data. These data can take the form of a written label, a number, or a formula that combines information from other cells.