Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

USE EXCEL please show formula Use the information below to derive NOI, Expenses per GBA, Expenses per NRA, OER and NIR. GBA NRA 25,000 20,000

image text in transcribed

USE EXCEL please show formula

Use the information below to derive NOI, Expenses per GBA, Expenses per NRA, OER and NIR. GBA NRA 25,000 20,000 INCOME PGI Less Vacancy & Collection Loss EGI Year! $300,000 $18,000 $282,000 EXPENSES Fixed Property Tax Insurance Total Fixed $11,900 $4,000 $15,900 Variable Management Fee Utilities Janitorial Maintenance Total Variable $14,100 $30,000 $18,000 $4,000 $66,100 Replacement Reserves Roof Equipment Total Reserve Allowance $17,740 $15,705 $33,445 Total Expenses $115,445 NOI Expenses per GBA Expenses per NRA Expense Ratio (OER) Expense Ratio (NIR)

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

Breaking Through The Wall A Financial Advisors Guide To Grow Scale And Monetize Your Business For Millions

Authors: Timothy Kneen, Maxwell Smith

1st Edition

1949639517, 978-1949639513

More Books

Students also viewed these Finance questions