subject
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?

ansver
Answers: 2

Another question on Business

question
Business, 22.06.2019 18:20
Now ray has had the tires for two months and he notices that the tread has started to pull away from the tire. he has already contacted the place who sold the tires and calmly and accurately explained the problem. they didn’t him because they no longer carry that tire. so he talked with the manager and he still did not get the tire replaced. his consumer rights are being violated. pretend you are ray and write a letter to the company’s headquarters. here are some points to keep in mind when writing the letter: include your name, address, and account number, if appropriate. describe your purchase (name of product, serial numbers, date and location of purchase). state the problem and give the history of how you tried to resolve the problem. ask for a specific action. include how you can be reached.
Answers: 3
question
Business, 23.06.2019 00:40
Mesa company produces wooden rocking chairs. the company has two production departments, cutting and assembly. the wood is cut and sanded in cutting and then transferred to assembly to be assembled and painted. from assembly, the chairs are transferred to finished goods inventory and then are sold.mesa has compiled the following information for the month of february: cutting department assemblydepartmentdirect materials $ 73,000 $ 13,000direct labor 73,000 108,000applied manufacturing overhead 159,000 171,000cost of goods completed and transferred out 233,000 255,000required: 1, 2, 3, & 4. prepare journal entries for the transactions in the cutting and assembly departments of mesa company. (if no entry is required for a transaction/event, select "no journal entry required" in the first account field.)
Answers: 3
question
Business, 23.06.2019 02:00
Andrea's opportunity cost rate is 12 percent compounded annually. how much must he deposit in an account today if he wants to receive $2,100 at the beginning of each of the next seven years? use the equation method to determine the amount.
Answers: 3
question
Business, 23.06.2019 04:50
According to fiedler, in situations that are very unfavorable for the leader, it would be wise to choose someone who: a. is task oriented. b. is likely to engage in behaviors that are classified as consideration behaviors. c. has a low lpc score. d. has a high lpc score.
Answers: 1
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
question
Mathematics, 18.03.2021 22:10
question
Mathematics, 18.03.2021 22:10
question
Engineering, 18.03.2021 22:10
question
Biology, 18.03.2021 22:10