Present Value (PV) – Excel Template – 365 Financial Analyst

Home Templates Present Value (PV) – Excel Template

Present Value (PV) – Excel Template

Ivan Kitov

Present value (PV)—also known as a discount value—measures the value of future cash flows in today’s dollar. It is commonly used to evaluate whether a project or stock is worth investing in today.

This open-access Excel template is a useful tool for bankers, investment professionals, and corporate finance practitioners.

Present value is among the topics included in the Quantitative Methods module of the CFA Level 1 Curriculum. Gain valuable insights into the subject with our Math for Finance course.

You can also explore other related templates such as—Future Value and Time Value of Money.

By continuing you agree to 365 Data Science’s Terms of Use and Privacy Policy

Most Popular Resources

Check out our most helpful downloadable resources according to 365 Finance Analyst’s students and expert team of instructors.

3-Statement Model – Excel Template

The P&L, Balance sheet, and Cash flow statements are three interrelated parts. The P&L feeds net income on the l...

Types of Costs – Infographic

Infographic on Types of Costs, detailing cost classification, cost structure, incurred costs meaning, and the difference...

IF AND Excel – Template

IF AND Excel template demonstrating the use of IF&AND functions in Excel for logical analysis and decision-making.

Equity Investments Cheat Sheet

Equity investments involve purchasing company shares on the stock market, with investors aiming to benefit from a firm�...

15 Ways to Visualize Revenue in Excel – Template

Download for FREE our Revenue in Excel template and visualize your financial data effectively.

Balance Sheet – Excel Template

If the P&L statement shows how profitable a company was over a given timeframe, we can say that the Balance...

Excel Shortcuts Cheat Sheet

Our Excel shortcuts cheat sheet is essential for increasing productivity and efficiency. This guide provides an extensiv...

Make Data Invisible – Excel Template

From time to time you might want to hide source data in your worksheet. One way to do that is...

Time Series Analysis – Excel Template

Performing time series analysis consists in studying data points that are organized chronologically and equally spaced i...

Finance Careers to Pursue Infographic

Download for FREE our Finance Careers to Pursue Infographic, providing an overview of key roles with excellent finance j...

Debits and Credits Quiz

Test your accounting knowledge with a free debits and and credits quiz, including six practical questions. Start now!

Financial Derivatives Cheat Sheet

Our Financial Derivatives Cheat Sheet is an invaluable resource for candidates preparing for the CFA Level 1 derivatives...

Top