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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!