If I will have a lump sum of $265,560 in 18 years, how do I calculate the present value of my investment, assuming it will earn interest at the rate of3.45 percent compounded annually? In other words, what is the equivalent today of $265,560 payable as a lump sum 18 years in the future? what excel formula should i use for the following problem??explain in great detail