WALL STREET PREP REAL ESTATE
FINANCIAL MODELING EXAM WITH
CORRECT SOLUTIONS
1. which formula is frequently used in real estate financial models
when dealing with dates and timelines - -ANS☑️ ☑️ --=EOMonth
2. what is a good way to keep track of assumptions when building
a financial model - -ANS☑️
☑️ --Microsoft Excel cell comments
3. Which of the following is not one of the main sheets of a real
estate financial Model - -ANS☑️ ☑-️
-Engine
4. Which of the following is a type of commercial model - -
ANS☑️☑️ --Office
5. Which of the following is a supporting tab for a multifamily
model - -ANS☑️ ☑-️-Historical financials
6. Which of the following Real estate functions does not rely on
financial Models - -ANS☑️☑️--Tenants
7. Which of the following is not a formatting and layout best
practice for financial modeling - -ANS☑️☑-️-always password
protecting your model
, 8. In a model, what font color should hard-coded numbers (inputs)
be - -ANS☑️ ☑-️
-Blue
9. Which of the following is a supporting tab for a commercial
model - -ANS☑️ ☑-️-Argus outputs
10. What is Argus - -ANS☑️
☑-️ -A software program used to project
cash flows for commercial property types
11. real estate models are heavily reliant on which of the
following - -ANS☑️☑️ --Dates and Timelines
12. What is a good alternative to merging cells - -ANS☑️
☑-️
-Center
Across selection
13. Which of the following should you avoid - -ANS☑️
☑-️
-naming
cells and ranges
14. which of the following would you find on the inputs and
drivers tab of a real estate model - -ANS☑️☑️--property
overview
15. Which of the following would you find on the transaction
summary tab of a real estate model - -ANS☑️ ☑-️-Investment
returns
16. what is the main driver of property values - -ANS☑️
☑-️
-tenants
and their ability to pay rent
17. which of the following is not a way in which revenue is
generated by real estate assets - -ANS☑️ ☑️--broker fees
FINANCIAL MODELING EXAM WITH
CORRECT SOLUTIONS
1. which formula is frequently used in real estate financial models
when dealing with dates and timelines - -ANS☑️ ☑️ --=EOMonth
2. what is a good way to keep track of assumptions when building
a financial model - -ANS☑️
☑️ --Microsoft Excel cell comments
3. Which of the following is not one of the main sheets of a real
estate financial Model - -ANS☑️ ☑-️
-Engine
4. Which of the following is a type of commercial model - -
ANS☑️☑️ --Office
5. Which of the following is a supporting tab for a multifamily
model - -ANS☑️ ☑-️-Historical financials
6. Which of the following Real estate functions does not rely on
financial Models - -ANS☑️☑️--Tenants
7. Which of the following is not a formatting and layout best
practice for financial modeling - -ANS☑️☑-️-always password
protecting your model
, 8. In a model, what font color should hard-coded numbers (inputs)
be - -ANS☑️ ☑-️
-Blue
9. Which of the following is a supporting tab for a commercial
model - -ANS☑️ ☑-️-Argus outputs
10. What is Argus - -ANS☑️
☑-️ -A software program used to project
cash flows for commercial property types
11. real estate models are heavily reliant on which of the
following - -ANS☑️☑️ --Dates and Timelines
12. What is a good alternative to merging cells - -ANS☑️
☑-️
-Center
Across selection
13. Which of the following should you avoid - -ANS☑️
☑-️
-naming
cells and ranges
14. which of the following would you find on the inputs and
drivers tab of a real estate model - -ANS☑️☑️--property
overview
15. Which of the following would you find on the transaction
summary tab of a real estate model - -ANS☑️ ☑-️-Investment
returns
16. what is the main driver of property values - -ANS☑️
☑-️
-tenants
and their ability to pay rent
17. which of the following is not a way in which revenue is
generated by real estate assets - -ANS☑️ ☑️--broker fees