Learn to calculate present value (PV) in Excel using rate and period inputs for better investment comparisons and informed financial decisions.

David Kindness is a Certified Public Accountant (CPA) and an expert in the fields of financial accounting, corporate and individual tax planning and preparation, and investing and retirement planning.

When teaching financial accounting, faculty often discuss bonds payable and how to calculate the issue price of a bond. The next time you cover this topic, consider teaching students how to calculate ...

Present value (PV) is an accounting term meaning the value today of some amount of money expected to be available one or more years in the future. The concept behind this is that money available in ...

To find an investment's interest rate, substitute price, face value, and duration into a formula. For T-bills, subtract purchase price from face value, divide by face value, adjust for term. Online ...

Calculating the interest rate using the present value formula can at first seem impossible. However, with a little math and some common sense, anyone can quickly calculate an investment's interest ...