The following data entry key was developed to assist users of The Razor with
questions related to gathering and entering a client's information. This key
was based on the 6 steps of the data entry wizard but can also be used with the
Data screen.
Client names: Enter your client’s names as you would like them to appear on the
client report.
Advisor name: Enter the advisor’s name as you would like it to appear on the
client report.
Plan date: The Razor has been designed to calculate based on whole years.
Therefore, the software will begin calculations as of January 1st of the year
entered. Example: A plan date of September 19, 2011 will cause the software to
begin calculations as of Jan 01, 2011. Enter the plan date as “MMM DD, YYYY”.
Entering the date in this exact format will mitigate issues caused by different
system settings.
Comment: This field allows you to enter a specific comment with respect to the
client file opened. This value will not appear anywhere within the reporting or
calculations.
Name: Enter the first name of both Client A and Client B (if needed).
These names will appear on the client reports. Including your client's
last names as well may cause issues if the name is too long.
Date of birth: Enter your client's date of birth as “MMM DD, YYYY”.
Entering the date in this exact format will eliminate any issues caused by different
system settings. It may be possible to enter the date in another format,
but this ability will vary depending on the system settings you are using.
Age: This is an auto-calculated field. The software will determine the age of
your client based on the date of birth entered. Keep in mind that the software
will make calculations based on January 1st of the Plan Date year. Therefore, it is
possible that your client’s age may appear to be one year younger than their
actual age if their birthday
falls between January 1st and the Plan Date.
Gender: Enter your client(s)' gender; this will affect the calculation of
life expectancy at retirement as well as chart colours when necessary.
Client B: If you are entering a single client, be sure to select “No
Spouse” from this field's dropdown. This will remove all spousal (Client B)
information from the reports. There is no need to remove Client B default
information if "No Spouse" is selected, the software will do this automatically
in the calculations.
Address: Enter your client's current street address if necessary.
This information is for your purposes only, any data entered will not show up on
the client report.
City: Enter your client's current city of residence. This
information is for your purposes only, any data entered will not show up on the
client report.
Prov: Enter your client’s current province of residence for tax purposes.
This information is required to properly calculate the taxes to apply to client
income both Pre and Post retirement.
Postal Code: Enter your client’s current postal code. This
information is for your purposes only, any data entered will not show up on the
client report.
Preferred contact number A or B: Enter the preferred contact number for both
client A and B. This information is for your purposes only, any data
entered will not show up on the client report.
Email address A or B: Enter the email address for both client A and B.
This information is for your purposes only, any data entered will not show up on
the client report.
Income (A$): Enter your client’s gross “Earned Income” for the current taxation year.
Do not include investment income such as interest, dividends or capital gains.
This entry is required to accurately calculate the impact of taxation on your
client’s non-registered investment prior to retirement. If the client is
receiving substantial dividend income you may choose to include it but will be
required to gross-up the dividend for tax purposes. This may seem odd at
first, but keep in-mind that The Razor does not calculate pre-retirement
cash-flow and therefore does not require the breakdown of income sources, just a
tax base for investment income moving forward.
This field will also attribute to the client's Human Capital calculation for
risk management. Any income entered into this field will increase the
client's overall Human Capital. If you have grossed-up the client's income
due to large dividend payments as mentioned above, the client's Human Capital
may be overstated. In this case you can enter a negative amount equal to
the gross-up as "Other Income" (Wizard / Step 1 / Other). This will
in-turn reduce the client's Human Capital to account for the grossed-up
dividend.
Occupation / Employer: Enter the current occupation and employer of both
client A and B. This information is for your purposes only, any data entered
will not show up on the client report.
Income (A$): In addition to earned income, your clients may also generate other
income, such as corporate earnings, that are not paid to them directly but do
benefit them financially. This amount should be entered here. Any income
values entered into this field will have a direct result on the calculation of
Human Capital but will not affect tax calculations.
Example: Client A owns a professional corporation, earns $200,000/year but only
pays himself $85,000 and leaves the remaining $115,000 in his PC. In this
example, Client A has "Employment Income" of $85,000 and "Other Income" of
$115,000. The $85,000 will affect both taxation and Human Capital, whereas
the $115,000 will only affect Human Capital, it will not increase the
calculation of tax.
In addition, if one client is considered a “stay at home parent” and is not currently
generating earned income, you should enter the annual amount of additional
income required (for child care and other expenses) should this client die
prematurely. This information is necessary so that the software can properly
assess the value of the client’s Human Capital.
To Age: Enter the age to which you anticipate this income will continue. You can
select “Retirement” automatically by clicking on the field and selecting it from
the drop down. You can also choose to enter another age by simply typing it in.
This is most applicable when a client has increased child care expenses while
the children are young, but will decrease at some point in the future.
Active Age Client A: This field establishes the retirement age of both
Client A and B. The age
entered is based on Client A’s age. Should you wish to enter separate retirement
ages for Client A and B, use the field labeled "Age: Client B". However,
the software will still base all reports on Client A's age.
Active Age Client B: This field allows you to establish separate retirement ages
for both Client A and B. To set the retirement age for Client B, type an
age directly into the field. If left "N/A" the software will assume Client
B retires at the same time as Client A. Should you choose to retire Client
B at a separate age from Client A, it is recommended that Client B retire later.
In addition, any income earned by Client B while Client A is retired will be
used to offset retirement income needs. Should any excess income exist
during this period, the software will assume it is disposed of and not
automatically save the excess. Should you wish to save the excess income
while Client A is retired and Client B is still employed, it is recommended that
you retire the clients at the same age (set "Age Client B" to "N/A") and enter
Client B's income through the "Working In Retirement" section (Wizard / Step 2 /
Working). Any excess income entered in this manner will be automatically
saved by the software.
Passive Age: This field allows you to establish a secondary stage of retirement,
one during which your clients will be likely to spend less than in early
retirement due to the decrease in travel or other activities. This
age must be later then "Active Age" to avoid calculation errors, and is based on
the age of Client A. Should you choose
not to use a passive stage of retirement, simply enter $0 as the Passive Age
goal in the “Income (M$)” field. The software will then use the same value
as entered in "Active Age"
Income (M$): Enter the client's retirement income goal for both Passive and Active ages.
These values should be entered as Monthly After-Tax amounts, the software will
automatically calculate the annual amount.
Annual $: This field will automatically calculate the annual amount of Passive
Age or Passive Age income. You cannot override this data field, to change
the client's goal, enter a monthly income goal in the "Income (M$)" field.
Goal 1-5: Summarize the other goals and objectives of your clients. These goals
will not impact the calculations or reporting of the analysis. The purpose of
this area is to allow the user of the software to have a better understanding of
the client’s vision while making recommendations. In addition, there is
also a "Notes" area available from the "Data" screen for further notes and goals
tracking.
Amount (M$): Your clients may plan on transitioning into retirement by
continuing to work for a number of years at a reduced capacity or by engaging in
something else they enjoy. This field allows you to include this additional cash
flow into the analysis. Enter the monthly pre-tax income the client will expect
to earn. The income entered will be used to offset the client's income
needs throughout retirement. Any excess income will automatically be saved
in the client's Cash Investments.
Annual $: This field will automatically calculate the annual amount of income
expected. You cannot override this data field, to change the client's
income, enter a monthly income in the "Amount (M$)" field.
Index (% inflation): Should your clients expect this income to increase, enter
this increase as a percent of inflation. For example, if inflation is entered at 3% and you
enter 50% in this field, the software will assume an increase of 1.5%.
Start Age: Enter the age at which you anticipate this income will begin
accumulating. You can select
“Retirement” automatically by selecting it from the
dropdown. You can also choose to enter another age by simply typing it in.
If you choose to enter "Retirement", this field will adjust to match whatever
retirement age is entered. If you enter any other numeric age, it will not
adjust when changes to retirement age are made.
End Age: Enter the age to which you anticipate this income will continue as a
numeric value.
Amount (M$): If your client is expecting to receive retirement income from a
Defined Benefit pension, enter the expected income as a pre-tax monthly amount.
If they are currently retired, enter the amount they are receiving today. In
some cases, it is possible that a client could be receiving income from more than one
pension plan. In this situation, you could choose to group these benefits
together or enter the second pension in the Other Retirement Income section.
Enter any Defined Contribution pensions in the Registered Retirement Investments
section.
If the client is expecting to receive a bridge benefit for early retirement, you
will not enter the bridged amount in this section. Only enter the amount
of the pension less the bridge benefit. The bridge benefit will be entered
in the "Other Income" (Wizard / Step 2 / Other ) section of data entry.
Annual $: This field will automatically calculate the annual amount of pension
income expected. You cannot override this data field, to change the
client's income, enter a monthly income in the "Amount (M$)" field.
Index (% inflation): If this pension income offers indexing, enter the expected
indexing as a percent of inflation. For example, if inflation is entered at 3%
and you enter 50% in this field, the software will assume an increase of 1.5%.
Start Age: Enter the age at which you anticipate this pension will begin. You can select
“Retirement” automatically by clicking on the field and selecting it from the
drop down. You can also choose to enter another age by simply typing it in.
If you choose to enter "Retirement", this field will adjust to match whatever
retirement age is entered. If you enter any other numeric age, it will not
adjust when changes to retirement age are made.
Survivor (%): Some pensions offer a survivor benefit allowing a portion of the
income to pass on to a surviving spouse, should the client die. Enter the
survivor portion as a percent of the total income. The software requires this
information to properly calculate a client’s Human Capital in the risk
management section.
Method (% or $): CPP can be entered as a percent of maximum or a dollar amount. If
your client has not started receiving CPP, it is recommended you select “%
Maximum” from the dropdown and enter the percentage of your client’s average
lifetime earnings compared to YMPE (Yearly Maximum Pensionable Earnings =
$48,000 for 2011) into the field labeled “CPP (% Max)”. If your client is
currently receiving CPP benefits, select “Enter $” from the dropdown and enter
the total monthly amount received into the field labeled “CPP ($ Month)”.
% of Maximum: If you have selected “% Maximum” in the field labeled “CPP (% or
$)”, enter the monthly benefits your clients expect to receive as a percentage
of maximum CPP. Should you enter a start age earlier or later than 65; the
software will automatically adjust the CPP benefit accordingly.
$ Amount: If you have selected “Enter $” in the field labeled “CPP (% or
$)”, enter the total monthly benefit received by both clients. The software will
not make adjustments to this amount should you enter a Start Age earlier or
later than 65.
Start Age: Enter the age at which you expect to begin receiving CPP. You can select
“Retirement” automatically by clicking on the field and selecting it from the
drop down. You can also choose to enter another age by simply typing it in.
Include Benefit: For higher-income pensioners, the basic OAS pension is reduced by 15%
of net income exceeding $67,668. This 2011 limit is adjusted annually for
inflation. Should you choose to include OAS in your projections, any clawback of
benefits will be calculated automatically based on your client’s projected net
income. To include OAS benefits, select “Yes” from the dropdown.
Method: There are two ways to include OAS; Age 65 or Budget 2012.
Selecting "Age 65" from the dropdown will base your clients OAS calculation on
the old age 65 rules prior to the 2012 budget. Selecting "Budget 2012"
will utilize the new 2012 calculation for OAS and, depending on the age of your
client, may cause them to wait till 67 to begin receiving benefits.
This option is useful when demonstrating to a client, the impact the 2012 OAS
changes will have on their retirement. For many clients, this means that a
retirement goal which was previously attainable, may now be out of reach and
new recommendations are required.
Start Age: If "Age 65" is selected in the "Method" field, this data point is not
required, as age 65 is the only option. If "Budget 2012" is selected in
the "Method" field, you can choose to defer OAS payments up to age 70.
This will provide an increased OAS benefit to the client but will delay the
start date of OAS.
Amount (M$): In addition to retirement income, your clients may expect to
receive income in retirement from other sources, such as rental property or an
annuity. Enter the total monthly amount your clients expect to receive, in
today’s dollars. If a client is expecting to receive a bridge benefit on
their pension due to early retirement, enter only the bridge portion in this
location. The base pension amount should still be entered in "Pension
Income" (Wizard / Step 2 / Pensions).
Index (% inflation): Should your clients expect this income to increase, enter
as a percent of inflation. For example, if inflation is entered at 3% and you
enter 50% in this field, the software will assume an increase of 1.5%.
Taxable (%): This field allows you to specify the taxable portion of this income
source. In most cases 100% of income received would be subject to taxation,
however, as alternative scenarios arise you will be able to adjust this amount
and reduce the taxable portion.
Start Age: Enter the age at which you expect this income to begin. You can select
“Retirement” automatically by clicking on the field and selecting it from the
drop down. You can also choose to enter another age by simply typing it in.
If you choose to enter "Retirement", this field will adjust to match whatever
retirement age is entered. If you enter any other numeric age, it will not
adjust when changes to retirement age are made.
End Age: Enter the age to which you anticipate this income will continue as a
numeric value.
Survivor (%): Like a pension, some of this income may pass on to a surviving
spouse, should one of the clients die. Enter the survivor portion as a percent of
the total income. The software requires this information to properly calculate a
client’s Human Capital in the risk management section.
Value ($): Enter the total value your clients have in all RRSP
investments, as well as any Defined Contribution Pension assets. These
accounts are grouped together within The Razor because of their similar tax
treatment. The software will automatically calculate minimum withdrawal
amounts and although we understand that there are maximums associated with DCPs in
some provinces, this has not been included. The primary goal of The Razor
is to enable an advisor to quickly and efficiently analyze a client situation while providing a high
quality result. Separating these two investments will create complexity
within data entry and provide little advantage in the way of accuracy.
Please contact support if you wish to discuss this
concept further.
Savings ($): Enter the savings your clients are planning to make now and in the
future to RRSP and DCP investments. You can choose to enter them as either annual or
monthly amounts, but must specify the mode in the “Mode (A/M)” field. Although
there are maximums associated with RRSP deposits, the software does not limit
the amount a client can deposit. Therefore, there is no data entry point for
Current Contribution Room. An advisor must make sure not to exceed the
available room for RRSP deposits.
If entering DCP deposits, enter both the client and employer portions. As
The Razor does not analyze pre-retirement cash-flow, no justification is
required for these added employer deposits. If a client has both DCP and
RRSP deposits, you should group them together in this field.
Mode (A/M): To enter the mode associated with RRSP savings, click on the field
and select either “Annual” or “Monthly” from the dropdown.
Index (Y/N): To specify whether savings will be linked to inflation, click on
this field and select “Yes” or “No” from the dropdown. The software will
use the inflation rate entered through assumptions (Wizard / Step 5 / ROR).
Value ($): Enter the total value that your clients have in all Non-RRSP investments
and Tax Free Savings Account (TFSA) assets. The software will automatically
allocate any current value and future savings into a TFSA asset, up to the
maximum room available. This result can be seen in the Ledger under
Personal Assets / Cash Investments / TFSA Balance. The benefit to this is that
the software will continue to utilize the TFSA account even when in retirement,
demonstrating the full benefit of TFSA. There are locations to enter Client A
and Client B investments, as well as any joint investments.
Cost base ($): Enter the current cost base of all Non-RRSP and TFSA investments.
The software will utilize this amount when calculating the tax liability of
Non-RSP investments. This allows the software to accurately calculate the tax
implication of investment withdrawals and net worth.
Savings ($): Enter the savings that your clients are planning to make now and in the
future to Non-RRSP investments. You can choose to enter them as either annual or
monthly amounts but must specify the mode in the “Mode (A/M)” field. The
software will automatically track maximums associated with TFSA deposits.
Therefore, there is no data entry point for Current Contribution Room.
This is an area we will expand on in a future release.
Mode (A/M): To enter the mode associated with Non-RRSP and TFSA savings, click on the
field and select either “Annual” or “Monthly” from the dropdown.
Index (Y/N): To specify whether savings will be linked to inflation, click on
this field and select “Yes” or “No” from the dropdown. The software will use
the inflation rate entered through assumptions (Wizard / Step 5 / ROR).
Value ($): Enter any real estate your clients currently own. There are three
types of properties that can be entered; principal residence, recreational
property and investment/rental property. Any growth associated with your
client’s principal residence will not create a tax liability, however, any growth
associated with the other two properties will create a tax liability. If
the client owns more than 3 properties you must group the excess properties into
one of the 3 categories.
The software will not liquidate fixed assets to help fund the client's
retirement goals. Instead, the software will calculate the retirement
assets required and compare this amount to the client's total assets. This
can be seen on the Assets chart in the Chart screen or on Integrated Analysis in
the client report. This allows you to look at the effect of liquidating
fixed assets without the need to model the results.
Cost base ($): Enter the current cost base of the selected real estate
properties. As the principal residence is not subject to taxation, cost base is
not required. The software will utilize this amount when calculating the tax
liability of all future growth. This allows the software to accurately calculate
the tax implication from an estate and net worth perspective.
Mortgage ($): Enter the current outstanding mortgage value of the selected
property. This amount will negatively affect the client’s net worth and any
remaining payments at retirement will be added to lifestyle needs. The
software will automatically pay down the mortgage based on the "Rate (%)" and
"Payment (M$)" entered, see below.
Rate (%): Enter current interest rate associated with the client’s mortgage.
This is a static rate, compounded semi-annually, that will remain until the mortgage has been reduced to
zero.
Payment (M$): The software allows for a monthly mortgage payment only. For
clients who are paying weekly or bi-weekly, you will need to adjust their
payments to reflect a monthly payment.
Value ($): This location allows you to specify an additional one time
deposit for both the client and spouse. The software will automatically allocate
this amount toward the client’s Non-RRSP investments. Withdrawals will then be
made to offset lifestyle deficiencies if the client is retired. Two entries have been included to
add flexibility.
At age: Select the age at which this one time deposit will occur.
Two entries have been included to add flexibility.
Value ($): This field allows you to specify any additional personal assets at
three different rates of return: the rate of inflation, investment rate of
return and no indexing. If entering an asset, decide the type of growth it will
experience and enter the value into the corresponding location.
Cost base ($): Enter the current cost base of the selected asset. The software
will utilize this amount when calculating the tax liability of all future
growth. This allows the software to accurately calculate the tax implication
from an estate and net worth perspective.
Value ($): Enter the total value of all non-real estate corporate investments.
The software will use this information to track the value of the corporation
throughout the lifespan of the clients. This value can then flow out to the
clients to help offset needs in retirement (Wizard / Step 6: Plan Assumptions /
Settings / Solve Corporate).
Cost base ($): Enter the current cost base of all non-real estate corporate
investments. The software will utilize this amount when calculating the tax
liability of the corporation. This allows the software to accurately calculate
the tax implication from an estate and net worth perspective.
Savings ($): Enter any savings being made to the non-real estate corporate
investments. You can choose to enter them as either annual or monthly amounts
but must specify the mode in the “Mode (A/M)” field.
Mode (A/M): To enter the mode associated with corporate savings, click on the
field and select either “Annual” or “Monthly” from the dropdown.
Index (Y/N): To specify whether savings will be linked to inflation, click on
this field and select “Yes” or “No” from the dropdown.
Value ($): Enter any real estate held within a client’s corporation. Enter the
total value of all corporate real estate as a single amount. Any future growth
associated with corporate real estate will create a tax liability.
Cost base ($): Enter the total cost base of all corporate real estate
properties. The software will utilize this amount when calculating the tax
liability of all future growth. This allows the software to accurately calculate
the tax implication from an estate and net worth perspective.
Mortgage ($): Enter the current outstanding mortgage value of all corporate real
estate properties.
Rate (%): Enter current interest rate associated with the corporate real estate.
This is a static rate that will remain until the mortgage has been reduced to
zero.
Payment (M$): The software allows for a monthly mortgage payment only. For
clients who are paying weekly or bi-weekly, you will need to adjust their
payments to reflect a monthly payment.
Value ($): In addition to investment and real estate, the corporation may also
have considerable value in the good will of the day to day operations. This
field allows you to increase the value of the business beyond the total value of
investments and real estate.
Value ($): This field is automatically calculated based on the total value of
all corporate assets, less any remaining liabilities.
Cost base ($): Enter your client’s Adjusted Cost Base as it relates to the
corporate assets. The ACB is used to determine the cost of the shares for tax
purposes. Generally, 50% of the capital gain is taxable when the shares are
disposed of.
Inflation: Enter the rate of inflation by which your client’s analysis will be
based. This rate of inflation will affect the lifestyle needs of your clients
and establish the base inflation for government benefits and retirement income.
Investment: Enter the average assumed rate of return for all investment assets,
both personal and corporate.
Real Estate: Enter the annual increase in value of all real estate properties,
both personal and corporate.
Business Value: Enter the annual increase in value for business operations and
good will.
Lifestyle Debt: Enter the interest charged on money borrowed to finance income
deficiencies in retirement (Lifestyle Line of Credit).
Accumulation: Enter your client’s current Tax Efficiency Factor. This amount
will be applied to all pre-retirement investment income. For a full description
of Tax Efficiency, please see the notes at the end of this document.
Retirement: Enter your client’s future Tax Efficiency Factor. This amount will
be applied to all post-retirement investment income. For a full description of
Tax Efficiency, please see the notes at the end of this document.
Income Splitting: Many forms of retirement income can be split between spouses,
resulting in a reduction in income taxes. Enter the assumed level of income
splitting your clients can attain. Keep in mind that while 100% would be very
difficult to achieve, it is not always in the best interest of the client. You
can alter this value in the future to view different outcomes.
RRIF Age: Enter the age at which your client’s RRSP investments will begin paying
retirement income. If RRIF income is required before this age, the software will
automatically begin making withdrawals unless “Solve RRIF” has been set to “No”.
Solve RRIF: This field allows you to give the software the ability to draw on
RRIF assets to fill deficiencies in retirement. If set to “No”, the software will
be limited to drawing RRIF minimum amounts only.
Solve Corporate: This field allows you to give the software the ability to draw
on corporate investment assets in retirement. If “Yes” is selected the software
will automatically create a dividend to utilize RDTOH each year, beginning with
the first year of retirement. The software will also utilize principal amounts
to generate a dividend to offset deficiencies in retirement, only after RRSPs
and Non-Registered investments are depleted.
LE + Years: Enter the number of additional years past life expectancy to solve
for income goals. For example, a life expectancy of 85 with a “LE + Years” of 5
will solve to 90.
Monthly LOC: This field allows you to enter an amount of income to leverage in
retirement. This is most applicable while demonstrating an Insured Retirement
Plan (IRP) strategy. The software will track and display a leveraged withdrawal,
but will not physically tie the leveraged amount to any one fixed asset. This
allows you to demonstrate the ability to borrow against fixed assets for
discussion purposes.
Life Insurance: Enter the number of Human Capital years to cover with Life
Insurance. For a full description of Human Capital, please see the notes at the
end of this document.
Critical Illness: Enter the number of Human Capital years to cover with Critical
Illness Insurance. For a full description of Human Capital, please see the notes
at the end of this document.
Disability: Enter the number of Human Capital years to cover with Disability
Insurance. The software will divide this Human Capital amount by the number of
months remaining to this point. For a full description of Human Capital, please
see the notes at the end of this document.
DI % Income: Enter the percent of income to include for the Disability
calculation above.
LTC % Income: Enter the percent of current income required, should your client
require Long Term Care.
Finish Button: Clicking this button will automatically calculate the client
analysis and move you to the Report document. From here you can view the results
and print the client report. To make changes, you can return to the Wizard or
Data screens at any time. For advanced users, you can also use the Chart screen
to view and manipulate client data.
Report Title: This field allows you to change the title of all client reports.
Advisor Contact Information: Any data entered here will automatically populate
on the Cover Page of the client report. To change the "Advisor Name", see
"Getting Started".
Tax Efficiency (TE): "Tax Efficiency" is a concept that is applied to
non-registered investments and represents the portion of investment income that
is taxable. For example, an investment that earns capital gains that are fully
realized each year would be 50% tax efficient. Whereas, an investment that earns
only interest would be 0% tax efficient, as 100% of the growth is subject to
taxation.
Allocation and taxation have an immense impact on a client’s ability to fund
their needs throughout their lifetime. By incorporating Tax Efficiency into The
Razor, we are able to accurately calculate taxation while minimizing the
complexity of the analysis and effort required to complete it.
Human Capital (HC): "Human Capital" is used by The Razor as a heuristic method
to calculate a client’s life insurance needs. This process involves estimating
their future earnings potential, then discounting this future cash flow using an
appropriate investment rate of return.
The lifestyle that your client enjoys today, and hopes to enjoy in the future,
is only made possible because each year they convert part of their Human Capital
into cash, investments, real estate and other assets that they will use in the
future.
The content of this site is
intended to provide you with information on the products and services of
Financial Plan Advantage and should not be
considered in any way as providing
advice. We made every effort to ensure the accuracy of the information provided
on this site at the time of posting,
however it is recommended you not act or
rely on any information on this site without first seeking the advice of the
appropriate professional advisor(s).
Copyright 2011, Financial Plan Advantage Ltd. All rights reserved