help in homework

New User?

Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / For each of the following? cases, calculate the present value of the? annuity, assuming the annuity cash flows occur at the end of each year

For each of the following? cases, calculate the present value of the? annuity, assuming the annuity cash flows occur at the end of each year

Finance

For each of the following? cases, calculate the present value of the? annuity, assuming the annuity cash flows occur at the end of each year.  

 

 

Annuity Interest? (%)Period? (Yrs) Present Value? 

 

20,000 5 9

2,000 10 13

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

1.Computation of Present Value of Annuity using PV Function in Excel:

=-pv(rate,nper,pmt,fv)

Here,

PV = Present Value of Annuity = ?

Rate = 5%

Nper = 9 Years

PMT = $20,000

FV = 0

Substituting the values in formula:

=-pv(5%,9,20000,0)

PV or Present Value of Annuity = $142,156.43

 

2.Computation of Present Value of Annuity using PV Function in Excel:

=-pv(rate,nper,pmt,fv)

Here,

PV = Present Value of Annuity = ?

Rate = 10%

Nper = 13 Years

PMT = $20,000

FV = 0

Substituting the values in formula:

=-pv(10%,13,20000,0)

PV or Present Value of Annuity = $142,067.12

Sitejabber (5.0)

BBC (5.0)

Trustpilot (4.9)

Google (5.0)