This is a Property Investment Balanced Scorecard Report, it is one of reports that Balanced Scorecard Designer can generate for Property Investment scorecard. With this software you can also design your own KPIs, Balanced Scorecards and metrics.


Real Estate Investment

Report includes: 1 month(s) 49 day(s), from 05.04.2008 to 24.05.2008

  Name Start value End value Dynamic Contains
Root Real Estate Investment 38,99 % 48,44 % + 9,45 %
Equity Value(55,9%, 7,64%Up)
Profitability per SqFt(49,4%, -13,9%Down)
Annual Return on Investment(50,8%, 15,1%Up)
Monthly Return on Investment(53,7%, 12,28%Up)
Price to Income(49,7%, -1,42%Down)
Risk metrics(31,7%, 30,46%Up)

Graph for Real Estate Investment

Graph for Real Estate Investment

Data for Real Estate Investment

DatesValue
05.04.200838,99
12.04.200854,52
19.04.200851,59
26.04.200858,36
03.05.200849,91
10.05.200868,61
17.05.200842,6
24.05.200848,44

Equity Value

  Name Start value End value Dynamic Parent Contains
Root Equity Value 48,28 % 55,92 % + 7,64% Real Estate Investment
Indicators
Equity in Property
Future Property Value
IRR

Graph for Equity Value

Graph for Equity Value

Data for Equity Value

DatesValueWeight
05.04.200848,283
12.04.200855,023
19.04.200841,023
26.04.200850,783
03.05.200878,743
10.05.200880,823
17.05.200839,263
24.05.200855,923

Equity in Property

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Equity in Property 29,66 28,04 -1,62 Score Maximize Equity Value
Description The total equity owned by the Investor in the current year, including property value escalation, repaid loan principal, and property improvements.
Target description [Mln. USD]

Graph for Equity in Property

Graph for Equity in Property

Data for Equity in Property

DatesWeightMinMaxValue
05.04.20084103029,66
12.04.20084103016,96
19.04.20084103010,8
26.04.20084103014,3
03.05.20084103028,24
10.05.20084103028,18
17.05.20084103026,32
24.05.20084103028,04

Future Property Value

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Future Property Value 14,472 15,312 + 0,84 Score Maximize Equity Value
Description The Fair Market Value of the property in the current year, assuming property improvements and value escalation.
Target description [Mln. USD]

Graph for Future Property Value

Graph for Future Property Value

Data for Future Property Value

DatesWeightMinMaxValue
05.04.20084113914,472
12.04.20084113926,736
19.04.20084113926,876
26.04.20084113931,552
03.05.20084113936,508
10.05.20084113937,124
17.05.20084113911,7
24.05.20084113915,312

IRR

  Name Start value End value Dynamic Measure units Optimization method Parent
Root IRR 1,6 5,472 + 3,872 % Maximize Equity Value
Description The annualized effective compounded return rate which can be earned on the invested capital (the yield on the investment).

Graph for IRR

Graph for IRR

Data for IRR

DatesWeightMinMaxValue
05.04.20082081,6
12.04.20082087,448
19.04.20082086,696
26.04.20082085,128
03.05.20082082,328
10.05.20082082,856
17.05.20082082,248
24.05.20082085,472

Profitability per SqFt

  Name Start value End value Dynamic Parent Contains
Root Profitability per SqFt 63,3 % 49,4 % -13,9% Real Estate Investment
Indicators
Price/ Sq Ft
Rent/ Sq Ft

Graph for Profitability per SqFt

Graph for Profitability per SqFt

Data for Profitability per SqFt

DatesValueWeight
05.04.200863,31
12.04.200825,11
19.04.200855,851
26.04.200858,251
03.05.200839,551
10.05.200844,351
17.05.200843,11
24.05.200849,41

Price/ Sq Ft

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Price/ Sq Ft 2514,6 2406,8 -107,8 Score Maximize Profitability per SqFt
Description The property price divided by the livable square feet in the property.
Target description [USD]

Graph for Price/ Sq Ft

Graph for Price/ Sq Ft

Data for Price/ Sq Ft

DatesWeightMinMaxValue
05.04.20085120026002514,6
12.04.20085120026001576,6
19.04.20085120026002292
26.04.20085120026002369
03.05.20085120026002294,8
10.05.20085120026001247,6
17.05.20085120026002394,2
24.05.20085120026002406,8

Rent/ Sq Ft

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Rent/ Sq Ft 21,54 17,52 -4,02 Score Maximize Profitability per SqFt
Description The estimated monthly property rental income divided by the livable square feet in the property.
Target description [USD]

Graph for Rent/ Sq Ft

Graph for Rent/ Sq Ft

Data for Rent/ Sq Ft

DatesWeightMinMaxValue
05.04.20085153521,54
12.04.20085153519,66
19.04.20085153521,74
26.04.20085153521,6
03.05.20085153515,18
10.05.20085153532,06
17.05.20085153515,18
24.05.20085153517,52

Annual Return on Investment

  Name Start value End value Dynamic Parent Contains
Root Annual Return on Investment 35,69 % 50,79 % + 15,1% Real Estate Investment
Indicators
Pre-tax Annual Cash-on-cash return
Pre-tax Annual Cash Flow
Post-tax Annual Cash Flow

Graph for Annual Return on Investment

Graph for Annual Return on Investment

Data for Annual Return on Investment

DatesValueWeight
05.04.200835,691
12.04.200849,241
19.04.200847,61
26.04.200863,461
03.05.200871,31
10.05.200821,691
17.05.200839,741
24.05.200850,791

Pre-tax Annual Cash-on-cash return

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Pre-tax Annual Cash-on-cash return 1,138 3,322 + 2,184 % Maximize Annual Return on Investment
Description The annual total cash received by the Investor divided by the total investment in the property (before taxes), multiplied by 100

Graph for Pre-tax Annual Cash-on-cash return

Graph for Pre-tax Annual Cash-on-cash return

Data for Pre-tax Annual Cash-on-cash return

DatesWeightMinMaxValue
05.04.20084171,138
12.04.20084173,508
19.04.20084176,736
26.04.20084175,488
03.05.20084176,664
10.05.20084171
17.05.20084172,812
24.05.20084173,322

Pre-tax Annual Cash Flow

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Pre-tax Annual Cash Flow 2,38 3,924 + 1,544 % Maximize Annual Return on Investment
Description The total cash returned to the Investor during the calendar year, after financing costs, but before taxes.

Graph for Pre-tax Annual Cash Flow

Graph for Pre-tax Annual Cash Flow

Data for Pre-tax Annual Cash Flow

DatesWeightMinMaxValue
05.04.20083152,38
12.04.20083152,084
19.04.20083151,632
26.04.20083151,476
03.05.20083154,672
10.05.20083151,08
17.05.20083154,616
24.05.20083153,924

Post-tax Annual Cash Flow

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Post-tax Annual Cash Flow 3,035 2,115 -0,92 % Maximize Annual Return on Investment
Description The total cash returned to the Investor during the calendar year, after financing costs and taxes.

Graph for Post-tax Annual Cash Flow

Graph for Post-tax Annual Cash Flow

Data for Post-tax Annual Cash Flow

DatesWeightMinMaxValue
05.04.2008313,53,035
12.04.2008313,53,0325
19.04.2008313,51,385
26.04.2008313,53,4975
03.05.2008313,51,5
10.05.2008313,52,7575
17.05.2008313,51,045
24.05.2008313,52,115

Monthly Return on Investment

  Name Start value End value Dynamic Parent Contains
Root Monthly Return on Investment 41,39 % 53,67 % + 12,28% Real Estate Investment
Indicators
Pre-tax Monthly Cash-on-cash return
Pre-tax Monthly Cash Flow
Post-tax Monthly Cash Flow

Graph for Monthly Return on Investment

Graph for Monthly Return on Investment

Data for Monthly Return on Investment

DatesValueWeight
05.04.200841,391
12.04.200848,511
19.04.200828,761
26.04.200844,651
03.05.200843,661
10.05.200858,071
17.05.200834,151
24.05.200853,671

Pre-tax Monthly Cash-on-cash return

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Pre-tax Monthly Cash-on-cash return 2,56 3,106 + 0,546 % Maximize Monthly Return on Investment
Description The monthly total cash received by the Investor divided by the total investment in the property (before taxes), multiplied by 100

Graph for Pre-tax Monthly Cash-on-cash return

Graph for Pre-tax Monthly Cash-on-cash return

Data for Pre-tax Monthly Cash-on-cash return

DatesWeightMinMaxValue
05.04.20084172,56
12.04.20084172,08
19.04.20084174,198
26.04.20084176,37
03.05.20084171,78
10.05.20084175,638
17.05.20084173,04
24.05.20084173,106

Pre-tax Monthly Cash Flow

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Pre-tax Monthly Cash Flow 2,976 2,788 -0,188 % Maximize Monthly Return on Investment
Description The total cash returned to the Investor during the calendar month, after financing costs, but before taxes.

Graph for Pre-tax Monthly Cash Flow

Graph for Pre-tax Monthly Cash Flow

Data for Pre-tax Monthly Cash Flow

DatesWeightMinMaxValue
05.04.20083152,976
12.04.20083154,88
19.04.20083151,04
26.04.20083151,036
03.05.20083154,316
10.05.20083152,592
17.05.20083153,352
24.05.20083152,788

Post-tax Monthly Cash Flow

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Post-tax Monthly Cash Flow 2,3475 3,185 + 0,837 % Maximize Monthly Return on Investment
Description The total cash returned to the Investor during the average month, after financing costs and taxes.

Graph for Post-tax Monthly Cash Flow

Graph for Post-tax Monthly Cash Flow

Data for Post-tax Monthly Cash Flow

DatesWeightMinMaxValue
05.04.2008313,52,3475
12.04.2008313,52,0175
19.04.2008313,51,595
26.04.2008313,51,715
03.05.2008313,52,1325
10.05.2008313,52,2675
17.05.2008313,51,2425
24.05.2008313,53,185

Price to Income

  Name Start value End value Dynamic Parent Contains
Root Price to Income 51,08 % 49,66 % -1,42% Real Estate Investment
Indicators
GRM
Rent Ratio
Cap rate

Graph for Price to Income

Graph for Price to Income

Data for Price to Income

DatesValueWeight
05.04.200851,082
12.04.200849,962
19.04.200866,462
26.04.200859,682
03.05.200835,962
10.05.200871,392
17.05.200856,072
24.05.200849,662

GRM

  Name Start value End value Dynamic Measure units Optimization method Parent
Root GRM 79,875 71,335 -8,54 Score Maximize Price to Income
Description The price of a property divided by its annual rental income before all expenses (property taxes, property management, insurance, etc.).
Target description [GRM]

Graph for GRM

Graph for GRM

Data for GRM

DatesWeightMinMaxValue
05.04.200846510079,875
12.04.200846510075,955
19.04.200846510088,765
26.04.200846510092,44
03.05.200846510065,91
10.05.200846510097,2
17.05.200846510081,485
24.05.200846510071,335

Rent Ratio

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Rent Ratio 0,72596 1,18824 + 0,462 % Maximize Price to Income
Description The monthly rental income for a property divided by its price, multiplied by 100.

Graph for Rent Ratio

Graph for Rent Ratio

Data for Rent Ratio

DatesWeightMinMaxValue
05.04.200830,031,30,72596
12.04.200830,031,31,16792
19.04.200830,031,30,7158
26.04.200830,031,30,46942
03.05.200830,031,31,07902
10.05.200830,031,30,3983
17.05.200830,031,30,411
24.05.200830,031,31,18824

Cap rate

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Cap rate 2,8052 2,5558 -0,249 % Maximize Price to Income
Description The property’s actual Net Operating Income (NOI) divided by its price, multiplied by 100

Graph for Cap rate

Graph for Cap rate

Data for Cap rate

DatesWeightMinMaxValue
05.04.200831,142,8052
12.04.200831,142,1208
19.04.200831,143,333
26.04.200831,142,8342
03.05.200831,142,0802
10.05.200831,143,6027
17.05.200831,143,8289
24.05.200831,142,5558

Risk metrics

  Name Start value End value Dynamic Parent Contains
Root Risk metrics 1,28 % 31,74 % + 30,46% Real Estate Investment
Indicators
Value at risk
Capital adequacy ratio

Graph for Risk metrics

Graph for Risk metrics

Data for Risk metrics

DatesValueWeight
05.04.20081,282
12.04.200878,682
19.04.200863,862
26.04.200872,782
03.05.200818,242
10.05.200888,382
17.05.200839,522
24.05.200831,742

Value at risk

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Value at risk 11,968 9,948 -2,02 Score Minimize Risk metrics
Description The largest amount of capital that a company risks losing with a given level of confidence
Target description Mln

Graph for Value at risk

Graph for Value at risk

Data for Value at risk

DatesWeightMinMaxValue
05.04.2008681211,968
12.04.200868129,096
19.04.200868128,492
26.04.200868128,972
03.05.2008681211,056
10.05.200868128,172
17.05.200868129,432
24.05.200868129,948

Capital adequacy ratio

  Name Start value End value Dynamic Measure units Optimization method Parent
Root Capital adequacy ratio 5,3 5,36 + 0,06 % Maximize Risk metrics
Description The amount of capital that must be held in relation to risk-weighted assets

Graph for Capital adequacy ratio

Graph for Capital adequacy ratio

Data for Capital adequacy ratio

DatesWeightMinMaxValue
05.04.200845205,3
12.04.2008452018,17
19.04.200845209,215
26.04.2008452015,26
03.05.200845206,53
10.05.2008452016,61
17.05.200845205,375
24.05.200845205,36
Created by: AKS-Labs
Report created with Balanced Scorecard Designer at 28.04.2008 23:57:12

Copyright © 2000-2008 AKS-Labs. All rights reserved.