DCF Lease Appraisal

Reviews

Shared by: B Ryan

Tags

financial, excel, spreadsheets

Stats

views:: 248
rating:: not rated
reviews:: 0
posted:: 1/8/2008
language:: English
pages:: 0

Public Domain

DCF Lease Appraisal Very general DCF appraisal. Optionally, handles leases that have indexation as well as rack-rented and stepped rents. Has Cap Value at end based on market rent. Timebase based on rental payment dates or regular budget periods. Has all usual BF stuff: partial periods, selectable daycount, rental payment timing, etc. Data validation on inputs. Basic Assumptions Base As Rent Dates Start Proj. 1 Jan 05 Units 1,000 DayCount 6.03 Periods +13.00 #NAME? Market Rent NB. For a timebase as per the rental payments, input zero, otherwise, put in a value eg 3 or 12 months rent Market #NAME? Growth Dates 1 Jan 05 £20.00 /sf Growth Rates 2.00% Discounting Discount Rate NPV Date DayCountDisc PeriodsDisc Cap Rate 6.00% 1 Jan 06 6.00 Defaulted 5.00% #NAME? Indexation (if/where applied) Index Index Growth Dates Growth Rates 1 Jan 05 2.00% Reletting Void Rent Fee Relet Term Market Review Mechanism RevMonths RevDisc 60 months (0.00% ) The length of time inbetween market reviews Upwards Only, 0.00% discount. 12 months 6 months 10 years The Standard Lease NIA Lease Start Rent Free Rent Start Term Expiry/Break Break Penalty Rents #NAME? 50,000 sq ft 1 Jan 06 12 months #NAME? 20 years #NAME? £20.00 /sf Reviews #NAME? #NAME? My Deal NIA Lease Start Rent Free Rent Start Term Expiry/Break Break Penalty 50,000 sq ft 1 Jan 06 12 months #NAME? 15 years #NAME? £20.00 /sf Reviews #NAME? #NAME? #NAME? Indexation Regularity (If Any) Rents £20.00 /sf £30.00 /sf Indexation Regularity (If Any) 12 months Inducements £20.00 /sf Date 1 Jan 06 Inducements £20.00 /sf Date 1 Jan 06 NPV #NAME? #NAME? Inducements #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? Rent #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? Total #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? Inducements #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? Rent #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? Total #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? DCF Lease Appraisal Very general DCF appraisal. Optionally, handles leases that have indexation as well as rack-rented and stepped rents. Has Cap Value at end based on market rent. Timebase based on rental payment dates or regular budget periods. Has all usual BF stuff: partial periods, selectable daycount, rental payment timing, etc. Data validation on inputs. Basic Assumptions Base As Rent Dates Start Proj. 1 Jan 05 Units 1,000 DayCount 6.03 Periods +13.00 #NAME? Market Rent NB. For a timebase as per the rental payments, input zero, otherwise, put in a value eg 3 or 12 months rent Market #NAME? Growth Dates 1 Jan 05 £20.00 /sf Growth Rates 2.00% Discounting Discount Rate NPV Date DayCountDisc PeriodsDisc Cap Rate 6.00% 1 Jan 06 6.00 Defaulted 5.00% #NAME? Indexation (if/where applied) Index Index Growth Dates Growth Rates 1 Jan 05 2.00% Reletting Void Rent Fee Relet Term Market Review Mechanism RevMonths RevDisc 60 months (0.00% ) The length of time inbetween market reviews Upwards Only, 0.00% discount. 12 months 6 months 10 years The Standard Lease #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? My Deal #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? DCF Lease Appraisal Very general DCF appraisal. Optionally, handles leases that have indexation as well as rack-rented and stepped rents. Has Cap Value at end based on market rent. Timebase based on rental payment dates or regular budget periods. Has all usual BF stuff: partial periods, selectable daycount, rental payment timing, etc. Data validation on inputs. Basic Assumptions Base As Rent Dates Start Proj. 1 Jan 05 Units 1,000 DayCount 6.03 Periods +13.00 #NAME? Market Rent NB. For a timebase as per the rental payments, input zero, otherwise, put in a value eg 3 or 12 months rent Market #NAME? Growth Dates 1 Jan 05 £20.00 /sf Growth Rates 2.00% Discounting Discount Rate NPV Date DayCountDisc PeriodsDisc Cap Rate 6.00% 1 Jan 06 6.00 Defaulted 5.00% #NAME? Indexation (if/where applied) Index Index Growth Dates Growth Rates 1 Jan 05 2.00% Reletting Void Rent Fee Relet Term Market Review Mechanism RevMonths RevDisc 60 months (0.00% ) The length of time inbetween market reviews Upwards Only, 0.00% discount. 12 months 6 months 10 years The Standard Lease #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? My Deal #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? Cap Value > Cap Value >