WALL STREET PREP FINANCIAL
STATEMENT MODELING TEST FINAL
PAPER QUESTIONS SOLUTIONS
GRADED A+
⩥ What is a financial model? Answer: A tool built in a spreadsheet used
to forecast a business's financial performance and make business
decisions.
⩥ What are the three core financial statements linked in 3-Statement
Modeling? Answer: Income statement, balance sheet, and cash flow
statement.
⩥ What is one of the learning objectives of the course? Answer: To
understand model-building best practices.
⩥ What is the significance of inputs in financial modeling? Answer:
Inputs should be clearly identified and only entered once.
⩥ What is the purpose of processing in financial modeling? Answer:
Processing should be transparent, broken down into simple steps, and
easy to follow.
, ⩥ What should outputs in a financial model be like? Answer: Outputs
should be quickly accessible, easily updated, and exportable.
⩥ What is the role of sensitivity analysis in financial modeling? Answer:
To evaluate how sensitive an investment is to changes in drivers.
⩥ What does DCF stand for in financial modeling? Answer: Discounted
Cash Flow.
⩥ What is one best practice for financial modeling? Answer: Use test
data to ensure the model works as expected.
⩥ What is the difference between negative and positive expense
conventions in financial modeling? Answer: Negative expenses show
costs as negative numbers, while positive expenses show them as
positive numbers.
⩥ What is a common challenge when building complex financial
models? Answer: They can be prone to error and hard to model.
⩥ What should be considered when crafting assumptions in financial
modeling? Answer: The problem the model is meant to solve and who
the end user is.
STATEMENT MODELING TEST FINAL
PAPER QUESTIONS SOLUTIONS
GRADED A+
⩥ What is a financial model? Answer: A tool built in a spreadsheet used
to forecast a business's financial performance and make business
decisions.
⩥ What are the three core financial statements linked in 3-Statement
Modeling? Answer: Income statement, balance sheet, and cash flow
statement.
⩥ What is one of the learning objectives of the course? Answer: To
understand model-building best practices.
⩥ What is the significance of inputs in financial modeling? Answer:
Inputs should be clearly identified and only entered once.
⩥ What is the purpose of processing in financial modeling? Answer:
Processing should be transparent, broken down into simple steps, and
easy to follow.
, ⩥ What should outputs in a financial model be like? Answer: Outputs
should be quickly accessible, easily updated, and exportable.
⩥ What is the role of sensitivity analysis in financial modeling? Answer:
To evaluate how sensitive an investment is to changes in drivers.
⩥ What does DCF stand for in financial modeling? Answer: Discounted
Cash Flow.
⩥ What is one best practice for financial modeling? Answer: Use test
data to ensure the model works as expected.
⩥ What is the difference between negative and positive expense
conventions in financial modeling? Answer: Negative expenses show
costs as negative numbers, while positive expenses show them as
positive numbers.
⩥ What is a common challenge when building complex financial
models? Answer: They can be prone to error and hard to model.
⩥ What should be considered when crafting assumptions in financial
modeling? Answer: The problem the model is meant to solve and who
the end user is.
