How to trace a function f(x) in excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fourbluenotes - 25 Jan 2006 11:06 GMT

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 to this Message

Niek Otten - 25 Jan 2006 11:10 GMT

Look at Tools>Solver.
Another, less sophisticated option over which you have some more control is
Data>Table.

Signature

Kind regards,

Niek Otten

> Say, I have a financial model that gives me a company value as an output.
> I
[quoted text clipped - 3 lines]
> I've been looking around but coudnt find any plugin or macro...
> Any idea?

Reply to this Message

Tushar Mehta - 25 Jan 2006 12:17 GMT

Check out XL help for the Data | Table... capability.

Signature

Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

> 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 to this Message