Consider the following loan information. . Total acquisition price: $3,000,000. Property consists of twelve office suites,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the following loan information. . Total acquisition price: $3,000,000. Property consists of twelve office suites, five on the first floor and seven on the second. Contract rents: three suites at $2,400 per month, two at $3,000 per month, and seven at $1,330 per month. Annual market rent increases: 3% per year. W . .. . Vacancy and collection losses: 5% per year. .. Operating expenses: 35% of effective gross income each year. . Capital expenditures: 6% of effective gross income each year. . . W Expected holding period: 5 years. W Expected selling price in year 5: Year 6 NOI capitalized at 5%. Selling expenses in year 5: 3% of the sale price. First mortgage loan: 75% LTV. . . M Annual mortgage interest rate: 4.5%. Loan term and amortization period: 25 years (monthly payments). Total up-front financing costs: 2% of loan amount. Required return: 9% 1. Create a one-year operating pro forma and calculate investment criteria (cap rate, equity dividend rate, net income multiplier, effective gross income multiplier, debt coverage ratio, debt yield ratio, and loan-to- value ratio). 2. Create a five-year operating pro forma up to BTCF and BTER. 3. Calculate the NPV and IRR of the project based on the 5-year levered cash flows. 4. (Sensitivity Test) Calculate the project NPV of levered cash flows based on the following required return assumptions: 10%, 12%, 14%, 16%, 18%, and 20%. 5. (Extra Credit 5pts) Calculate the project NPV of levered cash flows when LTV is 90% (instead of 75%). How does it change the NPV and IRR? Consider the following loan information. . Total acquisition price: $3,000,000. Property consists of twelve office suites, five on the first floor and seven on the second. Contract rents: three suites at $2,400 per month, two at $3,000 per month, and seven at $1,330 per month. Annual market rent increases: 3% per year. W . .. . Vacancy and collection losses: 5% per year. .. Operating expenses: 35% of effective gross income each year. . Capital expenditures: 6% of effective gross income each year. . . W Expected holding period: 5 years. W Expected selling price in year 5: Year 6 NOI capitalized at 5%. Selling expenses in year 5: 3% of the sale price. First mortgage loan: 75% LTV. . . M Annual mortgage interest rate: 4.5%. Loan term and amortization period: 25 years (monthly payments). Total up-front financing costs: 2% of loan amount. Required return: 9% 1. Create a one-year operating pro forma and calculate investment criteria (cap rate, equity dividend rate, net income multiplier, effective gross income multiplier, debt coverage ratio, debt yield ratio, and loan-to- value ratio). 2. Create a five-year operating pro forma up to BTCF and BTER. 3. Calculate the NPV and IRR of the project based on the 5-year levered cash flows. 4. (Sensitivity Test) Calculate the project NPV of levered cash flows based on the following required return assumptions: 10%, 12%, 14%, 16%, 18%, and 20%. 5. (Extra Credit 5pts) Calculate the project NPV of levered cash flows when LTV is 90% (instead of 75%). How does it change the NPV and IRR?
Expert Answer:
Answer rating: 100% (QA)
1 OneYear Operating Pro Forma and Investment Criteria Potential Gross Income PGI 2400 3 3000 2 1330 7 31710 12 380520 Vacancy and Collection Loss 5 38... View the full answer
Related Book For
Real Estate Finance and Investments
ISBN: 978-0073377339
14th edition
Authors: William Brueggeman, Jeffrey Fisher
Posted Date:
Students also viewed these finance questions
-
The property consists of 10 office suites, 4 on the first floor and 6 on the second. - Contract rents: 2 suites at $1,500 per month, 2 at $3,600 per month, and 6 at $1,560 per month. - Vacancy and...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
1. What are the four basic types of unemployment? Which type is most pronounced during difficult economic times such as we have been experiencing during the last few years? Which type is most...
-
The total cost of repaying a student loan at an interest rate of r % per year is C = f(r). (a) What is the meaning of the derivative f'(r)? What are its units? (b) What does the statement f'(10) =...
-
In protocol 6, when a data frame arrives, a check is made to see if the sequence number differs from the one expected and nonak is true. If both conditions hold, a NAK is sent. Otherwise, the...
-
What are the inflation targets for the central banks in the US, UK and the Eurozone countries?
-
The following table gives the map coordinates and the shipping loads for a set of cities that we wish to connect through a central hub. (a) Near which map coordinates should the hub be located? (b)...
-
An individual pays 4,000 p.a. into a savings account for 10 years. During the first 4 years, the payments are made quarterly in advance. For the remaining years, the payments are made continuously....
-
Solve y" + y = 1 - t 2 / 2 ? if 0 < t < and 0 if t ?? ??; here, y(0) = 0, y' (0) = 0. This models an undamped system on which a force F acts during some interval of time (see Fig. 59), for instance,...
-
Change dycdk into an equivalent the Cartesian integral polar integral. Then evaluate the polar integral Select one: O a. na O b. No correct answer O c 2ra O d. 2ra O e. za Check
-
Name two quasi-governmental entities.
-
Where is the IASB based?
-
An auditor's risk of misstatement of accounts receivable is least likely to increase if there is a. An increase in customer complaints about their accounts. b. A general slowdown in cash collections....
-
An auditor's purpose in reviewing credit ratings of customers with delinquent accounts receivable most likely is to obtain evidence concerning management's assertions about a. Valuation or...
-
Can a company charge any proposed dividends to its income statement?
-
When working with gas mixtures we often use the approximation that the gas mixture is ideal. However, when studying condensed phases, the simple solution model is often inappropriate. 1. Dene what is...
-
In Exercises 1558, find each product. (9 - 5x) 2
-
How can mechanics liens achieve priority over first mortgages that were recorded prior to the mechanics lien?
-
How does each of the following affect the IRR on the ATCF difference from owning versus leasing? a. The property can be leased for $175,000 instead of $200,000. b. A loan can be obtained at an 8...
-
What are special allocations?
-
Mass transfer models include transfer in only the packed region. Mass transfer also occurs in the column ends where liquid and vapor are separated. Discuss how these end effects affect a design. How...
-
Construct your key relations chart for this chapter.
-
a. The Bolles and Fair (1982) correlation indicates that \(\mathrm{H}_{\mathrm{G}}\) is more dependent on liquid flux than on gas flux. Explain this on the basis of a simple physical model. b. Why do...
Study smarter with the SolutionInn App