Question: Using the information provided below, a one-year proforma in Excel for this property for 2019 (full year). This property is a 15,000 square foot shopping
Using the information provided below, a one-year proforma in Excel for this property for 2019 (full year). This property is a 15,000 square foot shopping center. Consider proper and professional formatting and presentation. a. What is the projected NOI? b. What is the projected cash flow from operations? CAM $2.50 psf Insurance $0.50 psf Landlord Expenses $0.75 psf Tenant Improvements $15,000 total for 2019 Vacancy 5% Miscellaneous Income $6,000 per year Percentage Rent $20,000 per year Roof Replacement $50,000 assume this cost is in 2019 Management Fee 5% (not included in CAM definition under Tenant's leases) Collections 2% Base Rents $25.00 psf for all tenants. No free rent, tenants pay all year Signage Income $3,000 Concessions None NNN Recoveries 100% of recoverable costs Real Estate Taxes $12,000 per year Leasing Commissions $7,000 total cost for 2019 Dues & Subscriptions $1,000 Legal & Accounting $3,000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
