LevPFtemplate_400X_sp10

LevPFtemplate_400X_sp10 - (106,581 Total Cash...

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%)
Background image of page 1

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

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

Unformatted text preview: (106,581) Total Cash Flows (1,275,000) 108,810 112,074 115,437 (106,100) 159,030 2,188,834 Present Value (11%) $1,468,120 Net Present Value $193,120 IRR 14.03% Leveraged Analysis: Annual Interest Rate Loan at 0% LTV Points Loan Term (Years) Loan at DSCR Maximum LTV Actual loan amount received Leveraged Discount Rate Minimum DSCR Actual Yearly debt service Year Year Year Year Year Year Year Year 1 2 3 4 5 6 7 Net Operating Income ♥ Robert Bridges, A.I.A., 7/9/04, Page 1 Capital Reserves Tenant Improvements Debt Service Cash Flow After Debt Service Sales Price Mortgage Balance Sales Commission Before Tax Cash Flow (BCTF) Asking Price Loan Amount Points Total Cash Flows Leveraged Present Value Leveraged Net Present Value Leveraged Internal Rate of Return...
View Full Document

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

Page1 / 2

LevPFtemplate_400X_sp10 - (106,581 Total Cash...

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