reval - Inputallyellowshadedareas...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Input all yellow shaded areas Begin In terminal year Building space (in square feet) 528357 Vacancy rate = 95% 97% Rent/square foot 28.07 Inflation rate for rents/expenses = 3.00% 3.00% Inflation rate for real estate taxes = 4.00% 3.00% Inflation rate for ground rent = 0.00% 3.00% Unlevered beta = 0.62 0.50 Levered beta = 1.20 1.20 Riskfree rate = 5.40% Risk premium  = 4.00% 1 2 3 4 5 Terminal year Building Space 528357 528357 528357 528357 528357 Occupancy 95% 95.50% 96.00% 96.50% 97% Rent/Square foot $28.07 $28.91 $29.78 $30.67 $31.59 $32.54 Rental Income $14,512,115 $15,026,149 $15,557,965 $16,108,166 $16,677,377 $17,177,698 Garage Income $800,000 $824,000 $848,720 $874,182 $900,407 $927,419 $955,242 Reimbursement revenue 10.00% $353,735 $364,347 $375,277 $386,536 $398,132 $410,076 Credit Loss 2.50% $362,803 $375,654 $388,949 $402,704 $416,934 $429,442 Total Revenues $15,327,047 $15,863,563 $16,418,475 $16,992,404 $17,585,993 $18,113,573 Expenses Real Estate Taxes $5.24  $2,879,334 $2,994,508 $3,114,288 $3,238,860 $3,368,414 $3,469,466 Ground Rent $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,545,000 Other expenses $6.50 $3,537,350 $3,643,471 $3,752,775 $3,865,358 $3,981,319 $4,100,758 Management fee $300,000  $309,000 $318,270 $327,818 $337,653 $347,782 $358,216 Total Expenses $8,225,684 $8,456,248
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

reval - Inputallyellowshadedareas...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online