Practice problems - RENT $270,000.00 $274,050.00...

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

View Full Document Right Arrow Icon
IRR 17% growth 5% cap 12% Year NOI 1 150,000 2 157,500 3 165,375 4 173,644 5 182,326 6 191,442 7 201,014 8 211,065 Year Cashflow 0 0 1 150,000 2 157,500 3 165,375 4 173,644 5 182,326 6 191,442 7 1,959,890 rev value 1,758,876 NPV $1,250,000.00
Background image of page 1

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

View Full DocumentRight Arrow Icon
TENANT SPACE SF ANNUAL RENT PSF 1 20,000 16 2 30,000 17 3 25,000 17 4 25,000 19 TOTAL 100,000 OPERATING EXPENSES RE Taxes 325,000 Insurance 50,000 Utilities 118,000 Maintenance 220,000 TOTAL 713,000 OPERATING EXPENSE PSF 7.13 MANAGEMENT EXPENSES 5% VACANCY 4%
Background image of page 2
ANNUAL RENT AMMOUNT EXPENSE STOP REIMBURSABLE PSF REIMB $$$ 320,000 5 2.13 42600 510,000 5 2.13 63900 425,000 6 1.13 28250 475,000 7 0.13 3250 1,730,000 138,000 RENT 1,730,000 REIMBURSEMENT 138,000 PGI 1,868,000 VACANCY 74720 EGI 1,793,280 OPERATING EXPENSES 802664 NOI 990,616
Background image of page 3

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

View Full DocumentRight Arrow Icon
PURCHASE PRICE $1,800,000.00 LTVR 75% DEBT $1,350,000.00 EQUITY $450,000.00 AMORT 25 YEARS INTEREST 8.50% EXIT CAP 10.60% END YR5 MORTG PAYMENT ($10,870.57) ADS ($130,446.79) YEAR 0 YEAR 1 YEAR 2 YEAR 3
Background image of page 4
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: RENT $270,000.00 $274,050.00 $278,160.75 VACANCY 6% $(16,200.00) $(16,443.00) $(16,689.65) EGI $253,800.00 $257,607.00 $261,471.11 OP EXPENSE 28% $(71,064.00) $(72,129.96) $(73,211.91) NOI $182,736.00 $185,477.04 $188,259.20 ADS ($130,446.79) ($130,446.79) ($130,446.79) BTCFo $52,289.21 $55,030.25 $57,812.41 SALE PRICE COMMISSION OLB BTCFs NET CASHFLOW $(450,000.00) $52,289.21 $55,030.25 $57,812.41 15.88% YEAR 4 YEAR 5 YEAR 6 $282,333.16 $286,568.16 $290,866.68 $(16,939.99) $(17,194.09) $(17,452.00) $265,393.17 $269,374.07 $273,414.68 $(74,310.09) $(75,424.74) $(76,556.11) $191,083.08 $193,949.33 $196,858.57 ($130,446.79) ($130,446.79) $60,636.30 $63,502.54 $1,857,156.32 $(55,714.69) ($1,252,624.41) $548,817.22 $60,636.30 $612,319.76...
View Full Document

This note was uploaded on 03/28/2011 for the course FINANCE 1 taught by Professor Private during the Spring '09 term at University of San Diego.

Page1 / 5

Practice problems - RENT $270,000.00 $274,050.00...

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

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