Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You wish to calculate the present value of $2,000 to be recoived nine years from now, assuming an interest rate of 8%, compounded semiannually. Which
You wish to calculate the present value of $2,000 to be recoived nine years from now, assuming an interest rate of 8%, compounded semiannually. Which of the following Excel inputs will provide you with the correct answer, stated as a positive flow, that is, the amount of your expected inflow? (Select the two that apply.)
a. =PV(0.08/2,18,2000)
b. =PV(0.08/2,2*9,-2000)
c. =pv (4,18,2,000)
d.=pv (4%,2*9,2000)
e. =Pv(.04,18, -2000)
f.=Pv (.08/2,2"9,2000)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started