金融案例分析大赛作品
JOURNEYMAN JOURNEYMAN
Home Down Payment
Rising for Family
Children’s Education
Retirement
Assets
Cash
TFSA
Liabilities
$2,000
$5,000 NONE 0
RRSP
Savings account 2007 Nissan 370z Total
CND money market
3.60% 1.70% 2.10% 1.40% 1.80% 3.10% 3.80% 2.80% 0.20% 0.20%
US Equity Initial Value Time Frame Final Value R(compound ed rate of return) Weight(2010 -2029) Weighted rate of return Weight(2030 -2049) Weighted rate of return Weight(2049 +) Weighted rate of return $5.88
Terms of Saving
Monthly Saving
FV=25,000 PMT= -983.88 I =5.91%/12 PV=0
2 ×12
$30,000.00 $25,000.00
$20,000.00 $15,000.00
$10,000.00 $5,000.00 Interest Principal
US high yield bond 43.20% 28.90% 23.30% 4.90% 14.10% 13.00% 17.60% 18.00% -2.40% -1.90% 12.40% 2.00% 4.70% 3.80% -0.30% 11.50% -12.90% -7.70% 31.00% 8.50%
Reate of Retun 9.09% 9.09% 9.09% 9.09% 9.09% 9.09% 9.09% 9.09% 9.09% 9.09% 9.09% 9.09% 9.09% 9.09%
$ $ $ $ $ $ $
21-EXP 55,000.00 18,691.00 36,309.00 5,281.00 17,088.00 31,028.00 19,221.00
$ $ $ $ $ $ $
22 65,000.00 27,348.00 37,652.00 6,000.00 17,807.00 31,652.00 19,845.00
$0.00
Now 1 2
• Home Down 21-22 Payment 23-32 • Rising for Family
retirement
• Children’s 30-50 Education
RRSP
TFSA
SA
$200,000
• Home Down 21-22 Payment 23-32 • Rising for Family
Annual Contribution $ $ 9,900.00 $ 11,700.00 $ 1,141.00 $ 1,141.00 $ 1,141.00 $ 5,641.00 $ 5,641.00 $ 5,641.00 $ 5,641.00 $ 5,641.00 $ 11,041.00 $ 11,041.00 $ 11,041.00
CND Equity
CND Bond
International US high yield CND money Equity bond market $1
20 years $1(1+R1991)(1+R1992)……(1+R2009)(1+R2010) $6.89 $5.00 $3.65 $6.47 $1.23 Initial value*(1+R)20=Final Value 9.26% 15.00% 10.14% 55.00% 8.38% 8.00% 9.32% 6.69% 15.00% 9.79% 7.00% 2.06% 0.00%
14%
42%
24%
9.09%
14%
6%
0%
10%
19%
29% 7.09%
10%
6%
27%
Gross Pay Total Deductions Net Take Home Income Total Expenses TotalRemaining Net Expenses Net Remaining
$ $ $ $ $ $ $
Home Down Payment
Down payment Annual Contribution $ 11,807.00 $ 11,807.00 $ 11,807.00 $ 11,807.00
Year Current 21 22 23 $ $ $ $
Beginning Balance 5,500.00 6,012.60 17,395.65 6,807.37
21-MIN 45,000.00 14,898.00 30,102.00 4,378.00 16,185.00 25,724.00 13,917.00
21-MAX $ 80,000.00 $ 29,936.00 $ 50,064.00 $ 7,282.00 $ 19,089.00 $ 42,782.00 $ 30,975.00
Year Current 21 22 23 24 25 26 27 28 29 30 31 32 33 $ $ $ $ $ $ $ $ $ $ $ $ $ $
Beginning Balance 5,500.00 6,012.60 17,395.65 6,807.37 8,689.16 10,746.33 12,995.23 20,373.12 28,438.64 37,255.86 46,894.85 57,311.36 74,565.59 50,374.52
Canadian equity 19% U.S. euity 10% International euity 10%
Canadian bond 28%
U.S. high yield bond 6%
US Equity
1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 37.65% 24.85% 18.65% 5.65% 29.35% 20.35% 33.50% 21.30% 14.50% -2.75% 1.25% -22.10% 12.90% 6.25% 2.10% 16.65% -13.50% -19.20% 7.70% 14.65%
retirement
• Children’s 30-50 Education
Saving Goal Rate of Return Terms of Saving Monthly Saving
$1,500,000 5.91% 38 years $880.00
FV=1,5000,000 PMT= -879.88
Annual Contribution $ $ 9,900.00 $ 11,700.00 $ 1,141.00 $ 1,141.00 $ 1,141.00 $ 5,641.00 $ 5,641.00 $ 5,641.00 $ 5,641.00 $ 5,641.00 $ 11,041.00 $ 11,041.00 $ 11,041.00
25,000 in the Ending of Year of 22 (31,807.37 – 6,807.37)
Year Current 21 22 23 24 25 26 27 28 29 30 31 32 33 $ $ $ $ $ $ $ $ $ $ $ $ $ $
Beginning Balance 5,500.00 6,012.60 17,395.65 6,807.37 8,689.16 10,746.33 12,995.23 20,373.12 28,438.64 37,255.86 46,894.85 57,311.36 74,565.59 50,374.52
$5,500
$7,000 $25,000 $44,500 Total 0
21-25
26-30
31-35
36-40
41-45
46-50
51-55
$65,000
$90,000
$120,000
$160,000
$200,000
$250,000
$350,000+
CAD Equity CAD money market
I =5.91%/12
PV=0
N=38×12
Canadian bond 24%
Canadian equity 42%
U.S. high yield bond 6% Canadian money market 0% U.S. euity 14%
International euity 14%
Canadian money market 27%
CND Equity 11.80% 4.15% 40.40% -14.30% 14.20% 28.50% 11.00% -9.75% 26.00% 7.35% -4.60% -6.65% 34.70% 14.30% 21.90% 16.95% 5.90% -39.80% 55.10% 28.05%
Internatio CND Bond nal Equity 22.10% 9.80% 18.10% -4.30% 20.70% 12.30% 9.60% 9.20% -0.10% 10.20% 8.10% 8.70% 6.70% 7.10% 6.50% 4.10% 3.70% 6.40% 5.40% 6.70% 18.50% 4.80% 28.40% 11.90% 18.00% 14.60% 21.30% 33.90% 18.40% -9.90% -11.30% -20.40% 9.40% 6.90% 7.30% 20.20% -7.10% -25.40% 11.10% 6.50%