In: Finance
Find the present values of these ordinary annuities. Discounting occurs once a year. Round your answers to the nearest cent. $500 per year for 10 years at 12%. $ $250 per year for 5 years at 6%. $ $400 per year for 16 years at 0%. $ Rework previous parts assuming that they are annuities due. Round your answers to the nearest cent. $500 per year for 10 years at 12%. $ $250 per year for 5 years at 6%. $ $400 per year for 16 years at 0%. $
Solution: | ||
a. | present values of these ordinary annuities | |
$500 per year for 10 years at 12%. | $2,825.11 | |
$250 per year for 5 years at 6% | $1,053.09 | |
$400 per year for 16 years at 0% | $6,400.00 | |
Working Notes: | ||
Present value of annuity = P x (1-(1/(1+i)^n))/i | ||
P= annual cash flow | ||
i=interest rate | ||
n= no. Of years | ||
$500 per year for 10 years at 12%. | ||
Present value of annuity = P x (1-(1/(1+i)^n))/i | ||
P= annual cash flow = $500 | ||
i=interest rate =12% | ||
n= no. Of years = 10 years | ||
Present value of annuity = P x (1-(1/(1+i)^n))/i | ||
= 500 x (1-(1/(1+.12)^10))/.12 | ||
=2825.111514 | ||
=$2,825.11 | ||
$250 per year for 5 years at 6% | ||
Present value of annuity = P x (1-(1/(1+i)^n))/i | ||
P= annual cash flow = $250 | ||
i=interest rate =6% | ||
n= no. Of years = 5 years | ||
Present value of annuity = P x (1-(1/(1+i)^n))/i | ||
= 250 x (1-(1/(1+.06)^5))/.06 | ||
=1,053.090946 | ||
=$1,053.09 | ||
$400 per year for 16 years at 0% | ||
P= annual cash flow = $400 | ||
i=interest rate =0% | ||
n= no. Of years = 16 years | ||
Present value of annuity = P x n | ||
= 400 x 16 | ||
=6,400.00 | ||
these can also be calculated using excel formula | ||
=PV(rate,nper,pmt,(FV),(type)) | ||
For | $500 per year for 10 years at 12%. | |
rate=12% | ||
nper=10 | ||
pmt=-$500 | ||
fv=0 | ||
type= 0 for ordinary annuity | ||
=PV(rate,nper,pmt,(FV),(type)) | ||
=PV(12%,10,-500,0,0) | ||
2825.111514 | ||
For | $250 per year for 5 years at 6% | |
rate=6% | ||
nper=5 | ||
pmt=-$250 | ||
fv=0 | ||
type= 0 for ordinary annuity | ||
=PV(rate,nper,pmt,(FV),(type)) | ||
=PV(6%,5,-250,0,0) | ||
1053.090946 | ||
For | $400 per year for 16 years at 0% | |
rate=0% | ||
nper=16 | ||
pmt=-$400 | ||
fv=0 | ||
type= 0 for ordinary annuity | ||
=PV(rate,nper,pmt,(FV),(type)) | ||
=PV(0%,16,-400,0,0) | ||
6400 | ||
b. | present values of these ordinary annuities due | |
$500 per year for 10 years at 12%. | $3,164.12 | |
$250 per year for 5 years at 6% | $1,116.28 | |
$400 per year for 16 years at 0% | $6,400.00 | |
Working Notes: | ||
Present value of annuity due = P x (1+i) (1-(1/(1+i)^n))/i | ||
P= annual cash flow | ||
i=interest rate | ||
n= no. Of years | ||
$500 per year for 10 years at 12%. | ||
Present value of annuity due = P x (1+i) (1-(1/(1+i)^n))/i | ||
P= annual cash flow = $500 | ||
i=interest rate =12% | ||
n= no. Of years = 10 years | ||
Present value of annuity due = P x (1+i) (1-(1/(1+i)^n))/i | ||
= 500 x (1+.12) (1-(1/(1+.12)^10))/.12 | ||
=3,164.124896 | ||
=$3,164.12 | ||
$250 per year for 5 years at 6% | ||
Present value of annuity due = P x (1+i) (1-(1/(1+i)^n))/i | ||
P= annual cash flow = $250 | ||
i=interest rate =6% | ||
n= no. Of years = 5 years | ||
Present value of annuity due = P x (1+i) (1-(1/(1+i)^n))/i | ||
= 250 x (1+0.06) (1-(1/(1+.06)^5))/.06 | ||
=1,116.2764 | ||
=$1,116.28 | ||
$400 per year for 16 years at 0% | ||
P= annual cash flow = $400 | ||
i=interest rate =0% | ||
n= no. Of years = 16 years | ||
Present value of annuity = P x16 | ||
= 400 x 16 | ||
=6,400.00 | ||
these can also be calculated using excel formula | ||
=PV(rate,nper,pmt,(FV),(type)) | ||
For | $500 per year for 10 years at 12%. | |
rate=12% | ||
nper=10 | ||
pmt=-$500 | ||
fv=0 | ||
type= 1 for annuity DUE | ||
=PV(rate,nper,pmt,(FV),(type)) | ||
=PV(12%,10,-500,0,1) | ||
3164.124896 | ||
$250 per year for 5 years at 6% | ||
rate=6% | ||
nper=5 | ||
pmt=-$250 | ||
fv=0 | ||
type= 1 for annuity DUE | ||
=PV(rate,nper,pmt,(FV),(type)) | ||
=PV(6%,5,-250,0,1) | ||
1116.276403 | ||
$400 per year for 16 years at 0% | ||
rate=0% | ||
nper=16 | ||
pmt=-$400 | ||
fv=0 | ||
type= 1 for annuity DUE | ||
=PV(rate,nper,pmt,(FV),(type)) | ||
=PV(0%,16,-400,0,1) | ||
6400 | ||
Notes: | When there is 0% rate of interest present value will be just total amount deposited . | |
Please feel free to ask if anything about above solution in comment section of the question. |