Use Excel to calculate present value PV using bond price as an example. There are many ways to calculate the present value. We can use present value tables, a financial calculator, math and formulas, or Excel. Each method has its pros and cons but it is important to know that are all doing much the same thing, leading to the same outcome. Excel has many advantages including formatting the present value calculations in different ways to pull more information. Calculating the bond price is a common example for present value calculations because bond prices have two separate cash flows, one being the present value of one and the other being an annuity. The two present value requirements of bonds are perfect for thinking about the main two present value types of calculations.

For more accounting information see website.