LevPFsolutions_400X_fa10

LevPFsolutions_400X_fa10 - USC FBE 400X University View...

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

View Full Document Right Arrow Icon
Robert Bridges, A.I.A., 7/9/04, Page 1 USC FBE 400X University View Building: Leveraged 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%) (7,020) (7,231) (7,448) (7,671) (10,260) (10,568) (10,885) Net Operating Income 109,980 113,279 116,678 120,178 160,740 165,562 170,529 Capital Reserves (1,170) (1,205) (1,241) (1,278) (1,710) (1,761) (1,814) Tenant Improvements (225,000) Capitalized Value (Sales Price) 2,131,613 Sales Commission (5%) (106,581) Total Cash Flows (1,275,000) 108,810 112,074 115,437 (106,100) 159,030 2,188,834 Present Value (11%)
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.

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

Page1 / 2

LevPFsolutions_400X_fa10 - USC FBE 400X University View...

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