| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FV & dynamic payment
On Jan 27, 6:30*am, Emma Hope
wrote: I want to do the following, £100,000 grows at 9% per year, 12% per year is paid out for 10 years, what is the final value? Take a look at the first year to be sure I understand you correctly. After the first year, we have: 100000*(1+9%)*(1-12%) = 95920. Right? If so, then: =fv((1+9%)*(1-12%)-1,10,0,-100000) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Starting payment when increase rate is known & total payment is kn | Excel Worksheet Functions | |||
| Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| calculate payment with first payment due date variable? | Excel Worksheet Functions | |||
| how do you get a positive number payment with a mortgage payment . | Excel Worksheet Functions | |||
Hybrid Mode
