Business Functions Library for Excel

    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. Turnover Rent (Simple)
    12. Office Rent Roll
    13. Retail Turnover Rent Roll
    14. Indexed Rent
    15. DCF Lease Appraisal
    16. 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
Note: In order to use the spreadsheet examples, you need to download Business Functions, except where it says 'Non Business Functions' which just uses plain Excel.

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!
Download: cgt.xls

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