Ask Question
1 July, 10:17

if your daughter wants to earn $215,000 within the next twenty-three years and salaries grow at 4.45% per year, at what salary should she start to reach her goal?

+4
Answers (1)
  1. 1 July, 14:09
    0
    Answer: $789,84.93

    Using Microsoft Excel, the starting salary can easily be obtained. But we will use the method of trial and error here. We need five columns with the following inputs:

    1. For the no. of years (1-23)

    2. The salary at the start of the year (4.45% added)

    3. The fixed interest of 4.45%

    4. The product of salary for the corresponding year and 4.45%, and

    5. The sum of the salary for the previous year and the current year plus interest

    By guessing/inputting (trial and error) any amount in the first cell of column 2, you can arrive at the ending balance of $215,000 in the 5th column rightmost bottom.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “if your daughter wants to earn $215,000 within the next twenty-three years and salaries grow at 4.45% per year, at what salary should she ...” 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