Register now or log in to join your professional community.
· 1st of all I think the model should be as parametric as possible & enables you to change all results & output by changing each of Macro/Micro parameters such as growth, Interest, inflation etc rates.
· The model shouldn't have any error while running & it should have an understood able structure with a sheet including definitions & changeable parameters. Separating Opex, Capex, Balance sheet, Revenue etc in different sheets may help this
· Simplicity is a must, using less formula, less Macros & showing step by step calculation may help this item.
· The model should have self tester which would let you know where you have wrong inputs or wrong calculations (such as True tests in balance sheets)
· Many other small & big considerations !
Financial Modelling primarly cover simple sheets and datawhich is added up to sophiscated models in which the financial analyst have the flexibility to change the input and see desire results.
