| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Solving for Amortization with PMT function
Hello,
I need to solve for Amortization and think I should be using the PMT function €œPMT(rate,nper,pv,fv,type)€ My data gives me the desired payment, rate, pv, fv and type. I dont know what formula to use to return the amortization (in years). Can anyone help? Much appreciated! George |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Internet amortization answers differ from function | Excel Discussion (Misc queries) | |||
| solving for a sum | Excel Worksheet Functions | |||
| solving for NPer w/o function (algebra question) | Excel Worksheet Functions | |||
| Solving for X and Y with a = in the FUNCTION??? | Excel Discussion (Misc queries) | |||
| Unknown IF function parameter on amortization schedule | Excel Worksheet Functions | |||
Threaded Mode
