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.