Every year, you are investing $$1,000$ in Government Bonds, $$1,000$ in Corporate

Bonds, and $$3,000$ in common stock, creating a balanced diversified portfolio.

In this problem, use the FV function in cells D$11$: F$13,$ to compute the value of each investment after $10,20,$&$30$ years.

In cells B$14,$ D$14,$ E$14,$ & F$14,$ use the Sum function to total the values above.

ALL of the $13$ shaded cells should be filled in$.$

$\backslash$table$[[,,$Investment,Value after,Value after,Value after$],[,$Annual $$,$Return,$10$ years,$20$ years,$30$ years$],[$Govt Bonds,$1,000\mathrm{.}00,2\mathrm{.}00\%,,,],[$Corporate Bonds,$1,000\mathrm{.}00,3\mathrm{.}50\%,,,],[$Common Stocks,$3,000\mathrm{.}00,8\mathrm{.}00\%,,,],[$Total$,,,,,]]$