Business Functions Library for Excel


Debug Mode

    1. Simple Loan
    2. Finance Lease
    3. Mortgage
    4. Loan Mortgage With Extra Capital Repayments
    5. Maximum Mortgage for given periodic repayment
    6. Scheduled Repayment loan
    7. Scheduled Repayment Loan with Interest Rollup
    8. Flexible Mortgage Loan with stepped payments
    1. US APR Convertor
    1. Simple Bond Issue
    1. Polynomial Curve Fit
    1. Simple Cash Flow
    1. Week Number (including ISO)
    1. Depreciation Schedule
    2. Depreciation Work In Progress
    3. Accounts Receivable
    4. Capital Gains Using LIFO
    1. Property Business Plan
    2. Why Business Functions For Property
    3. Property Loan
    4. DCF Analysis
    5. Stepped Rent
    6. Tenant Sheet
    7. Property Loan
    8. Occupancy Costs
    9. Lease Appraisal
    10. European Property Fund
    11. Office Rent Roll
    12. Retail Turnover Rent Roll
    13. Indexed Rent
    14. DCF Lease Appraisal
    15. Construction Budget and Loan
    1. Takeover Property
    2. Capital Value
    3. Equivalent Yield
    1. Oil and Gas Production Profile (Decline Curve)
    1. Methods Of Spreading Capital Expenditure
    2. Simple Projections
    3. BF GoalSeek demonstration
    4. How to Call Business Functions from VBA
    1. Bullet Chart

Welcome to the Samples Collection

There are 51 sample models written in Excel that cover most parts of the BF library. These samples were previously called templates because the idea is that you can use them and modify them as a basis for a model, or part of a model, you might be building. Use the tree menu on the left hand side to browse and download them.

Some of the models use manual recalculation and you need to press F9 to calculate them in Excel.

Business Functions phone: +44 (0)20 8144 9374 (London UK)
Website Design: Webpure