Margill - General Public

The choice of thousands

• Accountants
• Financial planners
• Law offices, legal departments
• Government agencies
• Insurance companies
• SMEs and large corporations
• See also Finance, Financial planning, Real Estate
• People like you...

Common calculations for general public use

• Personal loans including APR (Annual Percentage Rate) calculation
• Line of credit management
• Mortgage comparison (regular and irregular payments at fixed or variable interest rates, lump sums...)
• Investment management and comparisons
  • Return on investment
  • Return on investment over the years with regular or irregular payouts
  • Future value of regular or irregular investments (periodic investments at compound interest) over time
  • Investment scenarios & comparisons - for example historic investment in the Stock market vs. fixed or variable rate security

Standards-based

• International standards and recognized principles for the calculation of interest (Americas, Europe, Asia, Australia, Africa)
• United States banking rules (Regulation Z, Truth in Lending Act)
• European Community rules (Directive 98/7/CE)
• Canadian rules
• Day count conventions : Actual/actual (also known as Actual/365), 30/360, Actual/360, Actual/365(Fixed)
• Actuarial rule (Normal amortization), Fixed capital and Interest only
• APR (Annual Percentage Rate) calculation

• Simple and Compound interest
• Unique (fixed) or variable interest rates
• 4 decimal point accuracy
• Multi-currency
• Printed reports that include quarterly and /or annual and choice of the financial year-end
• Export of the data to Excel,Word, XML, RTF

Highly specialized features
(for total accuracy in Amortization)

Real-life examples of various calculations

Click to see Margill examples:

• Regular mortgage
  • USA, Europe, Australia...
  • Canada
• Irregular mortgage with lump sum payments and variable interest rates
• Variable-rate mortgage with payments adjusted according to the interest rates in force
  
• Mortgage includes unknown future interest rates with payments adjusted as these rates become known
  
• Loan with regular payments
• Verification of the precision of the APR (Annual Percentage Rate)
• Irregular loan - let's make this fun ! refund interest only, then of a fixed principal amount and a regular refund. Let's include missed and late payments and even an NSF check!
• Loan that includes unknown future interest rates with payments adjusted as these rates become known
• Calculation of the unknown interest rate applicable to a loan with irregular refunds
• Value of historical investment in the Stock market vs. investment in treasuries
• Annual Rate of return
• Annual Rate of return in complex situations (regular or irregular investments and payouts)
• Future value of regular and irregular periodic investments over time
• Present value investment based on future predicted irregular cash flows

Multiple variable interest rate tables and indexation tables included - OR create your own

• All variable interest rates can be incremented (or reduced) by x% as of any date
  For example, prime + 2,5% starting November 15, 2004

Central Bank interest tables

• United-States - Discount rate (Federal reserve)
• Great-Britain - Repo rate
• Canada - Target rate (preferential)
• Australia - Cash rate
• Hong Kong - base rate
• Europe - key rates - deposit facility - European Central Bank

Late tax rates

• US Internal Revenue Service (IRS) underpayments
• Canada Revenue Agency (CRA) underpayments

Legal interest rates

USA (federal post-judgement interest rates), Canada (Ontario, British Columbia, Quebec), Great-Britain, Australia, France, Belgium, Luxembourg

Indexation tables:

• Inflation rates for various countries : USA, Canada, Great Britain, Australia, France, Switzerland, Belgium, Luxembourg,
• Historical performance of Stock market indices (annual % change)
  • Dow Jones Industrial Index, S&P 500, NASDAQ, FTSE (London), Toronto Stock Exchange, Hong Kong Hang Seng, Bourse de Paris