Wall Street Prep Real Estate Financial
Modeling Exam Questions and Answers
Graded A+
Which of the following Real estate functions does not rely on financial Models -
Correct answer-Tenants
Which of the following is not a formatting and layout best practice for financial
modeling - Correct answer-always password protecting your model
In a model, what font color should hard-coded numbers (inputs) be - Correct
answer-Blue
which formula is frequently used in real estate financial models when dealing with
dates and timelines - Correct answer-=EOMonth
what is a good way to keep track of assumptions when building a financial model -
Correct answer-Microsoft Excel cell comments
Which of the following is not one of the main sheets of a real estate financial
Model - Correct answer-Engine
Which of the following is a type of commercial model - Correct answer-Office
, Which of the following is a supporting tab for a multifamily model - Correct
answer-Historical financials
Which of the following is a supporting tab for a commercial model - Correct
answer-Argus outputs
What is Argus - Correct answer-A software program used to project cash flows for
commercial property types
real estate models are heavily reliant on which of the following - Correct answer-
Dates and Timelines
What is a good alternative to merging cells - Correct answer-Center Across
selection
Which of the following should you avoid - Correct answer-naming cells and ranges
which of the following would you find on the inputs and drivers tab of a real estate
model - Correct answer-property overview
Which of the following would you find on the transaction summary tab of a real
estate model - Correct answer-Investment returns
what is the main driver of property values - Correct answer-tenants and their ability
to pay rent
Modeling Exam Questions and Answers
Graded A+
Which of the following Real estate functions does not rely on financial Models -
Correct answer-Tenants
Which of the following is not a formatting and layout best practice for financial
modeling - Correct answer-always password protecting your model
In a model, what font color should hard-coded numbers (inputs) be - Correct
answer-Blue
which formula is frequently used in real estate financial models when dealing with
dates and timelines - Correct answer-=EOMonth
what is a good way to keep track of assumptions when building a financial model -
Correct answer-Microsoft Excel cell comments
Which of the following is not one of the main sheets of a real estate financial
Model - Correct answer-Engine
Which of the following is a type of commercial model - Correct answer-Office
, Which of the following is a supporting tab for a multifamily model - Correct
answer-Historical financials
Which of the following is a supporting tab for a commercial model - Correct
answer-Argus outputs
What is Argus - Correct answer-A software program used to project cash flows for
commercial property types
real estate models are heavily reliant on which of the following - Correct answer-
Dates and Timelines
What is a good alternative to merging cells - Correct answer-Center Across
selection
Which of the following should you avoid - Correct answer-naming cells and ranges
which of the following would you find on the inputs and drivers tab of a real estate
model - Correct answer-property overview
Which of the following would you find on the transaction summary tab of a real
estate model - Correct answer-Investment returns
what is the main driver of property values - Correct answer-tenants and their ability
to pay rent
