WSP Financial Modelling exam questions with answers

WSP Financial Modelling exam questions
|\ |\ |\ |\ |\




with answers |\




Why do you never want to re-enter the same input more
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\



than once in your model? - CORRECT ANSWERS ✔✔Bc.
|\ |\ |\ |\ |\ |\ |\ |\ |\



you want your model to be dynamic
|\ |\ |\ |\ |\ |\




Components of a financial statement model? - CORRECT |\ |\ |\ |\ |\ |\ |\ |\



ANSWERS ✔✔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 - CORRECT ANSWERS ✔✔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? - CORRECT ANSWERS ✔✔No,
|\ |\ |\ |\ |\ |\ |\ |\



grouping is better |\ |\




Should you merge cells? - CORRECT ANSWERS ✔✔No,
|\ |\ |\ |\ |\ |\ |\ |\



centering across selection is better |\ |\ |\ |\




Footnotes vs comments? - CORRECT ANSWERS |\ |\ |\ |\ |\ |\



✔✔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? - CORRECT ANSWERS ✔✔Ctrl + F
|\ |\ |\ |\ |\ |\ |\




and then search for the name of the worksheet you want
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\



to delete
|\




What documents would you gather prior to starting to
|\ |\ |\ |\ |\ |\ |\ |\ |\



model? - CORRECT ANSWERS ✔✔Latest annual report and
|\ |\ |\ |\ |\ |\ |\