Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

CFP 102 Case Study/ assignment Written assessment designed to evaluate communication skills. Worth 20% of your final grade. Delivery details: Deliverable no later than 5:00 PM EST 3 December 2021...

1 answer below »

CFP 102 Case Study/ assignment
Written assessment designed to evaluate communication skills.
Worth 20% of your final grade.
Delivery details:
Deliverable no later than 5:00 PM EST 3 December 2021
Email to XXXXXXXXXX
Your assignment must be completed and sent in a Word file (I will decline pdfs, jpegs and other files). I will not download files from the ‘cloud.’ You may also provide supporting documentation with EXCEL if you wish.
Your document must be written in size 12 Arial font and the file name must be formatted as:
Last name_first name_cfp102_case study
The purpose of this assignment:
It is designed to help you learn how to communicate clearly through written language. You are tasked with developing a financial plan for hypothetical clients. Fair warning: I would not leave this assignment until the last minute, and/or do the very least amount of effort possible because that will annoy me.
Follow the guidance I provide below on how to build your case.
Requirements:
1) Appropriate cove
title page
2) Review of the facts (name the clients, their goals and objectives, and the purpose of your report)
3) Create a financial analysis of their situation: how much are they spending and where? Graph it.
4) How much can they save (reasonably) and how should they save it?
5) How do their investments grow over time?
6) You will then make a recommendation to the prospective clients. This recommendation should be logical and reasonable, employing facts to substantiate your position. Specifically you will tell them what to do and when they should do it. You will fail this case study if you do not do this step.
7) Show them the payout progression over time
8) At all times keep written language appropriate and professional.
Helpful notes:
The importance here is to teach you to make convincingly strong arguments in a professional environment. You should complete the case well before the deliverable date and ask someone to review your work. Get a critical analysis of your work and see how you can improve it. It is recommended that non-native English speakers/writers particularly check their work, noting that in Canada we follow British spelling practices.
Assignment facts
A couple comes to you asking for financial advice and a plan for securing their retirement. They specifically want to know what their retirement might look like and whether they are saving enough.
Make a financial plan for them given the following information.
Ages: Spouse 1 is aged 32 and Spouse 2 is aged 30.
Annual income : $ XXXXXXXXXXcombined, spouse 1 earning $60 000 and spouse 2 earning $ XXXXXXXXXXIncomes increase 10% for each spouse every 5 years.
Cu
ent savings:
$25 000 in RRSPs
$42 000 in TFSAs
$30 000 in non registered funds
Available registered savings room:
Spouse 1 has $27 000 of available RRSP contribution room
Spouse 2 has $34 000 of available RRSP contribution room
Figure out their TFSA room…..
Spending
85% is non discretionary spending
15% is discretionary
· Of that 15% a full half is spent on travel and entertainment
· 30% is spent on frivolous spending (gifts, etc)
· The other 20% is not traced
What you want to do to succeed
You have to establish reasonable rates of return – what will that be?
Figure out a time line – when do they retire, what do they get for CPP and/or OAS and GIS
What age do you have them retire, and why?
What might a life expectancy look like, and why do you choose that life span?
Build this into a full presentation: this is about communicating your ideas (what it says directly above). So I have no problem showing how to solve, because the issue is about communicating the solution.
Here is what you do step by step:
1. You want to write a cover page
2. Review of Facts
a. Couple
. State income and other given facts
c. State RRSP/TFSA space – you have to figure the TFSA space available so
y I didn’t do it for you boo hoo
d. What is their spending like – I abstracted it this time, which is fine
What you will have to do is target that “lost” money that we don’t really know about – frankly, this is closer to real life in the sense few actually know how every dollar is spent
We will draw our savings on that unknown spending area
3. State our assumptions now. Look, you have no idea how long real people will live, and you will have no idea on what rates of return to expect. So I did not give them to you. Lets make this closer to reality
So do not panic. Lets establish assumed length of life – what source of information might I use? Where would I get it?
Where do I get reasonable rates of return – what source of information might I draw upon ?
When might they retire? What ages might you suggest and why, and what reference might you use?
Think about this for a second…. How would you feel IF you came to me as this couple, and I provided a plan made on ru
ish, ga
age data ?
Specifically, we will create a baseline, and then a lower estimate and then a higher estimate as it respects
· Living
· Accumulation
· Spending
Why? Well yes we are actually doing a great deal of work, but we are demonstrating our ability to PLAN financially
4. So now lets begin our accumulation calculations. Specifically, we will run an assumed savings rate of YOUR CHOICE that is based on the number above. Let us just say of that untraced money 9% (because not one of you wants to use 9% it’s a silly number) will we allocate to annual savings
5. Now, we run an accumulation schedule at that rate of savings, using an estimated rate of return established above. That is our baseline. You then run the accumulation schedule two more times, one lower and one higher than the baseline rate. Don’t use wacky numbers like 76% rates of return….keep it reasonable.
6. Ok, now add the effect of cu
ent savings… using similar rates of return. Maybe that non registered account could be flipped over to a registered account… if so, what is the effect ? There will be a tax consequence, and also a possible tax benefit…
7. Ok, now will be calculate how much they actually accumulate based on existing savings and new savings
8. Show this in a graph. Make a big presentation showing how they escalate savings over time
9. Ok, now we retire them. What is their spending rate, do you think ? Now here we will abstract a bit… and again, we have to use some judgement…. Do we want to factor CPP and OAS? Should we do that?
10. Now generate a payout schedule, and create a baseline as well as a lower and higher range.
11. Wrap up a conclusion: the conclusion is that you, Joe financial planner, can help them meet their retirement goals as they mature and evolve. You do not know exactly what those goals and dreams are yet…, they might very well change…. But you show you are the one they should work with
12. Again, I am less concerned with the math and am more interested in how you effectively communicate to the prospective clients that you are the one! That is the goal.
So if you have problems with communications, particularly in English, then probably you want others to offer input into your work… constructive criticism is our friend

accumulation math
    the first thing is to set up the spreadsheet and see what we get in terms of their incomes, because we need to calculate the discretionary and non discretionary spending
    we also need this to determine their annual savings, and establish a rate of return NOTE we will use numbers drawn from a source of information
    So what does that mean? Well, use something with a proof behind it- a justification
        spouse 1    spouse 2    spouse 1    spouse 2    spouse 1    spouse 2    total annual    savings    total    5% return    end of yea
    year    age     age    income    income    contribution    contribution    contribution    (prev year)    savings    on savings    total savings
    1    32    30    $ 60,000.00    $ 80,000.00            $ - 0    0    $ - 0    $ - 0    $ - 0
    2    33    31    $ 60,000.00    $ 80,000.00            $ - 0    $ - 0    $ - 0    $ - 0    $ - 0
    3    34    32    $ 60,000.00    $ 80,000.00            $ - 0    $ - 0    $ - 0    $ - 0    $ - 0
    4    35    33    $ 60,000.00    $ 80,000.00            $ - 0    $ - 0    $ - 0    $ - 0    $ - 0
    5    36    34    $ 60,000.00    $ 80,000.00            $ - 0    $ - 0    $ - 0    $ - 0    $ - 0
    6    37    35    $ 66,000.00    $ 88,000.00            $ - 0    $ - 0    $ - 0    $ - 0    $ - 0
    7    38    36    $ 66,000.00    $ 88,000.00            $ - 0    $ - 0    $ - 0    $ - 0    $ - 0
    8    39    37    $ 66,000.00    $ 88,000.00            $ - 0    $ - 0    $ - 0    $ - 0    $ - 0
    9    40    38    $ 66,000.00    $ 88,000.00            $ - 0    $ - 0    $ - 0    $ - 0    $ - 0
    10    41    39    $ 66,000.00    $ 88,000.00            $ - 0    $ - 0    $ - 0    $ - 0    $ - 0
    11    42    40    $ 72,600.00    $ 96,800.00            $ - 0    $ - 0    $ - 0    $ - 0    $ - 0
    12    43    41    $ 72,600.00    $ 96,800.00            $ - 0    $ - 0    $ - 0    $ - 0    $ - 0
    13    44    42    $ 72,600.00    $ 96,800.00            $ - 0    $ - 0    $ - 0    $ - 0    $ - 0
    14    45    43    $ 72,600.00    $ 96,800.00            $ - 0    $ - 0    $ - 0    $ - 0    $ - 0
    15    46    44    $ 72,600.00    $ 96,800.00            $ - 0    $ - 0    $ - 0    $ - 0    $ - 0
    16    47    45    $ 79,860.00    $ 101,640.00            $ - 0    $ - 0    $
Answered 1 days After Dec 02, 2021

Solution

Neha answered on Dec 03 2021
124 Votes
Sheet1
accumulation math
    the first thing is to set up the spreadsheet and see what we get in terms of their incomes, because we need to calculate the discretionary and non discretionary spending
    we also need this to determine their annual savings, and establish a rate of return NOTE we will use numbers drawn from a source of information
    So what does that mean? Well, use something with a proof behind it- a justification
    Out of there annal income, they are ale to contibute an amunt towards their spending and saving. By finding out the amont they contribute annually to the sving, we can establish the amount hey will require and the rate at which they are able to generate return of their income.
        spouse 1    spouse 2    spouse 1    spouse 2    spouse 1    spouse 2    total annual    savings    total    5% return    end of yea
    year    age     age    income    income    contribution    contribution    contribution    (prev year)    savings    on savings    total savings
    1    32    30    $ 60,000.00    $ 80,000.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    0    $ 61,000.00    $ 3,050.00    $ 64,050.00
    2    33    31    $ 60,000.00    $ 80,000.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 64,050.00    $ 125,050.00    $ 6,252.50    $ 131,302.50
    3    34    32    $ 60,000.00    $ 80,000.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 131,302.50    $ 192,302.50    $ 9,615.13    $ 201,917.63
    4    35    33    $ 60,000.00    $ 80,000.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 201,917.63    $ 262,917.63    $ 13,145.88    $ 276,063.51
    5    36    34    $ 60,000.00    $ 80,000.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 276,063.51    $ 337,063.51    $ 16,853.18    $ 353,916.68
    6    37    35    $ 66,000.00    $ 88,000.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 353,916.68    $ 414,916.68    $ 20,745.83    $ 435,662.52
    7    38    36    $ 66,000.00    $ 88,000.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 435,662.52    $ 496,662.52    $ 24,833.13    $ 521,495.64
    8    39    37    $ 66,000.00    $ 88,000.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 521,495.64    $ 582,495.64    $ 29,124.78    $ 611,620.42
    9    40    38    $ 66,000.00    $ 88,000.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 611,620.42    $ 672,620.42    $ 33,631.02    $ 706,251.44
    10    41    39    $ 66,000.00    $ 88,000.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 706,251.44    $ 767,251.44    $ 38,362.57    $ 805,614.02
    11    42    40    $ 72,600.00    $ 96,800.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 805,614.02    $ 866,614.02    $ 43,330.70    $ 909,944.72
    12    43    41    $ 72,600.00    $ 96,800.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 909,944.72    $ 970,944.72    $ 48,547.24    $ 1,019,491.95
    13    44    42    $ 72,600.00    $ 96,800.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 1,019,491.95    $ 1,080,491.95    $ 54,024.60    $ 1,134,516.55
    14    45    43    $ 72,600.00    $ 96,800.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 1,134,516.55    $ 1,195,516.55    $ 59,775.83    $ 1,255,292.38
    15    46    44    $ 72,600.00    $ 96,800.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 1,255,292.38    $ 1,316,292.38    $ 65,814.62    $ 1,382,107.00
    16    47    45    $ 79,860.00    $ 101,640.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 1,382,107.00    $ 1,443,107.00    $ 72,155.35    $ 1,515,262.35
    17    48    46    $ 79,860.00    $ 101,640.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 1,515,262.35    $ 1,576,262.35    $ 78,813.12    $ 1,655,075.47
    18    49    47    $ 79,860.00    $ 101,640.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 1,655,075.47    $ 1,716,075.47    $ 85,803.77    $ 1,801,879.24
    19    50    48    $ 79,860.00    $ 101,640.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 1,801,879.24    $ 1,862,879.24    $ 93,143.96    $ 1,956,023.20
    20    51    49    $ 79,860.00    $ 101,640.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 1,956,023.20    $ 2,017,023.20    $ 100,851.16    $ 2,117,874.36
    21    52    50    $ 87,846.00    $ 106,722.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 2,117,874.36    $ 2,178,874.36    $ 108,943.72    $ 2,287,818.08
    22    53    51    $ 87,846.00    $ 106,722.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 2,287,818.08    $ 2,348,818.08    $ 117,440.90    $ 2,466,258.98
    23    54    52    $ 87,846.00    $ 106,722.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 2,466,258.98    $ 2,527,258.98    $ 126,362.95    $ 2,653,621.93
    24    55    53    $ 87,846.00    $ 106,722.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 2,653,621.93    $ 2,714,621.93    $ 135,731.10    $ 2,850,353.03
    25    56    54    $ 87,846.00    $ 106,722.00    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 2,850,353.03    $ 2,911,353.03    $ 145,567.65    $ 3,056,920.68
    26    57    55    $ 92,238.30    $ 112,058.10    $ 27,000.00    $ 34,000.00    $ 61,000.00    $ 3,056,920.68    $ 3,117,920.68    $ 155,896.03    $ 3,273,816.71
    27    58    56    $ 92,238.30    $ ...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here