The MoneyReady Forum
adminprofile picture

admin

Administrator
Joined:
Posts:
238
Topics:
87

Updates on this as people ask me questions about the AI:

  1. Is it safe? Yes, your data is not sent to OpenAI, only your question. Don't put personal information in the question.
  2. If you did, it wouldn't know what to do with it anyway. It's a language model, instructed to answer questions based on the MoneyReady documents only. It's not a calculator or a financial advisor/planner.  It understands language and is aware of the MoneyReady documents only. It can't run the tools for you or analyse your data.
  3. Vous pouvez lui demander des questions en Français, et le AI repondra en Français si possible car il peut faire la traduction des documents. C'est pas toujours parfait.

When logged in, you can select to search all the MoneyReady documentation using OpenAI from our forum search page. Just type in any question you may have and a response will be generated with an OpenAI large language model. The model has been fed all the information in the MoneyReadyApp eBook, all the app's help pages, all the forum posts, all our blog posts, the app's homepage, and our various other pages. It is instructed to answer only based on those documents. It does not know your data.

The answer given is sometimes surprisingly smart, sometimes disappointingly wrong, and often incomplete.  We attempt to provide the references to the top documents it used to form its answer so you can quickly find the source of the information.

If the AI answer is not useful, please don't hesitate to contact us with your question or post it on the Forum. You'll get a real human to respond.

 

 

 

To accomodate mostly pensions but also any other INCOMES, REVENUES, EXPENSES and AUTOMATIC SAVINGS/WITHDRAWALS that are indexed proportionaly to inflation, we' ve added a new parameter to fine tune indexing to inflation in the TIME MACHINE.

See the FAQ for (logged in) users: https://www.moneyreadyapp.ca/forum/topic/76-how-is-indexing-to-inflation-set for details.

The general model we use (with some modifications for Canadians, to bring it up to date to today, and some additional factors relevant to our users like USD exchange rates) is described https://www.soa.org/resources/research-reports/2000-2006/research-modeling-of-economic-series-coordinated-with-interest-rate-scenarios/ and https://www.moneyreadyapp.ca/blog/post/14. It drives all the rates, for each year, in each the 100 TIME MACHINE runs. They are generated on the fly with the model, they are very variable, we don’t store these inputs. You can look at at an individual simulation in RATES/YIELDS/CURRENCIES and see the rates there, and then run that particular simulation through the TIME MACHINE, but for the 100 simulations we don’t store them, or analyze which gave you the worst case case. It’s not important, as we may not have even hit the very worst-case (due to the 100 limit, and the model itself. It’s just a model, a good one, but still not reality). What’s important here is to see how likely and when, you run into a cash-flow problem with these simulations, that is helpful to know so you can adjust your spending to avoid it.

You can set when you to convert an RRSP (or similar types) accounts by editing the account, and make sure to click submit until it asks you  “age to convert”. The default is 71 but you can change it. You can also do partial conversions by setting it up in AUTOMATIC WITHDRAWALS. 

The CPP calculations are done following the CPP Act, so the way the CRA would do it when you apply for the pension. It’s more accurate than the estimate you get from the Service Canada today which  is calculated  as if you were 65 today and your average earnings so far.  Our estimate considers your expected future income and contributions, and also considers your expectations for inflation until you start CPP. The TIME MACHINE Report provides a summary of the the CPP calculation given your entered table of contributions if you are curious about how the calculation was done,. It’s the last thing in the pdf report, so you’ll need to scroll all the way down.

I  checked on your run it and it does looks fine. I see what you mean about it optimizing to 66 for you. Looking at the 3D graph, it’s very flat. Essentially any ages after 63 for you and 62 for your spouse for starting CPP, results in about the same legacy. Why? I think the most likely explanation in your case is that you have a large portfolio set to earn decent returns, so any money you get from CPP earlier reduces what you need to withdraw from those accounts and they thus get to grow more, and that dampens the effect of receiving more CPP if you delayed. Generally the better investor you are, the more advantageous it is to take CPP earlier. I agree delaying CPP is generally advantageous, but not always, you have to do the math which is what we do. If you haven’t already, see https://www.moneyreadyapp.ca/blog/post/9 for my study of the issue. 

I’m glad you’re enjoying the MoneyReadyApp, thanks for you kind words,

 

You can now specifify the months to add to the age you start/started taking the pensions. The CPP/QPP Optimizer will still only explore the starting dates on each of your birthdays after retirement.

From the 2023 Projection Assumption Guidelines:

"Making projections is critical to creating financial plans that help clients realize their long-term goals," says Julie Seberras, CFP®, MBA, FCSI and Chair of the FP Canada Standard Council™ Standards Panel. "The Projection Assumption Guidelines are a useful tool for planners to ensure their projections are based upon sound assumptions."  

The Guidelines are intended to be used when making long-term projections of 10 years or more, and they're meant to look beyond the current day rate environment. For shorter-term financial projections (less than 10 years), financial planners may use actual rates of return on fixed-term investments held to maturity and dividend yields on equities.  

The Projection Assumption Guidelines for 2023 are as follows: 

Inflation rate 

2.10 %

Return rates 

 

Short-term 

2.30 %

Fixed income 

3.20 %

Canadian equities 

6.20 %

Foreign developed market equities 

6.50 %

Emerging market equities 

7.40 %

YMPE or MPE growth rate 

3.10 %

Borrowing rate 

4.30 %

 

Note that these are all before fees.

 

To help with your expense planning, we've improved the presentation of the EXPENSES table.

You can now add a Subtype as well as a Type descriptions on expense entries to allow for more refined breakdown of expenses.

To make entering those expenses easier, there’s now a dropdown so you’ll be able to select for the Type from any previously entered types, or create a new type by typing it in. Same goes for the Subtype. 

Above the  EXPENSES table you’ll see buttons to group by date range (beg to end), by Type or by Subtype. The groups will have a subtotal in CAD and today’s dollars added to the table. The Type and Subtype groupings are still first grouped by date range (otherwise a subtotal makes no sense).

Below the table are additional graphs for the Type and Subtype groupings over time. These can be toggled to full screen by clicking on them. The graphs are also available in the pdf Report (for new runs). The Excel download EXPENSES tab of the TIME MACHINE results should show each  entry with its type and subtype.

Type and Subtype are completely optional, they are just separate tags, so not truly hierarchical, and if no types or subtypes are entered anywhere, these columns will not appear on the web, pdf, or Excel download.

We've tried to make this very generic to suit everyones needs to use as they like to set things up. Your comments and suggestions are welcome.

 

Depends on the view you are looking at in which currency investments are shown. In the Investments list for a particular account, each investment’s price, market value and book value is shown in its native currency, and the currency symbol is shown, so for a US security you'll see  US$49.37 or €6.00 for a Euro stock for example. At the bottom of the list is the total in CAD for the account, where all the foreign amounts have been converted to CAD. That amount is what you’ll see as the balance for the account in the list of Accounts.  The list shown in "View Investments in all accounts" also show investments prices and values in native currency. That makes sense as you can change the prices right on that screen, and you wouldn’t want to have to convert it yourself (same as when you add or edit the investment). In the Excel download of all accounts, there is  a Currency column there instead of showing the currency symbol on the values, to make it easier to do calculations in the spreadsheet.

The totals in CAD shown in the Accounts list may differ from your bank statement in CAD due to a difference in the date of valuation of the investments (thus price and number of shares), and the currency conversion rate. As mentioned you can see the prices used in the Investments list. You can also see the conversion rate being used in the app under RATES/YIELD/CURRENCIES. If you have a lot of rates, just type currency in the search box above the rates table. You should see the rate for USD. You can change it for today and for the future in the TIME MACHINE.

Keep in mind that the app updates the foreign currency exchange rate nightly using the daily rates from the European Central Bank. It also updates investment prices and values nightly using market data provided by Fundata Inc for those investments we track with a ticker symbol. And if you’re a Wealthica user and linked the MoneyReady App to Wealthica, you can update investments on demand from them.

For calculations in the TIME MACHINE and in its results and reports, all foreign investments are converted to CAD.

Hi,

Add (or Edit if already entered) the INCOME. Make sure for Select an Income source to select "Other income" from the drop-down, and fill out the rest of the form.

For a one time payment, the Start date and End date should be the same.

Click Submit.

A new form will the ask you to Select the tax treatment of this income.

Select "Not taxable" from the dropdown. Click Submit.

Your list of INCOMES should now have it  as Type OTHER NOTAX.

 

 

Accounts will be withdrawn from in the TIME MACHINE according to:
1: Any AUTOMATIC Withdrawals entered
2: To satisfy required minimum withdrawals of RRIFs/LIFs
3: Your Withdrawal PRIORITIES if you have a deficit at the end of the year after taking into account all entered and calculated incomes, expenses and taxes.
The Optimizer will ignore 1 & 3 in years after retirement and make withdrawals in the optimal way to leave the highest liquid legacy.
If you do not see withdrawals from the TFSA, then you probably don’t need the money from that account to satisfy your consumption. 
Make sure you have entered your living EXPENSEs.
If you want to determine what your expenses should be to leave a legacy of your choosing, you can use the CHOOSE YOUR LEGACY feature and the tool will calculate those expenses for you.
Enter the dividend income you want as an INCOME, make sure to enter the amount that you want.
Select from the  Income source the type of dividend you want your from CCPC.
Non-eligible dividends are your best bet from a CCPC, the others require a balance in the notional accounts. See the Help page on the TIME MACHINE pre-flight screen for the CCPC or the eBook about the CCPC notional accounts for more explanation.
Depending on the dividend type you entered, and the balance of the notional accounts, the balance of the investment account,  any entered REVENUES, the TIME MACHINE  will pay what it can.
You’ll see a Warning in the results if it can’t pay it out what was asked for.

In most cases, if your province was set in your PROFILE to Québec, the default is you will be eligible for QPP. If set to another province, the default is you will be taking CPP. However there can be exceptions to that. For example if you lived and worked in another province, but choose to retire in Québec, then you will be eligible for CPP and not for QPP. For this reason, we allow you to select the other plan by checking the box in the input form. The province in your PROFILE will still determine where provincial taxes are payable.

We have implemented the changes for QPP that were announced in the March 21 2023 Québec budget to apply from Jan 1, 2024. Although these changes will require legislative and regulatory amendments and as of this writing on April 1 2023,  we have not yet seen the details of their implementation. We'll be monitoring closely and will make changes as necessary. 

Nous avons mis en œuvre les changements pour le RRQ qui ont été annoncés dans le budget du Québec du 21 mars 2023 et qui s'appliqueront à partir du 1er janvier 2024. Bien que ces changements nécessitent des modifications législatives et réglementaires et qu'à ce jour, le 1er avril 2023, nous n'ayons pas encore vu les détails de leur mise en œuvre, nous les surveillerons de près et apporterons les changements nécessaires.

 

Yes, I realise it can be confusing, but all we have to indicate the name and type of the account is the header of the table and it's already a pretty long description. There's more opportunity in the detailed yearly reports to change the description of the account. Or we could add a note in the Warnings column.  I'll see what I can do to make it clearer.

The TIME MACHINE calculates the maximum withdrawal for the LIF depending on your age, province, and account balance at the end of the previous year. It won't let you withdraw any more than that, so you don't need to worry about that.  For a LIRA not yet converted, it won't let you withdraw anything unless your are 65 or over. This is to mostly to allow partial conversions to take advantage of the $2000 pension tax credit, and also because it knows that if you really need the money you would have converted the account.  It still won't let you take out more than the maximum calculated as if LIF though.

Your welcome! It's my pleasure.

 

Hi,

You don't need to enter the RIF or LIF, so just delete those accounts with 0 balance. The RRSP will be automatically converted to an RRIF and the LIRA to an LIF in the TIME MACHINE, at the age you set for them to be converted. They will keep any of the investments you entered. They will also keep their original name, but you should see at least the minimum withdrawals come out of the accounts in the years after conversion in the results.

Hi,

For 1) and 2).  Our GIS calculation is now entirely based on our implementation of the Old Age Security Act. The act describes how to compute the amounts for OAS, GIS , Alllowance, and Allowance for survivor, and that's how we do it.  We do need to also use the updated maximum amounts that are indexed every quarter (from https://open.canada.ca/data/en/dataset/ff1e4882-685c-4518-b741-c3cf9bb74c3e). We don't use the government pre-computed GIS tables (which apply only with full OAS pension, and we can reproduce in that case), and we don't make approximations for the clawback. I've clarified the eBook section on OAS/GIS.

With our calculations, indeed the GIS amount and the income threshold is increased for pensioners with partial OAS pensions, the retirehappy blog is entirely correct. The second blogger is also correct in their analysis of the tables, but if they want to derive the calculation, they should read the OAS Act :)

The OAS and GIS/Allowance calculations are made in each year of the TIME MACHINE so they adapt to circumstances and income levels in each year.

3) Yes we implement the QPP supplement, we refer to it as the PRB (Post-Retirement Benefit) for both QPP and CPP (although they are calculated slightly differently).

BTW If your parents are 65 or over and the TIME MACHINE calculates a GIS amount in all years, these runs will not count towards their MoneyReady App free trial.

Yes that should be done automatically for you. Make sure to select Rental income from the dropdown menu for Select an income source when you add or edit the INCOME. Leave the End date blank. When you click submit, it’ll then ask you for the property to link the income to (it should have been previously entered in REAL ESTATE). Also make sure the property and the income have the same Owner (ie if you have a spouse and the income is joint, the property should also be joint owner). Click Submit again once you selected the property from the drop-down.
The INCOME Type should now be listed as RENTAL. The income will stop when the property is sold in the TIME MACHINE.

There's a new calculator for OAS and GIS at https://www.canada.ca/en/services/benefits/publicpensions/cpp/old-age-security/payments.html#estimate-benefits.

It's not complete as it wimps out if you don't have a full OAS pension (less than 40 year residency in Canada), but it works well if you do.

I'm excited about it because it's the first time I see any source code (the javascript is right there in the html source of the page) for calculations available for any calculations from the Canadian government. The US social security system has provided full source code for their calculations for many years.