| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to trace a function f(x) in excel?
Say, I have a financial model that gives me a company value as an output. I
would like to carry-out a sensitivity analysis on any input value (growth, discount factor, interest on debt, etc.) The results would be presented in a table. I've been looking around but coudnt find any plugin or macro... Any idea? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to trace a function f(x) in excel?
Look at ToolsSolver.
Another, less sophisticated option over which you have some more control is DataTable. -- Kind regards, Niek Otten "fourbluenotes" wrote in message ... Say, I have a financial model that gives me a company value as an output. I would like to carry-out a sensitivity analysis on any input value (growth, discount factor, interest on debt, etc.) The results would be presented in a table. I've been looking around but coudnt find any plugin or macro... Any idea? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to trace a function f(x) in excel?
Check out XL help for the Data | Table... capability.
-- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Say, I have a financial model that gives me a company value as an output. I would like to carry-out a sensitivity analysis on any input value (growth, discount factor, interest on debt, etc.) The results would be presented in a table. I've been looking around but coudnt find any plugin or macro... Any idea? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel needs a better interface to trace precedents and dependents | Excel Discussion (Misc queries) | |||
| Excel Trace Fomula dependence or precedence | Excel Discussion (Misc queries) | |||
| trace dependent tool doesn't work but trace precendent doesn't | Excel Discussion (Misc queries) | |||
| Excel Trace Formula | Excel Worksheet Functions | |||
| Trace ALL dependent cells in any worksheet anywhere in Excel | Excel Worksheet Functions | |||
Linear Mode
