Your Ask Joey ™ Answer

How to calculate present value factors?

The present value factor formula is below, and while it may look daunting at first glance, it is easy to remember after you work through it a few times! In the formula, rate represents the cost of capital or the discount rate, while periods equals the number of years.

Present Value Factor Formula Example:

Let’s say that the question tells you the cost of capital is 5% and you need to calculate the present value of a cash inflow 5 years from now? Using the formula, the rate would be 5% and periods would be 5 years. The 3 steps to calculating are as follows:

Step 1) Start by taking 1+5%, which equals 1.05

Step 2) Take 1.05^5 = 1.276282

Step 3) Divide 1 by 1.276282, which = 0.783526

Excel PV Factor Template

Utilize this free Excel template for calculating the present value using any discount rate or cost of capital. This template also includes a column to enter undiscounted annual cash flows to arrive at discounted cash flows.

Back To All Questions

You might also be interested in...

  • Write For Us

    Write For Us Submit your guest blog post! Universal CPA Review welcomes contributors to submit articles for publication on our website. Please review the following guidelines before submitting your article. Due to the high volume of submissions we receive daily, we cannot respond to each one individually. If your article is selected for publication, you...

  • A Guide to Hiring a Small Business Accountant

    Overview Your small business is thriving, sales are up, and you’re poised for a record-breaking year. Exciting times, indeed, but have you thought about the implications for tax filing or financial planning for the upcoming quarter? If these questions are on your mind, it might be time to consult a small business accountant. A skilled...

  • QuickBooks Helps Small Business Beyond Compare

    Introduction Want to work faster, smarter, and better? In today’s business environment, the myriad options for financial management solutions can overwhelm even the most seasoned entrepreneurs. Selecting the right tool for managing business finances is crucial, yet the task is often daunting due to the plethora of available options. This is where QuickBooks comes into...