Wall Street Prep Real Estate Financial Modeling
Exam | Commercial & Multifamily Models, NOI,
ARGUS & Investment Returns
Which of the following Real estate functions does not rely on financial Models
Tenants
Which of the following is not a formatting and layout best practice for financial modeling
always password protecting your model
In a model, what font color should hard-coded numbers (inputs) be
Blue
which formula is frequently used in real estate financial models when dealing with dates and
timelines
=EOMonth
what is a good way to keep track of assumptions when building a financial model
Microsoft Excel cell comments
Which of the following is not one of the main sheets of a real estate financial Model
Engine
Which of the following is a type of commercial model
Office
Which of the following is a supporting tab for a multifamily model
Historical financials
Which of the following is a supporting tab for a commercial model
Argus outputs
What is Argus
A software program used to project cash flows for commercial property types
real estate models are heavily reliant on which of the following
, Dates and Timelines
What is a good alternative to merging cells
Center Across selection
Which of the following should you avoid
naming cells and ranges
which of the following would you find on the inputs and drivers tab of a real estate model
property overview
Which of the following would you find on the transaction summary tab of a real estate model
Investment returns
what is the main driver of property values
tenants and their ability to pay rent
which of the following is not a way in which revenue is generated by real estate assets
broker fees
what is the largest operating expense for any property
real estate taxes
how is net operating income (NIO) calculated
NIO = total income - total expenses
Which lease structure results in the highest quoted rent
Full Service (FS)
which of the following is not a key term of commercial leases
broker fee
which of the following is not a characteristic of multifamily properties
Long term cash flow
which of the following are subtracted from Gross Potential Rent (GPR) to calculate Net Potential
Rent (NPR)
Loss to lease and Concesssions
Exam | Commercial & Multifamily Models, NOI,
ARGUS & Investment Returns
Which of the following Real estate functions does not rely on financial Models
Tenants
Which of the following is not a formatting and layout best practice for financial modeling
always password protecting your model
In a model, what font color should hard-coded numbers (inputs) be
Blue
which formula is frequently used in real estate financial models when dealing with dates and
timelines
=EOMonth
what is a good way to keep track of assumptions when building a financial model
Microsoft Excel cell comments
Which of the following is not one of the main sheets of a real estate financial Model
Engine
Which of the following is a type of commercial model
Office
Which of the following is a supporting tab for a multifamily model
Historical financials
Which of the following is a supporting tab for a commercial model
Argus outputs
What is Argus
A software program used to project cash flows for commercial property types
real estate models are heavily reliant on which of the following
, Dates and Timelines
What is a good alternative to merging cells
Center Across selection
Which of the following should you avoid
naming cells and ranges
which of the following would you find on the inputs and drivers tab of a real estate model
property overview
Which of the following would you find on the transaction summary tab of a real estate model
Investment returns
what is the main driver of property values
tenants and their ability to pay rent
which of the following is not a way in which revenue is generated by real estate assets
broker fees
what is the largest operating expense for any property
real estate taxes
how is net operating income (NIO) calculated
NIO = total income - total expenses
Which lease structure results in the highest quoted rent
Full Service (FS)
which of the following is not a key term of commercial leases
broker fee
which of the following is not a characteristic of multifamily properties
Long term cash flow
which of the following are subtracted from Gross Potential Rent (GPR) to calculate Net Potential
Rent (NPR)
Loss to lease and Concesssions
