Spreadsheet: 162235d1339772273-excel-2007-formula-issue-occupancy-schedule-budget-template-excel-formula-question
Sheet: 2012 Renewals

 |  |  |  |  | 2012 Renewals
 |  |  |  |  | Renewal Calculation |  | Property
 |  |  |  |  | Enter information in the cells colored |  |  | Yellow |  |  |  |  |  |  |  |  | Rent Start Date | Yr 2 Bump Date
 |  |  |  |  | Do NOT enter any information in the cells colored |  |  | Gray
 |  |  |  |  | Lease Signature Date |  |  | 2013-01-01 00:00:00
 | Suite Helper | [NAME] | Yr 1 Rent Helper | Yr 2 Rent Helper | Lease Commencement Date
 |  |  |  |  | Suite |  | Description |  | Renewal |  |  | Costs
 |  |  |  |  |  | SF |  |  |  | Commission % | 0.06
 |  |  |  |  | Mo Rate PSF | Year | An Rate PSF | Annual Rent | Mo Rent | T/I $ PSF | 6
 |  |  |  |  |  | 1 | 22 |  |  | Total TILC
 |  |  |  |  |  |  | 22.5 |  |  | Space Plan PSF | 0
 |  |  |  |  |  |  | 23 |  |  | Total Legal | [NAME] | 0
 |  |  |  |  |  |  |  |  |  | Const Mgnt Fee | 0.05
 |  |  |  |  |  |  | Total Rent |  |  | Total Deal Cost
 |  |  |  |  |  | Free Rent |  | months free rent |  | Total Deal Cost PSF
 |  |  |  |  | Lease Signature Date |  |  | 2013-01-01 00:00:00
 |  |  |  |  | Lease Commencement Date
 |  |  |  |  | Suite |  | Description |  | Renewal |  |  | Costs
 |  |  |  |  |  | SF |  |  |  | Commission % | 0.06
 |  |  |  |  | Mo Rate PSF | Year | An Rate PSF | Annual Rent | Mo Rent | T/I $ PSF | 6
 |  |  |  |  |  | 1 | 22 |  |  | Total TILC
 |  |  |  |  |  |  | 22.5 |  |  | Space Plan PSF | 0
 |  |  |  |  |  |  | 23 |  |  | Total Legal | [NAME] | 0
 |  |  |  |  |  |  |  |  |  | Const Mgnt Fee | 0.05
 |  |  |  |  |  |  | Total Rent |  |  | Total Deal Cost
 |  |  |  |  |  | Free Rent |  | months free rent |  | Total Deal Cost PSF
 |  |  |  |  | Lease Signature Date |  |  | 2013-01-01 00:00:00
 |  |  |  |  | Lease Commencement Date
 |  |  |  |  | Suite |  | Description |  | Renewal |  |  | Costs
 |  |  |  |  |  | SF |  |  |  | Commission %
 |  |  |  |  | Mo Rate PSF | Year | An Rate PSF | Annual Rent | Mo Rent | T/I $ PSF
 |  |  |  |  |  | 1 | 22 |  |  | Total TILC
 |  |  |  |  |  |  | 22.5 |  |  | Space Plan PSF | 0
 |  |  |  |  |  |  | 23 |  |  | Total Legal | [NAME] | 0
 |  |  |  |  |  |  |  |  |  | Const Mgnt Fee | 0.05
 |  |  |  |  |  |  | Total Rent |  |  | Total Deal Cost
 |  |  |  |  |  | Free Rent |  | months free rent |  | Total Deal Cost PSF
 |  |  |  |  | Lease Signature Date |  |  | 2013-01-01 00:00:00
 |  |  |  |  | Lease Commencement Date
 |  |  |  |  | Suite |  | Description |  | Renewal |  |  | Costs
 |  |  |  |  |  | SF |  |  |  | Commission %
 |  |  |  |  | Mo Rate PSF | Year | An Rate PSF | Annual Rent | Mo Rent | T/I $ PSF
 |  |  |  |  |  | 1 |  |  |  | Total TILC
 |  |  |  |  |  |  |  |  |  | Space Plan PSF | 0
 |  |  |  |  |  |  |  |  |  | Total Legal | [NAME] | 0
 |  |  |  |  |  |  |  |  |  | Const Mgnt Fee | 0.05
 |  |  |  |  |  |  | Total Rent |  |  | Total Deal Cost
 |  |  |  |  |  | Free Rent |  | months free rent |  | Total Deal Cost PSF
 |  |  |  |  | Lease Signature Date |  |  | 2013-01-01 00:00:00
 |  |  |  |  | Lease Commencement Date
 |  |  |  |  | Suite |  | Description |  | Renewal |  |  | Costs
 |  |  |  |  |  | SF |  |  |  | Commission %
 |  |  |  |  | Mo Rate PSF | Year | An Rate PSF | Annual Rent | Mo Rent | T/I $ PSF
 |  |  |  |  |  | 1 |  |  |  | Total TILC
 |  |  |  |  |  |  |  |  |  | Space Plan PSF | 0
 |  |  |  |  |  |  |  |  |  | Total Legal | [NAME] | 0
 |  |  |  |  |  |  |  |  |  | Const Mgnt Fee | 0.05
 |  |  |  |  |  |  | Total Rent |  |  | Total Deal Cost
 |  |  |  |  |  | Free Rent |  | months free rent |  | Total Deal Cost PSF
 |  |  |  |  | Lease Signature Date |  |  | 2013-01-01 00:00:00
 |  |  |  |  | Lease Commencement Date
 |  |  |  |  | Suite |  | Description |  | Renewal |  |  | Costs
 |  |  |  |  |  | SF |  |  |  | Commission %
 |  |  |  |  | Mo Rate PSF | Year | An Rate PSF | Annual Rent | Mo Rent | T/I $ PSF
 |  |  |  |  |  | 1 |  |  |  | Total TILC
 |  |  |  |  |  |  |  |  |  | Space Plan PSF | 0
 |  |  |  |  |  |  |  |  |  | Total Legal | [NAME] | 0
 |  |  |  |  |  |  |  |  |  | Const Mgnt Fee | 0.05
 |  |  |  |  |  |  | Total Rent |  |  | Total Deal Cost
 |  |  |  |  |  | Free Rent |  | months free rent |  | Total Deal Cost PSF
 |  |  |  |  | Lease Signature Date |  |  | 2013-01-01 00:00:00
 |  |  |  |  | Lease Commencement Date
 |  |  |  |  | Suite |  | Description |  | Renewal |  |  | Costs
 |  |  |  |  |  | SF |  |  |  | Commission %
 |  |  |  |  | Mo Rate PSF | Year | An Rate PSF | Annual Rent | Mo Rent | T/I $ PSF
 |  |  |  |  |  | 1 |  |  |  | Total TILC
 |  |  |  |  |  |  |  |  |  | Space Plan PSF | 0
 |  |  |  |  |  |  |  |  |  | Total Legal | [NAME] | 0
 |  |  |  |  |  |  |  |  |  | Const Mgnt Fee | 0.05
 |  |  |  |  |  |  | Total Rent |  |  | Total Deal Cost
 |  |  |  |  |  | Free Rent |  | months free rent |  | Total Deal Cost PSF
 |  |  |  |  | Lease Signature Date |  |  | 2013-01-01 00:00:00
 |  |  |  |  | Lease Commencement Date
 |  |  |  |  | Suite |  | Description |  | Renewal |  |  | Costs
 |  |  |  |  |  | SF |  |  |  | Commission %
 |  |  |  |  | Mo Rate PSF | Year | An Rate PSF | Annual Rent | Mo Rent | T/I $ PSF
 |  |  |  |  |  | 1 |  |  |  | Total TILC
 |  |  |  |  |  |  |  |  |  | Space Plan PSF | 0
 |  |  |  |  |  |  |  |  |  | Total Legal | [NAME] | 0
 |  |  |  |  |  |  |  |  |  | Const Mgnt Fee | 0.05
 |  |  |  |  |  |  | Total Rent |  |  | Total Deal Cost
 |  |  |  |  |  | Free Rent |  | months free rent |  | Total Deal Cost PSF
 |  |  |  |  | Lease Signature Date |  |  | 2013-01-01 00:00:00
 |  |  |  |  | Lease Commencement Date
 |  |  |  |  | Suite |  | Description |  | Renewal |  |  | Costs
 |  |  |  |  |  | SF |  |  |  | Commission %
 |  |  |  |  | Mo Rate PSF | Year | An Rate PSF | Annual Rent | Mo Rent | T/I $ PSF
 |  |  |  |  |  | 1 |  |  |  | Total TILC
 |  |  |  |  |  |  |  |  |  | Space Plan PSF | 0
 |  |  |  |  |  |  |  |  |  | Total Legal | [NAME] | 0
 |  |  |  |  |  |  |  |  |  | Const Mgnt Fee | 0.05
 |  |  |  |  |  |  | Total Rent |  |  | Total Deal Cost
 |  |  |  |  |  | Free Rent |  | months free rent |  | Total Deal Cost PSF
 |  |  |  |  | Lease Signature Date |  |  | 2013-01-01 00:00:00
 |  |  |  |  | Lease Commencement Date
 |  |  |  |  | Suite |  | Description |  | Renewal |  |  | Costs
 |  |  |  |  |  | SF |  |  |  | Commission %
 |  |  |  |  | Mo Rate PSF | Year | An Rate PSF | Annual Rent | Mo Rent | T/I $ PSF
 |  |  |  |  |  | 1 |  |  |  | Total TILC
 |  |  |  |  |  |  |  |  |  | Space Plan PSF | 0
 |  |  |  |  |  |  |  |  |  | Total Legal | [NAME] | 0
 |  |  |  |  |  |  |  |  |  | Const Mgnt Fee | 0.05
 |  |  |  |  |  |  | Total Rent |  |  | Total Deal Cost
 |  |  |  |  |  | Free Rent |  | months free rent |  | Total Deal Cost PSF
 |  |  |  |  | Lease Signature Date |  |  | 2013-01-01 00:00:00
 |  |  |  |  | Lease Commencement Date
 |  |  |  |  | Suite |  | Description |  | Renewal |  |  | Costs
 |  |  |  |  |  | SF |  |  |  | Commission %
 |  |  |  |  | Mo Rate PSF | Year | An Rate PSF | Annual Rent | Mo Rent | T/I $ PSF
 |  |  |  |  |  | 1 |  |  |  | Total TILC
 |  |  |  |  |  |  |  |  |  | Space Plan PSF | 0
 |  |  |  |  |  |  |  |  |  | Total Legal | [NAME] | 0
 |  |  |  |  |  |  |  |  |  | Const Mgnt Fee | 0.05
 |  |  |  |  |  |  | Total Rent |  |  | Total Deal Cost
 |  |  |  |  |  | Free Rent |  | months free rent |  | Total Deal Cost PSF
 |  |  |  |  | Lease Signature Date |  |  | 2013-01-01 00:00:00
 |  |  |  |  | Lease Commencement Date
 |  |  |  |  | Suite |  | Description |  | Renewal |  |  | Costs
 |  |  |  |  |  | SF |  |  |  | Commission %
 |  |  |  |  | Mo Rate PSF | Year | An Rate PSF | Annual Rent | Mo Rent | T/I $ PSF
 |  |  |  |  |  | 1 |  |  |  | Total TILC
 |  |  |  |  |  |  |  |  |  | Space Plan PSF | 0
 |  |  |  |  |  |  |  |  |  | Total Legal | [NAME] | 0
 |  |  |  |  |  |  |  |  |  | Const Mgnt Fee | 0.05
 |  |  |  |  |  |  | Total Rent |  |  | Total Deal Cost
 |  |  |  |  |  | Free Rent |  | months free rent |  | Total Deal Cost PSF
 |  |  |  |  | Lease Signature Date |  |  | 2013-01-01 00:00:00
 |  |  |  |  | Lease Commencement Date
 |  |  |  |  | Suite |  | Description |  | Renewal |  |  | Costs
 |  |  |  |  |  | SF |  |  |  | Commission %
 |  |  |  |  | Mo Rate PSF | Year | An Rate PSF | Annual Rent | Mo Rent | T/I $ PSF
 |  |  |  |  |  | 1 |  |  |  | Total TILC
 |  |  |  |  |  |  |  |  |  | Space Plan PSF | 0
 |  |  |  |  |  |  |  |  |  | Total Legal | [NAME] | 0
 |  |  |  |  |  |  |  |  |  | Const Mgnt Fee | 0.05
 |  |  |  |  |  |  | Total Rent |  |  | Total Deal Cost
 |  |  |  |  |  | Free Rent |  | months free rent |  | Total Deal Cost PSF
 |  |  |  |  | Lease Signature Date |  |  | 2013-01-01 00:00:00
 |  |  |  |  | Lease Commencement Date
 |  |  |  |  | Suite |  | Description |  | Renewal |  |  | Costs
 |  |  |  |  |  | SF |  |  |  | Commission %
 |  |  |  |  | Mo Rate PSF | Year | An Rate PSF | Annual Rent | Mo Rent | T/I $ PSF
 |  |  |  |  |  | 1 |  |  |  | Total TILC
 |  |  |  |  |  |  |  |  |  | Space Plan PSF | 0
 |  |  |  |  |  |  |  |  |  | Total Legal | [NAME] | 0
 |  |  |  |  |  |  |  |  |  | Const Mgnt Fee | 0.05
 |  |  |  |  |  |  | Total Rent |  |  | Total Deal Cost
 |  |  |  |  |  | Free Rent |  | months free rent |  | Total Deal Cost PSF
 |  |  |  |  | Lease Signature Date |  |  | 2013-01-01 00:00:00
 |  |  |  |  | Lease Commencement Date
 |  |  |  |  | Suite |  | Description |  | Renewal |  |  | Costs
 |  |  |  |  |  | SF |  |  |  | Commission %
 |  |  |  |  | Mo Rate PSF | Year | An Rate PSF | Annual Rent | Mo Rent | T/I $ PSF
 |  |  |  |  |  | 1 |  |  |  | Total TILC
 |  |  |  |  |  |  |  |  |  | Space Plan PSF | 0
 |  |  |  |  |  |  |  |  |  | Total Legal | [NAME] | 0
 |  |  |  |  |  |  |  |  |  | Const Mgnt Fee | 0.05
 |  |  |  |  |  |  | Total Rent |  |  | Total Deal Cost
 |  |  |  |  |  | Free Rent |  | months free rent |  | Total Deal Cost PSF