MarketRent/Yrpersft,4decimalplacesYear Oper Expen/Yr per sft,4 decimal places Tenant 1 (Exisiting Lease) Rentable Space, sft Base Rent, sft, 4 decimal places Tenant CPI Adjusted Rent , sft, 4 decimal places Tenant Rent Tenant 2 (New Lease Signed at BOY1) Rentable Space, Sft Base Rent, sft, 4 decimal places Tenant CPI Adjusted Rent, sft, 4 decimal places Tenant Rent Total Rent PROJECTED INCOME Year Expense Stop, Tenant 1 Expense Stop, Tenant 2 Tenant 1 Expense Reimbursement Tenant 2 Expense Reimbursement Total Reimbursements Potential Gross Income Vacancy Effective Gross Income SUMMARY OF OPERATING EXPENSES Operating Expendtiure Management Fee Total Expenditure PROJECTED NET OPERATING INCOME Year Effective Gross Income Total Expenditure NOI Given DCR and NOI1, Calculation of Mortgage Loan and Future Loan Balances NOI1 DCR DS, Annual DS, Monthly Year PMT (=DS, Monthly, given DCR and NOI1) Mortgage Rate, Per Month, in decimal Amortization Period, Years FV