Question

1. Use a financial calculator or computer software program to answer the following questions:

a. What is the present value of $450,000 that is to be received at the end of 20 years if the discount rate is 10%?
b. How would your answer change in (a.) if the $450,000 is to be received at the end of 15 years?

Answer 1

Answer:

a. $66,889.63

b. $107,726.42

Explanation:

We use the Present value function that is to be reflected on the attachment

a. In the first case

Data provided in the question    

Future value = $450,000

Rate of interest = 10%

NPER = 20 years

PMT = $0

The formula is shown below:

= PV(Rate;NPER;PMT;FV;type)

So, after solving this, the present value is $66,889.63

b. In the second case

Data provided in the question    

Future value = $450,000

Rate of interest = 10%

NPER = 20 years

PMT = $0

The formula is shown below:

= PV(Rate;NPER;PMT;FV;type)

So, after solving this, the present value is $107,726.42