Real Estate |
Rent Rolls;Retail Rent;Investment Models;Lease Appraisal |
| Template Name | Description | Filename |
|---|
 | DCF Analysis | Simple little spreadsheet that does an IRR and an NPV |  dcfanalysis.xls |
| European Property Fund | Models rental properties and the European holding company structure that owns them, consolidating the whole to a fund level cash flow, profit and loss and balance sheet. Deals with taxes, group relief, indexed rents, loans etc | propfund.xls |
| Lease Appraisal | Quite a beefed up lease appraisal worksheet, where you can compare the value of the plan as against various deals, fow a whole building. Quite a lot of numbers here, but the principle is relatively simple. The leases can be the usual rack rent (5 yearly reviews) or annual indexation, or a mixture of both. | leaseappraisal.xls |
| Occupancy Costs | Useful worksheet to show a tenant the difference in occupancy costs over an extended period of time. | occupancycosts.xls |
| Property Business Plan | Our slowly evolving all singing property model. Not for the faint-hearted, this is our industry strength model we use in practise. Its either really useful for you or will will confuse you totally. Its more of a property project model rather than a company model, since it doesn"t yet do P and L or Balance Sheet. We use it for our assignments and adjust it for specific situations. | PropCo.xls |
| Property Loan | Meant to be an all singing Construction Loan model, it may have partially succeeded. What it does thats reasonably clever is to update the forecast for actuals to date. | property_loan.xls |
| Property Loan | Property Loan, Fairly conventional loan placed alongside the rental income | loan_property.xls |
| Really Simple Lease Analysis | Very basic DCF of a lease | reallysimpleleaseanalysis.xls |
| Simple DCF Analysis | There"s a couple of other DCF lease appraisals on the site, here"s another. | simpledcfanalysis.xls |
| Simple Rent Roll | Nice simple rent roll, reasonably presented. Shows the virtue of a array-entered rent function (and its got a pretty graph). | simplerentroll.xls |
| Stepped Rent | Very, very basic stepped rent, stepped anything, in fact. | steppedrent.xls |
| Tenant Sheet | Example of a sheet-to-a-tenant cashflow | tenantsheet.xls |
| Turnover Rent (Simple) | A simpler version of a retail rent roll. The turnover percentages depend on turnover thresholds, but not on time. This makes it a good deal simpler and you can have a line per tenant, by far the most efficient way of doing a rent roll. | turnrent2.xls |
| Why Business Functions For Property | Ah, this is a one-off. It demonstrates a few functins for rent, service charge, loans, equivalent yields etc and has a very pleasant little robotic voice t hat talks you through the demo thats on every workbook. It felt cute at the time. | whybusinessfunctionsforproperty.xls |
| Office Rent Roll | Plain vanilla rentroll schedule for office tenants | rentroll_office.xls |
| Retail Turnover Rent Roll | Generic, extendable, Rent Roll model for shopping centres | turnrent.xls |
| DCF Lease Appraisal | Compares the NPV of your Standard Lease to the deal you are offering. It copes with fixed stepped rents, inducements, indexation and reletting. It capitalises the value at the end of the cash flow. | dcfleaseappraisal.xls |
| Indexed Rent | Indexed rent model, such as exists on continental Europe. | idxrent.xls |
| Construction Budget and Loan | Does a Construction Loans allowing for update of costs against budget, changing interest rates, interest roll-up. Costs use S-curve function. Demonstrates an array function for merging timebases. | constructionloan.xls |
