Creating a template for your spreadsheet is the first step in order to accommodate the information and calculations you need. Excel, Google Sheets, or any other software that allows you to work with data and formulas can be used. Generally, a template will include sections such as lease details, cash flow analysis, operating expense analysis, tenant improvement analysis, and a summary and comparison. In the lease details section, you will need to enter basic information such as the property name, address, unit number, square footage, lease term, rent per square foot, rent escalation, security deposit, and other relevant data. The cash flow analysis should include calculating the monthly and annual rent payments for each lease proposal by taking into account rent escalation, free rent periods, and rent abatements or discounts. You can use the PMT function to calculate the monthly rent and the NPV and IRR functions to calculate the net present value and internal rate of return of each lease proposal. For the operating expense analysis section, compare different operating expense structures such as gross, net, or modified gross leases. Enter base year operating expenses, operating expense escalation, and operating expense reimbursement method for each lease proposal. Utilize SUMIF and SUMPRODUCT functions to calculate total operating expenses and tenant's share of operating expenses for each year of the lease term. The tenant improvement analysis should evaluate tenant improvement allowance and amortization for each lease proposal. Enter amount of tenant improvement allowance per square foot, interest rate, and amortization period for each lease proposal. Use PMT function to calculate monthly amortization payment and PV function to calculate present value of tenant improvement allowance. Lastly in the summary and comparison section summarize and compare key metrics and indicators for each lease proposal such as effective rent per square foot, total rent over the lease term, net present value of cash flow, internal rate of return, total operating expenses, total tenant improvement costs, etc. To highlight best and worst values for each metric use MIN MAX AVERAGE RANK functions.