Types of calculations performed by Margill

See also our Support / FAQ (Frequenty Asked Questions) for specific calculation explanations.

Fifty or so interest calculation software are available on the market but none offer the complete flexibility offered by Margill in terms of variable interest rates and for the payment tables that can be created and modified as desired.

The calculations are based on the calendar : 365 or 366 (leap year) days per year; 28, 29, 30, 31 days per month to offer the greatest possible accuracy.

Margill respects international and regional norms and regulations for interest calculation (Truth in Lending Act (USA), European Community Directive 98/7/EC, Canadian rules, etc.)

Multiple indexation tables are included (or custom tables can be created) to obtain precise installment schedules :

• 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

• Historical performance of stock indices (annual % change)
  • Dow Jones Industrial Index, S&P 500, NASDAQ, FTSE (London), Toronto Stock Exchange, Hong Kong Hang Seng, Bourse de Paris

(1) Variable interes rates (fluctuating)

Multiple interest tables are included and may be created on a custom basis and updated by the user

• United-States - Federal reserve Discount rate (Fed funds)
• Great-Britain - Repo rate
• Canada
  • Bank of Canada Target rate (preferential), Canada Revenue Agency (CRA) underpayments NEW!
  • Ontario legal (statutory) interest (pre and post judgment) NEW!
  • British Columbia - legal interest (pre and post judgment, Bankers' prime, Rule 58(6))
  • Quebec - legal interest + additional indemnity
• Australia - Cash rate, Aus. Taxation Office (ATO) legal rates
• Hong Kong - Base rate
• Europe - key rates - Deposit facility - European Central Bank
  
• France - legal interest, rates for late payments

Unlimited number of tables may be created that can contain an unlimited number of dates and interest rates

Margill also offers the option to add x% to the rates in an existing or new interest table (for example, preferential rate + x%)

Simple interest

• Calculates the interest payable between two dates on an amount of capital using variable interest rates

Compound interest

• Calculates the interest payable between two dates on an amount of capital using variable interest rates

• Multiple compound periods

Recurring payments (amortization schedule)

• Calculates the payments required to reimburse the starting capital and accumulated interest to obtain a balance of 0,00 or other

• Determines the unknown variable among the data to input: starting capital, payment amount or number of payments

• Multiple compound periods or simple interest

• Multiple payment frequencies (annually, semiannually, quarterly, monthly, twice monthly, every x number of days)

• Choice of payment start date after beginning of "loan"

• Payment (amortization) schedule may be fully customized
  • unpaid payment deleted
  • payment date changed
  • new payment date
  • new capital added to initial loan (negative payment)(for example: new loan amount added, non sufficient funds (NSF) check fee, administrative fees, etc.)

• Amortization schedule may be saved and modified at a later date

• Calculation methods: international "actuarial" method and/or "US Rule"

• A few concrete applications:
  • mortgage calculations (all countries)
  • loans reimbursed regularly or irregularly
  • collection of unpaid accounts receivable
  • cost of loan hypotheses (based on payment frequencies, interest rates, etc.)

Accrual by installment

• Calculates, from an initial amount of 0,00, the accumulated capital and interest following a number of periodic capital installments (accumulation of capital as opposed to its reimbursement - opposite of the above calculation)

• Interest compounded at every installment period or simple interest

• Multiple installment frequencies (annually, semiannually, quarterly, monthly, twice monthly, every x number of days)

• Possible indexation of the installments
  • Consumer price index (CPI), inflation, stock market performance or other custom tables

• Installment table may be fully customized
  • unpaid installment deleted
  • installment date changed
  • new installment date

  • capital reduction (negative installment)

• A few concrete applications:
  • interest owed for non payment of salary, rent or other
  • terminal value following periodic investments with (optional) indexation of the investments
  • periodic investment rate of return hypotheses

See the Examples section to see the various options and the results tables generated

(2) Single fixed interest rate

Same functions as variable rate calculations for these 4 calculations

Simple interest

Compound interest

Recurring payments (amortization schedule)

Accrual by installment

See the Examples section to see the various options and the results tables generated

(3) Other calculations

Present value

• Allows to evaluate the present value of future installments

• Future installments may be fixed amounts or variable amounts

• An indexation table (positive or negative growth) included in Margill (CPI, inflation, legal or conventional indexation) or custom built allows to create an installment table for which the present value can be derived

• Installments may be added, eliminated or modified and the present value recalculated automatically

• A few concrete applications:
  • comparative analysis: payment of a lump sum or future installments
  • investment opportunities (appropriate return)

Effective rate of return of an investment between two dates

Calculates the effective rate of return of an investment made at an initial date and cashed in at the final date.

Indexation of an amount based on a fluctuating indexation table

• A few concrete applications:
  • Effect of inflation (or other index) on the present value of a product, service, indemnity, etc.
  • Comparison of a stock market investment and a term deposit or other.
  • Present value of an historical investment in various market indices, mutual funds or other...

Creation of an indexation table from variable payments

This utility creates, using variable periodic payments (regular or irregular) an indexation table which may be used thereafter in other calculations ("Accrual by Installment", "Present Value" or "Indexation of an amount").

Nominal interest rate - effective (real) interest rate converter

Based on a compounding period, converts a nominal interest rate to the corresponding real interest rate. The effective rate may also be converted to the nominal rate.

Various date calculations

This simple utility allows the calculation of deadlines, number of days between dates, etc...

International sales tax calculations

This simple utility allows to calculate the sales taxes for various countries, states or provinces. Margill contains a number of sales taxes and others may be added.

See the Examples section to see the various options and the results tables generated