Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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? image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Frequently Asked Questions In International Standards On Auditing

Authors: Steven Collings

1st Edition

1118765419, 978-1118765418

More Books

Students also viewed these Accounting questions

Question

1. Let a, b R, a Answered: 1 week ago

Answered: 1 week ago