# 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

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

#### 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
171
Replies
1
Views
336
Replies
9
Views
286
Replies
0
Views
78
Replies
6
Views
856

1,181,614
Messages
5,930,945
Members
436,767
Latest member
Langaws

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