Business Template - Office Rent Roll by Mythri

VIEWS: 372 PAGES: 5

									Office Rent Roll
Base Start Proj. DayCount Periods ProjMode Units
NB. For a timebase as per the rental payments, input zero, otherwise, put in a value eg 3 months Market Rent

1 Jan 05 6.03 +13.00 1 1,000
Main Period:Actual/Actual (Within Period),Stub Periods:Actual Days/365.

Growth Dates 1 Jan 05

Growth Rates 2.00%

in advance, English Quarter Days (25Mar,24Jun,29Sep,25Dec) o=Accruals, 1=Cash. Should almost always be CASH (1)

Reletting Relet Void Relet Rent Free Relet Term Review Months Total Rent 675 675 675 2,025

12 months 6 months 10 years 60 months 675 675 675 2,025 757 694 694 2,145

Indexation (where/if applied) Idx Growth Idx Growth Dates Rates 1 Jan 05 2.00%

Building 1 Building 2 Building 3 ...etc...

757 694 694 2,145

757 694 701 2,152

757 694 701 2,152

757 713 734 2,204

757 713 734 2,204

757 713 741 2,211

757 713 741 2,211

757 735 741 2,234

757 735 741 2,234

757 735 748 2,241

757 735 748 2,241

757 735 764 2,257

757 735 764 2,257

757 735 771 2,264

757 735 771 2,264

757 812 828 2,397

757 812 828 2,397

NIA

Lease Start

Rent Free

Rent Start

Expiry Or Break

Market Rent

Review Discount
For Upwards only

Rents

Reviews

Indexation Regularity (If Any)

Date... 25 Mar 05

24 Jun 05

29 Sep 05

25 Dec 05

25 Mar 06

24 Jun 06

29 Sep 06

25 Dec 06

25 Mar 07

24 Jun 07

29 Sep 07

25 Dec 07

25 Mar 08

24 Jun 08

29 Sep 08

25 Dec 08

25 Mar 09

24 Jun 09

29 Sep 09

25 Dec 09

25 Mar 10

Building: 1: Uses the TStepRentGrowR Function Tenant: A 75,000 sq ft Plain Rack Rented with Market Review at year 5 25 Dec 04 6 months 24 Jun 05 24 Jun 15 £20.00 /sf (0.00% )
Upwards Only

£18.00 /sf

25 Dec 05

338

338

382

382

382

382

382

382

382

382

382

382

382

382

382

382

382

382

382

382

Market Tenant: B 75,000 sq ft Fixed Stepped Rents going to market review at year 10 25 Dec 04 6 months 24 Jun 05 24 Jun 15 £20.00 /sf (0.00% )
Upwards Only

£18.00 /sf £20.00 /sf

25 Dec 05 25 Dec 15

338

338

375

375

375

375

375

375

375

375

375

375

375

375

375

375

375

375

375

375

Market Building: 2: Uses the TStepIdxRentGrowR Function, which can optionally cope with indexed as well as market reviews Tenant: A 75,000 sq ft Plain Rack Rented with Market Review at year 5 25 Dec 04 6 months 24 Jun 05 24 Jun 15 £20.00 /sf (0.00% )
Upwards Only

£18.00 /sf

25 Dec 09

338

338

338

338

338

338

338

338

338

338

338

338

338

338

338

338

338

338

414

414

Tenant: B 75,000 sq ft

Fixed Stepped Rents going to market review at year 3 25 Dec 04 6 months 24 Jun 05 24 Jun 15

£20.00 /sf

(0.00% )
Upwards Only

£18.00 /sf £19.00 /sf £20.00 /sf

25 Dec 05 25 Dec 06 25 Dec 07

338

338

356

356

356

356

375

375

375

375

398

398

398

398

398

398

398

398

398

398

Building: 3 Tenant: A 75,000 sq ft Increasing annually with RPI and reverting to market at year 5 25 Dec 04 6 months 24 Jun 05 24 Jun 15 £20.00 /sf (0.00% )
Upwards Only

£18.00 /sf

25 Dec 09

12 months

338

338

338

338

344

344

344

344

351

351

351

351

358

358

358

358

365

365

414

414

Tenant: B 75,000 sq ft

Fixed Steps years 1-2, market years 3-7, then RPI to expiry (!) 25 Dec 04 6 months 24 Jun 05 24 Jun 15

£20.00 /sf

(0.00% )
Upwards Only

£18.00 /sf £19.00 /sf

Market

25 Dec 05 25 Dec 06 25 Dec 08 24 Jun 15

338 12 months

338

356

356

356

356

390

390

390

390

390

390

390

390

406

406

406

406

414

414

Note: If you don't have an indexation reviews (ie plain rack-rented), you can use the simpler TStepRentGrowR function 75,000 sq ft 25 Dec 04 6 months 24 Jun 05 24 Jun 15 £20.00 /sf (0.00% )
Upwards Only

£18.00 /sf £19.00 /sf

Market

25 Dec 05 25 Dec 06 25 Dec 08 24 Jun 15

338

338

356

356

356

356

390

390

390

390

390

390

390

390

406

406

406

406

406

406

Base

12 months

Annual Summary Units 1,000 Period Commencing Jan 05 Jan 06 2,107 2,044 2,044 6,195 3,029 2,794 2,829 8,652 Jan 07 3,029 2,873 2,958 8,860 Jan 08 3,029 2,941 3,001 8,972

RENT1 RENT2 RENT3

Building 1 Building 2 Building 2 Total

Jan 09 3,029 3,018 3,134 9,181

Jan 10 757 812 828 2,397

Jan 11

Jan 12

Jan 13

Jan 14


								
To top