(Solved) : Need Help Rent Roll Excel Regarding Following Project Financials 1 1 Anchor Tenant Paying Q32967177 . . . .

I need help doing a rent roll on excel regarding the followingproject financials:

1. 1 anchor tenant paying $37 per sq ft per year for 150,000 sqft

2. 5 supporting tenants paying $44 per sq ft per year for 18,000sq ft each

3. 10 kiosk tenants paying $56 sq ft per year for 1,000 sq fteach

4. The 1 anchor tenant has a contract that expires12/31/2018

5. The 5 supporting tenants all have contracts expire 2/7/2019,2/7/2020, 2/7/2021, 2/7/2022, and 2/7/2023

6. The 10 kiosk tenant’s contracts are structured so that halfexpire at the end of even years and the other half expire at theend of odd