{"id":4610,"date":"2016-10-27T12:00:35","date_gmt":"2016-10-27T15:19:33","guid":{"rendered":"http:\/\/margill.com\/en\/?p=4610"},"modified":"2025-10-10T11:22:03","modified_gmt":"2025-10-10T15:22:03","slug":"financial-planning","status":"publish","type":"post","link":"https:\/\/margill.com\/en\/financial-planning\/","title":{"rendered":"Financial Planning"},"content":{"rendered":"<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\">The choice of thousands<\/h3>\n<ul>\n<li>Financial planners<\/li>\n<li>Portfolio managers \/ Money managers<\/li>\n<li>Investors<\/li>\n<li>Accountants<\/li>\n<li>Lenders (corporate, personal, mortgage)<\/li>\n<li>Law offices<\/li>\n<li>Government agencies<\/li>\n<li>Sambas and large corporations<\/li>\n<li>Insurance companies<\/li>\n<li>See also <a href=\"\/en\/finance\/\">Finance<\/a>, <a href=\"\/en\/accounting\/\">Accounting<\/a><\/li>\n<\/ul>\n<h3><b class=\"texteOrange\"><span style=\"font-size: small;\">Common financial planning related calculations<\/span><\/b><\/h3>\n<ul>\n<li>Calculation of bond premium (schedule of bond premium amortization &#8211; effective interest method\n<ul>\n<li>Calculation of bond discount<\/li>\n<li>Zero-coupon bonds<\/li>\n<\/ul>\n<\/li>\n<li>Investment scenarios &amp; comparisons &#8211; for example historic investment in the Stock market vs. fixed or variable rate security<\/li>\n<li>Mortgage and loan calculations (regular and irregular payments at fixed or variable interest rates)<\/li>\n<li>Present value calculations (regular, irregular, indexed future cash flows)<\/li>\n<li>Return on investment<\/li>\n<li>Return on investment over the years with regular or irregular payouts<\/li>\n<li>Future value of regular or irregular investments (periodic investments at compound interest) over time<\/li>\n<\/ul>\n<h3 class=\"texteOrange\"><span style=\"font-size: small;\"><b>Standards-based<\/b><\/span><\/h3>\n<ul>\n<li><b>International standards and recognized principles<\/b> for the calculation of interest (Americas, Europe, Asia, Australia, Africa)<\/li>\n<li><b>United States banking rules <\/b>(Regulation Z, Truth in Lending Act)<\/li>\n<li><b>European Community rules <\/b>(Directive 98\/7\/CE)<\/li>\n<li><b>Canadian rules<\/b><\/li>\n<li><b>Day count <\/b>conventions : Actual\/actual (also known as Actual\/365), 30\/360, Actual\/360, Actual\/365(Fixed)<\/li>\n<li>Actuarial rule (Normal amortization), Fixed capital and Interest only<\/li>\n<li>APR (Annual Percentage Rate) calculation<\/li>\n<\/ul>\n<ul>\n<li><b>Simple<\/b> and <b>Compound<\/b> interest<\/li>\n<li><b>Unique<\/b> (fixed) or <b>variable<\/b> interest rates<\/li>\n<li>4-decimal-point accuracy<\/li>\n<li>Multi-currency<\/li>\n<li>Printed reports that include quarterly and \/or annual and choice of the financial year-end<\/li>\n<li>Export of the data to Excel,Word, XML, RTF<\/li>\n<\/ul>\n<p align=\"center\"><a href=\"\/en\/specialized-features\/\"><b>Highly specialized features<\/b><\/a><br \/>\n(for total accuracy in Amortization)<\/p>\n<h3><b class=\"texteOrange\"><span style=\"font-size: small;\">Real-life examples of various calculations<\/span><\/b><\/h3>\n<p>Click to see Margill examples:<\/p>\n<ul>\n<li><a href=\"http:\/\/\/en\/bonds\/#1\">Calculation of bond premium (schedule of bond premium amortization &#8211; effective interest method<\/a>\n<ul>\n<li><a href=\"http:\/\/\/en\/bonds\/#2\">Calculation of bond discount<\/a><\/li>\n<li><a href=\"http:\/\/\/en\/bonds\/#3\">Zero-coupon bonds<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"\/en\/investments\/#1\">Value of historical investment in the Stock market vs. investment in treasuries<\/a><\/li>\n<li><a href=\"\/en\/investments\/#2\">Annual Rate of return<\/a><\/li>\n<li><a href=\"\/en\/investments\/#2a\">Annual Rate of return in complex situations (regular or irregular investments and payouts)<\/a><\/li>\n<li><a href=\"\/en\/investments\/#3\">Future value of regular and irregular periodic investments over time<\/a><\/li>\n<li><a href=\"\/en\/investments\/#4\">Present value investment based on future predicted irregular cash flows<\/a><\/li>\n<li><a href=\"\/en\/mortgages\/#1\">Regular mortgage<\/a>\n<ul>\n<li>USA, Europe, Australia&#8230;<\/li>\n<li>Canada<\/li>\n<\/ul>\n<\/li>\n<li><a href=\"\/en\/mortgages\/#2\">Irregular mortgage with lump sum payments and variable interest rates<\/a><\/li>\n<li><a href=\"\/en\/mortgages\/#3-1\">Variable-rate mortgage with payments adjusted according to the interest rates in force<\/a><\/li>\n<li><a href=\"\/en\/loans\/#4-1\">Mortgage includes unknown future interest rates with payments adjusted as these rates become known<\/a><\/li>\n<li><a href=\"\/en\/loans\/#3\">Loan with regular payments<\/a><\/li>\n<li><a href=\"\/en\/loans\/#7\">Loan with APR (Annual Percentage Rate) calculation<\/a><\/li>\n<li><a href=\"\/en\/loans\/#4\">Irregular loan &#8211; <span class=\"texteRouge\">let&#8217;s make this fun!<\/span> refund interest only, then of a fixed principal amount and a regular refund. Let&#8217;s include missed and late payments and even an NSF check!<\/a><\/li>\n<li><a href=\"\/en\/loans\/#4-1\">Loan that includes unknown future interest rates with payments adjusted as these rates become known<\/a><\/li>\n<li><a href=\"\/en\/loans\/#6\">Calculation of the unknown interest rate applicable to a loan with irregular refunds<\/a><\/li>\n<\/ul>\n<table class=\"texteRouge\" border=\"1\" width=\"80%\" cellspacing=\"0\" cellpadding=\"15\" align=\"center\" bgcolor=\"#FFCC99\">\n<tbody>\n<tr align=\"center\">\n<td height=\"174\">\n<h3><b><span style=\"font-size: small;\">Fully exploit the power of Margill!<\/span><\/b><\/h3>\n<p align=\"left\">Once the amortization schedule is calculated, use the<b> <a href=\"\/en\/financial-planning\/\">right mouse click<\/a> <\/b>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.<\/p>\n<h3><b><span style=\"font-size: small;\">TOTAL flexibility available ONLY in Margill<\/span><\/b><\/h3>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><b class=\"texteOrange\"><span style=\"font-size: small;\">Multiple variable interest rate tables and indexation tables included &#8211; OR create your own<\/span><\/b><\/h3>\n<ul>\n<li>All variable interest rates can be incremented (or reduced) by x% as of any date<br \/>\nFor example, prime + 2,5% starting November 15, 2004<\/li>\n<\/ul>\n<h3><\/h3>\n<h3><span class=\"texteNoir\"><b>Central Bank interest tables<\/b><\/span><\/h3>\n<ul>\n<li>United-States &#8211; Discount rate (Federal reserve)<\/li>\n<li>Great-Britain &#8211; Repo rate<\/li>\n<li>Canada &#8211; Target rate (preferential)<\/li>\n<li>Australia &#8211; Cash rate<\/li>\n<li>Hong Kong &#8211; Base rate<\/li>\n<li>Europe &#8211; Key rates &#8211; Deposit facility &#8211; European Central Bank<\/li>\n<li>South Africa &#8211; Prime rate<\/li>\n<\/ul>\n<h3><b class=\"texteNoir\">Late tax rates<\/b><\/h3>\n<ul>\n<li>US Internal Revenue Service (IRS) underpayments<\/li>\n<li>Canada Revenue Agency (CRA) underpayments<\/li>\n<\/ul>\n<h3><b class=\"texteNoir\">Legal interest rates<\/b><\/h3>\n<p>USA (federal post-judgement interest rates), Canada (Ontario, British Columbia, Quebec), Great-Britain, Australia, France, Belgium, Luxembourg<\/p>\n<h3><b class=\"texteNoir\">Indexation tables:<\/b><\/h3>\n<ul>\n<li>Inflation rates for various countries: USA, Canada, Great Britain, Australia, France, Switzerland, Belgium, Luxembourg,<\/li>\n<li>Historical performance of Stock market indices (annual % change)\n<ul>\n<li>Dow Jones Industrial Index, S&amp;P 500, NASDAQ, FTSE (London), Toronto Stock Exchange, Hong Kong Hang Seng, Bourse de Paris<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; 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 &#8211; effective interest method Calculation of bond discount Zero-coupon [&hellip;]<\/p>\n","protected":false},"author":25,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[193,408,404],"tags":[],"class_list":["post-4610","post","type-post","status-publish","format-standard","hentry","category-knowledge-base","category-margill-law-and-standard","category-margill-loan-manager"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\r\n<title>Margill | Our software and financial planning<\/title>\r\n<meta name=\"description\" content=\"Learn how our software can be useful with financial planning.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/margill.com\/en\/financial-planning\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Margill | Our software and financial planning\" \/>\r\n<meta property=\"og:description\" content=\"Learn how our software can be useful with financial planning.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/margill.com\/en\/financial-planning\/\" \/>\r\n<meta property=\"og:site_name\" content=\"Margill\" \/>\r\n<meta property=\"article:published_time\" content=\"2016-10-27T15:19:33+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-10-10T15:22:03+00:00\" \/>\r\n<meta name=\"author\" content=\"Marc G\u00e9linas\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Marc G\u00e9linas\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/margill.com\/en\/financial-planning\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/margill.com\/en\/financial-planning\/\"},\"author\":{\"name\":\"Marc G\u00e9linas\",\"@id\":\"https:\/\/margill.com\/en\/#\/schema\/person\/72f5aeeb0d0d040309ac495539c5fb81\"},\"headline\":\"Financial Planning\",\"datePublished\":\"2016-10-27T15:19:33+00:00\",\"dateModified\":\"2025-10-10T15:22:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/margill.com\/en\/financial-planning\/\"},\"wordCount\":627,\"articleSection\":[\"Knowledge Base\",\"Margill Law and Standard\",\"Margill Loan Manager\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/margill.com\/en\/financial-planning\/\",\"url\":\"https:\/\/margill.com\/en\/financial-planning\/\",\"name\":\"Margill | Our software and financial planning\",\"isPartOf\":{\"@id\":\"https:\/\/margill.com\/en\/#website\"},\"datePublished\":\"2016-10-27T15:19:33+00:00\",\"dateModified\":\"2025-10-10T15:22:03+00:00\",\"author\":{\"@id\":\"https:\/\/margill.com\/en\/#\/schema\/person\/72f5aeeb0d0d040309ac495539c5fb81\"},\"description\":\"Learn how our software can be useful with financial planning.\",\"breadcrumb\":{\"@id\":\"https:\/\/margill.com\/en\/financial-planning\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/margill.com\/en\/financial-planning\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/margill.com\/en\/financial-planning\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/margill.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Financial Planning\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/margill.com\/en\/#website\",\"url\":\"https:\/\/margill.com\/en\/\",\"name\":\"Margill\",\"description\":\"Loan Servicing Solutions \/ Interest Calculators\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/margill.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/margill.com\/en\/#\/schema\/person\/72f5aeeb0d0d040309ac495539c5fb81\",\"name\":\"Marc G\u00e9linas\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Margill | Our software and financial planning","description":"Learn how our software can be useful with financial planning.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/margill.com\/en\/financial-planning\/","og_locale":"en_US","og_type":"article","og_title":"Margill | Our software and financial planning","og_description":"Learn how our software can be useful with financial planning.","og_url":"https:\/\/margill.com\/en\/financial-planning\/","og_site_name":"Margill","article_published_time":"2016-10-27T15:19:33+00:00","article_modified_time":"2025-10-10T15:22:03+00:00","author":"Marc G\u00e9linas","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marc G\u00e9linas","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/margill.com\/en\/financial-planning\/#article","isPartOf":{"@id":"https:\/\/margill.com\/en\/financial-planning\/"},"author":{"name":"Marc G\u00e9linas","@id":"https:\/\/margill.com\/en\/#\/schema\/person\/72f5aeeb0d0d040309ac495539c5fb81"},"headline":"Financial Planning","datePublished":"2016-10-27T15:19:33+00:00","dateModified":"2025-10-10T15:22:03+00:00","mainEntityOfPage":{"@id":"https:\/\/margill.com\/en\/financial-planning\/"},"wordCount":627,"articleSection":["Knowledge Base","Margill Law and Standard","Margill Loan Manager"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/margill.com\/en\/financial-planning\/","url":"https:\/\/margill.com\/en\/financial-planning\/","name":"Margill | Our software and financial planning","isPartOf":{"@id":"https:\/\/margill.com\/en\/#website"},"datePublished":"2016-10-27T15:19:33+00:00","dateModified":"2025-10-10T15:22:03+00:00","author":{"@id":"https:\/\/margill.com\/en\/#\/schema\/person\/72f5aeeb0d0d040309ac495539c5fb81"},"description":"Learn how our software can be useful with financial planning.","breadcrumb":{"@id":"https:\/\/margill.com\/en\/financial-planning\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/margill.com\/en\/financial-planning\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/margill.com\/en\/financial-planning\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/margill.com\/en\/"},{"@type":"ListItem","position":2,"name":"Financial Planning"}]},{"@type":"WebSite","@id":"https:\/\/margill.com\/en\/#website","url":"https:\/\/margill.com\/en\/","name":"Margill","description":"Loan Servicing Solutions \/ Interest Calculators","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/margill.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/margill.com\/en\/#\/schema\/person\/72f5aeeb0d0d040309ac495539c5fb81","name":"Marc G\u00e9linas"}]}},"_links":{"self":[{"href":"https:\/\/margill.com\/en\/wp-json\/wp\/v2\/posts\/4610","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/margill.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/margill.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/margill.com\/en\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/margill.com\/en\/wp-json\/wp\/v2\/comments?post=4610"}],"version-history":[{"count":1,"href":"https:\/\/margill.com\/en\/wp-json\/wp\/v2\/posts\/4610\/revisions"}],"predecessor-version":[{"id":20622,"href":"https:\/\/margill.com\/en\/wp-json\/wp\/v2\/posts\/4610\/revisions\/20622"}],"wp:attachment":[{"href":"https:\/\/margill.com\/en\/wp-json\/wp\/v2\/media?parent=4610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/margill.com\/en\/wp-json\/wp\/v2\/categories?post=4610"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/margill.com\/en\/wp-json\/wp\/v2\/tags?post=4610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}