Financial modelling Level One Flashcards
Tell me about the main financial modelling software packages you are aware of.
What is a financial model?
What are the pros and cons of a particular piece of software you have used?
Why may software be beneficial over Excel for modelling?
Why is it important to clearly identify inputs/outputs/unit types?
Why is locking cells important?
What is sensitivity analysis and why is it important?
What issues can arise with modelling spreadsheets/packages?
What are the limitations of modelling software/Excel?
How can you overcome these?
How do you ensure that formulas and mechanics are working correctly?
How do you ensure that the figures are not a false pretence?
How do you check the reliability and accuracy of data?
Why are explicit valuation approaches popular?
Did the economic crisis impact the type of financial modelling carried out by investors and developers?
What is discounting?
What is the time value of money and why is it important?
What is compounding?
Tell me about an assumption you might make in a financial model.
Are you aware of any RICS guidance relating to financial modelling?