| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How to use FV function to find a payment to reach a specific goal
I have a goal to save $50,000.00 in eight years. My annual interest rate is
6.35%. What amount would I need to put away monthly, to obtain this goal? How would I use FV and Goal Seek command to get this done? |
|
#2
|
|||
|
|||
|
Use the PMT function. Look in HELP for details; don't forget to divide the
interest% by 12 if you have monthly payments. Kind regards, Niek Otten "Duke20" wrote in message ... I have a goal to save $50,000.00 in eight years. My annual interest rate is 6.35%. What amount would I need to put away monthly, to obtain this goal? How would I use FV and Goal Seek command to get this done? |
|
#3
|
|||
|
|||
|
You don't need Goal Seek. Just use the PMT function:
=pmt(6.35%/12,8*12,0,-50000,1) The answer is just under $400 per month. -- Regards, Fred "Duke20" wrote in message ... I have a goal to save $50,000.00 in eight years. My annual interest rate is 6.35%. What amount would I need to put away monthly, to obtain this goal? How would I use FV and Goal Seek command to get this done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I NEED A FUNCTION TO FIND IF THERE IS AN INTERSECTION BETWEEN 2 DATE RANGES | Excel Worksheet Functions | |||
| Where do I find the Payment Request Wizard in Outlook? | Excel Discussion (Misc queries) | |||
| How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
| Worksheet Function - Find? | Excel Worksheet Functions | |||
| HOW TO USE FIND OR SEARCH FUNCTION TO FILL DATA | Excel Worksheet Functions | |||
Hybrid Mode
