WALL STREET PREP FINANCIAL
MODELING EXAM PAPER
COMPLETE QUESTIONS CORRECT
ANSWERS
◉ What are some things under the model tab?. Answer: Occupancy,
revenues, operating expenses, non-operating expenses, purchase and
sale, financial, and JV waterfall
◉ What are some things under the transaction summary tab?. Answer:
sources and uses, investment returns, yield summary, exit summary, debt
summary, revenue and expense summary
◉ Three types of models are. Answer: multifamily, commercial,
development
◉ What are the 5 major types of properties. Answer: multifamily, office,
retail, industrial and hotel
◉ NOI formula. Answer: total income-total expense
MODELING EXAM PAPER
COMPLETE QUESTIONS CORRECT
ANSWERS
◉ What are some things under the model tab?. Answer: Occupancy,
revenues, operating expenses, non-operating expenses, purchase and
sale, financial, and JV waterfall
◉ What are some things under the transaction summary tab?. Answer:
sources and uses, investment returns, yield summary, exit summary, debt
summary, revenue and expense summary
◉ Three types of models are. Answer: multifamily, commercial,
development
◉ What are the 5 major types of properties. Answer: multifamily, office,
retail, industrial and hotel
◉ NOI formula. Answer: total income-total expense
