Business Template - Simple Residual Valuation

Document Sample
Business Template - Simple Residual Valuation Powered By Docstoc
					Residual Appraisal Analysis - Commercial Office Building
Yield Yield Type Interest AER NIA 5.00% 1 6.00% 100,000 sf True Yield

Profit Interest Fees

Site Acquisition Land Prep Site Shell & Core Developers Finish RentPaying

Timing
Start On Site Lease-up Period Rent Free 1 Jan 07 6 months 12 months Duration Start End Shape (How Cost Distibuted) -100.00 -100.00 +0.50 +0.50 +0.50

Building

Jan 07

Jan 08

Costs
Land: Site Acquisition Prep Site Building: Shell & Core Developers Finish Fitout Practical Completion/Loan Repayment Fees: Fees Architect Leasing

£'000's Cost £/sf £50.00 /sf £10.00 /sf £150.00 /sf £30.00 /sf £50.00 /sf Cost £'000's (5,000) (1,000) (6,000) (15,000) (3,000) (5,000) (23,000) Interest Thereon #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME?

12 months 18 months 6 months 6 months #NAME? 5.00% £5.00 /sf On Land On Building

1 Jan 07 #NAME? #NAME? #NAME? #NAME?

#NAME? #NAME? #NAME? #NAME? #NAME?

(6,000)

#NAME? #NAME? #NAME?

(23,000)

on

(23,000)

(1,150) (500) (1,650) #NAME? #NAME? #NAME?

Interest

Value
Rents Value net of Selling Costs Selling Costs £30.00 /sf #NAME? 3.00%

£'000's 3,000

From #NAME?

=CapValueGD(E26,$E$4,$G$33:$G$34,$E$33:$E$34,$E$37,4,$E$5) #NAME? #NAME?

#VALUE! Equivalent Yield
Profit as at . . . . . . . . . . . . . . On Value . . . . . . . . . . . . . . . On Profit . . . . . . . . . . . . . . . 1 Jan 07 . . . . . . . . . . . . . . . . . . . . . . . . . #NAME? . . . . . . . . . . . . . . . . . . . . . . . . . #NAME? #NAME? #NAME? #NAME?

. . . . . . . . .

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