| Templates- These free Excel 2000/2003 spreadsheets are made available 'as is', without any warranty or liability, express or implied. You are free to use, alter and distribute them as you wish.
- It is straightforward to copy sections of the models to your own models, although where we have used range names to make the formulae clearer, you might need to alter or re-create these in your own model.
- They are also designed for you to build on yourself, and to demonstrate techniques. They are not supposed to be 'black boxes'.
- All the models are set to Manual Recalculation (F9 to recalculate as usual). You can change this in Excel/Tools/Options/Calculation.
- Input cells are coloured blue , output cells are yellow.
- There's a screenshot of the worksheet if you click on the
 emblem.
Recently Updated Templates| Category | | Template Name | Description | Filename | Updated |
|---|
| Real Estate |  | 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 | 2008-02-19 | | Accounting | | Capital Gains Using LIFO | Calculating the capital gains for UK tax is surprisingly complex, requiring you to match sales and purchases on a LIFO (last in first out) basis. To be honest, without this template, I can"t do my tax! | cgt.xls | 2007-10-10 | | Real Estate | | 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 | 2007-09-13 | | Real Estate | | 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 | 2006-11-18 | | Non Business Functions | | Bullet Chart | Little worksheet that does a bullet chart, similar to originally proposed by Edward Tufte and implemented in Excel by Charley Kyd. | bullet.xls | 2006-11-16 | | Real Estate | | Occupancy Costs | Useful worksheet to show a tenant the difference in occupancy costs over an extended period of time. | occupancycosts.xls | 2006-11-16 | | Techniques | | How to Call Business Functions from VBA | A few examples of how to do your own custom wrapper functions that call BF. | callfromvba.xls | 2006-11-02 | | Finance | | Business Plan Cashflow | No two Business Plans are the same, and one size does not fit all. However, here"s a business plan cashflow that could give you some ideas and get you started. | businessplancashflow.xls | 2006-10-26 | | Accounting | | Depreciation | Simple example of BF"s depreciation functions | depreciation.xls | 2006-10-26 | | Loans | | Loan Amortisation with the LoanX Function | Very simple loan amortisation, although it does have interest rollup if required | loan_amortisation_with_loanx.xls | 2006-10-26 |
|
