Margill & Accounting

The choice of thousands

• Accountants
  • Corporate clientele
  • General public clientele
• Tax experts
• Forensic accountants - see the Law section
• Financial planners
• Law offices, legal departments
• Government agencies
• Insurance companies
• SMEs and large corporations
• See also Finance, Law, Financial planning, Real Estate, Collection

• Late tax payments (taxation office variable interest rate tables)
• Investment scenarios & comparisons
• Future value of regular (or irregular) periodic investments over time
• Mortgage and loan calculations (regular and irregular payments at fixed or variable interest rates) including APR (Annual Percentage Rate) calculation
• Calculation of the unknown interest rate applicable to a loan with regular and irregular refunds
• Present value calculations (regular, irregular, indexed future cash flows)
• Collection (accounts payable)
• Asset finance (equipment, trucks, cars)

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 or/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:

• Late tax payments
• Calculation of bond premium (schedule of bond premium amortization - effective interest method
  • Calculation of bond discount
  • Zero-coupon bonds
• Regular mortgage
  • USA, Europe, Australia...
  • Canada
• Irregular mortgage with lump sum payments and fixed or variable interest rates
• Variable-rate mortgage with payments adjusted according to the interest rates in force
• Mortgage that includes unknown future interest rates with payments adjusted as these rates become known
• Reverse mortgage
• Loan with regular payments
• Loan with APR (Annual Percentage Rate) calculation
• 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
• Asset finance / Leasing
• Collection of unpaid accounts receivable
• Calculation of the unknown interest rate applicable to a loan with irregular refunds (determination of the contractual rate)
• Present value of an investment providing projected future returns
• Present value of an investment based on future regular and/or irregular cash flows
• Future value of regular and irregular periodic investments over time
• 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)
• Indexation rate in % based on 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
• South Africa - Prime rate

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

• 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 (TSE), Hong Kong Hang Seng, Bourse de Paris