Browse all practice questions for the Wall Street Real Estate Financial Modeling Practice Test. Search by topic, open any question and review its full explanation, then test yourself in the practice quiz.

Wall Street Real Estate Financial Modeling Practice Test course image
More practice questions

These questions are part of the practice quiz. Start practicing

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

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy