Question

Oxford Street Development Company's new project The LuLu DeLux has three components: Office, Retail, and Multifamily. There are 12,500 feet of office space, 25,000 feet of retail space and 10 apartments. The office space is subject to a ten-year gross lease at $30 per sq ft per year with $.50 annual increases. Base year expenses $12 per square foot. Expenses are expected to rise at 3% per annum. The retail space pays a $20 base rent per sq ft per year and 8% participating rent over a natural breakpoint on a ten-year lease. The base rent increases at the beginning of year 6 to $25 per square foot and the percentage rent resets. First year sales are $300 per square foot. Sales are expected to grow at a rate of 4% per annum. Retail expenses are 1.5 times the level of office expenses on a per square foot basis. The retail tenants reimbureses 90% of actual expenses. Of the 10 apartments there are 5 one bedrooms and 5 two bedrooms. Multifamily montly rents start at $1500 for one bedroom and $2700 for a two bedroom. All leases are one-year leases. They will rise each year at the CPI of 3.5%. Residential expenses are 40% of rents. You will hold the building for 10 years.

What is the year 6 NOI of the office, retail, and multifamily space ( please calculate NOI of each place separately). What is the total NOI for the investment period?

Answer 1

Office Space	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10
Area in feet	12,500	12,500	12,500	12,500	12,500	12,500	12,500	12,500	12,500	12,500
Rent in feet	30.00	30.50	31.00	31.50	32.00	32.50	33.00	33.50	34.00	34.50
Expenses in feet	12.00	12.36	12.73	13.11	13.51	13.91	14.33	14.76	15.20	15.66
NOI per feet	18.00	18.14	18.27	18.39	18.49	18.59	18.67	18.74	18.80	18.84
NOI	225,000	226,750	228,365	229,841	231,174	232,359	233,392	234,269	234,984	235,534
Retail Space	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10
Area in feet	25,000	25,000	25,000	25,000	25,000	25,000	25,000	25,000	25,000	25,000
Rent per feet	20.00	20.00	20.00	20.00	20.00	25.00	25.00	25.00	25.00	25.00
Participating rent feet(8% of 300)	24.00	24.96	25.96	27.00	28.08	29.20	30.37	31.58	32.85	34.16
Expense Reimbursement - 90%	16.20	16.69	17.19	17.70	18.23	18.78	19.34	19.92	20.52	21.14
Expenses	18.00	18.54	19.10	19.67	20.26	20.87	21.49	22.14	22.80	23.49
NOI per feet	42.20	43.11	44.05	45.03	46.05	52.11	53.22	54.37	55.57	56.81
NOI	1,055,000	1,077,650	1,101,220	1,125,746	1,151,267	1,302,824	1,330,459	1,359,215	1,389,137	1,420,272
Apartment	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10
Number of flats	10	10	10	10	10	10	10	10	10	10
Rent (5*2700 + 5*1500)	4,200.00	4,347.00	4,499.15	4,656.62	4,819.60	4,988.28	5,162.87	5,343.57	5,530.60	5,724.17
Expenses	1,680.00	1,738.80	1,799.66	1,862.65	1,927.84	1,995.31	2,065.15	2,137.43	2,212.24	2,289.67
NOI (per ares / per flat)	2,520.00	2,608.20	2,699.49	2,793.97	2,891.76	2,992.97	3,097.72	3,206.14	3,318.36	3,434.50
NOI	25,200	26,082	26,995	27,940	28,918	29,930	30,977	32,061	33,184	ekkarill92 Next > < Previous Related Solutions Your company's research and development department has been working on a new process that, if it... Your company's research and development department has been working on a new process that, if it works, can produce oil from coal at a cost of about $15 per barrel versus a current market price of $100 per barrel. The company needs $10 million of external funds at this time to complete the research. The results of the research will be known in about one year, and there is about a 50-50 chance of success. If the research is successful,... Project Title: Development of pre-employment selection testing for entry-level Retail Salespersons in retail clothing stores. Scope... Project Title: Development of pre-employment selection testing for entry-level Retail Salespersons in retail clothing stores. Scope of Project: The entry-level Retail Salesperson position is responsible for selling the popular “Big Turtle” clothing and merchandise at their retail stores. There are approximately 50 retail stores located throughout the Southeast region, employing over 600 Retail Salespersons. Currently, turnover for this title is averaging 50% annually. Big Turtle Clothiers, Inc. (BTC) also anticipates opening 10 new stores per year for the next 5... The company's management is considering a new 8 year project. The project will require the purchase... The company's management is considering a new 8 year project. The project will require the purchase of a new piece of equipment at a cost of $600,000. The equipment will last eight years and have no salvage value at the end of its life. This project will generate incremental net cash revenues eah year duing the assets life in the amount of $140,000. The company uses straight-line depreciation and requires a minumum of 10% return on all new projects. 1.... Oxnard Petro, Ltd., has three interdisciplinary project development teams that function on an ongoing basis. Team... Oxnard Petro, Ltd., has three interdisciplinary project development teams that function on an ongoing basis. Team members rotate from time to time. Every 4 months (three times a year) each department head rates the performance of each project team (using a 0 to 100 scale, where 100 is the best rating). Are the main effects significant? Is there an interaction? Year Marketing Engineering Finance 2007 88 77 79 84 76 91 85 66 97 2009 90 78 77 82 76... Project finance has become a major source of financing for infrastructure development .Three countries have successfully... Project finance has become a major source of financing for infrastructure development .Three countries have successfully utilized project finance successfully such as China, Dubai and Australia.Given the reasons why a project would be financed using a project fiance Model as compared to conventional finance Oxnard Petro, Ltd., has three interdisciplinary project development teams that function on an ongoing basis. Team... Oxnard Petro, Ltd., has three interdisciplinary project development teams that function on an ongoing basis. Team members rotate from time to time. Every 4 months (three times a year) each department head rates the performance of each project team (using a 0 to 100 scale, where 100 is the best rating). Are the main effects significant? Is there an interaction? Year Marketing Engineering Finance 2007 82 65 95 84 83 93 86 68 91 2009 88 74 85 87 66... Oxnard Petro, Ltd., has three interdisciplinary project development teams that function on an ongoing basis. Team... Oxnard Petro, Ltd., has three interdisciplinary project development teams that function on an ongoing basis. Team members rotate from time to time. Every 4 months (three times a year) each department head rates the performance of each project team (using a 0 to 100 scale, where 100 is the best rating). Are the main effects significant? Is there an interaction? Year Marketing Engineering Finance 2007 90 69 96 84 72 86 80 78 86 2009 72 73 89 83 77... You are completing a software development project. This project is expected to add SIX new features... You are completing a software development project. This project is expected to add SIX new features to a popular software program you sell to customers. The projected cost for the project is $100,000 and the development is expected to take 5 weeks. At the end of the second week, you spent $17,500 per new software feature and you completed the development of two new features. You are about to start the development of the third new software feature. Based on... Angela's LandBuyers has a new commercial real estate development proposal. The project will cost $500,000 today... Angela's LandBuyers has a new commercial real estate development proposal. The project will cost $500,000 today and produce positive cash inflows of $150,000 for each of the next six years. In year six, the project also requires an environmental revitalization cost of $50,000. Based on these initial figures, Angela's has calculated that the project produces a positive NPV and has an IRR greater than the required return of 15%. Prior to making a final decision about the project, the town's... Comparison of two hypothetical cases: Project 1: New construction of a highrise building in Wall Street,... Comparison of two hypothetical cases: Project 1: New construction of a highrise building in Wall Street, Manhattan, NYC. Project 2: New construction of LNG tanks in Cameron, Louisiana Two projects are greatly different in terms of project type and location. Discuss and compare unique impacts on the environment and public that may occur in each project. ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions How many grams of NaCl are contained in 350. mL of a 0.152 M solution of... Why does diversity matter for business? Provide 2-3 benefits and 2-3 challenges Dr C #1 An object with mass = 5 kg is oscillating on the end of... Calculate the value of a bond that matures in 13 years and has a $1,000 par... The documentary Gender Revolution implies that gender today—gender identities and categories—are vastly different today than they... 12. What is the payment in month 13 on a CAM loan for $250,000 with a... Which of the following is true of variable costing? It expenses administrative costs as costs of... ADVERTISEMENT About @ 2020 WizEdu