How to Create an NPV Chart

Business accountants compare potential investments, such as major equipment purchases, according to the calculations such as net present value or internal rate of return. Net present value is the sum value of future revenue streams adjusted by the discount rate minus initial outlay costs. Executives and decision makers can also use net present value (NPV) charts to analyze how discount rates impact the profitability of alternative projects. Creating an NPV chart allows you to present your assessment of investment options.

Instructions

    • 1

      Select discount rates to compare by choosing potential interest rates you could receive for depositing the cash in other investments (such as a secure bank). For example, if you could receive five percent interest on capital deposited in a bank you can use five percent as the discount rate for calculating NPV on other investments.

    • 2

      Add one to the discount rate expressed as a decimal. For example, if the discount rate is five percent you add .05 to 1.

    • 3

      Divide the sum by 100. For example, 1.05 divided by 100 equals .0105.

    • 4

      Raise the result to the power of the given year end times negative one. For example, at the end of year one you would raise .0105 to the power of -1, which equals .952. Record the result as the discount factor for that combination of discount rate and year.

    • 5

      Repeat the process for each year that the investment will have a cash flow (a ten-year lease will have a cash flow for ten years). The discount factor for year 0 (the initial investment year) is always 1.

    • 6

      Create a chart of discount factors. Write out "Year" and "Discount Factor" along the columns. Fill in the values for each year along the rows.

    • 7

      Add a column called "Undiscounted Cash Flow." Fill in the expected cash flow for each year along the rows.

    • 8

      Multiply the chart of discount factors by the undiscounted cash flow (in present dollars) for each year. For example, if year one has a cash flow of negative 20 thousand dollars then the adjusted cash flow is 19.04 thousand dollars. Record the result in a new column titled "Discounted Cash Flow."

    • 9

      Repeat the process to calculate adjusted cash flows for each year the investment will have a cash flow.

    • 10

      Add up each cash flow column. Record the sum of the "Discounted Cash Flow" column as the net present value for the given discount rate.

Learnify Hub © www.0685.com All Rights Reserved