Question

In: Finance

Assume the following for a floor in a multistory office building: total usable area: 33,000 sq...

Assume the following for a floor in a multistory office building:

  • total usable area: 33,000 sq ft;
  • Total common area: 5,000 sq ft;
  • total rentable area: 38,000 sq ft;
  • Tenant A’s usable area: 5,500 sq ft.
  • Tenant A’s annual rental rate is $25 per sq ft.

How much total rent does Tenant A pay per year?

Can you teach me how to do this in excel?

Solutions

Expert Solution


Related Solutions

Building type Average floor area (m2) Total floor area (m2) avg story height(cms) COST (HK$) 1...
Building type Average floor area (m2) Total floor area (m2) avg story height(cms) COST (HK$) 1 1852 81478 410 1467000000 1 1608 64313 411 1150000000 1 1430 55783 403 1028000000 1 1562 57794 390 1100000000 1 1109 37695 391 728000000 1 905 28048 382 558000000 1 1852 81478 410 1467000000 1 901 30617 391 631000000 1 1727 69062 400 1223000000 1 1161 37148 394 761000000 1 1004 37141 400 713000000 1 1216 38912 390 784000000 1 2007 88302 422 1593000000...
Building type Average floor area (m2) Total floor area (m2) avg story height(cms) COST (HK$) 1...
Building type Average floor area (m2) Total floor area (m2) avg story height(cms) COST (HK$) 1 1852 81478 410 1467000000 1 1608 64313 411 1150000000 1 1430 55783 403 1028000000 1 1562 57794 390 1100000000 1 1109 37695 391 728000000 1 905 28048 382 558000000 1 1852 81478 410 1467000000 1 901 30617 391 631000000 1 1727 69062 400 1223000000 1 1161 37148 394 761000000 1 1004 37141 400 713000000 1 1216 38912 390 784000000 1 2007 88302 422 1593000000...
Building type Average floor area (m2) Total floor area (m2) avg story height(cms) COST (HK$) 1...
Building type Average floor area (m2) Total floor area (m2) avg story height(cms) COST (HK$) 1 1852 81478 410 1467000000 1 1608 64313 411 1150000000 1 1430 55783 403 1028000000 1 1562 57794 390 1100000000 1 1109 37695 391 728000000 1 905 28048 382 558000000 1 1852 81478 410 1467000000 1 901 30617 391 631000000 1 1727 69062 400 1223000000 1 1161 37148 394 761000000 1 1004 37141 400 713000000 1 1216 38912 390 784000000 1 2007 88302 422 1593000000...
Building type Average floor area (m2) Total floor area (m2) avg story height(cms) COST (HK$) 1...
Building type Average floor area (m2) Total floor area (m2) avg story height(cms) COST (HK$) 1 1852 81478 410 1467000000 1 1608 64313 411 1150000000 1 1430 55783 403 1028000000 1 1562 57794 390 1100000000 1 1109 37695 391 728000000 1 905 28048 382 558000000 1 1852 81478 410 1467000000 1 901 30617 391 631000000 1 1727 69062 400 1223000000 1 1161 37148 394 761000000 1 1004 37141 400 713000000 1 1216 38912 390 784000000 1 2007 88302 422 1593000000...
Q No# 8 How is the maximum basic floor area of a building determined? Q No#...
Q No# 8 How is the maximum basic floor area of a building determined? Q No# 11 How are the exterior wall fire-resistance rating requirements determined for buildings that are on the same lot? Q No# 15 How are the required fire-resistance ratings of specific building elements determined? Q No# 16 How do the two different categories of Type I construction differ in fire protection? Q No# 17 Which characteristics are typical of a Group I occupancy? Q No# 18...
1. Assume that Area of kitchen is 15% of the total renovation area Area of bathrooms...
1. Assume that Area of kitchen is 15% of the total renovation area Area of bathrooms is 10% of the total renovation area Area of living room and dining room is 35% of the total renovation area Area of bedrooms is 40% of the total renovation area 2. Kitchen, living room and dining room flooring would be engineered wood flooring. Bathrooms would be natural stone tile floor and bedrooms would be carpet. Calculate the cost of flooring materials for kitchen,...
Building Type   Land Area in Acres   Living Area   Total Assessed Land Value   Total Assessed Parcel Value...
Building Type   Land Area in Acres   Living Area   Total Assessed Land Value   Total Assessed Parcel Value Commercial   0.20860882 318 625900 730700 Commercial   0.21751607 3630 423700 741100 Commercial   5.5474977 59506 10253200 13547100 Commercial   0.18682277 3780    293300 460200 Commercial   0.55227273 22017 681300 1214000 Condominium   0 1776 0 579500 Condominium   0   1270 0 512100 Condominium   0 2076 0 578900 Condominium   0 1132 0 281800 Condominium   0 957 0 266800 Condominium   0 1128 0 481100 Condominium   0 1235 0 470400 Condominium   0 1264...
An appraiser is appraising an office building in Manhattan. Assume that the population of these appraisals...
An appraiser is appraising an office building in Manhattan. Assume that the population of these appraisals is normally distributed. For commercial appraisals, a comparison analysis and a cost analysis is done. A comparison analysis involves finding the sale prices of several comparable properties (within the last six months) and computing an average value. The cost method involves determining the present cost of duplicating the given property. Clearly, if the comparable analysis yields a present market price greater than the cost...
Assume that HCA is evaluating the feasibility of building a new hospital in an area not...
Assume that HCA is evaluating the feasibility of building a new hospital in an area not currently served by the company. The company's analysts estimate a market beta for the hospital project of 1.1, which is somewhat higher than the 0.8 market beta of the company's average project. Financial forecasts for the new hospital indicate an expected rate of return on the equity portion of the investment of 20 percent. If the risk-free rate, RF, is 7 percent and the...
The property you are appraising is a five-story office building. Each floor has 10,000 square feet...
The property you are appraising is a five-story office building. Each floor has 10,000 square feet of rentable space and is suitable for single occupancy. Two tenants have leases. Floor 3 is occupied under a five-year lease with three years remaining. The current rental is $128,600 per year. Floor 4 is occupied under a new five-year lease and the rent is $150,000 per year. Floors 1, 2, and 5 are vacant. The rent being paid for the fourth floor is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT