Question
HW 6 due on 2/26/18 at the very beginning of class the reverse side is a table using an i headings for the columns. the first column stands for the number of years- 1 through 44. The h cs deals with the use of money in engineering proens the Each item in the first row shows what is below fother nterest rate of 8%. The first row serves as the n in columns have formulac associated with them as indicated in the table headings of the other low For example using 8% interest (i) over 33 years (n), the interest time one wanted to find "F", the future worth, given "p", the present F-P(1+iy. The interest substituting the above numbers worth factor would be (F/P, i, n) According to the table below, the associated formula would be time factor that one would multiply by P is (1+i) and gives us 12.6760496, th row with n-33. (Note: change 8% to a decimal e number in the table under that factor's column (2d) and on the 0.08) 8%, like the one on the reverse side able, with Your challenge is to generate a t using Excel. Grading will be as follows: 12 points Accuracy Format/Clarity 4 points Color Creativity20 points 20 points Interest-Time Factor Usc This Formul Given To Find (PIF, in) o)0 t i
Explanation / Answer
Thus, the table is generated using excel, and the given interest-time factor formulas.
n F/P P/F P/A A/P F/A A/F 1 1.08 0.925925926 0.925925926 1.08 1 1 2 1.1664 0.85733882 1.783264746 0.560769231 2.08 0.480769231 3 1.259712 0.793832241 2.577096987 0.388033514 3.2464 0.308033514 4 1.36048896 0.735029853 3.31212684 0.301920804 4.506112 0.221920804 5 1.469328077 0.680583197 3.992710037 0.250456455 5.86660096 0.170456455 6 1.586874323 0.630169627 4.622879664 0.216315386 7.335929037 0.136315386 7 1.713824269 0.583490395 5.206370059 0.192072401 8.92280336 0.112072401 8 1.85093021 0.540268885 5.746638944 0.174014761 10.63662763 0.094014761 9 1.999004627 0.500248967 6.246887911 0.160079709 12.48755784 0.080079709 10 2.158924997 0.463193488 6.710081399 0.149029489 14.48656247 0.069029489 11 2.331638997 0.428882859 7.138964258 0.140076342 16.64548746 0.060076342 12 2.518170117 0.397113759 7.536078017 0.132695017 18.97712646 0.052695017 13 2.719623726 0.367697925 7.903775942 0.126521805 21.49529658 0.046521805 14 2.937193624 0.340461041 8.244236983 0.121296853 24.2149203 0.041296853 15 3.172169114 0.315241705 8.559478688 0.116829545 27.15211393 0.036829545 16 3.425942643 0.291890468 8.851369155 0.112976872 30.32428304 0.032976872 17 3.700018055 0.270268951 9.121638107 0.109629431 33.75022569 0.029629431 18 3.996019499 0.250249029 9.371887136 0.106702096 37.45024374 0.026702096 19 4.315701059 0.231712064 9.6035992 0.104127627 41.44626324 0.024127627 20 4.660957144 0.214548207 9.818147407 0.101852209 45.7619643 0.021852209 21 5.033833715 0.198655748 10.01680316 0.09983225 50.42292144 0.01983225 22 5.436540413 0.183940507 10.20074366 0.098032068 55.45675516 0.018032068 23 5.871463646 0.170315284 10.37105895 0.096422169 60.89329557 0.016422169 24 6.341180737 0.157699337 10.52875828 0.094977962 66.76475922 0.014977962 25 6.848475196 0.146017905 10.67477619 0.093678779 73.10593995 0.013678779 26 7.396353212 0.135201764 10.80997795 0.092507127 79.95441515 0.012507127 27 7.988061469 0.125186818 10.93516477 0.091448096 87.35076836 0.011448096 28 8.627106386 0.115913721 11.05107849 0.090488906 95.33882983 0.010488906 29 9.317274897 0.107327519 11.15840601 0.089618535 103.9659362 0.009618535 30 10.06265689 0.099377333 11.25778334 0.088827433 113.2832111 0.008827433 31 10.86766944 0.092016049 11.34979939 0.088107284 123.345868 0.008107284 32 11.737083 0.085200045 11.43499944 0.087450813 134.2135374 0.007450813 33 12.67604964 0.078888931 11.51388837 0.086851632 145.9506204 0.006851632 34 13.69013361 0.073045306 11.58693367 0.08630411 158.6266701 0.00630411 35 14.78534429 0.067634543 11.65456822 0.085803265 172.3168037 0.005803265 36 15.96817184 0.062624577 11.71719279 0.085344674 187.102148 0.005344674 37 17.24562558 0.057985719 11.77517851 0.084924403 203.0703198 0.004924403 38 18.62527563 0.053690481 11.82886899 0.084538936 220.3159454 0.004538936 39 20.11529768 0.049713408 11.8785824 0.08418513 238.941221 0.00418513 40 21.7245215 0.046030933 11.92461333 0.083860162 259.0565187 0.003860162 41 23.46248322 0.042621235 11.96723457 0.083561494 280.7810402 0.003561494 42 25.33948187 0.039464106 12.00669867 0.083286841 304.2435234 0.003286841 43 27.36664042 0.036540839 12.04323951 0.083034137 329.5830053 0.003034137 44 29.55597166 0.03383411 12.07707362 0.082801516 356.9496457 0.002801516
