Problem I: CRE Mortgage Underwriting (50 points) First Floor Second Floor Annual rent increase Vacancy and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Problem I: CRE Mortgage Underwriting (50 points) First Floor Second Floor Annual rent increase Vacancy and collection losses Miscellaneous income Operating expenses (% EGI) CAPEX (% EGI) Holding period (years) Going-out cap rate on NCF at end of year 5 Sales expenses (e.g., broker commission) year 5 # Suites Rent/month (year 1) 2 $1,800 1 $3,600 5 $1,560 3% 10% 0 40% 5% 5 8.75% 4% 10% Discount rate (NCF) - beginning year 1 1. Find the value of the building at the beginning of year 1 and the implied going-in capitalization rate on NCF. (20 points) 2. Given the mortgage underwriting requirements below, what is the maximum loan amount a lender will approve if the loan is for 30 years at an annual interest rate of 8.25%? (20 points) a. Maximum LTV: 75% b. Minimum DSCR: 130% C. Minimum loan (debt) yield: 9.5% 3. Find the following for the approved loan: (10 points) a. Annual debt service b. LTV C. DSCR d. Loan yield Problem I: CRE Mortgage Underwriting (50 points) First Floor Second Floor Annual rent increase Vacancy and collection losses Miscellaneous income Operating expenses (% EGI) CAPEX (% EGI) Holding period (years) Going-out cap rate on NCF at end of year 5 Sales expenses (e.g., broker commission) year 5 # Suites Rent/month (year 1) 2 $1,800 1 $3,600 5 $1,560 3% 10% 0 40% 5% 5 8.75% 4% 10% Discount rate (NCF) - beginning year 1 1. Find the value of the building at the beginning of year 1 and the implied going-in capitalization rate on NCF. (20 points) 2. Given the mortgage underwriting requirements below, what is the maximum loan amount a lender will approve if the loan is for 30 years at an annual interest rate of 8.25%? (20 points) a. Maximum LTV: 75% b. Minimum DSCR: 130% C. Minimum loan (debt) yield: 9.5% 3. Find the following for the approved loan: (10 points) a. Annual debt service b. LTV C. DSCR d. Loan yield
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Graph the solution sets in Problems 316. x 100
-
Figure shows a portion of an infinitely long, concentric cable in cross section. The inner conductor carries a charge of 6 nC/m; the outer conductor is uncharged. (a) Find the electric field for all...
-
The Premier Car Title Loan Company makes emergency loans of up to $500 for 1 month for a fee of 4% of the loan amount. If a person borrows $500, what is (a) The nominal interest rate per year, and...
-
Wyler Company issued 20,000 shares of \(\$ 10\) par value common stock in exchange for a building with a current fair value of \(\$ 1,000,000\). In recording this transaction, what amount should be...
-
Angerstein Inc. produces calendars in a two-process, two-department operation. In the Printing Department, calendars are printed and cut. In the Assembly Department, the material received from...
-
Automobile Insurance The Patels have automobile liability and bodily injury coverage of $100,000/$300,000/$100,000. They have both comprehensive coverage (other than collision) and collision...
-
Bruin, Incorporated, has identified the following two mutually exclusive projects: Year Cash Flow (A) 01234 -$28,500 13,900 11,800 8,950 4,850 Cash Flow (B) -$28,500 4,050 9,550 14,700 16,300...
-
What approaches are used to deal with internal and external company problems in the context of Corporate Communication? Corporate Communication approach in dealing with internal company problems,...
-
A 7-inch gear and a 10-inch gear are in mesh. The speed of the 10-inch gear is 70 revolutions per minute (rpm). What will be the speed of the 7-inch gear
-
Charlotte is 22 years old, has just graduated from college, and is beginning her new job. She already has plans for her eventual retirement and will start saving right away with annual IRA...
-
The following schedule presents the beginning inventory, purchases and sales for Evan Corporations major product during the month of May. The company uses the perpetual approach only for units of...
-
You are required to note down on a weekly basis the activities that you personally engaged in , the lessons learned and the challenges you faced in relation to some of the topics below: - Prepare and...
-
help with this asap 11. The nucleus of an atom contains a) positive electrons and neutral neutrons. b) positive protons and neutral neutrons. c) negative electrons and neutral neutrons. d) negative...
-
How is use of the word consistent helpful in fraud reports?
-
Suppose you are often dissatisfied with the way things are done in your institution but are afraid to speak up or propose alternative ways of doing things. Does this mean you can never be a leader in...
-
How can one be a leader as a staff nurse?
-
Pittman, Rosenbach, and Potter (1998) described types of followers as: A. Subordinates who do what they are told but who are not actively involved. B. Contributors who are supportive, involved, and...
Study smarter with the SolutionInn App