70.2K

Verified Solution

Link Copied!

can you calculate for me how a 1% increases in interst rates (Stress test 3) will affect the bonds. please show the calculation through excel function (=formulatext)

Price per Name Expense Ratio Category Portfolio Percentage 5% 7% Vanguard Dividend Growth Vanguard Small-Cap Vanguard Equity-Income Vanguard Selected Value Vanguard Long-Term Inv High Yield Corporate Bond ETF Inv Grade Corporate Bond ETF IShares MBS ETF Vanguard Inflation Protected Securities Saving Account Total Symbol VDIGX VSMAX VEIPX VASVX VWESX HYG LOD MBS AGG Cash Large Cap Stock Small Cap Stock Mid Cap Stock Mid Cap Stock Long Bond Corporate bond Corporate bond Bond Bond Cash 6% 5% 8% 30% 22% 8% Shares 6388 2675 5483 6238 4923 13854 6777 2959 22039 Value share $ 31.31 $ 200,000.00 $ 104.69 $ 280,000.00 $ 43.77 $ 240,000.00 $ 32.06 $ 200,000.00 $ 65.00 $ 320,000.00 $ 86.62 $ 1,200,000.00 $ 129.85$ 880,000.00 S 108.145 320,000.00 $ 14.52 $ 320,000.00 $ 40,000.00 $ 4,000,000.00 0.27% 0.05% 0.28% 0.31% 0.22% 0.49% 0.14% 0.07% 0.04% Total Expense $ 540.00 $ 140.00 $ 672.00 $ 620.00 $ 704.00 $ 5,880.00 $ 1,232.00 $ 224.00 $ 128.00 8X 1% 100% $ 10,140.00 Beta Duration $ NO NO Dividend interest Return Amal Income 0.545 107 2.850 SS 0.99 $ 5,4229 0:36 2,24579 0.75 M0.00 40S 16.107.13 3.40 $ 28.0475 2115 6,241 2.2015 50,43 0.82 0.92 128 1.45 s year Average Retum Inflation Rate Stress Test 1 Amal Dollar Change Stress Test 2 Anual Dollar Change Stress Test Annual Dollar Change 10.96 $ (13,448.00 -16% (26,896.00 8.895 9$ 03.09.2011 18 147,393.40) 10.25% 1355 (19.121.60 (78.643.2011 OX 6.30N 1945 12.000 2015 184,100.00 0 513 OS ONS 6. OXS 5035 2.4 Ons 05 1.115 OXS OS 0.14 SE VS 17 SINO SKO NE NE ME SO 0.52 172 0.45 2 125 19 1% 1% $ 143,531 26 Weight Average Return: KEY KOST $ 113,513 Bill (237,037.00 Name Symbol Category Portfolio Percentage Vanguard Dividend Growth Vanguard Small-Cap Vanguard Equity-Income Vanguard Selected Value Vanguard Long-Term Inv High Yield Corporate Bond ETF Inv Grade Corporate Bond ETF iShares MBS ETF Vanguard Inflation-Protected Securities Saving Account Total VDIGX VSMAX VEIPX VASVX VWESX HYG LOD MBB AGG Cash Large Cap Stock Small Cap Stock Mid Cap Stock Mid Cap Stock Long Bond Corporate bond Corporate bond Bond Bond Cash 5% 7% 6% 5% 8% 30% 22% 8% 8% 1% 100% Price per Expense Ratio Value share Shares 6388 2675 5483 6238 4923 13854 6777 2959 22039 $ $ $ $ $ $ $ $ $ 31.31 $ 200,000.00 104.69 $ 280,000.00 43.77 $ 240,000.00 32.06 $ 200,000.00 65.00 $ 320,000.00 86.62 $ 1,200,000.00 129.85$ 880,000.00 108.14 $ 320,000.00 14.52 $ 320,000.00 $ 40,000.00 $ 4,000,000.00 0.27% 0.05% 0.28% 0.31% 0.22% 0.49% 0.14% 0.07% 0.04% Total Expense $ 540.00 $ 140.00 $ 672.00 $ 620.00 $ 704.00 $ 5,880.00 $ 1,232.00 $ 224.00 $ 128.00 $ 10,140.00 Beta Duration 5 year Average Return Inflation Rate Dividend/Interest Return Annual Income $ 0.54 $ 3,442.99 $ 1.07 $ 2,850.55 $ 0.99 $ 5,423.99 $ 0.36 $ 2,245.79 $ 0.78$ 3,840.00 $ 4.05 $ 56,107.13 $ 3.40 $ 23,048.75 $ 2.11 $ 6,243.76 $ 2.29 $ 50,468.32 0.82 0.92 1.28 1.45 0.14 0.52 1.77 0.45 1 15 5.8 8.3 3.25 5.9 10.96% 8.89% 10.25% 6.36% 5.12% 6.13% 5.03% 2.44% 3.12% $ 143,531.28 Weight Average Return: 6.48% 1.50% 0% Stress Test 1 Annual Dollar Change Stress Test 2 Annual Dollar Change Stress Test 3 Annual Dollar Change -8% $ (13,448.00) -16% $ (26,896.00) 0% -9%$ (23,699.20) -18% $ (47,398.40) -13% $ (39,321.60) -26% $ (78,643.20) 0% -15% $ (42,050.00) -29% $ (84,100.00) 0% 0% $ 0% $ 1% 0% $ 0% $ 1% 0% $ 0% $ 1% 0% $ 0% $ 1% 0% $ 0% $ 1% $ $ (118,518.80) $ (237,037.60)

Answer & Explanation Solved by verified expert

See Answer