WSP Financial Modelling

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