please help on this with excel i dont know how to solve for noi and btcf

Complete pro forma for NOI and BTCF Commercial Complex 4 tenants Property will be held for 5 years Tenant Lease Type Size Current Lease Rate Rent Growth Bank NNN Outparcel $75,000/yr 1.75% Retailer Percentage 4,200 Tenant revenue is expected $4.25 sq ft to grow at 3.35% Plus 5% per year revenue Year 1 Revenues are $350,000 Office 3,000 $18 sq ft CPI Office 3,800 $16 | OP EX Category Cost Growth Rate Utilities $1.20 per sq ft 2.4% per year Taxes $9,500 per year 2.5% per year Insurance $0.50 per sq ft 1.5% per year Maintenance $0.85 per sqft 3.0% per year CPI Rate Years 1-3 2.1% Years 4-7 2.8% Years 8-10 3.1% Part Two Questions: 1. Calculate The Max Debt for this property. 2. Calculate the amount of equity needed for this property 3. Calculation the Net Sale Proceeds to Owner. Going in Cap Rate 6.25% Terminal Cap Rate 6.15% Loan Interest Rate 4.45% Max loan to value for debt 60% Required Debt Service Coverage 1.40 Discount Rate 11% Loan Term 20 years Loan Fees 2.2% Can you teach me how to do this on excel? Complete pro forma for NOI and BTCF Commercial Complex 4 tenants Property will be held for 5 years Tenant Lease Type Size Current Lease Rate Rent Growth Bank NNN Outparcel $75,000/yr 1.75% Retailer Percentage 4,200 Tenant revenue is expected $4.25 sq ft to grow at 3.35% Plus 5% per year revenue Year 1 Revenues are $350,000 Office 3,000 $18 sq ft CPI Office 3,800 $16 | OP EX Category Cost Growth Rate Utilities $1.20 per sq ft 2.4% per year Taxes $9,500 per year 2.5% per year Insurance $0.50 per sq ft 1.5% per year Maintenance $0.85 per sqft 3.0% per year CPI Rate Years 1-3 2.1% Years 4-7 2.8% Years 8-10 3.1% Part Two Questions: 1. Calculate The Max Debt for this property. 2. Calculate the amount of equity needed for this property 3. Calculation the Net Sale Proceeds to Owner. Going in Cap Rate 6.25% Terminal Cap Rate 6.15% Loan Interest Rate 4.45% Max loan to value for debt 60% Required Debt Service Coverage 1.40 Discount Rate 11% Loan Term 20 years Loan Fees 2.2% Can you teach me how to do this on excel