WSP FINANCIAL MODELLING
QUESTIONS WITH CORRECT DETAILED
ANSWERS
m Why do you never want to re-enter the same input more than once in your model? - Bc. you want your
model to be dynamic
Components of a financial statement model? - Income statement
Balance sheet
Statement of cash flows
Both historical results and forecasts
What colour text should you use for:
Hard-coded inputs
Formulas
Links to other worksheets
Links to other files
Links to data providers - Hard-coded inputs -> blue
Formulas -> black
Links to other worksheets -> green
Links to other files -> red
Links to data providers -> dark red
Should you hide rows? - No, grouping is better
Should you merge cells? - No, centering across selection is better
Footnotes vs comments? - Footnotes will show up when model is printed
Comments for internal purposes
If you want to delete a worksheet and want to know if there are any links to that worksheet, how can
you do this? - Ctrl + F
QUESTIONS WITH CORRECT DETAILED
ANSWERS
m Why do you never want to re-enter the same input more than once in your model? - Bc. you want your
model to be dynamic
Components of a financial statement model? - Income statement
Balance sheet
Statement of cash flows
Both historical results and forecasts
What colour text should you use for:
Hard-coded inputs
Formulas
Links to other worksheets
Links to other files
Links to data providers - Hard-coded inputs -> blue
Formulas -> black
Links to other worksheets -> green
Links to other files -> red
Links to data providers -> dark red
Should you hide rows? - No, grouping is better
Should you merge cells? - No, centering across selection is better
Footnotes vs comments? - Footnotes will show up when model is printed
Comments for internal purposes
If you want to delete a worksheet and want to know if there are any links to that worksheet, how can
you do this? - Ctrl + F
