- + Industrial Cost Estimating Excel Assignment 10 Time Value of Money The time value of money refers to the changes in the nominal value of money due to inflation or deflation. The rate of change is usually referred to as interest in simple cases. The value that money will have at some time in the future can be calculated from the known interest rate and the number of periods into the future that are desired. The simplest form is known as simple interest and the calculation is that interest equals the principal times the interest rate times the number of periods or I-p.Ni. What is actually needed, however, is the future value of the money which will be equal to the principal plus the interest or E-P+1=P ( + Ni) Or in the nomenclature of the time value of money, the simple interest factor is SI = (F/P,1%.N) = 1 + Ni There are 6 different measures of the time value of money that are of interest in estimating. As a general rule these measures are expressed as factors or multipliers on the current value of the money, usually call the principal. For a given interest rate, i, and a given number of periods, 1, these factors are: SINGLE PAYMENT, COMPOUND AMT (F/P.%1,0) - SPCA SINGLE PAYMENT, PRESENT WORTH (P/F%l.n) -1/SPCA SPPW - 1/1 CAPITAL RECOVERY (A/P %l.n) - CR - 1*(1+1(+101) UNIFORM SERIES, PRESENT WORTH (P/A.%.n) USPW * 1/CR [(1+iX-17 SINKING FUND (A/F.%10) SE [eltir-1] UNIFORM SERIES, COMPOUND AMT (F/A.961.) USCA T/SF [(liyi Using Excel, create a template that would permit the user to enter an interest rate and calculate each of the time value of money factors to 36 periods