Thursday, 31 October 2013

Calculating the Single Amount (PV)

If we know the future value (FV), the number of time periods of compound interest (n), and the interest rate (i), we can use future value factors to calculate the unknown amount that was originally deposited (the “present value,” or PV). Calculations #13 through #16 illustrate how to determine the present value (PV).

(Note: The single amount can also be calculated by using present value factors. This is discussed in the AccountingCoach topic Present Value of a Single Amount.)



Calculation #13.
Joan wishes to make one deposit today into an individual retirement account (IRA) that is guaranteed to earn 6% per year compounded annually. She wants the amount deposited to grow to $10,000 at the end of 12 years. How much will she need to deposit today?

The following timeline plots the variables that are known and unknown:

PV =??




FV =$10,000





.....



← 1 year →← 1 year →← 1 year →


← 1 year →
0123

1112

n = 12 years; i = 6% per year

Calculation using the FV of 1 Table:

FV  =  PV x [FV factor n = 12 years, i = 6% per year]
$10,000  =  PV x [2.012] ←FV factor from FV of 1 Table
$10,000/2.012  =  PV
$4,970.18  =  PV

In order to have a future value of $10,000 in 12 years, Joan must deposit $4,970.18 today in her IRA.



Calculation #14.
What amount will you need to invest today in order to have $15,000 at the end of 10 years? Assume your amount will earn 10% per year compounded semiannually.

The following timeline plots the variables that are known and unknown:

PV =$??




FV =$15,000





.....



← 6 months →← 6 months →← 6 months →


← 6 months →
0123

1920

n = 20 semiannual periods; i = 5% per semiannual period

Because the interest is compounded semiannually, we convert the 10 annual time periods to20 semiannual time periods. Similarly, the interest rate is converted from 10% per year to 5% per semiannual period.

Calculation using the FV of 1 Table:
FV  =  PV x [FV factor n = 20 semiannual periods, i = 5% per semiannual period]
$15,000  =  PV x [2.653] ←FV factor from FV of 1 Table
$15,000/2.653  =  PV
$5,653.98  =  PV

You need to invest $5,653.98 today in order to have it grow to $15,000 in 20 six-month periods with interest at 10% per year compounded semiannually.



Calculation #15.
What amount today will grow to $30,000 at the end of 7 years if the amount earns 8% per year compounded quarterly

The following timeline plots the variables that are known and unknown:

PV =??




FV =$30,000





.....



← 3 months →← 3 months →← 3 months →


← 3 months →
0123

2728

n = 28 quarters; i = 2% per quarter

Because the interest is compounded quarterly, we convert the 7 one-year time periods to 28 quarters. Similarly, the interest rate is converted from 8% per year to 2% per quarter. In other words, n = 28 quarters, and i = 2% per quarter.

Calculation using the FV of 1 Table:
FV  =  PV x [FV factor n = 28 quarters, i = 2% per quarter]
$30,000  =  PV x [1.741] ←FV factor from FV of 1 Table
$30,000/1.741  =  PV
$17,231.48  =  PV

A single deposit of $17,231.48 will grow to $30,000 if it remains invested at 8% per yearcompounded quarterly for 7 years.



Calculation #16.
The number of visitors to Bill’s website is increasing at an annual rate of 36% compounded monthly. At the end of one year Bill expects the number of visitors to his site to reach 50,000 per day. What is the present number of visitors per day?

The following timeline plots the variables that are known and unknown:

PV =??




FV =50,000





.....



← 1 month →← 1 month →← 1 month →


← 1 month →
0123

1112

n = 12 months; i = 3% per month

Because the rate is compounded monthly, we convert the one-year time period to 12 monthly time periods. Similarly, the rate is converted from 36% per year to 3% per month.

Calculation using the FV of 1 Table:
FV  =  PV x [FV factor n = 12 months, i = 3% per month]
50,000  =  PV x [1.426] ←FV factor from FV of 1 Table
50,000/1.426  =  PV
35,063  =  PV

The present amount of visitors per day must be 35,063 if a 3% per month compounded increase results in 50,000 visitors per day after 12 months. (You can verify the answer 35,063 by using the table below.)

#16 Proof
We will assume that the present time is Dec 31, 2011.
Date
End of Period No.
Amount of Increase*
Total Amount
Dec 31, 2011
35,063
Jan 31, 2012
1
1,052
36,115
Feb 28, 2012
2
1,083
37,198
Mar 31, 2012
3
1,116
38,314
Apr 30, 2012
4
1,149
39,464
May 31, 2012
5
1,184
40,648
Jun 30, 2012
6
1,219
41,867
Jul 31, 2012
7
1,256
43,123
Aug 31, 2012
8
1,294
44,417
Sep 30, 2012
9
1,333
45,749
Oct 31, 2012
10
1,372
47,122
Nov 30, 2012
11
1,414
48,535
Dec 31, 2012
12
1,456
49,991
*3% of the previous “Total Amount.” 

If our future value factors were not rounded to 3 decimal places, the present number of visitors per day at December 31, 2011 would have been 35,069 and that would result in 50,000 at Dec 31, 2012.

No comments:

Post a Comment