TRADING COMPS MODELING WALL
STREET FULL QUESTIONS AND CORRECT
ANSWERS FINAL PAPER
●● 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
●● what is the main driver of property values
Answer: tenants and their ability to pay rent
●● which of the following is not a way in which revenue is generated by
real estate assets
Answer: broker fees
●● what is the largest operating expense for any property
Answer: real estate taxes
●● how is net operating income (NIO) calculated
Answer: NIO = total income - total expenses
●● Which lease structure results in the highest quoted rent
Answer: Full Service (FS)
STREET FULL QUESTIONS AND CORRECT
ANSWERS FINAL PAPER
●● 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
●● what is the main driver of property values
Answer: tenants and their ability to pay rent
●● which of the following is not a way in which revenue is generated by
real estate assets
Answer: broker fees
●● what is the largest operating expense for any property
Answer: real estate taxes
●● how is net operating income (NIO) calculated
Answer: NIO = total income - total expenses
●● Which lease structure results in the highest quoted rent
Answer: Full Service (FS)
