Present value is the current value of an expected future stream of cash flow. The concept is simple. For example, assume that you aim to save $10,000 in a savings account five years from today and the interest rate is 3% per year. You would need to figure out how much is needed to invest today, or the present value. The formula for present value is PV = FV ÷ (1+r)^n; where FV is the future value, r is the interest rate and n is the number of periods. Using information from the above example, PV = 10,000÷(1+.03)^5, or $8,626.09, which is the amount you would need to invest today.
On Microsoft Excel, there is a builtin function to find the present value, given the required arguments. For example, if you expect to have $50,000 in your banking account 10 years from now, with the interest rate at 5%, you can figure out the amount that would be invested today to achieve this. Using Excel, enter "Year" in cell A1. From cells B1 to L1, enter years 0 to 10. In cell A2, enter "Interest Rate" and enter 5% for all cells from C2 to L2. Now in cell A3, enter “Future Value” and $50,000 into cell L3. The builtin function PV can easily calculate the present value with the given information. Enter "Present Value" into cell A4, then select cell L4 and enter "=PV(L2, L1, 0, L3)." Since this is not based on payments, 0 is used for the pmt argument. The present value is calculated to be ($30,695.66), since you would need to put this amount into your account; it is considered to be a loss.

What is the difference between Macaulay duration and modified duration?
Find out more about the forward price to earnings ratio and how to calculate the forward price to earnings ratios of companies ... Read Answer >> 
How do I calculate the expected return of my portfolio in Excel?
Find out how to calculate the total expected annual return of your portfolio in Microsoft Excel using the value and return ... Read Answer >> 
What is the formula for calculating return on equity (ROE) in Excel?
Find out more about return on equity, the formula to calculate it and how to calculate return on equity in Microsoft Excel. Read Answer >> 
What is the formula for calculating the capital asset pricing model (CAPM) in Excel?
Find out more about the capital asset pricing model (CAPM) and the formula for calculating it in Microsoft Excel. Read Answer >> 
What is the formula for calculating free cash flow in Excel?
Find out more about free cash flow, the formula for calculating free cash flow and how to calculate a company's free cash ... Read Answer >> 
How can I calculate the cash ratio of a company in Excel?
Find out more about the cash ratio, what the cash ratio measures and how to calculate a company's cash ratio using Microsoft ... Read Answer >>

Trading
Improve your investing with Excel
Excel is a useful tool to assist with investment organization and evaluation. Find out how to use it. 
Retirement
Present and Future Value of Annuities
Do you want to invest in annuities that get you a series of payments over a period of time. Here's everything you need to account for when calculating the present and future value of annuities. 
Personal Finance
6 Tips For Getting A Good Cell Phone Plan
Avoid overspending on cell service with this expert advice. 
Insights
Cell Phone Evolution
Follow the evolution of cell phones from 20 pound bricks to the sleek smart phones of today. 
Financial Advisor
Calculate PV of different bond type with Excel
To determine the value of a bond today — for a fixed principal (par value) to be repaid in the future — we can use an Excel spreadsheet. 
Personal Finance
How Cell Phones Have Changed Your Budget
The cost of owning a cell phone wasn't a factor for people less than two decades ago. Today, there seems to be no end to the additional charges that come from owning a smartphone. 
Investing
Guide To Excel For Finance
Formulas, functions and features you need to know when using Excel for financial analysis.

Stated Annual Interest Rate
A stated annual interest rate is the return on an investment ... 
Adjusted Present Value  APV
The Net Present Value (NPV) of a project if financed solely by ... 
Manufacturing Cells
Manufacturing cells are sets of machines that are grouped by ... 
Compound Interest
Compound Interest is interest calculated on the initial principal ... 
Net Present Value Rule
The net present value rule (NPV) states an investment should ... 
Bullet Bond
A bullet bond is a debt instrument whose entire face value is ...