Wall Street Prep: Financial Modeling Course
Exam 2026/2027 | Accurate Detailed Solutions
| Graded A+ | Approved Pass
What are some things under the transaction summary tab? - ANSWERS-
sources and uses, investment returns, yield summary, exit summary, debt
summary, revenue and expense summary
Three types of models are - ANSWERS-multifamily, commercial, development
What are the 5 major types of properties - ANSWERS-multifamily, office,
retail, industrial and hotel
NOI formula - ANSWERS-total income-total expense
What are some other expenses in a property other than rent - ANSWERS-
utility reimbursements, pet fees, parking, storage. etc.
=EOMONTH - ANSWERS-takes start date, and returns the number that is the
given number of months away from your input (hold date)
What are some things under the inputs and drivers tab? - ANSWERS-property
overview, timing assumptions, purchase price, sale price, revenue drivers,
expense drivers, capital expenditures
What are some things under the model tab? - ANSWERS-Occupancy,
revenues, operating expenses, non-operating expenses, purchase and sale,
financial, and JV waterfall
Exam 2026/2027 | Accurate Detailed Solutions
| Graded A+ | Approved Pass
What are some things under the transaction summary tab? - ANSWERS-
sources and uses, investment returns, yield summary, exit summary, debt
summary, revenue and expense summary
Three types of models are - ANSWERS-multifamily, commercial, development
What are the 5 major types of properties - ANSWERS-multifamily, office,
retail, industrial and hotel
NOI formula - ANSWERS-total income-total expense
What are some other expenses in a property other than rent - ANSWERS-
utility reimbursements, pet fees, parking, storage. etc.
=EOMONTH - ANSWERS-takes start date, and returns the number that is the
given number of months away from your input (hold date)
What are some things under the inputs and drivers tab? - ANSWERS-property
overview, timing assumptions, purchase price, sale price, revenue drivers,
expense drivers, capital expenditures
What are some things under the model tab? - ANSWERS-Occupancy,
revenues, operating expenses, non-operating expenses, purchase and sale,
financial, and JV waterfall
