With the current volatility in markets around the world, this announcement of new features to make updating all investments' properties easier is either timely or untimely. That depends on whether you closely monitor your investments or ignore them in such times.
Mock investments. You can now set any investment (except 'Cash' investments) to be ignored in the TIME MACHINE and in net worth calculations. This is useful to run scenarios with portfolios of different investments you are considering. Ignored investments will still have their values automatically updated with FUNData market data or Wealthica when applicable, so it's also useful to just follow these investments you are considering but may not own yet.
View/Edit all Investments in all Accounts now allows you to edit most properties of all investments entered all on one page. Besides price, shares, market value, and book value, you can now change the risk value, default current expected returns, fees, and whether to ignore the investment or not.
Update from a spreadsheet. If you have many investments that need to be entered or updated manually, you may want to update from a spreadsheet (particularly if you do not use Wealthica). Most financial institutions allow you to download your investment values into a comma-separated (csv) or other file format that you can then get into a spreadsheet program to view it. Once you have your data in a spreadsheet program like Excel, Google Sheets, or Numbers, you can now import those data to update your investments in the MoneyReady App. For adding new accounts and their investments, first add the Account in the app, then the spreadsheet can be used to add the investments into it. I refer you to the eBook to learn how to set up the spreadsheet for import. It's easy to get a template by simply downloading your current list of investments from the View/Edit all Investments in all Accounts page.
Many are asking me how to deal with the current market volatility. Do not panic. Keep a long-term view for long-term investments. Make sure the money that is needed short-term is there for you by not having it tied up in the market.
Remember, we provide the tools for you to determine how resilient your portfolio is and thus be prepared for market volatility: https://www.moneyreadyapp.ca/blog/post/14
All the Best to all my fellow Canadians,
Elisabeth
In my last Announcement, I mentioned users wanted more and more detailed reporting.
Please let me know if you have any questions or suggestions.
PRIORITIES determine the order of accounts to deposit money in years you have a surplus, or to withdraw from accounts in years you have a deficit. It is a great strength of the MoneyReady App that you can control that, but I've noticed that sometimes users get stuck on this.
PRIORITIES tables no longer intermingle your accounts with your spouse’s accounts and your CCPC accounts.
Each of those now require separate tables. This sounds like it would be more complicated, but it actually makes things a lot clearer.
The entire PRIORITIES section of the eBook has been rewritten, and for visual learners, we have created a new video explaining how PRIORITIES work in detail.
It was a good time to make this change as you will be required to review your PRIORITIES with the New Year (see below).
I'm a bit sad to see 2024 go, as it was an amazing standout year for the MoneyReady App. We celebrated it turning 5 years old, and though you'd think we'd run out of features to add, far from it! Here's a brief summary of the upgrades we made and announced in 2024:
Reporting.
SCANS.
Taxes.
Permanent life insurance.
CCPCs.
All this hard work paid off as we got attention from the Press this year. Both Bruce Sellery and Rob Carrick told me it was MoneyReady App users who recommended the app to them and urged them to make it widely known. And they did, big time. Many of you now are new users, so welcome!
You know where to find me if you have questions, comments, or suggestions.
Thank you for spreading the word.
Happy New Year everyone!
Elisabeth
New Year Checklist:
Here is a list of things that need to be updated at the start of the year, and sometimes throughout the year to keep the TIME MACHINE calculation as accurate as possible.
Hi everyone,
The response to the press attention mentioned in my last two announcements has been phenomenal and has kept me very busy answering questions from new users. But I've also made improvements to the MoneyReadyApp over the last couple of months that I'd like to share with you today.
As always, the details are in the MoneyReady App eBook and appropriate Help pages. Let me know if you have any questions or suggestions.
And I want to extend a warm welcome to all our new users!
The MoneyReady App is a web app. It works with any modern browser on any device.
A laptop or a large tablet is preferable.
Note that some versions of the Safari browser have a bug that can cause you to get logged out or send you back to the dashboard. If you have any problems with it, please use a different browser.
We've made substantial changes that apply to CCPCs to improve accuracy, clarity, and optimisation. If you have an incorporated small business, read on.
As always, lots of explanations in the eBook and Help pages. If this sounds complicated, well it is. CCPCs are very complicated and you should always consult with professional advisors (accountants and lawyers) that are specialised in this area.
I had a nice chat with Bruce Sellery last week for his podcast:
I'm happy to announce we now support permanent LIFE INSURANCE in the MoneyReady App.
We cover Term to 100, Whole Life, and Universal Life. Any of these, plus regular term insurance can also be owned by a CCPC.
We also support collateral LOANS secured by the policies.
Projecting permanent life insurance values in time requires a lot of information, some of which is proprietary to the insurance company and not available. This limits the calculations we can do. However, your insurance advisor can provide you with an Illustration for any scenario you would like to model using their company's software. This includes the source of premiums paying for the policy, and taking policy loans or partial cash-value redemptions of the policy. Their software can handle all the parameters for these flexible and complicated policies to calculate the death benefit, cash value, and adjusted cost basis at any point in the future given their assumed rates of growth and other assumptions. I realise that life insurance Illustrations may be complicated so you may need to discuss them with your insurance advisor.
We have added the ability to upload into the MoneyReady App the information from such illustrations that it needs for the TIME MACHINE. It's a lot of numbers to enter, so we provide a template you can fill in Excel and then paste it in. Once entered, the TIME MACHINE will be able to determine changes in your cash flow, including any tax implications of including the life insurance policy into your financial plan. The TIME MACHINE is limited to that illustration you upload and will follow it to the penny. It will not change it in Simulations or the Optimizer. The best we can do is to stick to what your insurance advisor projects.
I leave you to read the updated eBook and Help pages for details. The LIFE INSURANCE chapter was rewritten from scratch.
Let me know if you have any questions or comments. If you have specific questions about entering your illustration data into the app, please contact me. I may ask you to send me your illustration.
The Alternative Minimum Tax is now implemented (federally and for all provinces) and we make it available for MoneyReady App subscribed users only.
The AMT is a separate tax calculation done to make sure that wealthy Canadians that have little or no regular tax to pay due to claimed tax deductions and credits, still have to pay a minimum tax. This has always applied rarely, and it will be even more rarely applicable with the recent changes to the AMT calculation itself, and the recently announced changes to the capital-gains inclusion rate.
Because it applies so rarely, you can set whether to have it calculated it or not in your PREFERENCES. Most of you can leave the feature off, as it will slow down your TIME MACHINE runs. Just turn it on if you are running a scenario where you think it may apply, or if you have made AMT payments in the past.
It will always be calculated for Advisor clients.
If you do choose to have it calculated (and have a valid subscription), you will be able to enter any AMT tax paid in the last 7 years in the tax input screens before running the TIME MACHINE. The TIME MACHINE also calculates any refund of the previous year's AMT payments.
The TIME MACHINE will show a Warning if the tax is applied and the detailed year reports will show you any AMT paid or any AMT carryover applied.
Important change for everyone:
To accommodate the AMT calculation we now need to ask you for the current year's capital losses and the previous year's carried-forward capital losses separately in the tax input screens.
Please treat all tax calculations in the MoneyReady App as approximate as we do not consider everything.
Let me know if you have any questions or issues.
To speed up analyses like Simulations, Scans, and the CPP/QPP and Withdrawal Optimiser that require many TIME MACHINES runs, we now distribute those runs over several machines so that they are done in parallel. Mileage varies, but our testing has shown the analyes are now 3 to 8 times faster, which is a great improvement. We hire machines on demand just for your own individual jobs, so that only under extreme traffic conditions will they be waiting in queue.
The only downside is that showing you the actual progress of an analysis is a little more complicated, as progress is no longer linear.
You will now see "0% done" at the start as a worker is hired which gets the jobs ready to distribute. You'll then see "Distributing tasks (x% done)" with the x increasing up to 99% as the tasks get distributed to other workers. It could look stuck there for a bit, as it waits for tasks to come back, then you will see "Tasks done (x%)". This last one increases pretty quickly as the tasks come back finished.
Although the analyses are much faster, they can still take some time so please be patient.
Enjoy the long weekend!
The latest Federal budget proposed a higher capital gains inclusion rate for capital gains of 66.67%. This would apply to all capital gains for corporations, and to capital gains above $250,000 for individuals. This is supposed to be applied from June 28, 2024. Many people have asked for its implementation in the app already, and the app applies it for all of 2024 (since April 19, 2024 when we implemented it).
The TIME MACHINE has mostly a one-year resolution. Do not use the app for last-minute tax planning, you should use a tax advisor for that. We will roll back this change if the proposal does not pass although it seems likely to pass. We will be implementing other tax changes announced in the latest federal and provincial budgets in the next few weeks, so you may see slight differences in tax calculations.
Today I'm happy to announce parameter SCANS for the TIME MACHINE.
To explore the effects of systematically changing one or more of the many parameters you have entered in your scenario for the TIME MACHINE, we now allow SCANS. In addition to the 6 saved runs that you can have at a time, we also allow you to save up to 6 SCANS at a time. Each scan can contain up to 101 runs.
In a scan, you can vary most values for most of the entities you have entered in your scenario. You will first select the type of entity from a drop-down list (e.g., EXPENSES, INCOMES, INVESTMENTS, etc.), and then select the entity (e.g., the EXPENSE) and the kind of values that apply to that entity (amount, percentage, date, etc.). You then enter a starting value, an increment value (which can be negative for a decrement), and a stop value. For dates, the increment is in full years. A TIME MACHINE run will be done for each value of that parameter, keeping everything else constant in your scenario.
Because different parameters often move in tandem, you can add additional parameters in exactly the same way. Although there is no limit to the number of parameters you can add, there is a limit to the total number of runs (100) we allow per SCAN. Each parameter is linked to the others, and the final number of runs will also be determined by the parameter with the fewest scan values. You will be able to see a table of the values that will be used for each run to confirm that you have set up the SCAN as you want before actually running it. The last run that will be done is for your current unmodified scenario.
For example: Say you have quotes for different term life insurance values. You can get a $100,000 death benefit for a $1,000/year premium, and every additional $100,000 of coverage costs $1,000/year. To set up this SCAN, you would select INSURANCE from the first dropdown, then select "death benefit" from the second. To explore a death benefit from $100,000 to $1,000,000 in $100,000 increments, the starting value would be $100,000, the increment $100,000, and the stop value $1,000,000. Once those are entered you can `Save and add a parameter'.
Again you would select INSURANCE from the first dropdown, then select "premium" from the second. The starting value would then be $1000 and the increment $1000. The stop value for a million dollars of coverage would be $10,000 in this case. If you enter a stop value less than that, say $8,000, the last run would be for $800,000 of coverage not a million. If you enter a stop value that is higher than $10,000, the runs will still stop when the stop on the death benefit is reached. In other words, the first of the stop conditions to be reached ends the run.
Here’s another more complicated example: Say you just received your statement from your defined benefit pension plan. It shows you how much you will get in pension income and bridge benefits if you start your pension at 55, 60, 65, and 70. You are considering when to retire and wish to explore those options. You would select the PROFILE table, and then set the start date of retirement. Set a starting date at your retirement date, increment 5 as dates are incremented in years, and stop value of your retirement date at age 70. Because you have linked INCOMES, EXPENSES, and SAVINGS to your retirement date, the TIME MACHINE will automatically also adjust the start/end dates for those entries as well. You would then add the parameter for the table INCOMES and select the pension you've entered. You would add the value for the pension from your statement at 55, then for the increment enter the difference between the value at 60 and 55. You can add a very high value for the stop as the runs will stop after 4 runs anyway due to the date of retirement parameter. The pension may not increase linearly, however, so the increment may only be approximate in the SCAN; you can always run another TIME MACHINE with a more accurate value once you have narrowed down your options. You can then add another parameter for the bridge pension in the same way as for the pension. The TIME MACHINE will not pay out a bridge pension after 65 anyway, so again you can set a very high number for the stop value.
When the runs are finished, you will see a table with some stats (total taxes paid, legacy, to estate, etc.) for each of the runs in a given SCAN, similar to your list of saved runs. You will be able to view each one and compare them pairwise. Just like saved runs, you can restore its scenario. SCAN runs have an automatic description added to them that shows the values of the parameters used in that run. Its name is just the TIME MACHINE run number. You can modify the name and the description if you want.
SCANS are a little dangerous because there is little or no checking of your inputs at this level. You may be instructing the TIME MACHINE into a parameter space that is disallowed for whatever reason (a loan can't be amortized for example), and it may even crash. If there is a crash, the scans should continue running, but you won't get the results of any run that crashed.
Your list of saved runs now has an extra table with the list of SCANS. You can click on a scan to view it. SCANS have an automatic description added with the inputs that you entered for that scan. You can add additional information in the description. Changing the description will not change the parameters, you need to set up a new scan to do that. For advisors, note that SCANS and their results will be visible to clients by default. You can remove that permission for any scan by unchecking `Allow client to view results' where you go to edit the SCAN name and description.
You can re-run a SCAN on your current scenario. The SCAN's previous runs will be deleted and replaced with the new runs. For example, you could change the age of death in your scenario, and re-run the life insurance scan for that age of death. Or you can just re-run a scan in a few months with updated values of your accounts and other entities. To avoid crashes, make sure the parameters of the scan are still applicable to the updated scenario.
This feature is included with any subscription. Let me know if you have any questions or feedback.
Enjoy!
Hi everyone,
For completeness, I just wanted to catch up on some recent changes that were either already announced in the other forums or are fairly minor.
The TIME MACHINE Year reports now have subtotals by expense type (when specified), income type, and account type. You can now get all the years together in a single report. This extensive report, in both today's and future dollars, is now included as new worksheets in the Excel download.
You can view only a selection of the years. That is the same cash-flow report that is included in the REPORT for printing or pdf download.
A new summary cash-flow report is now also available. For every year, it shows the Cash In totals of EXTERNAL INCOME and ACCOUNT WITHDRAWALs by account type. The Cash Out columns show the total spending, total taxes, and ACCOUNT DEPOSITS by account type. The Net-savings are also shown. The cells are coloured with a heat map to help you see exceptionally low and high amounts.
Although these reports are available for older runs including saved runs, those may not show all the subtotals. Also if you've entered a lot of EXPENSE entries, you may want to add an expense type for them if you haven't already. This way you'll see their subtotals in the reports, and it will also make the Sankey diagram in the year report a lot cleaner.
You can get to any of these larger reports from the Views section below any TIME MACHINE Timetable, or from the Year report (click on any year in the Timetable).
Let me know if you have any issues, questions, or suggestions.
Elisabeth
Here's what the summary cash-flow report looks like:
The account rebalancing procedure used by our rebalancing tool and the TIME MACHINE now considers risk-adjusted expected returns rather than simply expected returns.
For that to work optimally, you need to have entered risk values for all your investments. To make that easy, we expanded the 'Change the expected rates of return for all investments by their asset classes' feature again. We've added a checkbox that when checked will also automatically set the risk value for each investment. If we can calculate the 3-year volatility for the investment from the FUNData market data for that investment, the risk measure on our scale of 1 to 20 will be used. If not, an approximate risk measure based on the investment's asset classes will be set.
The risk measure will also be set automatically when you enter new investments either manually or when first imported from Wealthica.
I like to start the year by reflecting on the one past, and 2023 was absolutely fantastic for the MoneyReady App by every metric we have: traffic, registrations, subscriptions, and renewals. It's all from word of mouth, we didn't do any advertising.
I want to thank all of you who have supported the app not only with your paid subscriptions that keep the lights on, but also your referrals, and your feedback. I always find your feedback very useful so thank you for taking the time to reach out through the Forum or the Contact page.
I am continually improving the app and adding features and I want to particularly thank the people who have asked for features directly, or simply through their questions, feedback, and interesting discussions, that inspired me to write new or to improve features.
Here is the list of new features and enhancements we announced last year with the Money Ready Forum usernames of the people I particularly want to thank.
January 2023:
• 100 Monte-Carlo simulations. (understandingTermite8)
• If you have started or applied for U.S. Social Security benefits. (forcefulFerret1)
• Foreign currencies for REVENUES, INCOMES, EXPENSES, and AUTOMATIC SAVINGS/WITHDRAWALS. (enlightenedSyrup4, forcefulFerret1)
• A model for the USD/CAD exchange rate was added to the Market simulations. (forcefulFerret1)
March 2023:
• The MoneyReady Forum. (SheltieLover)
• Accurate GIS calculations when reduced OAS eligibility. (enchantedTermite7)
April 2023:
• Implementation of changes to the QPP starting in 2024.
• Ability to take CPP in Québec and QPP outside of Québec. (niceBumblebeeburritos8)
• EXPENSE Types, Subtypes, and Subtotals. (forcefulFerret1)
May 2023:
• CPP/QPP and OAS start age including months.
• Added a multiplier option to inflation for indexing. (immenseMuesli9)
June 2023:
• OpenAI searching of all MoneyReady documentation. (WanderingMonkey)
• Repeating EXPENSEs date picker. (brilliantChile0, forcefulFerret1)
October 2023:
• We’ve added support for Family RESPs and now allow multiple Individual RESPs for the same beneficiary. (communicativeTuna7)
• New Cash-flow Sankey diagrams in the year reports. (gregariousDotterel1)
November 2023:
• Notification emails from the MoneyReady Forum. (SheltieLover)
• ChatTVM: use AI for solving Time Value of Money problems.
December 2023:
• Rates for Short-term and Long-term financial planning. (sincereFish9)
If you use and like any of these features, I wanted to give all the credit to the users named.
Behind the scenes were many more enhancements. We have also greatly improved the site's speed, stability, and accuracy by adding server capacity, extensive testing capabilities, and more automated error checks and warnings. But still, along with all this new code in an extensive app as this one, it is inevitable for a bug to sometimes creep into production, and you can blame me entirely for those.
So I also want to give a special thanks to all of you who have graciously reported anomalies you saw or asked for clarification. This greatly helped me find the bug if there was one or to clarify the app and its documentation to eliminate confusion. Many of you are already in the list above since the power users that use the app extensively and push it to its limits, are also the most likely to both see anomalies and to make suggestions. Additional thanks to sympatheticRaisins4, impartialLollies5, astronomicalToucan8, stupendousSausage4, marvelousJerky8, incredibleBustard8, likableToucan0, decisiveGuppyhare3, courteousEggs8, fearlessRaisins5, enchantedTortoise1, focusedGranola0, lushEnzymeeukaryotefalcon1, adventurousBittern9, proficientLlama0, dependableTermite1, bustlingEnzymeeukaryotefalcon6, mountainousCheetah8. I thank you all for your patience and understanding.
Together, we are making the MoneyReady App the smartest financial planning app for you and all Canadians.
Onward to 2024! I wish everyone a happy and prosperous year.
Elisabeth Tillier, Ph.D.
President of MoneyReady
Today I'm happy to announce changes in the RATES/YIELDS/CURRENCIES section.
These mostly apply to advanced users who enter and follow their individual investments.
1. Setting default expected rates of return by asset classes.
If you've used this feature before you'll notice we have expanded the asset classes considered.
The rates entered will now be used to automatically set expected rates of return when investments are first entered, or first imported from Wealthica.
The defaults have been set to the FP Canada long-term recommendations but you can change those defaults and save them.
You can use them to change the default rates for all your investments at once at any time. You can now also opt-out any investment you never want changed by this feature.
2. Setting Long-Term future expected rates of return.
This allows you to set the TIME MACHINE to switch to long-term rates of return by asset class starting a given number of years in the future for all your investments.
This is an important new feature that permits simultaneous short-term and long-term financial planning.
It allows you to plan for shorter-term goals like buying a house, in conjunction with longer-term goals like retirement (or a later stage in retirement).
Many of my users are investors who follow their investments closely, including short-term investments with much higher or lower rates of return than the FP Canada™ projected long-term rates.
They want the rates to reflect their own expected returns for the short term, and see those reflected in the short-term projections.
However, by allowing long-term projected rates to start from a later date, we can also obtain a reasonable long-term financial plan.
3. The Withdrawal Optimizer now allows changes in future rates.
The motivation to implement varying rates in the Withdrawal Optimizer came about because of the new feature to automatically switch to long-term rates in the TIME MACHINE.
You can now optimize any TIME MACHINE run that uses that feature, anywhere you have set future rates manually in the Rates table,
and it even runs with market-crash scenarios and market simulations (although the usefulness of this on such simulations is doubtful).
Please see the expanded RATES/YIELDS/CURRENCIES section (7.1) of the eBook for details. Let me know if you have questions.
Happy holidays everyone!
You can now receive email notifications from the MoneyReady Forum.
This is turned off by default. To turn it on, first log in. On the Forum page, click on the arrow next to your username to go to Settings. There you can select from 3 options:
Click Save once you've made your selection. You can select all 3 options but you will only get 1 email if more than one option applies for a new post.
I recommend you select option 2 to be immediately informed of any new features and changes on the MoneyReady App.
You can turn off the emails anytime by changings your Settings again.