UVUnlevProformaSolution

UVUnlevProformaSolution - (7,020) (7,231) (7,448) (7,671)...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Robert Bridges, A.I.A., 7/9/04, Page 1 University View Building: Unleveraged Analysis Spreadsheet Problem Assumptions: 5,000 Leasable Area (S.F.) 11.00% Discount Rate 5% Sales Commission 1.95 Net Rent (Monthly) 45 Rehab./TI Cost (Per S.F.) 1% Capital Reserves 8% Cap Rate 2.85 Revised Lease Rate 1,275,000 Asking Price 3% CPI Adjustment 6% Vacancy and Collection Loss Pro-Forma Statement of Income Year Year Year Year Year Year Year Year 0 1 2 3 4 5 6 7 Potential Net Income 117,000 120,510 124,125 127,849 171,000 176,130 181,414 Vacancy and Collection Loss (6%)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: (7,020) (7,231) (7,448) (7,671) (10,260) (10,568) (10,885) Net Operating Income (NOI) 109,980 113,279 116,678 120,178 160,740 165,562 170,529 Capital Reserves (1,100) (1,133) (1,167) (1,202) (1,607) (1,656) (1,705) Tenant Improvements (225,000) Capitalized Value (Sales Price) 2,131,613 Sales Commission (5%) (106,581) Total Cash Flows (1,275,000) 108,880 112,147 115,511 (106,024) 159,133 2,188,939 Present Value (11%) $1,468,464 Net Present Value 193,464 IRR 14.03%...
View Full Document

This note was uploaded on 06/08/2011 for the course BUAD 400x at USC.

Ask a homework question - tutors are online