this is part 1. please help me with this. all should be done in excel.

Part One Directions Complete pro forma for NOI Commercial Complex 4 tenants Property will be held for 5 years Tenant Lease Type Size Current Lease Rate Rent Growth CAM Bank NNN Outparcel $85.250/y 2.15% $4.50/ sq ft Retailer Retailer percentage Percentage 3.125 Plus 4.55% Venue Tenant revenue is Limited to expected to $2.75 per sa grow at 2.5% foot per year Pro rata on Year 1 Revenues are $310.000 sq feet Office 9.600 $21.00/sqft CPI Nane Limited to $5.25 per sa foot Office 4375 $22.50/sqft CPI Pro rata on sq feet OP EX Category Cost Growth Rate Untities $3.25 per sqft 2.85% per year Taxes $11.627 pery 2.75% per year Insurance $2.75 per sqft 20% per year Maintenance $3.15 person 3.15$ per year CPI Rate Years 1-3 1.75 Years 4-7 2.25 Years 8-10 325 Make sure to show your work in the uploaded Excel file (be sure to show cash flows through BTCF). Part One Directions Complete pro forma for NOI Commercial Complex 4 tenants Property will be held for 5 years Tenant Lease Type Size Current Lease Rate Rent Growth CAM Bank NNN Outparcel $85.250/y 2.15% $4.50/ sq ft Retailer Retailer percentage Percentage 3.125 Plus 4.55% Venue Tenant revenue is Limited to expected to $2.75 per sa grow at 2.5% foot per year Pro rata on Year 1 Revenues are $310.000 sq feet Office 9.600 $21.00/sqft CPI Nane Limited to $5.25 per sa foot Office 4375 $22.50/sqft CPI Pro rata on sq feet OP EX Category Cost Growth Rate Untities $3.25 per sqft 2.85% per year Taxes $11.627 pery 2.75% per year Insurance $2.75 per sqft 20% per year Maintenance $3.15 person 3.15$ per year CPI Rate Years 1-3 1.75 Years 4-7 2.25 Years 8-10 325 Make sure to show your work in the uploaded Excel file (be sure to show cash flows through BTCF)