Determine the numerical value of the following factors using (a) linear interpolation, (b) the formula, and (c) the spreadsheet function from Figure 2-9.
(a) 1. Interpolate between i = 8% and i = 9% at n = 15:
0.4/1 = x/(0.3152 – 0.2745)
x = 0.0163
(P/F,8.4%,15) = 0.3152 – 0.0163
= 0.2989
2. Interpolate between i = 16% and i = 18% at n = 10:
1/2 = x/(0.04690 - 0.04251)
x = 0.00220
(A/F,17%,10) = 0.04690 – 0.00220
= 0.04470
Solution continued on the next page....
(b) 1. (P/F,8.4%,15) = 1/(1 + 0.084)15
= 0.2982
2. (A/F,17%,10) = 0.17/[(1 + 0.17)10 - 1]
= 0.04466
(c) 1. = -PV(8.4%,15,,1) displays 0.29824
2. = -PMT(17%,10,,1) displays 0.04466
You might also like to view...
"Organically produced foods" have now been defined by the ________
a. NRCS c. USDA b. FDA d. EPA
A sticky, putty-like feel indicates a high percentage of which soil separate?
A) clay B) silt C) sand D) humus E) none of the above
Which of these wires is MOST likely used for starter motor high current circuits?
A) 18 ga. B) 14 ga. C) 20 ga. D) 0 ga.
Reduces flash gas in the liquid line D) oil separator
What will be an ideal response?