IF a company will generate 80,000 in annual revenue each year for the next eight years and the interest rate is 8.2% what is the present value of the savings?
An EXCEL spreadsheet will be helpful for these types of calculations.
Let S1 be savings in year 1, S2 in year 2, and so on. (For now, unless you have been othewise instructed, assume annual savings is received on the last day of the year.) Let r be the interest rate.
First, calculate the nominal amount of cash that will be there after 8 years.
T = S1*(1+r)^7 + S2*(1+r)^6 ... S8(1+r)^0
Now deflate T by 8 years of annual discounting at rate d. PV = T/(1+d)^8 Since you did'nt specifiy a discount rate d, assume d=r.
Thanks! That is much easier!
456262.25
To calculate the present value of the savings, we can use the formula:
PV = S1*(1+r)^7 + S2*(1+r)^6 + ... + S8*(1+r)^0 / (1+r)^8
Given that the company will generate $80,000 in annual revenue each year for the next eight years and the interest rate is 8.2%, we can substitute the values into the formula.
PV = $80,000*(1+0.082)^7 + $80,000*(1+0.082)^6 + ... + $80,000*(1+0.082)^0 / (1+0.082)^8
Using an Excel spreadsheet will be helpful for these types of calculations. Simply enter the formula into a cell and fill in the values accordingly. The result will be the present value of the savings.