# FV function Help

#### Helix

##### New Member
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

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

#### Helix

##### New Member
bump, really need help

#### tusharm

##### MrExcel MVP
It appears you have it correct. Where do you get stuck?

Might an example help explain your problem?

Replies
1
Views
110
Replies
1
Views
147
Replies
6
Views
662
Replies
9
Views
4K
Replies
2
Views
161

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,152,111
Messages
5,768,163
Members
425,458
Latest member
Jaspal1996

### 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.

### Which adblocker are you using?

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

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