{"text_format":"3","workbook":"xlsx","n_sheets":16,"sheets":["Output","Input","Considerations","Sortie","Entrée","Considérations","Raw Data","Notes","List","LTCGE","LTCGE French","List French","RRIF","RRIF French","Estate tax rates","Estate tax rates French"],"not_rendered":{"charts":2,"images":12,"macros":1,"defined_names":302,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Output","index":0,"n_rows":30,"n_cols":17,"rows_kept":30,"hidden":true,"merged":[[11,1,11,16],[15,1,15,16],[16,3,16,6],[17,3,18,6],[17,10,18,15],[19,10,20,15],[21,3,21,6],[21,10,22,15],[22,3,23,6],[27,1,27,16],[28,1,28,16],[29,1,29,16]]}
{"$rows_empty":9}
[{"$nulls":16},"v2024"]
[]
[null,"You’ve worked your whole life to build your wealth and would like your loved ones to continue enjoying the fruits of your hard work. However, there are taxes and expenses that must be paid in cash before your assets are transferred to your beneficiaries. Those taxes and expenses may be higher than you think and may significantly reduce the size of your estate available to your beneficiaries. Further, if your estate does not have enough liquid assets to pay off those expenses some of the other assets may have to be quickly sold for example: your home, cottage or vehicles."]
[null,"The following chart is an estimation of what could happen to your estate and the cash shortfall you will leave behind."]
[]
[]
[null,"Taxes and final expenses may shrink the estate you intend to leave behind for your beneficiary."]
[{"$nulls":3},"You intend to leave this for your beneficiary:"]
[{"$nulls":3},{"$f":"'Raw Data'!D22","v":{"v":2409025.933149502,"d":"$2.4 M"}},{"$nulls":6},"Expected reduction in estate due to liabilities, expenses and taxes:"]
[]
[{"$nulls":10},{"$f":"ROUND(D18,1)-ROUND(D23,1)","v":{"v":821850.2999999998,"d":"$0.8 M"}}]
[]
[{"$nulls":3},"This is what your beneficiary will likely receive:",{"$nulls":6},"Consider including this amount in determining your total permanent life insurance need."]
[{"$nulls":3},{"$f":"'Raw Data'!D19","v":{"v":1587175.632591296,"d":"$1.6 M"}}]
[]
[]
[]
[]
[null,"A death benefit from an RBC life insurance policy may be used to pay tax liabilities and other expenses, and avoid reduction in the estate available to the beneficiaries."]
[]
[null,{"$f":"\"Reach out and speak to \"&IF(Eng_Adv_Use_In_Printouts=\"Yes\",TRIM(Eng_Prepared_By),\"your RBC advisor\")&\" today!\"","v":"Reach out and speak to your RBC advisor today!"}]

{"sheet":"Input","index":1,"n_rows":144,"n_cols":68,"rows_kept":144,"hidden":true,"merged":[[7,7,7,29],[8,11,8,12],[10,22,10,50],[14,2,14,72],[15,2,15,72],[16,2,16,72],[17,2,17,72],[18,2,18,72],[23,2,23,72],[24,2,24,72],[25,2,25,72],[27,3,27,7],[27,8,27,26],[27,27,27,31],[27,32,27,33],[27,35,27,41],[27,42,27,43],[27,45,27,54],[27,55,27,56],[27,58,27,65],[27,66,27,70],[33,2,33,72],[34,2,34,72],[35,2,35,72],[37,25,37,30],[37,32,37,36],[37,38,37,42],[37,44,37,48],[37,50,37,53],[37,55,37,59],[37,61,37,65],[37,67,37,71],[39,55,39,59],[39,61,39,65],[39,67,39,71],[41,3,41,6],[41,27,41,28],[41,38,41,42],[41,44,41,48],[41,50,41,53],[41,55,41,59],[41,61,41,65],[41,67,41,71],[43,3,43,6],[43,27,43,28],[43,44,43,48],[43,50,43,53],[43,55,43,59],[43,61,43,65],[43,67,43,71],[45,27,45,28],[45,38,45,42],[45,44,45,48],[45,50,45,53],[45,55,45,59],[45,61,45,65],[45,67,45,71],[47,3,47,26],[47,27,47,28],[47,32,47,36],[47,38,47,42],[47,44,47,48],[47,50,47,53],[47,55,47,59],[47,61,47,65],[47,67,47,71],[49,3,49,26],[49,27,49,28],[49,32,49,36],[49,38,49,42],[49,44,49,48],[49,50,49,53],[49,55,49,59],[49,61,49,65],[49,67,49,71],[51,27,51,28],[51,32,51,36],[51,38,51,42],[51,44,51,48],[51,50,51,53],[51,55,51,59],[51,61,51,65],[51,67,51,71],[53,32,53,36],[53,44,53,48],[53,50,53,53],[53,55,53,59],[53,61,53,65],[53,67,53,71],[55,32,55,36],[55,44,55,48],[55,50,55,53],[55,55,55,59],[55,61,55,65],[55,67,55,71],[57,32,57,36],[57,44,57,48],[57,50,57,53],[57,55,57,59],[57,61,57,65],[57,67,57,71],[59,27,59,28],[59,32,59,36],[59,44,59,48],[59,50,59,53],[59,55,59,59],[59,61,59,65],[59,67,59,71],[61,27,61,28],[61,32,61,36],[61,44,61,48],[61,55,61,59],[61,61,61,65],[61,67,61,71],[63,32,63,36],[63,44,63,48],[63,50,63,53],[63,55,63,59],[63,61,63,65],[63,67,63,71],[65,61,65,65],[65,67,65,71],[67,61,67,65],[67,67,67,71],[69,32,69,36],[69,38,69,42],[69,44,69,48],[69,50,69,53],[69,55,69,59],[69,61,69,65],[69,67,69,71],[71,32,71,36],[71,38,71,42],[71,44,71,48],[71,50,71,53],[71,55,71,59],[71,61,71,65],[71,67,71,71],[73,55,73,59],[73,61,73,65],[73,67,73,71],[75,55,75,59],[75,61,75,65],[75,67,75,71],[78,55,78,60],[78,61,78,65],[78,67,78,71],[84,2,84,72],[85,2,85,72],[86,2,86,72],[88,61,88,65],[88,67,88,71],[90,61,90,65],[90,67,90,71],[92,32,92,36],[92,61,92,65],[94,32,95,36],[94,61,95,65],[97,61,97,65],[100,55,100,60],[100,61,100,65],[100,67,100,71],[106,2,106,72],[107,2,107,72],[108,2,108,72],[110,3,110,9],[110,10,110,15],[110,17,110,27],[110,28,110,33],[110,35,110,44],[110,45,110,50],[110,56,110,65],[110,66,110,71],[116,2,116,25],[117,2,117,25],[118,2,118,25],[120,15,120,18],[120,20,120,24],[122,20,122,24],[124,20,124,24],[126,15,126,18],[126,20,126,24],[128,15,128,18],[128,20,128,24],[130,15,130,18],[130,20,130,24],[132,20,132,24],[134,20,134,24],[136,20,136,24],[139,3,139,19],[139,20,139,24],[143,2,143,72]]}
{"$rows_empty":7}
[null,null,"Prepared by:",{"$nulls":4},"Smith Advisors"]
[null,null,"Include in printouts:",{"$nulls":8},"No"]
[]
[{"$nulls":22},"ESTATE TRANSFER ESTIMATE v2024"]
[]
[]
[]
[]
[null,null,"About this calculator"]
[]
[null,null,"The purpose of this calculator is to estimate the income tax and estate administration tax/probate fees that may become payable upon your death based on the assets you may own at that time and show its impact on your estate. The calculation assumes that you are either a single person or a last to die spouse/common law-partner."]
[null,null,"An RBC Permanent Life Insurance policy may provide an excellent solution to maximize your estate’s liquidity."]
[]
[]
[]
[]
[]
[null,null,"Client information"]
[]
[]
[{"$nulls":3},"Client name  ",{"$nulls":4},"John Smith",{"$nulls":18},"Client age  ",{"$nulls":4},68,null,null,"Comparison age",{"$nulls":6},85,null,null,"Province of residence  ",{"$nulls":9},"AB",null,null,"Marginal tax rate  ",{"$nulls":7},{"v":0.5,"d":"50.00%"}]
[]
[]
[]
[]
[]
[]
[null,null,"Asset information"]
[]
[]
[{"$nulls":3},"Asset type",{"$nulls":21},"Benificiary designation",{"$nulls":6},"ACB / cost",{"$nulls":5},"Annual contribution",{"$nulls":5},"Current FMV",{"$nulls":5},"Growth rate",{"$nulls":4},"Future      value",{"$nulls":5},"Taxable income/gain",{"$nulls":5},"Estate"]
[]
[{"$nulls":3},"Cash",{"$nulls":57},{"v":0,"d":"0 "},{"$nulls":5},{"$f":"BD40","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"RRSP",{"$nulls":23},"No",{"$nulls":10},{"v":5000,"d":"5,000 "},{"$nulls":5},{"v":500000,"d":"500,000 "},{"$nulls":5},{"v":0.04,"d":"4.00%"},{"$nulls":4},{"$f":"IF($AQ$28>71,0,FV(AY42,$AQ$28-$AG$28,-AM42,-AS42,1))","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+IF(AQ28>71,0,BD42)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"IF(AB42=List!$A$20,0,BD42)","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"RRIF",{"$nulls":23},"No",{"$nulls":27},{"$f":"IF($AQ$28<72,0,VLOOKUP($AQ$28,RRIF!$A$4:$F$43,6))","v":{"v":209025.93314950223,"d":"209,026 "}},{"$nulls":5},{"$f":"+BD44","v":{"v":209025.93314950223,"d":"209,026 "}},{"$nulls":5},{"$f":"IF(AB44=List!$A$20,0,BD44)","v":{"v":209025.93314950223,"d":"209,026 "}}]
[]
[{"$nulls":3},"TFSA",{"$nulls":23},"No",{"$nulls":27},{"$f":"FV(AY46,+$AQ$28-$AG$28,-AM46,-AS46,1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"v":0,"d":"0 "},{"$nulls":5},{"$f":"IF(AB46=List!$A$20,0,BD46)","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Non-registered investments (growth/capital gains focused)",{"$nulls":23},"No",{"$nulls":27},{"$f":"FV(AY48,+$AQ$28-$AG$28,-AM48,-AS48,1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+(BD48-AG48-(AM48*($AQ$28-$AG$28)))*List!$B$1","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"IF(AB48=List!$A$20,0,BD48)","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Non-registered investments (segregated fund, if applicable)",{"$nulls":23},"No",{"$nulls":27},{"$f":"FV(AY50,+$AQ$28-$AG$28,-AM50,-AS50,1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+(BD50-AG50-(AM50*($AQ$28-$AG$28)))*List!$B$1","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"IF(AB50=List!$A$20,0,BD50)","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Non-registered investments (other)",{"$nulls":23},"No",{"$nulls":27},{"$f":"FV(AY52*(1-$BO$28),+$AQ$28-$AG$28,-AM52,-AS52,1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"v":0,"d":"0 "},{"$nulls":5},{"$f":"IF(AB52=List!$A$20,0,BD52)","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Land",{"$nulls":51},{"$f":"FV(AY54,+$AQ$28-$AG$28,,-AS54,1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+(BD54-AG54)*List!$B$1","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+BD54","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Principal residence",{"$nulls":51},{"$f":"FV(AY56,+$AQ$28-$AG$28,,-AS56,1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+MAX(0,(BD56-AG56)*List!$B$1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+BD56","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Other real estate (business/rental assets can not have capital losses)",{"$nulls":51},{"$f":"FV(AY58,+$AQ$28-$AG$28,,-AS58,1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+MAX(0,(BD58-AG58)*List!$B$1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+BD58","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Business shares (common / growth stock)",{"$nulls":23},"No",{"$nulls":16},{"v":1000000,"d":"1,000,000 "},{"$nulls":10},{"$f":"FV(AY60,+$AQ$28-$AG$28,,-AS60,1)","v":{"v":1000000,"d":"1,000,000 "}},{"$nulls":5},{"$f":"+(BD60-AG60)*List!$B$1","v":{"v":500000,"d":"500,000 "}},{"$nulls":5},{"$f":"IF(AB60=List!$A$20,0,BD60)","v":{"v":1000000,"d":"1,000,000 "}}]
[]
[{"$nulls":3},"Business shares (fixed value / estate-freeze stock)",{"$nulls":23},"No",{"$nulls":16},{"v":1000000,"d":"1,000,000 "},{"$nulls":10},{"$f":"AS62","v":{"v":1000000,"d":"1,000,000 "}},{"$nulls":5},{"$f":"+(BD62-AG62)*List!$B$1","v":{"v":500000,"d":"500,000 "}},{"$nulls":5},{"$f":"IF(AB62=List!$A$20,0,BD62)","v":{"v":1000000,"d":"1,000,000 "}}]
[]
[{"$nulls":3},"Other assets generating capital gains (e.g. gold coins, painting etc.) ",{"$nulls":51},{"$f":"FV(AY64,+$AQ$28-$AG$28,,-AS64,1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+(BD64-AG64)*List!$B$1","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+BD64","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Estimated depreciation recapture on personally owned buisness assets",{"$nulls":63},{"v":0,"d":"0 "}]
[]
[{"$nulls":3},"Estimated terminal loss on personally owned buisness/rental assets",{"$nulls":63},{"v":0,"d":"0 "}]
[]
[{"$nulls":3},"Other easily cashable assets",{"$nulls":51},{"$f":"FV(AY70,+$AQ$28-$AG$28,-AM70,-AS70,1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+(BD70-AG70-(AM70*($AQ$28-$AG$28)))*List!$B$1","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"BD70","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Other non-cashable assets",{"$nulls":51},{"$f":"FV(AY72,+$AQ$28-$AG$28,-AM72,-AS72,1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+(BD72-AG72-(AM72*($AQ$28-$AG$28)))*List!$B$1","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"BD72","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Guaranteed portion of annuity",{"$nulls":63},{"$f":"BD74","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Inforce Life insurance coverage (Death benefit - only if the estate is the beneficiary)",{"$nulls":51},{"v":200000,"d":"200,000"},{"$nulls":5},{"v":0,"d":"0 "},{"$nulls":5},{"$f":"BD76","v":{"v":200000,"d":"200,000 "}}]
[]
[]
[{"$nulls":55},"Total",{"$nulls":5},{"$f":"SUM(BJ40:BJ76)","v":{"v":1209025.9331495021,"d":"1,209,026 "}},{"$nulls":5},{"$f":"SUM(BP40:BP76)","v":{"v":2409025.933149502,"d":"2,409,026 "}}]
[]
[]
[]
[]
[]
[]
[null,null,"Deductions"]
[]
[]
[{"$nulls":61},"Taxable income/gain",{"$nulls":5},"Estate"]
[]
[{"$nulls":3},"Mortgage/borrowing on real property included in estate above",{"$nulls":57},{"v":0,"d":"0 "}]
[]
[{"$nulls":3},"Principal residence exemption (%)",{"$nulls":28},{"v":1,"d":"100.00%"},{"$nulls":28},{"$f":"+BJ56*AG93","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Lifetime capital gains deduction (1/2 of exemption amount)",{"$nulls":28},{"$f":"+VLOOKUP($AQ$28,LTCGE!$B$2:$D$101,3)","v":{"v":840337.4875043397,"d":"840,337 "}}]
[{"$nulls":3},"Maximum indexed to inflation amount of LTCGD at comparison age"]
[]
[{"$nulls":3},"Other"]
[]
[]
[{"$nulls":55},"Total",{"$nulls":5},{"$f":"SUM(BJ93:BJ98)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"BP91","v":{"v":0,"d":"0 "}}]
[]
[]
[]
[]
[]
[]
[null,null,"Liquidity Summary"]
[]
[]
[{"$nulls":3},"Liquid assets",{"$nulls":6},{"$f":"BD40+BD42+BD44+BD46+BD48+BD50+BD52+BD70","v":{"v":209025.93314950223,"d":"209,026 "}},{"$nulls":6},"Death benefit to estate",{"$nulls":10},{"$f":"BD76","v":{"v":200000,"d":"200,000 "}},{"$nulls":6},"Total cash required",{"$nulls":9},{"$f":"U140","v":{"v":821850.3005582063,"d":"821,850 "}},{"$nulls":10},"Surplus / (Shortfall)",{"$nulls":9},{"$f":"K111-AT111+AC111","v":{"v":-412824.367408704,"d":"(412,824)"}}]
[]
[]
[]
[]
[]
[]
[null,null,"Liabilities and expenses"]
[]
[]
[{"$nulls":15},"As a % of estate",{"$nulls":4},"Amount"]
[]
[{"$nulls":3},"Mortgage",{"$nulls":16},{"$f":"BP91","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Other debt and liabilities at death"]
[]
[{"$nulls":3},"Legal fees",{"$nulls":11},{"v":0.02,"d":"2.00%"},{"$nulls":4},{"$f":"+P127*($BP$79-$BP$101)","v":{"v":48180.51866299004,"d":"48,181 "}}]
[]
[{"$nulls":3},"Accounting fees",{"$nulls":11},{"v":0.02,"d":"2.00%"},{"$nulls":4},{"$f":"+P129*($BP$79-$BP$101)","v":{"v":48180.51866299004,"d":"48,181 "}}]
[]
[{"$nulls":3},"Trustee / executor fees",{"$nulls":11},{"v":0.05,"d":"5.00%"},{"$nulls":4},{"$f":"+P131*($BP$79-$BP$101)","v":{"v":120451.29665747512,"d":"120,451 "}}]
[]
[{"$nulls":3},"Other final expenses"]
[]
[{"$nulls":3},"Income tax payable",{"$nulls":16},{"$f":"+(BJ79-BJ101)*$BO$28","v":{"v":604512.9665747511,"d":"604,513 "}}]
[]
[{"$nulls":3},"Probate tax payable",{"$nulls":16},{"$f":"+VLOOKUP(BD28,List!$A$5:$D$17,4)","v":{"v":525,"d":"525 "}}]
[]
[]
[{"$nulls":3},"Expected shrinkage in estate due to liabilities, expenses and taxes",{"$nulls":16},{"$f":"SUM(U123:U137)","v":{"v":821850.3005582063,"d":"821,850 "}}]
[]
[]
[]
[null,null,{"$f":"\"Potential life insurance need to preserve your estate from shrinkage is \"&TEXT(U140,\"$#00,000\")&\". Contact \"&IF(Eng_Adv_Use_In_Printouts=\"Yes\",TRIM(Eng_Prepared_By),\"your RBC life insurance agent\")&\" to find the right insurance solution for you.\"","v":"Potential life insurance need to preserve your estate from shrinkage is $821,850. Contact your RBC life insurance agent to find the right insurance solution for you."}]

{"sheet":"Considerations","index":2,"n_rows":46,"n_cols":4,"rows_kept":46,"hidden":true,"merged":[[14,2,14,76],[15,2,15,76],[16,2,16,76],[18,3,18,76],[19,3,19,76],[20,3,20,76],[21,3,21,76],[22,3,22,76],[23,3,23,76],[24,3,24,76],[30,2,30,76],[31,2,31,76],[32,2,32,76],[34,3,34,76],[35,3,35,76],[36,3,36,76],[37,3,37,76],[38,3,38,76],[39,3,39,76],[40,3,40,76],[41,3,41,76],[42,3,42,76],[43,3,43,76],[44,3,44,76],[45,3,45,76]]}
{"$rows_empty":15}
[null,null,"General considerations"]
[]
[]
[null,null,1,"RBC Life Insurance Company recommends consulting with your legal, accounting, tax and financial advisors before making any decision. The information provided in this presentation is not intended to be relied upon as tax, legal, accounting or financial advice."]
[null,null,2,"RBC Life Insurance Company does not accept any liability for any direct, indirect or consequential loss arising from, or in connection with, the information in this presentation."]
[null,null,3,"Reasonable care has been taken to ensure the accuracy of the calculations and information provided, but errors and omissions are possible."]
[null,null,4,"If an insurance policy is issued, the coverage will be governed by the terms of the policy. This presentation will not form part of any policy issued."]
[null,null,5,"Buying a life insurance policy is a long-term commitment. Surrendering the policy can have significant tax and financial consequences."]
[null,null,6,"This is not an insurance illustration."]
[null,null,7,"To ensure you always provide your clients with accurate numbers, it is important that you use the latest version of the RBC Estate Transfer Estimate tool."]
[]
[]
[]
[]
[]
[]
[null,null,"Calculation considerations/assumptions"]
[]
[]
[null,null,1,"The income tax liability is calculated by multiplying the taxable income/gain by the marginal tax rate. Unless identified, any other credits/deductions that the client may be entitled to have not been considered in this calculation."]
[null,null,{"$f":"1+C35","v":2},{"$f":"\"The annual inflation rate used is \"&TEXT(LTCGE!$G$1,\"0.0%\")&\".\"","v":"The annual inflation rate used is 3.0%."}]
[null,null,3,"The maximum lifetime capital gains exemption in the comparison year is an estimated amount. The actual limit applicable in the year of death can be different than shown in this presentation."]
[null,null,4,"It is assumed that no capital or non-capital loss carryforwards will be available to reduce taxable gains or income in the year of death."]
[null,null,5,"Any tax liability in foreign countries and potential tax credits for those tax liabilities is not considered in the calculation."]
[null,null,6,"Capital gains/losses are calculated based on the adjusted cost base and projected fair market value of the assets. Special rules that apply in respect of personal-use property and listed personal property are not considered in this calculation."]
[null,null,7,"The future value of RRIF is calculated assuming that the minimum amount required under the Income Tax Act (Canada) will be withdrawn from age 71."]
[null,null,8,"When a beneficiary has been designated, it is assumed that the value of that asset will not be included in the estate tax calculation."]
[null,null,9,"It is assumed that no withdrawals will be made from the assets and they will continue to grow at a specified growth rate on an annual basis. However, it is possible that the asset value may decline even if no withdrawal is made."]
[null,null,10,"The calculator only calculates the income/gain that may result from various assets held at death. It does not consider other income earned during the year of death or any of the previous years."]
[null,null,11,"The potential estate tax liability is a simplified estimate only. The calculator is not meant to replace the detailed calculation based on the rules applicable in the respective province or territory. "]
[null,null,12,"All amounts, other than percentages, are in Canadian dollars."]

{"sheet":"Sortie","index":3,"n_rows":29,"n_cols":17,"rows_kept":29,"merged":[[11,1,11,16],[15,1,15,16],[16,3,16,6],[17,3,18,6],[17,10,18,15],[19,10,20,15],[21,3,21,6],[21,10,22,15],[22,3,23,6],[26,1,26,16],[27,1,27,16],[28,1,28,16]]}
[]
[]
[]
[null,"Quel patrimoine laissez-vous réellement ?"]
[]
[]
[]
[]
[]
[{"$nulls":16},"v2024"]
[]
[null,"Vous avez passé votre vie à bâtir votre patrimoine et vous aimeriez que vos proches continuent de récolter les fruits de votre labeur. Toutefois, il y aura de l’impôt et des frais à payer en espèces avant de procéder au transfert de votre actif à vos bénéficiaires. Les frais et l’impôt peuvent être plus élevés que vous ne le croyez et réduire considérablement le montant de la succession qui revient à vos bénéficiaires. De plus, si votre succession ne dispose pas de liquidités suffisantes pour payer ces dépenses, certains biens pourraient devoir être vendus rapidement, notamment votre maison, votre chalet ou vos véhicules."]
[null,"Le graphique ci-dessous représente une estimation de ce qui pourrait arriver à votre succession ainsi que le manque de fonds pour vos bénéficiaires."]
[]
[]
[null,"Les impôts et les dernières dépenses peuvent réduire la succession que vous prévoyez laisser à votre bénéficiaire."]
[{"$nulls":3},"Vous comptez laisser ceci à votre bénéficiaire :"]
[{"$nulls":3},{"$f":"'Raw Data'!E22","v":" 24,1 M$"},{"$nulls":6},"Diminution attendue de la succession en raison des dettes, des dépenses et des impôts :"]
[]
[{"$nulls":10},{"$f":"'Raw Data'!E20","v":" 8,2 M$"}]
[]
[{"$nulls":3},"Voici ce que recevra probablement votre bénéficiaire :",{"$nulls":6},"Pensez à inclure ce montant pour déterminer votre besoin en assurance vie permanente."]
[{"$nulls":3},{"$f":"'Raw Data'!E19","v":" 15,9 M$"}]
[]
[]
[]
[null,"Le capital-décès d’une police d’assurance vie RBC pourrait servir à payer la dette d’impôt et les autres dépenses, et éviter la réduction du patrimoine disponible pour les bénéficiaires."]
[]
[null,{"$f":"\"Communiquez avec \"&IF(Fre_Adv_Use_In_Printouts=\"Non\",\"votre conseiller RBC\",Fre_Prepared_By)&\" dès aujourd’hui !\"","v":"Communiquez avec votre conseiller RBC dès aujourd’hui !"}]

{"sheet":"Entrée","index":4,"n_rows":144,"n_cols":72,"rows_kept":144,"merged":[[7,7,7,29],[8,15,8,16],[10,22,10,54],[14,2,14,76],[15,2,15,76],[16,2,16,76],[17,2,17,76],[18,2,18,76],[23,2,23,76],[24,2,24,76],[25,2,25,76],[27,8,27,24],[27,32,27,33],[27,43,27,44],[27,56,27,57],[27,70,27,74],[33,2,33,76],[34,2,34,76],[35,2,35,76],[37,28,37,33],[37,35,37,39],[37,41,37,45],[37,47,37,51],[37,53,37,57],[37,59,37,63],[37,65,37,69],[37,71,37,75],[39,59,39,63],[39,65,39,69],[39,71,39,75],[41,3,41,6],[41,30,41,31],[41,41,41,45],[41,47,41,51],[41,53,41,57],[41,59,41,63],[41,65,41,69],[41,71,41,75],[43,3,43,6],[43,30,43,31],[43,47,43,51],[43,53,43,57],[43,59,43,63],[43,65,43,69],[43,71,43,75],[45,30,45,31],[45,41,45,45],[45,47,45,51],[45,53,45,57],[45,59,45,63],[45,65,45,69],[45,71,45,75],[47,3,47,29],[47,30,47,31],[47,35,47,39],[47,41,47,45],[47,47,47,51],[47,53,47,57],[47,59,47,63],[47,65,47,69],[47,71,47,75],[49,3,49,29],[49,30,49,31],[49,35,49,39],[49,41,49,45],[49,47,49,51],[49,53,49,57],[49,59,49,63],[49,65,49,69],[49,71,49,75],[51,30,51,31],[51,35,51,39],[51,41,51,45],[51,47,51,51],[51,53,51,57],[51,59,51,63],[51,65,51,69],[51,71,51,75],[53,35,53,39],[53,47,53,51],[53,53,53,57],[53,59,53,63],[53,65,53,69],[53,71,53,75],[55,35,55,39],[55,47,55,51],[55,53,55,57],[55,59,55,63],[55,65,55,69],[55,71,55,75],[57,3,58,34],[57,35,57,39],[57,47,57,51],[57,53,57,57],[57,59,57,63],[57,65,57,69],[57,71,57,75],[59,30,59,31],[59,35,59,39],[59,47,59,51],[59,53,59,57],[59,59,59,63],[59,65,59,69],[59,71,59,75],[61,30,61,31],[61,35,61,39],[61,47,61,51],[61,59,61,63],[61,65,61,69],[61,71,61,75],[63,3,64,34],[63,35,63,39],[63,47,63,51],[63,53,63,57],[63,59,63,63],[63,65,63,69],[63,71,63,75],[65,65,65,69],[65,71,65,75],[67,65,67,69],[67,71,67,75],[69,35,69,39],[69,41,69,45],[69,47,69,51],[69,53,69,57],[69,59,69,63],[69,65,69,69],[69,71,69,75],[71,35,71,39],[71,41,71,45],[71,47,71,51],[71,53,71,57],[71,59,71,63],[71,65,71,69],[71,71,71,75],[73,59,73,63],[73,65,73,69],[73,71,73,75],[75,59,75,63],[75,65,75,69],[75,71,75,75],[78,59,78,64],[78,65,78,69],[78,71,78,75],[84,2,84,76],[85,2,85,76],[86,2,86,76],[88,65,88,69],[88,71,88,75],[90,65,90,69],[90,71,90,75],[92,47,92,51],[92,65,92,69],[94,47,95,51],[94,65,95,69],[97,65,97,69],[100,59,100,64],[100,65,100,69],[100,71,100,75],[106,2,106,76],[107,2,107,76],[108,2,108,76],[110,3,110,9],[110,10,110,15],[110,17,110,34],[110,35,110,40],[110,42,110,53],[110,54,110,59],[110,61,110,69],[110,70,110,75],[116,2,116,28],[117,2,117,28],[118,2,118,28],[120,15,121,18],[120,20,120,27],[122,20,122,27],[124,20,124,27],[126,15,126,18],[126,20,126,27],[128,15,128,18],[128,20,128,27],[130,15,130,18],[130,20,130,27],[132,20,132,27],[134,20,134,27],[136,20,136,27],[139,3,139,19],[139,20,139,27],[143,2,143,76]]}
{"$rows_empty":7}
[null,null,"Préparé par:",{"$nulls":4},"Smith Advisors"]
[null,null," Inclure dans les impressions:",{"$nulls":12},"Non"]
[]
[{"$nulls":22},"ESTIMATION DU TRANSFERT DE PATRIMOINE, version 2024"]
[]
[]
[]
[]
[null,null,"À propos de cette calculatrice"]
[]
[null,null,"L’objectif de cette calculatrice est d’estimer les frais d’homologation/l’impôt sur l’administration des successions et l’impôt sur le revenu qui pourraient être payables à votre décès en fonction des éléments d’actif que vous pourriez détenir à ce moment-là et de montrer leur incidence sur votre succession. Le calcul suppose que vous êtes célibataire ou le dernier conjoint ou conjoint de fait décédé."]
[null,null,"Une police d’assurance vie permanente RBC peut constituer une excellente solution pour optimiser la liquidité de votre succession."]
[]
[]
[]
[]
[]
[null,null,"Renseignements sur le client"]
[]
[]
[{"$nulls":7},"Nom du client","John Smith",{"$nulls":22},"Âge du client",68,{"$nulls":9},"Âge de comparaison",85,{"$nulls":11},"Province de résidence","AB",{"$nulls":12},"Taux d’imposition marginal",{"v":0.5,"d":"50.00%"}]
[]
[]
[]
[]
[]
[]
[null,null,"Renseignements sur les éléments d’actif"]
[]
[]
[{"$nulls":3},"Type d’élément d’actif",{"$nulls":24},"Désignation de bénéficiaire",{"$nulls":6},"PBR / coût",{"$nulls":5},"Cotisation annuelle",{"$nulls":5},"JVM actuelle",{"$nulls":5},"Taux de croissance",{"$nulls":5},"Valeur future",{"$nulls":5},"Revenu/gain imposable",{"$nulls":5},"Succession"]
[]
[{"$nulls":3},"Espèces",{"$nulls":61},{"v":0,"d":"0 "},{"$nulls":5},{"$f":"BH40","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"REER",{"$nulls":26},"Non",{"$nulls":10},{"v":5000,"d":"5,000 "},{"$nulls":5},{"v":500000,"d":"500,000 "},{"$nulls":5},{"v":0.04,"d":"4.00%"},{"$nulls":5},{"$f":"IF($AR$28>71,0,FV(BB42,$AR$28-$AG$28,-AP42,-AV42,1))","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+IF(AR28>71,0,BH42)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"IF(AE42='List French'!$B$20,0,BH42)","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"FERR",{"$nulls":26},"Non",{"$nulls":28},{"$f":"IF($AR$28<72,0,VLOOKUP($AR$28,'RRIF French'!$A$4:$F$43,6))","v":{"v":209025.93314950223,"d":"209,026 "}},{"$nulls":5},{"$f":"+BH44","v":{"v":209025.93314950223,"d":"209,026 "}},{"$nulls":5},{"$f":"IF(AE44='List French'!$B$20,0,BH44)","v":{"v":209025.93314950223,"d":"209,026 "}}]
[]
[{"$nulls":3},"CELI",{"$nulls":26},"Non",{"$nulls":28},{"$f":"FV(BB46,+$AR$28-$AG$28,-AP46,-AV46,1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"v":0,"d":"0 "},{"$nulls":5},{"$f":"IF(AE46='List French'!$B$20,0,BH46)","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Placements non enregistrés (axés sur la croissance et les gains en capital)",{"$nulls":26},"Non",{"$nulls":28},{"$f":"FV(BB48,+$AR$28-$AG$28,-AP48,-AV48,1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+(BH48-AJ48-(AP48*($AR$28-$AG$28)))*'List French'!$B$1","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"IF(AE48='List French'!$B$20,0,BH48)","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Placements non enregistrés (fonds distincts, le cas échéant)",{"$nulls":26},"Non",{"$nulls":28},{"$f":"FV(BB50,+$AR$28-$AG$28,-AP50,-AV50,1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+(BH50-AJ50-(AP50*($AR$28-$AG$28)))*'List French'!$B$1","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"IF(AE50='List French'!$B$20,0,BH50)","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Placements non enregistrés (autres)",{"$nulls":26},"Non",{"$nulls":28},{"$f":"FV(BB52*(1-$BS$28),+$AR$28-$AG$28,-AP52,-AV52,1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"v":0,"d":"0 "},{"$nulls":5},{"$f":"IF(AE52='List French'!$B$20,0,BH52)","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Terrain",{"$nulls":55},{"$f":"FV(BB54,+$AR$28-$AG$28,,-AV54,1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+(BH54-AJ54)*'List French'!$B$1","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+BH54","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Résidence principale",{"$nulls":55},{"$f":"FV(BB56,+$AR$28-$AG$28,,-AV56,1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+MAX(0,(BH56-AJ56)*'List French'!$B$1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+BH56","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Autres biens immeubles (les actifs d’entreprise ou de location ne peuvent pas avoir de pertes en capital)",{"$nulls":55},{"$f":"FV(BB58,+$AR$28-$AG$28,,-AV58,1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+MAX(0,(BH58-AJ58)*'List French'!$B$1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+BH58","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Actions d’entreprise (ordinaires / titres de croissance)",{"$nulls":26},"Non",{"$nulls":16},{"v":1000000,"d":"1,000,000 "},{"$nulls":11},{"$f":"FV(BB60,+$AR$28-$AG$28,,-AV60,1)","v":{"v":1000000,"d":"1,000,000 "}},{"$nulls":5},{"$f":"+(BH60-AJ60)*'List French'!$B$1","v":{"v":500000,"d":"500,000 "}},{"$nulls":5},{"$f":"IF(AE60='List French'!$B$20,0,BH60)","v":{"v":1000000,"d":"1,000,000 "}}]
[]
[{"$nulls":3},"Actions d’entreprise (valeur fixe / actions grevant la succession)",{"$nulls":26},"Non",{"$nulls":16},{"v":1000000,"d":"1,000,000 "},{"$nulls":11},{"$f":"AV62","v":{"v":1000000,"d":"1,000,000 "}},{"$nulls":5},{"$f":"+(BH62-AJ62)*'List French'!$B$1","v":{"v":500000,"d":"500,000 "}},{"$nulls":5},{"$f":"IF(AE62='List French'!$B$20,0,BH62)","v":{"v":1000000,"d":"1,000,000 "}}]
[]
[{"$nulls":3},"Autres éléments d’actif générant des gains en capital (p. ex. pièces d’or, peinture, etc.) ",{"$nulls":55},{"$f":"FV(BB64,+$AR$28-$AG$28,,-AV64,1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+(BH64-AJ64)*'List French'!$B$1","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+BH64","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Estimation de la récupération de l’amortissement sur les actifs d’entreprise détenus à titre personnel",{"$nulls":67},{"v":0,"d":"0 "}]
[]
[{"$nulls":3},"Estimation de la perte finale sur les actifs d’entreprise ou de location détenus par des particuliers",{"$nulls":67},{"v":0,"d":"0 "}]
[]
[{"$nulls":3},"Autres actifs facilement encaissables",{"$nulls":55},{"$f":"FV(BB70,+$AR$28-$AG$28,-AP70,-AV70,1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+(BH70-AJ70-(AP70*($AR$28-$AG$28)))*'List French'!$B$1","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"BH70","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Autres actifs non encaissables",{"$nulls":55},{"$f":"FV(BB72,+$AR$28-$AG$28,-AP72,-AV72,1)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"+(BH72-AJ72-(AP72*($AR$28-$AG$28)))*'List French'!$B$1","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"BH72","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Portion garantie de la rente",{"$nulls":67},{"$f":"BH74","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Couverture d’assurance vie en vigueur (prestation de décès – seulement si la succession est le bénéficiaire)",{"$nulls":55},{"v":200000,"d":"200,000"},{"$nulls":5},{"v":0,"d":"0 "},{"$nulls":5},{"$f":"BH76","v":{"v":200000,"d":"200,000 "}}]
[]
[]
[{"$nulls":59},"Total",{"$nulls":5},{"$f":"SUM(BN40:BN76)","v":{"v":1209025.9331495021,"d":"1,209,026 "}},{"$nulls":5},{"$f":"SUM(BT40:BT76)","v":{"v":2409025.933149502,"d":"2,409,026 "}}]
[]
[]
[]
[]
[]
[]
[null,null,"Retenues"]
[]
[]
[{"$nulls":65},"Revenu/gain imposable",{"$nulls":5},"Succession"]
[]
[{"$nulls":3},"Prêt hypothécaire/emprunt sur bien immobilier inclus dans la succession ci-dessus",{"$nulls":61},{"v":0,"d":"0 "}]
[]
[{"$nulls":3},"Exemption pour résidence principale (%)",{"$nulls":43},{"v":1,"d":"100.00%"},{"$nulls":17},{"$f":"+BN56*AV93","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Déduction cumulative des gains en capital (½ du montant de l’exemption)",{"$nulls":43},{"$f":"+VLOOKUP($AR$28,'LTCGE French'!$B$2:$D$101,3)","v":{"v":840337.4875043397,"d":"840,337 "}}]
[{"$nulls":3},"Maximum indexé en fonction de l’inflation de la déduction cumulative des gains en capital à l’âge de comparaison"]
[]
[{"$nulls":3},"Other"]
[]
[]
[{"$nulls":59},"Total",{"$nulls":5},{"$f":"SUM(BN93:BN98)","v":{"v":0,"d":"0 "}},{"$nulls":5},{"$f":"BT91","v":{"v":0,"d":"0 "}}]
[]
[]
[]
[]
[]
[]
[null,null,"Sommaire des liquidités"]
[]
[]
[{"$nulls":3},"Actif liquide",{"$nulls":6},{"$f":"BH40+BH42+BH44+BH46+BH48+BH50+BH52+BH70","v":{"v":209025.93314950223,"d":"209,026 "}},{"$nulls":6},"Prestation de décès à la succession",{"$nulls":17},{"$f":"BH76","v":{"v":200000,"d":"200,000 "}},{"$nulls":6},"Total des espèces requises",{"$nulls":11},{"$f":"U140","v":{"v":821850.3005582063,"d":"821,850 "}},{"$nulls":6},"Excédent / (Déficit)",{"$nulls":8},{"$f":"K111-BC111+AJ111","v":{"v":-412824.367408704,"d":"(412,824)"}}]
[]
[]
[]
[]
[]
[]
[null,null,"Passif et dépenses"]
[]
[]
[{"$nulls":15},"En % de la succession",{"$nulls":4},"Montant"]
[]
[{"$nulls":3},"Prêt hypothécaire",{"$nulls":16},{"$f":"BT91","v":{"v":0,"d":"0 "}}]
[]
[{"$nulls":3},"Autres dettes et passifs au décès"]
[]
[{"$nulls":3},"Frais juridiques",{"$nulls":11},{"v":0.02,"d":"2.00%"},{"$nulls":4},{"$f":"+P127*($BT$79-$BT$101)","v":{"v":48180.51866299004,"d":"48,181 "}}]
[]
[{"$nulls":3},"Frais de comptabilité",{"$nulls":11},{"v":0.02,"d":"2.00%"},{"$nulls":4},{"$f":"+P129*($BT$79-$BT$101)","v":{"v":48180.51866299004,"d":"48,181 "}}]
[]
[{"$nulls":3},"Honoraires du fiduciaire / liquidateur",{"$nulls":11},{"v":0.05,"d":"5.00%"},{"$nulls":4},{"$f":"+P131*($BT$79-$BT$101)","v":{"v":120451.29665747512,"d":"120,451 "}}]
[]
[{"$nulls":3},"Autres dépenses finales"]
[]
[{"$nulls":3},"Impôt sur le revenu à payer",{"$nulls":16},{"$f":"+(BN79-BN101)*$BS$28","v":{"v":604512.9665747511,"d":"604,513 "}}]
[]
[{"$nulls":3},"Frais d’homologation à payer",{"$nulls":16},{"$f":"+VLOOKUP(BE28,'List French'!$A$5:$D$17,4)","v":{"v":525,"d":"525 "}}]
[]
[]
[{"$nulls":3},"Diminution attendue de la succession en raison des dettes, des dépenses et des impôts",{"$nulls":16},{"$f":"SUM(U123:U137)","v":{"v":821850.3005582063,"d":"821,850 "}}]
[]
[]
[]
[null,null,{"$f":"\"Le besoin potentiel d’assurance vie nécessaire pour éviter que votre succession ne diminue s’élève à \"&TEXT(U140,\"#00 000\")&\" $. \"&IF(Fre_Adv_Use_In_Printouts=\"Non\",\"Communiquez avec votre agent d'assurance vie RBC pour trouver la solution d'assurance qui vous convient.\",\"Contactez \"&Fre_Prepared_By&\" pour trouver la solution d’assurance qui vous convient.\")","v":"Le besoin potentiel d’assurance vie nécessaire pour éviter que votre succession ne diminue s’élève à 821 850 $. Communiquez avec votre agent d'assurance vie RBC pour trouver la solution d'assurance qui vous convient."}]

{"sheet":"Considérations","index":5,"n_rows":46,"n_cols":4,"rows_kept":46,"merged":[[14,2,14,76],[15,2,15,76],[16,2,16,76],[18,3,18,76],[19,3,19,76],[20,3,20,76],[21,3,21,76],[22,3,22,76],[23,3,23,76],[24,3,24,76],[30,2,30,76],[31,2,31,76],[32,2,32,76],[34,3,34,76],[35,3,35,76],[36,3,36,76],[37,3,37,76],[38,3,38,76],[39,3,39,76],[40,3,40,76],[41,3,41,76],[42,3,42,76],[43,3,43,76],[44,3,44,76],[45,3,45,76]]}
{"$rows_empty":15}
[null,null,"Considérations d’ordre général"]
[]
[]
[null,null,1,"La Compagnie d’assurance vie RBC recommande de consulter vos conseillers juridiques, comptables, fiscaux et financiers avant de prendre une décision. Les renseignements contenus dans cette présentation ne devraient pas être interprétés comme des conseils d’ordre fiscal, juridique, comptable ou financier."]
[null,null,2,"La Compagnie d’assurance vie RBC n’accepte aucune responsabilité pour toute perte directe, indirecte ou consécutive découlant des renseignements dans cette présentation."]
[null,null,3,"Des précautions raisonnables ont été prises pour garantir l’exactitude des calculs et des renseignements fournis, mais des erreurs et des omissions sont possibles."]
[null,null,4,"Si une police d’assurance est établie, la couverture sera régie par les conditions de la police. Cette présentation ne fait pas partie d’une police établie."]
[null,null,5,"La souscription d’une police d’assurance vie est un engagement à long terme. Le rachat de la police peut avoir d’importantes répercussions fiscales et financières."]
[null,null,6,"Il ne s’agit pas d’un exposé d’assurance."]
[null,null,7,"Afin d’assurer l’exactitude des chiffres que vous communiquez à vos clients, il est important que vous utilisiez la dernière version de l’outil Estimation du transfert de patrimoine RBC."]
[]
[]
[]
[]
[]
[]
[null,null,"Éléments à considérer dans le calcul et hypothèses"]
[]
[]
[null,null,1,"Le passif successoral est calculé en multipliant le revenu ou gain imposable par le taux d’imposition marginal. Sauf indication contraire, tout autre crédit ou toute autre déduction auxquels le client pourrait avoir droit n’ont pas été pris en compte dans ce calcul."]
[null,null,{"$f":"1+C35","v":2},{"$f":"\"Le taux d’inflation annuel utilisé est de \"&LTCGE!$H$1&\".\"","v":"Le taux d’inflation annuel utilisé est de 30,0%."}]
[null,null,3,"Le montant maximum de l’exemption cumulative des gains en capital pour l’année de comparaison est une estimation. Le plafond réel applicable pour l’année du décès peut être différent de celui indiqué dans la présente présentation."]
[null,null,4,"Il est présumé qu’aucun report de pertes en capital ou autres ne pourra être utilisé pour réduire les gains ou le revenu imposables au cours de l’année du décès."]
[null,null,5,"Les obligations fiscales à l’étranger et les crédits d’impôt potentiels découlant de ces obligations fiscales ne sont pas pris en compte dans le calcul."]
[null,null,6,"Les gains ou les pertes en capital sont calculés en fonction du prix de base rajusté et de la juste valeur de marché projetée des actifs. Les règles spéciales qui s’appliquent aux biens à usage personnel et aux biens meubles désignés ne sont pas prises en compte dans ce calcul."]
[null,null,7,"La valeur future du FERR est calculée en supposant que le montant minimum requis en vertu de la Loi de l’impôt sur le revenu (Canada) sera retiré à partir de l’âge de 71 ans."]
[null,null,8,"Lorsqu’un bénéficiaire a été désigné, on suppose que la valeur de cet élément d’actif ne sera pas incluse dans le calcul de l’impôt successoral."]
[null,null,9,"On suppose qu’aucun retrait ne sera effectué des actifs et qu’ils continueront de croître à un taux de croissance déterminé chaque année. Toutefois, il est possible que la valeur des actifs diminue même si aucun retrait n’est effectué."]
[null,null,10,"La calculatrice ne calcule que le revenu ou le gain qui peut découler de divers éléments d’actif détenus au décès. Elle ne tient pas compte d’autres revenus gagnés au cours de l’année du décès ou de l’une des années précédentes."]
[null,null,11,"L’impôt successoral éventuel est une estimation simplifiée seulement. La calculatrice ne vise pas à remplacer le calcul détaillé selon les règles applicables dans la province ou le territoire visé. "]
[null,null,12,"Tous les montants, autres que les pourcentages, sont exprimés en dollars canadiens."]

{"sheet":"Raw Data","index":6,"n_rows":39,"n_cols":9,"rows_kept":39,"hidden":true}
[]
[null,"French"]
[{"$nulls":6},"M"]
[null,"Your beneficiary likely gets",{"$f":"C19","v":{"v":1587175.632591296,"d":"$1.6 M"}},null,null,"Liquid",{"$f":"Input!K111","v":{"v":209025.93314950223,"d":"209,026 "}},{"$f":"G4","v":{"v":209025.93314950223,"d":"$0.2 M"}},{"$f":"IF($B$2=\"French\",SUBSTITUTE(TEXT(H4/100000,\"# ##0.0\"),\".\",\",\")&\" M$\",H4)","v":" 2,1 M$"}]
[null,"Your estate pays in taxes etc.",{"$f":"C20","v":{"v":821850.3005582063,"d":"$0.8 M"}},null,null,"Non-Liquid",{"$f":"C7-G4","v":{"v":2200000,"d":"2,200,000"}},{"$f":"G5","v":{"v":2200000,"d":"$2.2 M"}},{"$f":"IF($B$2=\"French\",SUBSTITUTE(TEXT(H5/100000,\"# ##0.0\"),\".\",\",\")&\" M$\",H5)","v":" 22,0 M$"}]
[]
[null,null,{"$f":"Input!$BP$79","v":{"v":2409025.933149502,"d":"2,409,026"}}]
[]
[]
[null,"Votre bénéficiaire reçoit",{"$f":"C4","v":{"v":1587175.632591296,"d":"$1.6 M"}},{"$f":"IF($B$2=\"French\",SUBSTITUTE(TEXT(C10/100000,\"# ##0.0\"),\".\",\",\")&\" M$\",C10)","v":" 15,9 M$"}]
[null,"Votre succession paie en impôts, etc",{"$f":"C5","v":{"v":821850.3005582063,"d":"$0.8 M"}},{"$f":"IF($B$2=\"French\",SUBSTITUTE(TEXT(C11/100000,\"# ##0.0\"),\".\",\",\")&\" M$\",C11)","v":" 8,2 M$"}]
{"$rows_empty":7}
[null,"Your beneficiary likely gets",{"$f":"C22-C20","v":{"v":1587175.632591296,"d":"1,587,176"}},{"$f":"C19","v":{"v":1587175.632591296,"d":"$1.6 M"}},{"$f":"IF($B$2=\"French\",SUBSTITUTE(TEXT(D19/100000,\"# ##0.0\"),\".\",\",\")&\" M$\",D19)","v":" 15,9 M$"}]
[null,"Your estate pays in taxes etc.",{"$f":"Input!$U$140","v":{"v":821850.3005582063,"d":"821,850"}},{"$f":"C20","v":{"v":821850.3005582063,"d":"$0.8 M"}},{"$f":"IF($B$2=\"French\",SUBSTITUTE(TEXT(D20/100000,\"# ##0.0\"),\".\",\",\")&\" M$\",D20)","v":" 8,2 M$"}]
[]
[null,null,{"$f":"Input!$BP$79","v":{"v":2409025.933149502,"d":"2,409,026"}},{"$f":"C22","v":{"v":2409025.933149502,"d":"$2.4 M"}},{"$f":"IF($B$2=\"French\",SUBSTITUTE(TEXT(D22/100000,\"# ##0.0\"),\".\",\",\")&\" M$\",D22)","v":" 24,1 M$"}]
[]
[]
[]
[null,"Available for beneficiary",{"$f":"C4","v":{"v":1587175.632591296,"d":"$1.6 M"}},{"$f":"IF($B$2=\"French\",SUBSTITUTE(TEXT(C26/100000,\"# ##0.0\"),\".\",\",\")&\" M$\",C26)","v":" 15,9 M$"}]
[null,"Shrinkage due to tax and expenses",{"$f":"C5","v":{"v":821850.3005582063,"d":"$0.8 M"}},{"$f":"IF($B$2=\"French\",SUBSTITUTE(TEXT(C27/100000,\"# ##0.0\"),\".\",\",\")&\" M$\",C27)","v":" 8,2 M$"}]
[]
[]
[]
[]
[]
[null,"Total Estate Value",{"$f":"D22","v":{"v":2409025.933149502,"d":"$2.4 M"}},{"$f":"IF($B$2=\"French\",SUBSTITUTE(TEXT(C33/100000,\"# ##0.0\"),\".\",\",\")&\" M$\",C33)","v":" 24,1 M$"}]
[null,"Shrinkage due to tax and other expenses",{"$f":"D20","v":{"v":821850.3005582063,"d":"$0.8 M"}}," 8,2 M$"]
[null,"Liquid Assets",{"$f":"H4","v":{"v":209025.93314950223,"d":"$0.2 M"}}," 2,1 M$"]
[]
[null,"Total Estate Value"]
[null,"Shrinkage due to tax and other expenses"]
[null,"Liquid Assets"]

{"sheet":"Notes","index":7,"n_rows":44,"n_cols":2,"rows_kept":44,"hidden":true}
[]
["Nehal"]
["Done","1. The text in the “about this calculator should be changed as under:"]
[null,"The purpose of this calculator is to estimate the income tax and estate tax that may become payable upon your death based on the assets you may own at that time and show its impact on your estate. The calculation assumes that you are either single or last to die spouse/common law-partner."]
["Done","2. The width of client information section should be expanded to match the size of other sections. May be client name, age and comparison age would appear in one row, and the province and marginal tax rate would appear in next row."]
[null,"3. If possible design the calculator such that if the client’s current age is 72 or higher, the RRSP row does not appear."]
["Will see what I can do during the coding part of this calculator. Might be able to hide the RRSP row altogether when the age is high enough."]
["Done","4. The formulas in “data entry” tab of the excel file Is end may be directly included in this input tab. The we will not need data entry tab."]
["It will","5. The column width needs to be adjusted so that all content fit in either portrait or landscape orientation."]
["It will","6. Also the $ amount cell should adjust auto-adjust the width based on the value entered/calculated. The value will be without decimals (except for %)."]
["Done","7. Please expand the width of deductions section so that columns align with the section above."]
[null,"8. If we are going with pie chart, the it may be added besides the “liabilities and expenses” section."]
["Done","9. The “total” in “liabilities and expenses” section may be retitled as “expected shrinkage in estate due liabilities, expenses and taxes”. That may help lead the conversation to potential insurance need."]
[null,"10. Mitch / Jean Guy – please suggest a client-friendly name for this calculator based on your experience in the field. Not sure if we want to call the final version “terminal tax calculator”."]
[]
[]
[]
[]
["Mitch"]
["Done","In the “about this calculator” section, we can add a sentence that says “A permanent life insurance policy like RBC Insurance’s Growth Insurance or Growth Insurance Plus may provide an excellent solution for your estate’s liquidity shortfall”."]
["Done","Most of the headings are pretty self explanatory but for the two that say “please specify”, I would eliminate that wording as there is nowhere on the sheet to specify.  I don’t want to put a bunch of explanatory notes where not necessary.  I would like to keep this simple and flexible."]
["Done","In deductions, I would change “real estate property” to “real property”"]
["Done","I would like to see a title like “Estate Liability Calculator” as the calculator encompasses taxes and other liabilities"]
[null,"I agree with Nehal’s Point 3, but another solution could be to not allow RRSP input with some sort of warning.  Whatever is easiest."]
[null,"Personally, I like the left alignments and different widths for the different sections."]
[]
[null,"The purpose of this calculator is to estimate the income tax and estate administration tax/probate fees that may become payable upon your death based on the assets you may own at that time and show its impact on your estate. The calculation assumes that you are either single or last to die spouse/common law-partner."]
[]
["Nehal - 2nd email"]
[null,"1. Following cells cannot have value less than zero."]
["done","A. All data entry cells"]
["done","B. W51 (i.e. loss on disposition of principal residence is deemed to be nil)"]
["done","2. Cell W63 cannot be positive (i.e. terminal loss amount should be entered as negative)."]
["done","3. The maximum value in cell W90 should be lower of (i) K90, and (ii) W55. The minimum value would be zero."]
["yes","4. I am assuming all greyed out cells will be protected."]
["when protected, formulae are not visible","5. Is it possible to hide the formula that appear in various cells in the final version?"]
[]
["Note does not move","1. The notes in cell BJ43, BJ47 and BJ86 should appear similar to the comment in BJ59."]
["Done","2. Need to add FV calculation formula in BD61 and BD63."]
["Done","3. Need to enter gain/loss calculation formula in cell BJ61 and BJ63 – the formula will be similar to the one in cell BJ39."]
["Done","4. Please delete the cell AG65 and AS65."]
["Done","5. Please add following note to cell BD65 – This is the lump sum amount to be paid on termination of the annuity."]
["Done","6. Please add following note to cell BJ65 – The lump sum amount to be paid less the adjusted cost basis of the annuity at death. If negative – enter zero. Is it possible to add a validating macro in the background that will prompt the user to correct the data entry if a negative amount is entered."]
["Done","7. Also, a $ sign should appear before all amounts, including the values in pie chart."]

{"sheet":"List","index":8,"n_rows":72,"n_cols":4,"rows_kept":72,"hidden":true}
["Capital gains inclusion factor",{"v":0.5,"d":"50.00%"}]
[]
["Province","Estate tax"]
[]
["AB",{"$f":"+'Estate tax rates'!H7","v":{"v":525,"d":"525.00"}},"Alberta",{"$f":"B5","v":{"v":525,"d":"525.00"}}]
["BC",{"$f":"+'Estate tax rates'!H12","v":{"v":33390,"d":"33,390.00"}},"British Columbia",{"$f":"B6","v":{"v":33390,"d":"33,390.00"}}]
["MB",{"$f":"+'Estate tax rates'!H15","v":0},"Manitoba",0]
["NB",{"$f":"+'Estate tax rates'!H22","v":{"v":12050,"d":"12,050.00"}},"New Brunswick",{"v":12050,"d":"12,050.00"}]
["NL",{"$f":"+'Estate tax rates'!H26","v":{"v":14508.6,"d":"14,508.60"}},"Newfoundland & Labrador",{"v":14508.6,"d":"14,508.60"}]
["NT",{"$f":"+'Estate tax rates'!H33","v":{"v":435,"d":"435.00"}},"Northwest Territories",{"v":435,"d":"435.00"}]
["NS",{"$f":"+'Estate tax rates'!H40","v":{"v":40157.15,"d":"40,157.15"}},"Nova Scotia",{"v":40157.15,"d":"40,157.15"}]
["NU",{"$f":"+'Estate tax rates'!H47","v":{"v":425,"d":"425.00"}},"Nunavut",{"v":425,"d":"425.00"}]
["ON ",{"$f":"+'Estate tax rates'!H51","v":{"v":35400,"d":"35,400.00"}},"Ontario",{"v":35400,"d":"35,400.00"}]
["PE",{"$f":"+'Estate tax rates'!H58","v":{"v":9640,"d":"9,640.00"}},"Prince Edward Island",{"v":9640,"d":"9,640.00"}]
["QC",{"$f":"+'Estate tax rates'!H61","v":{"v":230,"d":"230.00"}},"Quebec",{"v":230,"d":"230.00"}]
["SK",{"$f":"+'Estate tax rates'!H65","v":{"v":17070,"d":"17,070.00"}},"Saskatchewan",{"v":17070,"d":"17,070.00"}]
["YT",{"$f":"+'Estate tax rates'!H69","v":{"v":140,"d":"140.00"}},"Yukon",{"v":140,"d":"140.00"}]
[]
["Data validation for beneficiary designation"]
["Yes","Oui"]
["No","Non"]
[]
["Investment rate of return"]
[]
[{"v":0.0025,"d":"0.25%"}]
[{"$f":"+A25+0.25%","v":{"v":0.005,"d":"0.50%"}}]
[{"$f":"+A26+0.25%","v":{"v":0.0075,"d":"0.75%"}}]
[{"v":0.01,"d":"1.00%"}]
[{"v":0.0125,"d":"1.25%"}]
[{"v":0.015000000000000001,"d":"1.50%"}]
[{"v":0.0175,"d":"1.75%"}]
[{"v":0.02,"d":"2.00%"}]
[{"v":0.0225,"d":"2.25%"}]
[{"v":0.024999999999999998,"d":"2.50%"}]
[{"v":0.027499999999999997,"d":"2.75%"}]
[{"v":0.029999999999999995,"d":"3.00%"}]
[{"v":0.032499999999999994,"d":"3.25%"}]
[{"v":0.034999999999999996,"d":"3.50%"}]
[{"v":0.0375,"d":"3.75%"}]
[{"v":0.04,"d":"4.00%"}]
[{"v":0.0425,"d":"4.25%"}]
[{"v":0.045000000000000005,"d":"4.50%"}]
[{"v":0.04750000000000001,"d":"4.75%"}]
[{"v":0.05000000000000001,"d":"5.00%"}]
[{"v":0.05250000000000001,"d":"5.25%"}]
[{"v":0.055000000000000014,"d":"5.50%"}]
[{"v":0.057500000000000016,"d":"5.75%"}]
[{"v":0.06000000000000002,"d":"6.00%"}]
[{"v":0.06250000000000001,"d":"6.25%"}]
[{"v":0.06500000000000002,"d":"6.50%"}]
[{"v":0.06750000000000002,"d":"6.75%"}]
[{"v":0.07000000000000002,"d":"7.00%"}]
[{"v":0.07250000000000002,"d":"7.25%"}]
[{"v":0.07500000000000002,"d":"7.50%"}]
[{"v":0.07750000000000003,"d":"7.75%"}]
[{"v":0.08000000000000003,"d":"8.00%"}]
[{"v":0.08250000000000003,"d":"8.25%"}]
[{"v":0.08500000000000003,"d":"8.50%"}]
[{"v":0.08750000000000004,"d":"8.75%"}]
[{"v":0.09000000000000004,"d":"9.00%"}]
[{"v":0.09250000000000004,"d":"9.25%"}]
[{"v":0.09500000000000004,"d":"9.50%"}]
[{"v":0.09750000000000004,"d":"9.75%"}]
[{"v":0.10000000000000005,"d":"10.00%"}]
[{"v":0.10250000000000005,"d":"10.25%"}]
[{"v":0.10500000000000005,"d":"10.50%"}]
[{"v":0.10750000000000005,"d":"10.75%"}]
[{"v":0.11000000000000006,"d":"11.00%"}]
[{"v":0.11250000000000006,"d":"11.25%"}]
[{"v":0.11500000000000006,"d":"11.50%"}]
[{"v":0.11750000000000006,"d":"11.75%"}]
[{"v":0.12000000000000006,"d":"12.00%"}]

{"sheet":"LTCGE","index":9,"n_rows":101,"n_cols":9,"rows_kept":101,"hidden":true}
["Year","Age","LTCGE limit","LTCGD limit",null,"Inflation factor",{"v":0.03,"d":"3%"},{"$f":"SUBSTITUTE(TEXT(G1*10,\"0.0%\"),\".\",\",\")","v":"30,0%"}]
[{"$f":"YEAR(NOW())","v":2024},{"$f":"Input!$AG$28","v":68},{"$f":"VLOOKUP(A2,$H$3:$I$4,2,FALSE)","v":{"v":1016836,"d":"1,016,836.00"}},{"$f":"+C2*50%","v":{"v":508418,"d":"508,418.00"}},{"$nulls":4},"Actual LTCGE"]
[{"$f":"+A2+1","v":2025},{"$f":"+B2+1","v":69},{"$f":"IF(ISNA(VLOOKUP(A3,$H$3:$I$4,2,FALSE)),C2*(1+$G$1),VLOOKUP(A3,$H$3:$I$4,2,FALSE))","v":{"v":1047341.0800000001,"d":"1,047,341.08"}},{"$f":"+C3*50%","v":{"v":523670.54000000004,"d":"523,670.54"}},{"$nulls":3},2023,{"v":971190,"d":"971,190.00"}]
[{"$f":"+A3+1","v":2026},{"$f":"+B3+1","v":70},{"$f":"IF(ISNA(VLOOKUP(A4,$H$3:$I$4,2,FALSE)),C3*(1+$G$1),VLOOKUP(A4,$H$3:$I$4,2,FALSE))","v":{"v":1078761.3124000002,"d":"1,078,761.31"}},{"v":539380.6562000001,"d":"539,380.66"},{"$nulls":3},2024,{"v":1016836,"d":"1,016,836.00"}]
[2027,71,{"v":1111124.1517720001,"d":"1,111,124.15"},{"v":555562.0758860001,"d":"555,562.08"}]
[2028,72,{"v":1144457.8763251603,"d":"1,144,457.88"},{"v":572228.9381625801,"d":"572,228.94"}]
[2029,73,{"v":1178791.612614915,"d":"1,178,791.61"},{"v":589395.8063074575,"d":"589,395.81"}]
[2030,74,{"v":1214155.3609933625,"d":"1,214,155.36"},{"v":607077.6804966812,"d":"607,077.68"}]
[2031,75,{"v":1250580.0218231634,"d":"1,250,580.02"},{"v":625290.0109115817,"d":"625,290.01"}]
[2032,76,{"v":1288097.4224778584,"d":"1,288,097.42"},{"v":644048.7112389292,"d":"644,048.71"}]
[2033,77,{"v":1326740.3451521941,"d":"1,326,740.35"},{"v":663370.1725760971,"d":"663,370.17"}]
[2034,78,{"v":1366542.55550676,"d":"1,366,542.56"},{"v":683271.27775338,"d":"683,271.28"}]
[2035,79,{"v":1407538.8321719628,"d":"1,407,538.83"},{"v":703769.4160859814,"d":"703,769.42"}]
[2036,80,{"v":1449764.9971371219,"d":"1,449,765.00"},{"v":724882.4985685609,"d":"724,882.50"}]
[2037,81,{"v":1493257.9470512355,"d":"1,493,257.95"},{"v":746628.9735256177,"d":"746,628.97"}]
[2038,82,{"v":1538055.6854627726,"d":"1,538,055.69"},{"v":769027.8427313863,"d":"769,027.84"}]
[2039,83,{"v":1584197.3560266558,"d":"1,584,197.36"},{"v":792098.6780133279,"d":"792,098.68"}]
[2040,84,{"v":1631723.2767074555,"d":"1,631,723.28"},{"v":815861.6383537278,"d":"815,861.64"}]
[2041,85,{"v":1680674.9750086793,"d":"1,680,674.98"},{"v":840337.4875043397,"d":"840,337.49"}]
[2042,86,{"v":1731095.2242589397,"d":"1,731,095.22"},{"v":865547.6121294699,"d":"865,547.61"}]
[2043,87,{"v":1783028.080986708,"d":"1,783,028.08"},{"v":891514.040493354,"d":"891,514.04"}]
[2044,88,{"v":1836518.9234163093,"d":"1,836,518.92"},{"v":918259.4617081546,"d":"918,259.46"}]
[2045,89,{"v":1891614.4911187987,"d":"1,891,614.49"},{"v":945807.2455593994,"d":"945,807.25"}]
[2046,90,{"v":1948362.9258523628,"d":"1,948,362.93"},{"v":974181.4629261814,"d":"974,181.46"}]
[2047,91,{"v":2006813.8136279336,"d":"2,006,813.81"},{"v":1003406.9068139668,"d":"1,003,406.91"}]
[2048,92,{"v":2067018.2280367718,"d":"2,067,018.23"},{"v":1033509.1140183859,"d":"1,033,509.11"}]
[2049,93,{"v":2129028.774877875,"d":"2,129,028.77"},{"v":1064514.3874389376,"d":"1,064,514.39"}]
[2050,94,{"v":2192899.638124211,"d":"2,192,899.64"},{"v":1096449.8190621056,"d":"1,096,449.82"}]
[2051,95,{"v":2258686.6272679376,"d":"2,258,686.63"},{"v":1129343.3136339688,"d":"1,129,343.31"}]
[2052,96,{"v":2326447.2260859758,"d":"2,326,447.23"},{"v":1163223.6130429879,"d":"1,163,223.61"}]
[2053,97,{"v":2396240.642868555,"d":"2,396,240.64"},{"v":1198120.3214342776,"d":"1,198,120.32"}]
[2054,98,{"v":2468127.862154612,"d":"2,468,127.86"},{"v":1234063.931077306,"d":"1,234,063.93"}]
[2055,99,{"v":2542171.6980192503,"d":"2,542,171.70"},{"v":1271085.8490096251,"d":"1,271,085.85"}]
[2056,100,{"v":2618436.848959828,"d":"2,618,436.85"},{"v":1309218.424479914,"d":"1,309,218.42"}]
[2057,101,{"v":2696989.9544286225,"d":"2,696,989.95"},{"v":1348494.9772143112,"d":"1,348,494.98"}]
[2058,102,{"v":2777899.653061481,"d":"2,777,899.65"},{"v":1388949.8265307406,"d":"1,388,949.83"}]
[2059,103,{"v":2861236.6426533256,"d":"2,861,236.64"},{"v":1430618.3213266628,"d":"1,430,618.32"}]
[2060,104,{"v":2947073.7419329253,"d":"2,947,073.74"},{"v":1473536.8709664627,"d":"1,473,536.87"}]
[2061,105,{"v":3035485.954190913,"d":"3,035,485.95"},{"v":1517742.9770954566,"d":"1,517,742.98"}]
[2062,106,{"v":3126550.5328166406,"d":"3,126,550.53"},{"v":1563275.2664083203,"d":"1,563,275.27"}]
[2063,107,{"v":3220347.04880114,"d":"3,220,347.05"},{"v":1610173.52440057,"d":"1,610,173.52"}]
[2064,108,{"v":3316957.460265174,"d":"3,316,957.46"},{"v":1658478.730132587,"d":"1,658,478.73"}]
[2065,109,{"v":3416466.184073129,"d":"3,416,466.18"},{"v":1708233.0920365646,"d":"1,708,233.09"}]
[2066,110,{"v":3518960.169595323,"d":"3,518,960.17"},{"v":1759480.0847976615,"d":"1,759,480.08"}]
[2067,111,{"v":3624528.974683183,"d":"3,624,528.97"},{"v":1812264.4873415914,"d":"1,812,264.49"}]
[2068,112,{"v":3733264.843923678,"d":"3,733,264.84"},{"v":1866632.421961839,"d":"1,866,632.42"}]
[2069,113,{"v":3845262.7892413884,"d":"3,845,262.79"},{"v":1922631.3946206942,"d":"1,922,631.39"}]
[2070,114,{"v":3960620.6729186303,"d":"3,960,620.67"},{"v":1980310.3364593151,"d":"1,980,310.34"}]
[2071,115,{"v":4079439.2931061895,"d":"4,079,439.29"},{"v":2039719.6465530947,"d":"2,039,719.65"}]
[2072,116,{"v":4201822.471899375,"d":"4,201,822.47"},{"v":2100911.2359496877,"d":"2,100,911.24"}]
[2073,117,{"v":4327877.146056357,"d":"4,327,877.15"},{"v":2163938.5730281784,"d":"2,163,938.57"}]
[2074,118,{"v":4457713.460438048,"d":"4,457,713.46"},{"v":2228856.730219024,"d":"2,228,856.73"}]
[2075,119,{"v":4591444.864251189,"d":"4,591,444.86"},{"v":2295722.4321255945,"d":"2,295,722.43"}]
[2076,120,{"v":4729188.2101787245,"d":"4,729,188.21"},{"v":2364594.1050893622,"d":"2,364,594.11"}]
[2077,121,{"v":4871063.856484086,"d":"4,871,063.86"},{"v":2435531.928242043,"d":"2,435,531.93"}]
[2078,122,{"v":5017195.772178609,"d":"5,017,195.77"},{"v":2508597.8860893045,"d":"2,508,597.89"}]
[2079,123,{"v":5167711.645343968,"d":"5,167,711.65"},{"v":2583855.822671984,"d":"2,583,855.82"}]
[2080,124,{"v":5322742.994704287,"d":"5,322,742.99"},{"v":2661371.4973521433,"d":"2,661,371.50"}]
[2081,125,{"v":5482425.284545415,"d":"5,482,425.28"},{"v":2741212.6422727075,"d":"2,741,212.64"}]
[2082,126,{"v":5646898.043081778,"d":"5,646,898.04"},{"v":2823449.021540889,"d":"2,823,449.02"}]
[2083,127,{"v":5816304.984374232,"d":"5,816,304.98"},{"v":2908152.492187116,"d":"2,908,152.49"}]
[2084,128,{"v":5990794.133905459,"d":"5,990,794.13"},{"v":2995397.0669527296,"d":"2,995,397.07"}]
[2085,129,{"v":6170517.9579226235,"d":"6,170,517.96"},{"v":3085258.9789613117,"d":"3,085,258.98"}]
[2086,130,{"v":6355633.496660302,"d":"6,355,633.50"},{"v":3177816.748330151,"d":"3,177,816.75"}]
[2087,131,{"v":6546302.5015601115,"d":"6,546,302.50"},{"v":3273151.2507800558,"d":"3,273,151.25"}]
[2088,132,{"v":6742691.576606915,"d":"6,742,691.58"},{"v":3371345.7883034577,"d":"3,371,345.79"}]
[2089,133,{"v":6944972.323905123,"d":"6,944,972.32"},{"$f":"+C67*50%","v":{"v":3472486.1619525617,"d":"3,472,486.16"}}]
[{"$f":"+A67+1","v":2090},{"$f":"+B67+1","v":134},{"$f":"IF(ISNA(VLOOKUP(A68,$H$3:$I$4,2,FALSE)),C67*(1+$G$1),VLOOKUP(A68,$H$3:$I$4,2,FALSE))","v":{"v":7153321.493622277,"d":"7,153,321.49"}},{"v":3576660.7468111385,"d":"3,576,660.75"}]
[2091,135,{"v":7367921.138430946,"d":"7,367,921.14"},{"v":3683960.569215473,"d":"3,683,960.57"}]
[2092,136,{"v":7588958.772583874,"d":"7,588,958.77"},{"v":3794479.386291937,"d":"3,794,479.39"}]
[2093,137,{"v":7816627.535761391,"d":"7,816,627.54"},{"v":3908313.7678806954,"d":"3,908,313.77"}]
[2094,138,{"v":8051126.361834233,"d":"8,051,126.36"},{"v":4025563.1809171163,"d":"4,025,563.18"}]
[2095,139,{"v":8292660.1526892595,"d":"8,292,660.15"},{"v":4146330.0763446297,"d":"4,146,330.08"}]
[2096,140,{"v":8541439.957269937,"d":"8,541,439.96"},{"v":4270719.978634968,"d":"4,270,719.98"}]
[2097,141,{"v":8797683.155988036,"d":"8,797,683.16"},{"v":4398841.577994018,"d":"4,398,841.58"}]
[2098,142,{"v":9061613.650667677,"d":"9,061,613.65"},{"v":4530806.825333838,"d":"4,530,806.83"}]
[2099,143,{"v":9333462.060187707,"d":"9,333,462.06"},{"v":4666731.030093853,"d":"4,666,731.03"}]
[2100,144,{"v":9613465.921993338,"d":"9,613,465.92"},{"v":4806732.960996669,"d":"4,806,732.96"}]
[2101,145,{"v":9901869.899653139,"d":"9,901,869.90"},{"v":4950934.949826569,"d":"4,950,934.95"}]
[2102,146,{"v":10198925.996642733,"d":"10,198,926.00"},{"v":5099462.9983213665,"d":"5,099,463.00"}]
[2103,147,{"v":10504893.776542015,"d":"10,504,893.78"},{"v":5252446.888271008,"d":"5,252,446.89"}]
[2104,148,{"v":10820040.589838276,"d":"10,820,040.59"},{"v":5410020.294919138,"d":"5,410,020.29"}]
[2105,149,{"v":11144641.807533424,"d":"11,144,641.81"},{"v":5572320.903766712,"d":"5,572,320.90"}]
[2106,150,{"v":11478981.061759427,"d":"11,478,981.06"},{"v":5739490.530879714,"d":"5,739,490.53"}]
[2107,151,{"v":11823350.493612211,"d":"11,823,350.49"},{"v":5911675.246806106,"d":"5,911,675.25"}]
[2108,152,{"v":12178051.008420577,"d":"12,178,051.01"},{"v":6089025.504210289,"d":"6,089,025.50"}]
[2109,153,{"v":12543392.538673194,"d":"12,543,392.54"},{"v":6271696.269336597,"d":"6,271,696.27"}]
[2110,154,{"v":12919694.31483339,"d":"12,919,694.31"},{"v":6459847.157416695,"d":"6,459,847.16"}]
[2111,155,{"v":13307285.144278392,"d":"13,307,285.14"},{"v":6653642.572139196,"d":"6,653,642.57"}]
[2112,156,{"v":13706503.698606744,"d":"13,706,503.70"},{"v":6853251.849303372,"d":"6,853,251.85"}]
[2113,157,{"v":14117698.809564946,"d":"14,117,698.81"},{"v":7058849.404782473,"d":"7,058,849.40"}]
[2114,158,{"v":14541229.773851896,"d":"14,541,229.77"},{"v":7270614.886925948,"d":"7,270,614.89"}]
[2115,159,{"v":14977466.667067453,"d":"14,977,466.67"},{"v":7488733.333533727,"d":"7,488,733.33"}]
[2116,160,{"v":15426790.667079477,"d":"15,426,790.67"},{"v":7713395.333539738,"d":"7,713,395.33"}]
[2117,161,{"v":15889594.387091862,"d":"15,889,594.39"},{"v":7944797.193545931,"d":"7,944,797.19"}]
[2118,162,{"v":16366282.218704619,"d":"16,366,282.22"},{"v":8183141.109352309,"d":"8,183,141.11"}]
[2119,163,{"v":16857270.685265757,"d":"16,857,270.69"},{"v":8428635.342632879,"d":"8,428,635.34"}]
[2120,164,{"v":17362988.805823732,"d":"17,362,988.81"},{"v":8681494.402911866,"d":"8,681,494.40"}]
[2121,165,{"v":17883878.469998445,"d":"17,883,878.47"},{"v":8941939.234999223,"d":"8,941,939.23"}]
[2122,166,{"v":18420394.8240984,"d":"18,420,394.82"},{"v":9210197.4120492,"d":"9,210,197.41"}]
[2123,167,{"v":18973006.668821353,"d":"18,973,006.67"},{"v":9486503.334410677,"d":"9,486,503.33"}]

{"sheet":"LTCGE French","index":10,"n_rows":101,"n_cols":7,"rows_kept":101,"hidden":true}
["Year","Age","LTCGE limit","LTCGD limit",null,"Inflation factor",{"$f":"LTCGE!G1","v":{"v":0.03,"d":"3%"}}]
[{"$f":"YEAR(NOW())","v":2024},{"$f":"Entrée!$AG$28","v":68},{"$f":"VLOOKUP(A2,LTCGE!$H$3:$I$4,2,FALSE)","v":{"v":1016836,"d":"1,016,836.00"}},{"$f":"+C2*50%","v":{"v":508418,"d":"508,418.00"}}]
[{"$f":"+A2+1","v":2025},{"$f":"+B2+1","v":69},{"$f":"IF(ISNA(VLOOKUP(A3,LTCGE!$H$3:$I$4,2,FALSE)),C2*(1+$G$1),VLOOKUP(A3,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1047341.0800000001,"d":"1,047,341.08"}},{"$f":"+C3*50%","v":{"v":523670.54000000004,"d":"523,670.54"}}]
[{"$f":"+A3+1","v":2026},70,{"$f":"IF(ISNA(VLOOKUP(A4,LTCGE!$H$3:$I$4,2,FALSE)),C3*(1+$G$1),VLOOKUP(A4,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1078761.3124000002,"d":"1,078,761.31"}},{"v":539380.6562000001,"d":"539,380.66"}]
[2027,71,{"$f":"IF(ISNA(VLOOKUP(A5,LTCGE!$H$3:$I$4,2,FALSE)),C4*(1+$G$1),VLOOKUP(A5,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1111124.1517720001,"d":"1,111,124.15"}},{"v":555562.0758860001,"d":"555,562.08"}]
[2028,72,{"$f":"IF(ISNA(VLOOKUP(A6,LTCGE!$H$3:$I$4,2,FALSE)),C5*(1+$G$1),VLOOKUP(A6,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1144457.8763251603,"d":"1,144,457.88"}},{"v":572228.9381625801,"d":"572,228.94"}]
[2029,73,{"$f":"IF(ISNA(VLOOKUP(A7,LTCGE!$H$3:$I$4,2,FALSE)),C6*(1+$G$1),VLOOKUP(A7,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1178791.612614915,"d":"1,178,791.61"}},{"v":589395.8063074575,"d":"589,395.81"}]
[2030,74,{"$f":"IF(ISNA(VLOOKUP(A8,LTCGE!$H$3:$I$4,2,FALSE)),C7*(1+$G$1),VLOOKUP(A8,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1214155.3609933625,"d":"1,214,155.36"}},{"v":607077.6804966812,"d":"607,077.68"}]
[2031,75,{"$f":"IF(ISNA(VLOOKUP(A9,LTCGE!$H$3:$I$4,2,FALSE)),C8*(1+$G$1),VLOOKUP(A9,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1250580.0218231634,"d":"1,250,580.02"}},{"v":625290.0109115817,"d":"625,290.01"}]
[2032,76,{"$f":"IF(ISNA(VLOOKUP(A10,LTCGE!$H$3:$I$4,2,FALSE)),C9*(1+$G$1),VLOOKUP(A10,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1288097.4224778584,"d":"1,288,097.42"}},{"v":644048.7112389292,"d":"644,048.71"}]
[2033,77,{"$f":"IF(ISNA(VLOOKUP(A11,LTCGE!$H$3:$I$4,2,FALSE)),C10*(1+$G$1),VLOOKUP(A11,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1326740.3451521941,"d":"1,326,740.35"}},{"v":663370.1725760971,"d":"663,370.17"}]
[2034,78,{"$f":"IF(ISNA(VLOOKUP(A12,LTCGE!$H$3:$I$4,2,FALSE)),C11*(1+$G$1),VLOOKUP(A12,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1366542.55550676,"d":"1,366,542.56"}},{"v":683271.27775338,"d":"683,271.28"}]
[2035,79,{"$f":"IF(ISNA(VLOOKUP(A13,LTCGE!$H$3:$I$4,2,FALSE)),C12*(1+$G$1),VLOOKUP(A13,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1407538.8321719628,"d":"1,407,538.83"}},{"v":703769.4160859814,"d":"703,769.42"}]
[2036,80,{"$f":"IF(ISNA(VLOOKUP(A14,LTCGE!$H$3:$I$4,2,FALSE)),C13*(1+$G$1),VLOOKUP(A14,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1449764.9971371219,"d":"1,449,765.00"}},{"v":724882.4985685609,"d":"724,882.50"}]
[2037,81,{"$f":"IF(ISNA(VLOOKUP(A15,LTCGE!$H$3:$I$4,2,FALSE)),C14*(1+$G$1),VLOOKUP(A15,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1493257.9470512355,"d":"1,493,257.95"}},{"v":746628.9735256177,"d":"746,628.97"}]
[2038,82,{"$f":"IF(ISNA(VLOOKUP(A16,LTCGE!$H$3:$I$4,2,FALSE)),C15*(1+$G$1),VLOOKUP(A16,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1538055.6854627726,"d":"1,538,055.69"}},{"v":769027.8427313863,"d":"769,027.84"}]
[2039,83,{"$f":"IF(ISNA(VLOOKUP(A17,LTCGE!$H$3:$I$4,2,FALSE)),C16*(1+$G$1),VLOOKUP(A17,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1584197.3560266558,"d":"1,584,197.36"}},{"v":792098.6780133279,"d":"792,098.68"}]
[2040,84,{"$f":"IF(ISNA(VLOOKUP(A18,LTCGE!$H$3:$I$4,2,FALSE)),C17*(1+$G$1),VLOOKUP(A18,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1631723.2767074555,"d":"1,631,723.28"}},{"v":815861.6383537278,"d":"815,861.64"}]
[2041,85,{"$f":"IF(ISNA(VLOOKUP(A19,LTCGE!$H$3:$I$4,2,FALSE)),C18*(1+$G$1),VLOOKUP(A19,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1680674.9750086793,"d":"1,680,674.98"}},{"v":840337.4875043397,"d":"840,337.49"}]
[{"$f":"+A19+1","v":2042},86,{"$f":"IF(ISNA(VLOOKUP(A20,LTCGE!$H$3:$I$4,2,FALSE)),C19*(1+$G$1),VLOOKUP(A20,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1731095.2242589397,"d":"1,731,095.22"}},{"v":865547.6121294699,"d":"865,547.61"}]
[2043,87,{"$f":"IF(ISNA(VLOOKUP(A21,LTCGE!$H$3:$I$4,2,FALSE)),C20*(1+$G$1),VLOOKUP(A21,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1783028.080986708,"d":"1,783,028.08"}},{"v":891514.040493354,"d":"891,514.04"}]
[2044,88,{"$f":"IF(ISNA(VLOOKUP(A22,LTCGE!$H$3:$I$4,2,FALSE)),C21*(1+$G$1),VLOOKUP(A22,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1836518.9234163093,"d":"1,836,518.92"}},{"v":918259.4617081546,"d":"918,259.46"}]
[2045,89,{"$f":"IF(ISNA(VLOOKUP(A23,LTCGE!$H$3:$I$4,2,FALSE)),C22*(1+$G$1),VLOOKUP(A23,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1891614.4911187987,"d":"1,891,614.49"}},{"v":945807.2455593994,"d":"945,807.25"}]
[2046,90,{"$f":"IF(ISNA(VLOOKUP(A24,LTCGE!$H$3:$I$4,2,FALSE)),C23*(1+$G$1),VLOOKUP(A24,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":1948362.9258523628,"d":"1,948,362.93"}},{"v":974181.4629261814,"d":"974,181.46"}]
[2047,91,{"$f":"IF(ISNA(VLOOKUP(A25,LTCGE!$H$3:$I$4,2,FALSE)),C24*(1+$G$1),VLOOKUP(A25,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":2006813.8136279336,"d":"2,006,813.81"}},{"v":1003406.9068139668,"d":"1,003,406.91"}]
[2048,92,{"$f":"IF(ISNA(VLOOKUP(A26,LTCGE!$H$3:$I$4,2,FALSE)),C25*(1+$G$1),VLOOKUP(A26,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":2067018.2280367718,"d":"2,067,018.23"}},{"v":1033509.1140183859,"d":"1,033,509.11"}]
[2049,93,{"$f":"IF(ISNA(VLOOKUP(A27,LTCGE!$H$3:$I$4,2,FALSE)),C26*(1+$G$1),VLOOKUP(A27,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":2129028.774877875,"d":"2,129,028.77"}},{"v":1064514.3874389376,"d":"1,064,514.39"}]
[2050,94,{"$f":"IF(ISNA(VLOOKUP(A28,LTCGE!$H$3:$I$4,2,FALSE)),C27*(1+$G$1),VLOOKUP(A28,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":2192899.638124211,"d":"2,192,899.64"}},{"v":1096449.8190621056,"d":"1,096,449.82"}]
[2051,95,{"$f":"IF(ISNA(VLOOKUP(A29,LTCGE!$H$3:$I$4,2,FALSE)),C28*(1+$G$1),VLOOKUP(A29,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":2258686.6272679376,"d":"2,258,686.63"}},{"v":1129343.3136339688,"d":"1,129,343.31"}]
[2052,96,{"$f":"IF(ISNA(VLOOKUP(A30,LTCGE!$H$3:$I$4,2,FALSE)),C29*(1+$G$1),VLOOKUP(A30,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":2326447.2260859758,"d":"2,326,447.23"}},{"v":1163223.6130429879,"d":"1,163,223.61"}]
[2053,97,{"$f":"IF(ISNA(VLOOKUP(A31,LTCGE!$H$3:$I$4,2,FALSE)),C30*(1+$G$1),VLOOKUP(A31,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":2396240.642868555,"d":"2,396,240.64"}},{"v":1198120.3214342776,"d":"1,198,120.32"}]
[2054,98,{"$f":"IF(ISNA(VLOOKUP(A32,LTCGE!$H$3:$I$4,2,FALSE)),C31*(1+$G$1),VLOOKUP(A32,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":2468127.862154612,"d":"2,468,127.86"}},{"v":1234063.931077306,"d":"1,234,063.93"}]
[2055,99,{"$f":"IF(ISNA(VLOOKUP(A33,LTCGE!$H$3:$I$4,2,FALSE)),C32*(1+$G$1),VLOOKUP(A33,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":2542171.6980192503,"d":"2,542,171.70"}},{"v":1271085.8490096251,"d":"1,271,085.85"}]
[2056,100,{"$f":"IF(ISNA(VLOOKUP(A34,LTCGE!$H$3:$I$4,2,FALSE)),C33*(1+$G$1),VLOOKUP(A34,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":2618436.848959828,"d":"2,618,436.85"}},{"v":1309218.424479914,"d":"1,309,218.42"}]
[2057,101,{"$f":"IF(ISNA(VLOOKUP(A35,LTCGE!$H$3:$I$4,2,FALSE)),C34*(1+$G$1),VLOOKUP(A35,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":2696989.9544286225,"d":"2,696,989.95"}},{"v":1348494.9772143112,"d":"1,348,494.98"}]
[{"$f":"+A35+1","v":2058},102,{"$f":"IF(ISNA(VLOOKUP(A36,LTCGE!$H$3:$I$4,2,FALSE)),C35*(1+$G$1),VLOOKUP(A36,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":2777899.653061481,"d":"2,777,899.65"}},{"v":1388949.8265307406,"d":"1,388,949.83"}]
[2059,103,{"$f":"IF(ISNA(VLOOKUP(A37,LTCGE!$H$3:$I$4,2,FALSE)),C36*(1+$G$1),VLOOKUP(A37,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":2861236.6426533256,"d":"2,861,236.64"}},{"v":1430618.3213266628,"d":"1,430,618.32"}]
[2060,104,{"$f":"IF(ISNA(VLOOKUP(A38,LTCGE!$H$3:$I$4,2,FALSE)),C37*(1+$G$1),VLOOKUP(A38,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":2947073.7419329253,"d":"2,947,073.74"}},{"v":1473536.8709664627,"d":"1,473,536.87"}]
[2061,105,{"$f":"IF(ISNA(VLOOKUP(A39,LTCGE!$H$3:$I$4,2,FALSE)),C38*(1+$G$1),VLOOKUP(A39,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":3035485.954190913,"d":"3,035,485.95"}},{"v":1517742.9770954566,"d":"1,517,742.98"}]
[2062,106,{"$f":"IF(ISNA(VLOOKUP(A40,LTCGE!$H$3:$I$4,2,FALSE)),C39*(1+$G$1),VLOOKUP(A40,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":3126550.5328166406,"d":"3,126,550.53"}},{"v":1563275.2664083203,"d":"1,563,275.27"}]
[2063,107,{"$f":"IF(ISNA(VLOOKUP(A41,LTCGE!$H$3:$I$4,2,FALSE)),C40*(1+$G$1),VLOOKUP(A41,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":3220347.04880114,"d":"3,220,347.05"}},{"v":1610173.52440057,"d":"1,610,173.52"}]
[2064,108,{"$f":"IF(ISNA(VLOOKUP(A42,LTCGE!$H$3:$I$4,2,FALSE)),C41*(1+$G$1),VLOOKUP(A42,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":3316957.460265174,"d":"3,316,957.46"}},{"v":1658478.730132587,"d":"1,658,478.73"}]
[2065,109,{"$f":"IF(ISNA(VLOOKUP(A43,LTCGE!$H$3:$I$4,2,FALSE)),C42*(1+$G$1),VLOOKUP(A43,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":3416466.184073129,"d":"3,416,466.18"}},{"v":1708233.0920365646,"d":"1,708,233.09"}]
[2066,110,{"$f":"IF(ISNA(VLOOKUP(A44,LTCGE!$H$3:$I$4,2,FALSE)),C43*(1+$G$1),VLOOKUP(A44,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":3518960.169595323,"d":"3,518,960.17"}},{"v":1759480.0847976615,"d":"1,759,480.08"}]
[2067,111,{"$f":"IF(ISNA(VLOOKUP(A45,LTCGE!$H$3:$I$4,2,FALSE)),C44*(1+$G$1),VLOOKUP(A45,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":3624528.974683183,"d":"3,624,528.97"}},{"v":1812264.4873415914,"d":"1,812,264.49"}]
[2068,112,{"$f":"IF(ISNA(VLOOKUP(A46,LTCGE!$H$3:$I$4,2,FALSE)),C45*(1+$G$1),VLOOKUP(A46,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":3733264.843923678,"d":"3,733,264.84"}},{"v":1866632.421961839,"d":"1,866,632.42"}]
[2069,113,{"$f":"IF(ISNA(VLOOKUP(A47,LTCGE!$H$3:$I$4,2,FALSE)),C46*(1+$G$1),VLOOKUP(A47,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":3845262.7892413884,"d":"3,845,262.79"}},{"v":1922631.3946206942,"d":"1,922,631.39"}]
[2070,114,{"$f":"IF(ISNA(VLOOKUP(A48,LTCGE!$H$3:$I$4,2,FALSE)),C47*(1+$G$1),VLOOKUP(A48,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":3960620.6729186303,"d":"3,960,620.67"}},{"v":1980310.3364593151,"d":"1,980,310.34"}]
[2071,115,{"$f":"IF(ISNA(VLOOKUP(A49,LTCGE!$H$3:$I$4,2,FALSE)),C48*(1+$G$1),VLOOKUP(A49,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":4079439.2931061895,"d":"4,079,439.29"}},{"v":2039719.6465530947,"d":"2,039,719.65"}]
[2072,116,{"$f":"IF(ISNA(VLOOKUP(A50,LTCGE!$H$3:$I$4,2,FALSE)),C49*(1+$G$1),VLOOKUP(A50,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":4201822.471899375,"d":"4,201,822.47"}},{"v":2100911.2359496877,"d":"2,100,911.24"}]
[2073,117,{"$f":"IF(ISNA(VLOOKUP(A51,LTCGE!$H$3:$I$4,2,FALSE)),C50*(1+$G$1),VLOOKUP(A51,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":4327877.146056357,"d":"4,327,877.15"}},{"v":2163938.5730281784,"d":"2,163,938.57"}]
[{"$f":"+A51+1","v":2074},118,{"$f":"IF(ISNA(VLOOKUP(A52,LTCGE!$H$3:$I$4,2,FALSE)),C51*(1+$G$1),VLOOKUP(A52,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":4457713.460438048,"d":"4,457,713.46"}},{"v":2228856.730219024,"d":"2,228,856.73"}]
[2075,119,{"$f":"IF(ISNA(VLOOKUP(A53,LTCGE!$H$3:$I$4,2,FALSE)),C52*(1+$G$1),VLOOKUP(A53,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":4591444.864251189,"d":"4,591,444.86"}},{"v":2295722.4321255945,"d":"2,295,722.43"}]
[2076,120,{"$f":"IF(ISNA(VLOOKUP(A54,LTCGE!$H$3:$I$4,2,FALSE)),C53*(1+$G$1),VLOOKUP(A54,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":4729188.2101787245,"d":"4,729,188.21"}},{"v":2364594.1050893622,"d":"2,364,594.11"}]
[2077,121,{"$f":"IF(ISNA(VLOOKUP(A55,LTCGE!$H$3:$I$4,2,FALSE)),C54*(1+$G$1),VLOOKUP(A55,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":4871063.856484086,"d":"4,871,063.86"}},{"v":2435531.928242043,"d":"2,435,531.93"}]
[2078,122,{"$f":"IF(ISNA(VLOOKUP(A56,LTCGE!$H$3:$I$4,2,FALSE)),C55*(1+$G$1),VLOOKUP(A56,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":5017195.772178609,"d":"5,017,195.77"}},{"v":2508597.8860893045,"d":"2,508,597.89"}]
[2079,123,{"$f":"IF(ISNA(VLOOKUP(A57,LTCGE!$H$3:$I$4,2,FALSE)),C56*(1+$G$1),VLOOKUP(A57,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":5167711.645343968,"d":"5,167,711.65"}},{"v":2583855.822671984,"d":"2,583,855.82"}]
[2080,124,{"$f":"IF(ISNA(VLOOKUP(A58,LTCGE!$H$3:$I$4,2,FALSE)),C57*(1+$G$1),VLOOKUP(A58,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":5322742.994704287,"d":"5,322,742.99"}},{"v":2661371.4973521433,"d":"2,661,371.50"}]
[2081,125,{"$f":"IF(ISNA(VLOOKUP(A59,LTCGE!$H$3:$I$4,2,FALSE)),C58*(1+$G$1),VLOOKUP(A59,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":5482425.284545415,"d":"5,482,425.28"}},{"v":2741212.6422727075,"d":"2,741,212.64"}]
[2082,126,{"$f":"IF(ISNA(VLOOKUP(A60,LTCGE!$H$3:$I$4,2,FALSE)),C59*(1+$G$1),VLOOKUP(A60,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":5646898.043081778,"d":"5,646,898.04"}},{"v":2823449.021540889,"d":"2,823,449.02"}]
[2083,127,{"$f":"IF(ISNA(VLOOKUP(A61,LTCGE!$H$3:$I$4,2,FALSE)),C60*(1+$G$1),VLOOKUP(A61,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":5816304.984374232,"d":"5,816,304.98"}},{"v":2908152.492187116,"d":"2,908,152.49"}]
[2084,128,{"$f":"IF(ISNA(VLOOKUP(A62,LTCGE!$H$3:$I$4,2,FALSE)),C61*(1+$G$1),VLOOKUP(A62,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":5990794.133905459,"d":"5,990,794.13"}},{"v":2995397.0669527296,"d":"2,995,397.07"}]
[2085,129,{"$f":"IF(ISNA(VLOOKUP(A63,LTCGE!$H$3:$I$4,2,FALSE)),C62*(1+$G$1),VLOOKUP(A63,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":6170517.9579226235,"d":"6,170,517.96"}},{"v":3085258.9789613117,"d":"3,085,258.98"}]
[2086,130,{"$f":"IF(ISNA(VLOOKUP(A64,LTCGE!$H$3:$I$4,2,FALSE)),C63*(1+$G$1),VLOOKUP(A64,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":6355633.496660302,"d":"6,355,633.50"}},{"v":3177816.748330151,"d":"3,177,816.75"}]
[2087,131,{"$f":"IF(ISNA(VLOOKUP(A65,LTCGE!$H$3:$I$4,2,FALSE)),C64*(1+$G$1),VLOOKUP(A65,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":6546302.5015601115,"d":"6,546,302.50"}},{"v":3273151.2507800558,"d":"3,273,151.25"}]
[2088,132,{"$f":"IF(ISNA(VLOOKUP(A66,LTCGE!$H$3:$I$4,2,FALSE)),C65*(1+$G$1),VLOOKUP(A66,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":6742691.576606915,"d":"6,742,691.58"}},{"v":3371345.7883034577,"d":"3,371,345.79"}]
[2089,133,{"$f":"IF(ISNA(VLOOKUP(A67,LTCGE!$H$3:$I$4,2,FALSE)),C66*(1+$G$1),VLOOKUP(A67,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":6944972.323905123,"d":"6,944,972.32"}},{"$f":"+C67*50%","v":{"v":3472486.1619525617,"d":"3,472,486.16"}}]
[{"$f":"+A67+1","v":2090},134,{"$f":"IF(ISNA(VLOOKUP(A68,LTCGE!$H$3:$I$4,2,FALSE)),C67*(1+$G$1),VLOOKUP(A68,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":7153321.493622277,"d":"7,153,321.49"}},{"v":3576660.7468111385,"d":"3,576,660.75"}]
[2091,135,{"$f":"IF(ISNA(VLOOKUP(A69,LTCGE!$H$3:$I$4,2,FALSE)),C68*(1+$G$1),VLOOKUP(A69,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":7367921.138430946,"d":"7,367,921.14"}},{"v":3683960.569215473,"d":"3,683,960.57"}]
[2092,136,{"$f":"IF(ISNA(VLOOKUP(A70,LTCGE!$H$3:$I$4,2,FALSE)),C69*(1+$G$1),VLOOKUP(A70,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":7588958.772583874,"d":"7,588,958.77"}},{"v":3794479.386291937,"d":"3,794,479.39"}]
[2093,137,{"$f":"IF(ISNA(VLOOKUP(A71,LTCGE!$H$3:$I$4,2,FALSE)),C70*(1+$G$1),VLOOKUP(A71,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":7816627.535761391,"d":"7,816,627.54"}},{"v":3908313.7678806954,"d":"3,908,313.77"}]
[2094,138,{"$f":"IF(ISNA(VLOOKUP(A72,LTCGE!$H$3:$I$4,2,FALSE)),C71*(1+$G$1),VLOOKUP(A72,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":8051126.361834233,"d":"8,051,126.36"}},{"v":4025563.1809171163,"d":"4,025,563.18"}]
[2095,139,{"$f":"IF(ISNA(VLOOKUP(A73,LTCGE!$H$3:$I$4,2,FALSE)),C72*(1+$G$1),VLOOKUP(A73,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":8292660.1526892595,"d":"8,292,660.15"}},{"v":4146330.0763446297,"d":"4,146,330.08"}]
[2096,140,{"$f":"IF(ISNA(VLOOKUP(A74,LTCGE!$H$3:$I$4,2,FALSE)),C73*(1+$G$1),VLOOKUP(A74,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":8541439.957269937,"d":"8,541,439.96"}},{"v":4270719.978634968,"d":"4,270,719.98"}]
[2097,141,{"$f":"IF(ISNA(VLOOKUP(A75,LTCGE!$H$3:$I$4,2,FALSE)),C74*(1+$G$1),VLOOKUP(A75,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":8797683.155988036,"d":"8,797,683.16"}},{"v":4398841.577994018,"d":"4,398,841.58"}]
[2098,142,{"$f":"IF(ISNA(VLOOKUP(A76,LTCGE!$H$3:$I$4,2,FALSE)),C75*(1+$G$1),VLOOKUP(A76,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":9061613.650667677,"d":"9,061,613.65"}},{"v":4530806.825333838,"d":"4,530,806.83"}]
[2099,143,{"$f":"IF(ISNA(VLOOKUP(A77,LTCGE!$H$3:$I$4,2,FALSE)),C76*(1+$G$1),VLOOKUP(A77,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":9333462.060187707,"d":"9,333,462.06"}},{"v":4666731.030093853,"d":"4,666,731.03"}]
[2100,144,{"$f":"IF(ISNA(VLOOKUP(A78,LTCGE!$H$3:$I$4,2,FALSE)),C77*(1+$G$1),VLOOKUP(A78,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":9613465.921993338,"d":"9,613,465.92"}},{"v":4806732.960996669,"d":"4,806,732.96"}]
[2101,145,{"$f":"IF(ISNA(VLOOKUP(A79,LTCGE!$H$3:$I$4,2,FALSE)),C78*(1+$G$1),VLOOKUP(A79,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":9901869.899653139,"d":"9,901,869.90"}},{"v":4950934.949826569,"d":"4,950,934.95"}]
[2102,146,{"$f":"IF(ISNA(VLOOKUP(A80,LTCGE!$H$3:$I$4,2,FALSE)),C79*(1+$G$1),VLOOKUP(A80,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":10198925.996642733,"d":"10,198,926.00"}},{"v":5099462.9983213665,"d":"5,099,463.00"}]
[2103,147,{"$f":"IF(ISNA(VLOOKUP(A81,LTCGE!$H$3:$I$4,2,FALSE)),C80*(1+$G$1),VLOOKUP(A81,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":10504893.776542015,"d":"10,504,893.78"}},{"v":5252446.888271008,"d":"5,252,446.89"}]
[2104,148,{"$f":"IF(ISNA(VLOOKUP(A82,LTCGE!$H$3:$I$4,2,FALSE)),C81*(1+$G$1),VLOOKUP(A82,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":10820040.589838276,"d":"10,820,040.59"}},{"v":5410020.294919138,"d":"5,410,020.29"}]
[2105,149,{"$f":"IF(ISNA(VLOOKUP(A83,LTCGE!$H$3:$I$4,2,FALSE)),C82*(1+$G$1),VLOOKUP(A83,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":11144641.807533424,"d":"11,144,641.81"}},{"v":5572320.903766712,"d":"5,572,320.90"}]
[{"$f":"+A83+1","v":2106},150,{"$f":"IF(ISNA(VLOOKUP(A84,LTCGE!$H$3:$I$4,2,FALSE)),C83*(1+$G$1),VLOOKUP(A84,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":11478981.061759427,"d":"11,478,981.06"}},{"v":5739490.530879714,"d":"5,739,490.53"}]
[2107,151,{"$f":"IF(ISNA(VLOOKUP(A85,LTCGE!$H$3:$I$4,2,FALSE)),C84*(1+$G$1),VLOOKUP(A85,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":11823350.493612211,"d":"11,823,350.49"}},{"v":5911675.246806106,"d":"5,911,675.25"}]
[2108,152,{"$f":"IF(ISNA(VLOOKUP(A86,LTCGE!$H$3:$I$4,2,FALSE)),C85*(1+$G$1),VLOOKUP(A86,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":12178051.008420577,"d":"12,178,051.01"}},{"v":6089025.504210289,"d":"6,089,025.50"}]
[2109,153,{"$f":"IF(ISNA(VLOOKUP(A87,LTCGE!$H$3:$I$4,2,FALSE)),C86*(1+$G$1),VLOOKUP(A87,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":12543392.538673194,"d":"12,543,392.54"}},{"v":6271696.269336597,"d":"6,271,696.27"}]
[2110,154,{"$f":"IF(ISNA(VLOOKUP(A88,LTCGE!$H$3:$I$4,2,FALSE)),C87*(1+$G$1),VLOOKUP(A88,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":12919694.31483339,"d":"12,919,694.31"}},{"v":6459847.157416695,"d":"6,459,847.16"}]
[2111,155,{"$f":"IF(ISNA(VLOOKUP(A89,LTCGE!$H$3:$I$4,2,FALSE)),C88*(1+$G$1),VLOOKUP(A89,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":13307285.144278392,"d":"13,307,285.14"}},{"v":6653642.572139196,"d":"6,653,642.57"}]
[2112,156,{"$f":"IF(ISNA(VLOOKUP(A90,LTCGE!$H$3:$I$4,2,FALSE)),C89*(1+$G$1),VLOOKUP(A90,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":13706503.698606744,"d":"13,706,503.70"}},{"v":6853251.849303372,"d":"6,853,251.85"}]
[2113,157,{"$f":"IF(ISNA(VLOOKUP(A91,LTCGE!$H$3:$I$4,2,FALSE)),C90*(1+$G$1),VLOOKUP(A91,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":14117698.809564946,"d":"14,117,698.81"}},{"v":7058849.404782473,"d":"7,058,849.40"}]
[2114,158,{"$f":"IF(ISNA(VLOOKUP(A92,LTCGE!$H$3:$I$4,2,FALSE)),C91*(1+$G$1),VLOOKUP(A92,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":14541229.773851896,"d":"14,541,229.77"}},{"v":7270614.886925948,"d":"7,270,614.89"}]
[2115,159,{"$f":"IF(ISNA(VLOOKUP(A93,LTCGE!$H$3:$I$4,2,FALSE)),C92*(1+$G$1),VLOOKUP(A93,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":14977466.667067453,"d":"14,977,466.67"}},{"v":7488733.333533727,"d":"7,488,733.33"}]
[2116,160,{"$f":"IF(ISNA(VLOOKUP(A94,LTCGE!$H$3:$I$4,2,FALSE)),C93*(1+$G$1),VLOOKUP(A94,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":15426790.667079477,"d":"15,426,790.67"}},{"v":7713395.333539738,"d":"7,713,395.33"}]
[2117,161,{"$f":"IF(ISNA(VLOOKUP(A95,LTCGE!$H$3:$I$4,2,FALSE)),C94*(1+$G$1),VLOOKUP(A95,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":15889594.387091862,"d":"15,889,594.39"}},{"v":7944797.193545931,"d":"7,944,797.19"}]
[2118,162,{"$f":"IF(ISNA(VLOOKUP(A96,LTCGE!$H$3:$I$4,2,FALSE)),C95*(1+$G$1),VLOOKUP(A96,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":16366282.218704619,"d":"16,366,282.22"}},{"v":8183141.109352309,"d":"8,183,141.11"}]
[2119,163,{"$f":"IF(ISNA(VLOOKUP(A97,LTCGE!$H$3:$I$4,2,FALSE)),C96*(1+$G$1),VLOOKUP(A97,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":16857270.685265757,"d":"16,857,270.69"}},{"v":8428635.342632879,"d":"8,428,635.34"}]
[2120,164,{"$f":"IF(ISNA(VLOOKUP(A98,LTCGE!$H$3:$I$4,2,FALSE)),C97*(1+$G$1),VLOOKUP(A98,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":17362988.805823732,"d":"17,362,988.81"}},{"v":8681494.402911866,"d":"8,681,494.40"}]
[2121,165,{"$f":"IF(ISNA(VLOOKUP(A99,LTCGE!$H$3:$I$4,2,FALSE)),C98*(1+$G$1),VLOOKUP(A99,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":17883878.469998445,"d":"17,883,878.47"}},{"v":8941939.234999223,"d":"8,941,939.23"}]
[{"$f":"+A99+1","v":2122},166,{"$f":"IF(ISNA(VLOOKUP(A100,LTCGE!$H$3:$I$4,2,FALSE)),C99*(1+$G$1),VLOOKUP(A100,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":18420394.8240984,"d":"18,420,394.82"}},{"v":9210197.4120492,"d":"9,210,197.41"}]
[2123,167,{"$f":"IF(ISNA(VLOOKUP(A101,LTCGE!$H$3:$I$4,2,FALSE)),C100*(1+$G$1),VLOOKUP(A101,LTCGE!$H$3:$I$4,2,FALSE))","v":{"v":18973006.668821353,"d":"18,973,006.67"}},{"v":9486503.334410677,"d":"9,486,503.33"}]

{"sheet":"List French","index":11,"n_rows":72,"n_cols":4,"rows_kept":72,"hidden":true}
["Capital gains inclusion factor",{"v":0.5,"d":"50.00%"}]
[]
["Province","Estate tax"]
[]
["AB",{"$f":"+'Estate tax rates French'!H7","v":{"v":525,"d":"525.00"}},"Alberta",{"$f":"B5","v":{"v":525,"d":"525.00"}}]
["BC",{"$f":"+'Estate tax rates French'!H12","v":{"v":33390,"d":"33,390.00"}},"British Columbia",{"$f":"B6","v":{"v":33390,"d":"33,390.00"}}]
["MB",{"$f":"+'Estate tax rates French'!H15","v":0},"Manitoba",0]
["NB",{"$f":"+'Estate tax rates French'!H22","v":{"v":12050,"d":"12,050.00"}},"New Brunswick",{"v":12050,"d":"12,050.00"}]
["NL",{"$f":"+'Estate tax rates French'!H26","v":{"v":14508.6,"d":"14,508.60"}},"Newfoundland & Labrador",{"v":14508.6,"d":"14,508.60"}]
["NT",{"$f":"+'Estate tax rates French'!H33","v":{"v":435,"d":"435.00"}},"Northwest Territories",{"v":435,"d":"435.00"}]
["NS",{"$f":"+'Estate tax rates French'!H40","v":{"v":40157.15,"d":"40,157.15"}},"Nova Scotia",{"v":40157.15,"d":"40,157.15"}]
["NU",{"$f":"+'Estate tax rates French'!H47","v":{"v":425,"d":"425.00"}},"Nunavut",{"v":425,"d":"425.00"}]
["ON ",{"$f":"+'Estate tax rates French'!H51","v":{"v":35400,"d":"35,400.00"}},"Ontario",{"v":35400,"d":"35,400.00"}]
["PE",{"$f":"+'Estate tax rates French'!H58","v":{"v":9640,"d":"9,640.00"}},"Prince Edward Island",{"v":9640,"d":"9,640.00"}]
["QC",{"$f":"+'Estate tax rates French'!H61","v":{"v":230,"d":"230.00"}},"Quebec",{"v":230,"d":"230.00"}]
["SK",{"$f":"+'Estate tax rates French'!H65","v":{"v":17070,"d":"17,070.00"}},"Saskatchewan",{"v":17070,"d":"17,070.00"}]
["YT",{"$f":"+'Estate tax rates French'!H69","v":{"v":140,"d":"140.00"}},"Yukon",{"v":140,"d":"140.00"}]
[]
["Data validation for beneficiary designation"]
["Yes","Oui"]
["No","Non"]
[]
["Investment rate of return"]
[]
[{"v":0.0025,"d":"0.25%"}]
[{"$f":"+A25+0.25%","v":{"v":0.005,"d":"0.50%"}}]
[{"$f":"+A26+0.25%","v":{"v":0.0075,"d":"0.75%"}}]
[{"v":0.01,"d":"1.00%"}]
[{"v":0.0125,"d":"1.25%"}]
[{"v":0.015000000000000001,"d":"1.50%"}]
[{"v":0.0175,"d":"1.75%"}]
[{"v":0.02,"d":"2.00%"}]
[{"v":0.0225,"d":"2.25%"}]
[{"v":0.024999999999999998,"d":"2.50%"}]
[{"v":0.027499999999999997,"d":"2.75%"}]
[{"v":0.029999999999999995,"d":"3.00%"}]
[{"v":0.032499999999999994,"d":"3.25%"}]
[{"v":0.034999999999999996,"d":"3.50%"}]
[{"v":0.0375,"d":"3.75%"}]
[{"v":0.04,"d":"4.00%"}]
[{"v":0.0425,"d":"4.25%"}]
[{"v":0.045000000000000005,"d":"4.50%"}]
[{"v":0.04750000000000001,"d":"4.75%"}]
[{"v":0.05000000000000001,"d":"5.00%"}]
[{"v":0.05250000000000001,"d":"5.25%"}]
[{"v":0.055000000000000014,"d":"5.50%"}]
[{"v":0.057500000000000016,"d":"5.75%"}]
[{"v":0.06000000000000002,"d":"6.00%"}]
[{"v":0.06250000000000001,"d":"6.25%"}]
[{"v":0.06500000000000002,"d":"6.50%"}]
[{"v":0.06750000000000002,"d":"6.75%"}]
[{"v":0.07000000000000002,"d":"7.00%"}]
[{"v":0.07250000000000002,"d":"7.25%"}]
[{"v":0.07500000000000002,"d":"7.50%"}]
[{"v":0.07750000000000003,"d":"7.75%"}]
[{"v":0.08000000000000003,"d":"8.00%"}]
[{"v":0.08250000000000003,"d":"8.25%"}]
[{"v":0.08500000000000003,"d":"8.50%"}]
[{"v":0.08750000000000004,"d":"8.75%"}]
[{"v":0.09000000000000004,"d":"9.00%"}]
[{"v":0.09250000000000004,"d":"9.25%"}]
[{"v":0.09500000000000004,"d":"9.50%"}]
[{"v":0.09750000000000004,"d":"9.75%"}]
[{"v":0.10000000000000005,"d":"10.00%"}]
[{"v":0.10250000000000005,"d":"10.25%"}]
[{"v":0.10500000000000005,"d":"10.50%"}]
[{"v":0.10750000000000005,"d":"10.75%"}]
[{"v":0.11000000000000006,"d":"11.00%"}]
[{"v":0.11250000000000006,"d":"11.25%"}]
[{"v":0.11500000000000006,"d":"11.50%"}]
[{"v":0.11750000000000006,"d":"11.75%"}]
[{"v":0.12000000000000006,"d":"12.00%"}]

{"sheet":"RRIF","index":12,"n_rows":43,"n_cols":6,"rows_kept":43,"hidden":true}
[]
["Age on January 1st","RRIF factor","Value on January 1st","Minimum withdrawal","Annual growth","Cl.bal."]
[]
[71,0.0528,{"$f":"+IF(Input!$AG$28<72,+FV(Input!$AY$42,71-Input!$AG$28,-Input!AM42,-Input!AS42,1),0)","v":{"v":578664.3200000001,"d":"578,664"}},{"$f":"+C4*B4","v":{"v":30553.476096000002,"d":"30,553"}},{"$f":"+(C4-D4)*Input!$AY$44","v":0},{"$f":"+C4-D4+E4","v":{"v":548110.843904,"d":"548,111"}}]
[{"$f":"+A4+1","v":72},{"v":0.054,"d":"0.0540"},{"$f":"+IF(Input!$AG$28=RRIF!A5,Input!$AS$44,0)+F4","v":{"v":548110.843904,"d":"548,111"}},{"$f":"+C5*B5","v":{"v":29597.985570816,"d":"29,598"}},{"$f":"+(C5-D5)*Input!$AY$44","v":0},{"$f":"+C5-D5+E5","v":{"v":518512.85833318403,"d":"518,513"}}]
[{"$f":"+A5+1","v":73},0.0553,{"$f":"+IF(Input!$AG$28=RRIF!A6,Input!$AS$44,0)+F5","v":{"v":518512.85833318403,"d":"518,513"}},{"v":28673.761065825078,"d":"28,674"},{"$f":"+(C6-D6)*Input!$AY$44","v":0},{"$f":"+C6-D6","v":{"v":489839.097267359,"d":"489,839"}}]
[74,0.0567,{"$f":"+IF(Input!$AG$28=RRIF!A7,Input!$AS$44,0)+F6","v":{"v":489839.097267359,"d":"489,839"}},{"v":27773.876815059255,"d":"27,774"},{"$f":"+(C7-D7)*Input!$AY$44","v":0},{"v":462065.2204522997,"d":"462,065"}]
[75,0.0582,{"$f":"+IF(Input!$AG$28=RRIF!A8,Input!$AS$44,0)+F7","v":{"v":462065.2204522997,"d":"462,065"}},{"v":26892.195830323843,"d":"26,892"},{"$f":"+(C8-D8)*Input!$AY$44","v":0},{"v":435173.02462197584,"d":"435,173"}]
[76,0.0598,{"$f":"+IF(Input!$AG$28=RRIF!A9,Input!$AS$44,0)+F8","v":{"v":435173.02462197584,"d":"435,173"}},{"v":26023.346872394155,"d":"26,023"},{"$f":"+(C9-D9)*Input!$AY$44","v":0},{"v":409149.6777495817,"d":"409,150"}]
[77,0.0617,{"$f":"+IF(Input!$AG$28=RRIF!A10,Input!$AS$44,0)+F9","v":{"v":409149.6777495817,"d":"409,150"}},{"v":25244.53511714919,"d":"25,245"},{"$f":"+(C10-D10)*Input!$AY$44","v":0},{"v":383905.1426324325,"d":"383,905"}]
[78,0.0636,{"$f":"+IF(Input!$AG$28=RRIF!A11,Input!$AS$44,0)+F10","v":{"v":383905.1426324325,"d":"383,905"}},{"v":24416.36707142271,"d":"24,416"},{"$f":"+(C11-D11)*Input!$AY$44","v":0},{"v":359488.7755610098,"d":"359,489"}]
[79,0.0658,{"$f":"+IF(Input!$AG$28=RRIF!A12,Input!$AS$44,0)+F11","v":{"v":359488.7755610098,"d":"359,489"}},{"v":23654.361431914447,"d":"23,654"},{"$f":"+(C12-D12)*Input!$AY$44","v":0},{"v":335834.4141290954,"d":"335,834"}]
[80,0.0682,{"$f":"+IF(Input!$AG$28=RRIF!A13,Input!$AS$44,0)+F12","v":{"v":335834.4141290954,"d":"335,834"}},{"v":22903.907043604304,"d":"22,904"},{"$f":"+(C13-D13)*Input!$AY$44","v":0},{"v":312930.5070854911,"d":"312,931"}]
[81,0.0708,{"$f":"+IF(Input!$AG$28=RRIF!A14,Input!$AS$44,0)+F13","v":{"v":312930.5070854911,"d":"312,931"}},{"v":22155.47990165277,"d":"22,155"},{"$f":"+(C14-D14)*Input!$AY$44","v":0},{"v":290775.0271838383,"d":"290,775"}]
[82,0.0738,{"$f":"+IF(Input!$AG$28=RRIF!A15,Input!$AS$44,0)+F14","v":{"v":290775.0271838383,"d":"290,775"}},{"v":21459.19700616727,"d":"21,459"},{"$f":"+(C15-D15)*Input!$AY$44","v":0},{"v":269315.83017767104,"d":"269,316"}]
[83,0.0771,{"$f":"+IF(Input!$AG$28=RRIF!A16,Input!$AS$44,0)+F15","v":{"v":269315.83017767104,"d":"269,316"}},{"v":20764.250506698438,"d":"20,764"},{"$f":"+(C16-D16)*Input!$AY$44","v":0},{"v":248551.5796709726,"d":"248,552"}]
[84,0.0808,{"$f":"+IF(Input!$AG$28=RRIF!A17,Input!$AS$44,0)+F16","v":{"v":248551.5796709726,"d":"248,552"}},{"v":20082.967637414586,"d":"20,083"},{"$f":"+(C17-D17)*Input!$AY$44","v":0},{"v":228468.61203355802,"d":"228,469"}]
[85,0.0851,{"$f":"+IF(Input!$AG$28=RRIF!A18,Input!$AS$44,0)+F17","v":{"v":228468.61203355802,"d":"228,469"}},{"v":19442.678884055786,"d":"19,443"},{"$f":"+(C18-D18)*Input!$AY$44","v":0},{"v":209025.93314950223,"d":"209,026"}]
[86,0.0899,{"$f":"+IF(Input!$AG$28=RRIF!A19,Input!$AS$44,0)+F18","v":{"v":209025.93314950223,"d":"209,026"}},{"v":18791.43139014025,"d":"18,791"},{"$f":"+(C19-D19)*Input!$AY$44","v":0},{"v":190234.501759362,"d":"190,235"}]
[87,0.0955,{"$f":"+IF(Input!$AG$28=RRIF!A20,Input!$AS$44,0)+F19","v":{"v":190234.501759362,"d":"190,235"}},{"v":18167.394918019072,"d":"18,167"},{"$f":"+(C20-D20)*Input!$AY$44","v":0},{"v":172067.10684134293,"d":"172,067"}]
[88,0.1021,{"$f":"+IF(Input!$AG$28=RRIF!A21,Input!$AS$44,0)+F20","v":{"v":172067.10684134293,"d":"172,067"}},{"v":17568.05160850111,"d":"17,568"},{"$f":"+(C21-D21)*Input!$AY$44","v":0},{"v":154499.0552328418,"d":"154,499"}]
[89,0.1099,{"$f":"+IF(Input!$AG$28=RRIF!A22,Input!$AS$44,0)+F21","v":{"v":154499.0552328418,"d":"154,499"}},{"v":16979.446170089315,"d":"16,979"},{"$f":"+(C22-D22)*Input!$AY$44","v":0},{"v":137519.6090627525,"d":"137,520"}]
[90,0.1192,{"$f":"+IF(Input!$AG$28=RRIF!A23,Input!$AS$44,0)+F22","v":{"v":137519.6090627525,"d":"137,520"}},{"v":16392.3374002801,"d":"16,392"},{"$f":"+(C23-D23)*Input!$AY$44","v":0},{"v":121127.27166247241,"d":"121,127"}]
[91,0.1306,{"$f":"+IF(Input!$AG$28=RRIF!A24,Input!$AS$44,0)+F23","v":{"v":121127.27166247241,"d":"121,127"}},{"v":15819.221679118897,"d":"15,819"},{"$f":"+(C24-D24)*Input!$AY$44","v":0},{"v":105308.04998335351,"d":"105,308"}]
[92,0.1449,{"$f":"+IF(Input!$AG$28=RRIF!A25,Input!$AS$44,0)+F24","v":{"v":105308.04998335351,"d":"105,308"}},{"v":15259.136442587924,"d":"15,259"},{"$f":"+(C25-D25)*Input!$AY$44","v":0},{"v":90048.91354076558,"d":"90,049"}]
[93,0.1634,{"$f":"+IF(Input!$AG$28=RRIF!A26,Input!$AS$44,0)+F25","v":{"v":90048.91354076558,"d":"90,049"}},{"v":14713.992472561096,"d":"14,714"},{"$f":"+(C26-D26)*Input!$AY$44","v":0},{"v":75334.9210682045,"d":"75,335"}]
[94,0.1879,{"$f":"+IF(Input!$AG$28=RRIF!A27,Input!$AS$44,0)+F26","v":{"v":75334.9210682045,"d":"75,335"}},{"v":14155.431668715626,"d":"14,155"},{"$f":"+(C27-D27)*Input!$AY$44","v":0},{"v":61179.48939948887,"d":"61,179"}]
[95,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Input!$AG$28=RRIF!A28,Input!$AS$44,0)+F27","v":{"v":61179.48939948887,"d":"61,179"}},{"v":12235.897879897775,"d":"12,236"},{"$f":"+(C28-D28)*Input!$AY$44","v":0},{"v":48943.59151959109,"d":"48,944"}]
[96,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Input!$AG$28=RRIF!A29,Input!$AS$44,0)+F28","v":{"v":48943.59151959109,"d":"48,944"}},{"v":9788.718303918218,"d":"9,789"},{"$f":"+(C29-D29)*Input!$AY$44","v":0},{"v":39154.87321567287,"d":"39,155"}]
[97,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Input!$AG$28=RRIF!A30,Input!$AS$44,0)+F29","v":{"v":39154.87321567287,"d":"39,155"}},{"v":7830.974643134575,"d":"7,831"},{"$f":"+(C30-D30)*Input!$AY$44","v":0},{"v":31323.8985725383,"d":"31,324"}]
[98,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Input!$AG$28=RRIF!A31,Input!$AS$44,0)+F30","v":{"v":31323.8985725383,"d":"31,324"}},{"v":6264.77971450766,"d":"6,265"},{"$f":"+(C31-D31)*Input!$AY$44","v":0},{"v":25059.11885803064,"d":"25,059"}]
[99,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Input!$AG$28=RRIF!A32,Input!$AS$44,0)+F31","v":{"v":25059.11885803064,"d":"25,059"}},{"v":5011.8237716061285,"d":"5,012"},{"$f":"+(C32-D32)*Input!$AY$44","v":0},{"v":20047.295086424514,"d":"20,047"}]
[100,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Input!$AG$28=RRIF!A33,Input!$AS$44,0)+F32","v":{"v":20047.295086424514,"d":"20,047"}},{"v":4009.459017284903,"d":"4,009"},{"$f":"+(C33-D33)*Input!$AY$44","v":0},{"v":16037.836069139612,"d":"16,038"}]
[{"$f":"+A33+1","v":101},{"v":0.2,"d":"0.2000"},{"$f":"+IF(Input!$AG$28=RRIF!A34,Input!$AS$44,0)+F33","v":{"v":16037.836069139612,"d":"16,038"}},{"$f":"+C34*B34","v":{"v":3207.5672138279224,"d":"3,208"}},{"$f":"+(C34-D34)*Input!$AY$44","v":0},{"$f":"+C34-D34","v":{"v":12830.26885531169,"d":"12,830"}}]
[102,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Input!$AG$28=RRIF!A35,Input!$AS$44,0)+F34","v":{"v":12830.26885531169,"d":"12,830"}},{"v":2566.053771062338,"d":"2,566"},{"$f":"+(C35-D35)*Input!$AY$44","v":0},{"v":10264.215084249352,"d":"10,264"}]
[103,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Input!$AG$28=RRIF!A36,Input!$AS$44,0)+F35","v":{"v":10264.215084249352,"d":"10,264"}},{"v":2052.8430168498703,"d":"2,053"},{"$f":"+(C36-D36)*Input!$AY$44","v":0},{"v":8211.372067399481,"d":"8,211"}]
[104,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Input!$AG$28=RRIF!A37,Input!$AS$44,0)+F36","v":{"v":8211.372067399481,"d":"8,211"}},{"v":1642.2744134798963,"d":"1,642"},{"$f":"+(C37-D37)*Input!$AY$44","v":0},{"v":6569.097653919585,"d":"6,569"}]
[{"$f":"+A37+1","v":105},{"v":0.2,"d":"0.2000"},{"$f":"+IF(Input!$AG$28=RRIF!A38,Input!$AS$44,0)+F37","v":{"v":6569.097653919585,"d":"6,569"}},{"$f":"+C38*B38","v":{"v":1313.8195307839171,"d":"1,314"}},{"$f":"+(C38-D38)*Input!$AY$44","v":0},{"$f":"+C38-D38","v":{"v":5255.2781231356685,"d":"5,255"}}]
[106,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Input!$AG$28=RRIF!A39,Input!$AS$44,0)+F38","v":{"v":5255.2781231356685,"d":"5,255"}},{"v":1051.0556246271337,"d":"1,051"},{"$f":"+(C39-D39)*Input!$AY$44","v":0},{"v":4204.222498508535,"d":"4,204"}]
[107,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Input!$AG$28=RRIF!A40,Input!$AS$44,0)+F39","v":{"v":4204.222498508535,"d":"4,204"}},{"v":840.844499701707,"d":"841"},{"$f":"+(C40-D40)*Input!$AY$44","v":0},{"v":3363.377998806828,"d":"3,363"}]
[108,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Input!$AG$28=RRIF!A41,Input!$AS$44,0)+F40","v":{"v":3363.377998806828,"d":"3,363"}},{"v":672.6755997613657,"d":"673"},{"$f":"+(C41-D41)*Input!$AY$44","v":0},{"v":2690.7023990454627,"d":"2,691"}]
[109,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Input!$AG$28=RRIF!A42,Input!$AS$44,0)+F41","v":{"v":2690.7023990454627,"d":"2,691"}},{"v":538.1404798090925,"d":"538"},{"$f":"+(C42-D42)*Input!$AY$44","v":0},{"v":2152.56191923637,"d":"2,153"}]
[110,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Input!$AG$28=RRIF!A43,Input!$AS$44,0)+F42","v":{"v":2152.56191923637,"d":"2,153"}},{"v":430.51238384727407,"d":"431"},{"$f":"+(C43-D43)*Input!$AY$44","v":0},{"v":1722.049535389096,"d":"1,722"}]

{"sheet":"RRIF French","index":13,"n_rows":43,"n_cols":6,"rows_kept":43,"hidden":true}
[]
["Age on January 1st","RRIF factor","Value on January 1st","Minimum withdrawal","Annual growth","Cl.bal."]
[]
[71,0.0528,{"$f":"+IF(Entrée!$AG$28<72,+FV(Entrée!$BB$42,71-Entrée!$AG$28,-Entrée!AP42,-Entrée!AV42,1),0)","v":{"v":578664.3200000001,"d":"578,664"}},{"$f":"+C4*B4","v":{"v":30553.476096000002,"d":"30,553"}},{"$f":"+(C4-D4)*Entrée!$BB$44","v":0},{"$f":"+C4-D4+E4","v":{"v":548110.843904,"d":"548,111"}}]
[{"$f":"+A4+1","v":72},{"v":0.054,"d":"0.0540"},{"$f":"+IF(Entrée!$AG$28='RRIF French'!A5,Entrée!$AV$44,0)+F4","v":{"v":548110.843904,"d":"548,111"}},{"$f":"+C5*B5","v":{"v":29597.985570816,"d":"29,598"}},{"$f":"+(C5-D5)*Entrée!$BB$44","v":0},{"$f":"+C5-D5+E5","v":{"v":518512.85833318403,"d":"518,513"}}]
[{"$f":"+A5+1","v":73},0.0553,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A6,Entrée!$AV$44,0)+F5","v":{"v":518512.85833318403,"d":"518,513"}},{"v":28673.761065825078,"d":"28,674"},{"$f":"+(C6-D6)*Entrée!$BB$44","v":0},{"$f":"+C6-D6","v":{"v":489839.097267359,"d":"489,839"}}]
[74,0.0567,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A7,Entrée!$AV$44,0)+F6","v":{"v":489839.097267359,"d":"489,839"}},{"v":27773.876815059255,"d":"27,774"},{"$f":"+(C7-D7)*Entrée!$BB$44","v":0},{"v":462065.2204522997,"d":"462,065"}]
[75,0.0582,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A8,Entrée!$AV$44,0)+F7","v":{"v":462065.2204522997,"d":"462,065"}},{"v":26892.195830323843,"d":"26,892"},{"$f":"+(C8-D8)*Entrée!$BB$44","v":0},{"v":435173.02462197584,"d":"435,173"}]
[76,0.0598,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A9,Entrée!$AV$44,0)+F8","v":{"v":435173.02462197584,"d":"435,173"}},{"v":26023.346872394155,"d":"26,023"},{"$f":"+(C9-D9)*Entrée!$BB$44","v":0},{"v":409149.6777495817,"d":"409,150"}]
[77,0.0617,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A10,Entrée!$AV$44,0)+F9","v":{"v":409149.6777495817,"d":"409,150"}},{"v":25244.53511714919,"d":"25,245"},{"$f":"+(C10-D10)*Entrée!$BB$44","v":0},{"v":383905.1426324325,"d":"383,905"}]
[78,0.0636,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A11,Entrée!$AV$44,0)+F10","v":{"v":383905.1426324325,"d":"383,905"}},{"v":24416.36707142271,"d":"24,416"},{"$f":"+(C11-D11)*Entrée!$BB$44","v":0},{"v":359488.7755610098,"d":"359,489"}]
[79,0.0658,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A12,Entrée!$AV$44,0)+F11","v":{"v":359488.7755610098,"d":"359,489"}},{"v":23654.361431914447,"d":"23,654"},{"$f":"+(C12-D12)*Entrée!$BB$44","v":0},{"v":335834.4141290954,"d":"335,834"}]
[80,0.0682,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A13,Entrée!$AV$44,0)+F12","v":{"v":335834.4141290954,"d":"335,834"}},{"v":22903.907043604304,"d":"22,904"},{"$f":"+(C13-D13)*Entrée!$BB$44","v":0},{"v":312930.5070854911,"d":"312,931"}]
[81,0.0708,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A14,Entrée!$AV$44,0)+F13","v":{"v":312930.5070854911,"d":"312,931"}},{"v":22155.47990165277,"d":"22,155"},{"$f":"+(C14-D14)*Entrée!$BB$44","v":0},{"v":290775.0271838383,"d":"290,775"}]
[82,0.0738,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A15,Entrée!$AV$44,0)+F14","v":{"v":290775.0271838383,"d":"290,775"}},{"v":21459.19700616727,"d":"21,459"},{"$f":"+(C15-D15)*Entrée!$BB$44","v":0},{"v":269315.83017767104,"d":"269,316"}]
[83,0.0771,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A16,Entrée!$AV$44,0)+F15","v":{"v":269315.83017767104,"d":"269,316"}},{"v":20764.250506698438,"d":"20,764"},{"$f":"+(C16-D16)*Entrée!$BB$44","v":0},{"v":248551.5796709726,"d":"248,552"}]
[84,0.0808,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A17,Entrée!$AV$44,0)+F16","v":{"v":248551.5796709726,"d":"248,552"}},{"v":20082.967637414586,"d":"20,083"},{"$f":"+(C17-D17)*Entrée!$BB$44","v":0},{"v":228468.61203355802,"d":"228,469"}]
[85,0.0851,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A18,Entrée!$AV$44,0)+F17","v":{"v":228468.61203355802,"d":"228,469"}},{"v":19442.678884055786,"d":"19,443"},{"$f":"+(C18-D18)*Entrée!$BB$44","v":0},{"v":209025.93314950223,"d":"209,026"}]
[86,0.0899,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A19,Entrée!$AV$44,0)+F18","v":{"v":209025.93314950223,"d":"209,026"}},{"v":18791.43139014025,"d":"18,791"},{"$f":"+(C19-D19)*Entrée!$BB$44","v":0},{"v":190234.501759362,"d":"190,235"}]
[87,0.0955,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A20,Entrée!$AV$44,0)+F19","v":{"v":190234.501759362,"d":"190,235"}},{"v":18167.394918019072,"d":"18,167"},{"$f":"+(C20-D20)*Entrée!$BB$44","v":0},{"v":172067.10684134293,"d":"172,067"}]
[88,0.1021,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A21,Entrée!$AV$44,0)+F20","v":{"v":172067.10684134293,"d":"172,067"}},{"v":17568.05160850111,"d":"17,568"},{"$f":"+(C21-D21)*Entrée!$BB$44","v":0},{"v":154499.0552328418,"d":"154,499"}]
[89,0.1099,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A22,Entrée!$AV$44,0)+F21","v":{"v":154499.0552328418,"d":"154,499"}},{"v":16979.446170089315,"d":"16,979"},{"$f":"+(C22-D22)*Entrée!$BB$44","v":0},{"v":137519.6090627525,"d":"137,520"}]
[90,0.1192,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A23,Entrée!$AV$44,0)+F22","v":{"v":137519.6090627525,"d":"137,520"}},{"v":16392.3374002801,"d":"16,392"},{"$f":"+(C23-D23)*Entrée!$BB$44","v":0},{"v":121127.27166247241,"d":"121,127"}]
[91,0.1306,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A24,Entrée!$AV$44,0)+F23","v":{"v":121127.27166247241,"d":"121,127"}},{"v":15819.221679118897,"d":"15,819"},{"$f":"+(C24-D24)*Entrée!$BB$44","v":0},{"v":105308.04998335351,"d":"105,308"}]
[92,0.1449,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A25,Entrée!$AV$44,0)+F24","v":{"v":105308.04998335351,"d":"105,308"}},{"v":15259.136442587924,"d":"15,259"},{"$f":"+(C25-D25)*Entrée!$BB$44","v":0},{"v":90048.91354076558,"d":"90,049"}]
[93,0.1634,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A26,Entrée!$AV$44,0)+F25","v":{"v":90048.91354076558,"d":"90,049"}},{"v":14713.992472561096,"d":"14,714"},{"$f":"+(C26-D26)*Entrée!$BB$44","v":0},{"v":75334.9210682045,"d":"75,335"}]
[94,0.1879,{"$f":"+IF(Entrée!$AG$28='RRIF French'!A27,Entrée!$AV$44,0)+F26","v":{"v":75334.9210682045,"d":"75,335"}},{"v":14155.431668715626,"d":"14,155"},{"$f":"+(C27-D27)*Entrée!$BB$44","v":0},{"v":61179.48939948887,"d":"61,179"}]
[95,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Entrée!$AG$28='RRIF French'!A28,Entrée!$AV$44,0)+F27","v":{"v":61179.48939948887,"d":"61,179"}},{"v":12235.897879897775,"d":"12,236"},{"$f":"+(C28-D28)*Entrée!$BB$44","v":0},{"v":48943.59151959109,"d":"48,944"}]
[96,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Entrée!$AG$28='RRIF French'!A29,Entrée!$AV$44,0)+F28","v":{"v":48943.59151959109,"d":"48,944"}},{"v":9788.718303918218,"d":"9,789"},{"$f":"+(C29-D29)*Entrée!$BB$44","v":0},{"v":39154.87321567287,"d":"39,155"}]
[97,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Entrée!$AG$28='RRIF French'!A30,Entrée!$AV$44,0)+F29","v":{"v":39154.87321567287,"d":"39,155"}},{"v":7830.974643134575,"d":"7,831"},{"$f":"+(C30-D30)*Entrée!$BB$44","v":0},{"v":31323.8985725383,"d":"31,324"}]
[98,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Entrée!$AG$28='RRIF French'!A31,Entrée!$AV$44,0)+F30","v":{"v":31323.8985725383,"d":"31,324"}},{"v":6264.77971450766,"d":"6,265"},{"$f":"+(C31-D31)*Entrée!$BB$44","v":0},{"v":25059.11885803064,"d":"25,059"}]
[99,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Entrée!$AG$28='RRIF French'!A32,Entrée!$AV$44,0)+F31","v":{"v":25059.11885803064,"d":"25,059"}},{"v":5011.8237716061285,"d":"5,012"},{"$f":"+(C32-D32)*Entrée!$BB$44","v":0},{"v":20047.295086424514,"d":"20,047"}]
[100,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Entrée!$AG$28='RRIF French'!A33,Entrée!$AV$44,0)+F32","v":{"v":20047.295086424514,"d":"20,047"}},{"v":4009.459017284903,"d":"4,009"},{"$f":"+(C33-D33)*Entrée!$BB$44","v":0},{"v":16037.836069139612,"d":"16,038"}]
[101,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Entrée!$AG$28='RRIF French'!A34,Entrée!$AV$44,0)+F33","v":{"v":16037.836069139612,"d":"16,038"}},{"v":3207.5672138279224,"d":"3,208"},{"$f":"+(C34-D34)*Entrée!$BB$44","v":0},{"v":12830.26885531169,"d":"12,830"}]
[102,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Entrée!$AG$28='RRIF French'!A35,Entrée!$AV$44,0)+F34","v":{"v":12830.26885531169,"d":"12,830"}},{"v":2566.053771062338,"d":"2,566"},{"$f":"+(C35-D35)*Entrée!$BB$44","v":0},{"v":10264.215084249352,"d":"10,264"}]
[103,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Entrée!$AG$28='RRIF French'!A36,Entrée!$AV$44,0)+F35","v":{"v":10264.215084249352,"d":"10,264"}},{"v":2052.8430168498703,"d":"2,053"},{"$f":"+(C36-D36)*Entrée!$BB$44","v":0},{"v":8211.372067399481,"d":"8,211"}]
[104,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Entrée!$AG$28='RRIF French'!A37,Entrée!$AV$44,0)+F36","v":{"v":8211.372067399481,"d":"8,211"}},{"v":1642.2744134798963,"d":"1,642"},{"$f":"+(C37-D37)*Entrée!$BB$44","v":0},{"v":6569.097653919585,"d":"6,569"}]
[105,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Entrée!$AG$28='RRIF French'!A38,Entrée!$AV$44,0)+F37","v":{"v":6569.097653919585,"d":"6,569"}},{"v":1313.8195307839171,"d":"1,314"},{"$f":"+(C38-D38)*Entrée!$BB$44","v":0},{"v":5255.2781231356685,"d":"5,255"}]
[106,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Entrée!$AG$28='RRIF French'!A39,Entrée!$AV$44,0)+F38","v":{"v":5255.2781231356685,"d":"5,255"}},{"v":1051.0556246271337,"d":"1,051"},{"$f":"+(C39-D39)*Entrée!$BB$44","v":0},{"v":4204.222498508535,"d":"4,204"}]
[107,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Entrée!$AG$28='RRIF French'!A40,Entrée!$AV$44,0)+F39","v":{"v":4204.222498508535,"d":"4,204"}},{"v":840.844499701707,"d":"841"},{"$f":"+(C40-D40)*Entrée!$BB$44","v":0},{"v":3363.377998806828,"d":"3,363"}]
[108,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Entrée!$AG$28='RRIF French'!A41,Entrée!$AV$44,0)+F40","v":{"v":3363.377998806828,"d":"3,363"}},{"v":672.6755997613657,"d":"673"},{"$f":"+(C41-D41)*Entrée!$BB$44","v":0},{"v":2690.7023990454627,"d":"2,691"}]
[109,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Entrée!$AG$28='RRIF French'!A42,Entrée!$AV$44,0)+F41","v":{"v":2690.7023990454627,"d":"2,691"}},{"v":538.1404798090925,"d":"538"},{"$f":"+(C42-D42)*Entrée!$BB$44","v":0},{"v":2152.56191923637,"d":"2,153"}]
[110,{"v":0.2,"d":"0.2000"},{"$f":"+IF(Entrée!$AG$28='RRIF French'!A43,Entrée!$AV$44,0)+F42","v":{"v":2152.56191923637,"d":"2,153"}},{"v":430.51238384727407,"d":"431"},{"$f":"+(C43-D43)*Entrée!$BB$44","v":0},{"v":1722.049535389096,"d":"1,722"}]

{"sheet":"Estate tax rates","index":14,"n_rows":69,"n_cols":10,"rows_kept":69,"hidden":true,"merged":[[0,1,0,2],[0,4,0,5]]}
[null,"Range",null,null,"Rate",null,null,"Probate fees",null,{"$f":"(Input!$BP$79-Input!$BP$101)","v":{"v":2409025.933149502,"d":"2,409,026 "}}]
["AB",0,{"v":10000,"d":"10,000.00"},null,{"v":35,"d":"35.00"},null,null,{"$f":"+IF(AND($J$1>B2,$J$1<B3),E2,0)","v":0},null,"https://www.alberta.ca/court-fees.aspx"]
[null,{"$f":"+C2+0.01","v":{"v":10000.01,"d":"10,000.01"}},{"v":25000,"d":"25,000.00"},null,{"v":135,"d":"135.00"},null,null,{"$f":"+IF(AND($J$1>C2,$J$1<B4),E3,0)","v":0}]
[null,{"$f":"+C3+0.01","v":{"v":25000.01,"d":"25,000.01"}},{"v":125000,"d":"125,000.00"},null,{"v":275,"d":"275.00"},null,null,{"$f":"+IF(AND($J$1>C3,$J$1<B5),E4,0)","v":0}]
[null,{"$f":"+C4+0.01","v":{"v":125000.01,"d":"125,000.01"}},{"v":250000,"d":"250,000.00"},null,{"v":400,"d":"400.00"},null,null,{"$f":"+IF(AND(J1>C4,J1<B6),E5,0)","v":0}]
[null,{"$f":"+C5+0.01","v":{"v":250000.01,"d":"250,000.01"}},null,null,{"v":525,"d":"525.00"},null,null,{"$f":"+IF(J1>C5,E6,0)","v":{"v":525,"d":"525.00"}}]
[{"$nulls":7},{"$f":"SUM(H2:H6)","v":{"v":525,"d":"525.00"}}]
[]
["BC",0,{"v":25000,"d":"25,000.00"},null,0,null,null,{"$f":"+IF(AND(J1>B9,J1<B10),E9,0)","v":0},null,"https://www.bclaws.gov.bc.ca/civix/document/id/complete/statreg/00_99004_01#section2"]
[null,{"$f":"+C9+0.01","v":{"v":25000.01,"d":"25,000.01"}},{"v":50000,"d":"50,000.00"},null,{"v":6,"d":"6.00"},"per 1000 or part thereof + $200 filing fees",null,{"$f":"+IF(J1<'Estate tax rates'!B10,0,IF(AND(J1>C9,J1<B11),+(CEILING((J1-C9),1000)/1000*E10)+200,(C10-C9)/1000*E10))","v":{"v":150,"d":"150.00"}}]
[null,{"$f":"+C10+0.01","v":{"v":50000.01,"d":"50,000.01"}},null,null,{"v":14,"d":"14.00"},"per 1000 or part thereof + $200 filing fees",null,{"$f":"+IF(J1>C10,+(CEILING((J1-C10),1000)/1000*E11)+200,0)","v":{"v":33240,"d":"33,240.00"}}]
[{"$nulls":7},{"$f":"SUM(H9:H11)","v":{"v":33390,"d":"33,390.00"}}]
[]
["MB",{"$nulls":3},0,null,null,{"$f":"+E14","v":0},null,"https://www.manitobacourts.mb.ca/site/assets/files/1152/2020-11-06_notice_-_elimination_of_probate_charges.pdf"]
[{"$nulls":7},{"$f":"SUM(H14)","v":0}]
[]
["NB",0,{"v":5000,"d":"5,000.00"},null,{"v":25,"d":"25.00"},null,null,{"$f":"+IF(AND(J1>B17,J1<B18),E17,0)","v":0},null,"http://www.legal-info-legale.nb.ca/en/probate_of_the_will"]
[null,{"$f":"+C17+0.01","v":{"v":5000.01,"d":"5,000.01"}},{"v":10000,"d":"10,000.00"},null,{"v":50,"d":"50.00"},null,null,{"$f":"+IF(AND(J1>C17,J1<B19),E18,0)","v":0},null,"https://laws.gnb.ca/en/showfulldoc/cs/P-17.1/#anchorga:s_75"]
[null,{"$f":"+C18+0.01","v":{"v":10000.01,"d":"10,000.01"}},{"v":15000,"d":"15,000.00"},null,{"v":75,"d":"75.00"},null,null,{"$f":"+IF(AND(J1>C18,J1<B20),E19,0)","v":0}]
[null,{"$f":"+C19+0.01","v":{"v":15000.01,"d":"15,000.01"}},{"v":20000,"d":"20,000.00"},null,{"v":100,"d":"100.00"},null,null,{"$f":"+IF(AND(J1>C19,J1<B21),E20,0)","v":0}]
[null,{"$f":"+C20+0.01","v":{"v":20000.01,"d":"20,000.01"}},null,null,{"v":5,"d":"5.00"},"per 1000 or part thereof",null,{"$f":"+IF(J1>C20,+(CEILING(J1,1000)/1000*E21),0)","v":{"v":12050,"d":"12,050.00"}}]
[{"$nulls":7},{"$f":"SUM(H17:H21)","v":{"v":12050,"d":"12,050.00"}}]
[]
["NL",0,{"v":1000,"d":"1,000.00"},null,{"v":60,"d":"60.00"},null,null,{"$f":"+IF(AND(J1>B24,J1<B25),E24,0)","v":0},null,"https://www.assembly.nl.ca/legislation/sr/statutes/s13-2.htm#4_"]
[null,{"$f":"+C24+0.01","v":{"v":1000.01,"d":"1,000.01"}},null,null,{"v":0.6,"d":"0.60"},"per 100 or part thereof",null,{"$f":"+IF(J1>C24,+(CEILING((J1-C24),100)/100*E25)+60,0)","v":{"v":14508.6,"d":"14,508.60"}}]
[{"$nulls":7},{"$f":"SUM(H24:H25)","v":{"v":14508.6,"d":"14,508.60"}}]
[]
["NT",0,{"v":10000,"d":"10,000.00"},null,{"v":30,"d":"30.00"},null,null,{"$f":"+IF(AND(J1>B28,J1<B29),E28,0)","v":0},null,"https://www.justice.gov.nt.ca/en/files/legislation/financial-administration/financial-administration.r5.pdf"]
[null,{"$f":"+C28+0.01","v":{"v":10000.01,"d":"10,000.01"}},{"v":25000,"d":"25,000.00"},null,{"v":110,"d":"110.00"},null,null,{"$f":"+IF(AND(J1>C28,J1<B30),E29,0)","v":0}]
[null,{"v":25000.01,"d":"25,000.01"},{"v":125000,"d":"125,000.00"},null,{"v":215,"d":"215.00"},null,null,{"$f":"+IF(AND(J1>C29,J1<B31),E30,0)","v":0}]
[null,{"v":125000.01,"d":"125,000.01"},{"v":250000,"d":"250,000.00"},null,{"v":325,"d":"325.00"},null,null,{"$f":"+IF(AND(J1>C30,J1<B32),E31,0)","v":0}]
[null,{"v":250000.01,"d":"250,000.01"},null,null,{"v":435,"d":"435.00"},null,null,{"$f":"+IF(J1>C31,E32,0)","v":{"v":435,"d":"435.00"}}]
[{"$nulls":7},{"$f":"SUM(H28:H32)","v":{"v":435,"d":"435.00"}}]
[]
["NS",0,{"v":10000,"d":"10,000.00"},null,{"v":85.6,"d":"85.60"},null,null,{"$f":"+IF(AND(J1>B35,J1<B36),E35,0)","v":0},null,"https://www.courts.ns.ca/Probate_Court/documents/ProbateFeesTable.08.23.16.pdf"]
[null,{"$f":"+C35+0.01","v":{"v":10000.01,"d":"10,000.01"}},{"v":25000,"d":"25,000.00"},null,{"v":215.2,"d":"215.20"},null,null,{"$f":"+IF(AND(J1>C35,J1<B37),E36,0)","v":0}]
[null,{"v":25000.01,"d":"25,000.01"},{"v":50000,"d":"50,000.00"},null,358.15,null,null,{"$f":"+IF(AND(J1>C36,J1<B38),E37,0)","v":0}]
[null,{"v":50000.01,"d":"50,000.01"},{"v":100000,"d":"100,000.00"},null,{"v":1002.65,"d":"1,002.65"},null,null,{"$f":"+IF(AND(J1>C37,J1<B39),E38,0)","v":0}]
[null,{"v":100000.01,"d":"100,000.01"},null,null,16.95,"per 1000 or part thereof + $1002.65",null,{"$f":"+IF(J1>C38,+(CEILING((J1-C38),1000)/1000*E39)+1002.65,0)","v":{"v":40157.15,"d":"40,157.15"}}]
[{"$nulls":7},{"$f":"SUM(H35:H39)","v":{"v":40157.15,"d":"40,157.15"}}]
["Changed for 2024"]
["NU",0,{"v":10000,"d":"10,000.00"},null,{"v":30,"d":"30.00"},null,null,{"$f":"+IF(AND(J1>B42,J1<B43),E42,0)","v":0}]
[null,{"$f":"+C42+0.01","v":{"v":10000.01,"d":"10,000.01"}},{"v":25000,"d":"25,000.00"},null,{"v":110,"d":"110.00"},null,null,{"$f":"+IF(AND(J1>C42,J1<B44),E43,0)","v":0}]
[null,{"v":25000.01,"d":"25,000.01"},{"v":125000,"d":"125,000.00"},null,{"v":215,"d":"215.00"},null,null,{"$f":"+IF(AND(J1>C43,J1<B45),E44,0)","v":0}]
[null,{"v":125000.01,"d":"125,000.01"},{"v":250000,"d":"250,000.00"},null,{"v":325,"d":"325.00"},null,null,{"$f":"+IF(AND(J1>C44,J1<B46),E45,0)","v":0}]
[null,{"v":250000.01,"d":"250,000.01"},null,null,{"v":425,"d":"425.00"},null,null,{"$f":"+IF(J1>C45,E46,0)","v":{"v":425,"d":"425.00"}}]
[{"$nulls":7},{"$f":"SUM(H42:H46)","v":{"v":425,"d":"425.00"}}]
[]
["ON",0,{"v":50000,"d":"50,000.00"},null,0,null,null,{"$f":"+IF(AND(J1>B49,J1<B50),E49,0)","v":0},null,"https://www.ontario.ca/page/estate-administration-tax#section-3"]
[null,{"$f":"+C49+0.01","v":{"v":50000.01,"d":"50,000.01"}},null,null,{"v":15,"d":"15.00"},"per 1000 or part thereof",null,{"$f":"+IF(J1>C49,+(CEILING((J1-C49),1000)/1000*E50),0)","v":{"v":35400,"d":"35,400.00"}},null,"https://www.attorneygeneral.jus.gov.on.ca/english/estates/calculate.php"]
[{"$nulls":7},{"$f":"SUM(H49:H50)","v":{"v":35400,"d":"35,400.00"}}]
[]
["PE",0,{"v":10000,"d":"10,000.00"},null,{"v":50,"d":"50.00"},null,null,{"$f":"+IF(AND(J1>B53,J1<B54),E53,0)","v":0},null,"https://www.princeedwardisland.ca/sites/default/files/legislation/P-21-Probate%20Act.pdf"]
[null,{"$f":"+C53+0.01","v":{"v":10000.01,"d":"10,000.01"}},{"v":25000,"d":"25,000.00"},null,{"v":100,"d":"100.00"},null,null,{"$f":"+IF(AND(J1>C53,J1<B55),E54,0)","v":0},null,"See page 35 & 36"]
[null,{"v":25000.01,"d":"25,000.01"},{"v":50000,"d":"50,000.00"},null,{"v":200,"d":"200.00"},null,null,{"$f":"+IF(AND(J1>C54,J1<B56),E55,0)","v":0}]
[null,{"v":50000.01,"d":"50,000.01"},{"v":100000,"d":"100,000.00"},null,{"v":400,"d":"400.00"},null,null,{"$f":"+IF(AND(J1>C55,J1<B57),E56,0)","v":0}]
[null,{"v":100000.01,"d":"100,000.01"},null,null,{"v":4,"d":"4.00"},"per 1000 or part thereof + $400",null,{"$f":"+IF(J1>C56,+(CEILING((J1-C56),1000)/1000*E57)+400,0)","v":{"v":9640,"d":"9,640.00"}}]
[{"$nulls":7},{"$f":"SUM(H53:H57)","v":{"v":9640,"d":"9,640.00"}}]
["Changed for 2024"]
["QC",{"$nulls":3},{"v":230,"d":"230.00"},null,null,{"$f":"+IF(J1>0,E60,0)","v":{"v":230,"d":"230.00"}}]
[{"$nulls":7},{"$f":"+H60","v":{"v":230,"d":"230.00"}}]
[]
[]
["SK",{"$nulls":3},{"v":7,"d":"7.00"},"per 1000 or part thereof + $200 court fees",null,{"$f":"+IF(0<J1>C63,+(CEILING(J1,1000)/1000*E64)+200,0)","v":{"v":17070,"d":"17,070.00"}},null,"https://sasklawcourts.ca/kings-bench/wills-and-estates/probating-an-estate/"]
[{"$nulls":7},{"$f":"SUM(H64)","v":{"v":17070,"d":"17,070.00"}}]
[]
["YT",0,{"v":25000,"d":"25,000.00"},null,0,null,null,{"$f":"+IF(J1<B68,E67,0)","v":0},null,"https://yukon.ca/sites/yukon.ca/files/jus-pgt-book-3-what-is-probate.pdf"]
[null,{"$f":"+C67+0.01","v":{"v":25000.01,"d":"25,000.01"}},null,null,{"v":140,"d":"140.00"},null,null,{"$f":"+IF(J1>C67,E68,0)","v":{"v":140,"d":"140.00"}}]
[{"$nulls":7},{"$f":"SUM(H67:H68)","v":{"v":140,"d":"140.00"}}]

{"sheet":"Estate tax rates French","index":15,"n_rows":69,"n_cols":10,"rows_kept":69,"hidden":true,"merged":[[0,1,0,2],[0,4,0,5]]}
[null,"Range",null,null,"Rate",null,null,"Probate fees",null,{"$f":"(Entrée!$BT$79-Entrée!$BT$101)","v":{"v":2409025.933149502,"d":"2,409,026 "}}]
["AB",0,{"v":10000,"d":"10,000.00"},null,{"v":35,"d":"35.00"},null,null,{"$f":"+IF(AND($J$1>B2,$J$1<B3),E2,0)","v":0},null,"https://www.alberta.ca/court-fees.aspx"]
[null,{"$f":"+C2+0.01","v":{"v":10000.01,"d":"10,000.01"}},{"v":25000,"d":"25,000.00"},null,{"v":135,"d":"135.00"},null,null,{"$f":"+IF(AND($J$1>C2,$J$1<B4),E3,0)","v":0}]
[null,{"$f":"+C3+0.01","v":{"v":25000.01,"d":"25,000.01"}},{"v":125000,"d":"125,000.00"},null,{"v":275,"d":"275.00"},null,null,{"$f":"+IF(AND($J$1>C3,$J$1<B5),E4,0)","v":0}]
[null,{"$f":"+C4+0.01","v":{"v":125000.01,"d":"125,000.01"}},{"v":250000,"d":"250,000.00"},null,{"v":400,"d":"400.00"},null,null,{"$f":"+IF(AND(J1>C4,J1<B6),E5,0)","v":0}]
[null,{"$f":"+C5+0.01","v":{"v":250000.01,"d":"250,000.01"}},null,null,{"v":525,"d":"525.00"},null,null,{"$f":"+IF(J1>C5,E6,0)","v":{"v":525,"d":"525.00"}}]
[{"$nulls":7},{"$f":"SUM(H2:H6)","v":{"v":525,"d":"525.00"}}]
[]
["BC",0,{"v":25000,"d":"25,000.00"},null,0,null,null,{"$f":"+IF(AND(J1>B9,J1<B10),E9,0)","v":0},null,"https://www.bclaws.gov.bc.ca/civix/document/id/complete/statreg/00_99004_01#section2"]
[null,{"$f":"+C9+0.01","v":{"v":25000.01,"d":"25,000.01"}},{"v":50000,"d":"50,000.00"},null,{"v":6,"d":"6.00"},"per 1000 or part thereof + $200 filing fees",null,{"$f":"+IF(J1<'Estate tax rates French'!B10,0,IF(AND(J1>C9,J1<B11),+(CEILING((J1-C9),1000)/1000*E10)+200,(C10-C9)/1000*E10))","v":{"v":150,"d":"150.00"}}]
[null,{"$f":"+C10+0.01","v":{"v":50000.01,"d":"50,000.01"}},null,null,{"v":14,"d":"14.00"},"per 1000 or part thereof + $200 filing fees",null,{"$f":"+IF(J1>C10,+(CEILING((J1-C10),1000)/1000*E11)+200,0)","v":{"v":33240,"d":"33,240.00"}}]
[{"$nulls":7},{"$f":"SUM(H9:H11)","v":{"v":33390,"d":"33,390.00"}}]
[]
["MB",{"$nulls":3},0,null,null,{"$f":"+E14","v":0},null,"https://www.manitobacourts.mb.ca/site/assets/files/1152/2020-11-06_notice_-_elimination_of_probate_charges.pdf"]
[{"$nulls":7},{"$f":"SUM(H14)","v":0}]
[]
["NB",0,{"v":5000,"d":"5,000.00"},null,{"v":25,"d":"25.00"},null,null,{"$f":"+IF(AND(J1>B17,J1<B18),E17,0)","v":0},null,"http://www.legal-info-legale.nb.ca/en/probate_of_the_will"]
[null,{"$f":"+C17+0.01","v":{"v":5000.01,"d":"5,000.01"}},{"v":10000,"d":"10,000.00"},null,{"v":50,"d":"50.00"},null,null,{"$f":"+IF(AND(J1>C17,J1<B19),E18,0)","v":0},null,"https://laws.gnb.ca/en/showfulldoc/cs/P-17.1/#anchorga:s_75"]
[null,{"$f":"+C18+0.01","v":{"v":10000.01,"d":"10,000.01"}},{"v":15000,"d":"15,000.00"},null,{"v":75,"d":"75.00"},null,null,{"$f":"+IF(AND(J1>C18,J1<B20),E19,0)","v":0}]
[null,{"$f":"+C19+0.01","v":{"v":15000.01,"d":"15,000.01"}},{"v":20000,"d":"20,000.00"},null,{"v":100,"d":"100.00"},null,null,{"$f":"+IF(AND(J1>C19,J1<B21),E20,0)","v":0}]
[null,{"$f":"+C20+0.01","v":{"v":20000.01,"d":"20,000.01"}},null,null,{"v":5,"d":"5.00"},"per 1000 or part thereof",null,{"$f":"+IF(J1>C20,+(CEILING(J1,1000)/1000*E21),0)","v":{"v":12050,"d":"12,050.00"}}]
[{"$nulls":7},{"$f":"SUM(H17:H21)","v":{"v":12050,"d":"12,050.00"}}]
[]
["NL",0,{"v":1000,"d":"1,000.00"},null,{"v":60,"d":"60.00"},null,null,{"$f":"+IF(AND(J1>B24,J1<B25),E24,0)","v":0},null,"https://www.assembly.nl.ca/legislation/sr/statutes/s13-2.htm#4_"]
[null,{"$f":"+C24+0.01","v":{"v":1000.01,"d":"1,000.01"}},null,null,{"v":0.6,"d":"0.60"},"per 100 or part thereof",null,{"$f":"+IF(J1>C24,+(CEILING((J1-C24),100)/100*E25)+60,0)","v":{"v":14508.6,"d":"14,508.60"}}]
[{"$nulls":7},{"$f":"SUM(H24:H25)","v":{"v":14508.6,"d":"14,508.60"}}]
[]
["NT",0,{"v":10000,"d":"10,000.00"},null,{"v":30,"d":"30.00"},null,null,{"$f":"+IF(AND(J1>B28,J1<B29),E28,0)","v":0},null,"https://www.justice.gov.nt.ca/en/files/legislation/financial-administration/financial-administration.r5.pdf"]
[null,{"$f":"+C28+0.01","v":{"v":10000.01,"d":"10,000.01"}},{"v":25000,"d":"25,000.00"},null,{"v":110,"d":"110.00"},null,null,{"$f":"+IF(AND(J1>C28,J1<B30),E29,0)","v":0}]
[null,{"v":25000.01,"d":"25,000.01"},{"v":125000,"d":"125,000.00"},null,{"v":215,"d":"215.00"},null,null,{"$f":"+IF(AND(J1>C29,J1<B31),E30,0)","v":0}]
[null,{"v":125000.01,"d":"125,000.01"},{"v":250000,"d":"250,000.00"},null,{"v":325,"d":"325.00"},null,null,{"$f":"+IF(AND(J1>C30,J1<B32),E31,0)","v":0}]
[null,{"v":250000.01,"d":"250,000.01"},null,null,{"v":435,"d":"435.00"},null,null,{"$f":"+IF(J1>C31,E32,0)","v":{"v":435,"d":"435.00"}}]
[{"$nulls":7},{"$f":"SUM(H28:H32)","v":{"v":435,"d":"435.00"}}]
[]
["NS",0,{"v":10000,"d":"10,000.00"},null,{"v":85.6,"d":"85.60"},null,null,{"$f":"+IF(AND(J1>B35,J1<B36),E35,0)","v":0},null,"https://www.courts.ns.ca/Probate_Court/documents/ProbateFeesTable.08.23.16.pdf"]
[null,{"$f":"+C35+0.01","v":{"v":10000.01,"d":"10,000.01"}},{"v":25000,"d":"25,000.00"},null,{"v":215.2,"d":"215.20"},null,null,{"$f":"+IF(AND(J1>C35,J1<B37),E36,0)","v":0}]
[null,{"v":25000.01,"d":"25,000.01"},{"v":50000,"d":"50,000.00"},null,358.15,null,null,{"$f":"+IF(AND(J1>C36,J1<B38),E37,0)","v":0}]
[null,{"v":50000.01,"d":"50,000.01"},{"v":100000,"d":"100,000.00"},null,{"v":1002.65,"d":"1,002.65"},null,null,{"$f":"+IF(AND(J1>C37,J1<B39),E38,0)","v":0}]
[null,{"v":100000.01,"d":"100,000.01"},null,null,16.95,"per 1000 or part thereof + $1002.65",null,{"$f":"+IF(J1>C38,+(CEILING((J1-C38),1000)/1000*E39)+1002.65,0)","v":{"v":40157.15,"d":"40,157.15"}}]
[{"$nulls":7},{"$f":"SUM(H35:H39)","v":{"v":40157.15,"d":"40,157.15"}}]
["Changed for 2024"]
["NU",0,{"v":10000,"d":"10,000.00"},null,{"v":30,"d":"30.00"},null,null,{"$f":"+IF(AND(J1>B42,J1<B43),E42,0)","v":0}]
[null,{"v":10000.01,"d":"10,000.01"},{"v":25000,"d":"25,000.00"},null,{"v":110,"d":"110.00"},null,null,{"$f":"+IF(AND(J1>C42,J1<B44),E43,0)","v":0}]
[null,{"v":25000.01,"d":"25,000.01"},{"v":125000,"d":"125,000.00"},null,{"v":215,"d":"215.00"},null,null,{"$f":"+IF(AND(J1>C43,J1<B45),E44,0)","v":0}]
[null,{"v":125000.01,"d":"125,000.01"},{"v":250000,"d":"250,000.00"},null,{"v":325,"d":"325.00"},null,null,{"$f":"+IF(AND(J1>C44,J1<B46),E45,0)","v":0}]
[null,{"v":250000.01,"d":"250,000.01"},null,null,{"v":425,"d":"425.00"},null,null,{"$f":"+IF(J1>C45,E46,0)","v":{"v":425,"d":"425.00"}}]
[{"$nulls":7},{"$f":"SUM(H42:H46)","v":{"v":425,"d":"425.00"}}]
[]
["ON",0,{"v":50000,"d":"50,000.00"},null,0,null,null,{"$f":"+IF(AND(J1>B49,J1<B50),E49,0)","v":0},null,"https://www.ontario.ca/page/estate-administration-tax#section-3"]
[null,{"$f":"+C49+0.01","v":{"v":50000.01,"d":"50,000.01"}},null,null,{"v":15,"d":"15.00"},"per 1000 or part thereof",null,{"$f":"+IF(J1>C49,+(CEILING((J1-C49),1000)/1000*E50),0)","v":{"v":35400,"d":"35,400.00"}},null,"https://www.attorneygeneral.jus.gov.on.ca/english/estates/calculate.php"]
[{"$nulls":7},{"$f":"SUM(H49:H50)","v":{"v":35400,"d":"35,400.00"}}]
[]
["PE",0,{"v":10000,"d":"10,000.00"},null,{"v":50,"d":"50.00"},null,null,{"$f":"+IF(AND(J1>B53,J1<B54),E53,0)","v":0},null,"https://www.princeedwardisland.ca/sites/default/files/legislation/P-21-Probate%20Act.pdf"]
[null,{"$f":"+C53+0.01","v":{"v":10000.01,"d":"10,000.01"}},{"v":25000,"d":"25,000.00"},null,{"v":100,"d":"100.00"},null,null,{"$f":"+IF(AND(J1>C53,J1<B55),E54,0)","v":0},null,"See page 35 & 36"]
[null,{"v":25000.01,"d":"25,000.01"},{"v":50000,"d":"50,000.00"},null,{"v":200,"d":"200.00"},null,null,{"$f":"+IF(AND(J1>C54,J1<B56),E55,0)","v":0}]
[null,{"v":50000.01,"d":"50,000.01"},{"v":100000,"d":"100,000.00"},null,{"v":400,"d":"400.00"},null,null,{"$f":"+IF(AND(J1>C55,J1<B57),E56,0)","v":0}]
[null,{"v":100000.01,"d":"100,000.01"},null,null,{"v":4,"d":"4.00"},"per 1000 or part thereof + $400",null,{"$f":"+IF(J1>C56,+(CEILING((J1-C56),1000)/1000*E57)+400,0)","v":{"v":9640,"d":"9,640.00"}}]
[{"$nulls":7},{"$f":"SUM(H53:H57)","v":{"v":9640,"d":"9,640.00"}}]
["Changed for 2024"]
["QC",{"$nulls":3},{"v":230,"d":"230.00"},null,null,{"$f":"+IF(J1>0,E60,0)","v":{"v":230,"d":"230.00"}}]
[{"$nulls":7},{"$f":"+H60","v":{"v":230,"d":"230.00"}}]
[]
[]
["SK",{"$nulls":3},{"v":7,"d":"7.00"},"per 1000 or part thereof + $200 court fees",null,{"$f":"+IF(0<J1>C63,+(CEILING(J1,1000)/1000*E64)+200,0)","v":{"v":17070,"d":"17,070.00"}},null,"https://sasklawcourts.ca/kings-bench/wills-and-estates/probating-an-estate/"]
[{"$nulls":7},{"$f":"SUM(H64)","v":{"v":17070,"d":"17,070.00"}}]
[]
["YT",0,{"v":25000,"d":"25,000.00"},null,0,null,null,{"$f":"+IF(J1<B68,E67,0)","v":0},null,"https://yukon.ca/sites/yukon.ca/files/jus-pgt-book-3-what-is-probate.pdf"]
[null,{"$f":"+C67+0.01","v":{"v":25000.01,"d":"25,000.01"}},null,null,{"v":140,"d":"140.00"},null,null,{"$f":"+IF(J1>C67,E68,0)","v":{"v":140,"d":"140.00"}}]
[{"$nulls":7},{"$f":"SUM(H67:H68)","v":{"v":140,"d":"140.00"}}]