金融案例分析大赛作品

$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%
wk.baidu.com
U.S. high yield bond 6% Canadian money market 0% U.S. euity 14%
International euity 14%
Canadian money market 27%
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%
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%
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
$50,000.0 0
Previous Budget
$250,000. 00
$250,000. 00
Previous Budget RRSP
NO TAX FOR YOUR FIRST HOME
Risk-free Rate
Saving Goal Rate of Return
$25,000 5.91%
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%
Ending Balance $ $ $ $ $ $ $ $ $ $ $ $ $ $ 6,012.60 17,395.65 31,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 93,388.23 66,998.19
Annual Reate of Contribution Retun 9.09% $ 9.09% $ 9,900.00 9.09% $ 11,700.00 9.09% $ 1,141.00
$ $ $ $
Ending Balance 6,012.60 17,395.65 31,807.37 8,689.16
retirement
• Children’s 30-50 Education
RESP Yearly Saving Gov’s contribution 2,902.50 580.50
Saving account 3,483.00 0.00
Total
180,000.00
180,000.00
• 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
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
US Equity
ETFs
US high yield Bond CAD Bond Internatio nal Equity
• Home Down 21-22 Payment 23-32 • Rising for Family
retirement
• Children’s 30-50 Education
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 years
$984.00
N=2×12
$30,000.00 $25,000.00
$20,000.00 $15,000.00
$10,000.00 $5,000.00 Interest Principal
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%
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 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%
$ $ $ $ $ $ $
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
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
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
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
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%
$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
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
$ $ $ $ $ $ $
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