The easiest and most accurate way to calculate the present value of any future amounts (single amount, varying amounts, annuities) is to use an electronic financial calculator or computer software. Some electronic financial calculators are now available for less than $35. Show IMPORTANT! Understand that each financial calculator operates differently and may operate in a manner that is different from our Explanation. Be certain to read and thoroughly understand the directions before operating any calculator or computer software. One incorrect assumption, one incorrect input, or the use of a button that works differently from what you assumed, will mean an incorrect answer—and that could have a significant financial consequence! If you don't have access to an electronic financial calculator or software, an easy way to calculate present value amounts is to use present value tables (PV tables). PV tables cannot provide the same level of accuracy as financial calculators or computer software because the factors used in the tables are rounded off to fewer decimal places. In addition, they usually contain a limited number of choices for interest rates and time periods. Despite this, present value tables remain popular in academic settings because they are easy to incorporate into a textbook. Because of their widespread use, we will use present value tables for solving our examples. Behind every table, calculator, and piece of software, are the mathematical formulas needed to compute present value amounts, interest rates, the number of periods, and the future value amounts. We will, at the outset, show you several examples of how to use the present value formula in addition to using the PV tables. Except for minor differences due to rounding, answers to equations below will be the same whether they are computed using a financial calculator, computer software, PV tables, or the formulas. Calculating the Present Value of a Single Amount (PV)In this section we will demonstrate how to find the present value of a single future cash amount, such as a receipt or a payment. We'll refer to the present value of a single amount as PV. Exercise #1Let's assume we are to receive $100 at the end of two years. How do we calculate the present value of the amount, assuming the interest rate is 8% per year compounded annually? The following timeline depicts the information we know, along with the unknown component (PV): Calculation Using the PV Formula The present value formula for a single amount is: Using the second version of the formula, the solution is: The answer, $85.73, tells us that receiving $100 in two years is the same as receiving $85.73 today, if the time value of money is 8% per year compounded annually. ("Today" is the same concept as "time period 0.") Calculation Using a PV of 1 Table It's common for accounting and finance textbooks to provide present value tables to use in calculating present value amounts. In a PV of 1 table, each column heading displays an interest rate (i), and the row indicates the number of periods into the future before an amount will occur (n). At the intersection of each column and row is the correlating present value of 1 (PV of 1) factor. The PV of 1 factor tells us what the present value will be, at time period 0, for a single amount of $1 at the end of time period (n). Click the following to see a present value of 1 table: PV of 1 Table. The PV of 1 table has two limitations: (1) values are rounded (ours has the rounding to three decimal places for ease of use) and thus the table sacrifices a bit of accuracy, and (2) the table displays only a limited number of choices for rates and years. Once you determine the PV of 1 factor from the table, simply use it to substitute for the following term in the PV formula: [ 1 ÷ (1 + i)n ] Using the data presented in Exercise #1, we can solve for the present value of receiving $100 at the end of two years, when discounted by an interest rate of 8% compounded annually: Because the PV of 1 table had the factors rounded to three decimal places, the answer ($85.70) differs slightly from the amount calculated using the PV formula ($85.73). In either case, what the answer tells us is that $100 at the end of two years is the equivalent of receiving approximately $85.70 today (at time period 0) if the time value of money is 8% per year compounded annually. Exercise #2We need to calculate the present value (the value at time period 0) of receiving a single amount of $1,000 in 20 years. The interest rate for discounting the future amount is estimated at 10% per year compounded annually. The following timeline depicts the information we know, along with the unknown component (PV): Calculation Using the PV of 1 Formula The answer tells us that receiving $1,000 in 20 years is the equivalent of receiving $148.64 today, if the time value of money is 10% per year compounded annually. Calculation Using a PV of 1 Table We see that the present value of receiving $1,000 in 20 years is the equivalent of receiving approximately $149.00 today, if the time value of money is 10% per year compounded annually. Exercise #3What is the present value of receiving a single amount of $5,000 at the end of three years, if the time value of money is 8% per year, compounded quarterly? The following timeline depicts the information we know, along with the unknown component (PV): Notice that the timeline shows n = 12, because there are 12 quarters in the three-year period. Because the time periods are three months long, the rate for discounting is i = 2% (the quarterly rate that results from the annual rate of 8% divided by the four quarters in each year). Calculation Using the PV Formula The answer tells us that receiving $5,000 three years from today is the equivalent of receiving $3,942.45 today, if the time value of money has an annual rate of 8% that is compounded quarterly. Calculation Using a PV of 1 Table We see that the present value of receiving $5,000 three years from today is approximately $3,940.00 if the time value of money is 8% per year, compounded quarterly. Exercise #4What is the present value of receiving a single amount of $10,000 at the end of five years, if the time value of money is 6% per year, compounded semiannually? The following timeline depicts the information we know, along with the unknown component (PV): Notice that the timeline shows n = 10, because there are 10 six-month (or semiannual) periods in five-years time. Because the compounding occurs semiannually, the rate for discounting is i = 3% per six-month period (the annual rate of 6% divided by the two semiannual periods in each year). Calculation Using the PV Formula The answer tells us that receiving $10,000 five years from today is the equivalent of receiving $7,440.90 today, if the time value of money has an annual rate of 6% compounded semiannually. Calculation Using a PV of 1 Table We see that the present value of receiving $10,000 five years from today is the equivalent of receiving approximately $7,440.00 today, if the time value of money has an annual rate of 6% compounded semiannually. Page 2In the illustrations of the present value of 1 in Part 1 we assumed that interest was compounded on an annual basis. Now we'll look at what happens when interest is compounded (1) annually, (2) semiannually, (3) quarterly, and (4) monthly. The tables below show the number of periods (n) and the related interest rate (i) for four different compounding assumptions. The following table reflects a single amount invested for one year and earning an annual interest rate of 12%: The following table reflects a single amount invested for two years and earning an annual interest rate of 12%: To demonstrate the variations that occur with different compounding assumptions, let's look at an example: Assume that on January 1, 2020, a single deposit of $10,000 was made into each of four accounts. Although each of the four accounts earns an annual interest rate of 12%, the interest is compounded differently. We'll track the account activity for two years.
The next two tables compare selected account balances from each of the four accounts above: Table 1 Table 2 As you have seen, the frequency of compounding requires you to adjust the number of periods (n). Likewise, the interest rate (i) must be adjusted to be compatible with (n). Compounding affects both present value and future value. In Table 2 we see that on December 31, 2021, Account #4—the account that is compounded monthly—has the highest future value: $12,697.35. When interest is deposited monthly, the account earns "interest on interest" more often. In the last column we see a present value factor of 0.78757—this tells us the amount we need in the present time to grow to 1.000 in the future. In other words, because of monthly compounding, we need only deposit $0.78757 today for it to grow to be $1.00 at the end of two years (with a 12% annual interest rate). With less compounding (e.g., annual, semiannual, or quarterly) we need to deposit more today in order for the amount to grow to $1.00 during the same span of time as monthly compounding. PV calculations greatly assist investment decisions because of their ability to bring future amounts into the context of the present (to time period 0). After all, it is hard to relate $100,000 being spent today (a present value) to $300,000 that is expected to be received 20 years from today (a future value). By discounting that future $300,000 to a present value, we can more logically compare it to the $100,000 because both amounts will be expressed in present value amounts. Handling More Than One Future AmountIf there are two or more future amounts occurring at different times for an investment, their present value can be determined by simply discounting each amount separately. For example, if an amount of $5,000 occurs at the end of two years, and a second amount of $6,000 occurs at the end of five years, you simply calculate the present value of each and combine them. If the future amounts are identical in amount and they occur at equal time intervals, the situation is referred to as an annuity. (Learn more at Present Value of an Ordinary Annuity.) Page 3There are occasions when we need to determine the length of time (n) in a Present Value (PV) calculation. To do this, we need to know the three other components in the PV calculation: present value amount, future cash amount (FV), and the interest rate used for discounting the future cash amount (i). Exercise #5What is the length of time involved if a future amount of $5,000 has a present value of $1,000, and the time value of money is 8% compounded annually? The following timeline depicts the information we know, along with the unknown component (n): Calculation Using the Present Value of 1 Table From the information we've been given, we know that the future value is $5,000, the present value is $1,000, and the annual interest rate is 8% compounded annually. Let's plug those numbers into our equation to solve for (n), the number of annual time periods: Our equation tells us that the PV of 1 factor is 0.20040. Since the rate for discounting is 8% compounded annually, we look at the PV of 1 Table in the 8% column and find the amount closest to 0.200; this would be 0.199. We see it is located in the row where n = 21. This tells us that the missing component, length of time, is approximately 21 years. Exercise #6What is the length of time involved if a future amount of $10,000 has a present value of $3,000, and the time value of money is 10% per year compounded semiannually? The following timeline depicts the information we know, along with the unknown component (n): Calculation Using a PV of 1 Table From the information we've been given, we know that the future value is $10,000 and the present value is $3,000. The annual interest rate is 10% compounded semiannually, which we can restate as 5% per semiannual period. When we plug in the information we know, we can solve for (n), the number of semiannual periods: Our equation tells us that the PV factor is 0.30000. Since the rate for discounting is 5% per semiannual period, we look at the PV of 1 Table in the 5% column and find the amount closest to 0.300; this would be 0.295. We see it is located in the row where n = 25. This tells us that the missing component, length of time, is approximately 25 semiannual periods (about 12.5 years). Exercise #7What is the length of time involved if a future amount of $100,000 has a present value of $75,000, and the time value of money is 12% per year compounded monthly? The following timeline depicts the information we know, along with the unknown component (n): Calculation Using a PV of 1 Table Our equation tells us that the PV factor is 0.750. Since the rate for discounting is 1% per month, we look at the PV of 1 Table in the 1% column and find the amount closest to 0.750; this amount would be 0.749. We see it is located in the row where n = 29. This tells us that the missing component, length of time, is approximately 29 months (about 2.4 years). Page 4Now we will show how to find the interest rate (i) for discounting the future amount in a present value (PV) calculation. To do this, we need to know the three other components in the PV calculation: present value amount (PV), future amount (FV), and the length of time before the future amount is received (n). Exercise #8What is the annual interest rate necessary to discount a future amount of $10,000 to a present value of $7,300 over a four-year period, assuming the interest is compounded annually?The following timeline depicts the information we know, along with the unknown component (i): Calculation Using a Present Value of 1 Table Our equation tells us that the PV factor is 0.730. Since the number of periods is four, we look at the PV of 1 Table in the row where n = 4 and find the amount closest to 0.730; this would be 0.735. We see it is located in the column where i = 8%. This tells us that the missing component, the annual interest rate, is approximately 8% compounded annually. Exercise #9What is the annual interest rate necessary to discount a future amount of $100,000 to a present value of $67,000 over a five-year period, assuming the interest is compounded quarterly? The following timeline depicts the information we know, along with the unknown component (i): Calculation Using a PV of 1 Table Our equation tells us that the PV factor is 0.670. Since the number of periods is 20 quarters, we look at the PV of 1 Table in the row where n = 20 and we find the amount closest to 0.670; this would be 0.673. We see it is located in the column where i = 2%. This tells us that the missing component, the interest rate is approximately 2% per quarter. However, the exercise asked for the annual interest rate, compounded quarterly. The annual interest rate is approximately 8% (the quarterly interest rate x four quarters). Exercise #10A future amount of $1,000 will be due in exactly two years. The obligation can be settled today for $790. What is the annual interest rate involved in this arrangement if interest is compounded monthly? The following timeline depicts the information we know, along with the unknown component (i): Calculation Using a PV of 1 Table In equation form, Exercise #10 looks like this: Our equation tells us that the PV factor is 0.790. Since the number of periods is 24 months, we look at the PV of 1 Table in the row where n = 24 and find the amount closest to 0.790; this would be 0.788. We see it is located in the column where i = 1%. This tells us that the missing component, the interest rate (i), is approximately 1% per month. However, the exercise asked for the annual interest rate, compounded monthly. The annual interest rate is approximately 12% (the approximate monthly interest rate x 12 months). Page 5Let's use the Present Value (PV) calculation to record an accounting transaction. On December 31, 2021, Instafix Co. performs a service for MedHealth, Inc. in exchange for a promissory note for $1,000 that will come due on December 31, 2024. The note does not specify any interest and there is no market for the note. The type of service performed by Instafix Co. is highly customized, meaning the fair market value of the service is not available. Instafix Co.'s accountant must record the transaction on December 31, 2021, keeping in mind the following:
To record the cash equivalent amount through a present value calculation, the accountant must estimate the interest rate (i) appropriate for discounting the future amount to the present time. The rate will reflect the length of time before the money will be received as well as the credit worthiness of MedHealth, Inc. Let's assume that the appropriate rate is 10% compounded annually. The following timeline depicts the information we know, along with the unknown component (PV): As our timeline indicates, the length of time is three years, the interest rate is 10% compounded annually, and the future cash amount is $1,000. Let's calculate the present value of this single amount by using a PV of 1 table: Our calculation shows that receiving $1,000 at the end of three years is the equivalent of receiving approximately $751.00 today, assuming the time value of money is 10% per year compounded annually. The cost principle (cash or cash equivalent at the time of the transaction) will be satisfied by recording the amount $751. The revenue recognition principle will also be satisfied, because only $751 has been earned (the amount associated with the services performed in December 2021). The $249 difference between $1,000 and $751 is interest that will be earned in the years 2022, 2023, and 2024. Here is the entry the Instafix Co. accountant records on December 31, 2021: In the years 2022 through 2024, the Instafix Co. will record a total of $249 of interest revenue. If that amount is considered insignificant (with regards to the company's total net income) the company could simply use the straight-line method to record $83 per year ($249 ÷ 3 years), as shown in the following journal entry: Over the years 2022 through 2024, the balance in Discount on Notes Receivable will move from a credit balance of $249 to a balance of zero. (Some accountants would describe this as amortizing the $249 balance to Interest Revenue over the life of the note.) At the end of 2024 and just prior to collecting the $1,000 due on the note, the carrying value of the note will be $1,000 (the $1,000 balance in Notes Receivable minus the $0 balance in Discount on Notes Receivable). Effective Interest Rate Method of Amortizing the Discount If, however, the $249 of interest is considered significant, then the amount of interest recorded each year should be determined by the effective interest rate method. Under this method, the amount of interest revenue recorded is directly tied to the balance (or carrying amount) of the note receivable. In other words, over the years, the interest revenue will increase as the note's carrying value increases: Using the effective interest rate method for interest earned, the journal entries to amortize Discount on Notes Receivable to Interest Revenue over the life of the note are as follows: After posting these journal entries, the account balances will appear as follows: The effective interest rate method must be used when the amount of the discount is significant. The reason for requiring this method of amortizing is to exhibit the logical relationship between the carrying value of the note reported on the balance sheet and the interest reported on the income statement.
We recommend that you now take our free Practice Quiz for this topic so that you can...
Note: You can receive instant access to our PRO materials (visual tutorials, flashcards, quick tests, quick tests with coaching, cheat sheets, video training, bookkeeping and managerial guides, business forms, printable PDF files, and progress tracking) when you join AccountingCoach PRO.
You should consider our materials to be an introduction to selected accounting and bookkeeping topics, and realize that some complexities (including differences between financial statement reporting and income tax reporting) are not presented. Therefore, always consult with accounting and tax professionals for assistance with your specific circumstances. |