[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_heading tag=’h3′ padding=’10’ heading=’Financial Planning’ 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_heading]
[av_textblock size=” font_color=” color=” av_uid=’av-328i7m’]
The choice of thousands
- Financial planners
- Portfolio managers / Money managers
- Investors
- Accountants
- Lenders (corporate, personal, mortgage)
- Law offices
- Government agencies
- Sambas and large corporations
- Insurance companies
- See also Finance, Accounting
Common financial planning related calculations
- Calculation of bond premium (schedule of bond premium amortization – effective interest method
- Calculation of bond discount
- Zero-coupon bonds
- Investment scenarios & comparisons – for example historic investment in the Stock market vs. fixed or variable rate security
- Mortgage and loan calculations (regular and irregular payments at fixed or variable interest rates)
- Present value calculations (regular, irregular, indexed future cash flows)
- 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
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:
- Calculation of bond premium (schedule of bond premium amortization – effective interest method
- 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
- 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
- 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
- Calculation of the unknown interest rate applicable to a loan with irregular refunds
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 rates, 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]