Financial Planning for A Family Case Study Project Finance project. I need a finance expert. All questions should be answered and work shown. No plagiarism | Course Hero

Financial Planning for A Family Case Study Project Finance project. I need a finance expert. All questions should be answered and work shown. No plagiarism no grammar issuesThis is a very important assignment an I need good marks on this paper. Kindly do not bid before going through the assignments. Quality should be assured. Be keen on the instructions. PERSONAL FINANCIAL PLANNING
Weight: 15%
Marks: 50
Case Study #1: Financial Planning for a Family
Instructions
Using the information provided in the case study that begins on the next page, answer
the questions at the end of the case study.
Be sure to clearly indicate the question numbers within your submission (e.g., 1a, 2c, etc.). Do
as much in point form as possible to make it easier to read. You are expected to proofread your
submission for accuracy in grammar and spelling and marks are deducted for errors.
While completing this case study, participate in Case Study #1 Discussion in the Brightspace
Discussions area. You can share your ideas with other students in this class, but you must
submit your own assignment and work to avoid any plagiarism. Be sure to reference any outside
sources you use – see the Getting Started > Academic Honesty and Citing Sources page in
the Content area.
Note: If you choose to use Microsoft Excel to create the net worth statement and cash flow
statement, submit your assignment as a .zip file containing all of your case study files.
Submit your answers to the case study questions as a Word document to the Brightspace
Assignments area. If you have questions regarding the assignment, please contact the
instructor.
1
School of Business
© 2016, Southern Alberta Institute of Technology
PERSONAL FINANCIAL PLANNING
Case Study
Marta and Marcel, a couple in their early-forties, recently purchased a house in the suburbs of
Calgary, Alberta. The purchase price of $440,000 was a little more than they had anticipated,
but with their growing children, they felt they needed to finally move from their apartment.
Marcel works as a sales manager for a telecommunications company in northeast Calgary.
Marta works part-time as an accountant in downtown Calgary and is just getting back into the
workforce now that her children are both attending school. Colton is eight and Ashley is six.
Marta is working casual and contract positions until a full-time position comes available, thus her
present income is somewhat uncertain and irregular.
The couple placed a down payment of $200,000 on the new house, which were from years of
saving topped up with a gift from Marta’s parents. They carry a mortgage of $240,000, with a
five year term and a rate of 5.5%. The mortgage will be paid off over 25 years, which is longer
than they had intended. The payments are $1335 per month. Their new house also needed
blinds and some new furniture, which they financed with a personal loan of $4,000 over two
years at 8.5%, with payments of $182 a month. The couple also recently purchased a newer
van valued at $16,500 with financing of $12,000 over four years at 6.5%. The payments on this
loan are $285 a month.
They have $2,500 in Canada Savings Bonds, $500 in a savings account, and $750 in their joint
chequing account. Last year, they received $72 in interest on the Canada Savings Bonds.
Marcel has $4,500 in a mutual fund RRSP – money transferred from a non-vested pension plan
from the last company he worked for. He has an RRSP invested in a term deposit now worth
$3,000, which was purchased before they were married. They have named each other as
beneficiaries on their RRSPs.
When they were married, Marta and Marcel both purchased $100,000 whole life insurance
policies that now have a cash surrender value of $2,000 each. They are named as each other’s
beneficiaries.
They have no will.
The couple relies on a line of credit from their bank for emergencies. It has a limit of $15,000
and is currently at a zero balance. At present, they owe $1,300 on a Visa credit card (interest
rate of 18.5%, minimum payment of $65 a month) and $1,000 on a MasterCard (interest rate of
19%, minimum payment of $50 a month). Both cards have credit limits of $5,000. They use
these credit cards to cover spending in the months when the paycheque just does not cover
everything.
None of this debt carries life insurance or disability insurance other than the mortgage, which is
life insured for both of them.
They have little flexibility should Marcel be off work for any length of time due to an illness or
injury. He does have disability insurance coverage at work that pays 50% of his usual wages,
tax free, should he become disabled for longer than three months. During the three month
waiting period, he would collect a small Employment Insurance benefit and approximately two
weeks of sick pay.
2
School of Business
© 2016, Southern Alberta Institute of Technology
PERSONAL FINANCIAL PLANNING
Marcel’s benefits at work include the use of a leased car and an expense account for
entertaining clients. He has a comprehensive dental, drug, and vision care plan as well as a
group life insurance policy equaling two times his salary. The company does not have a pension
plan but does offer a group RSP, matching each dollar contributed by the employee (up to 5%
of their salary). Marcel doesn’t feel they have the extra funds right now, so does not currently
participate in this plan even though he knows that he is passing up on a substantial contribution
by the company by not doing so.
Marta does not have any benefits at work, as she is only part-time.
Marta and Marcel would like to start renovating the basement of their new home but doubt they
can do this until Marta gets a full-time teaching position.
The couple rarely takes vacations other than going to Marcel’s parent’s cabin in British
Columbia at a cost of $1,200 each year. They would really like to go to Disneyland next year
and figure the trip will cost about $4,000 for all four of them combined.
From their view, the only extravagance in their spending is the $2,400 it costs each year to keep
the kids in hockey, ballet, and other sports.
It seems to Marcel that, with his income of $50,000 a year plus regular commissions of $15,000,
they should not be having the money worries they are currently experiencing – but he knows
something is not quite right with their financial situation. Before the children were born, the
couple spent money quite freely, but with no established management pattern, money now just
seems to disappear.
They still do not really keep track of their finances or spending – they rarely balance their
cheque book and throw all their bills and financial papers on a desk in the den. Many months,
they do run out of money in their account before all the bills are paid. They tend to keep their
fears and concerns to themselves, rarely communicating their anxieties with each other.
Below is a list of monthly net income and expenses that are not already mentioned above. The
income figures are net of deductions at source such as income tax, EI, and CPP and, in
Marcel’s case, include his commissions.
Income
Marcel’s monthly take home pay
Marta’s average monthly net income
CSB interest per year
Other expenses are provided on the next page.
3
School of Business
© 2016, Southern Alberta Institute of Technology
$4,050.00
700.00
72.00
PERSONAL FINANCIAL PLANNING
Other Expenses
Heating
Electricity and water
Home telephone
Home insurance
Property taxes
Food and groceries
Entertainment
Clothes
Babysitter
Netflix, Apple music, subscriptions
Gifts
Life insurance
Transportation (insurance/gas/maint)
Cell phone
Misc
Questions
$120.00
165.00
35.00
55.00
200.00
750.00
175.00
200.00
80.00
38.00
150.00
86.00
425.00
110.00
300.00
(be sure to number each section):
1. Prepare a net worth statement for this couple using a similar format to the one on page 52 in
Chapter 2 in the textbook or in the Personal Finance Planner document on the textbook
companion website. (5 marks)
2. Prepare a monthly cash flow statement for this couple, noting which expenditures are fixed
and which are flexible (variable), similar to the one on page 54 in Chapter 2 in the textbook.
What is this couple’s total cash surplus or deficit for an average month? (5 marks)
3. Identify the stated and implicit financial goals for this family and sort them into short,
medium and long-term. Stated goals are the ones that are obvious from the case; implicit
goals are ones you as a financial planner will tell the couple to consider. (10 marks)
4. What future difficulties do you foresee for this family if they continue on their current financial
path? What do you think are the underlying problems/issues causing this financial situation?
(10 marks)
5. Thinking of the deficit you identified in Question 2, what are the various range of options this
couple could consider to eliminate it? Try, where possible, to quantify your suggestions to
demonstrate their effect on the deficit you’ve identified. (10 marks)
6. This couple has come to see you (a financial planner). Outline the approach you would take
with this couple to help them to improve their overall financial situation, get things back on
track and stay on track. This may include relevant steps in a financial plan, setting goals
and budgets, or other areas you will discuss with them to consider. (10 marks)
4
School of Business
© 2016, Southern Alberta Institute of Technology

Purchase answer to see full
attachment