:: Templates:: Real Estate (UK Specific)

Real Estate (UK Specific)

Property worksheets designed specifically for the UK approach to valuation.

Template NameDescriptionFilename
Click For ScreenshotReal Estate MathSpreadsheet that I got quite obsessive about when I was comparing valyuation using the yield method and comparing it with DCF. Academics my like it.real_estate_math.xls
Click For ScreenshotSimple Residual ValuationSimple residual giving profit, equivalent yield etc.simpleresidual.xls
Click For ScreenshotTakeover PropertyModel for evaluating the exposure (as a landlord) incurred when you take over (take assignment) of another lease.uktakeover.xls
Click For ScreenshotCapital ValueIn the UK its common to use yield to value real estate, and where there are stepped rents the layer method (an extension of yield) is used. This worksheet uses a single Business Function, CapValueGD, to apply the layered yield method to calculate a property value, using either a True or Equivalent Yield.capvalue.xls
Click For ScreenshotEquivalent YieldIn the UK its common to use yield to value real estate, and where there are stepped rents the layer method (an extension of yield) is used. This worksheet uses a single Business Function, EqYieldGD, to calculate either a True or Equivalent yield for a given property value.eqyield.xls
153