Question: Please type out formula please use excel. CH. 9 - OFFICE CASE STUDY You own a 232 unit apartment complex. It is a combination of

Please type out formula

please use excel.

Please type out formula please use excel. CH. 9 - OFFICE CASE

CH. 9 - OFFICE CASE STUDY You own a 232 unit apartment complex. It is a combination of 1 and 2 bedroom units. The average rent per unit is 885.65 per month. Vacancy and collection loss is 11.55% of gross rent. You collect non-rental income from parking, laundry, etc. of 111,080. Several units were signed to leases prior to a market rent increase so your 'loss to lease' is 263.09 per unit (annually). You recover a certain number of utility expenses from renters in the amount of 200,000. You believe per year you should save/earmark 246,095 for capital expenditures. Concessions to renters will amount to 181,739. Operating expenses are 990,380. What is Net Operating Income? What is Net Cash Flow

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Please type out formula Please use excel CH. 9 - OFFICE CASE STUDY - A building had a survey completed and is 501,362 sq ft. Vacancy is 5% of gross rent. Expenses per rentable sq ft is 13.39....

Type out all formulas. Then Type out all formulas out in excel. Show formulas and numbers. CH. 9 - OFFICE CASE STUDY A building had a survey completed and is 501,362 sq ft. Vacancy is 5% of gross...

1. Type out equation and fill in. 2. Put formulas into excel and show numbers and formula. CH. 9 OFFICE CASE STUDY You own a 232 unit apartment complex. It is a combination of 1 and 2 bedroom units....

Can someone please help me answer the four questions on the first two pages? NA0274 Cavendish Cove Cottages Sean Hennessey, University of Prince Edward Island \"I just don't know if the asking price...

Read the Seattle Pacific Hotel case with particular focus to the Project Financing/Sources of Funds box and the Tax Credit Analysis box. Assuming the following factors change: The current yield for...

Please answer this with clear instruction and screenshots. Thank you Office 2016- myitlab:grader Instructions Excel Project EX16_XL_CH07_GRADER CAP_HW - Apartment Complex 1.9 Project Description You...

Use comparable to start to develop a plan for a current project using data from previous projects. As we start to develop this proforma to evaluate alternative cost proposals, we are going to build...

Please see the attachment and prepare financial analysis using spreadsheet and determine whether or not they should go with the project. For the exclusive use of Z. Wu, 2016. REVISED APRIL 14, 2016...

Business Research MethodologyQuestion Bank 1 1. When the marketing department of an organization attempts to determine the amount of time the managers in this department spend at their computers in...

PLEASE HELP ME WITH IS EXCEL WORKSHEET. DIRECTIONS AND WORKSHEET ATTACHED Search Engine Enter Unit # to see rent Rental Price Unit # 101 102 103 104 105 106 107 108 109 110 201 202 203 204 205 206...

Haillie Inc. manufactures two products: A123 and B456. Of the two product lines, the B456 product line is more complex, requiring one hour of direct labour time per unit to manufacture, compared to...

For Example 3.7 (p. 150) and the scatter diagram in Figure 3.26 on page 151: a. Explain how the slope of 4.71 can be seen. b. Explain why the y-intercept of-186.5 cannot be seen.

George, a participant at the convention , has recently taken over his grandfather s bakery in a Midwestern city. He wants to place a radio spot on one of the local stations. How can George best take...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...