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...
-
What is the relationship between tuition and student enrollment at a university. How would this relationship be graphed?
-
The group in DNA that reacts with the diol-epoxide has the following general structure. Using mechanistic reasoning, show how the amino group indicated by the asterisk (*) might react with the...
-
Independent random samples were selected from each of two normally distributed populations, n1 = 6 from population 1 and n2 = 4 from population 2. The data are shown in the following table. Sample 1...
-
The trial balance of Zoop Co. shown below does not balance. Each of the listed accounts has a normal balance per the general ledger. An examination of the ledger and journal reveals the following...
-
Ryan wishes to purchase a new boat and can afford monthly payments of up to $\$ 600$ per month. Finance is available, and the terms are that the loan lasts for 4 years and the annual interest rate is...
-
a. To simplify the analysis, assume for now that there is virtually no turnaround time between flights so the next flight can begin as soon as the current flight ends. (If an immediate next flight is...
-
The Pareto distribution is sometimes used in economics as a. model for a. density function with a slowly decaying tail. Its p.d.f. is given by f($|$o,0) = Mfg1, w 2 560,9 > 1 Assume that :50 is...
-
A drug is used to help prevent blood clots in certain patients. In clinical trials, among 4705 patients treated with the drug, 170 developed the adverse reaction of nausea. Construct a 95% confidence...
-
A popular theory is that presidential candidates have an advantage if they are taller than their main opponents. Listed are heights (in centimeters) of randomly selected presidents along with the...
-
Cash Flows Horiz Analysis Horiz Analysis Vertic Analysis Vertic Analysis from Oper Inc St Bal St Inc St Bal Sheet Ratios Requirement Prepare the cash flows from operations section of R. Ashburn...
-
Rudy Gandolfi owns and operates Rudy's Furniture Emporium Incorporated. The balance sheet totals for assets, liabilities, and stockholders' equity at August 1, 2022, are as indicated. Described here...
-
The brand manager for a brand of toothpaste must plan a campaign designed to increase brand recognition. He wants to first determine the percentage of adults who have heard of the brand. How many...
-
A fiduciary is personally liable for any losses due to a breach in duty and can be liable for a breach by a co-fiduciary as well. Group of answer choices True False
-
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?
-
How can software assist in procuring goods and services? What is e-procurement software? Do you see any ethical issues with e-procurement? For example, should stores be able to block people with...
-
What is the main purpose of a procurement audit? LO.1
-
In Chapter 7, we will learn to split the data set into a training data set and a test data set. To test whether there exist unwanted differences between the training and test set, which hypothesis...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App