Ask Question
21 December, 14:12

Suppose that you deposit? $10,000 in an account that pays? 6% interest and you want to know how much will be in your account at the end of 10 years. To solve this problem in Microsoft? Excel, you would use which of the following Excel? formulas?

=FV? (.06,10,0,10000)

B.

?=PV? (.06,10,0,10000)

C.

?=PV? (.06,10000,0,10)

D.

?=FV? (.06,10000,0,10)

+4
Answers (1)
  1. 21 December, 15:30
    0
    B. = PV (.06,10,0,10000)

    Explanation:

    In MS Excel the formula of Present value re is as "=PV (rate, nper, pmt, [fv]) ".

    PV = Present value

    rate = Interest rate = 6% = 0.06

    nper = number of periods = 10

    pmt = payment made each period = 0 in this scenario

    fv = future value = 10,000

    So, according to the formula the correct sequence is = PV (.06,10,0,10000)

    which is correctly mentioned in option B.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “Suppose that you deposit? $10,000 in an account that pays? 6% interest and you want to know how much will be in your account at the end of ...” in 📙 Business if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers