Suppose that you are considering an investment that will pay you $4,000 per year for the next five years.The appropriate rate of interest is 5%.You want to know the present value of the cash flows from this investment.To solve this problem in Microsoft Excel,you would use which of the following Excel formulas?
A) =PV(.05,5,4000,0,0)
B) =PV(.05,5,4000,0,1)
C) =PV(5,.05,4000,0)
D) =PV(5,5,4000,0)
Correct Answer:
Verified
Q60: Mr.Zhu is selling his business for retirement.It
Q61: Your son is about to start kindergarten
Q63: Your son is about to start kindergarten
Q66: Use the information for the question(s)below.
Assume that
Q66: By quitting smoking,Lisa could save $350 per
Q67: You are considering purchasing a new home.You
Q69: Net Present Value can be calculated for
Q69: You are interested in purchasing a new
Q82: You are looking for a new truck
Q87: You are considering investing in a zero
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents