Ask Question
3 August, 12:45

You have $40,549.50 in a brokerage account, and you plan to deposit an additional $3,000 at the end of every future year until your account totals $210,000. You expect to earn 11% annually on the account. How many years will it take to reach your goal? Round your answer to the nearest whole number.

+1
Answers (1)
  1. 3 August, 14:45
    0
    It will take 25.12 or 25 years to reach the desired goal.

    Explanation:

    Given:

    Amount in brokerage account which is the present value = $40,549.5

    Additional annual deposits which is PMT or payment = $3,000

    Rate of interest = 11% or 0.11

    Desired goal or future value = $210,000

    Use excel function (nper) to calculate number of years required to achieve desired goal.

    Formula is = NPER (rate, pmt, PV, FV)

    The same is calculated in the following excel.

    Therefore, it will take 25 years to achieve desired goal.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “You have $40,549.50 in a brokerage account, and you plan to deposit an additional $3,000 at the end of every future year until your account ...” 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