Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

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

Finance Nov 03, 2020

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%:$

Expert Solution

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

Archived Solution
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment