Starter Spreadsheet Cartwright

Starter Spreadsheet Cartwright - Exhibits ($000) Exhibit 1...

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

View Full Document Right Arrow Icon
Exhibits ($000) Allison Green 900 Stony Walk Ivy Terrace The Fowler Building Garden Apartment Exhibit 1  List of Salient Facts Montgomery Maryland No. of units/Square feet of rental space 100  67,000 Gross Purchase Price $9,600.0  Depreciable Base $7,500.0  Depreciable Life 27.5  Estimate Sales Price $12,500.0  Expected Year of Sale 10  Cash Flow from Operations $870.2  Annual Increase in CFO 3% Leasehold Payments $0.0  Equity Investment $3,600.0  Amount of 1st Mortgage $6,000.0    Interest Rate 6.00%   Term 10    Amortization Period 30    Constant Loan Payments 7.26% 9.08% 7.26% 8.97% Exhibit 2  First Year Project Setups  Allison Green 900 Stony Walk Ivy Terrace The Fowler Building Gross Rents 1,440.0    -Vacancies (72.0) Net Rents 1,368.0    -Real Estate Taxes (172.8)   -Other Operating Expenses (300.0)   -Capital Reserves (25.0) Cash Flow from Operations 870.2    -Finance Payments (435.9)   -Lease Payments 0.0  Before Tax Cash Flow 434.3  Exhibit 3  Purchase and Operating Comparables Allison Green 900 Stony Walk Ivy Terrace The Fowler Building Price/Unit or Price/Rentable SF $96,000  $171.64  Real Estate Taxes/Gross Revenue 12% Other OP Expenses/Unit or /Rentable SF $3,000  $5.50 Other OP Expenses/Gross Revenue 20.8% $4,728  Average Monthly Rents or Rent/SF of Office $1,200  $26.00 Actual or Projected Occupancy 95% R.E. Taxes and Oper. Expense/Unit or/  Rentable SF
Background image of page 1

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

View Full DocumentRight Arrow Icon
Exhibits Exhibit 4  Break-even Analysis Allison Green 900 Stony Walk Ivy Terrace The Fowler Building Current or Projected Occupancy 95% Added margin 30.16% Break-even Occupancy 64.84% Loan to Value 62.50% Debt Coverage Ratio 2.00 
Background image of page 2
Exhibits Exhibit 6  Financial Analysis Allison Green 900 Stony Walk Ivy Terrace The Fowler Building Equity Required $3,600.0  Simple Return Measures Capitalization Rate -- Purchase 9.06%
Background image of page 3

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

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

Page1 / 9

Starter Spreadsheet Cartwright - Exhibits ($000) Exhibit 1...

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

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