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.

You've been promised a payment of $400 in the future

Economics Apr 01, 2021

You've been promised a payment of $400 in the future. In which case is the present value of this payment highest? a you wait 3 years and the interest rate is 6% b. you wait 3 years and the interest rate is 5% c. you wait 2 years and the interest rate is 6% d. you wait 2 years and the interest rate is 5% 
 

Expert Solution

Answer

d .

Explanation

Computation of Present Value using PV Function in Excel:

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

 

a) Here,

PV = Present Value = ?

Rate = 6%

Nper = 3 years 

PMT = 0

FV = $400

Substituting the values in formula:

=-pv(6%,3,0,400)

PV or Present Value = $335.85

 

b) Here,

PV = Present Value = ?

Rate = 5%

Nper = 3 years 

PMT = 0

FV = $400

Substituting the values in formula:

=-pv(5%,3,0,400)

PV or Present Value = $345.54

 

c) Here,

PV = Present Value = ?

Rate = 6%

Nper = 2 years 

PMT = 0

FV = $400

Substituting the values in formula:

=-pv(6%,2,0,400)

PV or Present Value = $356

 

d) Here,

PV = Present Value = ?

Rate = 5%

Nper = 2 years 

PMT = 0

FV = $400

Substituting the values in formula:

=-pv(5%,3,0,400)

PV or Present Value = $362.81

 

So, the correct option is D "You wait 2 years and the interest rate is 5%".

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