Wall Street Prep Financial Modeling Course
|| || || || || ||
questions with accurate detailed answers || || || ||
=EOMONTH - ✔✔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? - ✔✔property overview, timing
|| || || || || || || || || || || || || ||
assumptions, purchase price, sale price, revenue drivers, expense drivers, capital expenditures
|| || || || || || || || || ||
What are some things under the model tab? - ✔✔Occupancy, revenues, operating expenses, non-
|| || || || || || || || || || || || ||
operating expenses, purchase and sale, financial, and JV waterfall
|| || || || || || || ||
What are some things under the transaction summary tab? - ✔✔sources and uses, investment
|| || || || || || || || || || || || || ||
returns, yield summary, exit summary, debt summary, revenue and expense summary
|| || || || || || || || || ||
Three types of models are - ✔✔multifamily, commercial, development
|| || || || || || || ||
What are the 5 major types of properties - ✔✔multifamily, office, retail, industrial and hotel
|| || || || || || || || || || || || || ||
NOI formula - ✔✔total income-total expense
|| || || || ||
What are some other expenses in a property other than rent - ✔✔utility reimbursements, pet fees,
|| || || || || || || || || || || || || || || ||
parking, storage. etc. || ||
What are the three types of commercial lease structures? - ✔✔Triple Net (NNN), full service
|| || || || || || || || || || || || || || ||
(FS), modified gross (MS)
|| || ||
What is a triple net lease? - ✔✔tenant must pay all expenses, typically the lowest rent
|| || || || || || || || || || || || || || ||
|| || || || || ||
questions with accurate detailed answers || || || ||
=EOMONTH - ✔✔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? - ✔✔property overview, timing
|| || || || || || || || || || || || || ||
assumptions, purchase price, sale price, revenue drivers, expense drivers, capital expenditures
|| || || || || || || || || ||
What are some things under the model tab? - ✔✔Occupancy, revenues, operating expenses, non-
|| || || || || || || || || || || || ||
operating expenses, purchase and sale, financial, and JV waterfall
|| || || || || || || ||
What are some things under the transaction summary tab? - ✔✔sources and uses, investment
|| || || || || || || || || || || || || ||
returns, yield summary, exit summary, debt summary, revenue and expense summary
|| || || || || || || || || ||
Three types of models are - ✔✔multifamily, commercial, development
|| || || || || || || ||
What are the 5 major types of properties - ✔✔multifamily, office, retail, industrial and hotel
|| || || || || || || || || || || || || ||
NOI formula - ✔✔total income-total expense
|| || || || ||
What are some other expenses in a property other than rent - ✔✔utility reimbursements, pet fees,
|| || || || || || || || || || || || || || || ||
parking, storage. etc. || ||
What are the three types of commercial lease structures? - ✔✔Triple Net (NNN), full service
|| || || || || || || || || || || || || || ||
(FS), modified gross (MS)
|| || ||
What is a triple net lease? - ✔✔tenant must pay all expenses, typically the lowest rent
|| || || || || || || || || || || || || || ||
