Margill Interest calculation software for professionals

1. Click on when you are ready to go on to the next slide. Click for Next Click for Next Margill Interest calculation software for professionals • This 6 minute presentation outlines Margill’s major functions • Also see the “User’s manual”, the “FAQ” on www.margill.com and Margill’s “Tips and Tricks” for more... • In each slide, the animation will appear automatically. You can click with the mouse to go faster. • You can also take your time (why rush?) and look over the whole slide before going on to the next.

2. Click for Next Margill - The Basics • Windows based (3.1, 95, 98, NT, 2000, XP) • Single user or network versions available • Multi currency : $, €, £, F, ¥, R, DA, Rs... and any other Windows compatible currency • Based on the calendar (365 / 366 year)(Actual/actual day count) for total accuracy. • Coming Spring 04 : 30/360, Actual/360, Actual/365. • International and country-specific standards • Truth in Lending (USA) • European Community Directive 98/7/EC • Canadian rules • International actuarial method • Includes User manual (PDF) • Extremely robust for your simple and complex needs

3. Click for Next Who uses? How? • Lawyers, Courts of justice, Bailiffs • Fields : Litigation, labor, commercial, insurance, banking, real estate, M&A, investment, tax, municipal, liability, family • Court award calculations • Bill and award collection • Late, unpaid salaries, alimony, rent • Court award hypotheses (annuity or lump sum) • Real-estate calculations • Accountants / Tax specialists / Bookeepers • Track client line of credit and other banking transactions • Late income tax and tax payments (interest and fees) • Investment planning and hypotheses • Return on investment • Present value • Real-estate calculations, Leasing calculations • Law-related, complex calculations • Financial planners • Investment scenarios, comparisons, hypotheses and planning • Real-estate calculations for clients • Return on investment (ROI) • Real-estate professionalsMortgage brokers, RE managers, land developers, architects • Mortgage - regular, irregular, prepayments, various hypotheses • Mortage - variable interest rate • Late rent, court awards • Insurance companies • Court awards • Payment options (lump sum, regular payment (present value) • Investment tracking, hypotheses • Loan and financing companies Personal & corporate, Equipment, car & truck sales and leasing • Loan and repayment schedules (regular, irregular) • Payment options • Leasing options • Unions and employers • Late, unpaid salaries • Court awards • Companies (SME & large) • Bill collection and late payments • Lease calculations • Collection agencies • One-time interest • Payment schedules • Individuals • Track line of credit and other banking transactions • Loan and mortgage payment options and hypotheses • Investment options and returns • Government • Late payments to suppliers • Labor relations: late, unpaid salaries to employees • Court award calculations • Real-estate calculations

4. After a very simple 4-click installation procedure... Use in Demo mode - This is a full version, valid for 14 days from the date of installation If you then wish to purchase, first download the order form from www.margill.com and fax it. Then press “Send Email”. We will provide with you the permanent activation code by email. Our customer service is next to none! Click for Next Margill Startup 14

5. Click for Next The calculations • These calculations use variable interest rates • You may use variable rates + x% or - x% for all rates or starting at a certain date. • Tables included : • International Discount, Repo and Target interest rates, Legal interest rates • OR create and update your own tables in a snap.

6. Click for Next The calculations These calculations use a single interest rate that you specify

7. Click for Next 4 types of calculationsMultiple applications... • Simple interest • Total interest of one amount between two dates (loan with unique payment, court awards, etc.) • Compound interest • Total interest of one amount between two dates (loan with unique payment, court awards, tax penalties, etc.) • Recurring payments (Amortization) • VERY powerful calculation • Loans with repayments (regular or not), line of credit, mortgages, leases, bill collection, amortization schedules with missed payments, new capital or penalties during loan, simple or complex court awards with prepayments, fees, etc. • Accrual by installment • Regular or irregular capital installments that accrue over time (regular investments and interest), interest on unpaid salaries, rent or alimony, court awards, etc.)

8. Click for Next Other calculations • Present value (in which you may index the future installments) • Effective rate of return • Indexation of an amount (including depreciation and appreciation) based on indexation tables (inflation & CPI, stock market indices, etc.) • Nominal - effective interest rate converter • Date calculations • International sales tax calculator (a little extra our cients truly appreciate!)

9. Click for Next Interest and indexation tables • Interest rate tables included • United-States: Discount rate and IRS interest rates • Great-Britain: Repo rate • Canada: Target rate (preferential - overnight) • Quebec - Legal interest + additional indemnity (3 tables) • British Columbia - Legal interest (4 tables) • Australia: Cash rate and Aus. Taxation Office (ATO) legal rates • Europe: Key rates - Deposit facility - European Central Bank • Hong Kong: Base rate • France - Legal interest, rates for late payments • Belgium - Legal interest (3 tables) • Luxemburg - Legal interest • Indexation tables included • United States: Consumer Price Index (CPI) • Great-Britain: Retail Prices Index (RPI) • Australia: CPI • Canada: CPI • Quebec: Alimony indexation rates • France: Harmonised Consumer Price Index (HCPI) • Switzerland: CPI • Belgium: HCPI • Luxembourg: HCPI OR Create your own and update these in a snap, directly in Margill or from Excel or Word data

10. Choose between Normal - Actuarial method US Rule (Simple interest) Simple interest Multiple compounding periods Multiple regular payment periods including every x days OR totally irregular (you specify in the results screen) One interest rate or use a variable rate table Enter 2 of 3 variables and the last will be calculated automatically Coming Spring 2004: interest rate to be calculated automatically (enter 3 of 4 variables) Click for Next Recurring Payments (Amortization)Total power and versatility to YOU • Loans with repayments (regular or not), line of credit, mortgages, leases, bill collection, amortization schedules with missed payments, new capital or penalties during loan, simple or complex court awards with prepayments, fees, etc. • Edit the preliminary results screen in order to create your totally custom payment schedule (see example later)

11. Click for Next Recurring Payments (Amortization)Results screen $5000 payments in this example • You can edit this schedule as you want specifically • Change payments • Change dates • Add payments anywhere • Eliminate payments • Add new capital • Charge extra fees with interest (if without interest, add at end of table) • Change many lines at once: payment or interest rate

12. Example : Prepayments 3 payments changed to $8000 simultaneously Select lines with Ctrl key and mouse and right click to change all lines at once Any and all interest rates may also be changed at any time Click for Next Recurring Payments (Amortization)Results screen (edited) $5000 payments initially

13. If a variable interest rate table is used, the changing rates are reflected in the results screen Click for Next Recurring Payments (Amortization)Results screen (variable interest rates)

14. Table may be saved and continued as events occur Payment for May 1st is only $500 New capital added May 10 (minus $7500) Sept 1 payment is NSF check (minus $25 fee charged) Last payment changed to compensate Coming in Spring 2004: after changes to table, selected payments recalculated to give balance = 0. Click for Next Recurring Payments (Amortization)Results screen edited for irregular events $5000 payments initially Let’s look at a few events

15. Delete many lines at once Change payments or interest rates Even add x $ to each irregular payment or x% to the interest rates Upto that line or for selected lines Export Results to .TXT file or table directly to various formats Click for Next Power of the right mouse click

16. Multiple regular payment periods including every x days OR irregular (you specify in the results screen) End of period using date or number of installments (mouse right click) Use an indexation table (historic or predicted) to increase or decrease your installments over time Use the normal rule (interest on interest) or simple interest Click for Next Accrual by installment calculation Regular or irregular capital installments that accrue over time (regular investments and interest on these), interest on unpaid or late salaries, rent or alimony, court awards, etc.

17. Example : $1000 paid (accumulated) every 28 days Indexed to $1034 on January 1st 2001 Total accumulated so far Click for Next Accrual by installment calculationResults screen • You can edit this schedule to meet your needs • Change installments • Change dates • Add installments anywhere • Eliminate installments • Reduce capital (add negative installment) • Change many lines at once: interest rate, payment Same possibilities as the Recurring payments (Amortization) calculation See preceding slides

18.  Capitalize Rate table to use OR specify a fixed interest rate Variable rates + or - x% for the whole period OR as of Effective date For simple interest, it is possible to capitalize the interest at the loan anniversay date Click for Next Simple and compound interest Total interest of one amount between two dates (loan with unique payment, court awards, etc.)

19. Change of interest rates throughout the period based on the interest table Click for Next Simple and compound interest

20. Installments may include every x day intervals Installments may be indexed (for example, predicted cost of living inscrease if not already factored into the Discount rate) Installments may be changed at any set date Click for Next Present value

21. Annual rate of return Effective / nominal rate converter Enter Starting date, Amount invested, Ending date and Amount returned to obtain the Effective Rate OR Compounding at practically any frequency Click for Next Other useful calculations

22. Using a selected indexation table or newly created table Click for Next Other useful calculations Indexation of an amount In this example: approximate value in 2003 of a $10,000 investment in 1990 in the stock market (NASDAQ based-fund). We can see the peak $92,400 value in 2000 and the value in Jan. 2003 of $29,700. Indexation tables can be yearly, monthly, etc. to increase accuracy in values Can also be used for depreciation and appreciation calculations

23. Click for Next Finally... • Margill also contains other useful utilities : • Conversion of payments to an indexation table • Various date calculations • Sales tax calculations • For further examples and concrete applications, consult the FAQ section of www.margill.com, the User’s manual and the Margill Tips & Tricks

24. Conclusion • Margill’s versatility makes it an indispensible tool for hundreds of companies and professionals. • Over 2500 installations in North America, Europe and the Middle East. Margill is also used in Asia and Australia • Order and support • Prices and Order form : www.margill.com/buy-en.asp • Sales : sales@margill.com • Support : support@margill.com • Phone : Toll free 1-877-683-1815, Direct (514) 683-1815 • Adresses : • US office - 220 E. Delaware Avenue, Newark, Delaware 19711 • Canada office - 4841 Elmview, Suite 100, Montreal, Quebec, H9A 3E9 • Sales and support for Europe, Asia, Africa and Australia (Canada office)