FV function Help

Helix

New Member
Joined
Jan 25, 2005
Messages
2
I need a worksheet, within the existing payroll workbook, that would help me to figure how much money will be made with the temporary contributions from employee paychecks.


The person needs to enter the following fields:

- The number of compounding periods per year
- The number of years
- The simple yearly interest rate
- The amount of money (PV) that can be invested today
- A deposit made by Jeff at each compounding period.
(Note: Payment will always be made at the end of the period)

I keep getting hung up on this. I know the formula is:

FV(rate,nper,pmt,pv,type)

type = 0 because its the end of the month
rate = %/compounding periods
nper = years * 12
pv = The amount of money (PV) that can be invested today ???
pmt = A deposit made by person at each compounding period ???

I cant quite figure it out. Any help would be appreciated. Thanks in advance.
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,029
It appears you have it correct. Where do you get stuck?

Might an example help explain your problem?
 

Forum statistics

Threads
1,147,691
Messages
5,742,661
Members
423,746
Latest member
Joaogomes

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top