i posted the question and my professors solution to the problem. can someone explain how to get he got ROI & where the $11.77 came from?
G G D 71 F 72 Problem 4. An office building has the following rent roll (a statement showing all the space in the building and who occupies them as well as other important information 73 from the lease): 74 Tenant Rentable 75 Suite Expense Renter SF Income Stop Abracadaba Ltd 76 101 NNN (ic 3,509 $13.95 48950.55 SO) 77 Betterment Co 102 3,952 $14.72 NNN 58173.44 78 Charisma Inc 201 4,504 $15.09 $8.45 $67,965 36 79 Xanthum Ind. 204 2,969 $14.29 $9.09 S42,427.01 80 Zephyr LLC 300 7.531 $16.25 $7.01 S122,378.75 81 In addition to the tenants, there is $900/mo in storage income and there is a rooftop antenna lease that pays $15,000 per year. Both of these are considered "Other 82 Income 83 84 Expenses are as follows (all amounts monthly unless indicated otherwise): 85 Management foe: 6% of gross income 86 Utilities: $1,795 87 Maintenance & Repairs: $1,500 88 Salaries & Personnel: S2.500 89 Property Taxes: $89.000/yr 90 Insurance: $52,500/yr 91 Landscaping: $995 92 Advertising/Marketing: 5900 193 94 Prepare an income statement (operating cash flow statement) for the next 12 months of this property 95 % Paste Conditional Formatting Format as Tablo Font Alignment Number Cell Styles x fx =SUM(F57:F64)/SUM(B46:350) + Calls Editing Ideas H64 A B D E F G K 3,509 3,9521 4,504 2,969 7.531 Tenint $11.77 $11.77 $3.32 $2.68 $4.76 LL Reimb $0.00 $41,318.06 $0.00 $46,534.33 8.45 $14,975.27 9.09 $7,971.41 7.01 $35.884.32 $146,683.39 SO 45 46 47 48 49 SO 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 11 Annual Totals $13.95 $48,951 $14.72 $58,173 $15.09 $67,965 $14.291 $42,427 $16.25 $122,379 Gross Rent $339,895 annual total Expense Reimb Storage Income $10,800 Rooftop Antenna $15.000 Gross Income $512,378 Mgmt Fee $30,743 Utilities $21,540 Maintenance & Repair $18,000 Salaries & Personnel $30,000 Property Taxes $89,000 Insurance $52,500 Landscaping $11.940 Advertising/Marketing $10.800 Total $264,523 $11.77 NOI S247,856