Excel Examples

Listed below are a number of useful Excel Templates on a number of topics that you can download for free. They provide real working examples for your benefit but also demonstrate Excel features that can be used in Excel design.

Financial:

Home Loan Simulator -This spreadsheet calculates the loan repayments due for any borrowed amount you care to enter. This simple but effective model allows you to simulate changes in interest rates and the term length and see the impact.Excel Features: Demonstrates the PMT financial function and is an excellent example of an Excel spin button (to change the term) and an Excel scroll bar (to change the interest rate) for use by users. Home_Loan_Simulator.xls

Balance Sheet with Ratios - This spreadsheet is a good example of a Balance Sheet layout together with various financial ratios. Excel Features: Good demonstration of the Quick, Current, Cash and Working Capital ratios. Balance_sheet_with_ratios.xls
 
Project Financial Analysis - This spreadsheet analyses the cashflow financial impact of a project. Excel Features: Demonstrates the Net Present Value (NPV) and Internal Rate of Return (IRR) financial functions, calculates a Return on Investment (ROI) and a Payback Period. This is an excellent example of these project financial functions. Project_Financial_Analysis.xls


Organisational:

Expense Clain Form- This spreadsheet provides a ready made form to use for expense claims. Expense_Claim_Form.xls

Special Characters in Excel- This spreadsheet provides a list of the special characters that you can have easily in any version of Excel using the fonts of Wingdings and Webdings. Excel Features: Excellent demonstration of these special characters which are extremely useful and highly recommended.  Special_Characters_in_Excel.xls


Personal:

Personal Budget- This spreadsheet provides a personal budget for people to track their expenditure. The various categories prompts people to allow better budgeting and better understand the key elements of their expenditure.Personal_Budget.xls 

Other:

Panel Calculator for Sliding Doors- This spreadsheet gives a good example of what is possible in spreadsheet design. The calculator provides a marketing advantage to a supplier of sliding door fittings to assist the customer in knowing what specific parts to buy for the particular configuration. Tomma_Panel_Calculator.xls