USING MICROSOFT EXCEL
WORKBOOK THEMES
| Question 
 [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
 | 
 As an example of a financial function, = ____ (.1, 5, -500) displays the current value of five payments of $500 at a 10% interest rate. 
|  |  PMT 
 | 
|  |  FV 
 | 
|  |  CV 
 | 
|  |  PV 
 | 
 Explanation: 
Detailed explanation-1: -Present value is the value today of an amount of money in the future. If the appropriate interest rate is 10 percent, then the present value of $100 spent or earned one year from now is $100 divided by 1.10, which is about $91.
Detailed explanation-2: -Answer and Explanation: The correct answer is d) $1, 116.14.
Detailed explanation-3: -Answer and Explanation: The present value is A. $453.51.
Detailed explanation-4: -Find the present value and the amount (future value) of an ordinary annuity of P5, 000 payable semi-annually for 10 years if money is worth 6% compounded semi-annually. 1. Answer: P = P74, 387.37, F = P134, 351.87 2.
 There is 1 question to complete.