Business, 27.04.2021 16:00 foriegnngal

Ann is looking to buy an office building in 2014. She plans to rent it out for 5 years (2015-2019) and sell it at the end of 2019. Use the first sheet of the spreadsheet (titled "NOI") to compute the Net Operating Income (NOI) for this property for 2015. Fill in the missing information in the spreadsheet. This property has two types of operating income, rental income and parking.
A B C D E F G
Inputs Green text represent inputs
Square feet 20000. 00
Annual rent
per square foot $72.50 20
Parking income
2015 $65, 000. 00 Purple text represent outputs

Rental vacancy
rate 2015 2.40% % of
square feet 2015
Collection loss
rate 2015 2.00% % of
PGT
Operating
expense rate
2015 47.00% % of EGI Rental Income 1,450,000.00
Parking
Potential Gross Income (PGI)
Vacancy Expenses
Collection losses
Effective Gross Income (EGI)
Operating Expenses
Net Operating Income (NOI) $65, 000. 00
Asking cap rate 2014
Asking Price 6. 50%
This property has two types of operating income, rental income and parking. Rental Income in 2015 = (# square feet)(Annual rent per square foot in 2015) Parking is a fixed dollar amount given Vacancy expenses in 2015 = (Rental vacancy rate in 2015)(rental income in 2015) Collection losses in 2015 = (collection loss rate in 2015)(PGI in 2015) Operating Expenses in 2015 = (Operating expense rate in 2015)(EGI in 2015)
(A) What is the NOI for 2015?
(B) If this building is being sold in 2014 at an asking cap rate of 6.50%, what is the asking price?

Answers: 2

Show answers

Another question on Business

Business, 23.06.2019 02:00

True of false: the chancellor of a university has commissioned a team to collect data on students' gpas and the amount of time they spend bar hopping every week (measured in minutes). he wants to know if imposing much tougher regulations on all campus bars to make it more difficult for students to spend time in any campus bar will have a significant impact on general students' gpas. his team should use a t test on the slope of the population regression.

Answers: 1

Answer

Business, 23.06.2019 17:50

Suppose that georgiania was a thriving empire in its golden age. business was booming and it was the center of international trade under the leadership of emperor raphael iii. his empire's pride and joy was the trading of green and black tea, and he decreed that their entire economy should be built around it. however, in the mid 1800s, georgiania experienced a severe economic downturn when the other nations of the world created an embargo on tea from georgiania, which led to civil strife due to thousands of workers being laid off.a downward fluctuation in the economy like this is known as a )the correct term is a key component )

Answers: 2

Answer

Business, 23.06.2019 20:30

Saks fifth avenue wants to learn about its consumers' attitudes toward on-line purchases. there are numerous studies that are available about consumers and on-line buying, but saks believes its customers might be different from the usual on-line consumer profile, so they decide to conduct their own study. if saks were to use the available data about consumer attitudes, it would be using data; however, if saks does its own study it would collect data.

Answers: 3

Answer

Business, 23.06.2019 21:00

Type the object of the prepositional phrase that appears in capital letters. marcy plans to select a worthy charity and offer to with fund-raising events.

Answers: 1

Answer

You know the right answer?

Ann is looking to buy an office building in 2014. She plans to rent it out for 5 years (2015-2019) a...

Questions