Finance

Finance

In:

[av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ link=” linktarget=” link_hover=” padding=’0px’ border=” border_color=” radius=’0px’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-3l45sw’]
[av_heading tag=’h3′ padding=’10’ heading=’Finance’ color=” style=’blockquote modern-quote’ custom_font=” size=’30’ subheading_active=” subheading_size=’15’ custom_class=” admin_preview_bg=” av-desktop-hide=” av-medium-hide=” av-small-hide=” av-mini-hide=” av-medium-font-size-title=” av-small-font-size-title=” av-mini-font-size-title=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” margin=” av_uid=’av-2axs4g’][/av_heading]

[av_textblock size=” font_color=” color=” av_uid=’av-avh28′]

Bonds, Banking, Lending, Leasing

The choice of thousands

  • Mortgage brokers
  • Corporate lenders
    • Loans
    • Equipment, Auto & Truck finance / leasing
  • Personal loan companies
  • Investors
  • Law offices
  • Government agencies
  • SMEs and large corporations
  • Insurance companies
  • See also Financial planning, Accounting, Real Estate, Collection

Common finance-related calculations

  • Corporate loans (regular and irregular payments at fixed or variable interest rates, lump sums, fixed principal, interest only…) using 30/360, Actual/Actual, Actual/365 or Actual/360
  • Personal and Car (auto) loans including APR (Annual Percentage Rate) calculation
  • Lines of credit
  • Mortgages (regular and irregular)
  • Asset finance and leasing (equipment, trucks, cars)
  • Calculation of bond premium (schedule of bond premium amortization – effective interest method
    • Calculation of bond discount
    • Zero-coupon bonds
  • Present value calculations (regular, irregular, indexed future cash flows) for investment (equipment purchase, corporate acquisition)

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:

Fully exploit the power of Margill!

Once the amortization schedule is calculated, use the right mouse click to create totally custom payment schedules: interest only, fixed principal, irregular payment amounts and dates, lump sum, missed and extra payments, variable interest rate/en/finance/s, new principal, etc.

TOTAL flexibility available ONLY in Margill

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

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

[/av_textblock]
[/av_one_full]