Ask Question
4 June, 05:54

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.

+5
Answers (1)
  1. 4 June, 06:18
    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?
Find 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 the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers