Question: Craig and Lyn Case Data Organization (provided to the students) As a Financial Planner you will often have extensive meetings with your clients to collect

Craig and Lyn Case Data Organization (provided to the students)

As a Financial Planner you will often have extensive meetings with your clients to collect all the information required to design an appropriate financial plan for them. Once you have acquired everything you need it is always a good idea to divide the data into sections based on various segments of financial planning (listed below). The same approach should be used when you, as a student, address a case study. To demonstrate how this will help we have completed this task for you for the Craig and Lyn case. We have also provided a cash flow statement for Craig and Lyn with the current expenses included. You can use this cash-flow statement as the basis for the projected cash flow statement you will complete which will include all the recommendations you are making for the couple. You will find the information divided into the following sections:

Financial and Life Goals

Risk Tolerance

Assumptions

Financial Management Plan Related Information

Asset Management Plan Related Information

Taxation Management Plan Related Information

Risk Management Plan Related Information

Retirement Management Plan Related Information

Estate Management Plan Related Information

Financial and Life Goals Short Term Goals (1 5 Years)

Find a way to budget for paying Craigs income taxes (Craig)

Long Term Care Insurance (both)

Critical Illness Insurance (both)

Disability insurance (both)

Quit smoking (Craig)

Life insurance (both)

Eliminate the Credit Card Debt (both)

Develop a workable budget (both)

Find ways to create an emergency fund (both)

Medium Term Goals (5 10 Years)

Buy a home in Florida to use for retirement (both)

Buy a new vehicle for Lyn

Long Term Goals (Over 10 Years)

Retire at age 65 (Lyn)

Retire at age 61 (Craig)

Put both children through post-secondary education (both)

All debt paid off by retirement (both)

Go on trips each year when retired ($10,000 per year) (both)

Live in Florida in the winter when retired (both)

Take a year off to write a book (Lyn)

Ongoing Goals

Save for Childrens post-secondary education (both)

Travel to an all-inclusive each year ($3,000) (both)

Continue camping trips with the kids ($2,000) (both)

Ensure no debt remains if one spouse dies and the children are taken care of if

both spouses die (both)

Ensure that the family does not suffer a hardship if Craig is injured and unable to

work (both)

Save for a new vehicle for Lyn

Assumptions Assumptions Relating to the Customer

Rental Property and Family Home will increase in value annually at the rate of inflation

No additional renovations will be required to the rental property

Lyns position at TD is secure and her salary will continue to increase annually at

the rate of inflation

Craigs salary will increase at the rate of inflation (based on his average salary for

the past 3 years)

If one spouse dies all debt will be paid off and expenses will be about 90% of

existing remaining expenses

Current non-fixed expenses will increase each year by the rate of inflation

Both children will complete post-secondary education and will be non-

dependents by the age of 21

Living expenses at retirement will be the same as now (except no debt or dependents, extra travel and no life or disability insurance premiums) all figures indexed for inflation

Lyns pension will be indexed to the inflation rate

No inheritance from Lyns father when he dies

The leveraged investment portfolio did not yield any return as there were no

dividends paid and the stock prices did not grow.

Craig and Lyn will both qualify for the maximum CPP and OAS pension at age 65

Assumptions Relating to the Economy

Pre-tax rate of return on medium risk investments is 7%

Pre-tax rate of return on GICs is 3%

Prime Rate = 3%

Inflation Rate = 2.5%

Canadian Dollar remains at par with the $U.S.

Assumptions Relating to the Government

Income tax rates will remain the same as today

Capital gains will continue to be taxed at 50%

The OAS claw-back range will increase each year by the inflation rate

The OAS and CPP payments will increase each year by the inflation rate

The current deductions allowed for taxes will remain the same in the future

The reduction or increase in CPP for receiving the pension earlier or later than at

age 65 will remain the same as it is today

The government will continue with the RESP subsidy program by depositing a

grant into the RESP equivalent to 20% of the contribution to a maximum of $500.00 per child.

Taxation Management Plan Related Information

Craig always has a problem paying income tax and is looking for ways to avoid the pain associated with filing his income tax every April.

The rental expenses and income are currently being added to Craigs tax return.

Tax returns are provided.

Risk Management Plan Related Information

Lyns father, Don, was diagnosed with Alziehmer's

Lyns benefit package consists of full medical and dental coverage for her and

her family, life insurance totaling 2 times her salary, short term disability for 6 months at full salary (paid for by her employer) and long term disability which she pays for and will provide her 70% of her salary.

Craig does not receive any group benefits or disability insurance from Remax which puts the family at risk should Craig become injured and unable to work.

Lyn does not have critical illness and long term care insurance.

Craigs parents are both deceased. His mother died of cancer when she was 60

and his father had a major stroke at the age of 65 and died a few months later.

Craig and Lyn are hoping that there is a way to make the palliative care process

easier on the family in the event that one or both of them are in this position.

If either Craig or Lyn die they wish the remaining spouse to take over all the

assets and have no debt to deal with.

If Craig and Lyn both live into retirement they are not interested in leaving a

legacy for the children.

Addendum (insurance costing assumptions)

Long-Term Care Insurance: Assume following rates:

Male: $50/month per $100,000 of coverage aggregate max

($8,000/month benefit)

Female $55/month per $100,000 of coverage

Critical Illness Insurance: Assume Following rates: Female (38): $45/month per $50,000 of coverage

Male (34): $45/month per $50,000 of coverage for non-smoker Male (34): $80/month per $50,000 of coverage for smoker

Disability Insurance: Assume Following rates: Assume annual cost/$100 of coverage of $44 for Male Example: $1,000 of monthly benefit would cost $440 per year

Life Insurance: Assume Following rates: Male 34 non-smoker: Assume $146/year per $100k of coverage Male 34 smoker: Assume $255/year per $100k of coverage Female 38 non-smoker: $141/year per $100k of coverage

Assignment Tasks:

1) Basedontheinformationprovidedinthecase,beginfillingintheprovided spreadsheet with the cash inflows and cash outflows the couple will incur into the future. Utilize spreadsheet formulas like inflation into your calculations where necessary.

2) CreateaNetWorthstatementbasedontheinformationprovided

3) Create an assumptions tab in your spreadsheet where you demonstrate the thought and analysis put into each section (i.e. insurance analysis, tax assumptions, etc.). The purpose here is not to challenge your assumptions, but to see the level of thought put into your model.

4) Make sure that you address all the areas of planning we have discussed in the course (to date).

Financial management (savings and debt considerations)

Risk Management (insurance)

Estate Planning (Wills/POAs)

Asset Management (investments and rental properties)

Retirement Planning (pensions, RRIF withdrawals, etc)

Education Planning (RESPs etc.)

Tax management (deductions, employments expenses, RRSP

deductions, etc.).

Debt Management

5) In addressing 4) above use the financial planning process as discussed in class

Overall: Step 1: Engage (assume Letter of Engagement completed) Step 2: Data Gathering (complete provided in case details) --------------------------------------------------------------------------------- For each of the above areas use the following approach Step 3: Analyze and Develop solutions

i. ii.

Assess the Clients Current Situation (create projections/calculations if

necessary)

Determine what they want (goal) or where they should be (e.g. retire at age 65

and cover 70% of pre-retirement expenses; children attend prestigious school)

iii. iv.

Note you can use cash flow projections or time value of money calculations using qualitative reasoning to conduct your analysis for each section.

---------------------------------------------------------------------------------- Step 5: Implement and Step 6: Monitor (ignore for this assignment)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!