- for planning only: these wireframes not approved
Operations Page Flow v3
Skye Sant, User Experience Strategy 11 August 2014
Operations Dashboard: Main Page, 8 KPIs Main Page > Real Estate > Operations Dashboard Populate my dashboard with
Global
and/or
[Ownership]
data, grouped by
Division
, in
$ dollars
and
sqft
,where applicable.
Operations QTD latest - Global by Division NOI (Cash w/ Topside) Geography Americas Asia Europe TOTAL
Actuals $ millions
SS NOI Growth (Cash w/ topside)
Cash w/ Top.. Budget $ millions
Forecast $ millions
$343.1 $343.1 $343.1 56.8 56.8 56.8 203.1 203.1 203.1 $1,001.0 $1,001.0 $1,001.0
Average Occupancy (Include Topside)
Cash w/ Top..
Geography
Actuals
Budget
Forecast
Americas Asia Europe TOTAL
6.0% 4.5% -0.1% 5.0%
6.0% 4.5% -0.1% 5.0%
6.0% 4.5% -0.1% 5.0%
Period End Occupancy (Include Topside)
w/ Topside
Geography
Actuals
Budget
Forecast
Geography
Actuals
Budget
Forecast
Americas Asia Europe TOTAL
68.6% 88.3% 88.7% 85.0%
68.6% 88.3% 88.7% 85.0%
68.6% 88.3% 88.7% 85.0%
Americas Asia Europe TOTAL
68.5% 88.9% 88.2% 85.1%
68.5% 88.9% 88.2% 85.1%
68.5% 88.9% 88.2% 85.1%
Rent Change
Retention Geography
Actuals
Budget
Forecast
Geography
Actuals
Budget
Forecast
Americas Asia Europe TOTAL
68.4% 48.2% 58.9% 55.2%
68.4% 48.2% 58.9% 55.2%
68.4% 48.2% 58.9% 55.2%
Americas Asia Europe TOTAL
-10.5% -2.0% 15.3% 7.6%
-10.5% -2.0% 15.3% 7.6%
-10.5% -2.0% 15.3% 7.6%
Actuals
Budget
Forecast
$76.1 40.6 50.9 $166.5
$76.1 40.6 50.9 $166.5
$76.1 40.6 50.9 $166.5
Turnover Costs/Area Geography Americas Asia Europe TOTAL
w/ Topside
Property Improvements
Actuals
Budget
1.80 0.55 1.50 0.40
1.80 0.55 1.50 0.40
$/sqft
$/sqft
Forecast
Geography
$/sqft
1.80 0.55 1.50 0.40
Americas Asia Europe TOTAL
$ millions
$ millions
$ millions
Similar graphs are linked and the dropdown value will change them together
2
Skye Sant
11 August 2014
Operations Dashboard Main Page > Real Estate > Operations Dashboard Populate my dashboard with
Global
and/or
[Ownership]
data, grouped by
Division
, in
$ dollars
and
sqft
,where applicable.
Operations QTD latest - Global by Division NOI (Cash w/ Topside) Geography Americas Asia Europe TOTAL
Actuals $ millions
SS NOI Growth (Cash w/ topside)
Cash w/ Top.. Budget $ millions
Forecast $ millions
$343.1 $343.1 $343.1 56.8 56.8 56.8 203.1 203.1 203.1 $1,001.0 $1,001.0 $1,001.0
Average Occupancy (Include Topside)
Cash w/ Top..
Geography
Actuals
Budget
Forecast
Americas Asia Europe TOTAL
6.0% 4.5% -0.1% 5.0%
6.0% 4.5% -0.1% 5.0%
6.0% 4.5% -0.1% 5.0%
Period End Occupancy (Include Topside)
w/ Topside
Geography
Actuals
Budget
Forecast
Geography
Actuals
Budget
Forecast
Americas Asia Europe TOTAL
68.6% 88.3% 88.7% 85.0%
68.6% 88.3% 88.7% 85.0%
68.6% 88.3% 88.7% 85.0%
Americas Asia Europe TOTAL
68.5% 88.9% 88.2% 85.1%
68.5% 88.9% 88.2% 85.1%
68.5% 88.9% 88.2% 85.1%
Rent Change
Retention Geography
Actuals
Budget
Forecast
Geography
Actuals
Budget
Forecast
Americas Asia Europe TOTAL
68.4% 48.2% 58.9% 55.2%
68.4% 48.2% 58.9% 55.2%
68.4% 48.2% 58.9% 55.2%
Americas Asia Europe TOTAL
-10.5% -2.0% 15.3% 7.6%
-10.5% -2.0% 15.3% 7.6%
-10.5% -2.0% 15.3% 7.6%
Actuals
Budget
Forecast
$76.1 40.6 50.9 $166.5
$76.1 40.6 50.9 $166.5
$76.1 40.6 50.9 $166.5
Turnover Costs/Area Geography Americas Asia Europe TOTAL
w/ Topside
Property Improvements
Actuals
Budget
1.80 0.55 1.50 0.40
1.80 0.55 1.50 0.40
$/sqft
$/sqft
Forecast
Geography
$/sqft
1.80 0.55 1.50 0.40
Americas Asia Europe TOTAL
$ millions
$ millions
$ millions
Similar graphs are linked and the dropdown value will change them together
3
Skye Sant
11 August 2014
Forecast is the lightest Budget is the medium Actual is the dark
NOI - Global
Forecast is the lightest Budget is the medium Actual is the dark
Main Page > Real Estate > Operations Dashboard > NOI - Global (cash) and/or [Ownership]
Populate my dashboard with Global
, in $ dollars
data, grouped by Division
sqft
and
,where applicable.
NOI QTD-latest - Global (Cash) NOI Projection 12 Quarters - Global (Cash)
Cash
in 000,000’s
500 375 250 125 0
Actual/Forecast Budget | Q4
| Q12013
NOI QTD latest - Global (Cash) $ millions 500 400 300 200 100 0
|
|
Q2
Q3
|
|
Q4
Q12014
500
Total
400
600
0
|
Q2
Q3
12 Quarters
Total
Forecast Budget Actual
100 0 Asia
Europe
NOI YTD latest - Division (Cash)
1,075.2
1200
Total
800
$ millions
1,075.2
1000
Total
600
Forecast Budget Actual
400 200 0
Global
America
Top X Positive NOI Drivers QTD -Global (Cash)
Asia
Property Code
Property Name
Forecast NOI
Variance
atl00101 atl00101 atl00101 atl00101
Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
$850,000 $850,000 $850,000 $850,000
Actual NOI
$ millions
Top X Negative NOI Drivers QTD - Asia (Cash) Property Code atl00101 atl00101 atl00101 atl00101
|
345.5
200
Forecast Budget Actual
300
| Q12015
$ millions
America
NOI YTD latest - Global (Cash)
| Q4
300
Global
$ millions
| Q3
NOI QTD latest - Division (Cash)
345.5 Forecast Budget Actual
1200
| Q2
Forecast NOI Actual NOI Property Name Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
4
Europe
Variance $850,000 $850,000 $850,000 $850,000
Skye Sant
11 August 2014
Forecast is the lightest Budget is the medium Actual is the dark
NOI - Global: Dropdown
Forecast is the lightest Budget is the medium Actual is the dark
Main Page > Real Estate > Operations Dashboard > NOI - Global (cash) and/or [Ownership]
Populate my dashboard with Global
, in $ dollars
data, grouped by Division
sqft
and
,where applicable.
NOI QTD-latest - Global (Cash) NOI Projection 12 Quarters - Global (Cash)
Cash Cash Cash w/ Topside GAAP Actual/Forecast GAAP w/ Topside Budget
in 000,000’s
500 375 250 125 0
| Q4
| Q12013
NOI QTD latest - Global (Cash) $ millions 500 400 300 200 100 0
|
|
Q2
Q3
|
|
Q4
Q12014
500
Total
400
600
0
|
Q2
Q3
12 Quarters
Total
Forecast Budget Actual
100 0 Asia
Europe
NOI YTD latest - Division (Cash)
1,075.2
1200
Total
800
$ millions
1,075.2
1000
Total
600
Forecast Budget Actual
400 200 0
Global
America
Top X Positive NOI Drivers QTD -Global (Cash)
Asia
Property Code
Property Name
Forecast NOI
Variance
atl00101 atl00101 atl00101 atl00101
Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
$850,000 $850,000 $850,000 $850,000
Actual NOI
$ millions
Top X Negative NOI Drivers QTD - Asia (Cash) Property Code atl00101 atl00101 atl00101 atl00101
|
345.5
200
Forecast Budget Actual
300
| Q12015
$ millions
America
NOI YTD latest - Global (Cash)
| Q4
300
Global
$ millions
| Q3
NOI QTD latest - Division (Cash)
345.5 Forecast Budget Actual
1200
| Q2
Forecast NOI Actual NOI Property Name Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
5
Europe
Variance $850,000 $850,000 $850,000 $850,000
Skye Sant
11 August 2014
Forecast is the lightest Budget is the medium Actual is the dark
NOI - Global: Dropdown Detail
Forecast is the lightest Budget is the medium Actual is the dark
Main Page > Real Estate > Operations Dashboard > NOI - Global (cash) and/or [Ownership]
Populate my dashboard with Global
, in $ dollars
data, grouped by Division
sqft
and
,where applicable.
NOI QTD-latest - Global (Cash) NOI Projection 12 Quarters - Global (Cash)
Cash Cash Cash w/ Topside GAAP Actual/Forecast GAAP w/ Topside Budget
in 000,000’s
500 375 250 125 0
| Q4
| Q12013
NOI QTD latest - Global (Cash) $ millions 500 400 300 200 100 0
|
|
Q2
Q3
|
|
Q4
Q12014
500
Total
400
600
0
|
Q2
Q3
12 Quarters
Total
Forecast Budget Actual
100 0 Asia
Europe
NOI YTD latest - Division (Cash)
1,075.2
1200
Total
800
$ millions
1,075.2
1000
Total
600
Forecast Budget Actual
400 200 0
Global
America
Top X Positive NOI Drivers QTD -Global (Cash)
Asia
Property Code
Property Name
Forecast NOI
Variance
atl00101 atl00101 atl00101 atl00101
Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
$850,000 $850,000 $850,000 $850,000
Actual NOI
$ millions
Top X Negative NOI Drivers QTD - Asia (Cash) Property Code atl00101 atl00101 atl00101 atl00101
|
345.5
200
Forecast Budget Actual
300
| Q12015
$ millions
America
NOI YTD latest - Global (Cash)
| Q4
300
Global
$ millions
| Q3
NOI QTD latest - Division (Cash)
345.5 Forecast Budget Actual
1200
| Q2
Forecast NOI Actual NOI Property Name Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
6
Europe
Variance $850,000 $850,000 $850,000 $850,000
Skye Sant
11 August 2014
Forecast is the lightest Budget is the medium Actual is the dark
NOI - Global
Forecast is the lightest Budget is the medium Actual is the dark
Main Page > Real Estate > Operations Dashboard > NOI - Global (cash) and/or [Ownership]
Populate my dashboard with Global
, in $ dollars
data, grouped by Division
sqft
and
,where applicable.
NOI QTD-latest - Global (Cash) NOI Projection 12 Quarters - Global (Cash)
Cash
in 000,000’s
500 375 250 125 0
Actual/Forecast Budget | Q4
| Q12013
NOI QTD latest - Global (Cash) $ millions 500 400 300 200 100 0
|
|
Q2
Q3
|
|
Q4
Q12014
500
Total
400
600
0
|
Q2
Q3
12 Quarters
Total
Forecast Budget Actual
100 0 Asia
Europe
NOI YTD latest - Division (Cash)
1,075.2
1200
Total
800
$ millions
1,075.2
1000
Total
600
Forecast Budget Actual
400 200 0
Global
America
Top X Positive NOI Drivers QTD -Global (Cash)
Asia
Property Code
Property Name
Forecast NOI
Variance
atl00101 atl00101 atl00101 atl00101
Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
$850,000 $850,000 $850,000 $850,000
Actual NOI
$ millions
Top X Negative NOI Drivers QTD - Asia (Cash) Property Code atl00101 atl00101 atl00101 atl00101
|
345.5
200
Forecast Budget Actual
300
| Q12015
$ millions
America
NOI YTD latest - Global (Cash)
| Q4
300
Global
$ millions
| Q3
NOI QTD latest - Division (Cash)
345.5 Forecast Budget Actual
1200
| Q2
Forecast NOI Actual NOI Property Name Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
7
Europe
Variance $850,000 $850,000 $850,000 $850,000
Skye Sant
11 August 2014
Forecast is the lightest Budget is the medium Actual is the dark
NOI - Division
Forecast is the lightest Budget is the medium Actual is the dark
Main Page > Real Estate > Operations Dashboard > NOI - Global > NOI - Division (Cash) Populate my dashboard with
Division Global
and/or
[Ownership]
data, grouped by
Region Division
, in
$ dollars
and
sqft
,where applicable.
NOI QTD-latest - Division (Cash) NOI Projection 12 Quarters - Division (Cash)
Cash
in 000,000’s
500 375 250 125 0
Actual/Forecast Budget |
|
Q4
Q12013
|
|
Q2
Q3
| Q4
| Q12014
NOI QTD latest - Division (Cash)
| Q3
|
|
Q4
|
|
Q2
Q3
Q12015
12 Quarters
345.5
$ millions 350 300 250 200 150 100 0
| Q2
Total
Forecast Budget Actual America
Asia
Europe
NOI QTD latest - Region (Cash) $ millions
50 45 40 35 30 25 20 15 10 0
345.5 Total
Forecast Budget Actual AM-Cen
AM-Eas
AM-Lat
AM-Nor
AM-Sou
AS-Chi
AS-Jap
AS-Kor
EU-Cen
EU-Nor
EU-Sou
EU-Uni
NOI YTD latest - Division (Cash) 1200
$ millions
1000
1,075.2
800
Total
600
Forecast Budget Actual
400 200 0 America
Asia
Europe
NOI QTD latest - Region (Cash) in 000,000’s
500
1,075.2
400
Total
300 200 100 0
8
Forecast Budget Actual
Skye Sant
11 August 2014
Forecast is the lightest Budget is the medium Actual is the dark
NOI - Division
Forecast is the lightest Budget is the medium Actual is the dark
Main Page > Real Estate > Operations Dashboard > NOI - Global > NOI - Division (Cash) Populate my dashboard with
Division Global
and/or
[Ownership]
data, grouped by
Region Division
, in
$ dollars
and
sqft
,where applicable.
NOI QTD-latest - Division (Cash) NOI Projection 12 Quarters - Division (Cash)
Cash
in 000,000’s
500 375 250 125 0
Actual/Forecast Budget |
|
Q4
Q12013
|
|
Q2
Q3
| Q4
| Q12014
NOI QTD latest - Division (Cash)
| Q3
|
|
Q4
|
|
Q2
Q3
Q12015
12 Quarters
345.5
$ millions 350 300 250 200 150 100 0
| Q2
Total
Forecast Budget Actual America
Asia
Europe
NOI QTD latest - Region (Cash) $ millions
50 45 40 35 30 25 20 15 10 0
345.5 Total
Forecast Budget Actual AM-Cen
AM-Eas
AM-Lat
AM-Nor
AM-Sou
AS-Chi
AS-Jap
AS-Kor
EU-Cen
EU-Nor
EU-Sou
EU-Uni
NOI YTD latest - Division (Cash) 1200
$ millions
1000
1,075.2
800
Total
600
Forecast Budget Actual
400 200 0 America
Asia
Europe
NOI QTD latest - Region (Cash) in 000,000’s
500
1,075.2
400
Total
300 200 100 0
9
Forecast Budget Actual
Skye Sant
11 August 2014
Forecast is the lightest Budget is the medium Actual is the dark
NOI - Asia (Division)
Forecast is the lightest Budget is the medium Actual is the dark
Main Page > Real Estate > Operations Dashboard > NOI - Global > NOI - Division > NOI - Asia (Cash) and/or [Ownership]
Division Populate my dashboard with Global
, in $ dollars
data, grouped by Region Division
and
sqft
,where applicable.
NOI QTD-latest - Asia (Cash) NOI Projection 12 Quarters - Asia (Cash)
Cash
in 000,000’s
500 375 250 125 0
Actual/Forecast Budget | Q4
| Q12013
NOI QTD latest - Asia (Cash) $ millions 50 40 30 20 10 0
|
|
Q2
Q3
| Q4
| Q12014
|
|
Q2
Q3
50 0
43.3 Forecast Budget Actual
AS-China
AS-Japan
AS-Singapore
102.5 Total
200 150
Forecast Budget Actual
100 50 0
Asia
Top X Positive NOI Drivers QTD - Asia (Cash) Property Code
Property Name
Forecast NOI
Variance
atl00101 atl00101 atl00101 atl00101
Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
$850,000 $850,000 $850,000 $850,000
Actual NOI
$ millions
Top X Negative NOI Drivers QTD - Asia (Cash) Property Code atl00101 atl00101 atl00101 atl00101
12 Quarters
$ millions
102.5 Forecast Budget Actual
100
Q3
NOI YTD latest - Region (Cash) Total
150
|
Q2
Total
50 40 30 20 10 0
Asia
$ millions
|
$ millions
Forecast Budget Actual
200
| Q12015
NOI QTD latest - Region (Cash)
43.3 Total
NOI YTD latest - Asia (Cash)
| Q4
Forecast NOI Actual NOI Property Name Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
10
AS-China
AS-Japan
AS-Singapore
Variance $850,000 $850,000 $850,000 $850,000
Skye Sant
11 August 2014
Forecast is the lightest Budget is the medium Actual is the dark
NOI - Asia (Division)
Forecast is the lightest Budget is the medium Actual is the dark
Main Page > Real Estate > Operations Dashboard > NOI - Global > NOI - Division > NOI - Asia (Cash) and/or [Ownership]
Division Populate my dashboard with Global
, in $ dollars
data, grouped by Region Division
and
sqft
,where applicable.
NOI QTD-latest - Asia (Cash) NOI Projection 12 Quarters - Asia (Cash)
Cash
in 000,000’s
500 375 250 125 0
Actual/Forecast Budget | Q4
| Q12013
NOI QTD latest - Asia (Cash) $ millions 50 40 30 20 10 0
|
|
Q2
Q3
| Q4
| Q12014
|
|
Q2
Q3
50 0
43.3 Forecast Budget Actual
AS-China
AS-Japan
AS-Singapore
102.5 Total
200 150
Forecast Budget Actual
100 50 0
Asia
Top X Positive NOI Drivers QTD - Asia (Cash) Property Code
Property Name
Forecast NOI
Variance
atl00101 atl00101 atl00101 atl00101
Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
$850,000 $850,000 $850,000 $850,000
Actual NOI
$ millions
Top X Negative NOI Drivers QTD - Asia (Cash) Property Code atl00101 atl00101 atl00101 atl00101
12 Quarters
$ millions
102.5 Forecast Budget Actual
100
Q3
NOI YTD latest - Region (Cash) Total
150
|
Q2
Total
50 40 30 20 10 0
Asia
$ millions
|
$ millions
Forecast Budget Actual
200
| Q12015
NOI QTD latest - Region (Cash)
43.3 Total
NOI YTD latest - Asia (Cash)
| Q4
Forecast NOI Actual NOI Property Name Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
11
AS-China
AS-Japan
AS-Singapore
Variance $850,000 $850,000 $850,000 $850,000
Skye Sant
11 August 2014
Forecast is the lightest Budget is the medium Actual is the dark
NOI - AS-Japan (Region)
Forecast is the lightest Budget is the medium Actual is the dark
Main Page > Real Estate > Operations Dashboard > NOI - Global > NOI - Division > NOI - Asia > NOI - AS-Japan and/or [Ownership]
Region Populate my dashboard with Global
, in $ dollars
data, grouped by Country Division
sqft
and
,where applicable.
NOI QTD-latest - AS-Japan (Cash) NOI Projection 12 Quarters - AS-Japan (Cash)
Cash
in 000,000’s
500 375 250 125 0
Actual/Forecast Budget | Q4
| Q12013
|
|
Q2
Q3
| Q4
| Q12014
NOI QTD latest AS-Japan (Cash)
|
|
Q2
Q3
5.2
$ millions 50 40 30 20 10 0
Total
Forecast Budget Actual
| Q4
|
|
Q2
Q3
NOI QTD latest - Country (Cash) $ millions 50 40 30 20 10 0
12 Quarters
5.2 Total
Forecast Budget Actual
AS-Japan
Japan
NOI YTD latest AS-Japan (Cash)
25.1
$ millions 200
Total
150 50 0
NOI YTD latest - Country (Cash) $ millions 200
Forecast Budget Actual
100 50 0
AS-Japan
25.1 Total
150
Forecast Budget Actual
100
Japan
Top X Positive NOI Drivers QTD - AS-Japan (Cash) Property Code
Property Name
Forecast NOI
Variance
atl00101 atl00101 atl00101 atl00101
Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
$850,000 $850,000 $850,000 $850,000
Actual NOI
$ millions
Top X Negative NOI Drivers QTD - AS-Japan(Cash) Property Code atl00101 atl00101 atl00101 atl00101
| Q12015
Forecast NOI Actual NOI Property Name Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
12
Variance $850,000 $850,000 $850,000 $850,000
Skye Sant
11 August 2014
Forecast is the lightest Budget is the medium Actual is the dark
NOI - AS-Japan (Region)
Forecast is the lightest Budget is the medium Actual is the dark
Main Page > Real Estate > Operations Dashboard > NOI - Global > NOI - Division > NOI - Asia > NOI - AS-Japan and/or [Ownership]
Region Populate my dashboard with Global
, in $ dollars
data, grouped by Country Division
sqft
and
,where applicable.
NOI QTD-latest - AS-Japan (Cash) NOI Projection 12 Quarters - AS-Japan (Cash)
Cash
in 000,000’s
500 375 250 125 0
Actual/Forecast Budget | Q4
| Q12013
|
|
Q2
Q3
| Q4
| Q12014
NOI QTD latest AS-Japan (Cash)
|
|
Q2
Q3
5.2
$ millions 50 40 30 20 10 0
Total
Forecast Budget Actual
| Q4
|
|
Q2
Q3
NOI QTD latest - Country (Cash) $ millions 50 40 30 20 10 0
12 Quarters
5.2 Total
Forecast Budget Actual
AS-Japan
Japan
NOI YTD latest AS-Japan (Cash)
25.1
$ millions 200
Total
150 50 0
NOI YTD latest - Country (Cash) $ millions 200
Forecast Budget Actual
100 50 0
AS-Japan
25.1 Total
150
Forecast Budget Actual
100
Japan
Top X Positive NOI Drivers QTD - AS-Japan (Cash) Property Code
Property Name
Forecast NOI
Variance
atl00101 atl00101 atl00101 atl00101
Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
$850,000 $850,000 $850,000 $850,000
Actual NOI
$ millions
Top X Negative NOI Drivers QTD - AS-Japan(Cash) Property Code atl00101 atl00101 atl00101 atl00101
| Q12015
Forecast NOI Actual NOI Property Name Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
13
Variance $850,000 $850,000 $850,000 $850,000
Skye Sant
11 August 2014
Forecast is the lightest Budget is the medium Actual is the dark
NOI - Japan (Country)
Forecast is the lightest Budget is the medium Actual is the dark
Main Page > Real Estate > Operations Dashboard > NOI - Global > NOI - Division > NOI - Asia > NOI - AS-Japan > NOI - Japan and/or [Ownership]
Country Populate my dashboard with Global
, in $ dollars
data, grouped by Market Division
and
sqft
,where applicable.
NOI QTD-latest - Japan (Cash) NOI Projection 12 Quarters - Japan (Cash)
Cash
in 000,000’s
500 375 250 125 0
Actual/Forecast Budget | Q4
| Q12013
NOI QTD latest - Japan (Cash) 7 6 5 4 3 2 1 0
$ millions
| Q3
| Q4
| Q12014
|
|
Q2
Q3
Japan
30 10
Q3
12 Quarters
5.2 Total
Forecast Budget Actual JP-Fuk
JP-Hir
JP-Nag
JP-Osa
JP-Sen
JP-Tok
25.1
50
Total
40 30
Forecast Budget Actual
20 10 0
Japan
Top X Positive NOI Drivers QTD - Japan (Cash) Actual NOI
Forecast NOI
Property Code
Property Name
atl00101 atl00101 atl00101 atl00101
Altanta Dist. Ctr #1 $750,000 Functionality) Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 Altanta Dist. Ctr #1 $600,000
$ millions
Top X Negative NOI Drivers QTD - Japan(Cash) Property Code atl00101 atl00101 atl00101 atl00101
|
Q2
$ millions
25.1 Forecast Budget Actual
20
|
NOI YTD latest - Markets (Cash) Total
40
| Q12015
$ millions 7 6 5 4 3 2 1 0
Forecast Budget Actual
50 $ millions
| Q4
NOI QTD latest - Markets (Cash)
5.2 Total
NOI YTD latest - Japan (Cash)
0
| Q2
Forecast NOI Actual NOI Property Name Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
14
JP-Fuk
JP-Hir
JP-Nag
JP-Osa
JP-Sen
JP-Tok
Variance
Variance $850,000 $850,000 $850,000 $850,000
Skye Sant
11 August 2014
Continued Analysis
Forecast is the lightest Budget is the medium Actual is the dark
Forecast is the lightest Budget is the medium Actual is the dark
Future Functionality:
Main Page > Real Estate > Operations Dashboard > NOI - Global > NOI - Division > NOI - Asia > NOI - AS-Japan > NOI - Japan Populate my dashboard with
Country Global
and/or
[Ownership]
data, grouped by
Division Market
, in
$ dollars
and
sqft
,where applicable.
This page will continue out to other tools for analysis such as:
NOI QTD-latest - Japan (Cash) NOI Projection 12 Quarters - Japan (Cash)
Cash
in 000,000’s
500 375 250 125 0
Actual/Forecast Budget | Q4
| Q12013
NOI QTD latest - Japan (Cash) 7 6 5 4 3 2 1 0
$ millions
| Q3
| Q4
| Q12014
|
|
Q2
Q3
Japan
30 10
Q3
• Management Reports (current) • GDW (future)
12 Quarters
5.2 Total
Forecast Budget Actual JP-Fuk
JP-Hir
JP-Nag
JP-Osa
JP-Sen
JP-Tok
$ millions
25.1 Total
40 30
Forecast Budget Actual
20 10 0
Japan
Top X Positive NOI Drivers QTD - Japan (Cash) Actual NOI
Forecast NOI
Property Code
Property Name
atl00101 atl00101 atl00101 atl00101
Altanta Dist. Ctr #1 $750,000 Functionality) Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 Altanta Dist. Ctr #1 $600,000
$ millions
Top X Negative NOI Drivers QTD - Japan(Cash) Property Code atl00101 atl00101 atl00101 atl00101
|
Q2
50
Forecast Budget Actual
20
|
NOI YTD latest - Markets (Cash)
25.1 Total
40
| Q12015
$ millions 7 6 5 4 3 2 1 0
Forecast Budget Actual
50 $ millions
| Q4
NOI QTD latest - Markets (Cash)
5.2 Total
NOI YTD latest - Japan (Cash)
0
| Q2
Forecast NOI Actual NOI Property Name Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
JP-Fuk
JP-Hir
JP-Nag
JP-Osa
JP-Sen
Where possible, inclusions and/ or limitations on the data that are applied in PrologisOne will be included in the search criteria in these other tools.
JP-Tok
Variance
Variance $850,000 $850,000 $850,000 $850,000
15
Skye Sant
11 August 2014
Structure
KPI over 12 quarters (8 actual, 4 forecast) QTD - Geography Level
QTD - Geography Level +1
YTD - Geography Level
YTD - Geography Level +1
Top 5 Positive KPI Drivers
Top 5 Negative KPI Drivers
16
Skye Sant
11 August 2014
Page Flow
Dashboard Main Page > Real Estate > Operations Dashboard and/or [Ownership]
Populate my dashboard with Global
, in $ dollars
data, grouped by Division
sqft
and
,where applicable.
Operations QTD latest - Global by Division NOI (Cash w/ Topside) Geography
$ millions
Americas Asia Europe TOTAL
SS NOI Growth (Cash w/ topside)
Cash w/ Top.. Budget
Actuals
Forecast
$ millions
$ millions
Actuals
Budget
Forecast
Americas Asia Europe TOTAL
6.0% 4.5% -0.1% 5.0%
6.0% 4.5% -0.1% 5.0%
6.0% 4.5% -0.1% 5.0%
$343.1 $343.1 $343.1 56.8 56.8 56.8 203.1 203.1 203.1 $1,001.0 $1,001.0 $1,001.0
Average Occupancy (Include Topside)
Period End Occupancy (Include Topside)
w/ Topside
Geography
Actuals
Budget
Forecast
Americas Asia Europe TOTAL
68.6% 88.3% 88.7% 85.0%
68.6% 88.3% 88.7% 85.0%
68.6% 88.3% 88.7% 85.0%
Cash w/ Top..
Geography
Geography
Actuals
Budget
Forecast
Americas Asia Europe TOTAL
68.5% 88.9% 88.2% 85.1%
68.5% 88.9% 88.2% 85.1%
68.5% 88.9% 88.2% 85.1%
Budget
Forecast
Dashboard, Global Level (w/ Division info)
w/ Topside
Rent Change
Retention Geography
Actuals
Budget
Americas Asia Europe TOTAL
68.4% 48.2% 58.9% 55.2%
Geography
Actuals
68.4% 48.2% 58.9% 55.2%
68.4% 48.2% 58.9% 55.2%
Americas Asia Europe TOTAL
-10.5% -2.0% 15.3% 7.6%
-10.5% -2.0% 15.3% 7.6%
-10.5% -2.0% 15.3% 7.6%
Actuals
Budget
Forecast
Forecast
Geography
Actuals
Budget
Forecast
1.80 0.55 1.50 0.40
1.80 0.55 1.50 0.40
Americas Asia Europe TOTAL
$76.1 40.6 50.9 $166.5
$76.1 40.6 50.9 $166.5
$76.1 40.6 50.9 $166.5
Turnover Costs/Area Geography
Property Improvements
$/sqft
Americas Asia Europe TOTAL
$/sqft
$/sqft
1.80 0.55 1.50 0.40
$ millions
$ millions
$ millions
Similar graphs are linked and the dropdown value will change them together
Forecast is the lightest Budget is the medium Actual is the dark
Global
Forecast is the lightest Budget is the medium Actual is the dark
Main Page > Real Estate > Operations Dashboard > NOI - Global (cash) and/or [Ownership]
Populate my dashboard with Global
, in $ dollars
data, grouped by Division
sqft
and
,where applicable.
NOI QTD-latest - Global (Cash) NOI Projection 12 Quarters - Global (Cash)
Cash
in 000,000’s
500 375 250 125 0
KPI, Global Level (w/ Division info)
Actual/Forecast Budget |
|
Q4
Q12013
|
|
Q2
Q3
|
|
Q4
Q12014
|
|
Q2
Q3
345.5
$ millions 500 400 300 200 100 0
500
Total
$ millions
Q3
12 Quarters
345.5
$ millions
Total
Forecast Budget Actual
200 100 0
1200
1,075.2
Asia
Europe
0
$ millions
1,075.2
1000
Total
800
Total
600
Forecast Budget Actual
300
Forecast Budget Actual
400 200 0
Global
America
Asia
Top X Positive NOI Drivers QTD -Global (Cash) $ millions
Europe
Variance
Forecast NOI
Actual NOI
Property Name
Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
atl00101 atl00101 atl00101 atl00101
|
Q2
NOI YTD latest - Division (Cash)
600
$850,000 $850,000 $850,000 $850,000
Top X Negative NOI Drivers QTD - Asia (Cash) Property Code atl00101 atl00101 atl00101 atl00101
|
300
America
1200
| Q12015
400
Forecast Budget Actual Global
NOI YTD latest - Global (Cash)
Property Code
| Q4
NOI QTD latest - Division (Cash)
NOI QTD latest - Global (Cash)
Variance $850,000 $850,000 $850,000 $850,000
Forecast NOI Actual NOI Property Name Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
Divisions (all)
Forecast is the lightest Budget is the medium Actual is the dark
Forecast is the lightest Budget is the medium Actual is the dark
Main Page > Real Estate > Operations Dashboard > NOI - Global > NOI - Division (Cash) and/or [Ownership]
Populate my dashboard with Division Global
Forecast is the lightest Budget is the medium Actual is the dark
and
sqft
Division Populate my dashboard with Global
Cash
NOI Projection 12 Quarters - Asia (Cash)
| Q12013
|
|
Q2
Q3
| Q4
| Q12014
|
|
Q2
Q3
|
|
Q4
|
|
Q2
Q3
Q12015
Asia
Forecast Budget Actual AM-Lat
AM-Nor
AM-Sou
AS-Chi
AS-Jap
AS-Kor
EU-Cen
EU-Nor
EU-Sou
800
200 0
| Q12015
|
|
Q2
Q3
12 Quarters
NOI QTD latest - Region (Cash)
43.3
43.3
$ millions
Total
50 40 30 20 10 0
KPI, Division Level (w/ Region info)
Forecast Budget Actual AS-China
AS-Japan
AS-Singapore
NOI YTD latest - Region (Cash) $ millions
102.5
$ millions 200
Total
150 50 0
Total
150
Forecast Budget Actual
100
102.5
200
Forecast Budget Actual
100 50 0
$ millions
Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
AS-China
AS-Japan
AS-Singapore
Variance
Forecast NOI
Actual NOI
Property Name
Top X Negative NOI Drivers QTD - Asia (Cash)
1,075.2
400
Total
0
| Q4
$850,000 $850,000 $850,000 $850,000
Europe
500
100
| Q3
Total
atl00101 atl00101 atl00101 atl00101
Forecast Budget Actual
400
Asia
| Q2
Asia
Total
600
America
| Q12014
Forecast Budget Actual
Property Code
1,075.2
NOI QTD latest - Region (Cash)
200
Cash
| Q4
Top X Positive NOI Drivers QTD - Asia (Cash)
$ millions
1000
in 000,000’s
| Q3
NOI YTD latest - Asia (Cash)
EU-Uni
NOI YTD latest - Division (Cash)
300
| Q2
Asia
345.5
AM-Eas
| Q12013
50 40 30 20 10 0
Total
AM-Cen
,where applicable.
Actual/Forecast Budget | Q4
Europe
$ millions
1200
500 375 250 125 0
$ millions
Total
Forecast Budget Actual America
12 Quarters
NOI QTD latest - Asia (Cash)
345.5
$ millions
NOI QTD latest - Region (Cash) 50 45 40 35 30 25 20 15 10 0
sqft
and
in 000,000’s
Actual/Forecast Budget |
NOI QTD latest - Division (Cash) 350 300 250 200 150 100 0
, in $ dollars
data, grouped by Region Division
NOI QTD-latest - Asia (Cash)
in 000,000’s
Q4
and/or [Ownership]
,where applicable.
NOI QTD-latest - Division (Cash) NOI Projection 12 Quarters - Division (Cash) 500 375 250 125 0
Asia
Forecast is the lightest Budget is the medium Actual is the dark
Main Page > Real Estate > Operations Dashboard > NOI - Global > NOI - Division > NOI - Asia (Cash) , in $ dollars
data, grouped by Region Division
Forecast Budget Actual
Property Code atl00101 atl00101 atl00101 atl00101
Forecast NOI Actual NOI Property Name Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
Variance $850,000 $850,000 $850,000 $850,000
AS-Japan
Forecast is the lightest Budget is the medium Actual is the dark
Forecast is the lightest Budget is the medium Actual is the dark
Main Page > Real Estate > Operations Dashboard > NOI - Global > NOI - Division > NOI - Asia > NOI - AS-Japan and/or [Ownership]
Region Populate my dashboard with Global
, in $ dollars
data, grouped by Country Division
sqft
and
,where applicable.
NOI QTD-latest - AS-Japan (Cash) NOI Projection 12 Quarters - AS-Japan (Cash)
Cash
in 000,000’s
500 375 250 125 0
Actual/Forecast Budget | Q4
| Q12013
|
|
Q2
Q3
| Q4
| Q12014
NOI QTD latest AS-Japan (Cash)
|
|
Q2
Q3
|
Q12015
|
Q2
Q3
$ millions 50 40 30 20 10 0
Total
Forecast Budget Actual
12 Quarters
5.2 Total
KPI, Region Level (w/ Country info)
Forecast Budget Actual
AS-Japan
Japan
NOI YTD latest AS-Japan (Cash)
NOI YTD latest - Country (Cash)
25.1
$ millions 200
$ millions 200
Total
150
Forecast Budget Actual
100 50 0
25.1 Total
150
Forecast Budget Actual
100 50 0
AS-Japan
Japan
Top X Positive NOI Drivers QTD - AS-Japan (Cash) Property Code
Property Name
Forecast NOI
Variance
atl00101 atl00101 atl00101 atl00101
Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
$850,000 $850,000 $850,000 $850,000
Actual NOI
$ millions
Top X Negative NOI Drivers QTD - AS-Japan(Cash) Property Code atl00101 atl00101 atl00101 atl00101
|
NOI QTD latest - Country (Cash)
5.2
$ millions 50 40 30 20 10 0
|
Q4
Forecast NOI Actual NOI Property Name Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
Variance $850,000 $850,000 $850,000 $850,000
Forecast is the lightest Budget is the medium Actual is the dark
Japan
Forecast is the lightest Budget is the medium Actual is the dark
Main Page > Real Estate > Operations Dashboard > NOI - Global > NOI - Division > NOI - Asia > NOI - AS-Japan > NOI - Japan and/or [Ownership]
Country Populate my dashboard with Global
, in $ dollars
data, grouped by Market Division
and
sqft
,where applicable.
NOI QTD-latest - Japan (Cash) NOI Projection 12 Quarters - Japan (Cash)
Cash
in 000,000’s
500 375 250 125 0
Actual/Forecast Budget | Q4
| Q12013
NOI QTD latest - Japan (Cash) 7 6 5 4 3 2 1 0
$ millions
| Q3
| Q4
| Q12014
|
|
Q2
Q3
5.2
30 10
Q3
KPI, Country Level (w/ Market info)
12 Quarters
5.2 Total
Forecast Budget Actual JP-Fuk
JP-Hir
JP-Nag
JP-Osa
JP-Sen
JP-Tok
$ millions
25.1 Total
40 30
Forecast Budget Actual
20 10 0
Japan
Top X Positive NOI Drivers QTD - Japan (Cash) Actual NOI
Forecast NOI
Property Code
Property Name
atl00101 atl00101 atl00101 atl00101
Altanta Dist. Ctr #1 $750,000 Functionality) Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 Altanta Dist. Ctr #1 $600,000
$ millions
Top X Negative NOI Drivers QTD - Japan(Cash) Property Code atl00101 atl00101 atl00101 atl00101
|
Q2
50
Forecast Budget Actual
20
|
NOI YTD latest - Markets (Cash)
25.1 Total
40
| Q12015
$ millions 7 6 5 4 3 2 1 0
Total
Forecast Budget Actual
50 $ millions
| Q4
NOI QTD latest - Markets (Cash)
Japan
NOI YTD latest - Japan (Cash)
0
| Q2
Forecast NOI Actual NOI Property Name Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
JP-Fuk
JP-Hir
JP-Nag
JP-Osa
JP-Sen
JP-Tok
Variance
Variance $850,000 $850,000 $850,000 $850,000
17
Skye Sant
11 August 2014
and/or [Ownership]
obal
, in $ dollars
data, grouped by Division
and
,where applicable.
sqft
Global (Cash)
(Cash) ters - Global Reading
Cash
Bar Graphs Forecast is the lightest Budget is the medium Actual is the dark
Forecast is the lightest Budget is the medium Actual is the dark
Main Page > Real Estate > Operations Dashboard > NOI - Global (cash) Populate my dashboard with
Global
and/or
[Ownership]
Division
data, grouped by
$ dollars
, in
sqft
and
Actual/Forecast Budget
,where applicable.
NOI QTD-latest - Global (Cash) NOI Projection 12 Quarters - Global (Cash)
Cash
in 000,000’s
500 375 250 125 0
|
Actual/Forecast Budget |
Q4
|
|
Q12013
NOI QTD latest - Global (Cash)
Q3
Q2
$ millions
500 400 300 200 100 0
|
|
Q2
Q3
345.5 Total
|
| Q4
| Q12014
Q4
500 300
1200 600
0
Total
Forecast Budget Actual
|
|
Q2
Q3
12 Quarters
Total
0
1,075.2
1200
Total
800
1000 600
$ millions
Asia
| Q4
|
|
|
Q2
Q12015
Q3
12 Quarters
Europe
NOI QTD latest - Division (Cash) 1,075.2 Total
Forecast Budget Actual
400 200 0 America
Property Name
Actual NOI
$ millions
Asia
500
345.5
$ millions Europe
Variance
Forecast NOI
Total
400
Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
$850,000 $850,000 $850,000 $850,000
300
Top X Negative NOI Drivers QTD - Asia (Cash)
Property Code atl00101 atl00101 atl00101 atl00101
Q3
345.5
100
Global
atl00101 atl00101 atl00101 atl00101
|
Q2
Forecast Budget Actual
Top X Positive NOI Drivers QTD -Global (Cash)
Property Code
|
NOI YTD latest - Division (Cash)
Forecast Budget Actual
300
| Q12015
200
America
$ millions
|
| Q4
Q12014
$ millions
400
Forecast Budget Actual
NOI YTD latest - Global (Cash)
345.5
| Q3
NOI QTD latest - Division (Cash)
Global
al
| Q2
Forecast Budget Actual
Variance $850,000 $850,000 $850,000 $850,000
Forecast NOI Actual NOI Property Name Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
200 100 0 America
Asia
Europe: Very Good Actuals surpass both budget and forecast Budget is set higher than the forecast
Europe
NOI YTD latest - Division (Cash)
al
1200
1,075.2
$ millions
1,075.2
1000
Total
Total Asia: Troubled
800 600
Forecast Budget Actual
200
America: Fine0 Asia America Actuals less than both budget and forecast Actuals are within an acceptable threshold (Cash) Drivers QTD -Global Budget is thanNOI the forecast Variance Forecast Actual NOI set lower
erty Name
$ millions
$750,000 -$100,000 ta Dist. Ctr #1 Functionality)-$100,000 (Future $650,000 ta Dist. Ctr #1 $600,000 -$100,000 ta Dist. Ctr #1 $600,000 #1 Ctr Dist. -$100,000 nta
I Drivers QTD - Asia (Cash)
erty Name nta Dist. Ctr #1
Forecast Actuals less than both budget and forecast Budget Actuals have fallen below an acceptable threshold Actual
400
Actual NOI $750,000
Forecast NOI -$100,000
Europe
Budget is set higher than the forecast
$850,000 $850,000 $850,000 $850,000
Variance $850,000
18
Skye Sant
11 August 2014
3
Global
Actual/Forecast Budget |
|
Q2
Q3
|
|
Q4
Q12014
Totals
|
|
|
Q2
Q3
|
Q4
Forecast is the lightest Budget is the medium Actual is the dark
Q12015
|
|
Q2
Q3
Forecast is the lightest Budget is the medium Actual is the dark
NOI QTD latest - Division (Cash)
345.5
500
345.5
$ millions
Main Page > Real Estate > Operations Dashboard > NOI - Global (cash)
Total
400
300and/or [Ownership]
Populate my dashboard with Global
in 000,000’s
500 375 250 125 0
America
|
|
|
1,075.2 NOI QTD latest - Global Q4
Q12013
(Cash) Total
$ millions
Forecast Budget Actual
Q3 1200
Q2
1000 800 345.5
Q4 $ millions
Q12014
500
NOI YTD latest - Global (Cash)
Property Name
300
0
1200
Asia
12 Quarters
Europe
1000
1,075.2
800
Total
600
Variance
Forecast NOI 400 200 0
$ millions
$600,000
NOI Drivers QTD - Negative Asia (Cash) Top X NOI Drivers QTD - Asia (Cash) Actual NOI
-$100,000 -$100,000
Forecast NOI
Forecast Actual Property Name AltantaNOI Dist. Ctr #1 $750,000 NOI-$100,000 atl00101 Functionality) Altanta Dist. Ctr #1 (Future$650,000 atl00101 Altanta Dist. Ctr #1atl00101 $750,000 -$100,000-$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000 (Future$650,000 Functionality) Altanta Dist. Ctr #1 $600,000 Altanta Dist. Ctr #1atl00101 -$100,000-$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
$850,000 $850,000 Variance $850,000 $850,000 $850,000 $850,000 Asia
1,075.2 Total
Forecast Budget Actual
Europe
$ millions
America
Property Name
Q3
Total
100
Global
Property Code
|
Q2
Forecast Budget Actual
Altanta Dist. Ctr #1 $750,000 -$100,000 Top X Positive NOI Drivers QTD -Global (Cash) (Future Functionality) Altanta Dist. Ctr #1 $650,000 -$100,000 Forecast NOI Actual NOI Property Code Property Name Altanta Dist. Ctr #1atl00101 $600,000 -$100,000-$100,000 Altanta Dist. Ctr #1 $750,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1atl00101 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 atl00101 Altanta Dist. Ctr #1
|
345.5
200
1,075.2
Actual NOI
atl00101
| Q12015
America Asia NOI YTD latest - Division (Cash)
Forecast Budget $ millionsActual
0
Q4
$ millions
America
Forecast Budget Cash Actual
Actual/Forecast Budget
300
NOI Drivers QTD -Global (Cash)Total 600
Q3
,where applicable.
Europe
400
0
Global
$ millions
Q2
sqft
and
NOI QTD latest - Division (Cash)
Forecast 400 Budget 200 Actual
1200
Asia
NOI |YTD | latest| - Division (Cash) | | |
Total 600
500 400 300 200 100 0
Total , in $ dollars
data, grouped by Division
Forecast 200 Budget NOI QTD-latest - Global (Cash) 100 Actual NOI Projection 12 Quarters - Global0 (Cash)
lobal
12 Quarters
Forecast Budget Actual Europe
$850,000 $850,000
Variance
Variance $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 19
Skye Sant
11 August 2014
ash) OI Projection 12 Quarters - Global (Cash)
]
, in $ dollars
in 000,000’s
data, grouped by Division
Visual Design: Color
00 75 50 25 0
Forecast is the lightest Budget is the medium Actual is the dark
| Q4
|
Main Page > Real Estate > Operations Dashboard > NOI (cash) and/or [Ownership]
Populate my dashboard with Global
NOI QTD-latest - Global (Cash) Q12013
Forecast is the lightest Budget is the medium Actual is the dark
|
|
, in $ dollars
data, grouped by Division
Q2
and
|
sqft
Q3
Q4
|
|
$ millions
500 400 300| 200 12014 100 0
Q12013
NOI QTD latest - Global (Cash) $ millions
|
|
Q2
Q3
|
Q4
| Q12014
|
|
Q2
Q3
345.5
345.5 500
0
|
Q2
Q3
Forecast | Budget Q4 Actual
|
1,075.2 Total
Forecast Budget Actual
Q2
1200 1000 800 600
Q3
200 0
America
Top X Positive NOI Drivers QTD -Global (Cash) Forecast NOI
Actual NOI
Property Code
Property Name
atl00101 atl00101 atl00101 atl00101
Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
Global
Actual NOI
OI YTD latest - Global ash) $ millions
Asia
500
|
Q3
|
Q12014
1,075.2 Total
Forecast Budget Actual
NOI YTD latest - Global (Cash)
|
|
$ millions 1200
Q2
600 300 0
00 0 Global
|
Q3
sqft
,where applicable.
Q12015
Q3
|
|
Q2
Q
12 Quarters
345.5
$ millions
Total
Forecast Budget Actual
100 0
America
300
1200
Total
Forecast Budget Actual
600 400 200 0 America
Property Name
Forecast NOI
0
Variance
atl00101 atl00101 atl00101 atl00101
Altanta Dist. Ctr #1 $750,000 -$100,000 Functionality)-$100,000 Altanta Dist. Ctr #1 (Future$650,000 Altanta Dist. Ctr #1 $600,000 -$100,000 Altanta Dist. Ctr #1 $600,000 -$100,000
$850,000 $850,000 $850,000 $850,000
Top X Negative NOI Drivers QTD -Global (Cash) Actual NOI
1,075.2 400
Variance
Forecast NOI
Asia
Europe
America
Asia
345.5
NOI YTD latest Total - Division (Cash) 1200
$ millions
1000
200
800
100
600 400
Europe
1,075.2
$ millions
800
Property Code
$ millions
Europe
1000
100
Actual NOI
Asia
NOI YTD latest - Division (Cash)
200
12 Quarters
Asia
|
Q2
200
400
1,075.2
Property Name
|
300
Total
Property Code
$ millions
|
Q12015
400
Top X Positive NOI Drivers QTD -Global (Cash)
Variance
|
Q4
500
Global
Variance
Forecast Budget 0 Actual America
00
|
NOI QTD latest - Division (Cash)
Forecast Budget Actual
Q3
Europe
|
Q2
345.5
300Total
00
|
Q4
Total
NOI QTD latest - Division (Cash) Forecast NOI
|
Q2
Global
$850,000 $850,000 $850,000 $850,000
Top X Negative NOI Drivers QTD -Global (Cash) Property Name
|
Q12015
400
Global
Property Code
$ millions
and
Cash
Forecast Budget Actual
Europe
NOI YTD latest - Division (Cash)
|
$ millions
Asia
| Q12013
500 400 300 200 100 0
Forecast Budget Actual America
|
$ millions
Total
100
, in $ dollars
Cash Cash w/ Topside GAAP Actual/Forecast GAAP w/ Topside Budget
NOI QTD latest - Global (Cash)
345.5
200
data, grouped by Division
Cash Cash latest w/ Topside NOI QTD - Division (Cash) GAAP Actual/Forecast 500 $ millions GAAP w/ Topside Budget
in 000,000’s
Q4
300
|
Cash Q4
and/or [Ownership]
Q2 - Global (Cash)Q3 NOI QTD-latest 500 375 250 125 0
12 Quarters
$ millions
|
Forecast is the lightest Budget is the medium Actual is the dark
NOI Projection 12 Quarters - Global (Cash)
0
$ millions
300
|
Total
Forecast Budget Actual
NOI YTD latest - Global (Cash) 600
| Q12015
400
Global
1200
|
Q4
NOI QTD latest - Division (Cash)
Total
500 400 300 200 100 0
|
Main Page > Real Estate > Operations Dashboard > NOI (cash)
Q12014
Earl Grey color scheme
Forecast is the lightest Budget is the medium Actual is the dark
Populate my dashboard with Global
Cash Cash w/ Topside GAAP Actual/Forecast GAAP w/ Topside Budget
in 000,000’s
Q4
|
,where applicable.
Cash
OI QTD latest - Global ash)
,where applicable.
Heather color scheme
NOI Projection 12 Quarters - Global (Cash) 500 375 250 125 0
sqft
and
Forecast Budget Actual
200 0 America
NOI YTD latest - Division (Cash)
$ millions 1200QTD Top X Positive NOI Drivers -Global (Cash)
Property Code
Property Name
Forecast NOI
Variance
atl00101 atl00101
Altanta Dist.600 Ctr #1 $750,000 20 -$100,000 (Future Functionality) Altanta Dist.400 Ctr #1 $650,000
$850,000 $850,000
1000 800
Actual NOI
$ millions
Asia
1,075.2 Total Skye Sant Forecast Budget
11 August 2014
Visual Design: Main Page Main Page
Main Page (restricted access)
Main Page
Main Page
Main Summary (Global)
Main Summary (Global)
Real Estate Operations
Real Estate Operations Leasing
Operations
Capital Deployment
Leasing
Operations
Capital Deployment
Customer
Flash Reports
Mgmt Reports
Customer
Flash Reports
Mgmt Reports
Performance
Annual Goals
Corporate and Funds
Corporate and Funds Fund Mgmt & Strategy
Fund Mgmt & Strategy
Divisional Business Plans
Research Analytics
Research Analytics Predictive Analytics
Predictive Analytics
Analysis Tools
Analysis Tools
Scorecards ROI Quarterly Summary (Global)
RCA Quarterly Summary (Global)
PIRI Quarterly Summary (Global)
21
Skye Sant
11 August 2014
APPENDIX: Future Functionality: Title and ‘info’ hover-overs
Main Page > Real Estate > Leasing Dashboard
Leasing (Global)
Leasing Coverage Ratio (90 day)
Leasing Volume to Budget (YTD)
Leasing Coverage (90 day) >500K
Actual Leased Area
500250 250100
Budget Leased Area
<100K divided by qtr
Leasing Velocity (rolling 12 month)
[25 days]
days
Definition: Leasing Coverage Ratio is defined as the amount of area in the A and B pipeline stages that is tied to a currently vacant or expiring Coverage unit in the next 90 days divided by the total area of units that are Area (A+B) currently vacant or expiring in the next 90 days.
Formula: (Total Area of A + B Pipeline Stages) / (Total Space at Risk) = Total Space at Leasing Coverage Ratio Risk Area Go to this definition in the KPI Dictionary (link opens in new window)
Leasing Coverage Ratio (90 day) 100
% coverage
[Global Average: 86%]
90 250
80
90 day Average
70 200
60
Last Year
50 150
40 30
100
20 10
0
|
Jan13
|
Feb
|
|
Mar Apr
|
May
|
Jun
|
|
Jul Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
Jan14
In the future, each widget title and info icon will have information that will be displayed on hover (click, for tablets)
0 Americas
Asia
Europe
geography
Main Page > Real Estate > Leasing Dashboard
Leasing (Global) Leasing Volume to Budget (YTD)
Leasing Coverage (90 day) >500K
Actual Leased Area
Coverage Area (A+B)
500250 250100
Budget Leased Area
Total Space at Risk Area
<100K divided by qtr
Leasing Velocity (rolling 12 month)
[25 days]
days
Leasing Coverage Ratio (90 day) 100
% coverage
90
Contact: NAME Phone Email
80
250
70 60
200
Data: [Global Average: 86%] Valid ______ to ______ Source: [tool, database, excel load] 90 day Average Last Year
50 40
150
30 20
100
10 0
|
Jan13
22
|
Feb
|
|
Mar Apr
|
May
|
Jun
|
|
Jul Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
Jan14
0 Americas
Asia
Skye Sant
Europe
geography
11 August 2014