| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating a discount rate
Hello,
I have a series of future cash flows, and a lump sum offer for them. Is there a function I can use in Excel to calculate what the discount rate used to generate that lump offer was? I can trial and error it using PV and extrapolating a rate, but I was hoping for something that I could plug Present Value, Future Value and Number of Periods into that would give me the discount rate. Any advice would be greatly appreciated. -- Mike Lee McKinney,TX USA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating pensions rate | Excel Worksheet Functions | |||
| Calculating Time * Rate | Excel Discussion (Misc queries) | |||
| Solving for discount rate in present value calculation | Excel Worksheet Functions | |||
| Calculating rate based on age ranges | Excel Worksheet Functions | |||
| Discount rate - what to use? | Excel Worksheet Functions | |||
Threaded Mode
