WALL STREET PREP FINANCIAL
STATEMENT MODELING
EXAMINATION COMPREHENSIVE
QUESTIONS ACCURATE ANSWERS
⩥ Which of the following is not a formatting and layout best practice for
financial modeling. Answer: always password protecting your model
⩥ In a model, what font color should hard-coded numbers (inputs) be.
Answer: Blue
⩥ which formula is frequently used in real estate financial models when
dealing with dates and timelines. Answer: =EOMonth
⩥ what is a good way to keep track of assumptions when building a
financial model. Answer: Microsoft Excel cell comments
⩥ Which of the following is not one of the main sheets of a real estate
financial Model. Answer: Engine
⩥ Which of the following is a type of commercial model. Answer:
Office
, ⩥ Which of the following is a supporting tab for a multifamily model.
Answer: Historical financials
⩥ Which of the following is a supporting tab for a commercial model.
Answer: Argus outputs
⩥ What is Argus. Answer: A software program used to project cash
flows for commercial property types
⩥ real estate models are heavily reliant on which of the following.
Answer: Dates and Timelines
⩥ What is a good alternative to merging cells. Answer: Center Across
selection
⩥ Which of the following should you avoid. Answer: naming cells and
ranges
⩥ which of the following would you find on the inputs and drivers tab of
a real estate model. Answer: property overview
⩥ Which of the following would you find on the transaction summary
tab of a real estate model. Answer: Investment returns
STATEMENT MODELING
EXAMINATION COMPREHENSIVE
QUESTIONS ACCURATE ANSWERS
⩥ Which of the following is not a formatting and layout best practice for
financial modeling. Answer: always password protecting your model
⩥ In a model, what font color should hard-coded numbers (inputs) be.
Answer: Blue
⩥ which formula is frequently used in real estate financial models when
dealing with dates and timelines. Answer: =EOMonth
⩥ what is a good way to keep track of assumptions when building a
financial model. Answer: Microsoft Excel cell comments
⩥ Which of the following is not one of the main sheets of a real estate
financial Model. Answer: Engine
⩥ Which of the following is a type of commercial model. Answer:
Office
, ⩥ Which of the following is a supporting tab for a multifamily model.
Answer: Historical financials
⩥ Which of the following is a supporting tab for a commercial model.
Answer: Argus outputs
⩥ What is Argus. Answer: A software program used to project cash
flows for commercial property types
⩥ real estate models are heavily reliant on which of the following.
Answer: Dates and Timelines
⩥ What is a good alternative to merging cells. Answer: Center Across
selection
⩥ Which of the following should you avoid. Answer: naming cells and
ranges
⩥ which of the following would you find on the inputs and drivers tab of
a real estate model. Answer: property overview
⩥ Which of the following would you find on the transaction summary
tab of a real estate model. Answer: Investment returns
