Marketing > EXAM > MARKETING 100 communication - Real Estate Financial Modeling Exam. (All)

MARKETING 100 communication - Real Estate Financial Modeling Exam.

Document Content and Description Below

Real Estate Financial Modeling: 1-Which of the following is correct about the difference between land loans and other loans? Land loans have lower interest rates Land loans do not have an NOI Land loans do not require a collateral Land loan's loan-to-value is higher ……………………………… Please download Excel 1 and open it. The same file will be used for the following 5 questions; do not close it until you have passed the assessment. Note: enable the iteration calculation function for this exercise. 2-Please complete the NOI and property value calculations using the assumption provided on the second worksheet. What is the total gross revenue for the urban property? 200,000 188,000 178,000 168,000 ……………………………… 3-Please complete the NOI and property value calculations using the assumption provided on the second worksheet. What is the total expenses for the suburban property? 42,729 89,752 46,763 63,464 …………………………………………………….. 4-Please complete the NOI and property value calculations using the assumption provided on the second worksheet. What is the total NOI for the downtown property? 123,452 124,652 110,646 113,369 ……………………………… Real-Estate-Financial-Modelingdocx/5-Please complete the NOI and property value calculations using the assumption provided on the second worksheet. What is the property value for the seaview property? 6,163,474 6,987,414 6,476,667 5,676,163 ………………………………… 6-Please complete the sensitivity analysis using the variance given in the worksheet. What is the property value per sq ft for the seaview property if its gross monthly rent per sq is $4.00 and Cap rate is 1.50%? 2,380 1,790 1,450 2,430 …………………………………… 7-Which of the following is not an approach to find the loan-to-value of a land loan? Comparable approach Income approach Eligible VS ineligible costs approach Cost approach ………………………………… 8-What is the value of the land lift of a property that has cash cost to purchase and rezone of $10,000,000, appraised value of $15,000,000, and loan-to-value of 40%? 4,000,000 5,000,000 4,500,000 6,000,000 ……………………………

[Show More]

Last updated: 3 years ago

Preview 1 out of 5 pages

Buy Now

Instant download