I am reposting this because i got incorrect answer. I posted other parts of this question as seperate. MUST SHOW WORK IN EXCEL.

Q2 Given the following information, calculate the net operating income assuming below-line treatment of capital expenditures: Property: 11 office units, Contract rents per unit: $2,350 per month; Vacancy and collection losses: 8%; Operating expenses: $92,700; Capital expenditures: 15%