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

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

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?
 
Master Excel Bundle

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.

Forum statistics

Threads
1,152,110
Messages
5,768,150
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.
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