Tim has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced course
Financial Models
I have been sent a fairly large financial model that Im supposed to be familiarising myself with. Im trying to do some sensitivity analysis but changing key inputs to see what effect that has on the IRRs etc. Whilst the formulae are in placing linking all the different cells, teh linked cells are not automatically changing to reflect the new number in the input cell.
What do I need to do to ensure the model responds to new changes of value in the input cells??
Many Thanks,
Tim
RE: financial Models
Tim,
It sounds like Excel is not calculating the fomulae automatically.
To check that that this option is enabled, Click TOOLS > OPTIONS > CALCULATION
Make sure that the first button is selected (automatic calculation).
Let me know if this sorts the problem out.
Regards
Richard