How to Calculate Present Value in Excel With Examples
Sometimes the present value, the future value, and the interest rate for discounting are known, but the length of time before the future value occurs is unknown. To illustrate, let’s assume that $1,000 will be invested today at an annual interest rate of 8% compounded annually. Because we know three components, we can solve for […]
How to Calculate Present Value in Excel With Examples Read More »