Spreadsheet: 90621d1290406988-distributing-rents-to-calendar-year-leasing
Sheet: Leasing Model - Rental Year

 |  |  |  | Country |  | HBA Version |  | Status Information |  |  |  | Type Information |  |  | Colour Codes |  |  |  |  |  |  |  |  |  | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Opening Date
 |  |  |  | Project Name |  | Start Construction |  | Let |  |  |  | Anchor | > 800 sqm |  | To be filled by: |  |  |  |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2008-06-20 00:00:00
 |  |  |  | Project Number |  | Opening Date | 2008-06-20 00:00:00 | Agreed |  |  |  | MSU | 300-800 sqm |  | Leasing | MAM | MMM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Opening
 |  |  | Open | Report Date |  | Floor Plans |  | LOI |  |  |  | Shops | < 300 sqm |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 |  |  |  |  | 2007-10-30 00:00:00 | 2007-11-30 00:00:00 | 2007-12-30 00:00:00 | 2008-01-30 00:00:00 | 2008-02-29 00:00:00 | 2008-03-30 00:00:00 | 2008-04-30 00:00:00 | 2008-05-30 00:00:00 | 2008-06-30 00:00:00 | 2008-07-30 00:00:00 | 2008-08-30 00:00:00 | 2008-09-30 00:00:00 | 2008-10-30 00:00:00 | 2008-11-30 00:00:00 | 2008-12-30 00:00:00 | 2009-01-30 00:00:00 | 2009-02-28 00:00:00 | 2009-03-30 00:00:00 | 2009-04-30 00:00:00 | 2009-05-30 00:00:00 | 2009-06-30 00:00:00 | 2009-07-30 00:00:00 | 2009-08-30 00:00:00 | 2009-09-30 00:00:00 | 2009-10-30 00:00:00 | 2009-11-30 00:00:00 | 2009-12-30 00:00:00 | 2010-01-30 00:00:00 | 2010-02-28 00:00:00
 |  |  | Closed |  |  |  |  | Vacant or Reserved |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28
 |  |  |  | 3 | 4 |  |  |  |  |  |  | 5 |  | 6 | 7 |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  | 9 |  |  |  | 8 |  |  | 9 |  |  |  | 8 |  |  | 9 |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  | 11 |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3
 |  | Unit #: | Tenant Information |  |  |  |  |  |  |  |  |  |  |  |  | HBA |  |  |  |  | Bluebook |  |  |  |  |  | 1st Rental Year |  |  |  |  |  |  | 2nd Rental Year |  |  |  |  |  |  | 3rd Rental Year |  |  |  |  |  |  | % of HBA |  |  | Tenant Incentives |  |  |  |  |  |  |  |  |  |  |  | Caps on Recoverable Costs |  | Yield % | Investment Value
 |  |  | Physical Status | [NAME] | [NAME] | Tenant | Type | Sqm | Rent Start Date | Contract Finish Date | Term Years | 2nd Year Indexation Forecast | 3rd Year Indexation Forecast | Bank Guarantee | Approved by MAM | Sqm | Rent / Sqm / Month | Rent / Month | Rent / Sqm / Year | Annual Rent | % of HBA | Sqm | Rent / Sqm / Month | Rent / Month | Rent / Sqm / Year | Annual Rent | Annual Turnover Forecast | Turnover % | Annual Turnover Rent Forecast | Rent / Sqm / Month | Rent / Month | Rent / Sqm / Year | Annual Rent | Annual Turnover Forecast | Turnover % | Annual Turnover Rent Forecast | Rent / Sqm / Month | Rent / Month | Rent / Sqm / Year | Annual Rent | Annual Turnover Forecast | Turnover % | Annual Turnover Rent Forecast | Rent / Sqm / Month | Rent / Month | Rent / Sqm / Year | Annual Rent | 1st Rental Year | 2nd Rental Year | 3rd Rental Year | Rent Discounts |  |  |  | Under Development |  |  | Under Exploitation |  |  |  | Total Tenant Incentives | Service Charges | Marketing Charges |  | HBA | 1st Rental Year | 2nd Rental Year | 3rd Rental Year |  |  |  |  | Rent | Discounts |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Step Up Dates |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st Year | 2nd Year | 3rd Year | Total | Rent Free Period | Cash Contributions | Total: | Rent Free Period | Cash Contributions | Marketing Contributions | Total |  | € [NAME] / Sqm | € [NAME] / Sqm |  |  |  |  |  | Remarks: |  |  |  | 2008-05-15 00:00:00 | 2008-06-15 00:00:00 | 2008-07-15 00:00:00 | 2008-08-15 00:00:00 | 2008-09-15 00:00:00 | 2008-10-15 00:00:00 | 2008-11-15 00:00:00 | 2008-12-15 00:00:00 | 2009-01-15 00:00:00 | 2009-02-15 00:00:00 | 2009-03-15 00:00:00 | 2009-04-15 00:00:00 | 2009-05-15 00:00:00 | 2009-06-15 00:00:00 | 2009-07-15 00:00:00 | 2009-08-15 00:00:00 | 2009-09-15 00:00:00 | 2009-10-15 00:00:00 | 2009-11-15 00:00:00 | 2009-12-15 00:00:00 | 2010-01-15 00:00:00 | 2010-02-15 00:00:00 | 2010-03-15 00:00:00 | 2010-04-15 00:00:00 | 2010-05-15 00:00:00 | 2010-06-15 00:00:00 | 2010-07-15 00:00:00 | 2010-08-15 00:00:00 | 2010-09-15 00:00:00 |  | 1st Year | 2nd Year | 3rd Year | 2008-05-15 00:00:00 | 2008-06-15 00:00:00 | 2008-07-15 00:00:00 | 2008-08-15 00:00:00 | 2008-09-15 00:00:00 | 2008-10-15 00:00:00 | 2008-11-15 00:00:00 | 2008-12-15 00:00:00 | 2009-01-15 00:00:00 | 2009-02-15 00:00:00 | 2009-03-15 00:00:00 | 2009-04-15 00:00:00 | 2009-05-15 00:00:00 | 2009-06-15 00:00:00 | 2009-07-15 00:00:00 | 2009-08-15 00:00:00 | 2009-09-15 00:00:00 | 2009-10-15 00:00:00 | 2009-11-15 00:00:00 | 2009-12-15 00:00:00 | 2010-01-15 00:00:00 | 2010-02-15 00:00:00 | 2010-03-15 00:00:00 | 2010-04-15 00:00:00 | 2010-05-15 00:00:00 | 2010-06-15 00:00:00 | 2010-07-15 00:00:00 | 2010-08-15 00:00:00 | 2010-09-15 00:00:00 |  | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00
 |  | B1-49 | Open | Let | Other | A | Shop | 100 | 2008-06-20 00:00:00 | 2014-06-19 00:00:00 | 6 |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  | 0 |  |  |  |  | 0 | 5 | 500 | 60 | 6000 |  |  | 0 | 10 | 1000 | 120 | 12000 |  |  | 0 | 15 | 1500 | 180 | 18000 |  |  |  | 12000 | 6000 | 0 | 18000 |  |  | 18000 |  |  |  | 0 | 18000 |  |  | #N/A |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 8585 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2008-06-20 00:00:00 | 2009-06-20 00:00:00 | 2010-06-20 00:00:00 |  | 0 | 0 | 0 | 0 | 8585 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 683.3333333333334 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1183.333333333333 | 1500 | 1500 | 1500 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | B1-50 | Open | Let | Accessoires | B | Shop | 100 | 2008-03-12 00:00:00 | 2019-06-12 00:00:00 | 11 |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 100000 | 0.1 | 10000 |  | 0 | 0 | 10000 |  |  | 0 | 10 | 1000 | 120 | 12000 |  |  |  | 12000 | 2000 | 0 | 14000 |  |  | 14000 |  |  |  | 0 | 14000 |  |  | #N/A |  |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2008-03-12 00:00:00 | 2009-03-12 00:00:00 | 2010-03-12 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 833.3333333333334 | 833.3333333333334 | 833.3333333333334 | 833.3333333333334 | 833.3333333333334 | 833.3333333333334 | 833.3333333333334 | 833.3333333333334 | 833.3333333333334 | 833.3333333333334 | 833.3333333333334 | 833.3333333333334 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | B1-51 | Open | Let | Household Goods | C | Shop | 100 | 2008-06-20 00:00:00 | 2019-06-12 00:00:00 | 11 |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 10 | 1000 | 120 | 12000 |  |  |  | 12000 | 12000 | 0 | 24000 |  |  | 24000 |  |  |  | 0 | 24000 |  |  | #N/A |  |  |  |  |  |  |  |  |  | #N/A |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2008-06-20 00:00:00 | 2009-06-20 00:00:00 | 2010-06-20 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1000 | 1000 | 1000 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | B1-52 | Open | Let | Household Goods | D | Shop | 100 | 2009-06-12 00:00:00 | 2015-06-12 00:00:00 | 6 |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  | 0 |  |  |  |  | 0 | 6 | 600 | 72 | 7200 |  |  | 0 | 9 | 900 | 108 | 10800 |  |  | 0 | 10 | 1000 | 120 | 12000 |  |  |  | 4800 | 1200 | 0 | 6000 |  |  | 6000 |  |  |  | 0 | 6000 |  |  | #N/A |  |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-06-12 00:00:00 | 2010-06-12 00:00:00 | 2011-06-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 790 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 900 | 900 | 900 | 900 |  | -1000 | -1000 | -1000 | -1000 | -1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Tenant |  |  |  |  |  | Problem
 |  | A | 3 years step (escalating) rents |  |  |  |  | None
 |  | B | 1st year rent free, 2nd year turnover based base rent, 3rd year fix rent |  |  |  |  | [NAME] is rent free for 11 days but calculation shows 8333 which is the full month rent. Similar problem for Mar-10.
 |  | C | First 2 years rent free, 3rd year fixed rent |  |  |  |  | Jun-10 Does not show 10 days of invoicing
 |  | D | 3 years step (escalating) rents |  |  |  |  | Jun-09 Shows over-invoicing
 |  | Calendar Year Cashflow starts at column DL
 |  |  |  | Accessoires | Storage
 |  |  |  | Fashion | Kiosk
 |  |  |  | Food | [NAME]
 |  |  |  | Household Goods | Seating Area
 |  |  |  | Leisure | ATM
 |  |  |  | Miscellaneous | Stand
 |  |  |  | Services | Other
 |  |  |  | Others