Docstoc

Business Template - Take Over Property

Document Sample
Business Template - Take Over Property Powered By Docstoc
					Property Takeover Model New Sublettings Takeover Date NIA Headlease Rent £30.00 /sf 1 May 06 30,000 sq ft NIA Init Rent Serv Chg % Fitout Fitout in £ Lease Fee Lease Fee £ Lease Start Rent Free Rent Start Term Expiry First relet First refit First relet fee Rent Rent Out Rent In NPV Net Rent (3,535,336) (£117.8 /sf) Rates Out Tenant 1 15,000 sq ft £30.00 /sf 50.00% £30.00 /sf 450,000 £1.50 /sf 22,500 1 May 07 3 months 1 Aug 07 5 years 1 Aug 12 1 Aug 13 300,000 22,500 Tenant 2 ######## £30.00 /sf 50.00% £30.00 /sf 450,000 £1.50 /sf 22,500 1 May 07 3 months 1 Aug 07 5 years 1 Aug 12 1 Aug 13 300,000 22,500 Market Rent Mkt Rent Growth 2.00% 3.00% £30.00 /sf From Dates 1 Jan 05 1 Jan 07 Inflation Inflation 2.00% 3.00% From Dates 1 Jan 05 1 Jan 07 Rates Rates Multiplier 42.00% General StartDate Base ProjMode DayCount Periods 1 Jan 06 3 months 1 6 13

Reviews 1 Jan 10

Rent Start 1 May 06 Expiry Or Break 1 Jan 27 Dilaps (£ of Today) £20.00 /sf Review Months 60 months Review Discount -5%

Reletting Term Void RentFree Refit Dilaps Relet Fees Rates Rates In Tenant 1 Tenant 2

5 years 12 months 6 months £20.00 /sf £40.00 /sf £1.50 /sf

Service Charge DayCount Periods Ann Amt First SC Rev

6 4 240,000 1 Jan 05

NPV Discount Rate NPV Date

6% 1 May 06

Service Charge Net Rates (1,117,219) (£37.2 /sf) SC Out Service Charge In Tenant 1 Tenant 2 Net SC (751,666) (£25.1 /sf) Fitout

Other Expenses Letting Fees Dilap adations Net Other ####### (£88.0 /sf)

Total

####### #######

1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr 1 Jul 1 Oct 1 Jan 1 Apr

06 06 06 06 07 07 07 07 08 08 08 08 09 09 09 09 10 10 10 10 11 11 11 11 12 12 12 12 13 13 13 13 14 14 14 14 15 15 15 15 16 16 16 16 17 17 17 17 18 18 18 18 19 19 19 19 20 20 20 20 21 21 21 21 22 22 22 22 23 23 23 23 24 24 24 24 25 25 25 25 26 26 26 26 27 27

(358,516) (225,000) (225,000) (225,000) (225,000) (225,000) (225,000) (225,000) (225,000) (225,000) (225,000) (225,000) (225,000) (225,000) (241,606) (243,007) (243,007) (243,007) (243,007) (243,007) (243,007) (243,007) (243,007) (243,007) (243,007) (243,007) (243,007) (243,007) (243,007) (243,007) (243,007) (243,007) (243,007) (243,007) (278,701) (281,711) (281,711) (281,711) (281,711) (281,711) (281,711) (281,711) (281,711) (281,711) (281,711) (281,711) (281,711) (281,711) (281,711) (281,711) (281,711) (281,711) (281,711) (281,711) (323,129) (326,581) (326,581) (326,581) (326,581) (326,581) (326,581) (326,581) (326,581) (326,581) (326,581) (326,581) (326,581) (326,581) (326,581) (326,581) (326,581) (326,581) (326,581) (326,581) (374,551) (378,596) (378,596) (378,596) (378,596) (378,596) (378,596) (378,596) (29,446)

180,928 112,500 112,500 112,500 112,500 112,500 112,500 112,500 112,500 112,500 112,500 112,500 112,500 112,500 112,500 112,500 112,500 112,500 122,991 50,998

180,928 112,500 112,500 112,500 112,500 112,500 112,500 112,500 112,500 112,500 112,500 112,500 112,500 112,500 112,500 112,500 112,500 112,500 122,991 50,998

(358,516) (225,000) (225,000) (225,000) (225,000) 136,856

82,153 142,189 142,189 142,189 142,189 142,189 142,189 142,189 142,189 142,189 142,189 142,189 142,189 142,189 142,189 142,189 142,189 142,189 55,703

82,153 142,189 142,189 142,189 142,189 142,189 142,189 142,189 142,189 142,189 142,189 142,189 142,189 142,189 142,189 142,189 142,189 142,189 55,703

98,883 169,781 169,781 169,781 169,781 169,781 169,781 169,781 169,781 169,781 169,781 169,781 169,781 169,781 169,781 169,781 169,781 169,781 66,512

98,883 169,781 169,781 169,781 169,781 169,781 169,781 169,781 169,781 169,781 169,781 169,781 169,781 169,781 169,781 169,781 169,781 169,781 66,512

117,131 202,727 202,727 202,727 15,768

117,131 202,727 202,727 202,727 15,768

(16,606) (18,007) (18,007) (18,007) (18,007) (18,007) (18,007) (18,007) (18,007) 2,975 (141,011) (243,007) (243,007) (243,007) (243,007) (243,007) (78,700) 41,370 41,370 41,370 5,676 2,666 2,666 2,666 2,666 2,666 2,666 2,666 2,666 2,666 2,666 2,666 2,666 2,666 (170,306) (281,711) (281,711) (281,711) (281,711) (281,711) (125,363) 12,981 12,981 12,981 12,981 12,981 12,981 12,981 12,981 12,981 12,981 12,981 12,981 12,981 12,981 12,981 12,981 12,981 (193,557) (326,581) (374,551) (378,596) (378,596) (378,596) (144,334) 26,857 26,857 26,857 2,089

(64,436) (97,182) (97,182) (95,070) (98,288) (99,368) (99,368) (98,019) (100,960) (102,069) (102,069) (100,124) (104,274) (105,419) (105,419) (103,128) (101,739) (102,857) (102,857) (100,621) (104,791) (105,943) (105,943) (104,505) (107,640) (108,823) (108,823) (106,749) (111,173) (112,395) (112,395) (109,951) (114,508) (115,766) (115,766) (113,250) (117,943) (119,239) (119,239) (117,621) (121,150) (122,481) (122,481) (120,147) (125,126) (126,501) (126,501) (123,751) (128,880) (130,296) (130,296) (127,464) (132,746) (134,205) (134,205) (132,384) (136,355) (137,853) (137,853) (135,226) (140,830) (142,378) (142,378) (139,283) (145,055) (146,649) (146,649) (143,461) (149,407) (151,049) (151,049) (148,999) (153,469) (155,155) (155,155) (152,198) (158,506) (160,248) (160,248) (156,764) (163,261) (165,055) (165,055)

42,708 59,135 59,135 19,712 60,909 60,909 60,909 20,303 62,736 62,736 62,736 20,912 61,211 61,211 61,211 20,404 63,047 63,047 63,047 21,016 64,939 7,215

42,708 59,135 59,135 19,712 60,909 60,909 60,909 20,303 62,736 62,736 62,736 20,912 61,211 61,211 61,211 20,404 63,047 63,047 63,047 21,016 64,939 7,215

59,455 66,887 22,296 68,894 68,894 68,894 22,965 70,960 70,960 70,960 23,653 73,089 73,089 73,089 24,363 75,282 75,282 75,282 25,094 77,540 8,616

59,455 66,887 22,296 68,894 68,894 68,894 22,965 70,960 70,960 70,960 23,653 73,089 73,089 73,089 24,363 75,282 75,282 75,282 25,094 77,540 8,616

70,992 79,867 26,622 82,263 82,263 82,263 27,421 84,730 84,730 84,730 28,243 87,272 87,272 87,272 29,091 89,891 89,891 89,891 29,964 92,587 10,287

70,992 79,867 26,622 82,263 82,263 82,263 27,421 84,730 84,730 84,730 28,243 87,272 87,272 87,272 29,091 89,891 89,891 89,891 29,964 92,587 10,287

84,769 95,365 31,788 98,226 98,226 98,226 (49,113)

84,769 95,365 31,788 98,226 98,226 98,226 (49,113)

(64,436) (97,182) (97,182) (95,070) (12,871) 18,902 18,902 (58,596) 20,858 19,748 19,748 (59,518) 21,198 20,053 20,053 (61,304) 20,683 19,565 19,565 (59,814) 21,304 20,152 20,152 (62,473) 22,238 (94,392) (108,823) (106,749) (111,173) 6,516 21,379 (65,360) 23,279 22,021 22,021 (67,321) 23,977 22,681 22,681 (70,314) 25,029 23,697 23,697 (71,421) 25,438 24,063 24,063 (73,563) 26,201 (113,065) (130,296) (127,464) (132,746) 7,780 25,528 (79,139) 28,170 26,672 26,672 (80,384) 28,630 27,083 27,083 (82,796) 29,489 27,895 27,895 (85,280) 30,374 28,732 28,732 (89,072) 31,706 (134,580) (155,155) (152,198) (158,506) 9,290 30,482 (93,188) 33,190 31,396 31,396 (98,226)

(41,024) (61,200) (61,200) (62,424) (62,424) (62,424) (62,424) (64,297) (64,297) (64,297) (64,297) (66,226) (66,226) (66,226) (66,226) (68,212) (68,212) (68,212) (68,212) (70,259) (70,259) (70,259) (70,259) (72,367) (72,367) (72,367) (72,367) (74,538) (74,538) (74,538) (74,538) (76,774) (76,774) (76,774) (76,774) (79,077) (79,077) (79,077) (79,077) (81,449) (81,449) (81,449) (81,449) (83,893) (83,893) (83,893) (83,893) (86,409) (86,409) (86,409) (86,409) (89,002) (89,002) (89,002) (89,002) (91,672) (91,672) (91,672) (91,672) (94,422) (94,422) (94,422) (94,422) (97,255) (97,255) (97,255) (97,255) (100,172) (100,172) (100,172) (100,172) (103,177) (103,177) (103,177) (103,177) (106,273) (106,273) (106,273) (106,273) (109,461) (109,461) (109,461) (109,461)

20,922 31,212 31,212 32,148 32,148 32,148 32,148 33,113 33,113 33,113 33,113 34,106 34,106 34,106 34,106 35,129 35,129 35,129 35,129 36,183 36,183 12,192

20,922 31,212 31,212 32,148 32,148 32,148 32,148 33,113 33,113 33,113 33,113 34,106 34,106 34,106 34,106 35,129 35,129 35,129 35,129 36,183 36,183 12,192

(41,024) (61,200) (61,200) (62,424) (20,579)

(900,000)

(45,000)

(945,000)

24,711 37,269 38,387 38,387 38,387 38,387 39,538 39,538 39,538 39,538 40,725 40,725 40,725 40,725 41,946 41,946 41,946 41,946 43,205 43,205 14,558

24,711 37,269 38,387 38,387 38,387 38,387 39,538 39,538 39,538 39,538 40,725 40,725 40,725 40,725 41,946 41,946 41,946 41,946 43,205 43,205 14,558

(47,982) (72,367) (74,538) (74,538) (25,116)

(758,339)

(56,875)

(815,214)

29,506 44,501 45,836 45,836 45,836 45,836 47,211 47,211 47,211 47,211 48,627 48,627 48,627 48,627 50,086 50,086 50,086 50,086 51,589 51,589 17,383

29,506 44,501 45,836 45,836 45,836 45,836 47,211 47,211 47,211 47,211 48,627 48,627 48,627 48,627 50,086 50,086 50,086 50,086 51,589 51,589 17,383

(57,293) (86,409) (89,002) (89,002) (29,990)

(879,123)

(65,934)

(945,057)

(1,019,144)

(76,436)

#######

35,232 53,136 54,730 54,730 54,730 54,730

35,232 53,136 54,730 54,730 54,730 54,730

(68,411) (103,177) (106,273) (106,273) (35,809)

(1,127,447) #######

(463,977) (383,382) (383,382) (382,494) ####### 155,757 18,902 (58,596) 20,858 19,748 19,748 (59,518) 21,198 20,053 3,446 (79,310) 2,677 1,559 1,559 (77,820) 3,297 2,145 2,145 (59,498) (118,773) (385,381) (424,196) (424,293) (428,717) ####### (57,320) (23,989) 64,650 63,391 27,697 (64,655) 26,643 25,347 25,347 (67,648) 27,695 26,363 26,363 (68,755) 28,103 26,728 26,728 (70,897) (144,105) ####### (498,417) (498,177) (503,459) (303,921) (99,835) (66,159) 41,151 39,652 39,652 (67,404) 41,611 40,063 40,063 (69,815) 42,470 40,876 40,876 (72,299) 43,354 ####### 41,713 (76,091) (161,851) (529,572) (632,883) (637,067) (643,375) (405,116) (113,852) (66,330) 60,048 58,254 33,485 #######


				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:197
posted:2/10/2008
language:English
pages:1