WALL STREET PREP FINANCIAL
MODELING EXAM PREMIUM MATERIAL
TEST PAPER QUESTIONS SOLUTIONS
GRADED A+
◉ 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
◉ what is the main driver of property values. Answer: tenants and their
ability to pay rent
MODELING EXAM PREMIUM MATERIAL
TEST PAPER QUESTIONS SOLUTIONS
GRADED A+
◉ 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
◉ what is the main driver of property values. Answer: tenants and their
ability to pay rent
