Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / Present Value of an Annuity Find the present value of the following ordinary annuities

Present Value of an Annuity Find the present value of the following ordinary annuities

Finance

Present Value of an Annuity Find the present value of the following ordinary annuities. (Notes: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in many situations, to see how changes in input variables affect the output variable. Also, note that you can leave values in the TVM register, switch to Begin Mode, press PV, and find the PV of the annuity due.) Do not round intermediate calculations. Round your answers to the nearest cent. a. $600 per year for 10 years at 14%. $ b. $300 per year for 5 years at 7%. $ c. $600 per year for 5 years at 0%. $ d. Now rework parts a, b, and c assuming that payments are made at the beginning of each year; that is, they are annuities due. Present value of $600 per year for 10 years at 14%: $ Present value of $300 per year for 5 years at 7%: $ Present value of $600 per year for 5 years at 0%:$

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

a. Use PV function in EXCEL to find the present value

=PV(rate,nper,pmt,fv,type)

rate=14%; nper=10 years; pmt=600; fv=0; type=0

=PV(14%,10,600,0,0)=$3129.67

b. rate=7%; nper=5 years; pmt=300;fv=0;type=0

=PV(7%,5,300,0,0)=$1230.06

c. rate=0%,nper=5 years; pmt=600; fv=0;type=0

=PV(0%,5,600,0,0)=$3000

==> For annuity dues (begining of the year payments) only type=1 is the change and the remaining inputs will be same

d. =PV(14%,10,600,0,1)=$3567.82

=PV(7%,5,300,0,1)=$1316.16

=PV(0%,5,600,0,1)=$3000