| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Present value and future value
Errata....
On Apr 7, 5:33 am, "joeu2004" wrote: =round(pmt((1+5%)/(1+4%)-1, 2, -25000, 0, 1) [....] =round(pmt((1+5%)/(1+3%)-1, 30, -100000, 0, 1) Well, at least my typos are consistent ;-). Of course, those should be: =round(pmt(...), 0) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Financial Calc: present cash value of a future amount | Excel Worksheet Functions | |||
| Net Present Value | New Users to Excel | |||
| Counting dates for a the present month but not future months | Excel Worksheet Functions | |||
| Present Value | New Users to Excel | |||
| calculating the future value of a present value | Excel Worksheet Functions | |||
Hybrid Mode
