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
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