Friday, November 25, 2016

How to enter defined benefit pension amounts


I have entered defined benefit company plans for me and my spouse. My report is showing much higher pension amounts.

It seems accurate for current 2016, but much too high starting next year 2017: ($105,620 for 2016, and $178,211 for 2017 combined).

Here is my input:

For me:

  • Bridge Pension Payable Until Age 65: $74,655
  • Lifetime Pension Payable at Age 65: $61,895

For my spouse:

  • Bridge Pension Payable Until Age 65: $31,200
  • Lifetime Pension Payable at Age 65: $23,520

Can you help, do you see where I may be entering inaccurately?


The lifetime pensions are correct.

For you, the bridge should be $12,760 (74,655 - 61,895). If it's in payment, enter it as a "Former Employer Plan", otherwise there will be accruals between now and retirement. The way you have it should be OK, as you are already 60.

The same comments apply to your spouse, please enter the annual bridge only (31,200 - 23,520).

Note that you can see detailed cash flow tables for each spouses and both combined at the bottom of the 'Accumulations' and 'Income Forecast' tabs.

Tuesday, November 22, 2016

Using RetireWare for fee-only practice


I'm in the process of trying to scale my fee-only/advice-only planning practice. With enough clients that I'm reaching significant overload, I'm looking into Canadian planning software that I can use for my clients - but not necessarily with my clients.


If you use the professional version, you create and control the files and your clients do not have any access.

The collaborative version has more CRM functionality, such as exportable client lists, but not to the extent of exchanging information with billing and other CRM systems. For the collaborative, you can turn off the social media and referral components.

Friday, November 18, 2016

Update Wizard


One question on the “Update” feature.  I haven’t used it yet but just trying to figure out what happens when you use it.  So say you update all the financial information and any changes that might need to be done with assumptions, etc.,  does the program then use those numbers and the date (for example if I updated the financial info for Feb 28th, next week)  and project the year end results for this year based on 10 months of returns / expenses?

If you use the update feature I assume it changes the “date of financial information” to the current month.  If you just go in and make changes to the data then it will be using the previous date for calculations unless you manually change the “date of financial information”.

Basically the update feature seems to be an automated feature that adjusts the date for calculations and allows you to update the financial information.  If you need to do more than that then you can go into the other sections to do that.

So it will use 10 months of data for projection for year 1 when I use March as my start date for instance?


What you said is correct. The Update Wizard groups all main and changing inputs in one location (mostly asset values), and updates the date of calculation automatically.

If you use the Detailed or Quick retirement calculations, you must change the date manually.

If you go through the Update Wizard, you can always go to the main program at any time and change the date back if you wish. It is not cast in stone. However, it's best to align the date with the date of the most current account balances.

The projection for year one is for 10 months, and all other years are twelve months, except the last. The last year, i.e. grimly called "year of death", is from January 1 to the birthday month.

Tuesday, November 15, 2016

Purchasing an annuity with RRSP


How do I purchase an annuity in 2020 with my my RRSP?


There is a section in 'Registered Investments' on the 'Financial Information' page where you can select to purchase an annuity with the proceeds of your RRSP.

Thursday, November 10, 2016

Asset allocation and sources of income


Looking at the Report I have a few questions:

Under Asset Allocation it states “The Investor Profile Questionnaire established that the following portfolio: Security might be the most …”  Do I assume that the RetireWare used a “Security” mix for my investments listed under Finances or will it use the “Selection of Rates in Economic Outlook?”  I deliberately left all RRSPs in the “Finances – Registered Investments – Market Value” as “Cash” so the projected growth would utilize a low return (2.25% as noted on the Assumptions and Disclosures).

Under the “Sources of Retirement Income” it has “yes” next to Personal Residence even though I indicated for both my wife and me “Never” under “Financial Information – Principal Residence – Sell Principal Residence.”  Are the income projections using the value of our personal residence or not?


The calculations use the asset allocation basis selected on the 'Asset Mix for Projections' tab on the 'Options' page. You can select an asset allocation based on one of the profiles, the current asset mix, or your own custom allocation.

Since you selected 'Never', there will be no sale taking place. If you had selected a year for the sale but left the personal residence unselected in 'Sources of Retirement Income', then the funds would not be used for retirement.

Tuesday, November 8, 2016

Cash Flow Forecast


In the Cash Flow Forecast Detailed Data Table, there is a column of data called "Retirement Objective Net". From what I can see it includes the Post retirement expenses that I setup along with special expenses according to the parameters on the "retirement income target" tab.

However I can't seem to reconcile the data in that column against the budget, it is always higher. Can you tell me what data is included in the (net) retirement income objective column?


The expenses you entered are in "today's dollars". So if it's payable in. say, 10 years, the annual expenses are increased by the rate of inflation applicable during that period. This is to ensure that your assets can pay for the expenses when they are incurred in the future. Look in the Help file, under Forecast Menu | Retirement Income Target |  Adjustments to Retirement Income. There is more information and an example about the impact of inflation.

Thursday, November 3, 2016

MonteCarlo calculations


I have a dilemma. Hopefully you can help. My investment adviser recently provided me with a retirement plan using another product.

Income, future assets etc. were comparable to what I calculate using RetireWare.

However, for the same scenario, RetireWare is indicating a 100% probability of success. The competing software shows a 14% failure. The adviser recommends up to 10% failure as acceptable.

I assume that both programs should yield generally comparable Monte Carlo results?


Please note that there is a setting in the Options page that counts small shortfalls as a success, so by setting the threshold to $0, the probability may go down.

Also note that Naviplan probably uses a different approach for their simulations. For example, they may use only one expected return and volatility, or maybe only fixed income and equities for asset classes. In any case, with such calculations resting heavily on assumptions and methodologies, one may view a 14% failure as equivalent to a 10% failure. Also, since this is the product of an advisor, there is an incentive to err on the conservative side since your success is at stake, so he may be extra careful to recommend higher spending.

One way to assess your plan is to look at the various results produced by the software. You have the odds of success, a deterministic projection based on your selected expected returns (or RetireWare's standard, which is fairly conservative). You also have a projection assuming you earn poor investment returns in the future. Then there is the risk analysis that "stress tests" the plan against the main risks under various economic conditions.

Our idea in making decisions when facing an uncertain future is to take a "holistic" approach. If you see that most indicators are favourable, then you probably are OK.

One last thought. If you find you experience lower than expected returns or higher expenses after a year or two, you are able to correct the course by monitoring your plan and adapting your spending going forward to set you back on solid footing to meet your expenses throughout retirement.

Tuesday, November 1, 2016

A few product questions


I have a few questions about some inputs that I cannot resolve on my own. I am a new subscriber but I think I have everything figured out now except the below.

Is there a way to model a spousal loan? for example, if I have lent my spouse $1 Million at 1% until death there is a $10,000 deductible interest expense for one and interest income for the other.

I don't quite understand the "dividend yield" and "increase in earnings" fields in the economic forecast. If I input all the nominal equity asset class returns as 7% for example, what happens when I manipulate the other two variables? it seems to effect the Monte Carlo simulation significantly so I want to be more certain as to their meaning.

For the Monte Carlo simulation, how conservative are the input volatility? I am trying to get more comfortable on the simulation and how I manipulate the variables to get an 85% chance of success or a 35% chance (or everything in between).


To model the loan, you could add an 'Other Income; of $10,000 per year for you, and a $10,000 interest expense on her budget.

The "dividend yield" adds a constant dividend on the share of assets invested in equities (based on the profile selected in 'Asset Mix for Projections' on the 'Options' page. So if you select 2% and have $100,000 in equities, it will add $2,000 in the following year of dividend income taxed assuming they are eligible dividends. In future years, it will be based on the market value of equities, so as they grow, so does the dividends.

The "increase in earnings" field in the economic forecast is an assumption for annual wage increase. So if you are not retired and earn $100,000 per year with a 3% annual increase in earnings, the program will calculate earnings of $103,000 next year and increase it by 3% each year up to retirement. This is the only purpose of this assumption. In turn, your annual earnings are used to estimate the CPP.

The increase in earnings and dividend rate are not subject to volatility in the simulation. In other words they are assumed to be constant.

The default volatility for each asset class are based on historical experience adjusted to recent trends. In a nutshell, cash and fixed income are assumed to be less volatile than historically, and equities are in line with their historical volatility (based on the last 20 years), with International equities experiencing the most volatility. These are revisited annually.

Thursday, October 27, 2016

Functionality of RetireWare


I am interested in a subscription but before doing so wanted to know the extent of your program - is there a 30 day trial version.

I tried another product but the program was not detailed enough. Does your software allow you to enter your lifestyle needs item by item. e.g., housing expenses, living expenses including food, entertainment, travel , transportation expenses etc.

Then does it allow you to enter RRSP and TFSA balances and unregistered investment accounts separately for myself and my spouse and then set different returns for different investment products i.e. cash (1%), bonds (2%), Canadian equities (5%), foreign equities (7%).

Does to allow you to set annual contributions to the RRSP an TFSA and then set dates when withdrawals may or may not take place. What about personal residence and recreational property?


Here are answers to your questions:

1. You can base your income goal on a detailed post-retirement budget that includes nearly 50 different items.

2. balances are separate by type of account and include RRSP, TFSA, non-registered and locked-in, also separated for each spouse.

3. You can customize expected investment returns for the following asset classes: cash, fixed income, Canadian equity, US equity and international equity. The program suggests defaults as well. The expected return will depend on the asset mix selected for the calculations.

4. You formulate an annual savings goal and select one of several savings rules, such as maximizing the RRSP, then contributing to the TFSA. RRSP and TFSA limits are applied and carried forward.

5.  Withdrawals are driven by the retirement income goals. After taking into account annual income from public and private pensions, shortfalls are funded from non-registered assets, TFSAs, locked-in assets and the RRIF.

6. You can also include the disposition of the personal residence, other property, business or other future assets in your plan.

As opposed to a free trial, we offer a 30-day money back guarantee. If you're not satisfied with the product, we will refund your credit card in full - no questions asked. Simply email us and request a refund and we will oblige within 24 hours.

Monday, October 24, 2016

Retirement income goal and rates of returns


As I am new to this program, I just have a couple of questions before I start rolling it out to  my clients.

When it asks for Annual retirement objective (total dollar amount), will this include all sources such as CPP , OAS , and then net of tax if indicated below? Or, is this just going to draw from one’s own savings?

Standard forecast rates of returns: what rates are used? How does that work ? The other two choices (Historical and Custom ) seem straight forward.


The retirement income objective is how much you want to have each year during retirement. The income forecast tries to meet the goal with CPP, OAS, other income or company pensions, and make up any gap from invested assets. Note that the retirement objective is in terms of "today's dollars". So if you enter say $50,000, and retirement takes place in 10 years, and inflation is 2%, the actual retirement objective in the year of retirement will be 50,000 x 1.02 ^ 10 or $60,949.

The standard are the default values shown in the Custom Forecast.

  • Cash and equivalents: 2.25%
  • Fixed income: 6%
  • Canadian equity: 7%
  • US equity: 8%
  • International equity: 8%

The above are exclusive of investment management fees.

The standard also has values for inflation, real estate and wage increase, also shown in the default values..

Note that these do change each year based on historical averages adjusted for current trends.

Friday, October 21, 2016

Saving in a holding company


You can include the value of a business from which you can pay dividends. You will find this on the 'Other Assets' tab on the Financial Information page. I'm not sure if this addresses what you want to do with a holding company.

I do have a question on how to optimize the plan. I know we have lots of extra cash flow but it doesn't appear to be putting any money into the TFSA or RRSP or Non-Registered where is the excess cash flow going? Can you please advise how I tell the system to "auto direct budget surpluses to savings"?


Please note that before retirement, extra cash is assumed to be spent.

After retirement surpluses are saved to the non-registered account and available to cover shortfalls in future years.

If you have excesses before retirement, manually increase your annual savings amount and it will be directed in the RRSP, TFSA and non-registered according to the savings rule you selected on the Forecast page.

Wednesday, October 19, 2016

Pre-retirement Planning


I do not plan to retire for another 10 years. So does the software allow me to input my current income details (indexed for inflation) and asset (residence, RRSPs, investment portfolio) and liability balances as well as current expense budget (indexed for inflation) to see how I am trending to reach my retirement goals


Yes you enter your income before retirement and it will increase each year in line with a wage increase assumption. You can also enter all assets and liabilities (in particular mortgage balances on properties and remaining term).

For the budget, you can complete a pre-retirement budget and a post-retirement budget separately. Your post-retirement budget will be used for setting your retirement income goals (and is indexed as well to retirement and each year thereafter).

Monday, October 17, 2016

Survivor pension benefits


I have a 57 year old receiving roughly $10,000 of QPP survivor benefits and roughly $1,200 annually of private pension survivor benefits. Keep in mind the client will begin receiving regular reduced QPP retirement benefits sometime after age 60.

How do I enter these amounts?


I've looked briefly at the plan and have a few comments.

  1. You can put the $10,000 of QPP survivor benefits in non-registered or TFSA (I assume it's a one-time lump sum and has been paid). If it's coming in the future put it as an 'Other Asset' in the Financial Information page.
  2. You have $1,680 annual pension of $1,680 at 65, with an actuarial reduction to age 50. You may want instead put this as a 'Pension or Annuity Income from Registered Pension Plan' on the Financial Information page. 
  3. You have QPP starting at 65 not 60. Enter the age you want the QPP to start.
  4. In 'Asset Mix for Projections' on the Options page, you have the asset allocation percentages for non-registered adding up to 110%. It should add up to 100%.

Thursday, October 13, 2016

Asset mix profiles


What are the asset mixes used in the historical returns application for conservative, moderate, balanced, growth and aggressive. I an an investment advisor and results are difficult to explain without some specific parameters. I've also found that the more I get into the program, the more questions I have. Is there any documentation dealing with assumptions etc rather than just data input. For example, I have been trying to determine how to input how to max out a TFSA in later years from the sale of a principle residence. Any help is appreciated,


You will find the asset mixes on the Investor Profile tab on the Review page of the RetireWare application. There is also information in the help files.

The software automatically deposits part of the proceeds into a TFSA if there is contributions room, and any excess goes to the non-registered account.

There are a few tutorials you can view on our YouTube page:

Tuesday, October 11, 2016

Defined Benefit Accruals


I tried to input my husband's pension, which starts collecting on Jan 1, 2022. I am entering the lifetime amount and the bridge benefit from his pension statement, which are $32,484 and $10,218, respectively. However, when I put this into the input page, the output I get is far more than these numbers.


If it is a defined benefit pension from a current employer, the program estimates future accruals between now and 2022, so the bridge and pension include years of service all the way to 2002. If you want the amounts unchanged, enter them as a defined benefit pension from a former employer.

Thursday, October 6, 2016



I have a client who would like to input their RESP assets and also build into their plan the expense they will incur to put their two children through university so that the financial impact of this is built into their retirement plan.


First, on the File Manager page, go to the Applications tab and select 'Education Planning'. This will help determine the annual amounts that need to be saved toward education.

Then, go in the RetireWare file of your user, and on the Finances menu, select 'Budget Information'. You can Enter the planned annual savings and existing balance in Non-retirement Savings and Assets under RESP.

The savings will show in the income forecast and in the (pre-retirement) budget on the Review page. It may be a good idea to complete the information in 'Pre-retirement Expenses' to get a complete budget.

Tuesday, October 4, 2016

Asset Mix Changing Over Time


I would like to have more detail about the change in Asset mix when I select 'Move gradually to conservative portfolio until 80'.


The amount held in fixed income will increase gradually each year until it reaches the amount of the conservative profile. Thereafter it will be assumed that the funds are invested in accordance to the conservative profile. You will find the asset allocation of the conservative and all other profiles in the help files.

Thursday, September 29, 2016

Increase in Retirement Expenses


My client is considering selling her home in a few years (let's say 6 years from now when age 75) and we're projecting till age 90. How do we reflect a increase in her cash needs for the remaining 15 years of her life (75 to 90).

I can see where to sell the home, but where can I input a monthly increase in expenses of $500 per month starting in 6 years from now?


On the Forecast page, you can enter on the 'Retirement Income Target' tab under 'Special Expenses' a periodic expense starting say in 2021, with frequency 1 (meaning once per year) of $6,000.

Alternatively, on the same tab under 'Advanced' you can increase the budget in percentage terms . If you use this approach, determine the percentage that $6,000 per year is to the retirement income goal.

Tuesday, September 27, 2016

Viewing Detailed Cash Flows


On the future assets table in the report, the registered assets at age 94 (year 2054) for the surviving client are $240,979.

At that age the client is required to withdraw a minimum 20% which would be $48,200. The investment return is a net 5% or about $12,000 maximum yet the client’s registered assets at the start of the next year are $217,683, which is about $13,000 more than the math would indicate it should be.

The cash-flow forecast for age 94 (2054) shows only $31,711 being withdrawn from the registered assets of $240,979 which is 13% and not 20% as required by CRA. Is there an explanation for this?

Is there something else in ‘registered’ other than a RRIF or a LIF that might distort the figures, like a TFSA?


For each spouse on the 'Accumulations' tab on the 'View' page there is at the bottom under 'Your Future Assets - Detailed Data Table' links to pop-up tables that provide the detailed cash flow. You will see that the withdrawals are 20% at age 94.

For investment income, it will be based on the rates of returns selected in the 'Economic Forecast' page (less investment fees), weighted in accordance with the basis selected in 'Asset Mix for Projections' on the 'Options' page.

The summary tables on the results page combine TFSA, LIFs and RRIFs.

The Accumulations and Income Forecast tabs have detailed pop up cash flow tables that show all cash flows.

Friday, September 23, 2016

RRIF Withdrawals


How do I delay RRIF withdrawals to age 71 in the program?


On the Options page, select "Start Withdrawals of Registered Investments" and the program will defer the RRIF withdrawals as long as possible.

Please note that if funds are not sufficient to meet the retirement income goal, then the RRIF will be opened before age 71 in order to meet the income goal. So if non-registered (or TFSAs) are not sufficient, reducing the goal will facilitate the deferment of the RRSP to the latest age.

As well, ensure you select 'Use Investment Earnings and Capital' for 'Use of Non-Registered Assets After Retirement' on the same page.

Wednesday, September 21, 2016

Future Income Tax


I ran the model and the level of income taxes seem low for the amount of income each year in the future.

With a  gross incomes of around $80,000, it shows about $10,000 in taxes for example.


Income taxes may seem low but remember these are "future dollars", and the income mix may be from capital withdrawals from a non-registered account, investment income which is taxed a lower rates if it's from realized capital gains and dividends.

Monday, September 19, 2016

Expected Investment Income


How are investment income calculated for the projection?


Registered funds are projected in the future based on the rates selected in the Economic Forecast on the Forecast page, and the asset allocation selected on the Options page.

If you base your projection on the current asset mix, then you should enter the asset allocation of registered assets by clicking the blue icon next to the 'Registered' balance on the second tab of the
Financial Information page. In setting your rate for fixed income consider that part of the assets will earn 8% on the mortgages and part will earn a lower rate for mutual fund investments, bonds, etc.

Also recognize that the expected rates may apply for 30 to 50 years in the future, so it is best to use a conservative approach and consider that rates that may be guaranteed for
the next few years may not apply for the entire life expectancy.

Thursday, September 15, 2016

RRIF Withdrawals Based on Younger Spouse's Age


Is it possible to use my spouse's DOB for my RRIF payments? Also, can I  control how much income comes from a RRIF, subject to the minimum?

Finally, how can I see the annual RRIF income coming out of my plan?


You can use the spouse's age by selecting this information on the Option page  under 'Registered'

There are detailed pop up tables for the asset and income cash flow on the results page. The links to the pop ups are under the last header of the Accumulations and Income Forecast tabs.

You can control how much income comes from the RRIF by selecting the option under 'Registered' on the 'Options' page. You can select an annual amount or minimum payments, and select the age of commencement of payments from the RRIF. Please note that the actual payment may differ if more funds are required to meet the retirement income goal in any particular year.

You also have the option of starting registered withdrawals as late as possible, or at retirement.

Tuesday, September 13, 2016

Tax Brackets and Marginal Tax


How do you determine the tax bracket/marginal tax many years in the future?


The program assumes brackets, credits and other amounts will grow each year by the rate of inflation.

Most provinces automatically index these amounts each year. We assume brackets are indexed for provinces who don't automatically index because they eventually update them, and it would not be realistic to have a model using fixed brackets in 20 or 30 years.

Note that for RRSP limits and YMPE increase in line with the average wage.

Thursday, September 8, 2016

Spending Projections in Retirement


When doing long term income projections, is it possible to drop spending by say 25% at age 75 and then continue adjusting that revised spending by inflation rather than having spending continue along the same rate?


Yes, go to the 'Forecast' page and on the 'Retirement Income Target' tab, and click 'Advanced'.

You can increase or decrease retirement income at three points during retirement and income continues to be adjusted with inflation throughout.

You can also add one-time or recurring special expenses in your retirement income goals (such as car purchase every few years, trips, weddings, etc.).

Tuesday, September 6, 2016

RRSP Savings and Pension Adjustment


Why are allowable RRSP contributions so low if the earnings are high enough to contribute the maximum amount?


Low RRSP contributions for persons earning substantial money. may occur if there is an ongoing defined benefit pension plan. Note that you entered a defined benefit pension for your client, and the system estimates a pension adjustment, which reduces the RRSP contribution room.

If your client is not currently accruing a defined benefit pension, then you should enter this amount as a "defined benefit pension from a former employer" and this will cause no future pension accruals and no pension adjustments.

Thursday, September 1, 2016

Income Coverage


Can you explain the concept of "income coverage" in the risk analysis results?


For the income coverage, it is defined as lifetime sources of income over total average income. It is a useful measure for lower wealth individuals that require the peace of mind of knowing funds will be available to cover their expenses no matter how long they live. A few other users mention that the usually low percentage requires extra explanations to clients and we will be adding wording to indicate that it's not a bad thing if funds are sufficient.

Tuesday, August 30, 2016

Collaborative Version


I recently purchased your software and understand I could share it with my clients ( I bought the professional collaborative version with up to 200 files).

How can I do this and how does the client login?


When you create a new file on the first tab of the File Manager (the landing page after logging in), you can enter your client's email address and send an automated invitation.

The invitation has a link where the user can choose a password to access their account. Once this is completed, the user can login and access a simplified version and work on or review their retirement plan.

I suggest you use a personal email to try and see the experience from the user's perspective. This will help in understanding how it works.

If you need further information, there are a few You Tube videos at the following link:

The videos can also be a helpful reference to your clients trying to get familiar with the user interface.

Thursday, August 25, 2016

Rental Properties


We have several rental properties.  I have entered this amount in Other Assets - Investment in Other Properties.  Is there a way to enter these properties separately, so that properties could be sold individually when needed?


No, there is allowance for only one property other than your personal residence.

Please note that you can enter up to four assets on the 'Other Assets' tab on the 'Financial Information' page, with disposition in four separate years.

So if you can group your sales around five separate years, this may work. However, note that you should include the after-tax proceeds in 'Other Assets' and their value will only be reflected in the year of disposition. It may be best to create an alternative file for this and use it just to see the impact of selling the properties in a staggered way.

Tuesday, August 23, 2016

Eliminating a Retirement Shortfall


I ran a plan which advised me that assets were not sufficient and that clients needed $19,500 more in savings each year until retirement.

I input $20,000 more into savings and revised plan came back with:

  • Current annual savings: $20,000
  • Total required savings: $32,500
  • Additional required savings: $12,500

 Can you explain this please and how to get rid of shortfall.


On the Forecast page on the Savings tab, you have set maximum savings at 50% of earnings.

That's why the program comes up with $32,500 total annual savings.

Nevertheless, your client, who is 1.5 years away from retirement, and with his spouse already retired, need to fund nearly a $1 million gap.

So no reasonable contributions can help, other disposing of existing assets, for example selling the personal residence at a later point in time.

Note that you have based the projections on their current asset mix on all cash investments for the registered funds and locked-in assets.

Investing in a more diversified mix will generate higher returns for the projections, but they will still significantly fall short.

Maybe you can look at adjusting the income goals and retirement dates, in addition to using a better asset mix or finding other funds for retirement.

Thursday, August 18, 2016

If You Are Retired


What use is RetireWare for those people already retired?


As a retired person, you use RetireWare to set and monitor your spending levels such that it will last a lifetime. Also, if you have poor or excellent investment returns can impact future expenses, and when unforeseen expenses or life changes occur, you revisit your plan and adjust your goals.

Tuesday, August 16, 2016

Printing a Report


Where do we generate a PDF report of the results of the analysis?


Click the 'Review' button on the toolbar, and go to the 'Report' tab. You will see an icon that you can click to generate a PDF report.

Thursday, August 11, 2016

Multiple Rental Properties


I own several rental properties, each with a market value, purchase price, and mortgage. Is it possible to control the timing of sale of each property?


There are two things you can do.

Combine the value of the properties into one and enter the average year of disposition. This will work if the disposition of the properties will occur over a few years in the future. For example of you plan to dispose of the properties within a 5 year window, say 2020 to 2024, you can use 2022 as the average year of disposition. This will not make a material difference in your retirement plan.

The other way is to enter the after-tax disposition of each property as 'Other Assets' on the Financial Information page. The disadvantage is that you won't see the full value of these assets in the net worth until the years of disposition.

Tuesday, August 9, 2016

Asset Projections


Why is the amount shown on the summary for poor returns is less than that shown for normal returns?


If you use a custom forecast that's very conservative, it may result in the main projection having lower values than the poor returns.

Thursday, August 4, 2016

Investor Profiles


Where can I view the asset mixes for the various Profile portfolios?


it's in the help files under 'Investor Profile': 

Tuesday, August 2, 2016

Use of Various Sources of Income


Does RetireWare optimize the various streams of income in retirement, i.e. non-registered, registered, etc. for each year to provide the most tax efficient outflows?

Does the software provide cash flow results in after-tax dollars?


The program does not do a year-by year optimization. Rather, the procedure for the use of funds followed by RetireWare is to determine whether existing pensions, such as company pensions,
Canada or Quebec Pensions and Old Age Security are sufficient to meet the retirement income objective. If not, RetireWare uses non-registered investment income (and capital until exhausted, if you select that option), then Tax-Free Savings Accounts (TFSA), locked-in RRSPs (including funds from a defined contribution pension plan), and RRSP/RRIFs last. This has the advantage of achieving tax-free compounding of registered investments for as long as possible. RetireWare uses locked-in RRSPs before non-locked-in RRSPs.

The software shows detailed cash flow charts and tables, showing each source of income, income tax payable each year and net income.

Friday, July 29, 2016

Data linking


Will your product read data from Quicken Home & Business?

I have RRSPs from many sources, stock options from my work, and have to open many different websites to look at all the investments.


No, there is no fetching of data from other sites, such as banks, mutual funds, brokerage accounts, etc.

There is no need to enter exact account balances, rather you can enter a close but approximate amount for each type of account (non-registered, registered, TFSA, locked-in), and the program will calculate whether you current funds together with planned savings will be sufficient to fund your retirement.

Wednesday, July 27, 2016



The description of RetireWare refers to limits on the number of "files" each subscription level is entitled to, but I don't see any explanation of what a file is.

I'm guessing it's a comprehensive report based on a single scenario or set of input data.


A file represents a record in the database that holds the information of a financial plan for you and your spouse.

With 10 files you can create a few alternative scenarios (different retirement ages, income goals), and you can build plans for other family members or friends and save their information for future retrieval.

When you delete a plan, your file tally goes back up by one. You can access any of your files at will to modify, run or generate a report and this does not affect your limit of 10.

Monday, July 25, 2016

Custom Rates of Return


Why can't the custom rates of return be set to negative values to match some current YTD performances?


You can see the effect of negative returns that will occur in some years with the Monte Carlo simulation.

We don't allow negative rates since making such an assumption over the long-term does not make sense. If it was a possibility, we might as well keep our assets in a 0% interest bank account.

You could put 0% for some or all asset classes and with investment management fees it would essentially be negative returns. For example, with a 0% return assumption for say Canadian equities and 2% fees, your return would be -2%.

Friday, July 22, 2016

RRSP withdrawals and withholding tax


My tax advisor suggested withdrawing income funds from my RRSP account before my non RRSP account now during times of layoffs.

This would be to reduce possible clawbacks in OAS at a later time. Is there a way for the software to pull from RRSP before non RRSP?

Also can it incorporate the withholding taxes that would be applied to withdrawal of the RRSP?


In order to do this, check the option 'Already Retired' on the Financial Information page.

Then on the Options page, on the first tab under 'Registered' select 'At the selected retirement age' for the 'Start Withdrawals of Registered Investments' option.

The income taxes showing in the cash flow statements are income taxes and deductions for each year based on your mix of income from all sources.

For withholding information, please visit the CRA website, or see this link:

Wednesday, July 20, 2016

Use of Funds


Does the application look at the original amount in non-registered and as soon as that amount is used it switches to registered withdrawals?

Does it consider deposits after the original date?


If at one point you don't have any other sources of funds, and non-registered and TFSA accounts are used up, your withdrawals will come from registered funds to meet your retirement income goal. if
you select to receive payments from registered funds as late as possible on the Options page.

On the 'View' page, at the bottom of the Accumulations and Income Forecast tabs there are pop-up tables that show the detailed cash flow.

You can open these tables and see the usage of funds to meet the income goal. You can do  for you, your spouse or the combined results.

Monday, July 18, 2016

Post retirement budget


When I create the post retirement budget selecting one budget for both spouses, it doubles the budget requirements. Our expenses are around $47,000 per year. when I finish the plan, its has our budget at over $90,000.

I've played around quite a bit with this and can't find a way to get it to use $47,000 total for both.


You must select 'Based on Expenses' for the retirement income objective on the Forecast page.

Otherwise, it's using a percentage or dollar-based income goal, not the separate or common budget.

Friday, July 15, 2016



1. Will the product allow me to prepare retirement income projections for my wife and me combined?

2. Assuming yes, will it allow different start times for her and my CPP and OAS?

3. Will it provide any optimization regarding when we should start drawing from RRSPs relative to
OAS and CPP?


1. You can do retirement income projections for a couple for a common plan by entering separately the financial information for each.

2. Yes you can start CPP and OAS, or retire at different times.

3. The software does not optimize the retirement date that will be best for RRSP withdrawals relative to OAS and CPP. But you can run a few different scenarios to find a practical solution.

Wednesday, July 13, 2016

Risk Analysis


Is there an explanation to what changes in metrics are used for the longevity, market, sequence of events and inflation risk analysis?


You will find information in the help files under 'View Menu' | 'Risk Analysis'.

Here's a link that provides more background on the approach used: 

Monday, July 11, 2016

Demo Account


Do you have a demo account that I can test drive?


No, but you can purchase the version you want to try it and we will refund your payment in full within 30 days if you don't like it or find it not to be a good fit for your needs.

In order to get a refund, simply send an email at and we will do the refund within one business day.

If you work for a financial services company and are looking for a vendor that does custom development, customization or white label versions of products, we do provide a demo account.

Friday, July 8, 2016

Detailed Cash Flow Tables


When I try to view the detailed table for both income and accumulations, nothing comes up. Any suggestions on how to fix?


Please ensure your browser doesn't block "pop-up" windows. Or try another browser, such as Google Chrome.

Wednesday, July 6, 2016

Types of Assets Supported by RetireWare


My spouse and I have salary income. We are contemplating early retirement (5 years early). We will both earn small pensions from our employers.

We have the following 6 registered plans. TFSA x 2, RRSP x 2, Locked-In registered plan (LIRA) x 2, plus Investment accounts x 2 plus an investment property.

Before I purchase a DIY plan I am writing to inquire if the software will has functionality to input details for all the above accounts individually.


You'll be able to enter all these types of accounts and property separately for each spouse by selecting the option of doing a plan that combines the financial information for both spouses on the Forecast page.

Monday, July 4, 2016

How to input annual TFSA contributions


How do I input annual TFSA contributions of $5,500 till I retire?


1. On the Forecast page, on the 'Savings Plan' tab, enter $5,500 and under Advanced select the last savings options (TFSA first).

2. Enter you TFSA room and contributions this year on the Financial Information page under 'TFSA'.

Note that you have to select TFSA as a source of retirement income on the Options page.

Friday, July 1, 2016

Rates of Return


In the economic outlook when I enter my own custom rates of return and in advanced you include investment management fees does that reduce the rates of return by the investment fee?


Yes it does, whether you select the standard forecast or enter your own custom rates of returns.

Wednesday, June 29, 2016

Life Income Funds


Is there a way to specify whether a DC pension in converted to a LRIF or LIF. It looks like it is defaulting to LIF.


You can specify the plan type and jurisdiction on the Finances page under Locked-in Retirement Account on the 'Registered' tab.

Software for individuals, advisors and financial services companies

Software for individuals, advisors and financial services companies
Retirement Planning

Blog Archive

Featured Post

Quantifying Risk

Lightning and lotteries According to the National Oceanic and Atmospheric Administration, the odds of becoming a lightning victim in th...

About Us

My photo
RetireWare is a Web-based risk management and retirement planning software for individuals and financial advisors that's easy-to-use, full of rich visuals and comprehensive analysis. Try today and take advantage of our unconditional money-back guarantee. Know how much retirement income you can have. Build a plan and know where you stand.

Equisoft Inc.

Founded in 1994, Equisoft offers advanced digital business solutions to its clients in the insurance and wealth management industries to support their growth. The firm develops and markets innovative front-end applications (InsuranceElements and WealthElements) featuring industry-leading user interfaces and state-of-the-art technology.

Follow by Email

© 2018 by Equisoft Inc. All rights reserved. Powered by Blogger.


© 2018 Risk Blog by Equisoft Inc. All rights reserved. Designed by Templateism

Back To Top