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