Note: In order to use the spreadsheet examples, you need to download Business Functions
|CapValueGD (ValuationDate, Yield, FromDates, AnnRents, [CostsPerc], [PmtsPerYearOpt], [CapOptions])|
|Cap Value (UK Real Estate Conventional Math), extended version, extended version|
|Capitalised Value of a rental stream (using Conventional Math) This is the extended version, with additional inputs for more control. This is the extended version, with additional inputs for more control.|
Note that it is ANNUAL RENTAL RATES that are specified. Sometimes you might want to use this function on a quarterly cash flow. If you do you need to multiply the rents up accordingly, as the math for this function ALWAYS ASSUME ANNUAL RATES OF RENT.
TemplatesThis function features in the following downloadable spreadsheet template(s):