Wall Street Real Estate Financial Modeling Practice Test

These questions are part of the practice quiz. Start practicing

• What is a real estate waterfall?
• Which statement about capital expenditures and operating expenses is correct?
• Which lease type is associated with the highest quoted rent?
• Which of the following are subtracted from Gross Potential Rent (GPR) to calculate Net Potential Rent (NPR)?
• Which of the following is not a required input for the PMT function?
• Which item is included in EGI but not in PGI?
• What is the top revenue line of a multifamily development?
• What is the term for a performance bonus paid to the GP to incentivize out-performance?
• Which of the following is the most risky position in the capital stack?
• What is a good rule of thumb for an acquisition fee as a percentage of the purchase price?
• Which Excel function is used to determine the fixed payment amount for a loan?
• What support tab is included in development models?
• Why is it important to separate operating cash flow from net cash flow to equity in modeling?
• What is the definition of loan-to-value (LTV) and how does a higher LTV typically affect financing terms for a property acquisition?
• How many different places can you typically find contingency in a development budget?
• Which of the following is included in hard costs?
• What are 'Untrended Stabilized' revenues and expenses?
• Why is it important to consider both unlevered and levered investment returns?
• Which formula correctly defines effective gross income (EGI) in real estate cash flow modeling?
• What new operating expense line item is introduced for industrial properties?
• Which of the following is a pro of non-recourse loans?
• Which of the following is a supporting tab for a multifamily model?
• Which item is typically excluded from development financing costs?
• How is value computed using direct capitalization from NOI?
• How does ramp-up period affect cash flows in a development or value-add project?
• Argus is best described as which of the following?
• In a deal analysis, which reflects the rule-of-thumb acquisition fee as a percentage of the purchase price?
• Which describes simple straight-line depreciation for a residential property under MACRS?
• What does unlevered cash flow (UCF) measure?
• If a property has net operating income of $2.5 million and annual debt service of $2 million, what is the DSCR and what does it imply?
• What is the relationship between DSCR and NOI?
• How should leasing commissions and tenant improvements (TI) be handled in a pro forma?
• Which statement best describes a 1031 exchange and how it might be reflected in a pro forma?
• Which statement best describes the typical components and modeling approach of an operating expense schedule in real estate financial modeling?
• Which formula is frequently used in real estate financial models when dealing with dates and timelines?
• Which statement best describes the function of Net Operating Income in evaluating property performance?
• Which item is typically included in the uses portion of a sources and uses schedule?
• Which of the following would you find on the transaction summary tab of a real estate model?
• Value-add investments are characterized by which approach?
• Tenant improvements are a function of what?
• What are typical closing costs included in uses on a real estate acquisition?
• Non-recourse loans are collateralized by what?
• Which statement is true about the difference between the equity multiple and IRR in terms of the time value of money?
• Which factor is the main driver of property values?
• What is the Internal Rate of Return (IRR)?
• How is net operating income (NOI) calculated?
• Which of the following is not a common ratio used to measure the size of a loan?
• Where does mezzanine debt fit in the capital stack, and what characteristic does it often have?
• Unlevered cash flow (UCF) excludes which type of cash flows?
• What is a development fee?
• In a typical equity waterfall, what is the purpose of the catch-up mechanism?
• Debt Yield is a measure of asset cash flow relative to which item?
• Which of the following Real estate functions does not rely on financial models?
• Which statement is true about the internal rate of return (IRR) in relation to cash flow reinvestment?
• What distinguishes vacancy losses from credit losses in a cash flow model?
• Which factor would you explicitly model to capture extension options in a sale timetable?
• If the most risky position is common equity, which characteristic describes it?
• What Excel function is used to calculate the amortization payment amount?
• Which of the following is not a formatting and layout best practice for financial modeling?
• If exit cap rate rises while NOI remains constant at year 7, what happens to the investment's IRR, assuming purchase price unchanged?
• Which of the following is not a common closing cost?
• In a stabilized pro forma, how is exit value typically estimated?
• What is the purpose of contingency in a development budget?
• To assess IRR risk via sensitivity analysis on exit cap rate and discount rate, which steps should you perform?
• What is the largest operating expense for any property?
• Approximately how much turnover do multifamily properties see each year?
• What is the difference between a development pro forma and a stabilization pro forma in real estate modeling?
• What does net operating income (NOI) measure?
• How do construction loans differ from permanent financing in terms of interest accrual and funding?
• How do you model rehabilitation, adaptive reuse, or redevelopment risk in a pro forma?
• What is the main driver of property values in a real estate model?
• Which statement about Levered Cash Flow is true?
• Explain why you would perform a scenario analysis for changes in occupancy and credit losses in a portfolio.
• How would you incorporate tax credits or incentives (e.g., LIHTC) into a real estate cash flow model?
• Rent concessions and free rent periods affect modeling of NOI and cash flows by which of the following?
• In capital planning, how does capex timing and depreciation affect cash flows?
• How can you test if the model's cash balances are non-negative across all years?
• Which metric is commonly referred to as the yield on a real estate investment?
• What is a fee paid to commercial real estate brokers for facilitating a lease transaction?
• Which term refers to funds reserved from operating cash flow for future capital improvements?
• What is the difference between physical occupancy and economic occupancy?
• The amortization period on a commercial real estate loan refers to what?
• Which of the following is not a key term of commercial leases?
• Which of the following is not a loan cash flow?
• What is a good way to keep track of assumptions when building a financial model?
• In a real estate exit waterfall, how are sale proceeds distributed?
• What is a "catch-up" in an equity waterfall and when does it typically occur?
• Which of the following is not a way in which revenue is generated by real estate assets?
• Which function is used to manage end-of-month date calculations in real estate models?
• How does cost segregation affect tax shields and early cash flow?
• What is a common contingency percentage to include in the total development budget?
• How does the typical investment horizon of a development differ from an acquisition?
• In the provided material, sponsor is described as synonymous with which party?
• Which tab would you expect to summarize investment returns in a real estate model?
• Which of the following is not one of the main sheets of a real estate financial Model?
• Net cash flow to equity is best described as what in a real estate model?
• Total sources should always equal what?
• Which term describes the entity that manages the joint venture's day-to-day operations?
• Who invests the majority of the capital?
• How much cash should be left over at the end of a waterfall?
• Which of the following are subtracted from Potential Base Rent (PBR) to calculate Total Rental Income?
• What is another term for sponsor?
• Which practice is NOT a best practice for formatting financial models?
• In order of priority from lowest risk to highest risk in typical real estate financing, which sequence is correct?
• What is cash-on-cash return?
• Non-recourse loans are collateralized by which asset?
• What is go-dark leasing and how might it affect a model during tenant expansions or relocations?
• Compare IRR, NPV, and equity multiple for evaluating real estate investments. Which statement correctly describes each?
• Which of the following does not describe a value-add investment?
• What is the tax shield, and how does it affect after-tax returns?
• What is the impact of operating expense escalations on long-term cash flows?
• Net Potential Rent (NPR) is the potential rent a property would generate under which condition?
• Define a preferred return in an equity waterfall and its effect on distributions.
• In private real estate investments, profits can be allocated unequally between JV partners by using what mechanism?
• Which term is commonly used as another name for cap rate?
• When modeling a loan with a floating rate, what adjustments should you include?
• Which item is the largest adjustment used when calculating reversion value?
• In development leasing scenarios, longer lease-up periods typically have what effect on debt yield and loan risk?
• If Total Lease Value is defined as square footage x rental rate x lease term, what happens to the Total Lease Value if you double both the square footage and the rental rate, keeping the lease term constant?
• What is amortization?
• What is a good alternative to merging cells in spreadsheets?
• Which metric measures an asset's cash flow relative to the total loan amount?
• Which of the following does not describe a core-plus investment?
• Which of the following would you find on the inputs and drivers tab of a real estate model?
• How is Total Lease Value Calculated?
• In rent escalations modeling, which approach best captures multi-year horizon dynamics?
• In a real estate pro forma, what does terminal value typically represent in simple exit calculations?
• In a real estate model, which item would you typically find on the inputs and drivers tab?
• What role do inflation drivers play in operating expense modeling?
• What does yield-on-cost (YOC) represent?
• What is the equity multiple?
• What is the largest adjustment made in calculating reversion value for a commercial property?
• Which option is typically not considered a closing cost in a property acquisition?
• In waterfall modeling, the initial calculation determines how much cash is available to distribute.
• Which describes the role of mezzanine debt in the capital stack?
• Which statement is true about IO in loan terminology?
• What does Levered Cash Flow (LCF) measure?
• Which of the following is not a characteristic of multifamily properties?
• Which of the following is the most common method of interest calculation?
• When are capital expenditures included in operating expenses?
• What does "IO" stand for?
• In development modeling, Net Potential Rent (NPR) denotes:
• What is debt yield protection and how would you test for it in a model?
• In real estate modeling, which statement best describes IRR compared to equity multiple?
• Which of the following would not be considered Deferred Maintenance?
• What is cost of debt in a capital stack and how do you calculate it?
• Opportunistic investments are best described as?
• Which statement correctly distinguishes net operating income (NOI) from funds from operations (FFO) in real estate cash flow analysis?
• Which of the following is not a characteristic of commercial property?
• Which concept is essential for aligning project milestones and financial events in a real estate model?
• Which of the following is not a major cost category in a development budget?
• Debt yield is defined as NOI divided by loan amount. Which inputs drive it and help ensure lender risk coverage?
• How would you assess alignment of sponsor incentives with investor returns in a modeled deal?
• Core investments typically feature which characteristic?
• Which item is not included in development financing costs?
• Why are interest reserves included in a development budget?
• Which line item is described as the first line when building a waterfall model?
• Which lease structure results in the highest quoted rent?
• In a real estate joint venture, which party typically provides the majority of capital but may not participate in daily management?
• Which of the following would be considered a main sheet in a real estate financial model?
• What are capital reserves?
• What is mezzanine debt and how does it differ from preferred equity in a real estate capital stack?
• In a model, what font color should hard-coded numbers (inputs) be?
• How is the debt service coverage ratio (DSCR) calculated for a stabilized property loan, and what does a DSCR greater than 1 signify?
• Which of the following is not a method commonly used by lenders to calculate interest?
• Core-plus investments typically feature which attribute?
• Which of the following metrics is not used to determine the maximum loan amount?
• How does inflation influence debt service terms and rent growth assumptions in a model?
• Which of the following does not describe an opportunistic investment?
• Which of the following is not outlined in a joint venture legal document?
• Which of the following is typically the largest piece of the capital stack?
• To arrive at Net Potential Rent, which items are subtracted from Gross Potential Rent?
• When using cap rates, what is the difference between going-in cap rate and stabilized cap rate?
• Explain the impact of a capital reserve on a real estate pro forma.
• Explain the concept of a typical equity waterfall with preferred return and catch-up. Which statement is correct?
• What kind of tables are useful for tweaking a finished model?
• In a development budget, which cost category is typically the largest?
• Which of the following does not describe Tenant Improvements (TIs)?
• Which of the following typically has the right to foreclose on the equity position and take control of the property?
• What is the key difference between a fixed-rate loan and an adjustable-rate loan, and how should this be reflected in modeling?
• Which of the following is a synonym for "cap rate"?
• What is Argus?
• In modeling, what is the difference between capex and ongoing maintenance?
• Which of the following is a type of commercial model?
• Which of the following should you avoid in a real estate model?
• What is the definition of the debt service coverage ratio (DSCR) and why is it important?
• Real estate models are heavily reliant on which of the following?
• What is a real estate joint venture?
• Which of the following is not an additional funding mechanism?
• What is the standard amortization period for a commercial real estate loan?
• How do you calculate cash-on-cash return for a property investment?
• What is a sources and uses schedule and why is it critical in closing a real estate deal?
• What is the difference between the market cap rate and yield-on-cost (YOC) called?
• What marks the end of the stabilization period?
• In which scenario does a landlord pay tenant improvement costs directly to the tenant?
• When aggregating portfolio metrics, why is diversification and correlation considered?
• The term for a GP's incentive to outperform targets is called what?
• Cap rates and multiples move in which direction relative to each other?
• In a multifamily model, which tab would you typically consult for historical financial performance?
• What is the first line when modeling a waterfall?
• How would you model a sale at year 7 with a 5-year hold and a 2-year extension option?
• Which item is typically included in closing costs (uses) for a real estate acquisition?
• How is exit cap rate used in projecting sale proceeds and how does it impact IRR?
• Which of the following does not describe a core investment?
• Why is the debt service schedule often modeled separately as a distinct 'debt service' line item with checks?
• How do you compute exit cash flow in a sale including debt payoff?
• Which of the following is not a reason investors use leverage?
• What does stabilization signify in a development or value-add model?
• What does Actual/360 represent in lending?
• Which of the following does not describe the loan term?
• What is subtracted from Net Potential Rent (NPR) to calculate Net Effective Rent (NER)?
• Which of the following is a supporting tab for a commercial model?
• What is the relationship between cap rates and multiples?
• What is the first step in a waterfall?
• What is a pro forma check that ensures the model is internally consistent?
• Which of the following would not be considered an Offensive Renovation?
• In rent modeling, what is a rent-up period?
• What is a good rule of thumb for an acquisition hold period?
• Which metric can tell the entire story of a potential transaction?
• In a development budget, which cost category typically drives the largest outlay?
• How do you model multiple properties in a portfolio and aggregate into portfolio metrics?
• Differentiate debt yield from DSCR and identify when each is typically used in lending decisions.