Explanation
Goal Seek can work with investment formulas as well.
Suppose you want a future investment value of ₹10,00,000.
Data
|
Input |
Value |
|
Monthly Investment |
₹8,000 |
|
Annual Rate |
8% |
|
Years |
5 |
Formula
=FV(B3/12,B4*12,-B2,0)
You can use Goal Seek to determine:
- Required monthly investment
- Required investment period
depending on which input you allow Excel to change.
Practice
Find the monthly investment required to achieve:
₹10,00,000 future value
using the given interest rate and period.