FINANCIAL STATEMENT MODELING EXAM 2024/ACTUAL EXAM FROM WALL STREET PREP WITH 100% CORRECT AND VERIFIED ANSWERS AND RATIONALES/ WSP FINANCIAL STATEMENT MODELING/LATEST UPDATE

FINANCIAL STATEMENT MODELING EXAM 2025/ACTUAL EXAM FROM WALL STREET PREP WITH 100% CORRECT AND VERIFIED ANSWERS AND RATIONALES/ WSP FINANCIAL STATEMENT MODELING/LATEST UPDATE Why do you never want to re-enter the same input more than once in your model? - (ANSWER)Bc. you want your model to be dynamic Components of a financial statement model? - (ANSWER)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 - (ANSWER)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? - (ANSWER)No, grouping is better Should you merge cells? - (ANSWER)No, centering across selection is better Footnotes vs comments? - (ANSWER)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? - (ANSWER)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? - (ANSWER)Latest annual report and corresponding 4th quarter press release and earnings call transcript